PostgreSQLmedium

ANALYZE: what does it do and how does it affect query plans?

Answer

ANALYZE collects statistics about table data (row counts, value distribution). The planner uses these stats to estimate costs and choose join orders and index usage. Stale stats can lead to bad plans.

Related questions

PostgreSQL

How do `pg_stat_activity` and `pg_stat_statements` help in troubleshooting?

#postgres#monitoring#pg_stat_activity

PostgreSQL

Materialized view vs view: what’s the difference?

#postgres#views#materialized-view

PostgreSQL

LISTEN/NOTIFY: what problem does it solve?

#postgres#listen-notify#pubsub

PostgreSQL

Advisory locks: what are they and when would you use them?

#postgres#locks#advisory

PostgreSQL

BRIN index: when is it useful?

#postgres#brin#indexes

PostgreSQL

GIN vs GiST indexes: when would you use each?

#postgres#indexes#gin