explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QSL0

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 3.325 ↑ 9.8 5 1

Sort (cost=3,336.44..3,336.56 rows=49 width=81) (actual time=3.324..3.325 rows=5 loops=1)

  • Sort Key: (avg(f.fatality_age))
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1,843
2. 0.061 3.307 ↑ 9.8 5 1

GroupAggregate (cost=3,333.84..3,335.06 rows=49 width=81) (actual time=3.278..3.307 rows=5 loops=1)

  • Group Key: d.state
  • Buffers: shared hit=1,843
3. 3.246 3.246 ↓ 1.7 82 1

Sort (cost=3,333.84..3,333.96 rows=49 width=11) (actual time=3.235..3.246 rows=82 loops=1)

  • Sort Key: d.state
  • Sort Method: quicksort Memory: 28kB
  • Buffers: shared hit=1,843
  • -> Nested Loop (cost=0.29..3332.46 rows=49 width=11) (actual time=0.282..3.145 rows=82 loops=1
  • Buffers: shared hit=1,843
  • -> Seq Scan on se_fatalities f (cost=0.00..12.13 rows=613 width=6) (actual time=0.029..0
  • Buffers: shared hit=6
  • -> Index Scan using se_details_pkey on se_details d (cost=0.29..5.42 rows=1 width=13) (a
  • Index Cond: (event_id = f.event_id)
  • Filter: (state = ANY ('{"NEW YORK",CONNECTICUT,GEORGIA,CALIFORNIA,OREGON}'::text[]))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=1,837