explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NwSQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.665 ↑ 1.0 1 1

Limit (cost=0.71..18.07 rows=1 width=98) (actual time=0.664..0.665 rows=1 loops=1)

2. 0.004 0.663 ↑ 745.0 1 1

Nested Loop (cost=0.71..12,933.86 rows=745 width=98) (actual time=0.663..0.663 rows=1 loops=1)

3. 0.651 0.651 ↑ 745.0 1 1

Index Scan Backward using idx_event_location_id on event e (cost=0.29..8,312.47 rows=745 width=8) (actual time=0.651..0.651 rows=1 loops=1)

  • Filter: (load_id = '2135777003607951153'::bigint)
  • Rows Removed by Filter: 1,600
4. 0.008 0.008 ↑ 1.0 1 1

Index Scan using idx_location_id on location l (cost=0.42..6.19 rows=1 width=98) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: (id = e.location_id)
Planning time : 0.312 ms
Execution time : 0.761 ms