explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 20DW

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 1,426.054 ↓ 0.0 0 1

Hash Left Join (cost=9,791,579.22..53,962,759,808,883,791,757,312.00 rows=1,076,535,462,599,692,044,468,224 width=583) (actual time=1,426.054..1,426.054 rows=0 loops=1)

  • Hash Cond: (subordertable.orderid = ordersdevicetype.orderid)
2. 0.000 1,426.053 ↓ 0.0 0 1

Hash Left Join (cost=9,680,477.62..1,307,669,228,456,933,632.00 rows=37,358,948,591,049,834,496 width=520) (actual time=1,426.053..1,426.053 rows=0 loops=1)

  • Hash Cond: (producttable.productcategoryid = productcategorytable.productcategoryid)
3. 0.000 1,426.053 ↓ 0.0 0 1

Hash Join (cost=8,947,151.79..22,925,172,167,632.43 rows=654,995,839,818,676 width=483) (actual time=1,426.053..1,426.053 rows=0 loops=1)

  • Hash Cond: (subordertableforresellers.productid = producttable.productid)
4. 0.000 1,426.053 ↓ 0.0 0 1

Hash Left Join (cost=487,812.21..180,857,303.22 rows=997,589,420 width=483) (actual time=1,426.053..1,426.053 rows=0 loops=1)

  • Hash Cond: (subordertable.couponid = couponmanagementtable.couponid)
5. 0.001 1,426.053 ↓ 0.0 0 1

Hash Join (cost=216,648.10..35,903,953.71 rows=997,589,420 width=482) (actual time=1,426.052..1,426.053 rows=0 loops=1)

  • Hash Cond: (subordertable.suborderid = subordertableforresellers.suborderid)
6. 1,426.052 1,426.052 ↓ 0.0 0 1

Seq Scan on subordertable (cost=0.00..731,451.54 rows=51,277 width=442) (actual time=1,426.051..1,426.052 rows=0 loops=1)

  • Filter: (orderid = 28,079)
7. 0.000 0.000 ↓ 0.0 0

Hash (cost=133,811.82..133,811.82 rows=3,890,982 width=48) (never executed)

8. 0.000 0.000 ↓ 0.0 0

Seq Scan on subordertableforresellers (cost=0.00..133,811.82 rows=3,890,982 width=48) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Hash (cost=158,246.16..158,246.16 rows=6,495,916 width=9) (never executed)

10. 0.000 0.000 ↓ 0.0 0

Seq Scan on couponmanagementtable (cost=0.00..158,246.16 rows=6,495,916 width=9) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Hash (cost=6,176,702.15..6,176,702.15 rows=131,315,715 width=16) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Seq Scan on producttable (cost=0.00..6,176,702.15 rows=131,315,715 width=16) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Hash (cost=479,332.52..479,332.52 rows=11,407,385 width=53) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=1,000.13..479,332.52 rows=11,407,385 width=53) (never executed)

  • Hash Cond: (productcategorytable.masterproductcategoryid = categoryhierarchy.masterproductcategoryid)
15. 0.000 0.000 ↓ 0.0 0

Seq Scan on productcategorytable (cost=0.00..321,480.85 rows=11,407,385 width=16) (never executed)

16. 0.000 0.000 ↓ 0.0 0

Hash (cost=898.70..898.70 rows=8,114 width=53) (never executed)

17. 0.000 0.000 ↓ 0.0 0

Subquery Scan on categoryhierarchy (cost=797.28..898.70 rows=8,114 width=53) (never executed)

18. 0.000 0.000 ↓ 0.0 0

Sort (cost=797.28..817.56 rows=8,114 width=126) (never executed)

  • Sort Key: cat.categorypriority, categorytosubcategorymappingtable.subcategorypriority, subcategorytomasterproductcategorymappingtable.masterproductpriority, cat.categoryid, subcat.subcategoryid, mastercat.masterproductcategoryid
19. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=139.69..270.43 rows=8,114 width=126) (never executed)

  • Hash Cond: (subcategorytomasterproductcategorymappingtable.subcategoryid = categorytosubcategorymappingtable.subcategoryid)
20. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=21.77..52.67 rows=880 width=37) (never executed)

  • Hash Cond: (subcategorytomasterproductcategorymappingtable.masterproductcategoryid = mastercat.masterproductcategoryid)
21. 0.000 0.000 ↓ 0.0 0

Seq Scan on subcategorytomasterproductcategorymappingtable (cost=0.00..18.80 rows=880 width=24) (never executed)

22. 0.000 0.000 ↓ 0.0 0

Hash (cost=13.01..13.01 rows=701 width=21) (never executed)

23. 0.000 0.000 ↓ 0.0 0

Seq Scan on masterproductcategorytable mastercat (cost=0.00..13.01 rows=701 width=21) (never executed)

24. 0.000 0.000 ↓ 0.0 0

Hash (cost=94.86..94.86 rows=1,844 width=72) (never executed)

25. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=52.42..94.86 rows=1,844 width=72) (never executed)

  • Hash Cond: (subcat.subcategoryid = categorytosubcategorymappingtable.subcategoryid)
26. 0.000 0.000 ↓ 0.0 0

Seq Scan on subcategorytable subcat (cost=0.00..18.00 rows=800 width=8) (never executed)

27. 0.000 0.000 ↓ 0.0 0

Hash (cost=46.66..46.66 rows=461 width=64) (never executed)

28. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=26.88..46.66 rows=461 width=64) (never executed)

  • Hash Cond: (categorytosubcategorymappingtable.categoryid = cat.categoryid)
29. 0.000 0.000 ↓ 0.0 0

Seq Scan on categorytosubcategorymappingtable (cost=0.00..3.24 rows=124 width=24) (never executed)

30. 0.000 0.000 ↓ 0.0 0

Hash (cost=17.50..17.50 rows=750 width=48) (never executed)

31. 0.000 0.000 ↓ 0.0 0

Seq Scan on categorytable cat (cost=0.00..17.50 rows=750 width=48) (never executed)

32. 0.000 0.000 ↓ 0.0 0

Hash (cost=110,741.40..110,741.40 rows=28,816 width=40) (never executed)

33. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..110,741.40 rows=28,816 width=40) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
34. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on ordersdevicetype (cost=0.00..106,859.80 rows=12,007 width=40) (never executed)

  • Filter: (orderid = 28,079)
Planning time : 1.946 ms
Execution time : 1,426.320 ms