explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wNEe

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

Nested Loop Left Join (cost=5.02..35.02 rows=1 width=2) (actual time=0.047..0.048 rows=0 loops=1)

2. 0.046 0.046 ↓ 0.0 0 1

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

  • Index Cond: ("treatmentPlanId" = '087f7ecb-80a3-4749-9786-1782ebaf443e'::uuid)
  • Filter: "inHouse
  • Rows Removed by Filter: 1
3. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=4.74..26.71 rows=1 width=32) (never executed)

4. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on "medicalImageRequestResults" x5 (cost=4.30..12.19 rows=2 width=48) (never executed)

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

Bitmap Index Scan on "medicalImageRequestResultRequestId" (cost=0.00..4.30 rows=2 width=0) (never executed)

  • 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 : 2.564 ms
Execution time : 0.097 ms