To: =?utf-8?q?Igor_Neyman?= <ineyman@perceptron.com>,
 =?utf-8?q?Pavel_Stehule?= <pavel.stehule@gmail.com>
Subject: 
 =?utf-8?q?RE=3A_=5BPERFORM=5D_Re=3A_=5BPERFORM=5D_Sub=2Doptimal_plan_for_a_paginated_query_on_a_view_with_another_view_inside_of_it=2E?=
Date: Wed, 07 Aug 2013 17:33:49 +0200
From: <slapo@centrum.sk>
Cc: =?utf-8?q?pgsql=2Dperformance=40postgresql=2Eorg?=
 <pgsql-performance@postgresql.org>
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>
In-Reply-To: 
 <A76B25F2823E954C9E45E32FA49D70EC1BBF393A@mail.corp.perceptron.com>
MIME-Version: 1.0
Message-Id: <20130807173349.E2F843A7@centrum.sk>
Content-Type: multipart/alternative;
 boundary="_d32c_-------8a336e122026dd2f1a9d96b7587caaaf"
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

This is a multi-part message in MIME format.

--_ca29_-------efe7cdaf3da2b8101a7ab5f96ca2ebd5
Content-Type: multipart/alternative;
	boundary="_d32c_-------8a336e122026dd2f1a9d96b7587caaaf"

--_d32c_-------8a336e122026dd2f1a9d96b7587caaaf
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

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


--_d32c_-------8a336e122026dd2f1a9d96b7587caaaf
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<p style="padding:0 0 0 0; margin:0 0 0 0;">I got:</p>

<p style="padding:0 0 0 0; margin:0 0 0 0;">"Total runtime: 9.313 ms" in pgAdmin</p>

<p style="padding:0 0 0 0; margin:0 0 0 0;"><span style="font-size: 10pt;">"Total runtime:</span><span style="font-size: 10pt;">&nbsp;</span>9.363 ms<span style="font-size: 10pt;">" in psql.</span></p>

<p style="padding:0 0 0 0; margin:0 0 0 0;">But timing after the query finished was 912.842 ms in psql.</p>

<p style="padding:0 0 0 0; margin:0 0 0 0;">&nbsp;</p>

<p style="padding:0 0 0 0; margin:0 0 0 0;">Cheers,</p>

<p style="padding:0 0 0 0; margin:0 0 0 0;">&nbsp;</p>

<p style="padding:0 0 0 0; margin:0 0 0 0;">Peter Slapansky</p>

<p style="padding:0 0 0 0; margin:0 0 0 0;">______________________________________________________________<br />
&gt; Od: Igor Neyman &lt;ineyman@perceptron.com&gt;<br />
&gt; Komu: "slapo@centrum.sk" &lt;slapo@centrum.sk&gt;, Pavel Stehule &lt;pavel.stehule@gmail.com&gt;<br />
&gt; D&aacute;tum: 07.08.2013 16:48<br />
&gt; Predmet: RE: [PERFORM] Re: [PERFORM] Sub-optimal plan for a paginated query on a view with another view inside of it.<br />
&gt;</p>

<p style="padding:0 0 0 0; margin:0 0 0 0;">&gt; CC: "pgsql-performance@postgresql.org"</p>

<p style="padding:0 0 0 0; margin:0 0 0 0;"><br />
<br />
From: slapo@centrum.sk [mailto:slapo@centrum.sk] <br />
Sent: Wednesday, August 07, 2013 10:43 AM<br />
To: Igor Neyman; Pavel Stehule<br />
Cc: pgsql-performance@postgresql.org<br />
Subject: RE: [PERFORM] Re: [PERFORM] Sub-optimal plan for a paginated query on a view with another view inside of it.<br />
<br />
You're right, it does... but it's quite odd, because I re-ran the explain-analyze statement and got the same results.<br />
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.<br />
&nbsp;<br />
I did this via pgadmin, but that shouldn't matter, should it?<br />
&nbsp;<br />
Thank you,<br />
&nbsp;<br />
Peter Slapansky<br />
______________________________________________________________<br />
_________________________________________________________<br />
<br />
At very end of explain analyze output there should be a line:<br />
<br />
Total runtime: ....<br />
<br />
What do you get there?<br />
<br />
Regards,<br />
Igor Neyman</p>


--_d32c_-------8a336e122026dd2f1a9d96b7587caaaf--

--_ca29_-------efe7cdaf3da2b8101a7ab5f96ca2ebd5--