explain.depesz.com

PostgreSQL's explain analyze made readable

Result: C7gY

Settings
# exclusive inclusive rows x rows loops node
1. 90.626 5,590.831 ↓ 11.7 53,590 1

Nested Loop Left Join (cost=91,883.78..792,541.61 rows=4,600 width=238) (actual time=766.421..5,590.831 rows=53,590 loops=1)

2. 24.576 1,701.421 ↓ 11.6 53,504 1

Hash Left Join (cost=91,867.54..682,646.38 rows=4,600 width=180) (actual time=766.234..1,701.421 rows=53,504 loops=1)

  • Hash Cond: (producttable.productid = resellingfeedstatustable.productid)
3. 27.580 1,496.935 ↓ 11.6 53,504 1

Hash Left Join (cost=75,426.46..666,187.91 rows=4,600 width=179) (actual time=581.849..1,496.935 rows=53,504 loops=1)

  • Hash Cond: (outofstockproducts.productvariantid = productskudetails.productvariantid)
4. 64.716 1,251.858 ↓ 11.6 53,504 1

Hash Join (cost=56,799.76..647,500.13 rows=4,600 width=164) (actual time=363.163..1,251.858 rows=53,504 loops=1)

  • Hash Cond: (wholesalecatalogueproducttable.catalogueid = wholesalecataloguetable.catalogueid)
5. 18.779 1,187.142 ↓ 11.6 53,504 1

Nested Loop (cost=45,958.59..636,595.71 rows=4,600 width=124) (actual time=316.330..1,187.142 rows=53,504 loops=1)

  • Join Filter: (outofstockproducts.productvariantid = productvarianttable.productvariantid)
  • Buckets: 131072 Batches: 1 Memory Usage: 9183kB
6. 15.738 1,034.505 ↓ 11.6 53,504 1

Nested Loop (cost=45,958.02..597,901.90 rows=4,600 width=128) (actual time=316.320..1,034.505 rows=53,504 loops=1)

7. 14.720 911.759 ↓ 11.6 53,504 1

Hash Join (cost=45,957.58..559,898.09 rows=4,600 width=112) (actual time=316.309..911.759 rows=53,504 loops=1)

  • Hash Cond: (producttable.storeid = storetable.storeid)
8. 0.577 881.779 ↑ 1.0 53,504 1

Nested Loop (cost=15,605.58..529,339.72 rows=54,860 width=97) (actual time=301.033..881.779 rows=53,504 loops=1)

  • Join Filter: (outofstockproducts.productid = producttable.productid)
9. 21.142 720.690 ↑ 1.0 53,504 1

Hash Join (cost=15,605.01..66,372.74 rows=54,860 width=46) (actual time=301.010..720.690 rows=53,504 loops=1)

  • Hash Cond: (outofstockproducts.productid = wholesalecatalogueproducttable.productid)
10. 536.697 536.697 ↑ 1.0 54,089 1

Seq Scan on outofstockproducts (cost=0.00..50,013.40 rows=54,860 width=30) (actual time=136.976..536.697 rows=54,089 loops=1)

  • Filter: ("timestamp" > (now() - '7 days'::interval))
  • Rows Removed by Filter: 1865705
11. 103.136 162.851 ↑ 1.0 540,534 1

Hash (cost=8,848.34..8,848.34 rows=540,534 width=16) (actual time=162.851..162.851 rows=540,534 loops=1)

  • Buckets: 1048576 Batches: 1 Memory Usage: 33530kB
12. 59.715 59.715 ↑ 1.0 540,534 1

Seq Scan on wholesalecatalogueproducttable (cost=0.00..8,848.34 rows=540,534 width=16) (actual time=0.005..59.715 rows=540,534 loops=1)

13. 160.512 160.512 ↑ 1.0 1 53,504

Index Scan using producttable_pkey on producttable (cost=0.57..8.43 rows=1 width=67) (actual time=0.002..0.003 rows=1 loops=53,504)

  • Index Cond: (productid = wholesalecatalogueproducttable.productid)
14. 0.803 15.260 ↑ 1.0 3,650 1

Hash (cost=30,306.38..30,306.38 rows=3,650 width=39) (actual time=15.260..15.260 rows=3,650 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 323kB
15. 3.173 14.457 ↑ 1.0 3,650 1

Nested Loop (cost=0.43..30,306.38 rows=3,650 width=39) (actual time=0.016..14.457 rows=3,650 loops=1)

16. 0.334 0.334 ↑ 1.0 3,650 1

Seq Scan on shop101commissiontableforwholesellers (cost=0.00..88.50 rows=3,650 width=20) (actual time=0.004..0.334 rows=3,650 loops=1)

17. 10.950 10.950 ↑ 1.0 1 3,650

Index Scan using storetable_pkey on storetable (cost=0.43..8.27 rows=1 width=19) (actual time=0.003..0.003 rows=1 loops=3,650)

  • Index Cond: (storeid = shop101commissiontableforwholesellers.wholesellerid)
18. 107.008 107.008 ↑ 1.0 1 53,504

Index Scan using idx_productvariantid_productvariantinfotable on productvariantinfotable (cost=0.43..8.25 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=53,504)

  • Index Cond: (productvariantid = outofstockproducts.productvariantid)
19. 60.341 107.008 ↑ 1.0 1 53,504

Index Scan using productvarianttable_pkey on productvarianttable (cost=0.57..8.40 rows=1 width=12) (actual time=0.002..0.002 rows=1 loops=53,504)

  • Index Cond: (productvariantid = productvariantinfotable.productvariantid)
20. 46.667 46.667 ↑ 1.0 99,341 1

Hash (cost=9,599.41..9,599.41 rows=99,341 width=48) (actual time=46.667..46.667 rows=99,341 loops=1)

21. 26.850 26.850 ↑ 1.0 99,341 1

Seq Scan on wholesalecataloguetable (cost=0.00..9,599.41 rows=99,341 width=48) (actual time=0.004..26.850 rows=99,341 loops=1)

22. 140.487 217.497 ↑ 1.0 616,520 1

Hash (cost=10,920.20..10,920.20 rows=616,520 width=23) (actual time=217.497..217.497 rows=616,520 loops=1)

  • Buckets: 1048576 Batches: 1 Memory Usage: 43569kB
23. 77.010 77.010 ↑ 1.0 616,520 1

Seq Scan on productskudetails (cost=0.00..10,920.20 rows=616,520 width=23) (actual time=0.006..77.010 rows=616,520 loops=1)

24. 118.941 179.910 ↑ 1.0 569,470 1

Hash (cost=9,322.70..9,322.70 rows=569,470 width=9) (actual time=179.910..179.910 rows=569,470 loops=1)

  • Buckets: 1048576 Batches: 1 Memory Usage: 34886kB
25. 60.969 60.969 ↑ 1.0 569,470 1

Seq Scan on resellingfeedstatustable (cost=0.00..9,322.70 rows=569,470 width=9) (actual time=0.008..60.969 rows=569,470 loops=1)

26. 53.861 3,798.784 ↑ 1.0 1 53,504

Nested Loop (cost=16.24..23.86 rows=1 width=74) (actual time=0.063..0.071 rows=1 loops=53,504)

  • Join Filter: (categorytosubcategorymappingtable.categoryid = categorytable.categoryid)
  • Rows Removed by Join Filter: 5
27. 53.861 3,691.776 ↑ 1.0 1 53,504

Nested Loop (cost=16.24..22.73 rows=1 width=50) (actual time=0.062..0.069 rows=1 loops=53,504)

28. 322.796 3,584.768 ↑ 1.0 1 53,504

Hash Join (cost=16.09..17.88 rows=1 width=53) (actual time=0.060..0.067 rows=1 loops=53,504)

  • Hash Cond: (categorytosubcategorymappingtable.subcategoryid = subcategorytomasterproductcategorymappingtable.subcategoryid)
29. 212.244 212.244 ↑ 1.0 57 53,061

Seq Scan on categorytosubcategorymappingtable (cost=0.00..1.57 rows=57 width=16) (actual time=0.001..0.004 rows=57 loops=53,061)

30. 53.504 3,049.728 ↑ 1.0 1 53,504

Hash (cost=16.08..16.08 rows=1 width=61) (actual time=0.057..0.057 rows=1 loops=53,504)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
31. 269.292 2,996.224 ↑ 1.0 1 53,504

Hash Join (cost=14.30..16.08 rows=1 width=61) (actual time=0.050..0.056 rows=1 loops=53,504)

  • Hash Cond: (subcategorytable.subcategoryid = subcategorytomasterproductcategorymappingtable.subcategoryid)
32. 212.244 212.244 ↑ 1.0 56 53,061

Seq Scan on subcategorytable (cost=0.00..1.56 rows=56 width=21) (actual time=0.001..0.004 rows=56 loops=53,061)

33. 53.504 2,514.688 ↑ 1.0 1 53,504

Hash (cost=14.28..14.28 rows=1 width=40) (actual time=0.047..0.047 rows=1 loops=53,504)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
34. 1,339.082 2,461.184 ↑ 1.0 1 53,504

Hash Join (cost=8.26..14.28 rows=1 width=40) (actual time=0.013..0.046 rows=1 loops=53,504)

  • Hash Cond: (subcategorytomasterproductcategorymappingtable.masterproductcategoryid = productcategorytable.masterproductcategoryid)
35. 1,015.094 1,015.094 ↑ 1.0 292 53,426

Seq Scan on subcategorytomasterproductcategorymappingtable (cost=0.00..4.92 rows=292 width=16) (actual time=0.002..0.019 rows=292 loops=53,426)

36. 0.000 107.008 ↑ 1.0 1 53,504

Hash (cost=8.25..8.25 rows=1 width=24) (actual time=0.002..0.002 rows=1 loops=53,504)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
37. 107.008 107.008 ↑ 1.0 1 53,504

Index Scan using productcategorytable_pkey on productcategorytable (cost=0.43..8.25 rows=1 width=24) (actual time=0.002..0.002 rows=1 loops=53,504)

  • Index Cond: (producttable.productcategoryid = productcategoryid)
38. 53.147 53.147 ↑ 1.0 1 53,147

Index Scan using masterproductcategorytable_pkey on masterproductcategorytable (cost=0.15..4.83 rows=1 width=21) (actual time=0.001..0.001 rows=1 loops=53,147)

  • Index Cond: (masterproductcategoryid = productcategorytable.masterproductcategoryid)
39. 53.147 53.147 ↑ 1.0 6 53,147

Seq Scan on categorytable (cost=0.00..1.06 rows=6 width=40) (actual time=0.000..0.001 rows=6 loops=53,147)