Skip to content

PopSQL: limited support.

Migrate now →
DataRunner
Start free

Indexes never used

Non-unique indexes with zero scans since the last statistics reset, with the space they take. Each one is write cost with no read benefit.

Run it in DataRunner
PostgreSQL · SQL
SELECT s.schemaname || '.' || s.relname AS table_name,
       s.indexrelname AS index_name,
       pg_size_pretty(pg_relation_size(s.indexrelid)) AS size,
       pg_relation_size(s.indexrelid) AS size_bytes,
       s.idx_scan AS scans
FROM pg_stat_user_indexes s
JOIN pg_index i ON i.indexrelid = s.indexrelid
WHERE s.idx_scan = 0
  AND NOT i.indisunique
  AND NOT i.indisprimary
ORDER BY pg_relation_size(s.indexrelid) DESC
LIMIT 25

This query is part of the "PostgreSQL health" pack: connect the database in DataRunner and install the whole pack — queries, dashboard and checks — at once.