Postgres Pro
Downloads
Home   >   mailing lists

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

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

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Postgresql 9.0.6 Raid 5 or not please help.
Next
From: "Michael Smolsky"
Date:
Subject: Exploring memory usage