explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2kcb

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 2.349 14,860.977 ↑ 149,952.4 350 1

Finalize GroupAggregate (cost=1,712,705.78..9,360,279.16 rows=52,483,344 width=21) (actual time=10,396.012..14,860.977 rows=350 loops=1)

  • Group Key: (lower(valid)), key
2. 0.000 14,858.628 ↑ 18,744.1 2,800 1

Gather Merge (cost=1,712,705.78..8,310,612.26 rows=52,483,347 width=21) (actual time=10,383.384..14,858.628 rows=2,800 loops=1)

  • Workers Planned: 7
  • Workers Launched: 7
3. 14,254.088 114,711.664 ↑ 21,421.8 350 8

Partial GroupAggregate (cost=1,711,705.66..1,880,402.13 rows=7,497,621 width=21) (actual time=10,116.904..14,338.958 rows=350 loops=8)

  • Group Key: (lower(valid)), key
4. 72,297.432 100,457.576 ↑ 1.1 6,562,500 8

Sort (cost=1,711,705.66..1,730,449.71 rows=7,497,621 width=13) (actual time=10,104.913..12,557.197 rows=6,562,500 loops=8)

  • Sort Key: (lower(valid)), key
  • Sort Method: quicksort Memory: 524800kB
  • Worker 0: Sort Method: quicksort Memory: 502717kB
  • Worker 1: Sort Method: quicksort Memory: 499411kB
  • Worker 2: Sort Method: quicksort Memory: 499600kB
  • Worker 3: Sort Method: quicksort Memory: 499283kB
  • Worker 4: Sort Method: quicksort Memory: 501857kB
  • Worker 5: Sort Method: quicksort Memory: 503464kB
  • Worker 6: Sort Method: quicksort Memory: 502673kB
5. 28,160.144 28,160.144 ↑ 1.1 6,562,500 8

Parallel Seq Scan on event_series (cost=0.00..855,552.26 rows=7,497,621 width=13) (actual time=0.135..3,520.018 rows=6,562,500 loops=8)

Planning time : 0.111 ms
Execution time : 14,895.602 ms