#observability

Do not add an index first: use EXPLAIN, statistics, and ANALYZE to see what PostgreSQL is guessing

PostgreSQL chooses query plans from estimated costs. Compare EXPLAIN estimates with real execution before deciding whether statistics, query design, or an index needs to change.