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?