статистика соединений PostgresSQL и диагностика ошибок

 SELECT state, count(*) 

FROM pg_stat_activity 

GROUP BY state;

SELECT client_addr, datname, usename, "state", wait_event_type, wait_event, "query"

FROM pg_stat_activity 

WHERE state IS NOT NULL;

SELECT now() - backend_start as connection_age, now() - xact_start as transaction_age, usename, application_name, state, query FROM pg_stat_activity WHERE datname = current_database() ORDER BY connection_age DESC;

SELECT count(*), usename, application_name FROM pg_stat_activity GROUP BY usename, application_name;

Источник: https://www.timescale.com/forum/t/connection-issue-too-many-clients-already-error-while-inserting-rows/2877/3