/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
contrib/pg_buffercache/pg_buffercache--1.3--1.4.sql
28 строк
1021 B
Tom Lane
Add pg_buffercache_usage_counts() to contrib/pg_buffercache.
07 апр 2023, 21:25
07 апр 2023, 21:25
f3fa313
Код
Авторство
О чём код?
/* contrib/pg_buffercache/pg_buffercache--1.3--1.4.sql */ -- complain if script is sourced in psql, rather than via ALTER EXTENSION \echo Use "ALTER EXTENSION pg_buffercache UPDATE TO '1.4'" to load this file. \quit CREATE FUNCTION pg_buffercache_summary( OUT buffers_used int4, OUT buffers_unused int4, OUT buffers_dirty int4, OUT buffers_pinned int4, OUT usagecount_avg float8) AS 'MODULE_PATHNAME', 'pg_buffercache_summary' LANGUAGE C PARALLEL SAFE; CREATE FUNCTION pg_buffercache_usage_counts( OUT usage_count int4, OUT buffers int4, OUT dirty int4, OUT pinned int4) RETURNS SETOF record AS 'MODULE_PATHNAME', 'pg_buffercache_usage_counts' LANGUAGE C PARALLEL SAFE; -- Don't want these to be available to public. REVOKE ALL ON FUNCTION pg_buffercache_summary() FROM PUBLIC; GRANT EXECUTE ON FUNCTION pg_buffercache_summary() TO pg_monitor; REVOKE ALL ON FUNCTION pg_buffercache_usage_counts() FROM PUBLIC; GRANT EXECUTE ON FUNCTION pg_buffercache_usage_counts() TO pg_monitor;