Re: Monitoring and insight into NOTIFY queue

On Fri, Feb 19, 2016 at 6:01 AM, Jiří Hlinka <jiri.hlinka@gmail.com> wrote:
> Hello,
>
> I'd like to ask you whether there is a way how to monitor and log details
> about NOTIFY queue? What do you use for this prupose?
>
> In the official documentation I'm unable to find a way how to monitor NOTIFY
> queue in more detail, at least size of this queue, which is critical in case
> of filling up the queue, which will lead to stopping the NOTIFY queue
> functionality.


It won't help you now, but version 9.6 will introduce a new function
that should help:


Date:   Fri Jul 17 09:12:03 2015 -0400

    Add new function pg_notification_queue_usage.

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


Cheers,

Jeff