explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AIqq : Optimization for: plan #EZug

Settings

Optimization path:

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

Nested Loop Left Join (cost=5.41..51.87 rows=1 width=2,029) (actual time=0.017..0.017 rows=0 loops=1)

  • Join Filter: (dbuser0_.uid = dbpractice4_.user_account_uid)
2. 0.000 0.017 ↓ 0.0 0 1

Nested Loop Left Join (cost=5.14..35.26 rows=1 width=1,819) (actual time=0.017..0.017 rows=0 loops=1)

3. 0.001 0.017 ↓ 0.0 0 1

Nested Loop Left Join (cost=4.86..26.96 rows=1 width=1,703) (actual time=0.017..0.017 rows=0 loops=1)

  • Join Filter: (dbuser0_.uid = roles2_.user_account_uid)
4. 0.000 0.016 ↓ 0.0 0 1

Nested Loop Left Join (cost=4.58..18.65 rows=1 width=1,679) (actual time=0.016..0.016 rows=0 loops=1)

  • Join Filter: (dbuser0_.uid = features1_.user_account_uid)
5. 0.016 0.016 ↓ 0.0 0 1

Index Scan using user_account_pkey on user_account dbuser0_ (cost=0.28..8.30 rows=1 width=1,646) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (uid = '5539f5e6-f17f-4ce8-9c3b-1d9c824d0481'::uuid)
6. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on user_feature features1_ (cost=4.30..10.32 rows=2 width=33) (never executed)

  • Recheck Cond: (user_account_uid = '5539f5e6-f17f-4ce8-9c3b-1d9c824d0481'::uuid)
7. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on user_feature_pkey (cost=0.00..4.29 rows=2 width=0) (never executed)

  • Index Cond: (user_account_uid = '5539f5e6-f17f-4ce8-9c3b-1d9c824d0481'::uuid)
8. 0.000 0.000 ↓ 0.0 0

Index Only Scan using user_role_pkey on user_role roles2_ (cost=0.28..8.30 rows=1 width=24) (never executed)

  • Index Cond: (user_account_uid = '5539f5e6-f17f-4ce8-9c3b-1d9c824d0481'::uuid)
  • Heap Fetches: 0
9. 0.000 0.000 ↓ 0.0 0

Index Scan using asset_pkey on asset dbasset3_ (cost=0.28..8.29 rows=1 width=116) (never executed)

  • Index Cond: (dbuser0_.logo_uid = uid)
10. 0.000 0.000 ↓ 0.0 0

Index Scan using practice_details_user_account_uid_idx on practice_details dbpractice4_ (cost=0.28..8.29 rows=1 width=145) (never executed)

  • Index Cond: (user_account_uid = '5539f5e6-f17f-4ce8-9c3b-1d9c824d0481'::uuid)
11.          

SubPlan (for Nested Loop Left Join)

12. 0.000 0.000 ↓ 0.0 0

Index Scan using practice_details_user_account_uid_idx on practice_details p (cost=0.28..8.29 rows=1 width=21) (never executed)

  • Index Cond: (user_account_uid = dbuser0_.uid)
Planning time : 4.094 ms
Execution time : 0.328 ms