explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8KX

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 0.101 ↑ 9.0 2 1

Hash Right Join (cost=50.14..73.88 rows=18 width=528) (actual time=0.100..0.101 rows=2 loops=1)

  • Hash Cond: (d_1.drift_id = d.drift_id)
  • Filter: ((sp.linked_incident_id IS NULL) OR (hashed SubPlan 1))
2. 0.000 0.066 ↓ 0.0 0 1

Nested Loop (cost=22.42..46.11 rows=20 width=8) (actual time=0.066..0.066 rows=0 loops=1)

3. 0.001 0.066 ↓ 0.0 0 1

Nested Loop (cost=22.28..38.90 rows=20 width=8) (actual time=0.066..0.066 rows=0 loops=1)

4. 0.023 0.065 ↓ 0.0 0 1

Hash Join (cost=22.13..25.65 rows=20 width=8) (actual time=0.065..0.065 rows=0 loops=1)

  • Hash Cond: (ds.drift_step_id = sp.step_id)
5. 0.007 0.007 ↑ 96.0 1 1

Seq Scan on imt_iamsar_drift_step ds (cost=0.00..2.96 rows=96 width=8) (actual time=0.007..0.007 rows=1 loops=1)

6. 0.000 0.035 ↓ 0.0 0 1

Hash (cost=21.88..21.88 rows=20 width=8) (actual time=0.035..0.035 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
7. 0.006 0.035 ↓ 0.0 0 1

Hash Join (cost=10.97..21.88 rows=20 width=8) (actual time=0.034..0.035 rows=0 loops=1)

  • Hash Cond: (sp.linked_incident_id = i.incident_id)
8. 0.022 0.022 ↑ 40.0 1 1

Seq Scan on sp_search_plan sp (cost=0.00..10.80 rows=40 width=8) (actual time=0.022..0.022 rows=1 loops=1)

  • Filter: (NOT deleted)
9. 0.001 0.007 ↓ 0.0 0 1

Hash (cost=10.60..10.60 rows=30 width=4) (actual time=0.006..0.007 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
10. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on im_incident i (cost=0.00..10.60 rows=30 width=4) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: (NOT deleted)
  • Rows Removed by Filter: 2
11. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (drift_object_id = ds.drift_object_id)
12. 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
13. 0.006 0.025 ↑ 17.5 2 1

Hash (cost=10.70..10.70 rows=35 width=528) (actual time=0.025..0.025 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
14. 0.019 0.019 ↑ 17.5 2 1

Seq Scan on imt_iamsar_drift d (cost=0.00..10.70 rows=35 width=528) (actual time=0.018..0.019 rows=2 loops=1)

  • Filter: (NOT deleted)
15.          

SubPlan (for Hash Right Join)

16. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.28..16.58 rows=1 width=4) (never executed)

17. 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 = 13)
18. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (incident_id = sp_1.linked_incident_id)
  • Heap Fetches: 0
Planning time : 3.456 ms
Execution time : 0.369 ms