explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HdCH : Optimization for: Optimization for: Optimization for: Optimization for: plan #9Iy7; plan #mMEL; plan #mXgnD; plan #3lUM

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 290.677 1,223.085 ↓ 1.1 12 1

HashAggregate (cost=110,628.6..110,628.71 rows=11 width=4) (actual time=1,223.082..1,223.085 rows=12 loops=1)

  • Group Key: incidentrecord.dest_port
  • Buffers: shared hit=1,495 read=102,051
2. 932.408 932.408 ↑ 1.0 565,577 1

Seq Scan on incidentrecord incidentrecord (cost=0..109,212.08 rows=566,608 width=4) (actual time=0.007..932.408 rows=565,577 loops=1)

  • Buffers: shared hit=1,495 read=102,051