I got:
"Total runtime: 9.313 ms" in pgAdmin
"Total runtime: 9.363 ms" in psql.
But timing after the query finished was 912.842 ms in psql.
Cheers,
Peter Slapansky
______________________________________________________________
Od: Igor Neyman <iney...@perceptron.com>
Komu: "sl...@centrum.sk" <sl...@centrum.sk>, Pavel Stehule
<pavel.steh...@gmail.com>
Dátum: 07.08.2013 16:48
Predmet: RE: [PERFORM] Re: [PERFORM] Sub-optimal plan for a paginated query on
a view with another view inside of it.
CC: "pgsql-performance@postgresql.org"
From: sl...@centrum.sk [mailto:sl...@centrum.sk]
Sent: Wednesday, August 07, 2013 10:43 AM
To: Igor Neyman; Pavel Stehule
Cc: pgsql-performance@postgresql.org
Subject: RE: [PERFORM] Re: [PERFORM] Sub-optimal plan for a paginated query on
a view with another view inside of it.
You're right, it does... but it's quite odd, because I re-ran the
explain-analyze statement and got the same results.
Still, the query now runs for about a second as mentioned before, so it's
almost like something's missing from the explain, but I'm certain I copied it
all.
I did this via pgadmin, but that shouldn't matter, should it?
Thank you,
Peter Slapansky
______________________________________________________________
_________________________________________________________
At very end of explain analyze output there should be a line:
Total runtime: ....
What do you get there?
Regards,
Igor Neyman
