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

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

PostgreSQL Pgbadger Installation On Linux

PostgreSQL pgBadger

How to configure Replication Manager (repmgr) ?

Migrating From Oracle to PostgreSQL using ora2pg open source tools