↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Functions / System Information Functions And Operators

pg_notification_queue_usage

Read the PG 18 manual

Returns the fraction (0–1) of the asynchronous notification queue's maximum size that is currently occupied by notifications that are waiting to be processed.

Reading PG 18current·documented in 12 of 27 versions, 9.6 to 20

Signatures & examples

pg_notification_queue_usage () → double precision
Returns the fraction (0–1) of the asynchronous notification queue's maximum size that is currently occupied by notifications that are waiting to be processed. See LISTEN and NOTIFY for more information.
Version history 2
  1. 12 → 13 changed
  2. 9.5 → 9.6 added

Definition snapshot: b7bd9cda · English manual source