On 11/23/21 14:56, James Sewell wrote:
Sorry, I could have been clearer - pg_stat_activity is what I'm looking at - I'm recording connection info from here every 15 seconds (from a superuser account so I don't get locked out). It never peaks above 300 (in fact when the incident happens no new connections can come in so it falls to around 100) - yet I'm seeing the log lines claim that I'm still hitting 597 (600 - 3 reserved).
What is the query you are using against pg_stat_activity?
James
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx
