explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bH4t : inc_agg_v2

Settings
# exclusive inclusive rows x rows loops node
1. 0.142 0.753 ↑ 1.0 1 1

Aggregate (cost=11.78..11.81 rows=1 width=32) (actual time=0.751..0.753 rows=1 loops=1)

2. 0.281 0.611 ↓ 2.7 8 1

HashAggregate (cost=11.66..11.70 rows=3 width=24) (actual time=0.595..0.611 rows=8 loops=1)

  • Hash Key: incidents.status
  • Hash Key: incidents.directive_id
  • Hash Key: incidents.severity
3. 0.330 0.330 ↓ 114.0 114 1

Seq Scan on incidents (cost=0.00..11.65 rows=1 width=16) (actual time=0.031..0.330 rows=114 loops=1)

  • Filter: ((registration_time <= now()) AND (registration_time >= (now() - '3600:00:00'::interval)))
Planning time : 0.334 ms
Execution time : 0.919 ms