explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yDhO

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.200 2.735 ↑ 1.4 14 1

Nested Loop (cost=0.29..3,350.17 rows=19 width=30) (actual time=0.775..2.735 rows=14 loops=1)

2. 0.083 0.083 ↑ 1.0 613 1

Seq Scan on se_fatalities f (cost=0.00..12.13 rows=613 width=21) (actual time=0.010..0.083 rows=613 loops=1)

3. 2.452 2.452 ↓ 0.0 0 613

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

  • Index Cond: (event_id = f.event_id)
  • Filter: (state = 'NEW YORK'::text)
  • Rows Removed by Filter: 1
Planning time : 0.468 ms
Execution time : 2.763 ms