codekingpro/portable-devtools

1/* contrib/pg_buffercache/pg_buffercache--1.3--1.4.sql */2 3-- complain if script is sourced in psql, rather than via ALTER EXTENSION4\echo Use "ALTER EXTENSION pg_buffercache UPDATE TO '1.4'" to load this file. \quit5 6CREATE FUNCTION pg_buffercache_summary(7    OUT buffers_used int4,8    OUT buffers_unused int4,9    OUT buffers_dirty int4,10    OUT buffers_pinned int4,11    OUT usagecount_avg float8)12AS 'MODULE_PATHNAME', 'pg_buffercache_summary'13LANGUAGE C PARALLEL SAFE;14 15CREATE FUNCTION pg_buffercache_usage_counts(16    OUT usage_count int4,17    OUT buffers int4,18    OUT dirty int4,19    OUT pinned int4)20RETURNS SETOF record21AS 'MODULE_PATHNAME', 'pg_buffercache_usage_counts'22LANGUAGE C PARALLEL SAFE;23 24-- Don't want these to be available to public.25REVOKE ALL ON FUNCTION pg_buffercache_summary() FROM PUBLIC;26GRANT EXECUTE ON FUNCTION pg_buffercache_summary() TO pg_monitor;27REVOKE ALL ON FUNCTION pg_buffercache_usage_counts() FROM PUBLIC;28GRANT EXECUTE ON FUNCTION pg_buffercache_usage_counts() TO pg_monitor;29