explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ACFU

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 103,758.380 ↓ 0.0 0 1

Insert on ivbal (cost=1,078,424.79..1,190,472.92 rows=1 width=235) (actual time=103,758.380..103,758.380 rows=0 loops=1)

2. 4,827.957 103,758.378 ↓ 0.0 0 1

Merge Anti Join (cost=1,078,424.79..1,190,472.92 rows=1 width=235) (actual time=103,758.378..103,758.378 rows=0 loops=1)

  • Merge Cond: ((s.division = t.division) AND (s."IBITEM" = t."IBITEM") AND (s."IBWHSE" = t."IBWHSE"))
3. 22,496.613 94,419.498 ↓ 1.0 4,179,175 1

Sort (cost=1,078,424.68..1,080,513.99 rows=4,178,630 width=187) (actual time=89,683.287..94,419.498 rows=4,179,175 loops=1)

  • Sort Key: s.division, s."IBITEM", s."IBWHSE
  • Sort Method: external merge Disk: 827,688kB
4. 71,922.885 71,922.885 ↓ 1.0 4,179,175 1

Seq Scan on ivbal s (cost=0.00..711,069.89 rows=4,178,630 width=187) (actual time=0.635..71,922.885 rows=4,179,175 loops=1)

5. 4,510.923 4,510.923 ↓ 1.0 4,179,175 1

Index Only Scan using ivbal_mkey on ivbal t (cost=0.11..96,759.19 rows=4,169,771 width=17) (actual time=3.013..4,510.923 rows=4,179,175 loops=1)