pgsql: Expose qurey ID in pg_stat_statements view.

Started by Fujii Masaoover 12 years ago3 messagescomitters
Jump to latest
#1Fujii Masao
masao.fujii@gmail.com

Expose qurey ID in pg_stat_statements view.

The query ID is the internal hash identifier of the statement,
and was not available in pg_stat_statements view so far.

Daniel Farina, Sameer Thakur and Peter Geoghegan, reviewed by me.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/91484409bdd17f330d10671d388b72d4ef1451d7

Modified Files
--------------
contrib/pg_stat_statements/Makefile | 4 +-
.../pg_stat_statements--1.1--1.2.sql | 43 +++++++++++
.../pg_stat_statements/pg_stat_statements--1.1.sql | 43 -----------
.../pg_stat_statements/pg_stat_statements--1.2.sql | 44 ++++++++++++
contrib/pg_stat_statements/pg_stat_statements.c | 62 +++++++++++++---
.../pg_stat_statements/pg_stat_statements.control | 2 +-
doc/src/sgml/pgstatstatements.sgml | 75 ++++++++++++++++----
7 files changed, 202 insertions(+), 71 deletions(-)

--
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers

In reply to: Fujii Masao (#1)
Re: pgsql: Expose qurey ID in pg_stat_statements view.

I see now that references to "queryid" in the documentation say
"querid" in one or two places. Whoops.

--
Peter Geoghegan

--
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers

#3Magnus Hagander
magnus@hagander.net
In reply to: Peter Geoghegan (#2)
Re: pgsql: Expose qurey ID in pg_stat_statements view.

Fixed. It was three..

//Magnus

On Sat, Dec 7, 2013 at 10:27 PM, Peter Geoghegan <pg@heroku.com> wrote:

I see now that references to "queryid" in the documentation say
"querid" in one or two places. Whoops.

--
Peter Geoghegan

--
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers

--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/