explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sWYx

Settings
# exclusive inclusive rows x rows loops node
1. 978.502 7,859.404 ↓ 0.0 0 1

Finalize GroupAggregate (cost=467,529.56..614,297.07 rows=427,458 width=20) (actual time=7,859.404..7,859.404 rows=0 loops=1)

  • Group Key: keympwszipcountry, mpwsdoyutc, mpwshourutc, mpwseffectivefromdate
  • Filter: (count(*) > 1)
  • Rows Removed by Filter: 4274605
2. 1,723.305 6,880.902 ↓ 5.0 4,274,605 1

Gather Merge (cost=467,529.56..597,198.75 rows=854,916 width=20) (actual time=4,514.648..6,880.902 rows=4,274,605 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 388.608 5,157.597 ↓ 3.3 1,424,868 3 / 3

Partial GroupAggregate (cost=466,529.54..497,520.21 rows=427,458 width=20) (actual time=4,505.069..5,157.597 rows=1,424,868 loops=3)

  • Group Key: keympwszipcountry, mpwsdoyutc, mpwshourutc, mpwseffectivefromdate
4. 952.024 4,768.989 ↑ 1.2 1,424,868 3 / 3

Sort (cost=466,529.54..470,982.22 rows=1,781,073 width=12) (actual time=4,505.064..4,768.989 rows=1,424,868 loops=3)

  • Sort Key: keympwszipcountry, mpwsdoyutc, mpwshourutc, mpwseffectivefromdate
  • Sort Method: external merge Disk: 31640kB
5. 3,816.965 3,816.965 ↑ 1.2 1,424,868 3 / 3

Parallel Seq Scan on weatherhourlyclimatology (cost=0.00..220,736.73 rows=1,781,073 width=12) (actual time=0.592..3,816.965 rows=1,424,868 loops=3)

Planning time : 0.113 ms