Skip site navigation (1) Skip section navigation (2)

Re: explain doesn't work with execute using

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: explain doesn't work with execute using
Date: 2008-06-01 18:59:48
Message-ID: 162867790806011159r1e68f13bqe1bcc0767cddb3e5@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
2008/6/1 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> writes:
>> 2008/6/1 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
>>> This argument seems entirely bogus.  How are they any more constant
>>> than in the other case?  The value isn't going to change for the life
>>> of the portal in either case.
>
>> this is true Tom, but problem is in EXPLAIN. I thing, so my and your
>> solution are little bit incorect. We solve result, not reason. We have
>> problem, bacause plan doesn't carry parameter's flags, and with
>> EXPLAIN planner is called two times with different param's flags.
>
> [ shrug... ]  Well, I'm willing to change the code as you suggest,
> but if you're thinking that this will make EXPLAIN exactly reproduce
> the plan that would be generated for a plain SELECT invoked in the
> same context, you're still mistaken.  It doesn't account for the
> effects of the fast-start-cursor option.  And for what you seem to
> want EXPLAIN to do here, it probably shouldn't.  The whole thing
> seems pretty unprincipled to me ...
>

It's not best, and it's surprise for me, so EXPLAIN can be different
then real plan. It's basic tool for identification of plpgsql
procedure's performance problems. So this can be short fix and point
for ToDo?

Regards
Pavel Stehule

>                        regards, tom lane
>

In response to

pgsql-hackers by date

Next:From: Zdenek KotalaDate: 2008-06-01 19:03:26
Subject: Re: Where can I find the doxyfile?
Previous:From: Pavel StehuleDate: 2008-06-01 18:53:08
Subject: Re: proposal: table functions and plpgsql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group