Script to find active sessions or connections in PostgreSQL

In this post, I am sharing one psql script to find a running or active session and connections of PostgreSQL.

This script is very useful for PostgreSQL DBA.
I am using this same script for our productions PostgreSQL server.

Below is a script and I have already filtered your running sessions and “idle connections”.

Anvesh Patel

Leave a Reply

Be the First to Comment!

Notify of