Postgres Pro
Downloads
Home   >   mailing lists

Re: How to clock the time spent for query parsing and planning? - Mailing list pgsql-performance

From Pavel Stehule
Subject Re: How to clock the time spent for query parsing and planning?
Date
Msg-id CAFj8pRARtqa16g50X_nk-J_qq0kahbE=vFVMf47XErHkFTaz4g@mail.gmail.com
Whole thread Raw
In response to How to clock the time spent for query parsing and planning?  (Igor Schtein <ischtein@gmail.com>)
Responses Re: How to clock the time spent for query parsing and planning?
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: "Michael Smolsky"
Date:
Subject: Exploring memory usage
Next
From: MirrorX
Date:
Subject: parse - bind take more time than execute