explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rGCi

Settings
# exclusive inclusive rows x rows loops node
1. 0.024 9.849 ↓ 6.0 6 1
→

Unique (cost=107.22..107.22 rows=1 width=8) (actual time=9.806..9.849 rows=6 loops=1)

2. 0.181 9.825 ↓ 344.0 344 1
→

Sort (cost=107.22..107.22 rows=1 width=8) (actual time=9.805..9.825 rows=344 loops=1)

  • Sort Key: lfg.location_id
  • Sort Method: quicksort Memory: 35kB
3. 0.199 9.644 ↓ 344.0 344 1
→

Nested Loop Left Join (cost=1.83..107.21 rows=1 width=8) (actual time=0.173..9.644 rows=344 loops=1)

4. 0.230 6.693 ↓ 344.0 344 1
→

Nested Loop (cost=1.27..104.61 rows=1 width=8) (actual time=0.146..6.693 rows=344 loops=1)

5. 0.152 2.251 ↓ 351.0 351 1
→

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

6. 0.691 0.691 ↓ 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.051..0.691 rows=352 loops=1)

  • Index Cond: (user_id = 3,397,025)
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 = 70,683)
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 = ul.location_id) AND (flag_id = 300))
  • Filter: (value = 'No'::text)
  • Rows Removed by Filter: 1