Webinar recording: Optimizing slow queries with EXPLAIN to fix bad query plans

pganalyze
pganalyze
0 بار بازدید - 3 ماه پیش - Find the presentation slide deck
Find the presentation slide deck and all other shared material below! On June 18th, 2024, we hosted our webinar on how to use EXPLAIN effectively to optimize slow queries in Postgres, and how to identify bad query plans, due to issues such as Postgres planner row mis-estimates. We were glad to see over 500 attendees and were happy to answer over 70 questions in our Q&A session and the post-webinar follow-up emails. Come join us live next time! Articles and material we talked about in the webinar (in chronological order): - Presentation slides with all responses from the Q&A session: resources.pganalyze.com/pganalyze_Query_Optimizati… - pganalyze newsletter: pganalyze.com/newsletter - The Basics of Postgres Query Planning: pganalyze.com/docs/explain/basics-of-postgres-quer… - Hacking the Query Planner (PDF) - Tom Lane's presentation from PGCon 2011: www.pgcon.org/2011/schedule/attachments/188_Planne… - EXPLAIN (ANALYZE) needs BUFFERS to improve the Postgres query optimization: postgres.ai/blog/20220106-explain-analyze-needs-bu… eBook: “Finding the root cause of slow Postgres queries using EXPLAIN” – pganalyze.com/ebooks/explain-slow-postgres-queries “How Postgres Chooses Which Index To Use For A Query”: pganalyze.com/blog/how-postgres-chooses-index - CREATE STATISTICS postgresql.org docs: www.postgresql.org/docs/current/sql-createstatisti… - “Postgres Planner Quirks”:    • Postgres Planner Quirks: The impact o...   - “5mins of Postgres” video series on our blog: pganalyze.com/blog - Query Planning Gone Wrong (video) - Robert Haas' presentation from Postgres Open 2013:    • Robert Haas: Query Planning Gone Wrong   - pg_hint_plan GitHub repository: github.com/ossc-db/pg_hint_plan - 5mins of Postgres E1: Using Postgres statistics to improve bad query plans, pg_hint_plan extension: pganalyze.com/blog/5mins-postgres-statistics-bad-q… - Planner Method Configuration - Query planning (on the postgresql.org documentation): www.postgresql.org/docs/current/runtime-config-que… - “How partition-wise joins and aggregates improve query performance” here - pganalyze.com/blog/5mins-postgres-partition-wise-j… - “Partitioning use cases with PostgreSQL” - by Adrien Nayrat: blog.anayrat.info/en/2021/09/01/partitioning-use-c… - Planner Cost Constants on the postgresql.org documentation: www.postgresql.org/docs/current/runtime-config-que… - "100x Faster Query in Aurora Postgres with a lower random_page_cost" by Shayon Mukherjee: www.shayon.dev/post/2024/55/100x-faster-query-in-a…
3 ماه پیش در تاریخ 1403/03/30 منتشر شده است.
0 بـار بازدید شده
... بیشتر