explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rX7V

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 1.059 ↓ 0.0 0 1

Unique (cost=24.30..24.30 rows=1 width=8) (actual time=1.059..1.059 rows=0 loops=1)

2. 0.026 1.059 ↓ 0.0 0 1

Sort (cost=24.30..24.30 rows=1 width=8) (actual time=1.059..1.059 rows=0 loops=1)

  • Sort Key: lfg.location_id
  • Sort Method: quicksort Memory: 25kB
3. 0.001 1.033 ↓ 0.0 0 1

Nested Loop Left Join (cost=5.89..24.29 rows=1 width=8) (actual time=1.033..1.033 rows=0 loops=1)

4. 0.001 1.032 ↓ 0.0 0 1

Hash Join (cost=5.33..21.69 rows=1 width=8) (actual time=1.032..1.032 rows=0 loops=1)

  • Hash Cond: (ul.location_id = loc.id)
5. 1.031 1.031 ↓ 0.0 0 1

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

  • Index Cond: (user_id = 299)
6. 0.000 0.000 ↓ 0.0 0

Hash (cost=4.90..4.90 rows=1 width=16) (never executed)

7. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.85..4.90 rows=1 width=16) (never executed)

8. 0.000 0.000 ↓ 0.0 0

Index Scan using i_loc_corp_id on location loc (cost=0.29..2.31 rows=1 width=8) (never executed)

  • Index Cond: (corporation_id = 105)
9. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_loc_flag_del on location_flag lf (cost=0.56..2.58 rows=1 width=8) (never executed)

  • Index Cond: ((location_id = loc.id) AND (flag_id = 14))
  • Filter: (value = 'Yes'::text)
10. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_loc_flag_del on location_flag lfg (cost=0.56..2.58 rows=1 width=8) (never executed)

  • Index Cond: ((location_id = ul.location_id) AND (flag_id = 300))
  • Filter: (value = 'No'::text)