explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rr9b : 19s

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 18,391.236 ↓ 1.0 1,010 1

Finalize GroupAggregate (cost=3,567,172.56..3,567,685.57 rows=1,008 width=16) (actual time=18,389.309..18,391.236 rows=1,010 loops=1)

  • Group Key: bod_vykonu_kod
  • Buffers: shared hit=85 read=540,654
  • Functions: 22
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 5.422 ms, Inlining 1374.725 ms, Optimization 169.360 ms, Emission 162.044 ms, Total 1711.551 ms
2. 50.993 18,414.262 ↓ 1.3 5,046 1

Gather Merge (cost=3,567,172.56..3,567,655.33 rows=4,032 width=16) (actual time=18,389.285..18,414.262 rows=5,046 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
  • Buffers: shared hit=352 read=2,614,611
3. 0.403 18,363.269 ↓ 1.0 1,009 5 / 5

Sort (cost=3,566,172.51..3,566,175.03 rows=1,008 width=16) (actual time=18,363.197..18,363.269 rows=1,009 loops=5)

  • Sort Key: bod_vykonu_kod DESC
  • Sort Method: quicksort Memory: 72kB
  • Worker 0: Sort Method: quicksort Memory: 72kB
  • Worker 1: Sort Method: quicksort Memory: 72kB
  • Worker 2: Sort Method: quicksort Memory: 72kB
  • Worker 3: Sort Method: quicksort Memory: 72kB
  • Buffers: shared hit=352 read=2,614,611
4. 10,215.315 18,362.866 ↓ 1.0 1,009 5 / 5

Partial HashAggregate (cost=3,566,112.14..3,566,122.22 rows=1,008 width=16) (actual time=18,362.647..18,362.866 rows=1,009 loops=5)

  • Group Key: bod_vykonu_kod
  • Buffers: shared hit=320 read=2,614,611
5. 8,147.551 8,147.551 ↑ 1.3 50,729,658 5 / 5

Parallel Seq Scan on cdc_s5_zdroj (cost=0.00..3,249,051.76 rows=63,412,076 width=8) (actual time=0.130..8,147.551 rows=50,729,658 loops=5)

  • Buffers: shared hit=320 read=2,614,611JIT: