EXPLAIN parameters
EXPLAIN
gives a window into the query plan. It has some optional parameters that provide additional information. You want to try out these optional parameters, focusing on the VERBOSE
and ANALYZE
parameters.
VERBOSE
allows you to see the available columns at each step of the plan. ANALYZE
computes actual run times in milliseconds. Which parameter's output do you find most useful?
This exercise is part of the course
Improving Query Performance in PostgreSQL
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
___ ___
SELECT *
FROM country_demos;