Presented by:

C06d45cc67a7b936a5c2780c8befbcc0

Jeevan Chalke

from EnterpriseDB
No video of the event yet, sorry!

Download slides

Many times we were amazed that why is my query running slow? And couldn't get to know exactly what's an issue. However, if we know the plan of a query, then life becomes easy. For that EXPLAIN is our handy tool which gives us a query-plan for the given statement. For good performance and tuning the system, choosing the right plan is very necessary. PostgreSQL planner is designed such a way that it analyzes the query structure, data and from the statistics, it chooses the best plan for the query. Moreover, if we are able to read and understand that plan correctly, then by tweaking a few of the server parameters we can have a better plan to execute the same query.

In this talk, I will mainly focus on reading and understanding the EXPLAIN and EXPLAIN ANALYZE output which will help us to restructure the schema definition or change the server parameters for better results. I will also go through the various options available with these commands.

Date:
2019 February 15 - 12:00
Duration:
45 min
Room:
Ballroom 1
Conference:
PGConf India, 2019
Language:
Track:
Database Administration
Difficulty:
Intermediate

Happening at the same time:

  1. Robust Replication strategies in PostgreSQL: Repmgr
  2. Start Time:
    2019 February 15 12:00

    Room:
    Ballroom 3

  3. Postgresql HA on Cloud using Kubernetes
  4. Start Time:
    2019 February 15 12:00

    Room:
    Ballroom 4