explain.depesz.com

PostgreSQL's explain analyze made readable

Result: A43m

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Subquery Scan on t (cost=511,453,324.34..580,502,812.34 rows=613,773,227 width=20) (actual rows= loops=)

  • Filter: (t.row_number < 2)
2. 0.000 0.000 ↓ 0.0

WindowAgg (cost=511,453,324.34..557,486,316.34 rows=1,841,319,680 width=20) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Sort (cost=511,453,324.34..516,056,623.54 rows=1,841,319,680 width=12) (actual rows= loops=)

  • Sort Key: weatherhourlyclimatology.keympwszipcountry, weatherhourlyclimatology.mpwsdoyutc, weatherhourlyclimatology.mpwshourutc, weatherhourlyclimatology.mpwseffectivefromdate
4. 0.000 0.000 ↓ 0.0

Seq Scan on weatherhourlyclimatology (cost=0.00..102,220,316.80 rows=1,841,319,680 width=12) (actual rows= loops=)