explain.depesz.com

PostgreSQL's explain analyze made readable

Result: o6NO

Settings
# exclusive inclusive rows x rows loops node
1. 0.292 101,385.867 ↓ 1.0 1,010 1

Sort (cost=6,419,715.93..6,419,718.45 rows=1,008 width=16) (actual time=101,385.809..101,385.867 rows=1,010 loops=1)

  • Sort Key: bod_vykonu_kod DESC
  • Sort Method: quicksort Memory: 72kB
  • Buffers: shared hit=288 read=2,614,643
  • Functions: 3
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 0.580 ms, Inlining 314.124 ms, Optimization 28.533 ms, Emission 29.013 ms, Total 372.250 ms
2. 44,445.585 101,385.575 ↓ 1.0 1,010 1

HashAggregate (cost=6,419,655.56..6,419,665.64 rows=1,008 width=16) (actual time=101,385.364..101,385.575 rows=1,010 loops=1)

  • Group Key: bod_vykonu_kod
  • Buffers: shared hit=288 read=2,614,643
3. 56,939.990 56,939.990 ↑ 1.0 253,648,288 1

Seq Scan on cdc_s5_zdroj (cost=0.00..5,151,414.04 rows=253,648,304 width=8) (actual time=4.934..56,939.990 rows=253,648,288 loops=1)

  • Buffers: shared hit=288 read=2,614,643JIT: