explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Io9

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

Unique (cost=109.53..109.54 rows=1 width=8) (actual time=10.865..10.867 rows=5 loops=1)

2. 0.035 10.865 ↓ 5.0 5 1

Sort (cost=109.53..109.54 rows=1 width=8) (actual time=10.865..10.865 rows=5 loops=1)

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

Nested Loop (cost=2.12..109.52 rows=1 width=8) (actual time=0.254..10.830 rows=5 loops=1)

4. 0.287 7.908 ↓ 344.0 344 1

Nested Loop (cost=1.56..106.93 rows=1 width=24) (actual time=0.181..7.908 rows=344 loops=1)

5. 0.086 3.409 ↓ 351.0 351 1

Nested Loop (cost=1.00..104.34 rows=1 width=16) (actual time=0.133..3.409 rows=351 loops=1)

6. 0.161 2.270 ↓ 351.0 351 1

Nested Loop (cost=0.71..102.02 rows=1 width=24) (actual time=0.081..2.270 rows=351 loops=1)

7. 0.701 0.701 ↓ 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.052..0.701 rows=352 loops=1)

  • Index Cond: (user_id = 3397025)
8. 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=16) (actual time=0.004..0.004 rows=1 loops=352)

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

Index Only Scan using corporation_pkey on corporation corp (cost=0.29..2.31 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=351)

  • Index Cond: (id = 70683)
  • Heap Fetches: 351
10. 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
11. 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