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
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