explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JLZX

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

Unique (cost=563,201,723.23..563,226,864.65 rows=335,219 width=928) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=563,201,723.23..563,202,561.28 rows=335,219 width=928) (actual rows= loops=)

  • Sort Key: hs0001_item_181203.itemnumber, hs0001_item_181203.itemname, hs0001_item_181203.status, hs0001_item_181203.itemtype, hs0001_item_181203.itemtypedesc, hs0001_item_181203.majorgrp, hs0001_item_181203.majorgrpdesc, hs0001_item_181203.minorgrp, hs0001_item_181203.minorgrpdesc, hs0001_item_181203.prodtype, hs0001_item_181203.prodtypedesc, hs0001_item_181203.um, hs0001_item_181203.style, hs0001_item_181203.styledesc, hs0001_item_181203.itemstylecolour, hs0001_item_181203.itemstylecolourfit, hs0001_item_181203.sizing, hs0001_item_181203.size, hs0001_item_181203.reportsize, hs0001_item_181203.fit, hs0001_item_181203.orthotic, hs0001_item_181203.brand, hs0001_item_181203.branddesc, hs0001_item_181203.heelheight, hs0001_item_181203.heelheightdesc, hs0001_item_181203.primarycolour, hs0001_item_181203.primarycolourdesc, hs0001_item_181203.retailcolour, hs0001_item_181203.retailcolourdesc
3. 0.000 0.000 ↓ 0.0

Append (cost=1,000.00..562,898,259.93 rows=335,219 width=928) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Gather (cost=1,000.00..562,848,317.01 rows=111,740 width=211) (actual rows= loops=)

  • Workers Planned: 2
5. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on hs0001_item_181203 (cost=0.00..562,836,143.01 rows=46,558 width=211) (actual rows= loops=)

  • Filter: (NOT (SubPlan 1))
6.          

SubPlan (forParallel Seq Scan)

7. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..11,529.47 rows=223,698 width=15) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on hs0001_item_181130 (cost=0.00..9,317.98 rows=223,698 width=15) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Merge Join (cost=1.03..46,590.73 rows=223,479 width=211) (actual rows= loops=)

  • Merge Cond: (a.itemnumber = b.itemnumber)
  • Join Filter: ((a.itemname <> b.itemname) OR (a.status <> b.status) OR (a.itemtype <> b.itemtype) OR (a.itemtypedesc <> b.itemtypedesc) OR (a.majorgrp <> b.majorgrp) OR (a.majorgrpdesc <> b.majorgrpdesc) OR (a.minorgrp <> b.minorgrp) OR (a.minorgrpdesc <> b.minorgrpdesc) OR (a.prodtype <> b.prodtype) OR (a.prodtypedesc <> b.prodtypedesc) OR (a.um <> b.um) OR (a.style <> b.style) OR (a.styledesc <> b.styledesc) OR (a.itemstylecolour <> b.itemstylecolour) OR (a.itemstylecolourfit <> b.itemstylecolourfit) OR (a.sizing <> b.sizing) OR (a.size <> b.size) OR (a.reportsize <> b.reportsize) OR (a.fit <> b.fit) OR (a.orthotic <> b.orthotic) OR (a.brand <> b.brand) OR (a.branddesc <> b.branddesc) OR (a.heelheight <> b.heelheight) OR (a.heelheightdesc <> b.heelheightdesc) OR (a.primarycolour <> b.primarycolour) OR (a.primarycolourdesc <> b.primarycolourdesc) OR (a.retailcolour <> b.retailcolour) OR (a.retailcolourdesc <> b.retailcolourdesc))
10. 0.000 0.000 ↓ 0.0

Index Scan using hs0001_item_181203_itemnumber_index on hs0001_item_181203 a (cost=0.42..13,885.99 rows=223,479 width=211) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Index Scan using hs0001_item_181130_itemnumber_index on hs0001_item_181130 b (cost=0.42..13,925.26 rows=223,698 width=211) (actual rows= loops=)