Index (PostgreSQL)

• https://www.postgresql.org/docs/current/indexes.html

GIN, B-tree and BRIN indexes 

CREATE INDEX

SELECT 
  relname, 
  100 * idx_scan / (seq_scan + idx_scan) percent_of_times_index_used, 
  n_live_tup rows_in_table
FROM 
  pg_stat_user_tables
WHERE 
    seq_scan + idx_scan > 0 
ORDER BY 
  n_live_tup DESC;

Ref: https://www.craigkerstiens.com/2012/10/01/understanding-postgres-performance/

relname | percent_of_times_index_used | rows_in_table
---------+-----------------------------+---------------
(0 rows)

\di
Did not find any relations.

News

• PostgreSQL 18 (Sep 2025) supports parallel builds for GIN indexes, joining B-tree and BRIN indexes in supporting this capability

Related

• Database index
• Schema
• PostgreSQL Index Locking
• INDEX

See also

• Index (PostgreSQL): CREATE INDEX, Index Locking, INDEX, REINDEX TABLE
• EXPLAIN, PostgreSQL parallel query, Execution plan