explain.depesz.com

PostgreSQL's explain analyze made readable

Result: D5gE

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 2,175.257 ↑ 1.0 1 1

Finalize Aggregate (cost=114,276.76..114,276.77 rows=1 width=8) (actual time=2,175.256..2,175.257 rows=1 loops=1)

  • Buffers: shared hit=36410 read=1212
2. 11.504 2,175.329 ↓ 1.5 3 1

Gather (cost=114,276.54..114,276.75 rows=2 width=8) (actual time=2,174.517..2,175.329 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=36410 read=1212
3. 517.758 2,163.825 ↑ 1.0 1 3

Partial Aggregate (cost=113,276.54..113,276.55 rows=1 width=8) (actual time=2,163.825..2,163.825 rows=1 loops=3)

  • Buffers: shared hit=36410 read=1212
4. 1,646.067 1,646.067 ↑ 1.3 1,099,296 3

Parallel Index Only Scan using pk_milly_dfo_by_quarter on dfo_by_quarter (cost=0.43..109,808.99 rows=1,387,020 width=4) (actual time=0.018..1,646.067 rows=1,099,296 loops=3)

  • Index Cond: (release_key = 34)
  • Heap Fetches: 0
  • Buffers: shared hit=36410 read=1212