explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CUc3

Settings
# exclusive inclusive rows x rows loops node
1. 0.369 1.237 ↑ 1.8 14 1

Nested Loop (cost=0.29..3,956.64 rows=25 width=30) (actual time=0.258..1.237 rows=14 loops=1)

2. 0.066 0.066 ↑ 1.0 802 1

Seq Scan on se_fatalities f (cost=0.00..16.02 rows=802 width=21) (actual time=0.004..0.066 rows=802 loops=1)

3. 0.802 0.802 ↓ 0.0 0 802

Index Scan using se_details_pkey on se_details d (cost=0.29..4.91 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=802)

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