Hello 2011/12/23 Igor Schtein <ischtein@xxxxxxxxx>: > 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance