explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bHp6 : Cleared cache, 266s

Settings
# exclusive inclusive rows x rows loops node
1. 0.413 145,284.125 ↓ 1.0 1,010 1

Sort (cost=6,419,715.93..6,419,718.45 rows=1,008 width=16) (actual time=145,284.067..145,284.125 rows=1,010 loops=1)

  • Sort Key: bod_vykonu_kod DESC
  • Sort Method: quicksort Memory: 72kB
  • Buffers: shared hit=512 read=2,614,419
  • Functions: 3
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 0.693 ms, Inlining 9.087 ms, Optimization 19.286 ms, Emission 12.741 ms, Total 41.806 ms
2. 52,626.692 145,283.712 ↓ 1.0 1,010 1

HashAggregate (cost=6,419,655.56..6,419,665.64 rows=1,008 width=16) (actual time=145,283.491..145,283.712 rows=1,010 loops=1)

  • Group Key: bod_vykonu_kod
  • Buffers: shared hit=512 read=2,614,419
3. 92,657.020 92,657.020 ↑ 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=2.499..92,657.020 rows=253,648,288 loops=1)

  • Buffers: shared hit=512 read=2,614,419JIT: