diff options
| author | Andrew Dunstan <andrew@dunslane.net> | 2015-03-27 15:43:22 -0400 |
|---|---|---|
| committer | Andrew Dunstan <andrew@dunslane.net> | 2015-03-27 15:43:22 -0400 |
| commit | 717f709532642f5f7756785c9be17b7ffcec8ae8 (patch) | |
| tree | 073e0996e1136c12440ae4eced0e48a3dc778a90 /doc/src | |
| parent | 8816af65e4f8285d3ef73158b09490099921f870 (diff) | |
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.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/pgstatstatements.sgml | 28 |
1 files changed, 28 insertions, 0 deletions
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 @@ -87,6 +87,34 @@ </row> <row> + <entry><structfield>min_time</structfield></entry> + <entry><type>double precision</type></entry> + <entry></entry> + <entry>Minimum time spent in the statement, in milliseconds</entry> + </row> + + <row> + <entry><structfield>max_time</structfield></entry> + <entry><type>double precision</type></entry> + <entry></entry> + <entry>Maximum time spent in the statement, in milliseconds</entry> + </row> + + <row> + <entry><structfield>mean_time</structfield></entry> + <entry><type>double precision</type></entry> + <entry></entry> + <entry>Mean time spent in the statement, in milliseconds</entry> + </row> + + <row> + <entry><structfield>stddev_time</structfield></entry> + <entry><type>double precision</type></entry> + <entry></entry> + <entry>Population standard deviation of time spent in the statement, in milliseconds</entry> + </row> + + <row> <entry><structfield>rows</structfield></entry> <entry><type>bigint</type></entry> <entry></entry> |