Episode 6 - Using EXPLAIN ANALYZE for Planning and Optimizing

Episode 6 - Using EXPLAIN ANALYZE for Planning and Optimizing Query Performance

Listen now

Description

When it comes to dealing with poor database and query performance, it’s a daunting task to venture into the dark cavern of query planning and optimization, but fear not! EXPLAIN is our friend in those dark and lonely places. This session covers EXPLAIN and how it is certainly one of the most invaluable tools for anyone working with PostgreSQL. Using it well will save you lots of time! For more information on this topic, visit this blog: https://www.enterprisedb.com/postgresql-query-optimization-performance-tuning-with-explain-analyze Join us every Monday at 11am EDT for our #PostgresPulse LIVE Q&A sessions. Learn more: https://www.enterprisedb.com/postgres-pulse

More Episodes

See all »

Episode 8 - X-Ray Vision for Your Queries | PgBadger

PgBadger is a PostgreSQL log analyzer with fully detailed reports and graphs. It is open source and is considered lightweight. While it doesn’t have the depth, probe capability or tool integration that EDB Postgres Enterprise Manager does, it’s particularly useful in helping you to analyze your...

Published 05/26/20

Episode 7 - Index Corruption in PostgreSQL: The Hidden Cost of Your Queries

A corruption in the database base often manifests itself in the form of errors when performing a DDL or DML operation on affected relations. The errors often show up as errors reading tables due to a missing file—that is rather straightforward, of course. However, a corrupt index is not as...

Published 05/14/20

Episode 5 - PostgreSQL Backup and Recovery - The Ifs, Whats, and Buts

Planning is key to PostgreSQL backup and recovery. Every environment has its own challenge—and even if we have multiple database clusters in the same organizations, the backup requirements for those might also vary. Therefore, it is important to list down the situations we might need to recover...

Published 04/30/20