explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Hixt

Settings
# exclusive inclusive rows x rows loops node
1. 161.692 5,765.570 ↓ 14.8 27,974 1

Nested Loop Left Join (cost=74,503.93..397,609.12 rows=1,895 width=2,184) (actual time=4,239.774..5,765.570 rows=27,974 loops=1)

2. 16.341 5,128.320 ↓ 14.8 27,974 1

Hash Left Join (cost=74,503.64..89,844.54 rows=1,895 width=3,072) (actual time=4,239.673..5,128.320 rows=27,974 loops=1)

  • Hash Cond: (sbd.fit = ft.fitid)
3. 18.070 5,111.934 ↓ 14.8 27,974 1

Hash Left Join (cost=74,502.40..89,835.21 rows=1,895 width=2,863) (actual time=4,239.596..5,111.934 rows=27,974 loops=1)

  • Hash Cond: (sbd.pricelevel = prl.pricelevelid)
4. 32.427 5,093.852 ↓ 14.8 27,974 1

Nested Loop Left Join (cost=74,501.33..89,826.36 rows=1,895 width=2,840) (actual time=4,239.579..5,093.852 rows=27,974 loops=1)

5. 16.478 4,949.529 ↓ 14.8 27,974 1

Nested Loop Left Join (cost=74,501.04..89,070.34 rows=1,895 width=2,826) (actual time=4,239.568..4,949.529 rows=27,974 loops=1)

6. 21.384 4,849.129 ↓ 14.8 27,974 1

Nested Loop Left Join (cost=74,500.75..88,314.32 rows=1,895 width=2,812) (actual time=4,239.555..4,849.129 rows=27,974 loops=1)

7. 14.219 4,715.849 ↓ 14.8 27,974 1

Hash Left Join (cost=74,500.46..87,635.97 rows=1,895 width=2,788) (actual time=4,239.539..4,715.849 rows=27,974 loops=1)

  • Hash Cond: (qi.status = qits.itemstatusid)
8. 24.308 4,701.618 ↓ 14.8 27,974 1

Nested Loop Left Join (cost=74,499.35..87,612.50 rows=1,895 width=2,777) (actual time=4,239.522..4,701.618 rows=27,974 loops=1)

9. 10.289 4,573.998 ↓ 13.6 12,914 1

Nested Loop Left Join (cost=74,498.93..86,974.33 rows=952 width=2,770) (actual time=4,239.504..4,573.998 rows=12,914 loops=1)

10. 16.301 4,486.225 ↓ 13.6 12,914 1

Hash Left Join (cost=74,498.64..86,240.59 rows=952 width=2,727) (actual time=4,239.482..4,486.225 rows=12,914 loops=1)

  • Hash Cond: (q.status = qs.quotationstatusid)
11. 7.691 4,469.891 ↓ 13.6 12,914 1

Hash Left Join (cost=74,497.10..86,225.96 rows=952 width=2,498) (actual time=4,239.433..4,469.891 rows=12,914 loops=1)

  • Hash Cond: (sbd.office = o2.officeid)
12. 12.186 4,462.142 ↓ 13.6 12,914 1

Hash Left Join (cost=74,490.15..86,215.43 rows=952 width=2,510) (actual time=4,239.369..4,462.142 rows=12,914 loops=1)

  • Hash Cond: (cs.officeid = o1.officeid)
13. 11.532 4,449.887 ↓ 13.6 12,914 1

Hash Join (cost=74,483.20..86,195.42 rows=952 width=2,509) (actual time=4,239.288..4,449.887 rows=12,914 loops=1)

  • Hash Cond: (sbd.status = ps.productstatusid)
14. 16.268 4,438.295 ↑ 2.5 14,459 1

Hash Left Join (cost=74,481.19..86,048.17 rows=36,193 width=2,280) (actual time=4,239.207..4,438.295 rows=14,459 loops=1)

  • Hash Cond: (q.clientsupplier = cs.clientsupplierid)
15. 120.002 4,398.194 ↑ 2.5 14,459 1

Hash Right Join (cost=72,677.34..83,746.67 rows=36,193 width=2,267) (actual time=4,215.351..4,398.194 rows=14,459 loops=1)

  • Hash Cond: (q.productid = pd.productid)
16. 63.084 63.084 ↑ 1.0 132,868 1

Seq Scan on quotation q (cost=0.00..5,486.65 rows=133,265 width=34) (actual time=0.012..63.084 rows=132,868 loops=1)

17. 36.784 4,215.108 ↑ 1.0 9,383 1

Hash (cost=69,921.50..69,921.50 rows=9,507 width=2,241) (actual time=4,215.108..4,215.108 rows=9,383 loops=1)

  • Buckets: 2,048 Batches: 8 Memory Usage: 481kB
18. 9.711 4,178.324 ↑ 1.0 9,383 1

Hash Left Join (cost=49,138.35..69,921.50 rows=9,507 width=2,241) (actual time=3,977.234..4,178.324 rows=9,383 loops=1)

  • Hash Cond: ((pd.client = d.clientid) AND (pd.department = d.departmentid))
19. 3.452 4,168.520 ↑ 1.0 9,383 1

Nested Loop (cost=49,100.36..69,812.11 rows=9,507 width=2,228) (actual time=3,977.132..4,168.520 rows=9,383 loops=1)

20. 0.041 0.041 ↑ 1.0 1 1

Seq Scan on dbclient c (cost=0.00..3.82 rows=1 width=8) (actual time=0.038..0.041 rows=1 loops=1)

  • Filter: ((clientid = '300000'::numeric) AND ((companyshort)::text = 'ADH'::text) AND (clientid = ANY ('{2008977,300000,2041999,8731597}'::numeric[])))
  • Rows Removed by Filter: 90
21. 10.630 4,165.027 ↑ 1.0 9,383 1

Hash Left Join (cost=49,100.36..69,713.22 rows=9,507 width=2,220) (actual time=3,977.089..4,165.027 rows=9,383 loops=1)

  • Hash Cond: ((pd.client = sc.clientid) AND (pd.seasonclient = sc.seasonclientid))
22. 7.130 4,154.370 ↑ 1.0 9,383 1

Nested Loop Left Join (cost=49,089.73..69,629.70 rows=9,507 width=2,211) (actual time=3,977.052..4,154.370 rows=9,383 loops=1)

23. 5.287 4,147.240 ↑ 1.0 9,383 1

Nested Loop Left Join (cost=49,089.31..60,631.78 rows=9,507 width=2,111) (actual time=3,977.049..4,147.240 rows=9,383 loops=1)

24. 3.792 4,085.655 ↑ 1.0 9,383 1

Hash Left Join (cost=49,088.89..51,633.87 rows=9,507 width=2,011) (actual time=3,977.017..4,085.655 rows=9,383 loops=1)

  • Hash Cond: (sbd.sustainability = sa.sustainabilityid)
25. 3.229 4,081.836 ↑ 1.0 9,383 1

Hash Left Join (cost=49,087.37..51,579.67 rows=9,507 width=1,802) (actual time=3,976.986..4,081.836 rows=9,383 loops=1)

  • Hash Cond: (md.othersweightunit = owu.weightunitid)
26. 3.146 4,078.591 ↑ 1.0 9,383 1

Hash Left Join (cost=49,085.83..51,541.77 rows=9,507 width=1,593) (actual time=3,976.966..4,078.591 rows=9,383 loops=1)

  • Hash Cond: (md.laceweightunit = lacewu.weightunitid)
27. 3.351 4,075.426 ↑ 1.0 9,383 1

Hash Left Join (cost=49,084.29..51,504.45 rows=9,507 width=1,384) (actual time=3,976.929..4,075.426 rows=9,383 loops=1)

  • Hash Cond: (md.paddingweightunit = pwu.weightunitid)
28. 3.300 4,072.051 ↑ 1.0 9,383 1

Hash Left Join (cost=49,082.75..51,466.13 rows=9,507 width=1,175) (actual time=3,976.899..4,072.051 rows=9,383 loops=1)

  • Hash Cond: (md.liningweightunit = liningwu.weightunitid)
29. 4.183 4,068.737 ↑ 1.0 9,383 1

Hash Left Join (cost=49,081.21..51,427.70 rows=9,507 width=966) (actual time=3,976.880..4,068.737 rows=9,383 loops=1)

  • Hash Cond: (md.shellweightunit = swu.weightunitid)
30. 6.026 4,064.532 ↑ 1.0 9,383 1

Hash Left Join (cost=49,079.67..51,359.75 rows=9,507 width=757) (actual time=3,976.852..4,064.532 rows=9,383 loops=1)

  • Hash Cond: (sbd.packaging = packaging.packagingid)
31. 8.015 4,058.452 ↑ 1.0 9,383 1

Hash Left Join (cost=49,077.89..51,234.52 rows=9,507 width=734) (actual time=3,976.774..4,058.452 rows=9,383 loops=1)

  • Hash Cond: (pd.productid = sr.productid)
32. 8.321 123.284 ↑ 1.0 9,383 1

Hash Left Join (cost=2,297.53..4,418.51 rows=9,507 width=702) (actual time=49.590..123.284 rows=9,383 loops=1)

  • Hash Cond: (sbd.catalog = catalog.catalogid)
33. 2.951 114.934 ↑ 1.0 9,383 1

Hash Left Join (cost=2,295.95..4,318.38 rows=9,507 width=484) (actual time=49.547..114.934 rows=9,383 loops=1)

  • Hash Cond: (sbd.wittmkz = mkz.smmkzid)
34. 5.405 111.781 ↑ 1.0 9,383 1

Hash Left Join (cost=2,285.90..4,225.71 rows=9,507 width=473) (actual time=49.325..111.781 rows=9,383 loops=1)

  • Hash Cond: (sbd.genre = genre.genreid)
35. 34.303 106.283 ↑ 1.0 9,383 1

Hash Join (cost=2,280.33..4,097.13 rows=9,507 width=473) (actual time=49.204..106.283 rows=9,383 loops=1)

  • Hash Cond: (sbd.productid = pd.productid)
36. 22.889 22.889 ↑ 1.0 34,786 1

Seq Scan on sourcerbriefingdetails sbd (cost=0.00..1,591.17 rows=34,817 width=197) (actual time=0.012..22.889 rows=34,786 loops=1)

37. 7.892 49.091 ↑ 1.0 9,383 1

Hash (cost=2,160.85..2,160.85 rows=9,558 width=284) (actual time=49.090..49.091 rows=9,383 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 1,706kB
38. 16.914 41.199 ↑ 1.0 9,383 1

Hash Right Join (cost=1,135.31..2,160.85 rows=9,558 width=284) (actual time=16.561..41.199 rows=9,383 loops=1)

  • Hash Cond: (md.productid = pd.productid)
39. 7.957 7.957 ↓ 1.0 34,774 1

Seq Scan on materialdetails md (cost=0.00..803.94 rows=34,194 width=209) (actual time=0.021..7.957 rows=34,774 loops=1)

40. 5.747 16.328 ↑ 1.0 9,383 1

Hash (cost=1,015.84..1,015.84 rows=9,558 width=84) (actual time=16.328..16.328 rows=9,383 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 1,355kB
41. 8.437 10.581 ↑ 1.0 9,383 1

Bitmap Heap Scan on product pd (cost=190.36..1,015.84 rows=9,558 width=84) (actual time=2.251..10.581 rows=9,383 loops=1)

  • Recheck Cond: (client = '300000'::numeric)
  • Heap Blocks: exact=664
42. 2.144 2.144 ↑ 1.0 9,456 1

Bitmap Index Scan on ixfk_product_client (cost=0.00..187.97 rows=9,558 width=0) (actual time=2.144..2.144 rows=9,456 loops=1)

  • Index Cond: (client = '300000'::numeric)
43. 0.053 0.093 ↑ 1.0 159 1

Hash (cost=3.59..3.59 rows=159 width=18) (actual time=0.093..0.093 rows=159 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
44. 0.040 0.040 ↑ 1.0 159 1

Seq Scan on genre (cost=0.00..3.59 rows=159 width=18) (actual time=0.012..0.040 rows=159 loops=1)

45. 0.105 0.202 ↓ 1.0 314 1

Hash (cost=6.13..6.13 rows=313 width=29) (actual time=0.202..0.202 rows=314 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 28kB
46. 0.097 0.097 ↓ 1.0 314 1

Seq Scan on dbsmmkz mkz (cost=0.00..6.13 rows=313 width=29) (actual time=0.008..0.097 rows=314 loops=1)

47. 0.012 0.029 ↑ 1.0 26 1

Hash (cost=1.26..1.26 rows=26 width=238) (actual time=0.029..0.029 rows=26 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
48. 0.017 0.017 ↑ 1.0 26 1

Seq Scan on catalog (cost=0.00..1.26 rows=26 width=238) (actual time=0.012..0.017 rows=26 loops=1)

49. 2.250 3,927.153 ↓ 8,656.0 8,656 1

Hash (cost=46,780.34..46,780.34 rows=1 width=40) (actual time=3,927.153..3,927.153 rows=8,656 loops=1)

  • Buckets: 16,384 (originally 1024) Batches: 1 (originally 1) Memory Usage: 547kB
50. 0.951 3,924.903 ↓ 8,656.0 8,656 1

Subquery Scan on sr (cost=46,780.29..46,780.34 rows=1 width=40) (actual time=3,912.020..3,924.903 rows=8,656 loops=1)

51. 5.186 3,923.952 ↓ 8,656.0 8,656 1

GroupAggregate (cost=46,780.29..46,780.33 rows=1 width=40) (actual time=3,912.020..3,923.952 rows=8,656 loops=1)

  • Group Key: p.productid
52. 5.055 3,918.766 ↓ 9,135.0 9,135 1

Unique (cost=46,780.29..46,780.30 rows=1 width=43) (actual time=3,912.004..3,918.766 rows=9,135 loops=1)

53. 13.913 3,913.711 ↓ 17,989.0 17,989 1

Sort (cost=46,780.29..46,780.30 rows=1 width=43) (actual time=3,912.003..3,913.711 rows=17,989 loops=1)

  • Sort Key: p.productid, isz.sizerangecode, (CASE WHEN (((isz0.dim2)::text || (isz0.dim1)::text) = ((isz1.dim2)::text || (isz1.dim1)::text)) THEN ((isz0.dim2)::text || (isz0.dim1)::text) ELSE (((((isz0.dim2)::text || (isz0.dim1)::text) || '-'::text) || (isz1.dim2)::text) || (isz1.dim1)::text) END)
  • Sort Method: quicksort Memory: 2,140kB
54. 256.346 3,899.798 ↓ 17,989.0 17,989 1

Merge Join (cost=42,275.43..46,780.28 rows=1 width=43) (actual time=3,452.961..3,899.798 rows=17,989 loops=1)

  • Merge Cond: ((p.productid = i.productid) AND ((isz.sizerangecode)::text = (isz0.sizerangecode)::text))
  • Join Filter: ((isz0.sortkeyinrange = (min(isz.sortkeyinrange))) AND (isz1.sortkeyinrange = (max(isz.sortkeyinrange))))
  • Rows Removed by Join Filter: 793,498
55. 37.880 569.987 ↑ 12.4 9,147 1

GroupAggregate (cost=22,474.86..25,037.00 rows=113,873 width=19) (actual time=505.272..569.987 rows=9,147 loops=1)

  • Group Key: p.productid, isz.sizerangecode
56. 256.295 532.107 ↑ 1.0 111,889 1

Sort (cost=22,474.86..22,759.54 rows=113,873 width=15) (actual time=505.252..532.107 rows=111,889 loops=1)

  • Sort Key: p.productid, isz.sizerangecode
  • Sort Method: external merge Disk: 2,872kB
57. 107.515 275.812 ↑ 1.0 111,889 1

Hash Join (cost=5,576.21..10,961.70 rows=113,873 width=15) (actual time=109.272..275.812 rows=111,889 loops=1)

  • Hash Cond: (isz.itemid = i_1.itemid)
58. 59.589 59.589 ↑ 1.0 111,889 1

Seq Scan on itemsize isz (cost=0.00..2,383.73 rows=113,873 width=15) (actual time=0.014..59.589 rows=111,889 loops=1)

59. 29.752 108.708 ↑ 1.0 65,760 1

Hash (cost=4,430.21..4,430.21 rows=65,920 width=16) (actual time=108.708..108.708 rows=65,760 loops=1)

  • Buckets: 131,072 Batches: 2 Memory Usage: 2,637kB
60. 45.409 78.956 ↑ 1.0 65,760 1

Hash Join (cost=1,493.61..4,430.21 rows=65,920 width=16) (actual time=20.764..78.956 rows=65,760 loops=1)

  • Hash Cond: (i_1.productid = p.productid)
61. 13.059 13.059 ↑ 1.0 65,760 1

Seq Scan on item i_1 (cost=0.00..2,030.20 rows=65,920 width=17) (actual time=0.014..13.059 rows=65,760 loops=1)

62. 12.164 20.488 ↑ 1.0 34,786 1

Hash (cost=1,056.05..1,056.05 rows=35,005 width=8) (actual time=20.488..20.488 rows=34,786 loops=1)

  • Buckets: 65,536 Batches: 1 Memory Usage: 1,905kB
63. 8.324 8.324 ↑ 1.0 34,786 1

Seq Scan on product p (cost=0.00..1,056.05 rows=35,005 width=8) (actual time=0.016..8.324 rows=34,786 loops=1)

64. 2,278.287 3,073.465 ↓ 27.0 811,487 1

Sort (cost=19,800.57..19,875.83 rows=30,103 width=31) (actual time=2,947.649..3,073.465 rows=811,487 loops=1)

  • Sort Key: i.productid, isz0.sizerangecode
  • Sort Method: external sort Disk: 38,648kB
65. 553.007 795.178 ↓ 27.0 811,487 1

Hash Join (cost=11,511.78..17,561.27 rows=30,103 width=31) (actual time=212.384..795.178 rows=811,487 loops=1)

  • Hash Cond: ((isz0.itemid = i.itemid) AND ((isz0.sizerangecode)::text = (isz1.sizerangecode)::text))
66. 29.898 29.898 ↑ 1.0 111,889 1

Seq Scan on itemsize isz0 (cost=0.00..2,383.73 rows=113,873 width=19) (actual time=0.014..29.898 rows=111,889 loops=1)

67. 57.145 212.273 ↑ 1.0 111,889 1

Hash (cost=8,913.68..8,913.68 rows=113,873 width=36) (actual time=212.273..212.273 rows=111,889 loops=1)

  • Buckets: 65,536 Batches: 4 Memory Usage: 2,482kB
68. 87.076 155.128 ↑ 1.0 111,889 1

Hash Join (cost=3,241.20..8,913.68 rows=113,873 width=36) (actual time=37.816..155.128 rows=111,889 loops=1)

  • Hash Cond: (isz1.itemid = i.itemid)
69. 30.465 30.465 ↑ 1.0 111,889 1

Seq Scan on itemsize isz1 (cost=0.00..2,383.73 rows=113,873 width=19) (actual time=0.005..30.465 rows=111,889 loops=1)

70. 22.788 37.587 ↑ 1.0 65,760 1

Hash (cost=2,030.20..2,030.20 rows=65,920 width=17) (actual time=37.587..37.587 rows=65,760 loops=1)

  • Buckets: 65,536 Batches: 2 Memory Usage: 2,129kB
71. 14.799 14.799 ↑ 1.0 65,760 1

Seq Scan on item i (cost=0.00..2,030.20 rows=65,920 width=17) (actual time=0.007..14.799 rows=65,760 loops=1)

72. 0.013 0.054 ↑ 1.0 35 1

Hash (cost=1.35..1.35 rows=35 width=52) (actual time=0.054..0.054 rows=35 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
73. 0.041 0.041 ↑ 1.0 35 1

Seq Scan on packaging (cost=0.00..1.35 rows=35 width=52) (actual time=0.036..0.041 rows=35 loops=1)

74. 0.007 0.022 ↑ 1.0 24 1

Hash (cost=1.24..1.24 rows=24 width=238) (actual time=0.022..0.022 rows=24 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
75. 0.015 0.015 ↑ 1.0 24 1

Seq Scan on weightunit swu (cost=0.00..1.24 rows=24 width=238) (actual time=0.010..0.015 rows=24 loops=1)

76. 0.007 0.014 ↑ 1.0 24 1

Hash (cost=1.24..1.24 rows=24 width=238) (actual time=0.014..0.014 rows=24 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
77. 0.007 0.007 ↑ 1.0 24 1

Seq Scan on weightunit liningwu (cost=0.00..1.24 rows=24 width=238) (actual time=0.002..0.007 rows=24 loops=1)

78. 0.015 0.024 ↑ 1.0 24 1

Hash (cost=1.24..1.24 rows=24 width=238) (actual time=0.024..0.024 rows=24 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
79. 0.009 0.009 ↑ 1.0 24 1

Seq Scan on weightunit pwu (cost=0.00..1.24 rows=24 width=238) (actual time=0.005..0.009 rows=24 loops=1)

80. 0.011 0.019 ↑ 1.0 24 1

Hash (cost=1.24..1.24 rows=24 width=238) (actual time=0.019..0.019 rows=24 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
81. 0.008 0.008 ↑ 1.0 24 1

Seq Scan on weightunit lacewu (cost=0.00..1.24 rows=24 width=238) (actual time=0.003..0.008 rows=24 loops=1)

82. 0.010 0.016 ↑ 1.0 24 1

Hash (cost=1.24..1.24 rows=24 width=238) (actual time=0.015..0.016 rows=24 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
83. 0.006 0.006 ↑ 1.0 24 1

Seq Scan on weightunit owu (cost=0.00..1.24 rows=24 width=238) (actual time=0.003..0.006 rows=24 loops=1)

84. 0.011 0.027 ↓ 1.3 29 1

Hash (cost=1.23..1.23 rows=23 width=238) (actual time=0.027..0.027 rows=29 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
85. 0.016 0.016 ↓ 1.3 29 1

Seq Scan on sustainability sa (cost=0.00..1.23 rows=23 width=238) (actual time=0.011..0.016 rows=29 loops=1)

86. 56.298 56.298 ↓ 0.0 0 9,383

Index Scan using pk_textcontent on textcontent addinfo (cost=0.42..0.94 rows=1 width=116) (actual time=0.006..0.006 rows=0 loops=9,383)

  • Index Cond: (textcontentid = sbd.productcomment)
87. 0.000 0.000 ↓ 0.0 0 9,383

Index Scan using pk_textcontent on textcontent itemcommnet (cost=0.42..0.94 rows=1 width=116) (actual time=0.000..0.000 rows=0 loops=9,383)

  • Index Cond: (textcontentid = sbd.itemcomment)
88. 0.007 0.027 ↑ 1.0 10 1

Hash (cost=10.48..10.48 rows=10 width=26) (actual time=0.027..0.027 rows=10 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
89. 0.006 0.020 ↑ 1.0 10 1

Bitmap Heap Scan on dbseasonclient sc (cost=4.35..10.48 rows=10 width=26) (actual time=0.019..0.020 rows=10 loops=1)

  • Recheck Cond: (clientid = '300000'::numeric)
  • Heap Blocks: exact=1
90. 0.014 0.014 ↑ 1.0 10 1

Bitmap Index Scan on ixfkseasonclient02 (cost=0.00..4.35 rows=10 width=0) (actual time=0.014..0.014 rows=10 loops=1)

  • Index Cond: (clientid = '300000'::numeric)
91. 0.037 0.093 ↓ 8.1 89 1

Hash (cost=37.83..37.83 rows=11 width=29) (actual time=0.093..0.093 rows=89 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 13kB
92. 0.029 0.056 ↓ 8.1 89 1

Bitmap Heap Scan on dbdepartment d (cost=4.37..37.83 rows=11 width=29) (actual time=0.036..0.056 rows=89 loops=1)

  • Recheck Cond: (clientid = '300000'::numeric)
  • Heap Blocks: exact=4
93. 0.027 0.027 ↓ 8.1 89 1

Bitmap Index Scan on uxdepartment (cost=0.00..4.37 rows=11 width=0) (actual time=0.027..0.027 rows=89 loops=1)

  • Index Cond: (clientid = '300000'::numeric)
94. 2.070 23.833 ↓ 1.0 6,134 1

Hash (cost=1,727.23..1,727.23 rows=6,130 width=30) (actual time=23.833..23.833 rows=6,134 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 447kB
95. 4.300 21.763 ↓ 1.0 6,134 1

Hash Left Join (cost=646.64..1,727.23 rows=6,130 width=30) (actual time=6.240..21.763 rows=6,134 loops=1)

  • Hash Cond: (cs.supplierid = s.supplierid)
96. 11.264 11.264 ↓ 1.0 6,134 1

Seq Scan on dbclientsupplier cs (cost=0.00..996.30 rows=6,130 width=23) (actual time=0.005..11.264 rows=6,134 loops=1)

97. 1.596 6.199 ↓ 1.0 5,096 1

Hash (cost=582.95..582.95 rows=5,095 width=15) (actual time=6.199..6.199 rows=5,096 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 303kB
98. 4.603 4.603 ↓ 1.0 5,096 1

Seq Scan on dbsupplier s (cost=0.00..582.95 rows=5,095 width=15) (actual time=0.012..4.603 rows=5,096 loops=1)

99. 0.010 0.060 ↓ 5.0 5 1

Hash (cost=2.00..2.00 rows=1 width=238) (actual time=0.060..0.060 rows=5 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
100. 0.050 0.050 ↓ 5.0 5 1

Seq Scan on productstatus ps (cost=0.00..2.00 rows=1 width=238) (actual time=0.035..0.050 rows=5 loops=1)

  • Filter: ((productstatusid = ANY ('{5515450957,5515450958,5515450959,5550467316,5566890007}'::numeric[])) AND ((code)::text = ANY ('{Open,"Free for Negotiation","Sample request","Style confirmation","Free for Order","Free for Quotation",Cancelled,"Order placed"}'::text[])))
  • Rows Removed by Filter: 33
101. 0.031 0.069 ↑ 1.0 131 1

Hash (cost=5.31..5.31 rows=131 width=8) (actual time=0.069..0.069 rows=131 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 14kB
102. 0.038 0.038 ↑ 1.0 131 1

Seq Scan on dboffice o1 (cost=0.00..5.31 rows=131 width=8) (actual time=0.009..0.038 rows=131 loops=1)

103. 0.033 0.058 ↑ 1.0 131 1

Hash (cost=5.31..5.31 rows=131 width=8) (actual time=0.058..0.058 rows=131 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 14kB
104. 0.025 0.025 ↑ 1.0 131 1

Seq Scan on dboffice o2 (cost=0.00..5.31 rows=131 width=8) (actual time=0.002..0.025 rows=131 loops=1)

105. 0.009 0.033 ↑ 1.0 24 1

Hash (cost=1.24..1.24 rows=24 width=238) (actual time=0.033..0.033 rows=24 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
106. 0.024 0.024 ↑ 1.0 24 1

Seq Scan on quotationstatus qs (cost=0.00..1.24 rows=24 width=238) (actual time=0.020..0.024 rows=24 loops=1)

107. 77.484 77.484 ↑ 1.0 1 12,914

Index Scan using iteminfo_pkey on iteminfo ii (cost=0.29..0.76 rows=1 width=51) (actual time=0.005..0.006 rows=1 loops=12,914)

  • Index Cond: (productid = pd.productid)
108. 103.312 103.312 ↑ 1.5 2 12,914

Index Scan using ix_quotationitem_quotionid on quotationitem qi (cost=0.42..0.64 rows=3 width=23) (actual time=0.007..0.008 rows=2 loops=12,914)

  • Index Cond: (q.quotationid = quotationid)
109. 0.004 0.012 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=20) (actual time=0.012..0.012 rows=5 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
110. 0.008 0.008 ↑ 1.0 5 1

Seq Scan on itemstatus qits (cost=0.00..1.05 rows=5 width=20) (actual time=0.008..0.008 rows=5 loops=1)

111. 111.896 111.896 ↑ 1.0 1 27,974

Index Scan using articletypeno_pk on articletypeno at (cost=0.29..0.35 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=27,974)

  • Index Cond: (sbd.articletypeno = articletypeid)
112. 83.922 83.922 ↑ 1.0 1 27,974

Index Scan using pk_ldpsrmppng on dbldapusermapping rby (cost=0.29..0.39 rows=1 width=22) (actual time=0.003..0.003 rows=1 loops=27,974)

  • Index Cond: (sbd.rebuying = ldapusermappingid)
113. 111.896 111.896 ↑ 1.0 1 27,974

Index Scan using pk_ldpsrmppng on dbldapusermapping cby (cost=0.29..0.39 rows=1 width=22) (actual time=0.003..0.004 rows=1 loops=27,974)

  • Index Cond: (sbd.creativebuyer = ldapusermappingid)
114. 0.001 0.012 ↑ 1.0 3 1

Hash (cost=1.03..1.03 rows=3 width=52) (actual time=0.012..0.012 rows=3 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
115. 0.011 0.011 ↑ 1.0 3 1

Seq Scan on pricelevel prl (cost=0.00..1.03 rows=3 width=52) (actual time=0.009..0.011 rows=3 loops=1)

116. 0.028 0.045 ↑ 1.0 11 1

Hash (cost=1.11..1.11 rows=11 width=238) (actual time=0.045..0.045 rows=11 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
117. 0.017 0.017 ↑ 1.0 11 1

Seq Scan on fit ft (cost=0.00..1.11 rows=11 width=238) (actual time=0.014..0.017 rows=11 loops=1)

118. 111.896 111.896 ↑ 1.0 1 27,974

Index Scan using quotationinfo_pkey on quotationinfo qoi (cost=0.29..0.45 rows=1 width=9) (actual time=0.004..0.004 rows=1 loops=27,974)

  • Index Cond: (productid = pd.productid)
119.          

SubPlan (for Nested Loop Left Join)

120. 56.738 363.662 ↑ 46.0 1 27,974

Nested Loop Left Join (cost=0.86..161.87 rows=46 width=32) (actual time=0.012..0.013 rows=1 loops=27,974)

121. 167.844 167.844 ↑ 46.0 1 27,974

Index Scan using pk_18ndscrptn on dbi18ndescription (cost=0.57..152.75 rows=46 width=24) (actual time=0.006..0.006 rows=1 loops=27,974)

  • Index Cond: ((rid = (sbd.brand)::numeric) AND (languageid = '3064863'::numeric))
122. 27.816 139.080 ↑ 1.0 1 27,816

Materialize (cost=0.29..8.32 rows=1 width=4) (actual time=0.004..0.005 rows=1 loops=27,816)

123. 111.264 111.264 ↑ 1.0 1 27,816

Index Scan using pk_dbsmimportmapping on dbsmimportmapping m (cost=0.29..8.31 rows=1 width=4) (actual time=0.003..0.004 rows=1 loops=27,816)

  • Index Cond: (smimportmappingid = sbd.brand)
  • Filter: ((("productAttribute")::text = 'Brand'::text) AND ((clientid)::numeric = pd.client))
Planning time : 36.502 ms
Execution time : 5,777.848 ms