explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qoPl : Optimization for: plan #EZug

Settings

Optimization path:

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

Nested Loop (cost=0.00..3.16 rows=1 width=1,043) (actual time=0.008..0.008 rows=0 loops=1)

2. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on screening dbscreenin0_ (cost=0.00..1.05 rows=1 width=1,027) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: ((cancellation_date IS NULL) AND (uid = '1b951370-9f8e-458d-8fde-64d702a1fa55'::uuid))
  • Rows Removed by Filter: 4
3. 0.000 0.000 ↓ 0.0 0

Seq Scan on screening_attributes_per_user attributes1_ (cost=0.00..1.05 rows=1 width=16) (never executed)

  • Filter: (screening_uid = '1b951370-9f8e-458d-8fde-64d702a1fa55'::uuid)
4.          

SubPlan (for Nested Loop)

5. 0.000 0.000 ↓ 0.0 0

Seq Scan on screening_attributes_per_user sr (cost=0.00..1.05 rows=1 width=16) (never executed)

  • Filter: (has_referent_right AND (screening_uid = dbscreenin0_.uid))
Planning time : 0.616 ms
Execution time : 0.029 ms