Add stats for min, max, mean, stddev times to pg_stat_statements

Enterprise / PostgreSQL - Andrew Dunstan [dunslane.net] - 27 March 2015 14:43 UTC

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.

717f709 Add stats for min, max, mean, stddev times to pg_stat_statements.
contrib/pg_stat_statements/Makefile | 5 +-
.../pg_stat_statements--1.2--1.3.sql | 47 +++++++++++
.../pg_stat_statements/pg_stat_statements--1.2.sql | 44 ----------
.../pg_stat_statements/pg_stat_statements--1.3.sql | 48 +++++++++++
contrib/pg_stat_statements/pg_stat_statements.c | 87 +++++++++++++++++++-
.../pg_stat_statements/pg_stat_statements.control | 2 +-
doc/src/sgml/pgstatstatements.sgml | 28 +++++++
7 files changed, 212 insertions(+), 49 deletions(-)

Upstream: git.postgresql.org

  • Share