MISSION 259

Debugging Postgres Queries

Learn how to debug your Postgres queries using EXPLAIN.

Objectives

  • Learn how to debug Postgres queries.
  • Learn how to measure estimated and actual execution times.

Mission Outline

1. The EXPLAIN Query
2. The Path of a Query
3. Additional Output Formats
4. Describing EXPLAIN Output
5. Adding the ANALYZE Option
6. Test and Rollback
7. ANALYZE a Join Statement
8. Join on Sequence Sacans
9. Next Steps
10. Takeaways

optimizing-postgres-databases-data-engineering

Course Info:

Optimizing Postgres Databases

Intermediate

The average completion time for this course is 10-hours.

This course is free and includes five missions. It is the 2nd course in the Data Engineer path.

START LEARNING FREE

Take a Look Inside