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

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add stats for min, max, mean, stddev times to pg_stat_statements
Date: 2015-03-27 19:48:58
Message-ID: E1YbaFW-0008VB-AD@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/717f709532642f5f7756785c9be17b7ffcec8ae8

Modified Files
--------------
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(-)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Andrew Dunstan 2015-03-27 21:33:46 pgsql: Fix portability issues with stddev in pg_stat_statements
Previous Message Andres Freund 2015-03-26 21:51:57 Re: Re: [COMMITTERS] pgsql: Add macros wrapping all usage of gcc's __attribute__.