Skip to content

Glossary: PostgreSQL Beyond the Basics

pg_stat_user_indexes

Also written: idx_scan

A view counting scans per index since statistics were last reset. An index with `idx_scan` 0 after weeks may be unused.

Where the book teaches it

Related terms

pg_stat_user_tables