How to List Indexes in PostgreSQL

Last updated July 25, 2026 · By the SaturnSQL team

In psql, \di lists indexes and \d tablename shows the indexes on one table. From SQL, query the pg_indexes view, which includes the full index definition.

\di
\d orders

SELECT indexname, indexdef
FROM pg_indexes
WHERE schemaname = 'public'
  AND tablename = 'orders'
ORDER BY indexname;