This article is half-done without your Comment! *** Please share your thoughts via Comment ***
In this post, I am sharing a psql script to find a running or active sessions and connections of PostgreSQL.
This script is handy for PostgreSQL DBA.
I am using this same script for our productions PostgreSQL server.
Below is a script:
I filtered “idle connections”
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
SELECT pid ,datname ,usename ,application_name ,client_hostname ,client_port ,backend_start ,query_start ,query FROM pg_stat_activity WHERE state <> 'idle' AND pid<>pg_backend_pid(); |
