explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8GRq

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 0.078 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.59..20.51 rows=1 width=2) (actual time=0.074..0.078 rows=1 loops=1)

2. 0.050 0.050 ↑ 1.0 1 1

Index Scan using "medicalImageRequestToTreatmentPlanFkIdx" on "medicalImageRequests" (cost=0.29..8.30 rows=1 width=40) (actual time=0.048..0.050 rows=1 loops=1)

  • Index Cond: ("treatmentPlanId" = 'e2eeb162-c5cf-4351-ae33-3f56d1b91359'::uuid)
  • Filter: "inHouse
3. 0.004 0.020 ↓ 0.0 0 1

Bitmap Heap Scan on "medicalImageRequestResults" x5 (cost=4.30..12.19 rows=2 width=32) (actual time=0.019..0.020 rows=0 loops=1)

  • Recheck Cond: ("medicalImageRequests".id = "medicalImageRequestId")
4. 0.016 0.016 ↓ 0.0 0 1

Bitmap Index Scan on "medicalImageRequestResultRequestId" (cost=0.00..4.30 rows=2 width=0) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: ("medicalImageRequests".id = "medicalImageRequestId")
Planning time : 0.580 ms
Execution time : 0.126 ms