explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PvwW

Settings
# exclusive inclusive rows x rows loops node
1. 0.046 0.111 ↑ 6.0 3 1

Seq Scan on imt_iamsar_drift d (cost=13.25..24.12 rows=18 width=528) (actual time=0.106..0.111 rows=3 loops=1)

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

SubPlan (for Seq Scan)

3. 0.002 0.065 ↓ 0.0 0 1

Nested Loop (cost=2.68..13.25 rows=1 width=4) (actual time=0.065..0.065 rows=0 loops=1)

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

Nested Loop (cost=2.68..12.03 rows=1 width=8) (actual time=0.063..0.063 rows=0 loops=1)

5. 0.001 0.062 ↓ 0.0 0 1

Nested Loop (cost=2.53..11.67 rows=1 width=8) (actual time=0.062..0.062 rows=0 loops=1)

6. 0.002 0.061 ↓ 0.0 0 1

Nested Loop (cost=2.39..11.07 rows=1 width=8) (actual time=0.060..0.061 rows=0 loops=1)

7. 0.003 0.059 ↓ 0.0 0 1

Merge Join (cost=2.25..2.40 rows=1 width=8) (actual time=0.059..0.059 rows=0 loops=1)

  • Merge Cond: (ds.drift_step_id = sp.step_id)
8. 0.028 0.028 ↑ 112.0 1 1

Index Scan using idx_imt_iamsar_asw_worksheet_step_drift on imt_iamsar_drift_step ds (cost=0.14..14.82 rows=112 width=8) (actual time=0.027..0.028 rows=1 loops=1)

9. 0.011 0.028 ↓ 0.0 0 1

Sort (cost=1.17..1.17 rows=1 width=8) (actual time=0.028..0.028 rows=0 loops=1)

  • Sort Key: sp.step_id
  • Sort Method: quicksort Memory: 25kB
10. 0.017 0.017 ↓ 0.0 0 1

Seq Scan on sp_search_plan sp (cost=0.00..1.16 rows=1 width=8) (actual time=0.016..0.017 rows=0 loops=1)

  • Filter: ((linked_incident_id IS NOT NULL) AND (NOT deleted) AND (step_id IS NOT NULL))
  • Rows Removed by Filter: 17
11. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_im_incident on im_incident i (cost=0.14..8.16 rows=1 width=4) (never executed)

  • Index Cond: (incident_id = sp.linked_incident_id)
  • Filter: (NOT deleted)
12. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (drift_object_id = ds.drift_object_id)
13. 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.36 rows=1 width=4) (never executed)

  • Index Cond: (drift_id = dob.drift_id)
  • Heap Fetches: 0
14. 0.000 0.000 ↓ 0.0 0

Seq Scan on sp_search_plan sp_1 (cost=0.00..1.20 rows=1 width=4) (never executed)

  • Filter: (search_plan_id = 3)
Planning time : 2.556 ms
Execution time : 0.321 ms