Re: How to clock the time spent for query parsing and planning?

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Igor Schtein <ischtein(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: How to clock the time spent for query parsing and planning?
Date: 2011-12-27 09:38:18
Message-ID: CAFj8pRARtqa16g50X_nk-J_qq0kahbE=vFVMf47XErHkFTaz4g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hello

2011/12/23 Igor Schtein <ischtein(at)gmail(dot)com>:
> I'd like to find some measurements/figures of query preparation and planning
> time to justify the use of prepared statements and stored procedures.
> I know that complex queries have larger preparation time. Though, is it
> possible to explicitly measure the time the optimizer spends parsing and
> planning for query execution?

You can use time for EXPLAIN statement

Regards

Pavel Stehule

>
> Thank you,
> James

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message MirrorX 2011-12-27 10:52:13 parse - bind take more time than execute
Previous Message Scott Marlowe 2011-12-25 07:15:01 Re: Postgresql 9.0.6 Raid 5 or not please help.