RE: [PERFORM] Re: [PERFORM] Sub-optimal plan for a paginated query on a view with another view inside of it. - Mailing list pgsql-performance

From
Subject RE: [PERFORM] Re: [PERFORM] Sub-optimal plan for a paginated query on a view with another view inside of it.
Date
Msg-id 20130807173349.E2F843A7@centrum.sk
Whole thread Raw
In response to Re: Re: [PERFORM] Sub-optimal plan for a paginated query on a view with another view inside of it.  (Igor Neyman <ineyman@perceptron.com>)
Responses Re: Re: [PERFORM] Sub-optimal plan for a paginated query on a view with another view inside of it.  (Igor Neyman <ineyman@perceptron.com>)
Re: RE: [PERFORM] Re: [PERFORM] Sub-optimal plan for a paginated query on a view with another view inside of it.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-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

pgsql-performance by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Re: [PERFORM] Sub-optimal plan for a paginated query on a view with another view inside of it.
Next
From: Alexis Lê-Quôc
Date:
Subject: Better performance possible for a pathological query?