Understand the Query Plan to Optimize Performance with EXPLAIN and EXPLAIN ANALYZE

What do you do, when you have to deal with poor database and query performance in PostgreSQL and there is no one around to help? Let us introduce you to important commands in PostgreSQL - EXPLAIN and EXPLAIN ANALYZE. Knowing how to use these 'tools' will help you identify query performance bottlenecks and opportunities. It provides a query plan detailing what approach the planner took to execute the statement provided.

Attend this webinar to learn:

  • What are EXPLAIN and EXPLAIN ANALYZE in PostgreSQL?
  • How do they help?
  • Know planner tuning parameters


Webinar video:



Webinar slides: