explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pKRo

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

Hash Right Join (cost=42.32..69.64 rows=18 width=536) (actual time=0.018..0.019 rows=0 loops=1)

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

Hash Join (cost=23.02..50.23 rows=40 width=8) (never executed)

  • Hash Cond: (dob.drift_id = d_1.drift_id)
3. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=11.45..38.55 rows=40 width=8) (never executed)

4. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=11.30..25.27 rows=40 width=8) (never executed)

  • Hash Cond: (ds.drift_step_id = sp.step_id)
5. 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)

6. 0.000 0.000 ↓ 0.0 0

Hash (cost=10.80..10.80 rows=40 width=8) (never executed)

7. 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: (NOT deleted)
8. 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)
9. 0.000 0.000 ↓ 0.0 0

Hash (cost=10.70..10.70 rows=70 width=4) (never executed)

10. 0.000 0.000 ↓ 0.0 0

Seq Scan on imt_iamsar_drift d_1 (cost=0.00..10.70 rows=70 width=4) (never executed)

11. 0.002 0.009 ↓ 0.0 0 1

Hash (cost=10.70..10.70 rows=35 width=528) (actual time=0.008..0.009 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
12. 0.007 0.007 ↓ 0.0 0 1

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

  • Filter: (NOT deleted)
13.          

SubPlan (for Hash Right Join)

14. 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)
Planning time : 1.542 ms
Execution time : 0.131 ms