Show active sessions

sql

SELECT pid, usename, application_name, state, query
FROM pg_stat_activity
ORDER BY backend_start;

Explanation

See summary for usage details.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Monitoring and Statistics

Inspect lock acquisition and contention.

Open In sheetsqlsame section

Review index scan counts when cleaning up indexes.

Open In sheetsqlsame section

Cancel a running query without terminating the session.

Open In sheetsqlsame section

Force a backend to disconnect.

Open In sheetsqlsame section

Measure one database's size.

Open In sheetsqlsame section

Measure one relation including indexes and TOAST.

Open In sheetsqlsame section