explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xVRy

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 0.082 ↑ 1.0 1 1

Nested Loop Left Join (cost=5.02..35.02 rows=1 width=2) (actual time=0.077..0.082 rows=1 loops=1)

2. 0.049 0.049 ↑ 1.0 1 1

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

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

Nested Loop (cost=4.74..26.71 rows=1 width=32) (actual time=0.026..0.026 rows=0 loops=1)

4. 0.002 0.023 ↓ 0.0 0 1

Bitmap Heap Scan on "medicalImageRequestResults" x5 (cost=4.30..12.19 rows=2 width=48) (actual time=0.022..0.023 rows=0 loops=1)

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

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

  • Index Cond: ("medicalImageRequests".id = "medicalImageRequestId")
6. 0.000 0.000 ↓ 0.0 0

Index Scan using events_pkey on events (cost=0.43..7.25 rows=1 width=16) (never executed)

  • Index Cond: (id = x5."eventId")
  • Filter: (("supersededBy" IS NULL) AND (deleted IS NULL))
Planning time : 0.680 ms
Execution time : 0.184 ms