explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NoRY

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 9.660 ↓ 5.0 5 1

Unique (cost=107.22..107.22 rows=1 width=8) (actual time=9.658..9.660 rows=5 loops=1)

2. 0.034 9.658 ↓ 5.0 5 1

Sort (cost=107.22..107.22 rows=1 width=8) (actual time=9.657..9.658 rows=5 loops=1)

  • Sort Key: lfg.location_id
  • Sort Method: quicksort Memory: 25kB
3. 0.166 9.624 ↓ 5.0 5 1

Nested Loop (cost=1.83..107.21 rows=1 width=8) (actual time=0.194..9.624 rows=5 loops=1)

4. 0.244 6.706 ↓ 344.0 344 1

Nested Loop (cost=1.27..104.61 rows=1 width=24) (actual time=0.134..6.706 rows=344 loops=1)

5. 0.143 2.250 ↓ 351.0 351 1

Nested Loop (cost=0.71..102.02 rows=1 width=16) (actual time=0.084..2.250 rows=351 loops=1)

6. 0.699 0.699 ↓ 9.5 352 1

Index Scan using user_loc_user_id on user_location ul (cost=0.42..16.63 rows=37 width=8) (actual time=0.053..0.699 rows=352 loops=1)

  • Index Cond: (user_id = 3397025)
7. 1.408 1.408 ↑ 1.0 1 352

Index Scan using idx_location_id_del on location loc (cost=0.29..2.31 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=352)

  • Index Cond: (id = ul.location_id)
  • Filter: (corporation_id = 70683)
8. 4.212 4.212 ↑ 1.0 1 351

Index Scan using idx_loc_flag_del on location_flag lf (cost=0.56..2.58 rows=1 width=8) (actual time=0.012..0.012 rows=1 loops=351)

  • Index Cond: ((location_id = loc.id) AND (flag_id = 14))
  • Filter: (value = 'Yes'::text)
  • Rows Removed by Filter: 0
9. 2.752 2.752 ↓ 0.0 0 344

Index Scan using idx_loc_flag_del on location_flag lfg (cost=0.56..2.58 rows=1 width=8) (actual time=0.008..0.008 rows=0 loops=344)

  • Index Cond: ((location_id = loc.id) AND (flag_id = 300))
  • Filter: (value = 'No'::text)
  • Rows Removed by Filter: 1