Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Script to find active sessions or connections in PostgreSQL

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”
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();

Comments

Popular posts from this blog

Oracle DBMS SCHEDULER Examples

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

7 Steps to configure BDR replication in postgresql

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

How to Enable/Disable autovacuum on PostgreSQL