explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rN6y

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

Seq Scan on imt_iamsar_drift d (cost=57.87..68.75 rows=18 width=528) (actual time=0.008..0.009 rows=0 loops=1)

  • Filter: ((NOT deleted) AND (NOT (hashed SubPlan 1)))
2.          

SubPlan (for Seq Scan)

3. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=22.56..57.82 rows=20 width=4) (never executed)

  • Join Filter: ((sp_1.linked_incident_id IS NULL) OR (sp.linked_incident_id <> sp_1.linked_incident_id))
4. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_sp_search_plan on sp_search_plan sp_1 (cost=0.14..8.16 rows=1 width=4) (never executed)

  • Index Cond: (search_plan_id = 3)
5. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=22.42..49.41 rows=20 width=8) (never executed)

6. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=22.28..42.54 rows=20 width=8) (never executed)

7. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=22.13..35.91 rows=20 width=8) (never executed)

  • Hash Cond: (ds.drift_step_id = sp.step_id)
8. 0.000 0.000 ↓ 0.0 0

Seq Scan on imt_iamsar_drift_step ds (cost=0.00..12.60 rows=260 width=8) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Hash (cost=21.88..21.88 rows=20 width=8) (never executed)

10. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=10.97..21.88 rows=20 width=8) (never executed)

  • Hash Cond: (sp.linked_incident_id = i.incident_id)
11. 0.000 0.000 ↓ 0.0 0

Seq Scan on sp_search_plan sp (cost=0.00..10.80 rows=40 width=8) (never executed)

  • Filter: ((linked_incident_id IS NOT NULL) AND (NOT deleted) AND (step_id IS NOT NULL))
12. 0.000 0.000 ↓ 0.0 0

Hash (cost=10.60..10.60 rows=30 width=4) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Seq Scan on im_incident i (cost=0.00..10.60 rows=30 width=4) (never executed)

  • Filter: (NOT deleted)
14. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_iamsar_drift_object on imt_iamsar_drift_object dob (cost=0.14..0.33 rows=1 width=8) (never executed)

  • Index Cond: (drift_object_id = ds.drift_object_id)
15. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_imt_iamsar_drift on imt_iamsar_drift d_1 (cost=0.14..0.34 rows=1 width=4) (never executed)

  • Index Cond: (drift_id = dob.drift_id)
  • Heap Fetches: 0
Planning time : 2.191 ms
Execution time : 0.149 ms