Re: Copy command Faster than original select

thanks,

but isn't copy use the same plan ???

any way this is the query play

"Sort  (cost=15402.76..15511.77 rows=43602 width=184)"
"  Output: "Sessions"."SesUser", "Vouchers"."VouID",
"Journals"."JurMuniment", "Journals"."JurRefID", "Journals"."JurDate",
"Vouchers"."VouJournal", "Vouchers"."VouMunNumber", "Vouchers"."VouDate",
"Vouchers"."VouNote", "Vouchers"."VouDoc", "Journals"."JurM (...)"
"  Sort Key: "VouItems"."ItmDate", "Vouchers"."VouID",
"VouItems"."ItmNumber""
"  ->  Hash Join  (cost=4665.21..8164.77 rows=43602 width=184)"
"        Output: "Sessions"."SesUser", "Vouchers"."VouID",
"Journals"."JurMuniment", "Journals"."JurRefID", "Journals"."JurDate",
"Vouchers"."VouJournal", "Vouchers"."VouMunNumber", "Vouchers"."VouDate",
"Vouchers"."VouNote", "Vouchers"."VouDoc", "Journals" (...)"
"        Hash Cond: ("VouItems"."ItmMaster" = "Vouchers"."VouID")"
"        ->  Seq Scan on public."VouItems"  (cost=0.00..1103.02 rows=43602
width=89)"
"              Output: "VouItems"."ItmMaster", "VouItems"."ItmNumber",
"VouItems"."ItmCurDebit", "VouItems"."ItmCurCredit",
"VouItems"."ItmAccount", "VouItems"."ItmBranch", "VouItems"."ItmSubAccount",
"VouItems"."ItmMuniment", "VouItems"."ItmDate", "VouItem (...)"
"        ->  Hash  (cost=4107.41..4107.41 rows=20544 width=95)"
"              Output: "Vouchers"."VouID", "Vouchers"."VouJournal",
"Vouchers"."VouMunNumber", "Vouchers"."VouDate", "Vouchers"."VouNote",
"Vouchers"."VouDoc", "Vouchers"."VouIsHold", "Vouchers"."VouCreateDate",
"Vouchers"."VouDebit", "Vouchers"."VouCredit" (...)"
"              ->  Hash Join  (cost=1793.25..4107.41 rows=20544 width=95)"
"                    Output: "Vouchers"."VouID", "Vouchers"."VouJournal",
"Vouchers"."VouMunNumber", "Vouchers"."VouDate", "Vouchers"."VouNote",
"Vouchers"."VouDoc", "Vouchers"."VouIsHold", "Vouchers"."VouCreateDate",
"Vouchers"."VouDebit", "Vouchers"."VouC (...)"
"                    Hash Cond: ("Vouchers"."VouJournal" =
"Journals"."JurID")"
"                    ->  Hash Join  (cost=1236.16..3165.12 rows=20544
width=74)"
"                          Output: "Vouchers"."VouID",
"Vouchers"."VouJournal", "Vouchers"."VouMunNumber", "Vouchers"."VouDate",
"Vouchers"."VouNote", "Vouchers"."VouDoc", "Vouchers"."VouIsHold",
"Vouchers"."VouCreateDate", "Vouchers"."VouDebit", "Vouchers" (...)"
"                          Hash Cond: ("Vouchers"."VouSession" =
"Sessions"."SesID")"
"                          ->  Seq Scan on public."Vouchers"
(cost=0.00..883.44 rows=20544 width=78)"
"                                Output: "Vouchers"."VouID",
"Vouchers"."VouJournal", "Vouchers"."VouMunNumber", "Vouchers"."VouDate",
"Vouchers"."VouNote", "Vouchers"."VouDoc", "Vouchers"."VouIsHold",
"Vouchers"."VouCreateDate", "Vouchers"."VouDebit", "Vou (...)"
"                          ->  Hash  (cost=654.85..654.85 rows=33385
width=12)"
"                                Output: "Sessions"."SesUser",
"Sessions"."SesID""
"                                ->  Seq Scan on public."Sessions"
(cost=0.00..654.85 rows=33385 width=12)"
"                                      Output: "Sessions"."SesUser",
"Sessions"."SesID""
"                    ->  Hash  (cost=417.04..417.04 rows=11204 width=29)"
"                          Output: "Journals"."JurMuniment",
"Journals"."JurRefID", "Journals"."JurDate", "Journals"."JurMunNumber",
"Journals"."JurID""
"                          ->  Seq Scan on public."Journals"
(cost=0.00..417.04 rows=11204 width=29)"
"                                Output: "Journals"."JurMuniment",
"Journals"."JurRefID", "Journals"."JurDate", "Journals"."JurMunNumber",
"Journals"."JurID""




--
View this message in context: http://postgresql.nabble.com/Copy-command-Faster-than-original-select-tp5836886p5836890.html

Sent from the PostgreSQL - performance mailing list archive at Nabble.com.


--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance