Postgres Pro
Downloads
Home   >   mailing lists

Re: Copy command Faster than original select - Mailing list pgsql-performance

From Pavel Stehule
Subject Re: Copy command Faster than original select
Date
Msg-id CAFj8pRCjpih-swz_Ac-QC7FnEC0kNqcZCUcJdFUqokVDPrqxrw@mail.gmail.com
Whole thread Raw
In response to Re: Copy command Faster than original select  (Belal Al-Hamed <belalhamed@gmail.com>)
Responses Re: Copy command Faster than original select
List pgsql-performance
Tree view


2015-02-06 9:44 GMT+01:00 Belal Al-Hamed <belalhamed@gmail.com>:
thanks,

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

aha - I was wrong,

this slowdown can be enforced by slow client (or slow network). pgAdmin is not terrible fast. Try to execute your query from psql.

Regards

Pavel
 

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

pgsql-performance by date:

Previous
From: Belal Al-Hamed
Date:
Subject: Re: Copy command Faster than original select
Next
From: Belal Al-Hamed
Date:
Subject: Re: Copy command Faster than original select