From: slapo@centrum.sk
To: Igor Neyman <ineyman@perceptron.com>
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: pgsql-performance@postgresql.org <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.
Date: Wed, 07 Aug 2013 17:33:49 +0200
Message-ID: <20130807173349.E2F843A7@centrum.sk> (raw)
In-Reply-To: <A76B25F2823E954C9E45E32FA49D70EC1BBF393A@mail.corp.perceptron.com>
References: <20130802154316.59167BB5@centrum.sk>
<CAFj8pRAc-sk8QigQJJn+9MgLJmxU7pjH90Eqd47tAF_1HsGOXQ@mail.gmail.com>
<20130807144239.654353D3@centrum.sk>
<A76B25F2823E954C9E45E32FA49D70EC1BBF38D9@mail.corp.perceptron.com>
<20130807164250.26C21834@centrum.sk>
<A76B25F2823E954C9E45E32FA49D70EC1BBF393A@mail.corp.perceptron.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
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 <ineyman@perceptron.com>
> Komu: "slapo@centrum.sk" <slapo@centrum.sk>, Pavel Stehule <pavel.stehule@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: slapo@centrum.sk [mailto:slapo@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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: slapo@centrum.sk, ineyman@perceptron.com, pavel.stehule@gmail.com
Subject: Re: RE: [PERFORM] Re: [PERFORM] Sub-optimal plan for a paginated query on a view with another view inside of it.
In-Reply-To: <20130807173349.E2F843A7@centrum.sk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox