Re: Monitoring and insight into NOTIFY queue

On Fri, Feb 19, 2016 at 6:01 AM, Jiří Hlinka <jiri(dot)hlinka(at)gmail(dot)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