1. Learn
    2. /
  2. Courses
    3. /
  3. Improving Query Performance in PostgreSQL

Exercise

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?

Instructions 1/2

undefined XP
  • 1

    Check out the query plan with the VERBOSE option so as to see the column names.

  • 2

    Check out the query plan with actual run times.