explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DqMU

Settings
# exclusive inclusive rows x rows loops node
1. 0.062 2.639 ↑ 1.3 14 1

Nested Loop (cost=0.29..3,330.17 rows=18 width=30) (actual time=0.569..2.639 rows=14 loops=1)

2. 0.125 0.125 ↑ 1.0 613 1

Seq Scan on se_fatalities f (cost=0.00..12.13 rows=613 width=21) (actual time=0.018..0.125 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.41 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.421 ms