codekingpro/portable-devtools

1/* contrib/pg_stat_statements/pg_stat_statements--1.8--1.9.sql */2 3-- complain if script is sourced in psql, rather than via ALTER EXTENSION4\echo Use "ALTER EXTENSION pg_stat_statements UPDATE TO '1.9'" to load this file. \quit5 6--- Define pg_stat_statements_info7CREATE FUNCTION pg_stat_statements_info(8    OUT dealloc bigint,9    OUT stats_reset timestamp with time zone10)11RETURNS record12AS 'MODULE_PATHNAME'13LANGUAGE C STRICT VOLATILE PARALLEL SAFE;14 15CREATE VIEW pg_stat_statements_info AS16  SELECT * FROM pg_stat_statements_info();17 18GRANT SELECT ON pg_stat_statements_info TO PUBLIC;19 20/* First we have to remove them from the extension */21ALTER EXTENSION pg_stat_statements DROP VIEW pg_stat_statements;22ALTER EXTENSION pg_stat_statements DROP FUNCTION pg_stat_statements(boolean);23 24/* Then we can drop them */25DROP VIEW pg_stat_statements;26DROP FUNCTION pg_stat_statements(boolean);27 28/* Now redefine */29CREATE FUNCTION pg_stat_statements(IN showtext boolean,30    OUT userid oid,31    OUT dbid oid,32    OUT toplevel bool,33    OUT queryid bigint,34    OUT query text,35    OUT plans int8,36    OUT total_plan_time float8,37    OUT min_plan_time float8,38    OUT max_plan_time float8,39    OUT mean_plan_time float8,40    OUT stddev_plan_time float8,41    OUT calls int8,42    OUT total_exec_time float8,43    OUT min_exec_time float8,44    OUT max_exec_time float8,45    OUT mean_exec_time float8,46    OUT stddev_exec_time float8,47    OUT rows int8,48    OUT shared_blks_hit int8,49    OUT shared_blks_read int8,50    OUT shared_blks_dirtied int8,51    OUT shared_blks_written int8,52    OUT local_blks_hit int8,53    OUT local_blks_read int8,54    OUT local_blks_dirtied int8,55    OUT local_blks_written int8,56    OUT temp_blks_read int8,57    OUT temp_blks_written int8,58    OUT blk_read_time float8,59    OUT blk_write_time float8,60    OUT wal_records int8,61    OUT wal_fpi int8,62    OUT wal_bytes numeric63)64RETURNS SETOF record65AS 'MODULE_PATHNAME', 'pg_stat_statements_1_9'66LANGUAGE C STRICT VOLATILE PARALLEL SAFE;67 68CREATE VIEW pg_stat_statements AS69  SELECT * FROM pg_stat_statements(true);70 71GRANT SELECT ON pg_stat_statements TO PUBLIC;72