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 median completion time for this course is 4.7 hours.

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

START LEARNING FREE

Take a Look Inside