explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Nusue : Optimization for: plan #EZug

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.001 0.648 ↓ 0.0 0 1

Nested Loop (cost=0.70..25.18 rows=1 width=920) (actual time=0.648..0.648 rows=0 loops=1)

2. 0.647 0.647 ↓ 0.0 0 1

Index Scan using screening_pkey on screening dbscreenin0_ (cost=0.29..8.31 rows=1 width=904) (actual time=0.647..0.647 rows=0 loops=1)

  • Index Cond: (uid = 'a4d1b3c4-d281-4ed4-bf96-2d899ae8ae20'::uuid)
  • Filter: (cancellation_date IS NULL)
3. 0.000 0.000 ↓ 0.0 0

Index Only Scan using screening_access_right_screening_uid_has_referent_right_idx on screening_attributes_per_user attributes1_ (cost=0.41..8.43 rows=1 width=16) (never executed)

  • Index Cond: (screening_uid = 'a4d1b3c4-d281-4ed4-bf96-2d899ae8ae20'::uuid)
  • Heap Fetches: 0
4.          

SubPlan (for Nested Loop)

5. 0.000 0.000 ↓ 0.0 0

Index Scan using screening_access_right_screening_uid_has_access_right_idx on screening_attributes_per_user sr (cost=0.41..8.43 rows=1 width=16) (never executed)

  • Index Cond: (screening_uid = dbscreenin0_.uid)
  • Filter: has_referent_right
Planning time : 50.125 ms
Execution time : 3.219 ms