April 6th, 2015 by depesz | Tags: performance, pg95, pg_stat_statements, postgresql, statistics, timing | 1 comment »
On 27th of March, Andrew Dunstan committed patch: Add stats for min, max, mean, stddev times to pg_stat_statements. The new fields are min_time, max_time, mean_time and stddev_time. Based on an original patch from Mitsumasa KONDO, modified by me. Reviewed by Petr Jelínek.
February 13th, 2012 by depesz | Tags: analyze, explain, overhead, pg92, postgresql, timing | 2 comments »
On 7th of February, Robert Haas committed patch: Sometimes it may be useful to get actual row counts out of EXPLAIN (ANALYZE) without paying the cost of timing every node entry/exit. With this patch, you can say EXPLAIN (ANALYZE, TIMING OFF) to get ...