Add new function pg_notification_queue_usage

Enterprise / PostgreSQL - Robert Haas [postgresql.org] - 17 July 2015 08:12 UTC

This tells you what fraction of NOTIFY's queue is currently filled.

Brendan Jurd, reviewed by Merlin Moncure and Gurjeet Singh. A few further tweaks by me.

a04bb65 Add new function pg_notification_queue_usage.
doc/src/sgml/func.sgml | 19 ++++++++--
doc/src/sgml/ref/notify.sgml | 5 +++
src/backend/commands/async.c | 50 ++++++++++++++++++++------
src/include/catalog/catversion.h | 2 +-
src/include/catalog/pg_proc.h | 4 +++
src/include/commands/async.h | 1 +
src/test/isolation/expected/async-notify.out | 17 +++++++++
src/test/isolation/specs/async-notify.spec | 14 ++++++++
src/test/regress/expected/async.out | 8 +++++
src/test/regress/sql/async.sql | 4 +++
10 files changed, 110 insertions(+), 14 deletions(-)

Upstream: git.postgresql.org

  • Share