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

Exercise

Filtering impacts

You will revisit filtering while examining the African countries with athletes competing in the Summer Olympics. You will look at the average age by gender for the Rio de Janeiro and Beijing games.

Along the way, you will compare the query plans using numeric filters, text filters, and indexed filters.

Instructions 1/3

undefined XP
  • 1

    Use age to find which Olympics, on average, had the youngest female athletes.

  • 2

    Check the query's execution time.

  • 3

    Now limit the results using the numeric year filter (2008, 2016) and run the new execution plan.