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.
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