1
/* contrib/pg_stat_statements/pg_stat_statements--1.0.sql */
4
CREATE FUNCTION pg_stat_statements_reset()
9
CREATE FUNCTION pg_stat_statements(
14
OUT total_time float8,
16
OUT shared_blks_hit int8,
17
OUT shared_blks_read int8,
18
OUT shared_blks_written int8,
19
OUT local_blks_hit int8,
20
OUT local_blks_read int8,
21
OUT local_blks_written int8,
22
OUT temp_blks_read int8,
23
OUT temp_blks_written int8
29
-- Register a view on the function for ease of use.
30
CREATE VIEW pg_stat_statements AS
31
SELECT * FROM pg_stat_statements();
33
GRANT SELECT ON pg_stat_statements TO PUBLIC;
35
-- Don't want this to be available to non-superusers.
36
REVOKE ALL ON FUNCTION pg_stat_statements_reset() FROM PUBLIC;