explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kdeW

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.067 ↓ 0.0 0 1

Nested Loop (cost=5.02..27.77 rows=1 width=2) (actual time=0.066..0.067 rows=0 loops=1)

2. 0.006 0.065 ↓ 0.0 0 1

Nested Loop (cost=4.59..20.51 rows=1 width=40) (actual time=0.064..0.065 rows=0 loops=1)

3. 0.041 0.041 ↑ 1.0 1 1

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

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

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

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

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

  • Index Cond: ("medicalImageRequestId" = "medicalImageRequests".id)
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") AND (id IS NOT NULL))
  • Filter: (("supersededBy" IS NULL) AND (deleted IS NULL))
Planning time : 0.789 ms
Execution time : 0.123 ms