explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ISOPb

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 1.417 ↑ 9.8 5 1

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

  • Sort Key: (avg(f.fatality_age))
  • Sort Method: quicksort Memory: 25kB
  • Execution Time: 1.483 msSort Key: d.state
2. 0.038 1.403 ↑ 9.8 5 1

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

  • Group Key: d.state
3. 1.365 1.365 ↓ 1.7 82 1

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

4. 0.014 1.417 ↑ 9.8 5 1

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

  • Sort Key: (avg(f.fatality_age))
  • Sort Method: quicksort Memory: 25kB
5. 0.038 1.403 ↑ 9.8 5 1

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

  • Group Key: d.state
6. 0.000 1.365 ↓ 1.7 82 1

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

  • Sort Key: d.state
  • Sort Method: quicksort Memory: 28kB
  • Sort Method: quicksort Memory: 28kB
7. 0.051 1.332 ↓ 1.7 82 1

Nested Loop (cost=0.29..3,332.46 rows=49 width=11) (actual time=0.080..1.332 rows=82 loops=1)

8. 0.055 0.055 ↑ 1.0 613 1

Seq Scan on se_fatalities f (cost=0.00..12.13 rows=613 width=6) (actual time=0.008..0.055 rows=613 loops=1)

9. 1.226 1.226 ↓ 0.0 0 613

Index Scan using se_details_pkey on se_details d (cost=0.29..5.42 rows=1 width=13) (actual time=0.002..0.002 rows=0 loops=613)

  • Index Cond: (event_id = f.event_id)
  • Filter: (state = ANY ('{"NEW YORK",CONNECTICUT,GEORGIA,CALIFORNIA,OREGON}'::text[]))
  • Rows Removed by Filter: 1
10. 0.051 1.332 ↓ 1.7 82 1

Nested Loop (cost=0.29..3,332.46 rows=49 width=11) (actual time=0.080..1.332 rows=82 loops=1)

11. 0.055 0.055 ↑ 1.0 613 1

Seq Scan on se_fatalities f (cost=0.00..12.13 rows=613 width=6) (actual time=0.008..0.055 rows=613 loops=1)

12. 1.226 1.226 ↓ 0.0 0 613

Index Scan using se_details_pkey on se_details d (cost=0.29..5.42 rows=1 width=13) (actual time=0.002..0.002 rows=0 loops=613)

  • Index Cond: (event_id = f.event_id)
  • Filter: (state = ANY ('{"NEW YORK",CONNECTICUT,GEORGIA,CALIFORNIA,OREGON}'::text[]))
  • Rows Removed by Filter: 1
Planning time : 0.402 ms
Execution time : 1.483 ms