PostgreSQLmedium

How do `pg_stat_activity` and `pg_stat_statements` help in troubleshooting?

Answer

`pg_stat_activity` shows current sessions and running queries. `pg_stat_statements` aggregates query statistics (calls, total time) to identify slow or frequent queries. Together they help spot blockers, long transactions, and heavy SQL.

Related questions

PostgreSQL

Materialized view vs view: what’s the difference?

#postgres#views#materialized-view

PostgreSQL

LISTEN/NOTIFY: what problem does it solve?

#postgres#listen-notify#pubsub

PostgreSQL

Advisory locks: what are they and when would you use them?

#postgres#locks#advisory

PostgreSQL

BRIN index: when is it useful?

#postgres#brin#indexes

PostgreSQL

GIN vs GiST indexes: when would you use each?

#postgres#indexes#gin

PostgreSQL

ANALYZE: what does it do and how does it affect query plans?

#postgres#analyze#optimizer