Get startedGet started for free

Partitioning on location

The air quality index (AQI) is calculated on four air pollutants (ozone, particle pollution, carbon monoxide, and sulfur dioxide) then categorized into six levels.

Air quality in the US is monitored on a state level, with states reporting data to the Environmental Protection Agency (EPA). Because of these different sources, the air quality table is partitioned by state. While it looks like one table, each state has its own child table.

Find the cost estimate impact of the partition. Then find the best days and places to visit in Hawaii based on the AQI.

This exercise is part of the course

Improving Query Performance in PostgreSQL

View Course

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

EXPLAIN
SELECT * 
FROM daily_aqi
___ state_code = ___; -- Hawaii state code
Edit and Run Code