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

From: Igor Schtein <ischtein(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: How to clock the time spent for query parsing and planning?
Date: 2011-12-23 19:27:13
Message-ID: CAN_fNGDfNxbmnbj8K42NXPA8GsU4XOmEK-qTfC2gUoxGGAgxOQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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?

Thank you,
James

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Smolsky 2011-12-24 19:22:39 Exploring memory usage
Previous Message Scott Marlowe 2011-12-23 18:06:51 Re: Postgresql 9.0.6 Raid 5 or not please help.