explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pnoS : Optimization for: plan #EZug

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.010 0.057 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.18..7.15 rows=1 width=11,370) (actual time=0.054..0.057 rows=1 loops=1)

  • Join Filter: (dbuser0_.uid = dbpractice4_.user_account_uid)
2. 0.001 0.042 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.18..4.98 rows=1 width=7,129) (actual time=0.039..0.042 rows=1 loops=1)

  • Join Filter: (dbuser0_.uid = roles2_.user_account_uid)
3. 0.002 0.038 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.18..3.79 rows=1 width=6,597) (actual time=0.036..0.038 rows=1 loops=1)

  • Join Filter: (dbuser0_.uid = features1_.user_account_uid)
4. 0.013 0.033 ↑ 1.0 1 1

Hash Right Join (cost=1.18..2.67 rows=1 width=6,549) (actual time=0.032..0.033 rows=1 loops=1)

  • Hash Cond: (dbasset3_.uid = dbuser0_.logo_uid)
5. 0.005 0.005 ↑ 1.0 35 1

Seq Scan on asset dbasset3_ (cost=0.00..1.35 rows=35 width=1,096) (actual time=0.003..0.005 rows=35 loops=1)

6. 0.004 0.015 ↑ 1.0 1 1

Hash (cost=1.16..1.16 rows=1 width=5,453) (actual time=0.015..0.015 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
7. 0.011 0.011 ↑ 1.0 1 1

Seq Scan on user_account dbuser0_ (cost=0.00..1.16 rows=1 width=5,453) (actual time=0.010..0.011 rows=1 loops=1)

  • Filter: (uid = '1b951370-9f8e-458d-8fde-64d702a1fa55'::uuid)
  • Rows Removed by Filter: 12
8. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on user_feature features1_ (cost=0.00..1.11 rows=1 width=48) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (user_account_uid = '1b951370-9f8e-458d-8fde-64d702a1fa55'::uuid)
  • Rows Removed by Filter: 9
9. 0.003 0.003 ↑ 1.0 1 1

Seq Scan on user_role roles2_ (cost=0.00..1.18 rows=1 width=532) (actual time=0.002..0.003 rows=1 loops=1)

  • Filter: (user_account_uid = '1b951370-9f8e-458d-8fde-64d702a1fa55'::uuid)
  • Rows Removed by Filter: 13
10. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on practice_details dbpractice4_ (cost=0.00..1.07 rows=1 width=4,176) (actual time=0.002..0.003 rows=0 loops=1)

  • Filter: (user_account_uid = '1b951370-9f8e-458d-8fde-64d702a1fa55'::uuid)
  • Rows Removed by Filter: 6
11.          

SubPlan (for Nested Loop Left Join)

12. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on practice_details p (cost=0.00..1.07 rows=1 width=516) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (user_account_uid = dbuser0_.uid)
  • Rows Removed by Filter: 6
Planning time : 0.385 ms
Execution time : 0.170 ms