From 717f709532642f5f7756785c9be17b7ffcec8ae8 Mon Sep 17 00:00:00 2001 From: Andrew Dunstan Date: Fri, 27 Mar 2015 15:43:22 -0400 Subject: Add stats for min, max, mean, stddev times to pg_stat_statements. MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit 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. --- doc/src/sgml/pgstatstatements.sgml | 28 ++++++++++++++++++++++++++++ 1 file changed, 28 insertions(+) (limited to 'doc/src') diff --git a/doc/src/sgml/pgstatstatements.sgml b/doc/src/sgml/pgstatstatements.sgml index a58ecf7065f..04b3f01ed5c 100644 --- a/doc/src/sgml/pgstatstatements.sgml +++ b/doc/src/sgml/pgstatstatements.sgml @@ -86,6 +86,34 @@ Total time spent in the statement, in milliseconds + + min_time + double precision + + Minimum time spent in the statement, in milliseconds + + + + max_time + double precision + + Maximum time spent in the statement, in milliseconds + + + + mean_time + double precision + + Mean time spent in the statement, in milliseconds + + + + stddev_time + double precision + + Population standard deviation of time spent in the statement, in milliseconds + + rows bigint -- cgit v1.2.3