Query Optimization and its Impact on Performance

Here are links to a few things we mentioned: 

• Using EXPLAIN (PostgreSQL documentation)
• explain.depesz.com
• explain.dalibo.com
• pgMustard 
• EverSQL
• pganalyze
• pg_stat_monitor (Extension by Percona)
• Recent thread on hackers mailing list about plan_id in pg_stat_activity
• auto_explain
• EXPLAIN observer effect (Ongres blog post by Álvaro Hernández)
• auto_explain overhead (blog post by Michael)  
• pg_test_timing
• Database Lab Engine (for thin clones)
• Our previous episode on BUFFERS
• EXPLAIN Explained (talk by Josh Berkus)
• A beginner's guide to EXPLAIN (talk by Michael)
• A deeper dive into EXPLAIN (talk by Michael)
• EXPLAIN glossary (pgMustard docs)
• Topic suggestions document

------------------------

What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov and @michristofides or by commenting on our Google doc.

If you would like to share this episode, here's a good link (and thank you!)

Postgres FM is brought to you by:

• Nikolay Samokhvalov, founder of Postgres.ai
• Michael Christofides, founder of pgMustard

With special thanks to:

• Jessie Draws for the elephant artwork