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