Query Optimization

pg_stat_statements

• find top-5 slowest queries

Fixes

• partial index
• covering index
• query rewrite

Before/After EXPLAIN pattern