1/* contrib/pg_stat_statements/pg_stat_statements--1.4.sql */
2
3-- complain if script is sourced in psql, rather than via CREATE EXTENSION
4\echo Use "CREATE EXTENSION pg_stat_statements" to load this file. \quit
5
6-- Register functions.
7CREATE FUNCTION pg_stat_statements_reset()
8RETURNS void
9AS 'MODULE_PATHNAME'
10LANGUAGE C PARALLEL SAFE;
11
12CREATE FUNCTION pg_stat_statements(IN showtext boolean,
13    OUT userid oid,
14    OUT dbid oid,
15    OUT queryid bigint,
16    OUT query text,
17    OUT calls int8,
18    OUT total_time float8,
19    OUT min_time float8,
20    OUT max_time float8,
21    OUT mean_time float8,
22    OUT stddev_time float8,
23    OUT rows int8,
24    OUT shared_blks_hit int8,
25    OUT shared_blks_read int8,
26    OUT shared_blks_dirtied int8,
27    OUT shared_blks_written int8,
28    OUT local_blks_hit int8,
29    OUT local_blks_read int8,
30    OUT local_blks_dirtied int8,
31    OUT local_blks_written int8,
32    OUT temp_blks_read int8,
33    OUT temp_blks_written int8,
34    OUT blk_read_time float8,
35    OUT blk_write_time float8
36)
37RETURNS SETOF record
38AS 'MODULE_PATHNAME', 'pg_stat_statements_1_3'
39LANGUAGE C STRICT VOLATILE PARALLEL SAFE;
40
41-- Register a view on the function for ease of use.
42CREATE VIEW pg_stat_statements AS
43  SELECT * FROM pg_stat_statements(true);
44
45GRANT SELECT ON pg_stat_statements TO PUBLIC;
46
47-- Don't want this to be available to non-superusers.
48REVOKE ALL ON FUNCTION pg_stat_statements_reset() FROM PUBLIC;
49