pgAssistant
  • Documentation
  • Posts
  • Search
  • Tags
Home » Tags

PGASSISTANT JOURNAL

Performance

May 12, 2026 · 6 min read

PostgreSQL: Which Queries Should You Optimize First?

When investigating PostgreSQL performance, the usual starting point is pg_stat_statements. From there, many teams sort queries by mean_exec_time or total_exec_time and start optimizing the …

Read more →: PostgreSQL: Which Queries Should You Optimize First?
May 11, 2026 · 9 min read

Designing the Right PostgreSQL Index Using Query Plans and Statistics

PostgreSQL index design is often misunderstood. Many developers think that creating a good index simply means: “Create an index containing the columns from the WHERE clause.” In reality, …

Read more →: Designing the Right PostgreSQL Index Using Query Plans and Statistics
May 10, 2026 · 4 min read

Detecting PostgreSQL optimization issues with deterministic analysis

Detecting PostgreSQL optimization issues with deterministic analysis For years, I kept seeing the same PostgreSQL problems in production: missing foreign key indexes stale statistics unused …

Read more →: Detecting PostgreSQL optimization issues with deterministic analysis
© 2026 pgAssistant — Continuous PostgreSQL Improvement · Powered by Hugo & PaperMod