explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QwlE

Settings
# exclusive inclusive rows x rows loops node
1. 0.262 276,555.261 ↑ 1.0 1 1

Aggregate (cost=10,148,660.23..10,148,660.24 rows=1 width=288) (actual time=276,555.261..276,555.261 rows=1 loops=1)

2. 0.013 276,554.999 ↓ 11.3 169 1

Limit (cost=10,148,659.25..10,148,659.63 rows=15 width=1,400) (actual time=276,553.657..276,554.999 rows=169 loops=1)

3. 0.945 276,554.986 ↓ 11.3 169 1

GroupAggregate (cost=10,148,659.25..10,148,659.63 rows=15 width=1,400) (actual time=276,553.656..276,554.986 rows=169 loops=1)

  • Group Key: (tch.pathnames[2]), (tch.pathnames[3]), tsu.name, (substring(cfc_47.value, '.*\:([^:]+)$'::text))
4. 11.068 276,554.041 ↓ 370.9 5,563 1

Sort (cost=10,148,659.25..10,148,659.29 rows=15 width=1,104) (actual time=276,553.640..276,554.041 rows=5,563 loops=1)

  • Sort Key: (tch.pathnames[2]), (tch.pathnames[3]), tsu.name, (substring(cfc_47.value, '.*\:([^:]+)$'::text))
  • Sort Method: quicksort Memory: 959kB
5. 50.594 276,542.973 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,390,350.59..10,148,658.96 rows=15 width=1,104) (actual time=156,234.750..276,542.973 rows=5,563 loops=1)

  • Join Filter: ((trp.projectid = prj.id) AND (trp.id = tcx.priorityid))
6. 2.552 276,492.379 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,390,321.47..10,148,627.52 rows=15 width=138) (actual time=156,234.663..276,492.379 rows=5,563 loops=1)

  • Join Filter: ((trc.projectid = prj.id) AND (trc.id = tcx.configurationid))
7. 5.400 276,489.827 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,390,292.35..10,148,596.12 rows=15 width=146) (actual time=156,234.631..276,489.827 rows=5,563 loops=1)

  • Join Filter: ((tts.projectid = prj.id) AND (tts.id = tcx.projecttesttypeid))
  • Rows Removed by Join Filter: 33378
8. 12.758 276,478.864 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,390,263.22..10,148,564.72 rows=15 width=154) (actual time=156,234.499..276,478.864 rows=5,563 loops=1)

  • Join Filter: ((trs.projectid = prj.id) AND (trs.id = tcr.testexecutionresultid))
  • Rows Removed by Join Filter: 89311
9. 6.356 276,460.543 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,390,234.10..10,148,533.32 rows=15 width=162) (actual time=156,234.301..276,460.543 rows=5,563 loops=1)

  • Join Filter: ((tct.projectid = prj.id) AND (tct.id = tcs.testcasetypeid))
  • Rows Removed by Join Filter: 38941
10. 4,146.225 276,448.624 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,390,204.98..10,148,501.92 rows=15 width=170) (actual time=156,233.994..276,448.624 rows=5,563 loops=1)

  • Join Filter: (cftctr53.objectid = tcs.id)
  • Rows Removed by Join Filter: 62411297
11. 2.993 245,093.766 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,333,282.25..10,091,459.07 rows=15 width=178) (actual time=131,771.793..245,093.766 rows=5,563 loops=1)

12. 4.155 243,833.535 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,333,280.98..10,090,141.27 rows=15 width=178) (actual time=131,771.546..243,833.535 rows=5,563 loops=1)

13. 3,198.150 243,796.002 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,333,280.13..10,089,324.45 rows=15 width=178) (actual time=131,771.528..243,796.002 rows=5,563 loops=1)

  • Join Filter: (cftctr51.objectid = tcs.id)
  • Rows Removed by Join Filter: 48275714
14. 6.432 209,211.406 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,276,357.40..10,032,281.60 rows=15 width=178) (actual time=102,511.028..209,211.406 rows=5,563 loops=1)

15. 4.355 208,120.189 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,276,356.12..10,030,963.80 rows=15 width=178) (actual time=102,510.823..208,120.189 rows=5,563 loops=1)

16. 1.998 206,908.663 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,276,354.85..10,029,645.99 rows=15 width=178) (actual time=102,510.600..206,908.663 rows=5,563 loops=1)

17. 6.252 205,660.553 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,276,353.57..10,028,328.19 rows=15 width=178) (actual time=102,510.362..205,660.553 rows=5,563 loops=1)

18. 8.208 204,491.634 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,276,352.72..10,027,511.37 rows=15 width=178) (actual time=102,510.136..204,491.634 rows=5,563 loops=1)

19. 6.791 203,292.944 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,276,351.87..10,026,694.55 rows=15 width=178) (actual time=102,509.913..203,292.944 rows=5,563 loops=1)

20. 4.589 202,056.730 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,276,351.02..10,025,877.73 rows=15 width=178) (actual time=102,509.677..202,056.730 rows=5,563 loops=1)

21. 3.897 200,833.844 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,276,349.74..10,024,559.93 rows=15 width=178) (actual time=102,509.449..200,833.844 rows=5,563 loops=1)

22. 9,012.723 199,461.449 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,276,348.89..10,014,962.45 rows=15 width=178) (actual time=102,509.167..199,461.449 rows=5,563 loops=1)

  • Join Filter: (cftctr41.objectid = tcs.id)
  • Rows Removed by Join Filter: 134251879
23. 6,101.757 114,374.701 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,219,426.17..9,957,919.60 rows=15 width=178) (actual time=32,323.148..114,374.701 rows=5,563 loops=1)

  • Join Filter: (cftctr40.objectid = tcs.id)
  • Rows Removed by Join Filter: 91299956
24. 3.690 77,086.766 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,162,503.44..9,900,876.75 rows=15 width=178) (actual time=5,180.033..77,086.766 rows=5,563 loops=1)

25. 3.605 77,038.572 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,162,502.16..9,899,558.95 rows=15 width=178) (actual time=5,180.014..77,038.572 rows=5,563 loops=1)

26. 2.865 75,688.721 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,162,500.89..9,898,241.14 rows=15 width=178) (actual time=5,179.598..75,688.721 rows=5,563 loops=1)

27. 4.548 75,646.915 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,162,499.61..9,896,923.34 rows=15 width=178) (actual time=5,179.576..75,646.915 rows=5,563 loops=1)

28. 3.556 75,603.426 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,162,498.34..9,895,605.53 rows=15 width=178) (actual time=5,179.555..75,603.426 rows=5,563 loops=1)

29. 1.650 75,560.929 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,162,497.06..9,894,287.73 rows=15 width=178) (actual time=5,179.536..75,560.929 rows=5,563 loops=1)

30. 2.880 75,520.338 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,162,496.21..9,893,470.91 rows=15 width=178) (actual time=5,179.516..75,520.338 rows=5,563 loops=1)

31. 1.790 75,478.517 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,162,494.94..9,892,153.10 rows=15 width=178) (actual time=5,179.497..75,478.517 rows=5,563 loops=1)

32. 6.380 75,432.223 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,162,493.66..9,890,835.30 rows=15 width=178) (actual time=5,179.475..75,432.223 rows=5,563 loops=1)

33. 7.747 75,386.902 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,162,492.39..9,889,517.49 rows=15 width=178) (actual time=5,179.455..75,386.902 rows=5,563 loops=1)

34. 4.464 75,340.214 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,162,491.53..9,888,700.68 rows=15 width=178) (actual time=5,179.434..75,340.214 rows=5,563 loops=1)

35. 3.338 75,291.246 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,162,490.26..9,887,382.87 rows=15 width=178) (actual time=5,179.412..75,291.246 rows=5,563 loops=1)

36. 2.834 75,237.841 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,162,488.98..9,886,065.07 rows=15 width=178) (actual time=5,179.389..75,237.841 rows=5,563 loops=1)

37. 6.171 75,168.251 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,162,488.13..9,885,248.25 rows=15 width=178) (actual time=5,179.361..75,168.251 rows=5,563 loops=1)

38. 4.483 75,095.324 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,162,487.28..9,884,431.43 rows=15 width=178) (actual time=5,179.316..75,095.324 rows=5,563 loops=1)

39. 338.306 75,046.337 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,162,486.43..9,883,614.61 rows=15 width=178) (actual time=5,179.288..75,046.337 rows=5,563 loops=1)

  • Join Filter: (cftctr23.objectid = tcs.id)
  • Rows Removed by Join Filter: 4917692
40. 3.118 74,474.385 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,105,563.70..9,826,571.77 rows=15 width=178) (actual time=5,166.190..74,474.385 rows=5,563 loops=1)

41. 5.733 74,443.452 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,105,562.85..9,825,754.95 rows=15 width=178) (actual time=5,166.173..74,443.452 rows=5,563 loops=1)

42. 416.901 74,387.652 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,105,561.57..9,824,437.14 rows=15 width=178) (actual time=5,166.145..74,387.652 rows=5,563 loops=1)

  • Join Filter: (cftctr22.objectid = tcs.id)
  • Rows Removed by Join Filter: 6224997
43. 4.799 73,664.786 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,048,638.84..9,767,394.30 rows=15 width=178) (actual time=5,140.850..73,664.786 rows=5,563 loops=1)

44. 3.367 73,426.341 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,048,633.96..9,764,329.02 rows=15 width=178) (actual time=5,140.719..73,426.341 rows=5,563 loops=1)

45. 5.238 73,172.639 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,048,629.03..9,760,679.31 rows=15 width=178) (actual time=5,140.581..73,172.639 rows=5,563 loops=1)

46. 3.671 72,933.755 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,048,623.71..9,754,787.67 rows=15 width=178) (actual time=5,140.447..72,933.755 rows=5,563 loops=1)

47. 3.770 72,685.312 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,048,618.36..9,748,005.84 rows=15 width=178) (actual time=5,140.275..72,685.312 rows=5,563 loops=1)

48. 6.474 72,648.164 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,048,617.51..9,738,408.36 rows=15 width=178) (actual time=5,140.261..72,648.164 rows=5,563 loops=1)

49. 130.522 72,335.725 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1,048,616.23..9,737,090.55 rows=15 width=178) (actual time=5,140.141..72,335.725 rows=5,563 loops=1)

  • Join Filter: (cftctr15.objectid = tcs.id)
  • Rows Removed by Join Filter: 1885857
50. 8.124 69,729.668 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=770,666.85..9,458,450.61 rows=15 width=178) (actual time=2,749.549..69,729.668 rows=5,563 loops=1)

  • Join Filter: (cftctr14.objectid = tcs.id)
  • Rows Removed by Join Filter: 22252
51. 5.751 67,229.320 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=487,452.52..9,174,485.66 rows=15 width=178) (actual time=257.788..67,229.320 rows=5,563 loops=1)

52. 4.658 66,984.360 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=487,447.55..9,170,396.36 rows=15 width=178) (actual time=257.648..66,984.360 rows=5,563 loops=1)

53. 5.924 66,729.367 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=487,442.20..9,163,614.53 rows=15 width=178) (actual time=257.500..66,729.367 rows=5,563 loops=1)

54. 1.056 66,667.813 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=487,440.92..9,162,296.73 rows=15 width=178) (actual time=257.477..66,667.813 rows=5,563 loops=1)

55. 2.182 66,421.985 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=487,436.00..9,158,647.01 rows=15 width=178) (actual time=257.332..66,421.985 rows=5,563 loops=1)

56. 6.623 66,152.779 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=487,430.63..9,151,420.91 rows=15 width=178) (actual time=257.167..66,152.779 rows=5,563 loops=1)

57. 3.668 66,090.526 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=487,429.35..9,150,103.11 rows=15 width=178) (actual time=257.143..66,090.526 rows=5,563 loops=1)

58. 7.152 66,047.917 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=487,428.50..9,149,286.29 rows=15 width=178) (actual time=257.122..66,047.917 rows=5,563 loops=1)

59. 5.468 65,990.698 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=487,427.65..9,148,469.47 rows=15 width=178) (actual time=257.094..65,990.698 rows=5,563 loops=1)

60. 5.633 65,957.415 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=487,426.37..9,147,151.67 rows=15 width=178) (actual time=257.080..65,957.415 rows=5,563 loops=1)

61. 3.070 65,907.278 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=487,425.52..9,146,334.85 rows=15 width=178) (actual time=257.059..65,907.278 rows=5,563 loops=1)

62. 3.197 65,837.452 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=487,424.24..9,145,017.04 rows=15 width=178) (actual time=257.034..65,837.452 rows=5,563 loops=1)

  • Join Filter: (cfrl1.objectid = rls.id)
63. 2.753 65,834.255 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=487,360.71..9,144,953.25 rows=15 width=186) (actual time=257.004..65,834.255 rows=5,563 loops=1)

64. 2.446 65,659.049 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=487,359.14..9,140,394.49 rows=15 width=194) (actual time=256.910..65,659.049 rows=5,563 loops=1)

65. 5.115 65,623.225 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=487,358.28..9,139,577.68 rows=15 width=194) (actual time=256.892..65,623.225 rows=5,563 loops=1)

66. 2.534 65,556.917 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=487,357.01..9,138,259.87 rows=15 width=194) (actual time=256.871..65,556.917 rows=5,563 loops=1)

67. 6.248 65,209.477 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=487,355.86..9,039,378.97 rows=15 width=194) (actual time=256.754..65,209.477 rows=5,563 loops=1)

68. 1.929 64,863.886 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=487,354.70..8,940,498.06 rows=15 width=194) (actual time=256.638..64,863.886 rows=5,563 loops=1)

69. 4.307 64,517.051 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=487,353.55..8,841,617.16 rows=15 width=194) (actual time=256.513..64,517.051 rows=5,563 loops=1)

70. 1.466 64,167.838 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=487,352.40..8,679,119.49 rows=15 width=194) (actual time=256.396..64,167.838 rows=5,563 loops=1)

71. 4.199 63,821.466 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=487,351.25..8,580,238.59 rows=15 width=194) (actual time=256.271..63,821.466 rows=5,563 loops=1)

72. 1.077 63,472.361 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=487,350.09..8,481,357.69 rows=15 width=194) (actual time=256.133..63,472.361 rows=5,563 loops=1)

73. 2.909 63,126.378 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=487,348.94..8,382,476.78 rows=15 width=194) (actual time=256.004..63,126.378 rows=5,563 loops=1)

74. 3.871 62,778.563 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=487,347.79..8,283,595.88 rows=15 width=194) (actual time=255.875..62,778.563 rows=5,563 loops=1)

75. 2.140 62,424.223 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=487,346.64..8,184,714.98 rows=15 width=194) (actual time=255.745..62,424.223 rows=5,563 loops=1)

76. 2.112 61,882.472 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=487,345.06..8,180,156.22 rows=15 width=194) (actual time=255.499..61,882.472 rows=5,563 loops=1)

77. 4.374 61,112.666 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=487,343.48..8,175,597.46 rows=15 width=194) (actual time=255.154..61,112.666 rows=5,563 loops=1)

78. 5.814 60,930.276 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=487,341.90..8,171,038.70 rows=15 width=194) (actual time=255.058..60,930.276 rows=5,563 loops=1)

79. 5.939 60,573.993 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=487,340.75..8,072,157.80 rows=15 width=194) (actual time=254.925..60,573.993 rows=5,563 loops=1)

80. 6.258 60,323.282 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=487,339.17..8,067,599.04 rows=15 width=194) (actual time=254.793..60,323.282 rows=5,563 loops=1)

81. 3.157 60,088.941 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=487,337.60..8,063,040.28 rows=15 width=194) (actual time=254.671..60,088.941 rows=5,563 loops=1)

82. 4.126 59,852.138 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=487,336.02..8,058,481.52 rows=15 width=173) (actual time=254.550..59,852.138 rows=5,563 loops=1)

83. 3.417 59,325.090 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=487,334.87..7,959,600.62 rows=15 width=173) (actual time=254.515..59,325.090 rows=5,563 loops=1)

84. 1.538 58,821.003 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=487,333.71..7,860,719.72 rows=15 width=173) (actual time=254.357..58,821.003 rows=5,563 loops=1)

85. 2.043 58,313.232 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=487,332.56..7,761,838.81 rows=15 width=173) (actual time=254.208..58,313.232 rows=5,563 loops=1)

86. 5.495 57,810.519 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=487,331.41..7,662,957.91 rows=15 width=173) (actual time=254.082..57,810.519 rows=5,563 loops=1)

87. 5.877 57,454.555 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=487,330.26..7,500,460.24 rows=15 width=173) (actual time=253.961..57,454.555 rows=5,563 loops=1)

88. 4.487 56,942.445 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=487,329.10..7,401,579.34 rows=15 width=173) (actual time=253.790..56,942.445 rows=5,563 loops=1)

89. 878.908 56,426.162 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=487,327.95..7,302,698.43 rows=15 width=173) (actual time=253.611..56,426.162 rows=5,563 loops=1)

  • Join Filter: (cfts30.objectid = tcx.id)
  • Rows Removed by Join Filter: 13173184
90. 5.106 54,779.560 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=114,032.37..6,903,274.41 rows=15 width=173) (actual time=72.351..54,779.560 rows=5,563 loops=1)

91. 6.316 54,652.068 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=114,030.79..6,898,715.65 rows=15 width=173) (actual time=72.284..54,652.068 rows=5,563 loops=1)

92. 5.988 54,551.181 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=114,029.22..6,894,156.90 rows=15 width=173) (actual time=72.224..54,551.181 rows=5,563 loops=1)

93. 3.748 54,411.681 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=114,027.64..6,889,598.14 rows=15 width=173) (actual time=72.138..54,411.681 rows=5,563 loops=1)

94. 3.793 52,010.280 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=114,026.06..6,885,039.38 rows=15 width=173) (actual time=71.100..52,010.280 rows=5,563 loops=1)

95. 2.680 51,923.042 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=114,024.48..6,880,480.62 rows=15 width=173) (actual time=71.051..51,923.042 rows=5,563 loops=1)

96. 6.044 51,725.657 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=114,023.33..6,781,599.72 rows=15 width=173) (actual time=70.981..51,725.657 rows=5,563 loops=1)

97. 2.962 51,435.900 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=114,021.75..6,777,040.96 rows=15 width=173) (actual time=70.842..51,435.900 rows=5,563 loops=1)

98. 2.548 50,937.831 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=114,020.60..6,678,160.06 rows=15 width=173) (actual time=70.687..50,937.831 rows=5,563 loops=1)

99. 6.498 50,740.578 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=114,019.45..6,579,279.15 rows=15 width=173) (actual time=70.617..50,740.578 rows=5,563 loops=1)

100. 3.653 50,411.426 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=114,017.87..6,574,720.39 rows=15 width=173) (actual time=70.454..50,411.426 rows=5,563 loops=1)

101. 4.239 50,213.068 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=114,016.72..6,475,839.49 rows=15 width=173) (actual time=70.382..50,213.068 rows=5,563 loops=1)

102. 1.337 46,587.316 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=114,011.40..5,961,885.63 rows=15 width=173) (actual time=69.314..46,587.316 rows=5,563 loops=1)

103. 1.415 46,391.274 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=114,010.24..5,863,004.73 rows=15 width=173) (actual time=69.243..46,391.274 rows=5,563 loops=1)

104. 2.455 46,200.717 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=114,008.67..5,858,445.97 rows=15 width=173) (actual time=69.134..46,200.717 rows=5,563 loops=1)

105. 2.082 46,003.557 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=114,007.51..5,759,565.07 rows=15 width=173) (actual time=69.061..46,003.557 rows=5,563 loops=1)

106. 6.972 42,958.514 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=114,002.19..5,245,611.21 rows=15 width=173) (actual time=68.133..42,958.514 rows=5,563 loops=1)

107. 6.907 39,163.139 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=113,996.84..4,634,013.27 rows=15 width=173) (actual time=66.983..39,163.139 rows=5,563 loops=1)

108. 3.114 38,961.527 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=113,995.68..4,535,132.36 rows=15 width=173) (actual time=66.908..38,961.527 rows=5,563 loops=1)

109. 2.294 38,051.644 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=113,994.11..4,530,573.60 rows=15 width=173) (actual time=66.525..38,051.644 rows=5,563 loops=1)

110. 2.061 34,422.274 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=113,988.75..3,918,975.66 rows=15 width=173) (actual time=65.461..34,422.274 rows=5,563 loops=1)

111. 2.409 30,798.700 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=113,983.40..3,307,377.71 rows=15 width=173) (actual time=64.342..30,798.700 rows=5,563 loops=1)

112. 6.864 27,180.341 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=113,978.05..2,695,779.76 rows=15 width=173) (actual time=63.126..27,180.341 rows=5,563 loops=1)

113. 3.903 23,390.637 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=113,972.71..2,133,003.65 rows=15 width=173) (actual time=61.860..23,390.637 rows=5,563 loops=1)

114. 6.242 19,737.406 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=113,967.38..1,619,049.79 rows=15 width=173) (actual time=60.592..19,737.406 rows=5,563 loops=1)

115. 4.194 15,759.182 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=113,961.55..1,591,275.83 rows=15 width=173) (actual time=58.837..15,759.182 rows=5,563 loops=1)

116. 4.158 12,083.408 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=113,956.18..930,856.59 rows=15 width=173) (actual time=57.579..12,083.408 rows=5,563 loops=1)

117. 2.924 8,402.107 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=113,950.81..270,437.34 rows=15 width=173) (actual time=56.342..8,402.107 rows=5,563 loops=1)

118. 2.632 5,829.077 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=113,945.02..246,811.51 rows=15 width=173) (actual time=55.221..5,829.077 rows=5,563 loops=1)

119. 3.786 4,357.813 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=113,939.24..224,844.08 rows=15 width=173) (actual time=54.582..4,357.813 rows=5,563 loops=1)

120. 5.985 4,320.649 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=113,938.39..224,027.26 rows=15 width=173) (actual time=54.565..4,320.649 rows=5,563 loops=1)

121. 1.406 4,275.723 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=113,937.53..223,210.45 rows=15 width=173) (actual time=54.544..4,275.723 rows=5,563 loops=1)

122. 5.107 4,224.250 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=113,936.68..213,612.97 rows=15 width=173) (actual time=54.525..4,224.250 rows=5,563 loops=1)

123. 4.038 4,196.891 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=113,935.83..212,796.15 rows=15 width=173) (actual time=54.511..4,196.891 rows=5,563 loops=1)

124. 6.294 4,170.601 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=113,934.98..211,979.33 rows=15 width=173) (actual time=54.495..4,170.601 rows=5,563 loops=1)

125. 2.633 4,142.055 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=113,934.13..211,162.51 rows=15 width=173) (actual time=54.480..4,142.055 rows=5,563 loops=1)

126. 89.480 4,083.792 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=113,933.27..210,345.70 rows=15 width=173) (actual time=54.452..4,083.792 rows=5,563 loops=1)

  • Join Filter: (cf19.objectid = tcx.id)
  • Rows Removed by Join Filter: 1307305
127. 9.936 3,927.556 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=57,010.55..153,302.85 rows=15 width=173) (actual time=47.639..3,927.556 rows=5,563 loops=1)

  • Join Filter: (cf18.objectid = tcx.id)
  • Rows Removed by Join Filter: 61193
128. 6.740 3,906.494 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=87.82..96,260.00 rows=15 width=173) (actual time=38.613..3,906.494 rows=5,563 loops=1)

129. 1.723 3,871.939 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=86.97..95,443.19 rows=15 width=173) (actual time=38.598..3,871.939 rows=5,563 loops=1)

130. 5.326 3,825.712 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=85.69..94,125.38 rows=15 width=173) (actual time=38.583..3,825.712 rows=5,563 loops=1)

131. 5.660 3,603.429 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=80.34..87,239.98 rows=15 width=173) (actual time=38.464..3,603.429 rows=5,563 loops=1)

132. 6.876 3,397.501 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=75.39..83,292.99 rows=15 width=173) (actual time=38.350..3,397.501 rows=5,563 loops=1)

133. 6.127 3,190.357 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=70.04..76,407.59 rows=15 width=173) (actual time=38.241..3,190.357 rows=5,563 loops=1)

134. 4.409 2,967.273 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=64.70..69,967.00 rows=15 width=173) (actual time=38.119..2,967.273 rows=5,563 loops=1)

135. 5.782 2,745.907 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=59.76..66,020.01 rows=15 width=173) (actual time=37.998..2,745.907 rows=5,563 loops=1)

136. 5.310 2,523.168 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=54.44..60,024.79 rows=15 width=173) (actual time=37.877..2,523.168 rows=5,563 loops=1)

137. 4.580 2,300.901 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=49.10..53,584.21 rows=15 width=173) (actual time=37.760..2,300.901 rows=5,563 loops=1)

138. 5.344 2,079.364 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=44.22..50,415.36 rows=15 width=173) (actual time=37.637..2,079.364 rows=5,563 loops=1)

139. 3.560 1,857.063 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=38.85..43,085.69 rows=15 width=173) (actual time=37.512..1,857.063 rows=5,563 loops=1)

140. 3.726 1,636.546 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=33.93..39,526.64 rows=15 width=173) (actual time=37.389..1,636.546 rows=5,563 loops=1)

141. 4.923 1,399.174 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=29.02..35,967.60 rows=15 width=173) (actual time=37.264..1,399.174 rows=5,563 loops=1)

142. 5.044 1,177.294 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=23.67..29,082.20 rows=15 width=173) (actual time=37.146..1,177.294 rows=5,563 loops=1)

143. 2.108 955.293 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=18.31..22,196.79 rows=15 width=173) (actual time=37.028..955.293 rows=5,563 loops=1)

144. 4.602 730.665 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=12.97..15,756.21 rows=15 width=173) (actual time=36.909..730.665 rows=5,563 loops=1)

145. 3.591 503.543 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=7.64..9,315.62 rows=15 width=173) (actual time=36.787..503.543 rows=5,563 loops=1)

146. 2.379 377.566 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=7.20..9,188.72 rows=15 width=120) (actual time=36.776..377.566 rows=5,563 loops=1)

147. 6.299 135.978 ↓ 370.9 5,563 1

Nested Loop Left Join (cost=1.86..2,748.13 rows=15 width=120) (actual time=36.643..135.978 rows=5,563 loops=1)

  • Join Filter: (rls.id = tcx.releaseid)
148. 2.126 129.679 ↓ 370.9 5,563 1

Nested Loop (cost=1.57..2,739.59 rows=15 width=120) (actual time=36.613..129.679 rows=5,563 loops=1)

149. 0.007 36.612 ↑ 5.0 1 1

Nested Loop Left Join (cost=0.00..49.53 rows=5 width=8) (actual time=36.540..36.612 rows=1 loops=1)

  • Join Filter: (crosstab.projectid = prj.id)
150. 0.164 0.164 ↑ 1.0 1 1

Seq Scan on projects prj (cost=0.00..36.97 rows=1 width=8) (actual time=0.112..0.164 rows=1 loops=1)

  • Filter: ((id = 563) AND (projectstatusid = 101))
  • Rows Removed by Filter: 956
151. 36.441 36.441 ↑ 5.0 1 1

Function Scan on crosstab (cost=0.00..12.50 rows=5 width=8) (actual time=36.423..36.441 rows=1 loops=1)

  • Filter: (projectid = 563)
  • Rows Removed by Filter: 381
152. 5.837 90.941 ↓ 1,854.3 5,563 1

Materialize (cost=1.57..2,689.88 rows=3 width=120) (actual time=0.072..90.941 rows=5,563 loops=1)

153. 3.841 85.104 ↓ 1,854.3 5,563 1

Nested Loop Left Join (cost=1.57..2,689.87 rows=3 width=120) (actual time=0.071..85.104 rows=5,563 loops=1)

154. 6.037 64.574 ↓ 1,854.3 5,563 1

Nested Loop Left Join (cost=1.28..2,664.92 rows=3 width=88) (actual time=0.061..64.574 rows=5,563 loops=1)

155. 4.093 41.848 ↓ 1,854.3 5,563 1

Nested Loop (cost=0.86..2,639.57 rows=3 width=88) (actual time=0.053..41.848 rows=5,563 loops=1)

156. 15.503 15.503 ↓ 1,854.3 5,563 1

Index Scan using idx_test_case_run_rel on test_case_run tcx (cost=0.43..2,614.19 rows=3 width=104) (actual time=0.044..15.503 rows=5,563 loops=1)

  • Index Cond: (releaseid = 2035)
  • Filter: ((NOT deleted) AND (projectid = 563) AND (clientid = 2))
  • Rows Removed by Filter: 4537
157. 22.252 22.252 ↑ 1.0 1 5,563

Index Scan using idx_test_cases_id on test_cases tcs (cost=0.43..8.45 rows=1 width=32) (actual time=0.003..0.004 rows=1 loops=5,563)

  • Index Cond: (id = tcx.testcaseid)
158. 16.689 16.689 ↑ 1.0 1 5,563

Index Scan using pk_test_case_results on test_case_results tcr (cost=0.42..8.44 rows=1 width=24) (actual time=0.003..0.003 rows=1 loops=5,563)

  • Index Cond: (id = tcx.latesttestcaseresultid)
159. 16.689 16.689 ↑ 1.0 1 5,563

Index Scan using idx_test_suites_id on test_suites tsu (cost=0.29..8.31 rows=1 width=48) (actual time=0.002..0.003 rows=1 loops=5,563)

  • Index Cond: (id = tcx.testsuiteid)
160. 0.000 0.000 ↑ 1.0 1 5,563

Materialize (cost=0.29..8.31 rows=1 width=8) (actual time=0.000..0.000 rows=1 loops=5,563)

161. 0.028 0.028 ↑ 1.0 1 1

Index Only Scan using idx_releases_id on releases rls (cost=0.29..8.31 rows=1 width=8) (actual time=0.025..0.028 rows=1 loops=1)

  • Index Cond: (id = 2035)
  • Heap Fetches: 5
162. 5.563 239.209 ↓ 0.0 0 5,563

Nested Loop (cost=5.34..429.36 rows=1 width=8) (actual time=0.043..0.043 rows=0 loops=5,563)

163. 130.556 233.646 ↓ 0.0 0 5,563

Nested Loop (cost=4.91..237.26 rows=23 width=35) (actual time=0.042..0.042 rows=0 loops=5,563)

  • Join Filter: (cfs.id = cfv.customfieldid)
  • Rows Removed by Join Filter: 301
164. 33.378 33.378 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv (cost=0.44..76.66 rows=194 width=27) (actual time=0.004..0.006 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
165. 69.665 69.712 ↓ 1.0 24 69,712

Materialize (cost=4.48..93.73 rows=23 width=8) (actual time=0.000..0.001 rows=24 loops=69,712)

166. 0.037 0.047 ↓ 1.0 24 1

Bitmap Heap Scan on custom_fields cfs (cost=4.48..93.62 rows=23 width=8) (actual time=0.017..0.047 rows=24 loops=1)

  • Recheck Cond: (sitefieldid = 495)
  • Filter: (active AND (clientid = 2))
  • Heap Blocks: exact=24
167. 0.010 0.010 ↓ 1.1 26 1

Bitmap Index Scan on idx_custom_fields_sitefieldid (cost=0.00..4.47 rows=24 width=0) (actual time=0.010..0.010 rows=26 loops=1)

  • Index Cond: (sitefieldid = 495)
168. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc (cost=0.42..8.34 rows=1 width=16) (never executed)

  • Index Cond: (customfieldid = cfv.customfieldid)
  • Filter: (((attribute)::text = 'values'::text) AND (cfv.value = (valueid)::text))
169. 122.386 122.386 ↑ 1.0 1 5,563

Index Scan using test_cycle_hier_pkey on test_cycle_hier tch (cost=0.43..8.45 rows=1 width=69) (actual time=0.004..0.022 rows=1 loops=5,563)

  • Index Cond: (id = tcx.testcycleid)
170. 0.000 222.520 ↓ 0.0 0 5,563

Nested Loop (cost=5.34..429.36 rows=1 width=8) (actual time=0.040..0.040 rows=0 loops=5,563)

171. 136.119 222.520 ↓ 0.0 0 5,563

Nested Loop (cost=4.91..237.26 rows=23 width=35) (actual time=0.040..0.040 rows=0 loops=5,563)

  • Join Filter: (cfs_3.id = cfv_3.customfieldid)
  • Rows Removed by Join Filter: 301
172. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_3 (cost=0.44..76.66 rows=194 width=27) (actual time=0.002..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
173. 69.670 69.712 ↓ 1.0 24 69,712

Materialize (cost=4.48..93.73 rows=23 width=8) (actual time=0.000..0.001 rows=24 loops=69,712)

174. 0.034 0.042 ↓ 1.0 24 1

Bitmap Heap Scan on custom_fields cfs_3 (cost=4.48..93.62 rows=23 width=8) (actual time=0.014..0.042 rows=24 loops=1)

  • Recheck Cond: (sitefieldid = 843)
  • Filter: (active AND (clientid = 2))
  • Heap Blocks: exact=25
175. 0.008 0.008 ↓ 1.1 27 1

Bitmap Index Scan on idx_custom_fields_sitefieldid (cost=0.00..4.47 rows=24 width=0) (actual time=0.008..0.008 rows=27 loops=1)

  • Index Cond: (sitefieldid = 843)
176. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_3 (cost=0.42..8.34 rows=1 width=16) (never executed)

  • Index Cond: (customfieldid = cfv_3.customfieldid)
  • Filter: (((attribute)::text = 'values'::text) AND (cfv_3.value = (valueid)::text))
177. 5.563 222.520 ↓ 0.0 0 5,563

Nested Loop (cost=5.34..429.36 rows=1 width=8) (actual time=0.040..0.040 rows=0 loops=5,563)

178. 130.556 216.957 ↓ 0.0 0 5,563

Nested Loop (cost=4.91..237.26 rows=23 width=35) (actual time=0.039..0.039 rows=0 loops=5,563)

  • Join Filter: (cfs_2.id = cfv_2.customfieldid)
  • Rows Removed by Join Filter: 301
179. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_2 (cost=0.44..76.66 rows=194 width=27) (actual time=0.002..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
180. 69.675 69.712 ↓ 1.0 24 69,712

Materialize (cost=4.48..93.73 rows=23 width=8) (actual time=0.000..0.001 rows=24 loops=69,712)

181. 0.030 0.037 ↓ 1.0 24 1

Bitmap Heap Scan on custom_fields cfs_2 (cost=4.48..93.62 rows=23 width=8) (actual time=0.013..0.037 rows=24 loops=1)

  • Recheck Cond: (sitefieldid = 842)
  • Filter: (active AND (clientid = 2))
  • Heap Blocks: exact=25
182. 0.007 0.007 ↓ 1.1 27 1

Bitmap Index Scan on idx_custom_fields_sitefieldid (cost=0.00..4.47 rows=24 width=0) (actual time=0.007..0.007 rows=27 loops=1)

  • Index Cond: (sitefieldid = 842)
183. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_2 (cost=0.42..8.34 rows=1 width=16) (never executed)

  • Index Cond: (customfieldid = cfv_2.customfieldid)
  • Filter: (((attribute)::text = 'values'::text) AND (cfv_2.value = (valueid)::text))
184. 0.000 216.957 ↓ 0.0 0 5,563

Nested Loop (cost=5.35..459.02 rows=1 width=8) (actual time=0.039..0.039 rows=0 loops=5,563)

185. 130.556 216.957 ↓ 0.0 0 5,563

Nested Loop (cost=4.93..250.21 rows=25 width=35) (actual time=0.039..0.039 rows=0 loops=5,563)

  • Join Filter: (cfs_1.id = cfv_1.customfieldid)
  • Rows Removed by Join Filter: 301
186. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_1 (cost=0.44..76.66 rows=194 width=27) (actual time=0.002..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
187. 69.672 69.712 ↑ 1.0 24 69,712

Materialize (cost=4.49..100.87 rows=25 width=8) (actual time=0.000..0.001 rows=24 loops=69,712)

188. 0.032 0.040 ↑ 1.0 24 1

Bitmap Heap Scan on custom_fields cfs_1 (cost=4.49..100.74 rows=25 width=8) (actual time=0.013..0.040 rows=24 loops=1)

  • Recheck Cond: (sitefieldid = 496)
  • Filter: (active AND (clientid = 2))
  • Heap Blocks: exact=26
189. 0.008 0.008 ↓ 1.0 27 1

Bitmap Index Scan on idx_custom_fields_sitefieldid (cost=0.00..4.49 rows=26 width=0) (actual time=0.008..0.008 rows=27 loops=1)

  • Index Cond: (sitefieldid = 496)
190. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_1 (cost=0.42..8.34 rows=1 width=16) (never executed)

  • Index Cond: (customfieldid = cfv_1.customfieldid)
  • Filter: (((attribute)::text = 'values'::text) AND (cfv_1.value = (valueid)::text))
191. 0.000 216.957 ↓ 0.0 0 5,563

Nested Loop (cost=5.35..459.02 rows=1 width=8) (actual time=0.039..0.039 rows=0 loops=5,563)

192. 130.556 216.957 ↓ 0.0 0 5,563

Nested Loop (cost=4.93..250.21 rows=25 width=35) (actual time=0.039..0.039 rows=0 loops=5,563)

  • Join Filter: (cfs_6.id = cfv_6.customfieldid)
  • Rows Removed by Join Filter: 301
193. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_6 (cost=0.44..76.66 rows=194 width=27) (actual time=0.001..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
194. 69.671 69.712 ↑ 1.0 24 69,712

Materialize (cost=4.49..100.87 rows=25 width=8) (actual time=0.000..0.001 rows=24 loops=69,712)

195. 0.034 0.041 ↑ 1.0 24 1

Bitmap Heap Scan on custom_fields cfs_6 (cost=4.49..100.74 rows=25 width=8) (actual time=0.014..0.041 rows=24 loops=1)

  • Recheck Cond: (sitefieldid = 846)
  • Filter: (active AND (clientid = 2))
  • Heap Blocks: exact=24
196. 0.007 0.007 ↓ 1.0 27 1

Bitmap Index Scan on idx_custom_fields_sitefieldid (cost=0.00..4.49 rows=26 width=0) (actual time=0.007..0.007 rows=27 loops=1)

  • Index Cond: (sitefieldid = 846)
197. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_4 (cost=0.42..8.34 rows=1 width=16) (never executed)

  • Index Cond: (customfieldid = cfv_6.customfieldid)
  • Filter: (((attribute)::text = 'values'::text) AND (cfv_6.value = (valueid)::text))
198. 147.245 233.646 ↓ 0.0 0 5,563

Nested Loop (cost=4.91..237.26 rows=1 width=8) (actual time=0.042..0.042 rows=0 loops=5,563)

  • Join Filter: (cfv_5.customfieldid = cfs_5.id)
  • Rows Removed by Join Filter: 301
199. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_5 (cost=0.44..76.66 rows=194 width=16) (actual time=0.001..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
200. 69.668 69.712 ↓ 1.0 24 69,712

Materialize (cost=4.48..93.73 rows=23 width=8) (actual time=0.000..0.001 rows=24 loops=69,712)

201. 0.034 0.044 ↓ 1.0 24 1

Bitmap Heap Scan on custom_fields cfs_5 (cost=4.48..93.62 rows=23 width=8) (actual time=0.017..0.044 rows=24 loops=1)

  • Recheck Cond: (sitefieldid = 845)
  • Filter: (active AND (clientid = 2))
  • Heap Blocks: exact=26
202. 0.010 0.010 ↓ 1.1 27 1

Bitmap Index Scan on idx_custom_fields_sitefieldid (cost=0.00..4.47 rows=24 width=0) (actual time=0.010..0.010 rows=27 loops=1)

  • Index Cond: (sitefieldid = 845)
203. 130.556 216.957 ↓ 0.0 0 5,563

Nested Loop (cost=4.91..237.26 rows=1 width=8) (actual time=0.039..0.039 rows=0 loops=5,563)

  • Join Filter: (cfv_4.customfieldid = cfs_4.id)
  • Rows Removed by Join Filter: 301
204. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_4 (cost=0.44..76.66 rows=194 width=16) (actual time=0.001..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
205. 69.673 69.712 ↓ 1.0 24 69,712

Materialize (cost=4.48..93.73 rows=23 width=8) (actual time=0.000..0.001 rows=24 loops=69,712)

206. 0.030 0.039 ↓ 1.0 24 1

Bitmap Heap Scan on custom_fields cfs_4 (cost=4.48..93.62 rows=23 width=8) (actual time=0.016..0.039 rows=24 loops=1)

  • Recheck Cond: (sitefieldid = 844)
  • Filter: (active AND (clientid = 2))
  • Heap Blocks: exact=26
207. 0.009 0.009 ↓ 1.1 27 1

Bitmap Index Scan on idx_custom_fields_sitefieldid (cost=0.00..4.47 rows=24 width=0) (actual time=0.009..0.009 rows=27 loops=1)

  • Index Cond: (sitefieldid = 844)
208. 0.000 216.957 ↓ 0.0 0 5,563

Nested Loop (cost=5.37..488.63 rows=1 width=8) (actual time=0.039..0.039 rows=0 loops=5,563)

209. 130.556 216.957 ↓ 0.0 0 5,563

Nested Loop (cost=4.94..263.12 rows=27 width=35) (actual time=0.039..0.039 rows=0 loops=5,563)

  • Join Filter: (cfs_8.id = cfv_8.customfieldid)
  • Rows Removed by Join Filter: 301
210. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_8 (cost=0.44..76.66 rows=194 width=27) (actual time=0.001..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
211. 69.668 69.712 ↑ 1.1 24 69,712

Materialize (cost=4.51..107.96 rows=27 width=8) (actual time=0.000..0.001 rows=24 loops=69,712)

212. 0.035 0.044 ↑ 1.1 24 1

Bitmap Heap Scan on custom_fields cfs_8 (cost=4.51..107.83 rows=27 width=8) (actual time=0.018..0.044 rows=24 loops=1)

  • Recheck Cond: (sitefieldid = 849)
  • Filter: (active AND (clientid = 2))
  • Heap Blocks: exact=24
213. 0.009 0.009 ↑ 1.0 27 1

Bitmap Index Scan on idx_custom_fields_sitefieldid (cost=0.00..4.50 rows=28 width=0) (actual time=0.009..0.009 rows=27 loops=1)

  • Index Cond: (sitefieldid = 849)
214. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_6 (cost=0.42..8.34 rows=1 width=16) (never executed)

  • Index Cond: (customfieldid = cfv_8.customfieldid)
  • Filter: (((attribute)::text = 'values'::text) AND (cfv_8.value = (valueid)::text))
215. 130.556 216.957 ↓ 0.0 0 5,563

Nested Loop (cost=4.88..211.25 rows=1 width=8) (actual time=0.039..0.039 rows=0 loops=5,563)

  • Join Filter: (cfv_9.customfieldid = cfs_9.id)
  • Rows Removed by Join Filter: 301
216. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_9 (cost=0.44..76.66 rows=194 width=16) (actual time=0.001..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
217. 69.670 69.712 ↓ 1.3 24 69,712

Materialize (cost=4.44..79.35 rows=19 width=8) (actual time=0.000..0.001 rows=24 loops=69,712)

218. 0.033 0.042 ↓ 1.3 24 1

Bitmap Heap Scan on custom_fields cfs_9 (cost=4.44..79.25 rows=19 width=8) (actual time=0.014..0.042 rows=24 loops=1)

  • Recheck Cond: (sitefieldid = 850)
  • Filter: (active AND (clientid = 2))
  • Heap Blocks: exact=24
219. 0.009 0.009 ↓ 1.4 27 1

Bitmap Index Scan on idx_custom_fields_sitefieldid (cost=0.00..4.44 rows=20 width=0) (actual time=0.009..0.009 rows=27 loops=1)

  • Index Cond: (sitefieldid = 850)
220. 0.000 216.957 ↓ 0.0 0 5,563

Nested Loop (cost=5.34..429.36 rows=1 width=8) (actual time=0.039..0.039 rows=0 loops=5,563)

221. 130.556 216.957 ↓ 0.0 0 5,563

Nested Loop (cost=4.91..237.26 rows=23 width=35) (actual time=0.039..0.039 rows=0 loops=5,563)

  • Join Filter: (cfs_7.id = cfv_7.customfieldid)
  • Rows Removed by Join Filter: 301
222. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_7 (cost=0.44..76.66 rows=194 width=27) (actual time=0.001..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
223. 69.676 69.712 ↓ 1.0 24 69,712

Materialize (cost=4.48..93.73 rows=23 width=8) (actual time=0.000..0.001 rows=24 loops=69,712)

224. 0.026 0.036 ↓ 1.0 24 1

Bitmap Heap Scan on custom_fields cfs_7 (cost=4.48..93.62 rows=23 width=8) (actual time=0.015..0.036 rows=24 loops=1)

  • Recheck Cond: (sitefieldid = 848)
  • Filter: (active AND (clientid = 2))
  • Heap Blocks: exact=24
225. 0.010 0.010 ↓ 1.1 27 1

Bitmap Index Scan on idx_custom_fields_sitefieldid (cost=0.00..4.47 rows=24 width=0) (actual time=0.010..0.010 rows=27 loops=1)

  • Index Cond: (sitefieldid = 848)
226. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_5 (cost=0.42..8.34 rows=1 width=16) (never executed)

  • Index Cond: (customfieldid = cfv_7.customfieldid)
  • Filter: (((attribute)::text = 'values'::text) AND (cfv_7.value = (valueid)::text))
227. 0.000 216.957 ↓ 0.0 0 5,563

Nested Loop (cost=5.32..399.67 rows=1 width=8) (actual time=0.039..0.039 rows=0 loops=5,563)

228. 130.556 216.957 ↓ 0.0 0 5,563

Nested Loop (cost=4.90..224.27 rows=21 width=35) (actual time=0.039..0.039 rows=0 loops=5,563)

  • Join Filter: (cfs_11.id = cfv_11.customfieldid)
  • Rows Removed by Join Filter: 301
229. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_11 (cost=0.44..76.66 rows=194 width=27) (actual time=0.001..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
230. 69.673 69.712 ↓ 1.1 24 69,712

Materialize (cost=4.46..86.56 rows=21 width=8) (actual time=0.000..0.001 rows=24 loops=69,712)

231. 0.029 0.039 ↓ 1.1 24 1

Bitmap Heap Scan on custom_fields cfs_11 (cost=4.46..86.45 rows=21 width=8) (actual time=0.016..0.039 rows=24 loops=1)

  • Recheck Cond: (sitefieldid = 854)
  • Filter: (active AND (clientid = 2))
  • Heap Blocks: exact=23
232. 0.010 0.010 ↓ 1.2 27 1

Bitmap Index Scan on idx_custom_fields_sitefieldid (cost=0.00..4.46 rows=22 width=0) (actual time=0.010..0.010 rows=27 loops=1)

  • Index Cond: (sitefieldid = 854)
233. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_8 (cost=0.42..8.34 rows=1 width=16) (never executed)

  • Index Cond: (customfieldid = cfv_11.customfieldid)
  • Filter: (((attribute)::text = 'values'::text) AND (cfv_11.value = (valueid)::text))
234. 130.556 216.957 ↓ 0.0 0 5,563

Nested Loop (cost=4.94..263.12 rows=1 width=8) (actual time=0.039..0.039 rows=0 loops=5,563)

  • Join Filter: (cfv_12.customfieldid = cfs_12.id)
  • Rows Removed by Join Filter: 301
235. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_12 (cost=0.44..76.66 rows=194 width=16) (actual time=0.001..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
236. 69.671 69.712 ↑ 1.1 24 69,712

Materialize (cost=4.51..107.96 rows=27 width=8) (actual time=0.000..0.001 rows=24 loops=69,712)

237. 0.029 0.041 ↑ 1.1 24 1

Bitmap Heap Scan on custom_fields cfs_12 (cost=4.51..107.83 rows=27 width=8) (actual time=0.018..0.041 rows=24 loops=1)

  • Recheck Cond: (sitefieldid = 1363)
  • Filter: (active AND (clientid = 2))
  • Heap Blocks: exact=23
238. 0.012 0.012 ↑ 1.0 27 1

Bitmap Index Scan on idx_custom_fields_sitefieldid (cost=0.00..4.50 rows=28 width=0) (actual time=0.012..0.012 rows=27 loops=1)

  • Index Cond: (sitefieldid = 1363)
239. 0.000 216.957 ↓ 0.0 0 5,563

Nested Loop (cost=5.34..429.36 rows=1 width=8) (actual time=0.039..0.039 rows=0 loops=5,563)

240. 130.556 216.957 ↓ 0.0 0 5,563

Nested Loop (cost=4.91..237.26 rows=23 width=35) (actual time=0.039..0.039 rows=0 loops=5,563)

  • Join Filter: (cfs_10.id = cfv_10.customfieldid)
  • Rows Removed by Join Filter: 301
241. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_10 (cost=0.44..76.66 rows=194 width=27) (actual time=0.001..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
242. 69.675 69.712 ↓ 1.0 24 69,712

Materialize (cost=4.48..93.73 rows=23 width=8) (actual time=0.000..0.001 rows=24 loops=69,712)

243. 0.028 0.037 ↓ 1.0 24 1

Bitmap Heap Scan on custom_fields cfs_10 (cost=4.48..93.62 rows=23 width=8) (actual time=0.015..0.037 rows=24 loops=1)

  • Recheck Cond: (sitefieldid = 851)
  • Filter: (active AND (clientid = 2))
  • Heap Blocks: exact=24
244. 0.009 0.009 ↓ 1.1 27 1

Bitmap Index Scan on idx_custom_fields_sitefieldid (cost=0.00..4.47 rows=24 width=0) (actual time=0.009..0.009 rows=27 loops=1)

  • Index Cond: (sitefieldid = 851)
245. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_7 (cost=0.42..8.34 rows=1 width=16) (never executed)

  • Index Cond: (customfieldid = cfv_10.customfieldid)
  • Filter: (((attribute)::text = 'values'::text) AND (cfv_10.value = (valueid)::text))
246. 0.000 200.268 ↓ 0.0 0 5,563

Nested Loop (cost=5.35..459.02 rows=1 width=8) (actual time=0.036..0.036 rows=0 loops=5,563)

247. 113.867 200.268 ↓ 0.0 0 5,563

Nested Loop (cost=4.93..250.21 rows=25 width=35) (actual time=0.036..0.036 rows=0 loops=5,563)

  • Join Filter: (cfs_15.id = cfv_15.customfieldid)
  • Rows Removed by Join Filter: 276
248. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_15 (cost=0.44..76.66 rows=194 width=27) (actual time=0.001..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
249. 69.678 69.712 ↑ 1.1 22 69,712

Materialize (cost=4.49..100.87 rows=25 width=8) (actual time=0.000..0.001 rows=22 loops=69,712)

250. 0.026 0.034 ↑ 1.1 22 1

Bitmap Heap Scan on custom_fields cfs_15 (cost=4.49..100.74 rows=25 width=8) (actual time=0.014..0.034 rows=22 loops=1)

  • Recheck Cond: (sitefieldid = 11619)
  • Filter: (active AND (clientid = 2))
  • Heap Blocks: exact=17
251. 0.008 0.008 ↑ 1.1 24 1

Bitmap Index Scan on idx_custom_fields_sitefieldid (cost=0.00..4.49 rows=26 width=0) (actual time=0.008..0.008 rows=24 loops=1)

  • Index Cond: (sitefieldid = 11619)
252. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_10 (cost=0.42..8.34 rows=1 width=16) (never executed)

  • Index Cond: (customfieldid = cfv_15.customfieldid)
  • Filter: (((attribute)::text = 'values'::text) AND (cfv_15.value = (valueid)::text))
253. 113.867 200.268 ↓ 0.0 0 5,563

Nested Loop (cost=4.94..263.12 rows=1 width=8) (actual time=0.036..0.036 rows=0 loops=5,563)

  • Join Filter: (cfv_14.customfieldid = cfs_14.id)
  • Rows Removed by Join Filter: 276
254. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_14 (cost=0.44..76.66 rows=194 width=16) (actual time=0.001..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
255. 69.674 69.712 ↑ 1.2 22 69,712

Materialize (cost=4.51..107.96 rows=27 width=8) (actual time=0.000..0.001 rows=22 loops=69,712)

256. 0.029 0.038 ↑ 1.2 22 1

Bitmap Heap Scan on custom_fields cfs_14 (cost=4.51..107.83 rows=27 width=8) (actual time=0.016..0.038 rows=22 loops=1)

  • Recheck Cond: (sitefieldid = 1546)
  • Filter: (active AND (clientid = 2))
  • Heap Blocks: exact=21
257. 0.009 0.009 ↑ 1.2 24 1

Bitmap Index Scan on idx_custom_fields_sitefieldid (cost=0.00..4.50 rows=28 width=0) (actual time=0.009..0.009 rows=24 loops=1)

  • Index Cond: (sitefieldid = 1546)
258. 0.000 216.957 ↓ 0.0 0 5,563

Nested Loop (cost=5.35..459.02 rows=1 width=8) (actual time=0.039..0.039 rows=0 loops=5,563)

259. 130.556 216.957 ↓ 0.0 0 5,563

Nested Loop (cost=4.93..250.21 rows=25 width=35) (actual time=0.039..0.039 rows=0 loops=5,563)

  • Join Filter: (cfs_13.id = cfv_13.customfieldid)
  • Rows Removed by Join Filter: 301
260. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_13 (cost=0.44..76.66 rows=194 width=27) (actual time=0.001..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
261. 69.673 69.712 ↑ 1.0 24 69,712

Materialize (cost=4.49..100.87 rows=25 width=8) (actual time=0.000..0.001 rows=24 loops=69,712)

262. 0.030 0.039 ↑ 1.0 24 1

Bitmap Heap Scan on custom_fields cfs_13 (cost=4.49..100.74 rows=25 width=8) (actual time=0.016..0.039 rows=24 loops=1)

  • Recheck Cond: (sitefieldid = 1376)
  • Filter: (active AND (clientid = 2))
  • Heap Blocks: exact=21
263. 0.009 0.009 ↑ 1.0 26 1

Bitmap Index Scan on idx_custom_fields_sitefieldid (cost=0.00..4.49 rows=26 width=0) (actual time=0.009..0.009 rows=26 loops=1)

  • Index Cond: (sitefieldid = 1376)
264. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_9 (cost=0.42..8.34 rows=1 width=16) (never executed)

  • Index Cond: (customfieldid = cfv_13.customfieldid)
  • Filter: (((attribute)::text = 'values'::text) AND (cfv_13.value = (valueid)::text))
265. 5.563 44.504 ↓ 0.0 0 5,563

Nested Loop (cost=1.28..87.84 rows=1 width=8) (actual time=0.008..0.008 rows=0 loops=5,563)

266. 0.000 38.941 ↓ 0.0 0 5,563

Nested Loop (cost=0.85..54.43 rows=4 width=35) (actual time=0.007..0.007 rows=0 loops=5,563)

267. 22.252 22.252 ↑ 4.0 1 5,563

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_17 (cost=0.29..20.07 rows=4 width=8) (actual time=0.003..0.004 rows=1 loops=5,563)

  • Index Cond: (sitefieldid = 35971)
  • Filter: (active AND (clientid = 2))
268. 16.689 16.689 ↓ 0.0 0 5,563

Index Scan using idx_uq_custom_field_values_cus_obj_valmd5 on custom_field_values cfv_17 (cost=0.56..8.58 rows=1 width=27) (actual time=0.003..0.003 rows=0 loops=5,563)

  • Index Cond: ((customfieldid = cfs_17.id) AND (objectid = tcx.id))
269. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_11 (cost=0.42..8.34 rows=1 width=16) (never executed)

  • Index Cond: (customfieldid = cfv_17.customfieldid)
  • Filter: (((attribute)::text = 'values'::text) AND (cfv_17.value = (valueid)::text))
270. 0.000 27.815 ↓ 0.0 0 5,563

Nested Loop (cost=0.85..54.44 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=5,563)

271. 11.126 11.126 ↑ 4.0 1 5,563

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_16 (cost=0.29..20.07 rows=4 width=8) (actual time=0.002..0.002 rows=1 loops=5,563)

  • Index Cond: (sitefieldid = 35967)
  • Filter: (active AND (clientid = 2))
272. 16.689 16.689 ↓ 0.0 0 5,563

Index Only Scan using idx_custom_field_values_cf_obj on custom_field_values cfv_16 (cost=0.56..8.58 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=5,563)

  • Index Cond: ((customfieldid = cfs_16.id) AND (objectid = tcx.id))
  • Heap Fetches: 0
273. 2.114 11.126 ↑ 42.0 11 5,563

Materialize (cost=56,922.73..56,940.05 rows=462 width=8) (actual time=0.002..0.002 rows=11 loops=5,563)

274. 0.004 9.012 ↑ 42.0 11 1

Subquery Scan on cf18 (cost=56,922.73..56,937.74 rows=462 width=8) (actual time=9.004..9.012 rows=11 loops=1)

275. 0.005 9.008 ↑ 42.0 11 1

GroupAggregate (cost=56,922.73..56,933.12 rows=462 width=64) (actual time=9.003..9.008 rows=11 loops=1)

  • Group Key: cfs_124.clientid, cfs_124.sitefieldid, cfv_124.objectid, cfv_124.customfieldid
276. 0.016 9.003 ↑ 33.0 14 1

Sort (cost=56,922.73..56,923.88 rows=462 width=32) (actual time=9.001..9.003 rows=14 loops=1)

  • Sort Key: cfv_124.objectid, cfv_124.customfieldid
  • Sort Method: quicksort Memory: 26kB
277. 0.012 8.987 ↑ 33.0 14 1

Nested Loop (cost=1.15..56,902.28 rows=462 width=32) (actual time=0.164..8.987 rows=14 loops=1)

  • Join Filter: (cfs_124.id = cfv_124.customfieldid)
278. 0.004 0.023 ↑ 12.0 3 1

Nested Loop (cost=0.71..56.74 rows=36 width=40) (actual time=0.016..0.023 rows=3 loops=1)

279. 0.008 0.008 ↑ 4.0 1 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_124 (cost=0.29..20.07 rows=4 width=24) (actual time=0.006..0.008 rows=1 loops=1)

  • Index Cond: (sitefieldid = 35968)
  • Filter: (active AND (clientid = 2))
280. 0.011 0.011 ↑ 1.3 3 1

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_91 (cost=0.42..9.13 rows=4 width=16) (actual time=0.008..0.011 rows=3 loops=1)

  • Index Cond: (customfieldid = cfs_124.id)
  • Filter: ((attribute)::text = 'values'::text)
281. 8.952 8.952 ↑ 379.8 5 3

Index Scan using idx_custom_field_values_cus on custom_field_values cfv_124 (cost=0.44..1,555.31 rows=1,899 width=27) (actual time=0.240..2.984 rows=5 loops=3)

  • Index Cond: (customfieldid = cfc_91.customfieldid)
  • Filter: ((cfc_91.valueid)::text = ANY (regexp_split_to_array(btrim(value), '\s+'::text)))
  • Rows Removed by Filter: 1836
282. 60.021 66.756 ↑ 2.0 235 5,563

Materialize (cost=56,922.73..56,940.05 rows=462 width=8) (actual time=0.001..0.012 rows=235 loops=5,563)

283. 0.037 6.735 ↑ 2.0 235 1

Subquery Scan on cf19 (cost=56,922.73..56,937.74 rows=462 width=8) (actual time=6.576..6.735 rows=235 loops=1)

284. 0.104 6.698 ↑ 2.0 235 1

GroupAggregate (cost=56,922.73..56,933.12 rows=462 width=64) (actual time=6.576..6.698 rows=235 loops=1)

  • Group Key: cfs_125.clientid, cfs_125.sitefieldid, cfv_125.objectid, cfv_125.customfieldid
285. 0.123 6.594 ↑ 2.0 235 1

Sort (cost=56,922.73..56,923.88 rows=462 width=32) (actual time=6.573..6.594 rows=235 loops=1)

  • Sort Key: cfv_125.objectid, cfv_125.customfieldid
  • Sort Method: quicksort Memory: 43kB
286. 0.057 6.471 ↑ 2.0 235 1

Nested Loop (cost=1.15..56,902.28 rows=462 width=32) (actual time=0.375..6.471 rows=235 loops=1)

  • Join Filter: (cfs_125.id = cfv_125.customfieldid)
287. 0.002 0.022 ↑ 18.0 2 1

Nested Loop (cost=0.71..56.74 rows=36 width=40) (actual time=0.018..0.022 rows=2 loops=1)

288. 0.010 0.010 ↑ 4.0 1 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_125 (cost=0.29..20.07 rows=4 width=24) (actual time=0.008..0.010 rows=1 loops=1)

  • Index Cond: (sitefieldid = 35969)
  • Filter: (active AND (clientid = 2))
289. 0.010 0.010 ↑ 2.0 2 1

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_92 (cost=0.42..9.13 rows=4 width=16) (actual time=0.008..0.010 rows=2 loops=1)

  • Index Cond: (customfieldid = cfs_125.id)
  • Filter: ((attribute)::text = 'values'::text)
290. 6.392 6.392 ↑ 16.1 118 2

Index Scan using idx_custom_field_values_cus on custom_field_values cfv_125 (cost=0.44..1,555.31 rows=1,899 width=27) (actual time=0.370..3.196 rows=118 loops=2)

  • Index Cond: (customfieldid = cfc_92.customfieldid)
  • Filter: ((cfc_92.valueid)::text = ANY (regexp_split_to_array(btrim(value), '\s+'::text)))
  • Rows Removed by Filter: 1838
291. 5.563 55.630 ↓ 0.0 0 5,563

Nested Loop (cost=0.85..54.44 rows=1 width=8) (actual time=0.010..0.010 rows=0 loops=5,563)

292. 16.689 16.689 ↑ 1.3 3 5,563

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_21 (cost=0.29..20.07 rows=4 width=8) (actual time=0.002..0.003 rows=3 loops=5,563)

  • Index Cond: (sitefieldid = 47374)
  • Filter: (active AND (clientid = 2))
293. 33.378 33.378 ↓ 0.0 0 16,689

Index Only Scan using idx_custom_field_values_cf_obj on custom_field_values cfv_21 (cost=0.56..8.58 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=16,689)

  • Index Cond: ((customfieldid = cfs_21.id) AND (objectid = tcx.id))
  • Heap Fetches: 0
294. 0.000 22.252 ↓ 0.0 0 5,563

Nested Loop (cost=0.85..54.44 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=5,563)

295. 11.126 11.126 ↑ 4.0 1 5,563

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_20 (cost=0.29..20.07 rows=4 width=8) (actual time=0.002..0.002 rows=1 loops=5,563)

  • Index Cond: (sitefieldid = 36599)
  • Filter: (active AND (clientid = 2))
296. 11.126 11.126 ↓ 0.0 0 5,563

Index Only Scan using idx_custom_field_values_cf_obj on custom_field_values cfv_20 (cost=0.56..8.58 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=5,563)

  • Index Cond: ((customfieldid = cfs_20.id) AND (objectid = tcx.id))
  • Heap Fetches: 0
297. 0.000 22.252 ↓ 0.0 0 5,563

Nested Loop (cost=0.85..54.44 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=5,563)

298. 11.126 11.126 ↑ 4.0 1 5,563

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_19 (cost=0.29..20.07 rows=4 width=8) (actual time=0.002..0.002 rows=1 loops=5,563)

  • Index Cond: (sitefieldid = 36048)
  • Filter: (active AND (clientid = 2))
299. 11.126 11.126 ↓ 0.0 0 5,563

Index Only Scan using idx_custom_field_values_cf_obj on custom_field_values cfv_19 (cost=0.56..8.58 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=5,563)

  • Index Cond: ((customfieldid = cfs_19.id) AND (objectid = tcx.id))
  • Heap Fetches: 0
300. 0.000 22.252 ↓ 0.0 0 5,563

Nested Loop (cost=0.85..54.44 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=5,563)

301. 11.126 11.126 ↑ 4.0 1 5,563

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_18 (cost=0.29..20.07 rows=4 width=8) (actual time=0.001..0.002 rows=1 loops=5,563)

  • Index Cond: (sitefieldid = 35972)
  • Filter: (active AND (clientid = 2))
302. 11.126 11.126 ↓ 0.0 0 5,563

Index Only Scan using idx_custom_field_values_cf_obj on custom_field_values cfv_18 (cost=0.56..8.58 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=5,563)

  • Index Cond: ((customfieldid = cfs_18.id) AND (objectid = tcx.id))
  • Heap Fetches: 0
303. 5.563 50.067 ↓ 0.0 0 5,563

Nested Loop (cost=0.85..639.70 rows=13 width=8) (actual time=0.009..0.009 rows=0 loops=5,563)

  • Join Filter: (cfv_24.value = (usx.id)::text)
304. 5.563 44.504 ↓ 0.0 0 5,563

Nested Loop (cost=0.85..54.43 rows=4 width=19) (actual time=0.008..0.008 rows=0 loops=5,563)

305. 16.689 16.689 ↑ 2.0 2 5,563

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_24 (cost=0.29..20.07 rows=4 width=8) (actual time=0.002..0.003 rows=2 loops=5,563)

  • Index Cond: (sitefieldid = 48523)
  • Filter: (active AND (clientid = 2))
306. 22.252 22.252 ↓ 0.0 0 11,126

Index Scan using idx_uq_custom_field_values_cus_obj_valmd5 on custom_field_values cfv_24 (cost=0.56..8.58 rows=1 width=27) (actual time=0.002..0.002 rows=0 loops=11,126)

  • Index Cond: ((customfieldid = cfs_24.id) AND (objectid = tcx.id))
307. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..142.66 rows=5,711 width=8) (never executed)

308. 0.000 0.000 ↓ 0.0 0

Seq Scan on user_ext usx (cost=0.00..114.11 rows=5,711 width=8) (never executed)

309. 0.000 38.941 ↓ 0.0 0 5,563

Nested Loop (cost=0.85..54.44 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=5,563)

310. 16.689 16.689 ↑ 2.0 2 5,563

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_23 (cost=0.29..20.07 rows=4 width=8) (actual time=0.002..0.003 rows=2 loops=5,563)

  • Index Cond: (sitefieldid = 47576)
  • Filter: (active AND (clientid = 2))
311. 22.252 22.252 ↓ 0.0 0 11,126

Index Only Scan using idx_custom_field_values_cf_obj on custom_field_values cfv_23 (cost=0.56..8.58 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=11,126)

  • Index Cond: ((customfieldid = cfs_23.id) AND (objectid = tcx.id))
  • Heap Fetches: 0
312. 11.126 33.378 ↓ 0.0 0 5,563

Nested Loop (cost=0.85..54.44 rows=1 width=8) (actual time=0.006..0.006 rows=0 loops=5,563)

313. 11.126 11.126 ↑ 2.0 2 5,563

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_22 (cost=0.29..20.07 rows=4 width=8) (actual time=0.001..0.002 rows=2 loops=5,563)

  • Index Cond: (sitefieldid = 47575)
  • Filter: (active AND (clientid = 2))
314. 11.126 11.126 ↓ 0.0 0 11,126

Index Only Scan using idx_custom_field_values_cf_obj on custom_field_values cfv_22 (cost=0.56..8.58 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=11,126)

  • Index Cond: ((customfieldid = cfs_22.id) AND (objectid = tcx.id))
  • Heap Fetches: 0
315. 83.454 1,468.632 ↓ 0.0 0 5,563

Nested Loop (cost=5.78..1,464.49 rows=1 width=8) (actual time=0.264..0.264 rows=0 loops=5,563)

  • Join Filter: (cfs_26.id = inhcfc_1.valueid)
316. 775.515 1,006.903 ↓ 2.7 68 5,563

Nested Loop (cost=5.35..1,272.34 rows=25 width=32) (actual time=0.042..0.181 rows=68 loops=5,563)

  • Join Filter: ((cfc_13.valueid)::text = cfv_26.value)
  • Rows Removed by Join Filter: 872
317. 22.252 22.252 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_26 (cost=0.44..76.66 rows=194 width=27) (actual time=0.002..0.004 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
318. 208.915 209.136 ↑ 3.0 75 69,712

Materialize (cost=4.92..331.00 rows=223 width=24) (actual time=0.000..0.003 rows=75 loops=69,712)

319. 0.020 0.221 ↑ 3.0 75 1

Nested Loop (cost=4.92..329.89 rows=223 width=24) (actual time=0.030..0.221 rows=75 loops=1)

320. 0.040 0.051 ↑ 1.0 25 1

Bitmap Heap Scan on custom_fields cfs_26 (cost=4.49..100.74 rows=25 width=8) (actual time=0.018..0.051 rows=25 loops=1)

  • Recheck Cond: (sitefieldid = 862)
  • Filter: (active AND (clientid = 2))
  • Heap Blocks: exact=25
321. 0.011 0.011 ↑ 1.0 26 1

Bitmap Index Scan on idx_custom_fields_sitefieldid (cost=0.00..4.49 rows=26 width=0) (actual time=0.011..0.011 rows=26 loops=1)

  • Index Cond: (sitefieldid = 862)
322. 0.150 0.150 ↑ 1.3 3 25

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_13 (cost=0.42..9.13 rows=4 width=16) (actual time=0.005..0.006 rows=3 loops=25)

  • Index Cond: (customfieldid = cfs_26.id)
  • Filter: ((attribute)::text = 'values'::text)
  • Rows Removed by Filter: 1
323. 378.275 378.275 ↓ 0.0 0 378,275

Index Only Scan using idx_custom_field_configurations_valueid_cus on custom_field_configurations inhcfc_1 (cost=0.42..7.67 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=378,275)

  • Index Cond: ((valueid = cfc_13.customfieldid) AND (customfieldid = cfv_26.customfieldid))
  • Heap Fetches: 0
324. 58.424 2,570.106 ↓ 0.0 0 5,563

Nested Loop (cost=5.79..1,575.05 rows=1 width=8) (actual time=0.462..0.462 rows=0 loops=5,563)

  • Join Filter: (cfs_25.id = inhcfc.valueid)
325. 1,614.830 2,125.066 ↓ 2.6 69 5,563

Nested Loop (cost=5.37..1,367.53 rows=27 width=32) (actual time=0.082..0.382 rows=69 loops=5,563)

  • Join Filter: ((cfc_12.valueid)::text = cfv_25.value)
  • Rows Removed by Join Filter: 2036
326. 22.252 22.252 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_25 (cost=0.44..76.66 rows=194 width=27) (actual time=0.002..0.004 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
327. 487.742 487.984 ↑ 1.4 168 69,712

Materialize (cost=4.93..356.40 rows=241 width=24) (actual time=0.000..0.007 rows=168 loops=69,712)

328. 0.051 0.242 ↑ 1.4 168 1

Nested Loop (cost=4.93..355.19 rows=241 width=24) (actual time=0.028..0.242 rows=168 loops=1)

329. 0.034 0.047 ↑ 1.1 24 1

Bitmap Heap Scan on custom_fields cfs_25 (cost=4.51..107.83 rows=27 width=8) (actual time=0.019..0.047 rows=24 loops=1)

  • Recheck Cond: (sitefieldid = 858)
  • Filter: (active AND (clientid = 2))
  • Heap Blocks: exact=24
330. 0.013 0.013 ↑ 1.1 25 1

Bitmap Index Scan on idx_custom_fields_sitefieldid (cost=0.00..4.50 rows=28 width=0) (actual time=0.013..0.013 rows=25 loops=1)

  • Index Cond: (sitefieldid = 858)
331. 0.144 0.144 ↓ 1.8 7 24

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_12 (cost=0.42..9.12 rows=4 width=16) (actual time=0.003..0.006 rows=7 loops=24)

  • Index Cond: (customfieldid = cfs_25.id)
  • Filter: ((attribute)::text = 'values'::text)
  • Rows Removed by Filter: 1
332. 386.616 386.616 ↓ 0.0 0 386,616

Index Only Scan using idx_custom_field_configurations_valueid_cus on custom_field_configurations inhcfc (cost=0.42..7.67 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=386,616)

  • Index Cond: ((valueid = cfc_12.customfieldid) AND (customfieldid = cfv_25.customfieldid))
  • Heap Fetches: 0
333. 41.691 3,677.143 ↓ 0.0 0 5,563

Nested Loop (cost=5.37..44,025.53 rows=242 width=8) (actual time=0.661..0.661 rows=0 loops=5,563)

  • Join Filter: (cfs_29.id = cfc_16.valueid)
  • Rows Removed by Join Filter: 1092
334. 197.312 289.276 ↑ 17.4 301 5,563

Nested Loop (cost=4.94..250.03 rows=5,238 width=24) (actual time=0.002..0.052 rows=301 loops=5,563)

335. 22.252 22.252 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_29 (cost=0.44..76.66 rows=194 width=16) (actual time=0.002..0.004 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
336. 69.666 69.712 ↑ 1.1 24 69,712

Materialize (cost=4.51..107.96 rows=27 width=8) (actual time=0.000..0.001 rows=24 loops=69,712)

337. 0.034 0.046 ↑ 1.1 24 1

Bitmap Heap Scan on custom_fields cfs_29 (cost=4.51..107.83 rows=27 width=8) (actual time=0.019..0.046 rows=24 loops=1)

  • Recheck Cond: (sitefieldid = 872)
  • Filter: (active AND (clientid = 2))
  • Heap Blocks: exact=24
338. 0.012 0.012 ↑ 1.1 25 1

Bitmap Index Scan on idx_custom_fields_sitefieldid (cost=0.00..4.50 rows=28 width=0) (actual time=0.012..0.012 rows=25 loops=1)

  • Index Cond: (sitefieldid = 872)
339. 3,346.176 3,346.176 ↑ 1.5 4 1,673,088

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_16 (cost=0.42..8.28 rows=6 width=16) (actual time=0.001..0.002 rows=4 loops=1,673,088)

  • Index Cond: (customfieldid = cfv_29.customfieldid)
340. 30.565 3,671.580 ↓ 0.0 0 5,563

Nested Loop (cost=5.37..44,025.53 rows=242 width=8) (actual time=0.660..0.660 rows=0 loops=5,563)

  • Join Filter: (cfs_28.id = cfc_15.valueid)
  • Rows Removed by Join Filter: 1092
341. 202.875 294.839 ↑ 17.4 301 5,563

Nested Loop (cost=4.94..250.03 rows=5,238 width=24) (actual time=0.002..0.053 rows=301 loops=5,563)

342. 22.252 22.252 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_28 (cost=0.44..76.66 rows=194 width=16) (actual time=0.002..0.004 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
343. 69.672 69.712 ↑ 1.1 24 69,712

Materialize (cost=4.51..107.96 rows=27 width=8) (actual time=0.000..0.001 rows=24 loops=69,712)

344. 0.032 0.040 ↑ 1.1 24 1

Bitmap Heap Scan on custom_fields cfs_28 (cost=4.51..107.83 rows=27 width=8) (actual time=0.015..0.040 rows=24 loops=1)

  • Recheck Cond: (sitefieldid = 866)
  • Filter: (active AND (clientid = 2))
  • Heap Blocks: exact=24
345. 0.008 0.008 ↑ 1.1 25 1

Bitmap Index Scan on idx_custom_fields_sitefieldid (cost=0.00..4.50 rows=28 width=0) (actual time=0.008..0.008 rows=25 loops=1)

  • Index Cond: (sitefieldid = 866)
346. 3,346.176 3,346.176 ↑ 1.5 4 1,673,088

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_15 (cost=0.42..8.28 rows=6 width=16) (actual time=0.001..0.002 rows=4 loops=1,673,088)

  • Index Cond: (customfieldid = cfv_28.customfieldid)
347. 64.605 3,971.982 ↓ 0.0 0 5,563

Nested Loop (cost=5.83..1,851.59 rows=1 width=8) (actual time=0.714..0.714 rows=0 loops=5,563)

  • Join Filter: (cfs_27.id = inhcfc_2.valueid)
348. 2,640.331 3,499.127 ↓ 2.3 73 5,563

Nested Loop (cost=5.41..1,605.64 rows=32 width=32) (actual time=0.126..0.629 rows=73 loops=5,563)

  • Join Filter: ((cfc_14.valueid)::text = cfv_27.value)
  • Rows Removed by Join Filter: 3373
349. 22.252 22.252 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_27 (cost=0.44..76.66 rows=194 width=27) (actual time=0.002..0.004 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
350. 836.189 836.544 ↑ 1.0 275 69,712

Materialize (cost=4.97..420.02 rows=286 width=24) (actual time=0.000..0.012 rows=275 loops=69,712)

351. 0.062 0.355 ↑ 1.0 275 1

Nested Loop (cost=4.97..418.59 rows=286 width=24) (actual time=0.026..0.355 rows=275 loops=1)

352. 0.034 0.043 ↑ 1.3 25 1

Bitmap Heap Scan on custom_fields cfs_27 (cost=4.55..125.40 rows=32 width=8) (actual time=0.016..0.043 rows=25 loops=1)

  • Recheck Cond: (sitefieldid = 864)
  • Filter: (active AND (clientid = 2))
  • Heap Blocks: exact=24
353. 0.009 0.009 ↑ 1.3 26 1

Bitmap Index Scan on idx_custom_fields_sitefieldid (cost=0.00..4.54 rows=33 width=0) (actual time=0.009..0.009 rows=26 loops=1)

  • Index Cond: (sitefieldid = 864)
354. 0.250 0.250 ↓ 2.8 11 25

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_14 (cost=0.42..9.12 rows=4 width=16) (actual time=0.004..0.010 rows=11 loops=25)

  • Index Cond: (customfieldid = cfs_27.id)
  • Filter: ((attribute)::text = 'values'::text)
  • Rows Removed by Filter: 1
355. 408.250 408.250 ↓ 0.0 0 408,250

Index Only Scan using idx_custom_field_configurations_valueid_cus on custom_field_configurations inhcfc_2 (cost=0.42..7.67 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=408,250)

  • Index Cond: ((valueid = cfc_14.customfieldid) AND (customfieldid = cfv_27.customfieldid))
  • Heap Fetches: 0
356. 19.439 3,649.328 ↓ 0.0 0 5,563

Nested Loop (cost=5.32..34,261.70 rows=189 width=8) (actual time=0.656..0.656 rows=0 loops=5,563)

  • Join Filter: (cfs_32.id = cfc_19.valueid)
  • Rows Removed by Join Filter: 1092
357. 191.749 283.713 ↑ 13.5 301 5,563

Nested Loop (cost=4.90..214.09 rows=4,074 width=24) (actual time=0.002..0.051 rows=301 loops=5,563)

358. 22.252 22.252 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_32 (cost=0.44..76.66 rows=194 width=16) (actual time=0.002..0.004 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
359. 69.665 69.712 ↓ 1.1 24 69,712

Materialize (cost=4.46..86.56 rows=21 width=8) (actual time=0.000..0.001 rows=24 loops=69,712)

360. 0.035 0.047 ↓ 1.1 24 1

Bitmap Heap Scan on custom_fields cfs_32 (cost=4.46..86.45 rows=21 width=8) (actual time=0.020..0.047 rows=24 loops=1)

  • Recheck Cond: (sitefieldid = 878)
  • Filter: (active AND (clientid = 2))
  • Heap Blocks: exact=23
361. 0.012 0.012 ↓ 1.1 25 1

Bitmap Index Scan on idx_custom_fields_sitefieldid (cost=0.00..4.46 rows=22 width=0) (actual time=0.011..0.012 rows=25 loops=1)

  • Index Cond: (sitefieldid = 878)
362. 3,346.176 3,346.176 ↑ 1.5 4 1,673,088

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_19 (cost=0.42..8.28 rows=6 width=16) (actual time=0.001..0.002 rows=4 loops=1,673,088)

  • Index Cond: (customfieldid = cfv_32.customfieldid)
363. 0.000 3,782.840 ↓ 0.0 0 5,563

Nested Loop (cost=5.34..37,516.35 rows=206 width=8) (actual time=0.680..0.680 rows=0 loops=5,563)

  • Join Filter: (cfs_31.id = cfc_18.valueid)
  • Rows Removed by Join Filter: 1137
364. 208.438 300.402 ↑ 14.3 313 5,563

Nested Loop (cost=4.91..226.10 rows=4,462 width=24) (actual time=0.002..0.054 rows=313 loops=5,563)

365. 22.252 22.252 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_31 (cost=0.44..76.66 rows=194 width=16) (actual time=0.002..0.004 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
366. 69.668 69.712 ↓ 1.1 25 69,712

Materialize (cost=4.48..93.73 rows=23 width=8) (actual time=0.000..0.001 rows=25 loops=69,712)

367. 0.035 0.044 ↓ 1.1 25 1

Bitmap Heap Scan on custom_fields cfs_31 (cost=4.48..93.62 rows=23 width=8) (actual time=0.018..0.044 rows=25 loops=1)

  • Recheck Cond: (sitefieldid = 876)
  • Filter: (active AND (clientid = 2))
  • Heap Blocks: exact=24
368. 0.009 0.009 ↓ 1.1 26 1

Bitmap Index Scan on idx_custom_fields_sitefieldid (cost=0.00..4.47 rows=24 width=0) (actual time=0.009..0.009 rows=26 loops=1)

  • Index Cond: (sitefieldid = 876)
369. 3,485.600 3,485.600 ↑ 1.5 4 1,742,800

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_18 (cost=0.42..8.28 rows=6 width=16) (actual time=0.001..0.002 rows=4 loops=1,742,800)

  • Index Cond: (customfieldid = cfv_31.customfieldid)
370. 0.000 3,615.950 ↓ 0.0 0 5,563

Nested Loop (cost=5.35..40,770.96 rows=224 width=8) (actual time=0.650..0.650 rows=0 loops=5,563)

  • Join Filter: (cfs_30.id = cfc_17.valueid)
  • Rows Removed by Join Filter: 1092
371. 197.312 283.713 ↑ 16.1 301 5,563

Nested Loop (cost=4.93..238.08 rows=4,850 width=24) (actual time=0.002..0.051 rows=301 loops=5,563)

372. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_30 (cost=0.44..76.66 rows=194 width=16) (actual time=0.002..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
373. 69.672 69.712 ↑ 1.0 24 69,712

Materialize (cost=4.49..100.87 rows=25 width=8) (actual time=0.000..0.001 rows=24 loops=69,712)

374. 0.030 0.040 ↑ 1.0 24 1

Bitmap Heap Scan on custom_fields cfs_30 (cost=4.49..100.74 rows=25 width=8) (actual time=0.017..0.040 rows=24 loops=1)

  • Recheck Cond: (sitefieldid = 874)
  • Filter: (active AND (clientid = 2))
  • Heap Blocks: exact=24
375. 0.010 0.010 ↑ 1.0 25 1

Bitmap Index Scan on idx_custom_fields_sitefieldid (cost=0.00..4.49 rows=26 width=0) (actual time=0.010..0.010 rows=25 loops=1)

  • Index Cond: (sitefieldid = 874)
376. 3,346.176 3,346.176 ↑ 1.5 4 1,673,088

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_17 (cost=0.42..8.28 rows=6 width=16) (actual time=0.001..0.002 rows=4 loops=1,673,088)

  • Index Cond: (customfieldid = cfv_30.customfieldid)
377. 0.000 3,621.513 ↓ 0.0 0 5,563

Nested Loop (cost=5.35..40,770.96 rows=224 width=8) (actual time=0.651..0.651 rows=0 loops=5,563)

  • Join Filter: (cfs_35.id = cfc_22.valueid)
  • Rows Removed by Join Filter: 1092
378. 202.875 289.276 ↑ 16.1 301 5,563

Nested Loop (cost=4.93..238.08 rows=4,850 width=24) (actual time=0.002..0.052 rows=301 loops=5,563)

379. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_35 (cost=0.44..76.66 rows=194 width=16) (actual time=0.002..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
380. 69.668 69.712 ↑ 1.0 24 69,712

Materialize (cost=4.49..100.87 rows=25 width=8) (actual time=0.000..0.001 rows=24 loops=69,712)

381. 0.032 0.044 ↑ 1.0 24 1

Bitmap Heap Scan on custom_fields cfs_35 (cost=4.49..100.74 rows=25 width=8) (actual time=0.018..0.044 rows=24 loops=1)

  • Recheck Cond: (sitefieldid = 884)
  • Filter: (active AND (clientid = 2))
  • Heap Blocks: exact=24
382. 0.012 0.012 ↑ 1.0 25 1

Bitmap Index Scan on idx_custom_fields_sitefieldid (cost=0.00..4.49 rows=26 width=0) (actual time=0.012..0.012 rows=25 loops=1)

  • Index Cond: (sitefieldid = 884)
383. 3,346.176 3,346.176 ↑ 1.5 4 1,673,088

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_22 (cost=0.42..8.28 rows=6 width=16) (actual time=0.001..0.002 rows=4 loops=1,673,088)

  • Index Cond: (customfieldid = cfv_35.customfieldid)
384. 0.000 3,627.076 ↓ 0.0 0 5,563

Nested Loop (cost=5.35..40,770.96 rows=224 width=8) (actual time=0.652..0.652 rows=0 loops=5,563)

  • Join Filter: (cfs_34.id = cfc_21.valueid)
  • Rows Removed by Join Filter: 1092
385. 197.312 283.713 ↑ 16.1 301 5,563

Nested Loop (cost=4.93..238.08 rows=4,850 width=24) (actual time=0.002..0.051 rows=301 loops=5,563)

386. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_34 (cost=0.44..76.66 rows=194 width=16) (actual time=0.002..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
387. 69.671 69.712 ↑ 1.0 24 69,712

Materialize (cost=4.49..100.87 rows=25 width=8) (actual time=0.000..0.001 rows=24 loops=69,712)

388. 0.031 0.041 ↑ 1.0 24 1

Bitmap Heap Scan on custom_fields cfs_34 (cost=4.49..100.74 rows=25 width=8) (actual time=0.018..0.041 rows=24 loops=1)

  • Recheck Cond: (sitefieldid = 882)
  • Filter: (active AND (clientid = 2))
  • Heap Blocks: exact=24
389. 0.010 0.010 ↑ 1.0 25 1

Bitmap Index Scan on idx_custom_fields_sitefieldid (cost=0.00..4.49 rows=26 width=0) (actual time=0.010..0.010 rows=25 loops=1)

  • Index Cond: (sitefieldid = 882)
390. 3,346.176 3,346.176 ↑ 1.5 4 1,673,088

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_21 (cost=0.42..8.28 rows=6 width=16) (actual time=0.001..0.002 rows=4 loops=1,673,088)

  • Index Cond: (customfieldid = cfv_34.customfieldid)
391. 47.166 906.769 ↓ 0.0 0 5,563

Nested Loop (cost=1.58..303.91 rows=1 width=8) (actual time=0.163..0.163 rows=0 loops=5,563)

  • Join Filter: (cfs_33.id = inhcfc_3.valueid)
392. 400.187 561.863 ↓ 13.5 54 5,563

Nested Loop (cost=1.15..273.16 rows=4 width=32) (actual time=0.024..0.101 rows=54 loops=5,563)

  • Join Filter: ((cfc_20.valueid)::text = cfv_33.value)
  • Rows Removed by Join Filter: 448
393. 22.252 22.252 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_33 (cost=0.44..76.66 rows=194 width=27) (actual time=0.002..0.004 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
394. 139.279 139.424 ↓ 1.1 40 69,712

Materialize (cost=0.71..56.92 rows=36 width=24) (actual time=0.000..0.002 rows=40 loops=69,712)

395. 0.020 0.145 ↓ 1.1 40 1

Nested Loop (cost=0.71..56.74 rows=36 width=24) (actual time=0.018..0.145 rows=40 loops=1)

396. 0.025 0.025 ↓ 5.0 20 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_33 (cost=0.29..20.07 rows=4 width=8) (actual time=0.007..0.025 rows=20 loops=1)

  • Index Cond: (sitefieldid = 880)
  • Filter: (active AND (clientid = 2))
397. 0.100 0.100 ↑ 2.0 2 20

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_20 (cost=0.42..9.13 rows=4 width=16) (actual time=0.004..0.005 rows=2 loops=20)

  • Index Cond: (customfieldid = cfs_33.id)
  • Filter: ((attribute)::text = 'values'::text)
  • Rows Removed by Filter: 1
398. 297.740 297.740 ↓ 0.0 0 297,740

Index Only Scan using idx_custom_field_configurations_valueid_cus on custom_field_configurations inhcfc_3 (cost=0.42..7.67 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=297,740)

  • Index Cond: ((valueid = cfc_20.customfieldid) AND (customfieldid = cfv_33.customfieldid))
  • Heap Fetches: 0
399. 10.777 194.705 ↓ 0.0 0 5,563

Nested Loop (cost=1.15..6,591.70 rows=36 width=8) (actual time=0.035..0.035 rows=0 loops=5,563)

  • Join Filter: (cfs_37.id = cfc_24.valueid)
  • Rows Removed by Join Filter: 45
400. 27.815 44.504 ↑ 59.7 13 5,563

Nested Loop (cost=0.73..106.44 rows=776 width=24) (actual time=0.002..0.008 rows=13 loops=5,563)

401. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_37 (cost=0.44..76.66 rows=194 width=16) (actual time=0.002..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
402. 0.000 0.000 ↑ 4.0 1 69,712

Materialize (cost=0.29..20.09 rows=4 width=8) (actual time=0.000..0.000 rows=1 loops=69,712)

403. 0.010 0.010 ↑ 4.0 1 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_37 (cost=0.29..20.07 rows=4 width=8) (actual time=0.009..0.010 rows=1 loops=1)

  • Index Cond: (sitefieldid = 1569)
  • Filter: (active AND (clientid = 2))
404. 139.424 139.424 ↑ 1.5 4 69,712

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_24 (cost=0.42..8.28 rows=6 width=16) (actual time=0.001..0.002 rows=4 loops=69,712)

  • Index Cond: (customfieldid = cfv_37.customfieldid)
405. 2.401 3,788.403 ↓ 0.0 0 5,563

Nested Loop (cost=5.35..40,770.96 rows=224 width=8) (actual time=0.681..0.681 rows=0 loops=5,563)

  • Join Filter: (cfs_36.id = cfc_23.valueid)
  • Rows Removed by Join Filter: 1137
406. 214.001 300.402 ↑ 15.5 313 5,563

Nested Loop (cost=4.93..238.08 rows=4,850 width=24) (actual time=0.002..0.054 rows=313 loops=5,563)

407. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_36 (cost=0.44..76.66 rows=194 width=16) (actual time=0.002..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
408. 69.666 69.712 ↑ 1.0 25 69,712

Materialize (cost=4.49..100.87 rows=25 width=8) (actual time=0.000..0.001 rows=25 loops=69,712)

409. 0.035 0.046 ↑ 1.0 25 1

Bitmap Heap Scan on custom_fields cfs_36 (cost=4.49..100.74 rows=25 width=8) (actual time=0.017..0.046 rows=25 loops=1)

  • Recheck Cond: (sitefieldid = 886)
  • Filter: (active AND (clientid = 2))
  • Heap Blocks: exact=25
410. 0.011 0.011 ↑ 1.0 26 1

Bitmap Index Scan on idx_custom_fields_sitefieldid (cost=0.00..4.49 rows=26 width=0) (actual time=0.011..0.011 rows=26 loops=1)

  • Index Cond: (sitefieldid = 886)
411. 3,485.600 3,485.600 ↑ 1.5 4 1,742,800

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_23 (cost=0.42..8.28 rows=6 width=16) (actual time=0.001..0.002 rows=4 loops=1,742,800)

  • Index Cond: (customfieldid = cfv_36.customfieldid)
412. 9.709 3,042.961 ↓ 0.0 0 5,563

Nested Loop (cost=5.32..34,261.70 rows=189 width=8) (actual time=0.547..0.547 rows=0 loops=5,563)

  • Join Filter: (cfs_40.id = cfc_27.valueid)
  • Rows Removed by Join Filter: 910
413. 158.371 244.772 ↑ 16.2 251 5,563

Nested Loop (cost=4.90..214.09 rows=4,074 width=24) (actual time=0.002..0.044 rows=251 loops=5,563)

414. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_40 (cost=0.44..76.66 rows=194 width=16) (actual time=0.002..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
415. 69.680 69.712 ↑ 1.1 20 69,712

Materialize (cost=4.46..86.56 rows=21 width=8) (actual time=0.000..0.001 rows=20 loops=69,712)

416. 0.024 0.032 ↑ 1.1 20 1

Bitmap Heap Scan on custom_fields cfs_40 (cost=4.46..86.45 rows=21 width=8) (actual time=0.013..0.032 rows=20 loops=1)

  • Recheck Cond: (sitefieldid = 1589)
  • Filter: (active AND (clientid = 2))
  • Heap Blocks: exact=19
417. 0.008 0.008 ↑ 1.0 21 1

Bitmap Index Scan on idx_custom_fields_sitefieldid (cost=0.00..4.46 rows=22 width=0) (actual time=0.008..0.008 rows=21 loops=1)

  • Index Cond: (sitefieldid = 1589)
418. 2,788.480 2,788.480 ↑ 1.5 4 1,394,240

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_27 (cost=0.42..8.28 rows=6 width=16) (actual time=0.001..0.002 rows=4 loops=1,394,240)

  • Index Cond: (customfieldid = cfv_40.customfieldid)
419. 10.777 194.705 ↓ 0.0 0 5,563

Nested Loop (cost=1.15..6,591.70 rows=36 width=8) (actual time=0.035..0.035 rows=0 loops=5,563)

  • Join Filter: (cfs_39.id = cfc_26.valueid)
  • Rows Removed by Join Filter: 45
420. 27.815 44.504 ↑ 59.7 13 5,563

Nested Loop (cost=0.73..106.44 rows=776 width=24) (actual time=0.002..0.008 rows=13 loops=5,563)

421. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_39 (cost=0.44..76.66 rows=194 width=16) (actual time=0.002..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
422. 0.000 0.000 ↑ 4.0 1 69,712

Materialize (cost=0.29..20.09 rows=4 width=8) (actual time=0.000..0.000 rows=1 loops=69,712)

423. 0.008 0.008 ↑ 4.0 1 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_39 (cost=0.29..20.07 rows=4 width=8) (actual time=0.007..0.008 rows=1 loops=1)

  • Index Cond: (sitefieldid = 1575)
  • Filter: (active AND (clientid = 2))
424. 139.424 139.424 ↑ 1.5 4 69,712

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_26 (cost=0.42..8.28 rows=6 width=16) (actual time=0.001..0.002 rows=4 loops=69,712)

  • Index Cond: (customfieldid = cfv_39.customfieldid)
425. 11.493 189.142 ↓ 0.0 0 5,563

Nested Loop (cost=1.58..303.91 rows=1 width=8) (actual time=0.034..0.034 rows=0 loops=5,563)

  • Join Filter: (cfs_38.id = inhcfc_4.valueid)
426. 144.638 161.327 ↑ 1.3 3 5,563

Nested Loop (cost=1.15..273.16 rows=4 width=32) (actual time=0.009..0.029 rows=3 loops=5,563)

  • Join Filter: ((cfc_25.valueid)::text = cfv_38.value)
  • Rows Removed by Join Filter: 122
427. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_38 (cost=0.44..76.66 rows=194 width=27) (actual time=0.002..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
428. 0.000 0.000 ↑ 3.6 10 69,712

Materialize (cost=0.71..56.92 rows=36 width=24) (actual time=0.000..0.000 rows=10 loops=69,712)

429. 0.002 0.022 ↑ 3.6 10 1

Nested Loop (cost=0.71..56.74 rows=36 width=24) (actual time=0.015..0.022 rows=10 loops=1)

430. 0.008 0.008 ↑ 4.0 1 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_38 (cost=0.29..20.07 rows=4 width=8) (actual time=0.007..0.008 rows=1 loops=1)

  • Index Cond: (sitefieldid = 1573)
  • Filter: (active AND (clientid = 2))
431. 0.012 0.012 ↓ 2.5 10 1

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_25 (cost=0.42..9.13 rows=4 width=16) (actual time=0.007..0.012 rows=10 loops=1)

  • Index Cond: (customfieldid = cfs_38.id)
  • Filter: ((attribute)::text = 'values'::text)
  • Rows Removed by Filter: 1
432. 16.322 16.322 ↓ 0.0 0 16,322

Index Only Scan using idx_custom_field_configurations_valueid_cus on custom_field_configurations inhcfc_4 (cost=0.42..7.67 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=16,322)

  • Index Cond: ((valueid = cfc_25.customfieldid) AND (customfieldid = cfv_38.customfieldid))
  • Heap Fetches: 0
433. 10.777 194.705 ↓ 0.0 0 5,563

Nested Loop (cost=1.15..6,591.70 rows=36 width=8) (actual time=0.035..0.035 rows=0 loops=5,563)

  • Join Filter: (cfs_42.id = cfc_29.valueid)
  • Rows Removed by Join Filter: 45
434. 27.815 44.504 ↑ 59.7 13 5,563

Nested Loop (cost=0.73..106.44 rows=776 width=24) (actual time=0.002..0.008 rows=13 loops=5,563)

435. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_42 (cost=0.44..76.66 rows=194 width=16) (actual time=0.002..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
436. 0.000 0.000 ↑ 4.0 1 69,712

Materialize (cost=0.29..20.09 rows=4 width=8) (actual time=0.000..0.000 rows=1 loops=69,712)

437. 0.008 0.008 ↑ 4.0 1 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_42 (cost=0.29..20.07 rows=4 width=8) (actual time=0.006..0.008 rows=1 loops=1)

  • Index Cond: (sitefieldid = 1595)
  • Filter: (active AND (clientid = 2))
438. 139.424 139.424 ↑ 1.5 4 69,712

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_29 (cost=0.42..8.28 rows=6 width=16) (actual time=0.001..0.002 rows=4 loops=69,712)

  • Index Cond: (customfieldid = cfv_42.customfieldid)
439. 0.000 3,621.513 ↓ 0.0 0 5,563

Nested Loop (cost=5.32..34,261.70 rows=189 width=8) (actual time=0.651..0.651 rows=0 loops=5,563)

  • Join Filter: (cfs_41.id = cfc_28.valueid)
  • Rows Removed by Join Filter: 1092
440. 202.875 289.276 ↑ 13.5 301 5,563

Nested Loop (cost=4.90..214.09 rows=4,074 width=24) (actual time=0.002..0.052 rows=301 loops=5,563)

441. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_41 (cost=0.44..76.66 rows=194 width=16) (actual time=0.002..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
442. 69.670 69.712 ↓ 1.1 24 69,712

Materialize (cost=4.46..86.56 rows=21 width=8) (actual time=0.000..0.001 rows=24 loops=69,712)

443. 0.032 0.042 ↓ 1.1 24 1

Bitmap Heap Scan on custom_fields cfs_41 (cost=4.46..86.45 rows=21 width=8) (actual time=0.016..0.042 rows=24 loops=1)

  • Recheck Cond: (sitefieldid = 1593)
  • Filter: (active AND (clientid = 2))
  • Heap Blocks: exact=23
444. 0.010 0.010 ↓ 1.1 25 1

Bitmap Index Scan on idx_custom_fields_sitefieldid (cost=0.00..4.46 rows=22 width=0) (actual time=0.010..0.010 rows=25 loops=1)

  • Index Cond: (sitefieldid = 1593)
445. 3,346.176 3,346.176 ↑ 1.5 4 1,673,088

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_28 (cost=0.42..8.28 rows=6 width=16) (actual time=0.001..0.002 rows=4 loops=1,673,088)

  • Index Cond: (customfieldid = cfv_41.customfieldid)
446. 10.777 194.705 ↓ 0.0 0 5,563

Nested Loop (cost=1.15..6,591.70 rows=36 width=8) (actual time=0.035..0.035 rows=0 loops=5,563)

  • Join Filter: (cfs_44.id = cfc_31.valueid)
  • Rows Removed by Join Filter: 45
447. 27.815 44.504 ↑ 59.7 13 5,563

Nested Loop (cost=0.73..106.44 rows=776 width=24) (actual time=0.002..0.008 rows=13 loops=5,563)

448. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_44 (cost=0.44..76.66 rows=194 width=16) (actual time=0.002..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
449. 0.000 0.000 ↑ 4.0 1 69,712

Materialize (cost=0.29..20.09 rows=4 width=8) (actual time=0.000..0.000 rows=1 loops=69,712)

450. 0.008 0.008 ↑ 4.0 1 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_44 (cost=0.29..20.07 rows=4 width=8) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: (sitefieldid = 1601)
  • Filter: (active AND (clientid = 2))
451. 139.424 139.424 ↑ 1.5 4 69,712

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_31 (cost=0.42..8.28 rows=6 width=16) (actual time=0.001..0.002 rows=4 loops=69,712)

  • Index Cond: (customfieldid = cfv_44.customfieldid)
452. 13.016 322.654 ↓ 0.0 0 5,563

Nested Loop (cost=1.58..303.91 rows=1 width=8) (actual time=0.058..0.058 rows=0 loops=5,563)

  • Join Filter: (cfs_43.id = inhcfc_5.valueid)
453. 175.060 261.461 ↓ 2.2 9 5,563

Nested Loop (cost=1.15..273.16 rows=4 width=32) (actual time=0.013..0.047 rows=9 loops=5,563)

  • Join Filter: ((cfc_30.valueid)::text = cfv_43.value)
  • Rows Removed by Join Filter: 217
454. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_43 (cost=0.44..76.66 rows=194 width=27) (actual time=0.002..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
455. 69.667 69.712 ↑ 2.0 18 69,712

Materialize (cost=0.71..56.92 rows=36 width=24) (actual time=0.000..0.001 rows=18 loops=69,712)

456. 0.006 0.045 ↑ 2.0 18 1

Nested Loop (cost=0.71..56.74 rows=36 width=24) (actual time=0.016..0.045 rows=18 loops=1)

457. 0.009 0.009 ↑ 1.3 3 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_43 (cost=0.29..20.07 rows=4 width=8) (actual time=0.007..0.009 rows=3 loops=1)

  • Index Cond: (sitefieldid = 1597)
  • Filter: (active AND (clientid = 2))
458. 0.030 0.030 ↓ 1.5 6 3

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_30 (cost=0.42..9.13 rows=4 width=16) (actual time=0.005..0.010 rows=6 loops=3)

  • Index Cond: (customfieldid = cfs_43.id)
  • Filter: ((attribute)::text = 'values'::text)
  • Rows Removed by Filter: 1
459. 48.177 48.177 ↓ 0.0 0 48,177

Index Only Scan using idx_custom_field_configurations_valueid_cus on custom_field_configurations inhcfc_5 (cost=0.42..7.67 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=48,177)

  • Index Cond: ((valueid = cfc_30.customfieldid) AND (customfieldid = cfv_43.customfieldid))
  • Heap Fetches: 0
460. 10.777 194.705 ↓ 0.0 0 5,563

Nested Loop (cost=1.15..6,591.70 rows=36 width=8) (actual time=0.035..0.035 rows=0 loops=5,563)

  • Join Filter: (cfs_47.id = cfc_34.valueid)
  • Rows Removed by Join Filter: 45
461. 27.815 44.504 ↑ 59.7 13 5,563

Nested Loop (cost=0.73..106.44 rows=776 width=24) (actual time=0.002..0.008 rows=13 loops=5,563)

462. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_47 (cost=0.44..76.66 rows=194 width=16) (actual time=0.002..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
463. 0.000 0.000 ↑ 4.0 1 69,712

Materialize (cost=0.29..20.09 rows=4 width=8) (actual time=0.000..0.000 rows=1 loops=69,712)

464. 0.006 0.006 ↑ 4.0 1 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_47 (cost=0.29..20.07 rows=4 width=8) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: (sitefieldid = 1607)
  • Filter: (active AND (clientid = 2))
465. 139.424 139.424 ↑ 1.5 4 69,712

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_34 (cost=0.42..8.28 rows=6 width=16) (actual time=0.001..0.002 rows=4 loops=69,712)

  • Index Cond: (customfieldid = cfv_47.customfieldid)
466. 10.079 495.107 ↓ 0.0 0 5,563

Nested Loop (cost=1.15..6,591.70 rows=36 width=8) (actual time=0.089..0.089 rows=0 loops=5,563)

  • Join Filter: (cfs_46.id = cfc_33.valueid)
  • Rows Removed by Join Filter: 136
467. 50.067 66.756 ↑ 20.4 38 5,563

Nested Loop (cost=0.73..106.44 rows=776 width=24) (actual time=0.002..0.012 rows=38 loops=5,563)

468. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_46 (cost=0.44..76.66 rows=194 width=16) (actual time=0.002..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
469. 0.000 0.000 ↑ 1.3 3 69,712

Materialize (cost=0.29..20.09 rows=4 width=8) (actual time=0.000..0.000 rows=3 loops=69,712)

470. 0.007 0.007 ↑ 1.3 3 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_46 (cost=0.29..20.07 rows=4 width=8) (actual time=0.004..0.007 rows=3 loops=1)

  • Index Cond: (sitefieldid = 1605)
  • Filter: (active AND (clientid = 2))
471. 418.272 418.272 ↑ 1.5 4 209,136

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_33 (cost=0.42..8.28 rows=6 width=16) (actual time=0.001..0.002 rows=4 loops=209,136)

  • Index Cond: (customfieldid = cfv_46.customfieldid)
472. 7.468 283.713 ↓ 0.0 0 5,563

Nested Loop (cost=1.58..303.91 rows=1 width=8) (actual time=0.051..0.051 rows=0 loops=5,563)

  • Join Filter: (cfs_45.id = inhcfc_6.valueid)
473. 141.682 228.083 ↓ 2.2 9 5,563

Nested Loop (cost=1.15..273.16 rows=4 width=32) (actual time=0.011..0.041 rows=9 loops=5,563)

  • Join Filter: ((cfc_32.valueid)::text = cfv_45.value)
  • Rows Removed by Join Filter: 179
474. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_45 (cost=0.44..76.66 rows=194 width=27) (actual time=0.002..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
475. 69.679 69.712 ↑ 2.4 15 69,712

Materialize (cost=0.71..56.92 rows=36 width=24) (actual time=0.000..0.001 rows=15 loops=69,712)

476. 0.008 0.033 ↑ 2.4 15 1

Nested Loop (cost=0.71..56.74 rows=36 width=24) (actual time=0.012..0.033 rows=15 loops=1)

477. 0.007 0.007 ↑ 1.3 3 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_45 (cost=0.29..20.07 rows=4 width=8) (actual time=0.005..0.007 rows=3 loops=1)

  • Index Cond: (sitefieldid = 1603)
  • Filter: (active AND (clientid = 2))
478. 0.018 0.018 ↓ 1.2 5 3

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_32 (cost=0.42..9.13 rows=4 width=16) (actual time=0.004..0.006 rows=5 loops=3)

  • Index Cond: (customfieldid = cfs_45.id)
  • Filter: ((attribute)::text = 'values'::text)
  • Rows Removed by Filter: 1
479. 48.162 48.162 ↓ 0.0 0 48,162

Index Only Scan using idx_custom_field_configurations_valueid_cus on custom_field_configurations inhcfc_6 (cost=0.42..7.67 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=48,162)

  • Index Cond: ((valueid = cfc_32.customfieldid) AND (customfieldid = cfv_45.customfieldid))
  • Heap Fetches: 0
480. 10.777 194.705 ↓ 0.0 0 5,563

Nested Loop (cost=1.15..6,591.70 rows=36 width=8) (actual time=0.035..0.035 rows=0 loops=5,563)

  • Join Filter: (cfs_49.id = cfc_36.valueid)
  • Rows Removed by Join Filter: 45
481. 27.815 44.504 ↑ 59.7 13 5,563

Nested Loop (cost=0.73..106.44 rows=776 width=24) (actual time=0.002..0.008 rows=13 loops=5,563)

482. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_49 (cost=0.44..76.66 rows=194 width=16) (actual time=0.002..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
483. 0.000 0.000 ↑ 4.0 1 69,712

Materialize (cost=0.29..20.09 rows=4 width=8) (actual time=0.000..0.000 rows=1 loops=69,712)

484. 0.007 0.007 ↑ 4.0 1 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_49 (cost=0.29..20.07 rows=4 width=8) (actual time=0.006..0.007 rows=1 loops=1)

  • Index Cond: (sitefieldid = 1629)
  • Filter: (active AND (clientid = 2))
485. 139.424 139.424 ↑ 1.5 4 69,712

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_36 (cost=0.42..8.28 rows=6 width=16) (actual time=0.001..0.002 rows=4 loops=69,712)

  • Index Cond: (customfieldid = cfv_49.customfieldid)
486. 7.365 83.445 ↓ 0.0 0 5,563

Nested Loop (cost=1.58..303.91 rows=1 width=8) (actual time=0.015..0.015 rows=0 loops=5,563)

  • Join Filter: (cfs_48.id = inhcfc_7.valueid)
487. 44.504 61.193 ↑ 1.3 3 5,563

Nested Loop (cost=1.15..273.16 rows=4 width=32) (actual time=0.005..0.011 rows=3 loops=5,563)

  • Join Filter: ((cfc_35.valueid)::text = cfv_48.value)
  • Rows Removed by Join Filter: 22
488. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_48 (cost=0.44..76.66 rows=194 width=27) (actual time=0.001..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
489. 0.000 0.000 ↑ 18.0 2 69,712

Materialize (cost=0.71..56.92 rows=36 width=24) (actual time=0.000..0.000 rows=2 loops=69,712)

490. 0.003 0.015 ↑ 18.0 2 1

Nested Loop (cost=0.71..56.74 rows=36 width=24) (actual time=0.014..0.015 rows=2 loops=1)

491. 0.005 0.005 ↑ 4.0 1 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_48 (cost=0.29..20.07 rows=4 width=8) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (sitefieldid = 1609)
  • Filter: (active AND (clientid = 2))
492. 0.007 0.007 ↑ 2.0 2 1

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_35 (cost=0.42..9.13 rows=4 width=16) (actual time=0.005..0.007 rows=2 loops=1)

  • Index Cond: (customfieldid = cfs_48.id)
  • Filter: ((attribute)::text = 'values'::text)
  • Rows Removed by Filter: 1
493. 14.887 14.887 ↓ 0.0 0 14,887

Index Only Scan using idx_custom_field_configurations_valueid_cus on custom_field_configurations inhcfc_7 (cost=0.42..7.67 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=14,887)

  • Index Cond: ((valueid = cfc_35.customfieldid) AND (customfieldid = cfv_48.customfieldid))
  • Heap Fetches: 0
494. 57.264 2,397.653 ↓ 0.0 0 5,563

Nested Loop (cost=1.58..303.91 rows=1 width=8) (actual time=0.431..0.431 rows=0 loops=5,563)

  • Join Filter: (cfs_51.id = inhcfc_9.valueid)
495. 1,481.318 1,985.991 ↓ 16.0 64 5,563

Nested Loop (cost=1.15..273.16 rows=4 width=32) (actual time=0.077..0.357 rows=64 loops=5,563)

  • Join Filter: ((cfc_38.valueid)::text = cfv_51.value)
  • Rows Removed by Join Filter: 1866
496. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_51 (cost=0.44..76.66 rows=194 width=27) (actual time=0.002..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
497. 487.757 487.984 ↓ 4.3 154 69,712

Materialize (cost=0.71..56.92 rows=36 width=24) (actual time=0.000..0.007 rows=154 loops=69,712)

498. 0.027 0.227 ↓ 4.3 154 1

Nested Loop (cost=0.71..56.74 rows=36 width=24) (actual time=0.017..0.227 rows=154 loops=1)

499. 0.024 0.024 ↓ 5.5 22 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_51 (cost=0.29..20.07 rows=4 width=8) (actual time=0.006..0.024 rows=22 loops=1)

  • Index Cond: (sitefieldid = 1698)
  • Filter: (active AND (clientid = 2))
500. 0.176 0.176 ↓ 1.8 7 22

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_38 (cost=0.42..9.13 rows=4 width=16) (actual time=0.004..0.008 rows=7 loops=22)

  • Index Cond: (customfieldid = cfs_51.id)
  • Filter: ((attribute)::text = 'values'::text)
  • Rows Removed by Filter: 1
501. 354.398 354.398 ↓ 0.0 0 354,398

Index Only Scan using idx_custom_field_configurations_valueid_cus on custom_field_configurations inhcfc_9 (cost=0.42..7.67 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=354,398)

  • Index Cond: ((valueid = cfc_38.customfieldid) AND (customfieldid = cfv_51.customfieldid))
  • Heap Fetches: 0
502. 6.193 133.512 ↓ 0.0 0 5,563

Nested Loop (cost=1.58..303.91 rows=1 width=8) (actual time=0.024..0.024 rows=0 loops=5,563)

  • Join Filter: (cfs_50.id = inhcfc_8.valueid)
503. 89.008 111.260 ↑ 1.3 3 5,563

Nested Loop (cost=1.15..273.16 rows=4 width=32) (actual time=0.007..0.020 rows=3 loops=5,563)

  • Join Filter: ((cfc_37.valueid)::text = cfv_50.value)
  • Rows Removed by Join Filter: 72
504. 22.252 22.252 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_50 (cost=0.44..76.66 rows=194 width=27) (actual time=0.002..0.004 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
505. 0.000 0.000 ↑ 6.0 6 69,712

Materialize (cost=0.71..56.92 rows=36 width=24) (actual time=0.000..0.000 rows=6 loops=69,712)

506. 0.001 0.017 ↑ 6.0 6 1

Nested Loop (cost=0.71..56.74 rows=36 width=24) (actual time=0.015..0.017 rows=6 loops=1)

507. 0.007 0.007 ↑ 4.0 1 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_50 (cost=0.29..20.07 rows=4 width=8) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (sitefieldid = 1633)
  • Filter: (active AND (clientid = 2))
508. 0.009 0.009 ↓ 1.5 6 1

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_37 (cost=0.42..9.13 rows=4 width=16) (actual time=0.007..0.009 rows=6 loops=1)

  • Index Cond: (customfieldid = cfs_50.id)
  • Filter: ((attribute)::text = 'values'::text)
  • Rows Removed by Filter: 1
509. 16.059 16.059 ↓ 0.0 0 16,059

Index Only Scan using idx_custom_field_configurations_valueid_cus on custom_field_configurations inhcfc_8 (cost=0.42..7.67 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=16,059)

  • Index Cond: ((valueid = cfc_37.customfieldid) AND (customfieldid = cfv_50.customfieldid))
  • Heap Fetches: 0
510. 1.558 94.571 ↓ 0.0 0 5,563

Nested Loop (cost=1.58..303.91 rows=1 width=8) (actual time=0.017..0.017 rows=0 loops=5,563)

  • Join Filter: (cfs_53.id = inhcfc_11.valueid)
511. 61.193 77.882 ↑ 1.3 3 5,563

Nested Loop (cost=1.15..273.16 rows=4 width=32) (actual time=0.005..0.014 rows=3 loops=5,563)

  • Join Filter: ((cfc_40.valueid)::text = cfv_53.value)
  • Rows Removed by Join Filter: 35
512. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_53 (cost=0.44..76.66 rows=194 width=27) (actual time=0.002..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
513. 0.000 0.000 ↑ 12.0 3 69,712

Materialize (cost=0.71..56.92 rows=36 width=24) (actual time=0.000..0.000 rows=3 loops=69,712)

514. 0.003 0.019 ↑ 12.0 3 1

Nested Loop (cost=0.71..56.74 rows=36 width=24) (actual time=0.016..0.019 rows=3 loops=1)

515. 0.007 0.007 ↑ 4.0 1 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_53 (cost=0.29..20.07 rows=4 width=8) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (sitefieldid = 1877)
  • Filter: (active AND (clientid = 2))
516. 0.009 0.009 ↑ 1.3 3 1

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_40 (cost=0.42..9.13 rows=4 width=16) (actual time=0.007..0.009 rows=3 loops=1)

  • Index Cond: (customfieldid = cfs_53.id)
  • Filter: ((attribute)::text = 'values'::text)
  • Rows Removed by Filter: 1
517. 15.131 15.131 ↓ 0.0 0 15,131

Index Only Scan using idx_custom_field_configurations_valueid_cus on custom_field_configurations inhcfc_11 (cost=0.42..7.67 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=15,131)

  • Index Cond: ((valueid = cfc_40.customfieldid) AND (customfieldid = cfv_53.customfieldid))
  • Heap Fetches: 0
518. 6.198 122.386 ↓ 0.0 0 5,563

Nested Loop (cost=1.58..303.91 rows=1 width=8) (actual time=0.022..0.022 rows=0 loops=5,563)

  • Join Filter: (cfs_52.id = inhcfc_10.valueid)
519. 83.445 100.134 ↑ 1.3 3 5,563

Nested Loop (cost=1.15..273.16 rows=4 width=32) (actual time=0.006..0.018 rows=3 loops=5,563)

  • Join Filter: ((cfc_39.valueid)::text = cfv_52.value)
  • Rows Removed by Join Filter: 60
520. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_52 (cost=0.44..76.66 rows=194 width=27) (actual time=0.001..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
521. 0.000 0.000 ↑ 7.2 5 69,712

Materialize (cost=0.71..56.92 rows=36 width=24) (actual time=0.000..0.000 rows=5 loops=69,712)

522. 0.001 0.014 ↑ 7.2 5 1

Nested Loop (cost=0.71..56.74 rows=36 width=24) (actual time=0.013..0.014 rows=5 loops=1)

523. 0.007 0.007 ↑ 4.0 1 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_52 (cost=0.29..20.07 rows=4 width=8) (actual time=0.006..0.007 rows=1 loops=1)

  • Index Cond: (sitefieldid = 1873)
  • Filter: (active AND (clientid = 2))
524. 0.006 0.006 ↓ 1.2 5 1

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_39 (cost=0.42..9.13 rows=4 width=16) (actual time=0.006..0.006 rows=5 loops=1)

  • Index Cond: (customfieldid = cfs_52.id)
  • Filter: ((attribute)::text = 'values'::text)
  • Rows Removed by Filter: 1
525. 16.054 16.054 ↓ 0.0 0 16,054

Index Only Scan using idx_custom_field_configurations_valueid_cus on custom_field_configurations inhcfc_10 (cost=0.42..7.67 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=16,054)

  • Index Cond: ((valueid = cfc_39.customfieldid) AND (customfieldid = cfv_52.customfieldid))
  • Heap Fetches: 0
526. 587.235 767.694 ↑ 42.4 2,368 5,563

Materialize (cost=373,295.58..377,064.11 rows=100,494 width=8) (actual time=0.032..0.138 rows=2,368 loops=5,563)

527. 0.311 180.459 ↑ 42.4 2,368 1

Subquery Scan on cfts30 (cost=373,295.58..376,561.64 rows=100,494 width=8) (actual time=177.362..180.459 rows=2,368 loops=1)

528. 1.994 180.148 ↑ 42.4 2,368 1

GroupAggregate (cost=373,295.58..375,556.70 rows=100,494 width=64) (actual time=177.362..180.148 rows=2,368 loops=1)

  • Group Key: cfs_126.clientid, cfs_126.sitefieldid, cfv_126.objectid, cfv_126.customfieldid
529. 3.929 178.154 ↑ 14.4 6,957 1

Sort (cost=373,295.58..373,546.82 rows=100,494 width=32) (actual time=177.357..178.154 rows=6,957 loops=1)

  • Sort Key: cfv_126.objectid, cfv_126.customfieldid
  • Sort Method: quicksort Memory: 736kB
530. 51.300 174.225 ↑ 14.4 6,957 1

Merge Join (cost=1,706.41..364,946.16 rows=100,494 width=32) (actual time=15.318..174.225 rows=6,957 loops=1)

  • Merge Cond: (inhcfc_19.valueid = cfc_93.customfieldid)
  • Join Filter: ((cfc_93.valueid)::text = ANY (regexp_split_to_array(btrim(cfv_126.value), '\s+'::text)))
  • Rows Removed by Join Filter: 2515
531. 0.488 44.333 ↑ 97.1 2,368 1

Nested Loop (cost=36.69..308,366.82 rows=230,019 width=59) (actual time=3.383..44.333 rows=2,368 loops=1)

532. 0.073 41.895 ↑ 9.3 26 1

Nested Loop (cost=36.25..49,564.09 rows=242 width=40) (actual time=0.997..41.895 rows=26 loops=1)

533. 41.712 41.712 ↑ 1.2 22 1

Index Scan using pk_custom_fields on custom_fields cfs_126 (cost=0.29..4,999.46 rows=27 width=24) (actual time=0.988..41.712 rows=22 loops=1)

  • Filter: (active AND (sitefieldid = 2117) AND (clientid = 2))
  • Rows Removed by Filter: 80196
534. 0.044 0.110 ↑ 1,030.0 1 22

Bitmap Heap Scan on custom_field_configurations inhcfc_19 (cost=35.96..1,640.24 rows=1,030 width=16) (actual time=0.005..0.005 rows=1 loops=22)

  • Recheck Cond: (valueid = cfs_126.id)
  • Heap Blocks: exact=26
535. 0.066 0.066 ↑ 1,030.0 1 22

Bitmap Index Scan on idx_custom_field_configurations_valueid_cus (cost=0.00..35.71 rows=1,030 width=0) (actual time=0.003..0.003 rows=1 loops=22)

  • Index Cond: (valueid = cfs_126.id)
536. 1.950 1.950 ↑ 426.8 91 26

Index Scan using idx_custom_field_values_cus on custom_field_values cfv_126 (cost=0.44..681.08 rows=38,835 width=27) (actual time=0.005..0.075 rows=91 loops=26)

  • Index Cond: (customfieldid = inhcfc_19.customfieldid)
537. 18.340 78.592 ↑ 5.2 113,059 1

Materialize (cost=0.42..39,109.69 rows=584,337 width=16) (actual time=0.019..78.592 rows=113,059 loops=1)

538. 60.252 60.252 ↑ 5.6 103,603 1

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_93 (cost=0.42..37,648.84 rows=584,337 width=16) (actual time=0.013..60.252 rows=103,603 loops=1)

  • Filter: ((attribute)::text = 'values'::text)
  • Rows Removed by Filter: 44232
539. 26.768 511.796 ↑ 36.0 1 5,563

Nested Loop (cost=1.15..6,591.70 rows=36 width=8) (actual time=0.085..0.092 rows=1 loops=5,563)

  • Join Filter: (cfs_56.id = cfc_43.valueid)
  • Rows Removed by Join Filter: 135
540. 44.504 66.756 ↑ 20.4 38 5,563

Nested Loop (cost=0.73..106.44 rows=776 width=24) (actual time=0.002..0.012 rows=38 loops=5,563)

541. 22.252 22.252 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_56 (cost=0.44..76.66 rows=194 width=16) (actual time=0.002..0.004 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
542. 0.000 0.000 ↑ 1.3 3 69,712

Materialize (cost=0.29..20.09 rows=4 width=8) (actual time=0.000..0.000 rows=3 loops=69,712)

543. 0.012 0.012 ↑ 1.3 3 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_56 (cost=0.29..20.07 rows=4 width=8) (actual time=0.008..0.012 rows=3 loops=1)

  • Index Cond: (sitefieldid = 47335)
  • Filter: (active AND (clientid = 2))
544. 418.272 418.272 ↑ 1.5 4 209,136

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_43 (cost=0.42..8.28 rows=6 width=16) (actual time=0.001..0.002 rows=4 loops=209,136)

  • Index Cond: (customfieldid = cfv_56.customfieldid)
545. 21.205 506.233 ↑ 36.0 1 5,563

Nested Loop (cost=1.15..6,591.70 rows=36 width=8) (actual time=0.090..0.091 rows=1 loops=5,563)

  • Join Filter: (cfs_55.id = cfc_42.valueid)
  • Rows Removed by Join Filter: 135
546. 44.504 66.756 ↑ 20.4 38 5,563

Nested Loop (cost=0.73..106.44 rows=776 width=24) (actual time=0.002..0.012 rows=38 loops=5,563)

547. 22.252 22.252 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_55 (cost=0.44..76.66 rows=194 width=16) (actual time=0.002..0.004 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
548. 0.000 0.000 ↑ 1.3 3 69,712

Materialize (cost=0.29..20.09 rows=4 width=8) (actual time=0.000..0.000 rows=3 loops=69,712)

549. 0.009 0.009 ↑ 1.3 3 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_55 (cost=0.29..20.07 rows=4 width=8) (actual time=0.005..0.009 rows=3 loops=1)

  • Index Cond: (sitefieldid = 47333)
  • Filter: (active AND (clientid = 2))
550. 418.272 418.272 ↑ 1.5 4 209,136

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_42 (cost=0.42..8.28 rows=6 width=16) (actual time=0.001..0.002 rows=4 loops=209,136)

  • Index Cond: (customfieldid = cfv_55.customfieldid)
551. 0.000 350.469 ↓ 0.0 0 5,563

Nested Loop (cost=1.15..10,832.01 rows=117 width=8) (actual time=0.063..0.063 rows=0 loops=5,563)

  • Join Filter: (cfv_54.value = (usx_1.id)::text)
552. 15.991 350.469 ↓ 0.0 0 5,563

Nested Loop (cost=1.15..6,591.70 rows=36 width=19) (actual time=0.063..0.063 rows=0 loops=5,563)

  • Join Filter: (cfs_54.id = cfc_41.valueid)
  • Rows Removed by Join Filter: 91
553. 38.941 55.630 ↑ 31.0 25 5,563

Nested Loop (cost=0.73..106.44 rows=776 width=35) (actual time=0.002..0.010 rows=25 loops=5,563)

554. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_54 (cost=0.44..76.66 rows=194 width=27) (actual time=0.002..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
555. 0.000 0.000 ↑ 2.0 2 69,712

Materialize (cost=0.29..20.09 rows=4 width=8) (actual time=0.000..0.000 rows=2 loops=69,712)

556. 0.008 0.008 ↑ 2.0 2 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_54 (cost=0.29..20.07 rows=4 width=8) (actual time=0.006..0.008 rows=2 loops=1)

  • Index Cond: (sitefieldid = 1881)
  • Filter: (active AND (clientid = 2))
557. 278.848 278.848 ↑ 1.5 4 139,424

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_41 (cost=0.42..8.28 rows=6 width=16) (actual time=0.001..0.002 rows=4 loops=139,424)

  • Index Cond: (customfieldid = cfv_54.customfieldid)
558. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..142.66 rows=5,711 width=8) (never executed)

559. 0.000 0.000 ↓ 0.0 0

Seq Scan on user_ext usx_1 (cost=0.00..114.11 rows=5,711 width=8) (never executed)

560. 15.642 500.670 ↑ 36.0 1 5,563

Nested Loop (cost=1.15..6,591.70 rows=36 width=8) (actual time=0.069..0.090 rows=1 loops=5,563)

  • Join Filter: (cfs_59.id = cfc_46.valueid)
  • Rows Removed by Join Filter: 135
561. 50.067 66.756 ↑ 20.4 38 5,563

Nested Loop (cost=0.73..106.44 rows=776 width=24) (actual time=0.002..0.012 rows=38 loops=5,563)

562. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_59 (cost=0.44..76.66 rows=194 width=16) (actual time=0.002..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
563. 0.000 0.000 ↑ 1.3 3 69,712

Materialize (cost=0.29..20.09 rows=4 width=8) (actual time=0.000..0.000 rows=3 loops=69,712)

564. 0.006 0.006 ↑ 1.3 3 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_59 (cost=0.29..20.07 rows=4 width=8) (actual time=0.004..0.006 rows=3 loops=1)

  • Index Cond: (sitefieldid = 47341)
  • Filter: (active AND (clientid = 2))
565. 418.272 418.272 ↑ 1.5 4 209,136

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_46 (cost=0.42..8.28 rows=6 width=16) (actual time=0.001..0.002 rows=4 loops=209,136)

  • Index Cond: (customfieldid = cfv_59.customfieldid)
566. 21.205 506.233 ↑ 36.0 1 5,563

Nested Loop (cost=1.15..6,591.70 rows=36 width=8) (actual time=0.075..0.091 rows=1 loops=5,563)

  • Join Filter: (cfs_58.id = cfc_45.valueid)
  • Rows Removed by Join Filter: 135
567. 44.504 66.756 ↑ 20.4 38 5,563

Nested Loop (cost=0.73..106.44 rows=776 width=24) (actual time=0.002..0.012 rows=38 loops=5,563)

568. 22.252 22.252 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_58 (cost=0.44..76.66 rows=194 width=16) (actual time=0.002..0.004 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
569. 0.000 0.000 ↑ 1.3 3 69,712

Materialize (cost=0.29..20.09 rows=4 width=8) (actual time=0.000..0.000 rows=3 loops=69,712)

570. 0.008 0.008 ↑ 1.3 3 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_58 (cost=0.29..20.07 rows=4 width=8) (actual time=0.006..0.008 rows=3 loops=1)

  • Index Cond: (sitefieldid = 47339)
  • Filter: (active AND (clientid = 2))
571. 418.272 418.272 ↑ 1.5 4 209,136

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_45 (cost=0.42..8.28 rows=6 width=16) (actual time=0.001..0.002 rows=4 loops=209,136)

  • Index Cond: (customfieldid = cfv_58.customfieldid)
572. 15.642 500.670 ↑ 36.0 1 5,563

Nested Loop (cost=1.15..6,591.70 rows=36 width=8) (actual time=0.079..0.090 rows=1 loops=5,563)

  • Join Filter: (cfs_57.id = cfc_44.valueid)
  • Rows Removed by Join Filter: 135
573. 44.504 66.756 ↑ 20.4 38 5,563

Nested Loop (cost=0.73..106.44 rows=776 width=24) (actual time=0.002..0.012 rows=38 loops=5,563)

574. 22.252 22.252 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_57 (cost=0.44..76.66 rows=194 width=16) (actual time=0.002..0.004 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
575. 0.000 0.000 ↑ 1.3 3 69,712

Materialize (cost=0.29..20.09 rows=4 width=8) (actual time=0.000..0.000 rows=3 loops=69,712)

576. 0.009 0.009 ↑ 1.3 3 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_57 (cost=0.29..20.07 rows=4 width=8) (actual time=0.006..0.009 rows=3 loops=1)

  • Index Cond: (sitefieldid = 47337)
  • Filter: (active AND (clientid = 2))
577. 418.272 418.272 ↑ 1.5 4 209,136

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_44 (cost=0.42..8.28 rows=6 width=16) (actual time=0.001..0.002 rows=4 loops=209,136)

  • Index Cond: (customfieldid = cfv_57.customfieldid)
578. 32.331 522.922 ↑ 36.0 1 5,563

Nested Loop (cost=1.15..6,591.70 rows=36 width=8) (actual time=0.055..0.094 rows=1 loops=5,563)

  • Join Filter: (cfs_61.id = cfc_48.valueid)
  • Rows Removed by Join Filter: 135
579. 50.067 72.319 ↑ 20.4 38 5,563

Nested Loop (cost=0.73..106.44 rows=776 width=24) (actual time=0.002..0.013 rows=38 loops=5,563)

580. 22.252 22.252 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_61 (cost=0.44..76.66 rows=194 width=16) (actual time=0.001..0.004 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
581. 0.000 0.000 ↑ 1.3 3 69,712

Materialize (cost=0.29..20.09 rows=4 width=8) (actual time=0.000..0.000 rows=3 loops=69,712)

582. 0.010 0.010 ↑ 1.3 3 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_61 (cost=0.29..20.07 rows=4 width=8) (actual time=0.006..0.010 rows=3 loops=1)

  • Index Cond: (sitefieldid = 47345)
  • Filter: (active AND (clientid = 2))
583. 418.272 418.272 ↑ 1.5 4 209,136

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_48 (cost=0.42..8.28 rows=6 width=16) (actual time=0.001..0.002 rows=4 loops=209,136)

  • Index Cond: (customfieldid = cfv_61.customfieldid)
584. 21.363 233.646 ↑ 1.0 1 5,563

Nested Loop (cost=1.58..303.91 rows=1 width=29) (actual time=0.029..0.042 rows=1 loops=5,563)

  • Join Filter: (cfs_60.id = inhcfc_12.valueid)
585. 144.638 166.890 ↓ 2.0 8 5,563

Nested Loop (cost=1.15..273.16 rows=4 width=53) (actual time=0.009..0.030 rows=8 loops=5,563)

  • Join Filter: ((cfc_47.valueid)::text = cfv_60.value)
  • Rows Removed by Join Filter: 105
586. 22.252 22.252 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_60 (cost=0.44..76.66 rows=194 width=27) (actual time=0.001..0.004 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
587. 0.000 0.000 ↑ 4.0 9 69,712

Materialize (cost=0.71..56.92 rows=36 width=45) (actual time=0.000..0.000 rows=9 loops=69,712)

588. 0.003 0.033 ↑ 4.0 9 1

Nested Loop (cost=0.71..56.74 rows=36 width=45) (actual time=0.016..0.033 rows=9 loops=1)

589. 0.009 0.009 ↑ 1.3 3 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_60 (cost=0.29..20.07 rows=4 width=8) (actual time=0.005..0.009 rows=3 loops=1)

  • Index Cond: (sitefieldid = 47343)
  • Filter: (active AND (clientid = 2))
590. 0.021 0.021 ↑ 1.3 3 3

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_47 (cost=0.42..9.13 rows=4 width=37) (actual time=0.006..0.007 rows=3 loops=3)

  • Index Cond: (customfieldid = cfs_60.id)
  • Filter: ((attribute)::text = 'values'::text)
  • Rows Removed by Filter: 1
591. 45.393 45.393 ↓ 0.0 0 45,393

Index Only Scan using idx_custom_field_configurations_valueid_cus on custom_field_configurations inhcfc_12 (cost=0.42..7.67 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=45,393)

  • Index Cond: ((valueid = cfc_47.customfieldid) AND (customfieldid = cfv_60.customfieldid))
  • Heap Fetches: 5480
592. 6.823 228.083 ↓ 0.0 0 5,563

Nested Loop (cost=1.58..303.91 rows=1 width=8) (actual time=0.041..0.041 rows=0 loops=5,563)

  • Join Filter: (cfs_63.id = inhcfc_14.valueid)
593. 97.178 189.142 ↓ 1.5 6 5,563

Nested Loop (cost=1.15..273.16 rows=4 width=32) (actual time=0.010..0.034 rows=6 loops=5,563)

  • Join Filter: ((cfc_50.valueid)::text = cfv_63.value)
  • Rows Removed by Join Filter: 145
594. 22.252 22.252 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_63 (cost=0.44..76.66 rows=194 width=27) (actual time=0.002..0.004 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
595. 69.676 69.712 ↑ 3.0 12 69,712

Materialize (cost=0.71..56.92 rows=36 width=24) (actual time=0.000..0.001 rows=12 loops=69,712)

596. 0.008 0.036 ↑ 3.0 12 1

Nested Loop (cost=0.71..56.74 rows=36 width=24) (actual time=0.017..0.036 rows=12 loops=1)

597. 0.008 0.008 ↑ 2.0 2 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_63 (cost=0.29..20.07 rows=4 width=8) (actual time=0.006..0.008 rows=2 loops=1)

  • Index Cond: (sitefieldid = 47511)
  • Filter: (active AND (clientid = 2))
598. 0.020 0.020 ↓ 1.5 6 2

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_50 (cost=0.42..9.13 rows=4 width=16) (actual time=0.005..0.010 rows=6 loops=2)

  • Index Cond: (customfieldid = cfs_63.id)
  • Filter: ((attribute)::text = 'values'::text)
  • Rows Removed by Filter: 1
599. 32.118 32.118 ↓ 0.0 0 32,118

Index Only Scan using idx_custom_field_configurations_valueid_cus on custom_field_configurations inhcfc_14 (cost=0.42..7.67 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=32,118)

  • Index Cond: ((valueid = cfc_50.customfieldid) AND (customfieldid = cfv_63.customfieldid))
  • Heap Fetches: 0
600. 8.158 244.772 ↓ 0.0 0 5,563

Nested Loop (cost=1.58..303.91 rows=1 width=8) (actual time=0.044..0.044 rows=0 loops=5,563)

  • Join Filter: (cfs_62.id = inhcfc_13.valueid)
601. 102.741 189.142 ↓ 2.2 9 5,563

Nested Loop (cost=1.15..273.16 rows=4 width=32) (actual time=0.010..0.034 rows=9 loops=5,563)

  • Join Filter: ((cfc_49.valueid)::text = cfv_62.value)
  • Rows Removed by Join Filter: 142
602. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_62 (cost=0.44..76.66 rows=194 width=27) (actual time=0.002..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
603. 69.675 69.712 ↑ 3.0 12 69,712

Materialize (cost=0.71..56.92 rows=36 width=24) (actual time=0.000..0.001 rows=12 loops=69,712)

604. 0.004 0.037 ↑ 3.0 12 1

Nested Loop (cost=0.71..56.74 rows=36 width=24) (actual time=0.016..0.037 rows=12 loops=1)

605. 0.009 0.009 ↑ 1.3 3 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_62 (cost=0.29..20.07 rows=4 width=8) (actual time=0.006..0.009 rows=3 loops=1)

  • Index Cond: (sitefieldid = 47347)
  • Filter: (active AND (clientid = 2))
606. 0.024 0.024 ↑ 1.0 4 3

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_49 (cost=0.42..9.13 rows=4 width=16) (actual time=0.005..0.008 rows=4 loops=3)

  • Index Cond: (customfieldid = cfs_62.id)
  • Filter: ((attribute)::text = 'values'::text)
  • Rows Removed by Filter: 1
607. 47.472 47.472 ↓ 0.0 0 47,472

Index Only Scan using idx_custom_field_configurations_valueid_cus on custom_field_configurations inhcfc_13 (cost=0.42..7.67 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=47,472)

  • Index Cond: ((valueid = cfc_49.customfieldid) AND (customfieldid = cfv_62.customfieldid))
  • Heap Fetches: 23
608. 15.991 350.469 ↓ 0.0 0 5,563

Nested Loop (cost=1.15..6,591.70 rows=36 width=8) (actual time=0.063..0.063 rows=0 loops=5,563)

  • Join Filter: (cfs_65.id = cfc_52.valueid)
  • Rows Removed by Join Filter: 91
609. 38.941 55.630 ↑ 31.0 25 5,563

Nested Loop (cost=0.73..106.44 rows=776 width=24) (actual time=0.002..0.010 rows=25 loops=5,563)

610. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_65 (cost=0.44..76.66 rows=194 width=16) (actual time=0.002..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
611. 0.000 0.000 ↑ 2.0 2 69,712

Materialize (cost=0.29..20.09 rows=4 width=8) (actual time=0.000..0.000 rows=2 loops=69,712)

612. 0.007 0.007 ↑ 2.0 2 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_65 (cost=0.29..20.07 rows=4 width=8) (actual time=0.006..0.007 rows=2 loops=1)

  • Index Cond: (sitefieldid = 47515)
  • Filter: (active AND (clientid = 2))
613. 278.848 278.848 ↑ 1.5 4 139,424

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_52 (cost=0.42..8.28 rows=6 width=16) (actual time=0.001..0.002 rows=4 loops=139,424)

  • Index Cond: (customfieldid = cfv_65.customfieldid)
614. 7.293 178.016 ↓ 0.0 0 5,563

Nested Loop (cost=1.58..303.91 rows=1 width=8) (actual time=0.032..0.032 rows=0 loops=5,563)

  • Join Filter: (cfs_64.id = inhcfc_15.valueid)
615. 122.386 139.075 ↓ 1.5 6 5,563

Nested Loop (cost=1.15..273.16 rows=4 width=32) (actual time=0.008..0.025 rows=6 loops=5,563)

  • Join Filter: ((cfc_51.valueid)::text = cfv_64.value)
  • Rows Removed by Join Filter: 95
616. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_64 (cost=0.44..76.66 rows=194 width=27) (actual time=0.002..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
617. 0.000 0.000 ↑ 4.5 8 69,712

Materialize (cost=0.71..56.92 rows=36 width=24) (actual time=0.000..0.000 rows=8 loops=69,712)

618. 0.002 0.028 ↑ 4.5 8 1

Nested Loop (cost=0.71..56.74 rows=36 width=24) (actual time=0.017..0.028 rows=8 loops=1)

619. 0.010 0.010 ↑ 2.0 2 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_64 (cost=0.29..20.07 rows=4 width=8) (actual time=0.009..0.010 rows=2 loops=1)

  • Index Cond: (sitefieldid = 47513)
  • Filter: (active AND (clientid = 2))
620. 0.016 0.016 ↑ 1.0 4 2

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_51 (cost=0.42..9.13 rows=4 width=16) (actual time=0.005..0.008 rows=4 loops=2)

  • Index Cond: (customfieldid = cfs_64.id)
  • Filter: ((attribute)::text = 'values'::text)
  • Rows Removed by Filter: 1
621. 31.648 31.648 ↓ 0.0 0 31,648

Index Only Scan using idx_custom_field_configurations_valueid_cus on custom_field_configurations inhcfc_15 (cost=0.42..7.67 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=31,648)

  • Index Cond: ((valueid = cfc_51.customfieldid) AND (customfieldid = cfv_64.customfieldid))
  • Heap Fetches: 0
622. 10.556 767.694 ↓ 0.0 0 5,563

Nested Loop (cost=1.58..303.91 rows=1 width=8) (actual time=0.138..0.138 rows=0 loops=5,563)

  • Join Filter: (cfs_67.id = inhcfc_17.valueid)
623. 497.365 723.190 ↓ 1.5 6 5,563

Nested Loop (cost=1.15..273.16 rows=4 width=32) (actual time=0.029..0.130 rows=6 loops=5,563)

  • Join Filter: ((cfc_54.valueid)::text = cfv_67.value)
  • Rows Removed by Join Filter: 671
624. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_67 (cost=0.44..76.66 rows=194 width=27) (actual time=0.002..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
625. 209.069 209.136 ↓ 1.5 54 69,712

Materialize (cost=0.71..56.92 rows=36 width=24) (actual time=0.000..0.003 rows=54 loops=69,712)

626. 0.014 0.067 ↓ 1.5 54 1

Nested Loop (cost=0.71..56.74 rows=36 width=24) (actual time=0.018..0.067 rows=54 loops=1)

627. 0.007 0.007 ↑ 2.0 2 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_67 (cost=0.29..20.07 rows=4 width=8) (actual time=0.006..0.007 rows=2 loops=1)

  • Index Cond: (sitefieldid = 47519)
  • Filter: (active AND (clientid = 2))
628. 0.046 0.046 ↓ 6.8 27 2

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_54 (cost=0.42..9.13 rows=4 width=16) (actual time=0.007..0.023 rows=27 loops=2)

  • Index Cond: (customfieldid = cfs_67.id)
  • Filter: ((attribute)::text = 'values'::text)
  • Rows Removed by Filter: 1
629. 33.948 33.948 ↓ 0.0 0 33,948

Index Only Scan using idx_custom_field_configurations_valueid_cus on custom_field_configurations inhcfc_17 (cost=0.42..7.67 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=33,948)

  • Index Cond: ((valueid = cfc_54.customfieldid) AND (customfieldid = cfv_67.customfieldid))
  • Heap Fetches: 0
630. 10.588 539.611 ↓ 0.0 0 5,563

Nested Loop (cost=1.58..303.91 rows=1 width=8) (actual time=0.097..0.097 rows=0 loops=5,563)

  • Join Filter: (cfs_66.id = inhcfc_16.valueid)
631. 338.994 495.107 ↓ 1.5 6 5,563

Nested Loop (cost=1.15..273.16 rows=4 width=32) (actual time=0.020..0.089 rows=6 loops=5,563)

  • Join Filter: ((cfc_53.valueid)::text = cfv_66.value)
  • Rows Removed by Join Filter: 445
632. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_66 (cost=0.44..76.66 rows=194 width=27) (actual time=0.002..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
633. 139.381 139.424 ↑ 1.0 36 69,712

Materialize (cost=0.71..56.92 rows=36 width=24) (actual time=0.000..0.002 rows=36 loops=69,712)

634. 0.001 0.043 ↑ 1.0 36 1

Nested Loop (cost=0.71..56.74 rows=36 width=24) (actual time=0.014..0.043 rows=36 loops=1)

635. 0.006 0.006 ↑ 2.0 2 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_66 (cost=0.29..20.07 rows=4 width=8) (actual time=0.005..0.006 rows=2 loops=1)

  • Index Cond: (sitefieldid = 47517)
  • Filter: (active AND (clientid = 2))
636. 0.036 0.036 ↓ 4.5 18 2

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_53 (cost=0.42..9.13 rows=4 width=16) (actual time=0.005..0.018 rows=18 loops=2)

  • Index Cond: (customfieldid = cfs_66.id)
  • Filter: ((attribute)::text = 'values'::text)
  • Rows Removed by Filter: 1
637. 33.916 33.916 ↓ 0.0 0 33,916

Index Only Scan using idx_custom_field_configurations_valueid_cus on custom_field_configurations inhcfc_16 (cost=0.42..7.67 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=33,916)

  • Index Cond: ((valueid = cfc_53.customfieldid) AND (customfieldid = cfv_66.customfieldid))
  • Heap Fetches: 0
638. 15.991 350.469 ↓ 0.0 0 5,563

Nested Loop (cost=1.15..6,591.70 rows=36 width=8) (actual time=0.063..0.063 rows=0 loops=5,563)

  • Join Filter: (cfs_70.id = cfc_57.valueid)
  • Rows Removed by Join Filter: 91
639. 38.941 55.630 ↑ 31.0 25 5,563

Nested Loop (cost=0.73..106.44 rows=776 width=24) (actual time=0.002..0.010 rows=25 loops=5,563)

640. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_70 (cost=0.44..76.66 rows=194 width=16) (actual time=0.002..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
641. 0.000 0.000 ↑ 2.0 2 69,712

Materialize (cost=0.29..20.09 rows=4 width=8) (actual time=0.000..0.000 rows=2 loops=69,712)

642. 0.007 0.007 ↑ 2.0 2 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_70 (cost=0.29..20.07 rows=4 width=8) (actual time=0.006..0.007 rows=2 loops=1)

  • Index Cond: (sitefieldid = 47525)
  • Filter: (active AND (clientid = 2))
643. 278.848 278.848 ↑ 1.5 4 139,424

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_57 (cost=0.42..8.28 rows=6 width=16) (actual time=0.001..0.002 rows=4 loops=139,424)

  • Index Cond: (customfieldid = cfv_70.customfieldid)
644. 10.428 344.906 ↓ 0.0 0 5,563

Nested Loop (cost=1.15..6,591.70 rows=36 width=8) (actual time=0.062..0.062 rows=0 loops=5,563)

  • Join Filter: (cfs_69.id = cfc_56.valueid)
  • Rows Removed by Join Filter: 91
645. 38.941 55.630 ↑ 31.0 25 5,563

Nested Loop (cost=0.73..106.44 rows=776 width=24) (actual time=0.002..0.010 rows=25 loops=5,563)

646. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_69 (cost=0.44..76.66 rows=194 width=16) (actual time=0.002..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
647. 0.000 0.000 ↑ 2.0 2 69,712

Materialize (cost=0.29..20.09 rows=4 width=8) (actual time=0.000..0.000 rows=2 loops=69,712)

648. 0.006 0.006 ↑ 2.0 2 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_69 (cost=0.29..20.07 rows=4 width=8) (actual time=0.005..0.006 rows=2 loops=1)

  • Index Cond: (sitefieldid = 47523)
  • Filter: (active AND (clientid = 2))
649. 278.848 278.848 ↑ 1.5 4 139,424

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_56 (cost=0.42..8.28 rows=6 width=16) (actual time=0.001..0.002 rows=4 loops=139,424)

  • Index Cond: (customfieldid = cfv_69.customfieldid)
650. 10.428 344.906 ↓ 0.0 0 5,563

Nested Loop (cost=1.15..6,591.70 rows=36 width=8) (actual time=0.062..0.062 rows=0 loops=5,563)

  • Join Filter: (cfs_68.id = cfc_55.valueid)
  • Rows Removed by Join Filter: 91
651. 38.941 55.630 ↑ 31.0 25 5,563

Nested Loop (cost=0.73..106.44 rows=776 width=24) (actual time=0.002..0.010 rows=25 loops=5,563)

652. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_68 (cost=0.44..76.66 rows=194 width=16) (actual time=0.002..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
653. 0.000 0.000 ↑ 2.0 2 69,712

Materialize (cost=0.29..20.09 rows=4 width=8) (actual time=0.000..0.000 rows=2 loops=69,712)

654. 0.007 0.007 ↑ 2.0 2 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_68 (cost=0.29..20.07 rows=4 width=8) (actual time=0.006..0.007 rows=2 loops=1)

  • Index Cond: (sitefieldid = 47521)
  • Filter: (active AND (clientid = 2))
655. 278.848 278.848 ↑ 1.5 4 139,424

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_55 (cost=0.42..8.28 rows=6 width=16) (actual time=0.001..0.002 rows=4 loops=139,424)

  • Index Cond: (customfieldid = cfv_68.customfieldid)
656. 10.428 344.906 ↓ 0.0 0 5,563

Nested Loop (cost=1.15..6,591.70 rows=36 width=8) (actual time=0.062..0.062 rows=0 loops=5,563)

  • Join Filter: (cfs_73.id = cfc_60.valueid)
  • Rows Removed by Join Filter: 91
657. 38.941 55.630 ↑ 31.0 25 5,563

Nested Loop (cost=0.73..106.44 rows=776 width=24) (actual time=0.002..0.010 rows=25 loops=5,563)

658. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_73 (cost=0.44..76.66 rows=194 width=16) (actual time=0.001..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
659. 0.000 0.000 ↑ 2.0 2 69,712

Materialize (cost=0.29..20.09 rows=4 width=8) (actual time=0.000..0.000 rows=2 loops=69,712)

660. 0.007 0.007 ↑ 2.0 2 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_73 (cost=0.29..20.07 rows=4 width=8) (actual time=0.006..0.007 rows=2 loops=1)

  • Index Cond: (sitefieldid = 47531)
  • Filter: (active AND (clientid = 2))
661. 278.848 278.848 ↑ 1.5 4 139,424

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_60 (cost=0.42..8.28 rows=6 width=16) (actual time=0.001..0.002 rows=4 loops=139,424)

  • Index Cond: (customfieldid = cfv_73.customfieldid)
662. 10.428 344.906 ↓ 0.0 0 5,563

Nested Loop (cost=1.15..6,591.70 rows=36 width=8) (actual time=0.062..0.062 rows=0 loops=5,563)

  • Join Filter: (cfs_72.id = cfc_59.valueid)
  • Rows Removed by Join Filter: 91
663. 38.941 55.630 ↑ 31.0 25 5,563

Nested Loop (cost=0.73..106.44 rows=776 width=24) (actual time=0.002..0.010 rows=25 loops=5,563)

664. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_72 (cost=0.44..76.66 rows=194 width=16) (actual time=0.001..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
665. 0.000 0.000 ↑ 2.0 2 69,712

Materialize (cost=0.29..20.09 rows=4 width=8) (actual time=0.000..0.000 rows=2 loops=69,712)

666. 0.007 0.007 ↑ 2.0 2 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_72 (cost=0.29..20.07 rows=4 width=8) (actual time=0.006..0.007 rows=2 loops=1)

  • Index Cond: (sitefieldid = 47529)
  • Filter: (active AND (clientid = 2))
667. 278.848 278.848 ↑ 1.5 4 139,424

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_59 (cost=0.42..8.28 rows=6 width=16) (actual time=0.001..0.002 rows=4 loops=139,424)

  • Index Cond: (customfieldid = cfv_72.customfieldid)
668. 0.000 344.906 ↓ 0.0 0 5,563

Nested Loop (cost=1.15..10,832.01 rows=117 width=8) (actual time=0.062..0.062 rows=0 loops=5,563)

  • Join Filter: (cfv_71.value = (usx_2.id)::text)
669. 10.428 344.906 ↓ 0.0 0 5,563

Nested Loop (cost=1.15..6,591.70 rows=36 width=19) (actual time=0.062..0.062 rows=0 loops=5,563)

  • Join Filter: (cfs_71.id = cfc_58.valueid)
  • Rows Removed by Join Filter: 91
670. 38.941 55.630 ↑ 31.0 25 5,563

Nested Loop (cost=0.73..106.44 rows=776 width=35) (actual time=0.002..0.010 rows=25 loops=5,563)

671. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_71 (cost=0.44..76.66 rows=194 width=27) (actual time=0.001..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
672. 0.000 0.000 ↑ 2.0 2 69,712

Materialize (cost=0.29..20.09 rows=4 width=8) (actual time=0.000..0.000 rows=2 loops=69,712)

673. 0.007 0.007 ↑ 2.0 2 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_71 (cost=0.29..20.07 rows=4 width=8) (actual time=0.006..0.007 rows=2 loops=1)

  • Index Cond: (sitefieldid = 47527)
  • Filter: (active AND (clientid = 2))
674. 278.848 278.848 ↑ 1.5 4 139,424

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_58 (cost=0.42..8.28 rows=6 width=16) (actual time=0.001..0.002 rows=4 loops=139,424)

  • Index Cond: (customfieldid = cfv_71.customfieldid)
675. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..142.66 rows=5,711 width=8) (never executed)

676. 0.000 0.000 ↓ 0.0 0

Seq Scan on user_ext usx_2 (cost=0.00..114.11 rows=5,711 width=8) (never executed)

677. 15.991 344.906 ↓ 0.0 0 5,563

Nested Loop (cost=1.15..6,591.70 rows=36 width=8) (actual time=0.062..0.062 rows=0 loops=5,563)

  • Join Filter: (cfs_76.id = cfc_63.valueid)
  • Rows Removed by Join Filter: 91
678. 33.378 50.067 ↑ 31.0 25 5,563

Nested Loop (cost=0.73..106.44 rows=776 width=24) (actual time=0.002..0.009 rows=25 loops=5,563)

679. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_76 (cost=0.44..76.66 rows=194 width=16) (actual time=0.001..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
680. 0.000 0.000 ↑ 2.0 2 69,712

Materialize (cost=0.29..20.09 rows=4 width=8) (actual time=0.000..0.000 rows=2 loops=69,712)

681. 0.008 0.008 ↑ 2.0 2 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_76 (cost=0.29..20.07 rows=4 width=8) (actual time=0.007..0.008 rows=2 loops=1)

  • Index Cond: (sitefieldid = 47571)
  • Filter: (active AND (clientid = 2))
682. 278.848 278.848 ↑ 1.5 4 139,424

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_63 (cost=0.42..8.28 rows=6 width=16) (actual time=0.001..0.002 rows=4 loops=139,424)

  • Index Cond: (customfieldid = cfv_76.customfieldid)
683. 4.865 339.343 ↓ 0.0 0 5,563

Nested Loop (cost=1.15..6,591.70 rows=36 width=8) (actual time=0.061..0.061 rows=0 loops=5,563)

  • Join Filter: (cfs_75.id = cfc_62.valueid)
  • Rows Removed by Join Filter: 91
684. 38.941 55.630 ↑ 31.0 25 5,563

Nested Loop (cost=0.73..106.44 rows=776 width=24) (actual time=0.002..0.010 rows=25 loops=5,563)

685. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_75 (cost=0.44..76.66 rows=194 width=16) (actual time=0.002..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
686. 0.000 0.000 ↑ 2.0 2 69,712

Materialize (cost=0.29..20.09 rows=4 width=8) (actual time=0.000..0.000 rows=2 loops=69,712)

687. 0.007 0.007 ↑ 2.0 2 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_75 (cost=0.29..20.07 rows=4 width=8) (actual time=0.006..0.007 rows=2 loops=1)

  • Index Cond: (sitefieldid = 47535)
  • Filter: (active AND (clientid = 2))
688. 278.848 278.848 ↑ 1.5 4 139,424

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_62 (cost=0.42..8.28 rows=6 width=16) (actual time=0.001..0.002 rows=4 loops=139,424)

  • Index Cond: (customfieldid = cfv_75.customfieldid)
689. 15.991 344.906 ↓ 0.0 0 5,563

Nested Loop (cost=1.15..6,591.70 rows=36 width=8) (actual time=0.062..0.062 rows=0 loops=5,563)

  • Join Filter: (cfs_74.id = cfc_61.valueid)
  • Rows Removed by Join Filter: 91
690. 33.378 50.067 ↑ 31.0 25 5,563

Nested Loop (cost=0.73..106.44 rows=776 width=24) (actual time=0.002..0.009 rows=25 loops=5,563)

691. 16.689 16.689 ↑ 14.9 13 5,563

Index Scan using idx_custom_field_values_obj on custom_field_values cfv_74 (cost=0.44..76.66 rows=194 width=16) (actual time=0.001..0.003 rows=13 loops=5,563)

  • Index Cond: (objectid = tcx.id)
692. 0.000 0.000 ↑ 2.0 2 69,712

Materialize (cost=0.29..20.09 rows=4 width=8) (actual time=0.000..0.000 rows=2 loops=69,712)

693. 0.005 0.005 ↑ 2.0 2 1

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_74 (cost=0.29..20.07 rows=4 width=8) (actual time=0.005..0.005 rows=2 loops=1)

  • Index Cond: (sitefieldid = 47533)
  • Filter: (active AND (clientid = 2))
694. 278.848 278.848 ↑ 1.5 4 139,424

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_61 (cost=0.42..8.28 rows=6 width=16) (actual time=0.001..0.002 rows=4 loops=139,424)

  • Index Cond: (customfieldid = cfv_74.customfieldid)
695. 5.563 61.193 ↓ 0.0 0 5,563

Nested Loop (cost=1.28..87.84 rows=1 width=8) (actual time=0.011..0.011 rows=0 loops=5,563)

696. 0.000 55.630 ↓ 0.0 0 5,563

Nested Loop (cost=0.85..54.43 rows=4 width=35) (actual time=0.010..0.010 rows=0 loops=5,563)

697. 22.252 22.252 ↑ 2.0 2 5,563

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_79 (cost=0.29..20.07 rows=4 width=8) (actual time=0.003..0.004 rows=2 loops=5,563)

  • Index Cond: (sitefieldid = 798)
  • Filter: (active AND (clientid = 2))
698. 33.378 33.378 ↓ 0.0 0 11,126

Index Scan using idx_uq_custom_field_values_cus_obj_valmd5 on custom_field_values cfv_79 (cost=0.56..8.58 rows=1 width=27) (actual time=0.003..0.003 rows=0 loops=11,126)

  • Index Cond: ((customfieldid = cfs_79.id) AND (objectid = tcs.id))
699. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_custom_field_configurations_cus on custom_field_configurations cfc_65 (cost=0.42..8.34 rows=1 width=16) (never executed)

  • Index Cond: (customfieldid = cfv_79.customfieldid)
  • Filter: (((attribute)::text = 'values'::text) AND (cfv_79.value = (valueid)::text))
700. 5.563 33.378 ↓ 0.0 0 5,563

Nested Loop (cost=0.85..54.44 rows=1 width=8) (actual time=0.006..0.006 rows=0 loops=5,563)

701. 11.126 11.126 ↑ 4.0 1 5,563

Index Scan using idx_custom_fields_sitefieldid on custom_fields cfs_78 (cost=0.29..20.07 rows=4 width=8) (actual time=0.002..0.002 rows=1 loops=5,563)

  • Index Cond: (sitefieldid = 797)
  • Filter: (active AND (clientid = 2))
702. 16.689 16.689 ↓ 0.0 0 5,563

Index Only Scan using idx_custom_field_values_cf_obj on custom_field_values cfv_78