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

Hello

2011/12/23 Igor Schtein <ischtein@gmail.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