SELECT
pid,
usename AS user,
datname AS database,
client_addr AS client,
application_name,
state,
query,
backend_start,
state_change
FROM pg_stat_activity;
This query retrieves details on all active connections, including the user, database, client address, application, and query being executed.
SELECT pid, usename, client_addr, state, query
FROM pg_stat_activity
WHERE datname = 'your_database_name';
This query shows how many connections exist per database.
SELECT datname, count(*) AS connection_count
FROM pg_stat_activity
GROUP BY datname;
Idle connections are those that are open but not actively executing a query.
SELECT pid, usename, client_addr, state, query
FROM pg_stat_activity
WHERE state = 'idle';
SELECT pid, datname, client_addr, state, query
FROM pg_stat_activity
WHERE usename = 'your_username';