Find unused indexes

sql

SELECT schemaname, relname, indexrelname, idx_scan
FROM pg_stat_user_indexes
ORDER BY idx_scan ASC, relname;

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 current sessions and queries.

Open In sheetsqlsame section

Inspect lock acquisition and contention.

Open In sheetsqlsame section

Review checkpoint and buffer write statistics.

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