explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BpQA

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

Merge Left Join (cost=2,620.97..2,621.08 rows=3 width=3,809) (actual rows= loops=)

  • Merge Cond: (ck_id.id = "KQ_RE_USE_SOFTWARE".k_id)
2.          

CTE ck_id

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.76..89.02 rows=3 width=36) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on callhistorian (cost=4.47..30.87 rows=7 width=12) (actual rows= loops=)

  • Filter: (acc ~~ 'ACC312543'::text)
5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uix_acc_date (cost=0.00..4.47 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (acc = 'ACC312543'::text)
6. 0.000 0.000 ↓ 0.0

Index Scan using clientknowledge_call_id_key on clientknowledge clientknowledge_1 (cost=0.29..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (call_id = callhistorian.id)
7.          

CTE KQ_ADV_ANNUAL_NEED

8. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=95.43..96.20 rows=31 width=36) (actual rows= loops=)

  • Group Key: "KQ_ADV_ANNUAL_NEED_1".knowledge_id
9. 0.000 0.000 ↓ 0.0

Sort (cost=95.43..95.51 rows=31 width=8) (actual rows= loops=)

  • Sort Key: "KQ_ADV_ANNUAL_NEED_1".knowledge_id
10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.37..94.66 rows=31 width=8) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_1 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_ADV_ANNUAL_NEED" "KQ_ADV_ANNUAL_NEED_1" (cost=4.37..31.43 rows=10 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_1.id)
13. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_ADV_ANNUAL_NEED_knowledge_id" (cost=0.00..4.36 rows=10 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_1.id)
14.          

CTE KQ_CUST_SUB_KANTAR

15. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=25.01..25.08 rows=3 width=36) (actual rows= loops=)

  • Group Key: "KQ_CUST_SUB_KANTAR_1".knowledge_id
16. 0.000 0.000 ↓ 0.0

Sort (cost=25.01..25.01 rows=3 width=8) (actual rows= loops=)

  • Sort Key: "KQ_CUST_SUB_KANTAR_1".knowledge_id
17. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..24.98 rows=3 width=8) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_2 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Index Scan using "ix_lookup_KQ_CUST_SUB_KANTAR_knowledge_id" on "KQ_CUST_SUB_KANTAR" "KQ_CUST_SUB_KANTAR_1" (cost=0.28..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_2.id)
20.          

CTE KQ_RE_REASON_ADS_RENTAL

21. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=35.62..36.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_RE_REASON_ADS_RENTAL_1".knowledge_id
22. 0.000 0.000 ↓ 0.0

Sort (cost=35.62..35.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_RE_REASON_ADS_RENTAL_1".knowledge_id
23. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.91..34.75 rows=34 width=8) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_3 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_RE_REASON_ADS_RENTAL" "KQ_RE_REASON_ADS_RENTAL_1" (cost=2.91..11.45 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_3.id)
26. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_RE_REASON_ADS_RENTAL_knowledge_id" (cost=0.00..2.90 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_3.id)
27.          

CTE KQ_CAR_ANNUAL_OPTION_BUDGET

28. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_CAR_ANNUAL_OPTION_BUDGET_1".knowledge_id
29. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_CAR_ANNUAL_OPTION_BUDGET_1".knowledge_id
30. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_4 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_CAR_ANNUAL_OPTION_BUDGET" "KQ_CAR_ANNUAL_OPTION_BUDGET_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_4.id)
33. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_CAR_ANNUAL_OPTION_BUDGET_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_4.id)
34.          

CTE KQ_JOB_CATEGORY

35. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=35.62..36.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_JOB_CATEGORY_1".knowledge_id
36. 0.000 0.000 ↓ 0.0

Sort (cost=35.62..35.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_JOB_CATEGORY_1".knowledge_id
37. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.91..34.75 rows=34 width=8) (actual rows= loops=)

38. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_5 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

39. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_JOB_CATEGORY" "KQ_JOB_CATEGORY_1" (cost=2.91..11.45 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_5.id)
40. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_JOB_CATEGORY_knowledge_id" (cost=0.00..2.90 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_5.id)
41.          

CTE KQ_CUST_USE_OPTION

42. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=2.40..2.48 rows=3 width=36) (actual rows= loops=)

  • Group Key: "KQ_CUST_USE_OPTION_1".knowledge_id
43. 0.000 0.000 ↓ 0.0

Sort (cost=2.40..2.41 rows=3 width=8) (actual rows= loops=)

  • Sort Key: "KQ_CUST_USE_OPTION_1".knowledge_id
44. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.10..2.38 rows=3 width=8) (actual rows= loops=)

  • Hash Cond: ("KQ_CUST_USE_OPTION_1".knowledge_id = ck_id_6.id)
45. 0.000 0.000 ↓ 0.0

Seq Scan on "KQ_CUST_USE_OPTION" "KQ_CUST_USE_OPTION_1" (cost=0.00..1.91 rows=91 width=8) (actual rows= loops=)

46. 0.000 0.000 ↓ 0.0

Hash (cost=0.06..0.06 rows=3 width=4) (actual rows= loops=)

47. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_6 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

48.          

CTE KQ_RE_AVERAGE_TIME_ACTION

49. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=7.60..7.67 rows=3 width=36) (actual rows= loops=)

  • Group Key: "KQ_RE_AVERAGE_TIME_ACTION_1".knowledge_id
50. 0.000 0.000 ↓ 0.0

Sort (cost=7.60..7.60 rows=3 width=8) (actual rows= loops=)

  • Sort Key: "KQ_RE_AVERAGE_TIME_ACTION_1".knowledge_id
51. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.10..7.57 rows=3 width=8) (actual rows= loops=)

  • Hash Cond: ("KQ_RE_AVERAGE_TIME_ACTION_1".knowledge_id = ck_id_7.id)
52. 0.000 0.000 ↓ 0.0

Seq Scan on "KQ_RE_AVERAGE_TIME_ACTION" "KQ_RE_AVERAGE_TIME_ACTION_1" (cost=0.00..5.96 rows=396 width=8) (actual rows= loops=)

53. 0.000 0.000 ↓ 0.0

Hash (cost=0.06..0.06 rows=3 width=4) (actual rows= loops=)

54. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_7 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

55.          

CTE KQ_RE_OPTION_PERCENT

56. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_RE_OPTION_PERCENT_1".knowledge_id
57. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_RE_OPTION_PERCENT_1".knowledge_id
58. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

59. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_8 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

60. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_RE_OPTION_PERCENT" "KQ_RE_OPTION_PERCENT_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_8.id)
61. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_RE_OPTION_PERCENT_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_8.id)
62.          

CTE KQ_CAR_USE_SOFTWARE

63. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_CAR_USE_SOFTWARE_1".knowledge_id
64. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_CAR_USE_SOFTWARE_1".knowledge_id
65. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

66. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_9 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

67. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_CAR_USE_SOFTWARE" "KQ_CAR_USE_SOFTWARE_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_9.id)
68. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_CAR_USE_SOFTWARE_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_9.id)
69.          

CTE KQ_CAR_STOCK

70. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_CAR_STOCK_1".knowledge_id
71. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_CAR_STOCK_1".knowledge_id
72. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

73. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_10 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

74. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_CAR_STOCK" "KQ_CAR_STOCK_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_10.id)
75. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_CAR_STOCK_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_10.id)
76.          

CTE KQ_RE_LBC_ADSERVING_MODE_NEW_SALES

77. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_RE_LBC_ADSERVING_MODE_NEW_SALES_1".knowledge_id
78. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_RE_LBC_ADSERVING_MODE_NEW_SALES_1".knowledge_id
79. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

80. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_11 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

81. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_RE_LBC_ADSERVING_MODE_NEW_SALES" "KQ_RE_LBC_ADSERVING_MODE_NEW_SALES_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_11.id)
82. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_RE_LBC_ADSERVING_MODE_NEW_SALES_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_11.id)
83.          

CTE KQ_RE_ADSERVING_SUPPORT_NEW_SALES

84. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=1.96..2.06 rows=4 width=36) (actual rows= loops=)

  • Group Key: "KQ_RE_ADSERVING_SUPPORT_NEW_SALES_1".knowledge_id
85. 0.000 0.000 ↓ 0.0

Sort (cost=1.96..1.97 rows=4 width=8) (actual rows= loops=)

  • Sort Key: "KQ_RE_ADSERVING_SUPPORT_NEW_SALES_1".knowledge_id
86. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.10..1.92 rows=4 width=8) (actual rows= loops=)

  • Hash Cond: ("KQ_RE_ADSERVING_SUPPORT_NEW_SALES_1".knowledge_id = ck_id_12.id)
87. 0.000 0.000 ↓ 0.0

Seq Scan on "KQ_RE_ADSERVING_SUPPORT_NEW_SALES" "KQ_RE_ADSERVING_SUPPORT_NEW_SALES_1" (cost=0.00..1.57 rows=57 width=8) (actual rows= loops=)

88. 0.000 0.000 ↓ 0.0

Hash (cost=0.06..0.06 rows=3 width=4) (actual rows= loops=)

89. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_12 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

90.          

CTE KQ_CAR_DEALERSHIP_MODE

91. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_CAR_DEALERSHIP_MODE_1".knowledge_id
92. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_CAR_DEALERSHIP_MODE_1".knowledge_id
93. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

94. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_13 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

95. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_CAR_DEALERSHIP_MODE" "KQ_CAR_DEALERSHIP_MODE_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_13.id)
96. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_CAR_DEALERSHIP_MODE_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_13.id)
97.          

CTE KQ_JOB_CAREER_PAGE

98. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_JOB_CAREER_PAGE_1".knowledge_id
99. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_JOB_CAREER_PAGE_1".knowledge_id
100. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

101. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_14 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

102. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_JOB_CAREER_PAGE" "KQ_JOB_CAREER_PAGE_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_14.id)
103. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_JOB_CAREER_PAGE_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_14.id)
104.          

CTE KQ_JOB_MANAGEMENT

105. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_JOB_MANAGEMENT_1".knowledge_id
106. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_JOB_MANAGEMENT_1".knowledge_id
107. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

108. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_15 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

109. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_JOB_MANAGEMENT" "KQ_JOB_MANAGEMENT_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_15.id)
110. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_JOB_MANAGEMENT_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_15.id)
111.          

CTE KQ_CAR_ADSERVING_SUPPORT

112. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_CAR_ADSERVING_SUPPORT_1".knowledge_id
113. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_CAR_ADSERVING_SUPPORT_1".knowledge_id
114. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

115. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_16 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

116. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_CAR_ADSERVING_SUPPORT" "KQ_CAR_ADSERVING_SUPPORT_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_16.id)
117. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_CAR_ADSERVING_SUPPORT_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_16.id)
118.          

CTE KQ_JOB_ANNUAL_NEED

119. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=89.19..89.79 rows=24 width=36) (actual rows= loops=)

  • Group Key: "KQ_JOB_ANNUAL_NEED_1".knowledge_id
120. 0.000 0.000 ↓ 0.0

Sort (cost=89.19..89.25 rows=24 width=8) (actual rows= loops=)

  • Sort Key: "KQ_JOB_ANNUAL_NEED_1".knowledge_id
121. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.35..88.64 rows=24 width=8) (actual rows= loops=)

122. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_17 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

123. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_JOB_ANNUAL_NEED" "KQ_JOB_ANNUAL_NEED_1" (cost=4.35..29.45 rows=8 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_17.id)
124. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_JOB_ANNUAL_NEED_knowledge_id" (cost=0.00..4.35 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_17.id)
125.          

CTE KQ_RE_RANGE

126. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_RE_RANGE_1".knowledge_id
127. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_RE_RANGE_1".knowledge_id
128. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

129. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_18 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

130. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_RE_RANGE" "KQ_RE_RANGE_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_18.id)
131. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_RE_RANGE_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_18.id)
132.          

CTE KQ_ADV_GOALS

133. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=25.01..25.08 rows=3 width=36) (actual rows= loops=)

  • Group Key: "KQ_ADV_GOALS_1".knowledge_id
134. 0.000 0.000 ↓ 0.0

Sort (cost=25.01..25.01 rows=3 width=8) (actual rows= loops=)

  • Sort Key: "KQ_ADV_GOALS_1".knowledge_id
135. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..24.98 rows=3 width=8) (actual rows= loops=)

136. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_19 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

137. 0.000 0.000 ↓ 0.0

Index Scan using "ix_lookup_KQ_ADV_GOALS_knowledge_id" on "KQ_ADV_GOALS" "KQ_ADV_GOALS_1" (cost=0.28..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_19.id)
138.          

CTE KQ_ADV_COMMUNICATION_RADIUS

139. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=25.00..25.07 rows=3 width=36) (actual rows= loops=)

  • Group Key: "KQ_ADV_COMMUNICATION_RADIUS_1".knowledge_id
140. 0.000 0.000 ↓ 0.0

Sort (cost=25.00..25.01 rows=3 width=8) (actual rows= loops=)

  • Sort Key: "KQ_ADV_COMMUNICATION_RADIUS_1".knowledge_id
141. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..24.98 rows=3 width=8) (actual rows= loops=)

142. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_20 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

143. 0.000 0.000 ↓ 0.0

Index Scan using "ix_lookup_KQ_ADV_COMMUNICATION_RADIUS_knowledge_id" on "KQ_ADV_COMMUNICATION_RADIUS" "KQ_ADV_COMMUNICATION_RADIUS_1" (cost=0.28..8.29 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_20.id)
144.          

CTE KQ_RE_HOLIDAY_RENTAL

145. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_RE_HOLIDAY_RENTAL_1".knowledge_id
146. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_RE_HOLIDAY_RENTAL_1".knowledge_id
147. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

148. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_21 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

149. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_RE_HOLIDAY_RENTAL" "KQ_RE_HOLIDAY_RENTAL_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_21.id)
150. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_RE_HOLIDAY_RENTAL_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_21.id)
151.          

CTE KQ_JOB_SOFTWARE_LEC_LIST

152. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_JOB_SOFTWARE_LEC_LIST_1".knowledge_id
153. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_JOB_SOFTWARE_LEC_LIST_1".knowledge_id
154. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

155. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_22 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

156. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_JOB_SOFTWARE_LEC_LIST" "KQ_JOB_SOFTWARE_LEC_LIST_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_22.id)
157. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_JOB_SOFTWARE_LEC_LIST_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_22.id)
158.          

CTE KQ_CUST_EMPLOYEES_RANGE

159. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=25.02..25.10 rows=3 width=36) (actual rows= loops=)

  • Group Key: "KQ_CUST_EMPLOYEES_RANGE_1".knowledge_id
160. 0.000 0.000 ↓ 0.0

Sort (cost=25.02..25.03 rows=3 width=8) (actual rows= loops=)

  • Sort Key: "KQ_CUST_EMPLOYEES_RANGE_1".knowledge_id
161. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..25.00 rows=3 width=8) (actual rows= loops=)

162. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_23 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

163. 0.000 0.000 ↓ 0.0

Index Scan using "ix_lookup_KQ_CUST_EMPLOYEES_RANGE_knowledge_id" on "KQ_CUST_EMPLOYEES_RANGE" "KQ_CUST_EMPLOYEES_RANGE_1" (cost=0.29..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_23.id)
164.          

CTE KQ_CAR_SOFTWARE_LIST

165. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_CAR_SOFTWARE_LIST_1".knowledge_id
166. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_CAR_SOFTWARE_LIST_1".knowledge_id
167. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

168. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_24 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

169. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_CAR_SOFTWARE_LIST" "KQ_CAR_SOFTWARE_LIST_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_24.id)
170. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_CAR_SOFTWARE_LIST_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_24.id)
171.          

CTE KQ_CAR_OPTION_PERCENT

172. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_CAR_OPTION_PERCENT_1".knowledge_id
173. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_CAR_OPTION_PERCENT_1".knowledge_id
174. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

175. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_25 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

176. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_CAR_OPTION_PERCENT" "KQ_CAR_OPTION_PERCENT_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_25.id)
177. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_CAR_OPTION_PERCENT_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_25.id)
178.          

CTE KQ_ADV_GENDER

179. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=25.01..25.08 rows=3 width=36) (actual rows= loops=)

  • Group Key: "KQ_ADV_GENDER_1".knowledge_id
180. 0.000 0.000 ↓ 0.0

Sort (cost=25.01..25.01 rows=3 width=8) (actual rows= loops=)

  • Sort Key: "KQ_ADV_GENDER_1".knowledge_id
181. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..24.98 rows=3 width=8) (actual rows= loops=)

182. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_26 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

183. 0.000 0.000 ↓ 0.0

Index Scan using "ix_lookup_KQ_ADV_GENDER_knowledge_id" on "KQ_ADV_GENDER" "KQ_ADV_GENDER_1" (cost=0.28..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_26.id)
184.          

CTE KQ_ADV_GOALS2

185. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=10.88..10.95 rows=3 width=36) (actual rows= loops=)

  • Group Key: "KQ_ADV_GOALS2_1".knowledge_id
186. 0.000 0.000 ↓ 0.0

Sort (cost=10.88..10.89 rows=3 width=8) (actual rows= loops=)

  • Sort Key: "KQ_ADV_GOALS2_1".knowledge_id
187. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.10..10.86 rows=3 width=8) (actual rows= loops=)

  • Hash Cond: ("KQ_ADV_GOALS2_1".knowledge_id = ck_id_27.id)
188. 0.000 0.000 ↓ 0.0

Seq Scan on "KQ_ADV_GOALS2" "KQ_ADV_GOALS2_1" (cost=0.00..8.62 rows=562 width=8) (actual rows= loops=)

189. 0.000 0.000 ↓ 0.0

Hash (cost=0.06..0.06 rows=3 width=4) (actual rows= loops=)

190. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_27 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

191.          

CTE KQ_RE_ANNUAL_OPTION_BUDGET

192. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_RE_ANNUAL_OPTION_BUDGET_1".knowledge_id
193. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_RE_ANNUAL_OPTION_BUDGET_1".knowledge_id
194. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

195. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_28 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

196. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_RE_ANNUAL_OPTION_BUDGET" "KQ_RE_ANNUAL_OPTION_BUDGET_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_28.id)
197. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_RE_ANNUAL_OPTION_BUDGET_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_28.id)
198.          

CTE KQ_CUST_CREDITCARD_USE

199. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_CUST_CREDITCARD_USE_1".knowledge_id
200. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_CUST_CREDITCARD_USE_1".knowledge_id
201. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

202. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_29 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

203. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_CUST_CREDITCARD_USE" "KQ_CUST_CREDITCARD_USE_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_29.id)
204. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_CUST_CREDITCARD_USE_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_29.id)
205.          

CTE KQ_JOB_CONTRACT

206. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_JOB_CONTRACT_1".knowledge_id
207. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_JOB_CONTRACT_1".knowledge_id
208. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

209. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_30 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

210. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_JOB_CONTRACT" "KQ_JOB_CONTRACT_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_30.id)
211. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_JOB_CONTRACT_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_30.id)
212.          

CTE KQ_RE_ACTIVITIES

213. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=10.59..10.67 rows=3 width=36) (actual rows= loops=)

  • Group Key: "KQ_RE_ACTIVITIES_1".knowledge_id
214. 0.000 0.000 ↓ 0.0

Sort (cost=10.59..10.60 rows=3 width=8) (actual rows= loops=)

  • Sort Key: "KQ_RE_ACTIVITIES_1".knowledge_id
215. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.10..10.57 rows=3 width=8) (actual rows= loops=)

  • Hash Cond: ("KQ_RE_ACTIVITIES_1".knowledge_id = ck_id_31.id)
216. 0.000 0.000 ↓ 0.0

Seq Scan on "KQ_RE_ACTIVITIES" "KQ_RE_ACTIVITIES_1" (cost=0.00..8.41 rows=541 width=8) (actual rows= loops=)

217. 0.000 0.000 ↓ 0.0

Hash (cost=0.06..0.06 rows=3 width=4) (actual rows= loops=)

218. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_31 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

219.          

CTE KQ_RE_LBC_ADSERVING_MODE_HOLY_RENTAL

220. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_RE_LBC_ADSERVING_MODE_HOLY_RENTAL_1".knowledge_id
221. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_RE_LBC_ADSERVING_MODE_HOLY_RENTAL_1".knowledge_id
222. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

223. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_32 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

224. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_RE_LBC_ADSERVING_MODE_HOLY_RENTAL" "KQ_RE_LBC_ADSERVING_MODE_HOLY_RENTAL_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_32.id)
225. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_RE_LBC_ADSERVING_MODE_HOLY_RENTAL_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_32.id)
226.          

CTE KQ_RE_FLOW_TYPE

227. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=7.58..7.66 rows=3 width=36) (actual rows= loops=)

  • Group Key: "KQ_RE_FLOW_TYPE_1".knowledge_id
228. 0.000 0.000 ↓ 0.0

Sort (cost=7.58..7.59 rows=3 width=8) (actual rows= loops=)

  • Sort Key: "KQ_RE_FLOW_TYPE_1".knowledge_id
229. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.10..7.56 rows=3 width=8) (actual rows= loops=)

  • Hash Cond: ("KQ_RE_FLOW_TYPE_1".knowledge_id = ck_id_33.id)
230. 0.000 0.000 ↓ 0.0

Seq Scan on "KQ_RE_FLOW_TYPE" "KQ_RE_FLOW_TYPE_1" (cost=0.00..5.95 rows=395 width=8) (actual rows= loops=)

231. 0.000 0.000 ↓ 0.0

Hash (cost=0.06..0.06 rows=3 width=4) (actual rows= loops=)

232. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_33 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

233.          

CTE KQ_ADV_AGE_RANGE

234. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=25.01..25.08 rows=3 width=36) (actual rows= loops=)

  • Group Key: "KQ_ADV_AGE_RANGE_1".knowledge_id
235. 0.000 0.000 ↓ 0.0

Sort (cost=25.01..25.01 rows=3 width=8) (actual rows= loops=)

  • Sort Key: "KQ_ADV_AGE_RANGE_1".knowledge_id
236. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..24.98 rows=3 width=8) (actual rows= loops=)

237. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_34 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

238. 0.000 0.000 ↓ 0.0

Index Scan using "ix_lookup_KQ_ADV_AGE_RANGE_knowledge_id" on "KQ_ADV_AGE_RANGE" "KQ_ADV_AGE_RANGE_1" (cost=0.28..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_34.id)
239.          

CTE KQ_CAR_CONSULT_STAT

240. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_CAR_CONSULT_STAT_1".knowledge_id
241. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_CAR_CONSULT_STAT_1".knowledge_id
242. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

243. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_35 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

244. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_CAR_CONSULT_STAT" "KQ_CAR_CONSULT_STAT_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_35.id)
245. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_CAR_CONSULT_STAT_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_35.id)
246.          

CTE KQ_CUST_RUBRIQUE

247. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_CUST_RUBRIQUE_1".knowledge_id
248. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_CUST_RUBRIQUE_1".knowledge_id
249. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

250. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_36 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

251. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_CUST_RUBRIQUE" "KQ_CUST_RUBRIQUE_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_36.id)
252. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_CUST_RUBRIQUE_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_36.id)
253.          

CTE KQ_ADV_GOALS3

254. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=2.31..2.38 rows=3 width=36) (actual rows= loops=)

  • Group Key: "KQ_ADV_GOALS3_1".knowledge_id
255. 0.000 0.000 ↓ 0.0

Sort (cost=2.31..2.31 rows=3 width=8) (actual rows= loops=)

  • Sort Key: "KQ_ADV_GOALS3_1".knowledge_id
256. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.10..2.28 rows=3 width=8) (actual rows= loops=)

  • Hash Cond: ("KQ_ADV_GOALS3_1".knowledge_id = ck_id_37.id)
257. 0.000 0.000 ↓ 0.0

Seq Scan on "KQ_ADV_GOALS3" "KQ_ADV_GOALS3_1" (cost=0.00..1.84 rows=84 width=8) (actual rows= loops=)

258. 0.000 0.000 ↓ 0.0

Hash (cost=0.06..0.06 rows=3 width=4) (actual rows= loops=)

259. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_37 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

260.          

CTE KQ_ADV_CAMPAIGN_DURATION

261. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=25.01..25.08 rows=3 width=36) (actual rows= loops=)

  • Group Key: "KQ_ADV_CAMPAIGN_DURATION_1".knowledge_id
262. 0.000 0.000 ↓ 0.0

Sort (cost=25.01..25.01 rows=3 width=8) (actual rows= loops=)

  • Sort Key: "KQ_ADV_CAMPAIGN_DURATION_1".knowledge_id
263. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..24.98 rows=3 width=8) (actual rows= loops=)

264. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_38 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

265. 0.000 0.000 ↓ 0.0

Index Scan using "ix_lookup_KQ_ADV_CAMPAIGN_DURATION_knowledge_id" on "KQ_ADV_CAMPAIGN_DURATION" "KQ_ADV_CAMPAIGN_DURATION_1" (cost=0.28..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_38.id)
266.          

CTE KQ_RE_OPTION_TYPE

267. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_RE_OPTION_TYPE_1".knowledge_id
268. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_RE_OPTION_TYPE_1".knowledge_id
269. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

270. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_39 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

271. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_RE_OPTION_TYPE" "KQ_RE_OPTION_TYPE_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_39.id)
272. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_RE_OPTION_TYPE_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_39.id)
273.          

CTE KQ_JOB_ANNUAL_VACANCIES_RANGE

274. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_JOB_ANNUAL_VACANCIES_RANGE_1".knowledge_id
275. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_JOB_ANNUAL_VACANCIES_RANGE_1".knowledge_id
276. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

277. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_40 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

278. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_JOB_ANNUAL_VACANCIES_RANGE" "KQ_JOB_ANNUAL_VACANCIES_RANGE_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_40.id)
279. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_JOB_ANNUAL_VACANCIES_RANGE_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_40.id)
280.          

CTE KQ_RE_MONTHLY_BUDGET

281. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_RE_MONTHLY_BUDGET_1".knowledge_id
282. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_RE_MONTHLY_BUDGET_1".knowledge_id
283. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

284. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_41 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

285. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_RE_MONTHLY_BUDGET" "KQ_RE_MONTHLY_BUDGET_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_41.id)
286. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_RE_MONTHLY_BUDGET_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_41.id)
287.          

CTE KQ_CAR_LBC_ADSERVING_MODE

288. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_CAR_LBC_ADSERVING_MODE_1".knowledge_id
289. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_CAR_LBC_ADSERVING_MODE_1".knowledge_id
290. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

291. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_42 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

292. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_CAR_LBC_ADSERVING_MODE" "KQ_CAR_LBC_ADSERVING_MODE_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_42.id)
293. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_CAR_LBC_ADSERVING_MODE_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_42.id)
294.          

CTE KQ_RE_ADSERVING_SUPPORT_RENTAL

295. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=3.12..3.30 rows=7 width=36) (actual rows= loops=)

  • Group Key: "KQ_RE_ADSERVING_SUPPORT_RENTAL_1".knowledge_id
296. 0.000 0.000 ↓ 0.0

Sort (cost=3.12..3.14 rows=7 width=8) (actual rows= loops=)

  • Sort Key: "KQ_RE_ADSERVING_SUPPORT_RENTAL_1".knowledge_id
297. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.10..3.02 rows=7 width=8) (actual rows= loops=)

  • Hash Cond: ("KQ_RE_ADSERVING_SUPPORT_RENTAL_1".knowledge_id = ck_id_43.id)
298. 0.000 0.000 ↓ 0.0

Seq Scan on "KQ_RE_ADSERVING_SUPPORT_RENTAL" "KQ_RE_ADSERVING_SUPPORT_RENTAL_1" (cost=0.00..2.35 rows=135 width=8) (actual rows= loops=)

299. 0.000 0.000 ↓ 0.0

Hash (cost=0.06..0.06 rows=3 width=4) (actual rows= loops=)

300. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_43 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

301.          

CTE KQ_RE_NS_AREA

302. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=1.87..1.94 rows=3 width=36) (actual rows= loops=)

  • Group Key: "KQ_RE_NS_AREA_1".knowledge_id
303. 0.000 0.000 ↓ 0.0

Sort (cost=1.87..1.87 rows=3 width=8) (actual rows= loops=)

  • Sort Key: "KQ_RE_NS_AREA_1".knowledge_id
304. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.10..1.84 rows=3 width=8) (actual rows= loops=)

  • Hash Cond: ("KQ_RE_NS_AREA_1".knowledge_id = ck_id_44.id)
305. 0.000 0.000 ↓ 0.0

Seq Scan on "KQ_RE_NS_AREA" "KQ_RE_NS_AREA_1" (cost=0.00..1.52 rows=52 width=8) (actual rows= loops=)

306. 0.000 0.000 ↓ 0.0

Hash (cost=0.06..0.06 rows=3 width=4) (actual rows= loops=)

307. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_44 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

308.          

CTE KQ_ADV_TARGETING

309. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=25.01..25.08 rows=3 width=36) (actual rows= loops=)

  • Group Key: "KQ_ADV_TARGETING_1".knowledge_id
310. 0.000 0.000 ↓ 0.0

Sort (cost=25.01..25.01 rows=3 width=8) (actual rows= loops=)

  • Sort Key: "KQ_ADV_TARGETING_1".knowledge_id
311. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..24.98 rows=3 width=8) (actual rows= loops=)

312. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_45 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

313. 0.000 0.000 ↓ 0.0

Index Scan using "ix_lookup_KQ_ADV_TARGETING_knowledge_id" on "KQ_ADV_TARGETING" "KQ_ADV_TARGETING_1" (cost=0.28..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_45.id)
314.          

CTE KQ_ADV_USE_COMMUNICATION_AGENCY

315. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=25.01..25.08 rows=3 width=36) (actual rows= loops=)

  • Group Key: "KQ_ADV_USE_COMMUNICATION_AGENCY_1".knowledge_id
316. 0.000 0.000 ↓ 0.0

Sort (cost=25.01..25.01 rows=3 width=8) (actual rows= loops=)

  • Sort Key: "KQ_ADV_USE_COMMUNICATION_AGENCY_1".knowledge_id
317. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..24.98 rows=3 width=8) (actual rows= loops=)

318. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_46 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

319. 0.000 0.000 ↓ 0.0

Index Scan using "ix_lookup_KQ_ADV_USE_COMMUNICATION_AGENCY_knowledge_id" on "KQ_ADV_USE_COMMUNICATION_AGENCY" "KQ_ADV_USE_COMMUNICATION_AGENCY_1" (cost=0.28..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_46.id)
320.          

CTE KQ_RE_REASON_ADS_HOLY_RENTAL

321. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_RE_REASON_ADS_HOLY_RENTAL_1".knowledge_id
322. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_RE_REASON_ADS_HOLY_RENTAL_1".knowledge_id
323. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

324. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_47 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

325. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_RE_REASON_ADS_HOLY_RENTAL" "KQ_RE_REASON_ADS_HOLY_RENTAL_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_47.id)
326. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_RE_REASON_ADS_HOLY_RENTAL_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_47.id)
327.          

CTE KQ_RE_NS_ANNUAL_PREMARKET

328. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=35.62..36.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_RE_NS_ANNUAL_PREMARKET_1".knowledge_id
329. 0.000 0.000 ↓ 0.0

Sort (cost=35.62..35.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_RE_NS_ANNUAL_PREMARKET_1".knowledge_id
330. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.91..34.75 rows=34 width=8) (actual rows= loops=)

331. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_48 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

332. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_RE_NS_ANNUAL_PREMARKET" "KQ_RE_NS_ANNUAL_PREMARKET_1" (cost=2.91..11.45 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_48.id)
333. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_RE_NS_ANNUAL_PREMARKET_knowledge_id" (cost=0.00..2.90 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_48.id)
334.          

CTE KQ_CUST_LBC_MONTH_RANGE_AD

335. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=3.10..3.18 rows=3 width=36) (actual rows= loops=)

  • Group Key: "KQ_CUST_LBC_MONTH_RANGE_AD_1".knowledge_id
336. 0.000 0.000 ↓ 0.0

Sort (cost=3.10..3.11 rows=3 width=8) (actual rows= loops=)

  • Sort Key: "KQ_CUST_LBC_MONTH_RANGE_AD_1".knowledge_id
337. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.10..3.08 rows=3 width=8) (actual rows= loops=)

  • Hash Cond: ("KQ_CUST_LBC_MONTH_RANGE_AD_1".knowledge_id = ck_id_49.id)
338. 0.000 0.000 ↓ 0.0

Seq Scan on "KQ_CUST_LBC_MONTH_RANGE_AD" "KQ_CUST_LBC_MONTH_RANGE_AD_1" (cost=0.00..2.42 rows=142 width=8) (actual rows= loops=)

339. 0.000 0.000 ↓ 0.0

Hash (cost=0.06..0.06 rows=3 width=4) (actual rows= loops=)

340. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_49 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

341.          

CTE KQ_CUST_LBC_CATEGORY

342. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_CUST_LBC_CATEGORY_1".knowledge_id
343. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_CUST_LBC_CATEGORY_1".knowledge_id
344. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

345. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_50 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

346. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_CUST_LBC_CATEGORY" "KQ_CUST_LBC_CATEGORY_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_50.id)
347. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_CUST_LBC_CATEGORY_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_50.id)
348.          

CTE KQ_CAR_MONTHLY_BUDGET

349. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_CAR_MONTHLY_BUDGET_1".knowledge_id
350. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_CAR_MONTHLY_BUDGET_1".knowledge_id
351. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

352. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_51 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

353. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_CAR_MONTHLY_BUDGET" "KQ_CAR_MONTHLY_BUDGET_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_51.id)
354. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_CAR_MONTHLY_BUDGET_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_51.id)
355.          

CTE KQ_RE_LIST_SELLER

356. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_RE_LIST_SELLER_1".knowledge_id
357. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_RE_LIST_SELLER_1".knowledge_id
358. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

359. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_52 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

360. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_RE_LIST_SELLER" "KQ_RE_LIST_SELLER_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_52.id)
361. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_RE_LIST_SELLER_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_52.id)
362.          

CTE KQ_ADV_COMMUNICATION_LOCATION

363. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=25.01..25.08 rows=3 width=36) (actual rows= loops=)

  • Group Key: "KQ_ADV_COMMUNICATION_LOCATION_1".knowledge_id
364. 0.000 0.000 ↓ 0.0

Sort (cost=25.01..25.01 rows=3 width=8) (actual rows= loops=)

  • Sort Key: "KQ_ADV_COMMUNICATION_LOCATION_1".knowledge_id
365. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..24.98 rows=3 width=8) (actual rows= loops=)

366. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_53 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

367. 0.000 0.000 ↓ 0.0

Index Scan using "ix_lookup_KQ_ADV_COMMUNICATION_LOCATION_knowledge_id" on "KQ_ADV_COMMUNICATION_LOCATION" "KQ_ADV_COMMUNICATION_LOCATION_1" (cost=0.28..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_53.id)
368.          

CTE KQ_RE_LBC_ADSERVING_MODE_RENTAL

369. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=1.91..1.98 rows=3 width=36) (actual rows= loops=)

  • Group Key: "KQ_RE_LBC_ADSERVING_MODE_RENTAL_1".knowledge_id
370. 0.000 0.000 ↓ 0.0

Sort (cost=1.91..1.92 rows=3 width=8) (actual rows= loops=)

  • Sort Key: "KQ_RE_LBC_ADSERVING_MODE_RENTAL_1".knowledge_id
371. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.10..1.88 rows=3 width=8) (actual rows= loops=)

  • Hash Cond: ("KQ_RE_LBC_ADSERVING_MODE_RENTAL_1".knowledge_id = ck_id_54.id)
372. 0.000 0.000 ↓ 0.0

Seq Scan on "KQ_RE_LBC_ADSERVING_MODE_RENTAL" "KQ_RE_LBC_ADSERVING_MODE_RENTAL_1" (cost=0.00..1.55 rows=55 width=8) (actual rows= loops=)

373. 0.000 0.000 ↓ 0.0

Hash (cost=0.06..0.06 rows=3 width=4) (actual rows= loops=)

374. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_54 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

375.          

CTE KQ_RE_CATEGORIES

376. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_RE_CATEGORIES_1".knowledge_id
377. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_RE_CATEGORIES_1".knowledge_id
378. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

379. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_55 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

380. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_RE_CATEGORIES" "KQ_RE_CATEGORIES_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_55.id)
381. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_RE_CATEGORIES_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_55.id)
382.          

CTE KQ_JOB_ATS

383. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_JOB_ATS_1".knowledge_id
384. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_JOB_ATS_1".knowledge_id
385. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

386. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_56 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

387. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_JOB_ATS" "KQ_JOB_ATS_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_56.id)
388. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_JOB_ATS_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_56.id)
389.          

CTE KQ_RE_NS_SOFTWARE_LIST

390. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=35.62..36.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_RE_NS_SOFTWARE_LIST_1".knowledge_id
391. 0.000 0.000 ↓ 0.0

Sort (cost=35.62..35.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_RE_NS_SOFTWARE_LIST_1".knowledge_id
392. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.91..34.75 rows=34 width=8) (actual rows= loops=)

393. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_57 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

394. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_RE_NS_SOFTWARE_LIST" "KQ_RE_NS_SOFTWARE_LIST_1" (cost=2.91..11.45 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_57.id)
395. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_RE_NS_SOFTWARE_LIST_knowledge_id" (cost=0.00..2.90 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_57.id)
396.          

CTE KQ_JOB_STATUS

397. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=25.01..25.09 rows=3 width=36) (actual rows= loops=)

  • Group Key: "KQ_JOB_STATUS_1".knowledge_id
398. 0.000 0.000 ↓ 0.0

Sort (cost=25.01..25.02 rows=3 width=8) (actual rows= loops=)

  • Sort Key: "KQ_JOB_STATUS_1".knowledge_id
399. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..24.99 rows=3 width=8) (actual rows= loops=)

400. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_58 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

401. 0.000 0.000 ↓ 0.0

Index Scan using "ix_lookup_KQ_JOB_STATUS_knowledge_id" on "KQ_JOB_STATUS" "KQ_JOB_STATUS_1" (cost=0.28..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_58.id)
402.          

CTE KQ_RE_REASON_ADS

403. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=1.85..1.93 rows=3 width=36) (actual rows= loops=)

  • Group Key: "KQ_RE_REASON_ADS_1".knowledge_id
404. 0.000 0.000 ↓ 0.0

Sort (cost=1.85..1.86 rows=3 width=8) (actual rows= loops=)

  • Sort Key: "KQ_RE_REASON_ADS_1".knowledge_id
405. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.10..1.83 rows=3 width=8) (actual rows= loops=)

  • Hash Cond: ("KQ_RE_REASON_ADS_1".knowledge_id = ck_id_59.id)
406. 0.000 0.000 ↓ 0.0

Seq Scan on "KQ_RE_REASON_ADS" "KQ_RE_REASON_ADS_1" (cost=0.00..1.51 rows=51 width=8) (actual rows= loops=)

407. 0.000 0.000 ↓ 0.0

Hash (cost=0.06..0.06 rows=3 width=4) (actual rows= loops=)

408. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_59 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

409.          

CTE KQ_RE_SOFTWARE_LIST

410. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=5.93..6.01 rows=3 width=36) (actual rows= loops=)

  • Group Key: "KQ_RE_SOFTWARE_LIST_1".knowledge_id
411. 0.000 0.000 ↓ 0.0

Sort (cost=5.93..5.94 rows=3 width=8) (actual rows= loops=)

  • Sort Key: "KQ_RE_SOFTWARE_LIST_1".knowledge_id
412. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.10..5.91 rows=3 width=8) (actual rows= loops=)

  • Hash Cond: ("KQ_RE_SOFTWARE_LIST_1".knowledge_id = ck_id_60.id)
413. 0.000 0.000 ↓ 0.0

Seq Scan on "KQ_RE_SOFTWARE_LIST" "KQ_RE_SOFTWARE_LIST_1" (cost=0.00..4.75 rows=275 width=8) (actual rows= loops=)

414. 0.000 0.000 ↓ 0.0

Hash (cost=0.06..0.06 rows=3 width=4) (actual rows= loops=)

415. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_60 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

416.          

CTE KQ_CUST_KANTAR

417. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=25.02..25.10 rows=3 width=36) (actual rows= loops=)

  • Group Key: "KQ_CUST_KANTAR_1".knowledge_id
418. 0.000 0.000 ↓ 0.0

Sort (cost=25.02..25.03 rows=3 width=8) (actual rows= loops=)

  • Sort Key: "KQ_CUST_KANTAR_1".knowledge_id
419. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..25.00 rows=3 width=8) (actual rows= loops=)

420. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_61 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

421. 0.000 0.000 ↓ 0.0

Index Scan using "ix_lookup_KQ_CUST_KANTAR_knowledge_id" on "KQ_CUST_KANTAR" "KQ_CUST_KANTAR_1" (cost=0.29..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_61.id)
422.          

CTE KQ_CAR_OPTION_TYPE

423. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_CAR_OPTION_TYPE_1".knowledge_id
424. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_CAR_OPTION_TYPE_1".knowledge_id
425. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

426. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_62 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

427. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_CAR_OPTION_TYPE" "KQ_CAR_OPTION_TYPE_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_62.id)
428. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_CAR_OPTION_TYPE_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_62.id)
429.          

CTE KQ_RE_MONTH_CREDIT_BUDGET

430. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=7.86..7.93 rows=3 width=36) (actual rows= loops=)

  • Group Key: "KQ_RE_MONTH_CREDIT_BUDGET_1".knowledge_id
431. 0.000 0.000 ↓ 0.0

Sort (cost=7.86..7.87 rows=3 width=8) (actual rows= loops=)

  • Sort Key: "KQ_RE_MONTH_CREDIT_BUDGET_1".knowledge_id
432. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.10..7.83 rows=3 width=8) (actual rows= loops=)

  • Hash Cond: ("KQ_RE_MONTH_CREDIT_BUDGET_1".knowledge_id = ck_id_63.id)
433. 0.000 0.000 ↓ 0.0

Seq Scan on "KQ_RE_MONTH_CREDIT_BUDGET" "KQ_RE_MONTH_CREDIT_BUDGET_1" (cost=0.00..6.15 rows=415 width=8) (actual rows= loops=)

434. 0.000 0.000 ↓ 0.0

Hash (cost=0.06..0.06 rows=3 width=4) (actual rows= loops=)

435. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_63 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

436.          

CTE KQ_RE_USE_OPTION

437. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_RE_USE_OPTION_1".knowledge_id
438. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_RE_USE_OPTION_1".knowledge_id
439. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

440. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_64 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

441. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_RE_USE_OPTION" "KQ_RE_USE_OPTION_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_64.id)
442. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_RE_USE_OPTION_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_64.id)
443.          

CTE KQ_CUST_BUDGET_OPTION

444. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=35.62..36.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_CUST_BUDGET_OPTION_1".knowledge_id
445. 0.000 0.000 ↓ 0.0

Sort (cost=35.62..35.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_CUST_BUDGET_OPTION_1".knowledge_id
446. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.91..34.75 rows=34 width=8) (actual rows= loops=)

447. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_65 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

448. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_CUST_BUDGET_OPTION" "KQ_CUST_BUDGET_OPTION_1" (cost=2.91..11.45 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_65.id)
449. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_CUST_BUDGET_OPTION_knowledge_id" (cost=0.00..2.90 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_65.id)
450.          

CTE KQ_RE_RANGE_NS_PROG

451. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=35.62..36.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_RE_RANGE_NS_PROG_1".knowledge_id
452. 0.000 0.000 ↓ 0.0

Sort (cost=35.62..35.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_RE_RANGE_NS_PROG_1".knowledge_id
453. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.91..34.75 rows=34 width=8) (actual rows= loops=)

454. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_66 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

455. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_RE_RANGE_NS_PROG" "KQ_RE_RANGE_NS_PROG_1" (cost=2.91..11.45 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_66.id)
456. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_RE_RANGE_NS_PROG_knowledge_id" (cost=0.00..2.90 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_66.id)
457.          

CTE KQ_ADV_COMMUNICATION_SUPPORT

458. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=8.30..8.37 rows=3 width=36) (actual rows= loops=)

  • Group Key: "KQ_ADV_COMMUNICATION_SUPPORT_1".knowledge_id
459. 0.000 0.000 ↓ 0.0

Sort (cost=8.30..8.31 rows=3 width=8) (actual rows= loops=)

  • Sort Key: "KQ_ADV_COMMUNICATION_SUPPORT_1".knowledge_id
460. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.10..8.27 rows=3 width=8) (actual rows= loops=)

  • Hash Cond: ("KQ_ADV_COMMUNICATION_SUPPORT_1".knowledge_id = ck_id_67.id)
461. 0.000 0.000 ↓ 0.0

Seq Scan on "KQ_ADV_COMMUNICATION_SUPPORT" "KQ_ADV_COMMUNICATION_SUPPORT_1" (cost=0.00..6.47 rows=447 width=8) (actual rows= loops=)

462. 0.000 0.000 ↓ 0.0

Hash (cost=0.06..0.06 rows=3 width=4) (actual rows= loops=)

463. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_67 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

464.          

CTE KQ_RE_ADSERVING_SUPPORT

465. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=16.16..16.31 rows=6 width=36) (actual rows= loops=)

  • Group Key: "KQ_RE_ADSERVING_SUPPORT_1".knowledge_id
466. 0.000 0.000 ↓ 0.0

Sort (cost=16.16..16.17 rows=6 width=8) (actual rows= loops=)

  • Sort Key: "KQ_RE_ADSERVING_SUPPORT_1".knowledge_id
467. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.10..16.08 rows=6 width=8) (actual rows= loops=)

  • Hash Cond: ("KQ_RE_ADSERVING_SUPPORT_1".knowledge_id = ck_id_68.id)
468. 0.000 0.000 ↓ 0.0

Seq Scan on "KQ_RE_ADSERVING_SUPPORT" "KQ_RE_ADSERVING_SUPPORT_1" (cost=0.00..12.67 rows=867 width=8) (actual rows= loops=)

469. 0.000 0.000 ↓ 0.0

Hash (cost=0.06..0.06 rows=3 width=4) (actual rows= loops=)

470. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_68 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

471.          

CTE KQ_RE_ADSERVING_SUPPORT_HOLY_RENTAL

472. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_RE_ADSERVING_SUPPORT_HOLY_RENTAL_1".knowledge_id
473. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_RE_ADSERVING_SUPPORT_HOLY_RENTAL_1".knowledge_id
474. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

475. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_69 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

476. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_RE_ADSERVING_SUPPORT_HOLY_RENTAL" "KQ_RE_ADSERVING_SUPPORT_HOLY_RENTAL_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_69.id)
477. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_RE_ADSERVING_SUPPORT_HOLY_RENTAL_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_69.id)
478.          

CTE KQ_JOB_MULTIPOSTER_LEC

479. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_JOB_MULTIPOSTER_LEC_1".knowledge_id
480. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_JOB_MULTIPOSTER_LEC_1".knowledge_id
481. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

482. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_70 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

483. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_JOB_MULTIPOSTER_LEC" "KQ_JOB_MULTIPOSTER_LEC_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_70.id)
484. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_JOB_MULTIPOSTER_LEC_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_70.id)
485.          

CTE KQ_RE_REASON_ADS_NEW_SALE

486. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_RE_REASON_ADS_NEW_SALE_1".knowledge_id
487. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_RE_REASON_ADS_NEW_SALE_1".knowledge_id
488. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

489. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_71 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

490. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_RE_REASON_ADS_NEW_SALE" "KQ_RE_REASON_ADS_NEW_SALE_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_71.id)
491. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_RE_REASON_ADS_NEW_SALE_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_71.id)
492.          

CTE KQ_CUST_WEBSITE

493. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=25.01..25.08 rows=3 width=36) (actual rows= loops=)

  • Group Key: "KQ_CUST_WEBSITE_1".knowledge_id
494. 0.000 0.000 ↓ 0.0

Sort (cost=25.01..25.01 rows=3 width=8) (actual rows= loops=)

  • Sort Key: "KQ_CUST_WEBSITE_1".knowledge_id
495. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..24.98 rows=3 width=8) (actual rows= loops=)

496. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_72 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

497. 0.000 0.000 ↓ 0.0

Index Scan using "ix_lookup_KQ_CUST_WEBSITE_knowledge_id" on "KQ_CUST_WEBSITE" "KQ_CUST_WEBSITE_1" (cost=0.28..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_72.id)
498.          

CTE KQ_CAR_USE_OPTION

499. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_CAR_USE_OPTION_1".knowledge_id
500. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_CAR_USE_OPTION_1".knowledge_id
501. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

502. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_73 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

503. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_CAR_USE_OPTION" "KQ_CAR_USE_OPTION_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_73.id)
504. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_CAR_USE_OPTION_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_73.id)
505.          

CTE KQ_ADV_ANNUAL_NEED_3

506. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.38..4.96 rows=14 width=36) (actual rows= loops=)

  • Group Key: "KQ_ADV_ANNUAL_NEED_3_1".knowledge_id
507. 0.000 0.000 ↓ 0.0

Sort (cost=4.38..4.46 rows=33 width=8) (actual rows= loops=)

  • Sort Key: "KQ_ADV_ANNUAL_NEED_3_1".knowledge_id
508. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.10..3.54 rows=33 width=8) (actual rows= loops=)

  • Hash Cond: ("KQ_ADV_ANNUAL_NEED_3_1".knowledge_id = ck_id_74.id)
509. 0.000 0.000 ↓ 0.0

Seq Scan on "KQ_ADV_ANNUAL_NEED_3" "KQ_ADV_ANNUAL_NEED_3_1" (cost=0.00..2.54 rows=154 width=8) (actual rows= loops=)

510. 0.000 0.000 ↓ 0.0

Hash (cost=0.06..0.06 rows=3 width=4) (actual rows= loops=)

511. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_74 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

512.          

CTE KQ_JOB_ACTIVITY

513. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=25.02..25.10 rows=3 width=36) (actual rows= loops=)

  • Group Key: "KQ_JOB_ACTIVITY_1".knowledge_id
514. 0.000 0.000 ↓ 0.0

Sort (cost=25.02..25.03 rows=3 width=8) (actual rows= loops=)

  • Sort Key: "KQ_JOB_ACTIVITY_1".knowledge_id
515. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..25.00 rows=3 width=8) (actual rows= loops=)

516. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_75 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

517. 0.000 0.000 ↓ 0.0

Index Scan using "ix_lookup_KQ_JOB_ACTIVITY_knowledge_id" on "KQ_JOB_ACTIVITY" "KQ_JOB_ACTIVITY_1" (cost=0.29..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_75.id)
518.          

CTE KQ_JOB_SOFTWARE_LIST

519. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=35.62..36.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_JOB_SOFTWARE_LIST_1".knowledge_id
520. 0.000 0.000 ↓ 0.0

Sort (cost=35.62..35.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_JOB_SOFTWARE_LIST_1".knowledge_id
521. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.91..34.75 rows=34 width=8) (actual rows= loops=)

522. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_76 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

523. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_JOB_SOFTWARE_LIST" "KQ_JOB_SOFTWARE_LIST_1" (cost=2.91..11.45 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_76.id)
524. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_JOB_SOFTWARE_LIST_knowledge_id" (cost=0.00..2.90 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_76.id)
525.          

CTE KQ_JOB_MULTIPOSTER

526. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=35.62..36.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_JOB_MULTIPOSTER_1".knowledge_id
527. 0.000 0.000 ↓ 0.0

Sort (cost=35.62..35.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_JOB_MULTIPOSTER_1".knowledge_id
528. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.91..34.75 rows=34 width=8) (actual rows= loops=)

529. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_77 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

530. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_JOB_MULTIPOSTER" "KQ_JOB_MULTIPOSTER_1" (cost=2.91..11.45 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_77.id)
531. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_JOB_MULTIPOSTER_knowledge_id" (cost=0.00..2.90 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_77.id)
532.          

CTE KQ_CUST_LBC_DEPOSIT

533. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=25.01..25.08 rows=3 width=36) (actual rows= loops=)

  • Group Key: "KQ_CUST_LBC_DEPOSIT_1".knowledge_id
534. 0.000 0.000 ↓ 0.0

Sort (cost=25.01..25.01 rows=3 width=8) (actual rows= loops=)

  • Sort Key: "KQ_CUST_LBC_DEPOSIT_1".knowledge_id
535. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..24.98 rows=3 width=8) (actual rows= loops=)

536. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_78 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

537. 0.000 0.000 ↓ 0.0

Index Scan using "ix_lookup_KQ_CUST_LBC_DEPOSIT_knowledge_id" on "KQ_CUST_LBC_DEPOSIT" "KQ_CUST_LBC_DEPOSIT_1" (cost=0.28..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_78.id)
538.          

CTE KQ_RE_LBC_ADSERVING_MODE

539. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=7.49..7.56 rows=3 width=36) (actual rows= loops=)

  • Group Key: "KQ_RE_LBC_ADSERVING_MODE_1".knowledge_id
540. 0.000 0.000 ↓ 0.0

Sort (cost=7.49..7.49 rows=3 width=8) (actual rows= loops=)

  • Sort Key: "KQ_RE_LBC_ADSERVING_MODE_1".knowledge_id
541. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.10..7.46 rows=3 width=8) (actual rows= loops=)

  • Hash Cond: ("KQ_RE_LBC_ADSERVING_MODE_1".knowledge_id = ck_id_79.id)
542. 0.000 0.000 ↓ 0.0

Seq Scan on "KQ_RE_LBC_ADSERVING_MODE" "KQ_RE_LBC_ADSERVING_MODE_1" (cost=0.00..5.88 rows=388 width=8) (actual rows= loops=)

543. 0.000 0.000 ↓ 0.0

Hash (cost=0.06..0.06 rows=3 width=4) (actual rows= loops=)

544. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_79 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

545.          

CTE KQ_CUST_CREDITCARD

546. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_CUST_CREDITCARD_1".knowledge_id
547. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_CUST_CREDITCARD_1".knowledge_id
548. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

549. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_80 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

550. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_CUST_CREDITCARD" "KQ_CUST_CREDITCARD_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_80.id)
551. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_CUST_CREDITCARD_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_80.id)
552.          

CTE KQ_ADV_SPC

553. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=25.01..25.08 rows=3 width=36) (actual rows= loops=)

  • Group Key: "KQ_ADV_SPC_1".knowledge_id
554. 0.000 0.000 ↓ 0.0

Sort (cost=25.01..25.01 rows=3 width=8) (actual rows= loops=)

  • Sort Key: "KQ_ADV_SPC_1".knowledge_id
555. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..24.98 rows=3 width=8) (actual rows= loops=)

556. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_81 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

557. 0.000 0.000 ↓ 0.0

Index Scan using "ix_lookup_KQ_ADV_SPC_knowledge_id" on "KQ_ADV_SPC" "KQ_ADV_SPC_1" (cost=0.28..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_81.id)
558.          

CTE KQ_RE_CONTACT_TYPOLOGY

559. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_RE_CONTACT_TYPOLOGY_1".knowledge_id
560. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_RE_CONTACT_TYPOLOGY_1".knowledge_id
561. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

562. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_82 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

563. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_RE_CONTACT_TYPOLOGY" "KQ_RE_CONTACT_TYPOLOGY_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_82.id)
564. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_RE_CONTACT_TYPOLOGY_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_82.id)
565.          

CTE KQ_JOB_SUPPORT

566. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=25.01..25.08 rows=3 width=36) (actual rows= loops=)

  • Group Key: "KQ_JOB_SUPPORT_1".knowledge_id
567. 0.000 0.000 ↓ 0.0

Sort (cost=25.01..25.01 rows=3 width=8) (actual rows= loops=)

  • Sort Key: "KQ_JOB_SUPPORT_1".knowledge_id
568. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..24.98 rows=3 width=8) (actual rows= loops=)

569. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_83 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

570. 0.000 0.000 ↓ 0.0

Index Scan using "ix_lookup_KQ_JOB_SUPPORT_knowledge_id" on "KQ_JOB_SUPPORT" "KQ_JOB_SUPPORT_1" (cost=0.28..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_83.id)
571.          

CTE KQ_ADV_NB_ANNUAL_CAMPAIGN

572. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=25.01..25.08 rows=3 width=36) (actual rows= loops=)

  • Group Key: "KQ_ADV_NB_ANNUAL_CAMPAIGN_1".knowledge_id
573. 0.000 0.000 ↓ 0.0

Sort (cost=25.01..25.01 rows=3 width=8) (actual rows= loops=)

  • Sort Key: "KQ_ADV_NB_ANNUAL_CAMPAIGN_1".knowledge_id
574. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..24.98 rows=3 width=8) (actual rows= loops=)

575. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_84 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

576. 0.000 0.000 ↓ 0.0

Index Scan using "ix_lookup_KQ_ADV_NB_ANNUAL_CAMPAIGN_knowledge_id" on "KQ_ADV_NB_ANNUAL_CAMPAIGN" "KQ_ADV_NB_ANNUAL_CAMPAIGN_1" (cost=0.28..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_84.id)
577.          

CTE KQ_RE_USE_SOFTWARE

578. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=7.28..7.36 rows=3 width=36) (actual rows= loops=)

  • Group Key: "KQ_RE_USE_SOFTWARE_1".knowledge_id
579. 0.000 0.000 ↓ 0.0

Sort (cost=7.28..7.29 rows=3 width=8) (actual rows= loops=)

  • Sort Key: "KQ_RE_USE_SOFTWARE_1".knowledge_id
580. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.10..7.26 rows=3 width=8) (actual rows= loops=)

  • Hash Cond: ("KQ_RE_USE_SOFTWARE_1".knowledge_id = ck_id_85.id)
581. 0.000 0.000 ↓ 0.0

Seq Scan on "KQ_RE_USE_SOFTWARE" "KQ_RE_USE_SOFTWARE_1" (cost=0.00..5.73 rows=373 width=8) (actual rows= loops=)

582. 0.000 0.000 ↓ 0.0

Hash (cost=0.06..0.06 rows=3 width=4) (actual rows= loops=)

583. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_85 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

584.          

CTE KQ_JOB_USE_SOFTWARE

585. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_JOB_USE_SOFTWARE_1".knowledge_id
586. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_JOB_USE_SOFTWARE_1".knowledge_id
587. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

588. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_86 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

589. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_JOB_USE_SOFTWARE" "KQ_JOB_USE_SOFTWARE_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_86.id)
590. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_JOB_USE_SOFTWARE_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_86.id)
591.          

CTE KQ_JOB_ADSERVING_SUPPORT

592. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_JOB_ADSERVING_SUPPORT_1".knowledge_id
593. 0.000 0.000 ↓ 0.0

Sort (cost=31.62..31.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_JOB_ADSERVING_SUPPORT_1".knowledge_id
594. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual rows= loops=)

595. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_87 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

596. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_JOB_ADSERVING_SUPPORT" "KQ_JOB_ADSERVING_SUPPORT_1" (cost=1.57..10.12 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_87.id)
597. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_JOB_ADSERVING_SUPPORT_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_87.id)
598.          

CTE KQ_ADV_ANNUAL_NEED_2

599. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=46.79..47.59 rows=32 width=36) (actual rows= loops=)

  • Group Key: "KQ_ADV_ANNUAL_NEED_2_1".knowledge_id
600. 0.000 0.000 ↓ 0.0

Sort (cost=46.79..46.87 rows=32 width=8) (actual rows= loops=)

  • Sort Key: "KQ_ADV_ANNUAL_NEED_2_1".knowledge_id
601. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.37..45.99 rows=32 width=8) (actual rows= loops=)

602. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_88 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

603. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_ADV_ANNUAL_NEED_2" "KQ_ADV_ANNUAL_NEED_2_1" (cost=4.37..15.20 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_88.id)
604. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_ADV_ANNUAL_NEED_2_knowledge_id" (cost=0.00..4.36 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_88.id)
605.          

CTE KQ_RE_NS_AD_MODE

606. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=35.62..36.47 rows=34 width=36) (actual rows= loops=)

  • Group Key: "KQ_RE_NS_AD_MODE_1".knowledge_id
607. 0.000 0.000 ↓ 0.0

Sort (cost=35.62..35.70 rows=34 width=8) (actual rows= loops=)

  • Sort Key: "KQ_RE_NS_AD_MODE_1".knowledge_id
608. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.91..34.75 rows=34 width=8) (actual rows= loops=)

609. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_89 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

610. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "KQ_RE_NS_AD_MODE" "KQ_RE_NS_AD_MODE_1" (cost=2.91..11.45 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (knowledge_id = ck_id_89.id)
611. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "ix_lookup_KQ_RE_NS_AD_MODE_knowledge_id" (cost=0.00..2.90 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (knowledge_id = ck_id_89.id)
612.          

CTE KQ_AREA_LIST

613. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=28.15..28.53 rows=19 width=36) (actual rows= loops=)

  • Group Key: "KQ_AREA_LIST_1".knowledge_id
614. 0.000 0.000 ↓ 0.0

Sort (cost=28.15..28.20 rows=19 width=36) (actual rows= loops=)

  • Sort Key: "KQ_AREA_LIST_1".knowledge_id
615. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.10..27.75 rows=19 width=36) (actual rows= loops=)

  • Hash Cond: ("KQ_AREA_LIST_1".knowledge_id = ck_id_90.id)
616. 0.000 0.000 ↓ 0.0

Seq Scan on "KQ_AREA_LIST" "KQ_AREA_LIST_1" (cost=0.00..22.70 rows=1,270 width=36) (actual rows= loops=)

617. 0.000 0.000 ↓ 0.0

Hash (cost=0.06..0.06 rows=3 width=4) (actual rows= loops=)

618. 0.000 0.000 ↓ 0.0

CTE Scan on ck_id ck_id_90 (cost=0.00..0.06 rows=3 width=4) (actual rows= loops=)

619. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=76.52..76.58 rows=3 width=3,781) (actual rows= loops=)

  • Merge Cond: (ck_id.id = "KQ_ADV_NB_ANNUAL_CAMPAIGN".k_id)
620. 0.000 0.000 ↓ 0.0

Sort (cost=76.44..76.45 rows=3 width=3,749) (actual rows= loops=)

  • Sort Key: ck_id.id DESC
621. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=75.58..76.42 rows=3 width=3,749) (actual rows= loops=)

  • Hash Cond: ("KQ_RE_NS_AD_MODE".k_id = ck_id.id)
622. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_RE_NS_AD_MODE" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

623. 0.000 0.000 ↓ 0.0

Hash (cost=75.54..75.54 rows=3 width=3,717) (actual rows= loops=)

624. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=74.70..75.54 rows=3 width=3,717) (actual rows= loops=)

  • Hash Cond: ("KQ_JOB_ADSERVING_SUPPORT".k_id = ck_id.id)
625. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_JOB_ADSERVING_SUPPORT" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

626. 0.000 0.000 ↓ 0.0

Hash (cost=74.67..74.67 rows=3 width=3,685) (actual rows= loops=)

627. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=73.83..74.67 rows=3 width=3,685) (actual rows= loops=)

  • Hash Cond: ("KQ_JOB_USE_SOFTWARE".k_id = ck_id.id)
628. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_JOB_USE_SOFTWARE" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

629. 0.000 0.000 ↓ 0.0

Hash (cost=73.79..73.79 rows=3 width=3,653) (actual rows= loops=)

630. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=73.00..73.79 rows=3 width=3,653) (actual rows= loops=)

  • Hash Cond: ("KQ_ADV_ANNUAL_NEED_2".k_id = ck_id.id)
631. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_ADV_ANNUAL_NEED_2" (cost=0.00..0.64 rows=32 width=36) (actual rows= loops=)

632. 0.000 0.000 ↓ 0.0

Hash (cost=72.96..72.96 rows=3 width=3,621) (actual rows= loops=)

633. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=72.48..72.96 rows=3 width=3,621) (actual rows= loops=)

  • Hash Cond: ("KQ_AREA_LIST".k_id = ck_id.id)
634. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_AREA_LIST" (cost=0.00..0.38 rows=19 width=36) (actual rows= loops=)

635. 0.000 0.000 ↓ 0.0

Hash (cost=72.44..72.44 rows=3 width=3,589) (actual rows= loops=)

636. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=71.48..72.44 rows=3 width=3,589) (actual rows= loops=)

  • Hash Cond: (ck_id.id = "KQ_CUST_LBC_DEPOSIT".k_id)
637. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=71.39..72.31 rows=3 width=3,557) (actual rows= loops=)

  • Hash Cond: (ck_id.id = "KQ_RE_LBC_ADSERVING_MODE".k_id)
638. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=71.29..72.17 rows=3 width=3,525) (actual rows= loops=)

  • Hash Cond: (ck_id.id = "KQ_ADV_SPC".k_id)
639. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=71.19..72.03 rows=3 width=3,493) (actual rows= loops=)

  • Hash Cond: ("KQ_RE_CONTACT_TYPOLOGY".k_id = ck_id.id)
640. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_RE_CONTACT_TYPOLOGY" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

641. 0.000 0.000 ↓ 0.0

Hash (cost=71.15..71.15 rows=3 width=3,461) (actual rows= loops=)

642. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=70.32..71.15 rows=3 width=3,461) (actual rows= loops=)

  • Hash Cond: ("KQ_CUST_CREDITCARD".k_id = ck_id.id)
643. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_CUST_CREDITCARD" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

644. 0.000 0.000 ↓ 0.0

Hash (cost=70.28..70.28 rows=3 width=3,429) (actual rows= loops=)

645. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=69.44..70.28 rows=3 width=3,429) (actual rows= loops=)

  • Hash Cond: ("KQ_JOB_MULTIPOSTER".k_id = ck_id.id)
646. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_JOB_MULTIPOSTER" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

647. 0.000 0.000 ↓ 0.0

Hash (cost=69.40..69.40 rows=3 width=3,397) (actual rows= loops=)

648. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=69.13..69.40 rows=3 width=3,397) (actual rows= loops=)

  • Merge Cond: (ck_id.id = "KQ_JOB_SUPPORT".k_id)
649. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=69.05..69.27 rows=3 width=3,365) (actual rows= loops=)

  • Merge Cond: (ck_id.id = "KQ_JOB_ACTIVITY".k_id)
650. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=68.96..69.13 rows=3 width=3,333) (actual rows= loops=)

  • Merge Cond: (ck_id.id = "KQ_ADV_ANNUAL_NEED_3".k_id)
651. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=68.42..68.48 rows=3 width=3,301) (actual rows= loops=)

  • Merge Cond: (ck_id.id = "KQ_CUST_WEBSITE".k_id)
652. 0.000 0.000 ↓ 0.0

Sort (cost=68.33..68.34 rows=3 width=3,269) (actual rows= loops=)

  • Sort Key: ck_id.id DESC
653. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=67.47..68.31 rows=3 width=3,269) (actual rows= loops=)

  • Hash Cond: ("KQ_JOB_SOFTWARE_LIST".k_id = ck_id.id)
654. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_JOB_SOFTWARE_LIST" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

655. 0.000 0.000 ↓ 0.0

Hash (cost=67.43..67.43 rows=3 width=3,237) (actual rows= loops=)

656. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=66.60..67.43 rows=3 width=3,237) (actual rows= loops=)

  • Hash Cond: ("KQ_CAR_USE_OPTION".k_id = ck_id.id)
657. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_CAR_USE_OPTION" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

658. 0.000 0.000 ↓ 0.0

Hash (cost=66.56..66.56 rows=3 width=3,205) (actual rows= loops=)

659. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=65.72..66.56 rows=3 width=3,205) (actual rows= loops=)

  • Hash Cond: ("KQ_RE_REASON_ADS_NEW_SALE".k_id = ck_id.id)
660. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_RE_REASON_ADS_NEW_SALE" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

661. 0.000 0.000 ↓ 0.0

Hash (cost=65.68..65.68 rows=3 width=3,173) (actual rows= loops=)

662. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=64.85..65.68 rows=3 width=3,173) (actual rows= loops=)

  • Hash Cond: ("KQ_JOB_MULTIPOSTER_LEC".k_id = ck_id.id)
663. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_JOB_MULTIPOSTER_LEC" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

664. 0.000 0.000 ↓ 0.0

Hash (cost=64.81..64.81 rows=3 width=3,141) (actual rows= loops=)

665. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=63.85..64.81 rows=3 width=3,141) (actual rows= loops=)

  • Hash Cond: (ck_id.id = "KQ_RE_ADSERVING_SUPPORT".k_id)
666. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=63.65..64.57 rows=3 width=3,109) (actual rows= loops=)

  • Hash Cond: (ck_id.id = "KQ_ADV_COMMUNICATION_SUPPORT".k_id)
667. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=63.56..64.43 rows=3 width=3,077) (actual rows= loops=)

  • Hash Cond: (ck_id.id = "KQ_RE_MONTH_CREDIT_BUDGET".k_id)
668. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=63.46..64.30 rows=3 width=3,045) (actual rows= loops=)

  • Hash Cond: ("KQ_RE_ADSERVING_SUPPORT_HOLY_RENTAL".k_id = ck_id.id)
669. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_RE_ADSERVING_SUPPORT_HOLY_RENTAL" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

670. 0.000 0.000 ↓ 0.0

Hash (cost=63.42..63.42 rows=3 width=3,013) (actual rows= loops=)

671. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=62.58..63.42 rows=3 width=3,013) (actual rows= loops=)

  • Hash Cond: ("KQ_RE_RANGE_NS_PROG".k_id = ck_id.id)
672. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_RE_RANGE_NS_PROG" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

673. 0.000 0.000 ↓ 0.0

Hash (cost=62.55..62.55 rows=3 width=2,981) (actual rows= loops=)

674. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=61.71..62.55 rows=3 width=2,981) (actual rows= loops=)

  • Hash Cond: ("KQ_CUST_BUDGET_OPTION".k_id = ck_id.id)
675. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_CUST_BUDGET_OPTION" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

676. 0.000 0.000 ↓ 0.0

Hash (cost=61.67..61.67 rows=3 width=2,949) (actual rows= loops=)

677. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=60.83..61.67 rows=3 width=2,949) (actual rows= loops=)

  • Hash Cond: ("KQ_RE_USE_OPTION".k_id = ck_id.id)
678. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_RE_USE_OPTION" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

679. 0.000 0.000 ↓ 0.0

Hash (cost=60.80..60.80 rows=3 width=2,917) (actual rows= loops=)

680. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=59.79..60.80 rows=3 width=2,917) (actual rows= loops=)

  • Hash Cond: (ck_id.id = "KQ_CUST_KANTAR".k_id)
681. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=59.70..60.66 rows=3 width=2,885) (actual rows= loops=)

  • Hash Cond: (ck_id.id = "KQ_RE_SOFTWARE_LIST".k_id)
682. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=59.60..60.52 rows=3 width=2,853) (actual rows= loops=)

  • Hash Cond: (ck_id.id = "KQ_RE_REASON_ADS".k_id)
683. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=59.50..60.38 rows=3 width=2,821) (actual rows= loops=)

  • Hash Cond: (ck_id.id = "KQ_JOB_STATUS".k_id)
684. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=59.40..60.24 rows=3 width=2,789) (actual rows= loops=)

  • Hash Cond: ("KQ_CAR_OPTION_TYPE".k_id = ck_id.id)
685. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_CAR_OPTION_TYPE" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

686. 0.000 0.000 ↓ 0.0

Hash (cost=59.37..59.37 rows=3 width=2,757) (actual rows= loops=)

687. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=58.53..59.37 rows=3 width=2,757) (actual rows= loops=)

  • Hash Cond: ("KQ_RE_NS_SOFTWARE_LIST".k_id = ck_id.id)
688. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_RE_NS_SOFTWARE_LIST" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

689. 0.000 0.000 ↓ 0.0

Hash (cost=58.49..58.49 rows=3 width=2,725) (actual rows= loops=)

690. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=57.65..58.49 rows=3 width=2,725) (actual rows= loops=)

  • Hash Cond: ("KQ_JOB_ATS".k_id = ck_id.id)
691. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_JOB_ATS" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

692. 0.000 0.000 ↓ 0.0

Hash (cost=57.62..57.62 rows=3 width=2,693) (actual rows= loops=)

693. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=56.65..57.62 rows=3 width=2,693) (actual rows= loops=)

  • Hash Cond: (ck_id.id = "KQ_RE_LBC_ADSERVING_MODE_RENTAL".k_id)
694. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=56.56..57.48 rows=3 width=2,661) (actual rows= loops=)

  • Hash Cond: (ck_id.id = "KQ_ADV_COMMUNICATION_LOCATION".k_id)
695. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=56.46..57.34 rows=3 width=2,629) (actual rows= loops=)

  • Hash Cond: (ck_id.id = "KQ_CUST_LBC_MONTH_RANGE_AD".k_id)
696. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=56.36..57.20 rows=3 width=2,597) (actual rows= loops=)

  • Hash Cond: ("KQ_RE_CATEGORIES".k_id = ck_id.id)
697. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_RE_CATEGORIES" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

698. 0.000 0.000 ↓ 0.0

Hash (cost=56.32..56.32 rows=3 width=2,565) (actual rows= loops=)

699. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=55.49..56.32 rows=3 width=2,565) (actual rows= loops=)

  • Hash Cond: ("KQ_RE_LIST_SELLER".k_id = ck_id.id)
700. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_RE_LIST_SELLER" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

701. 0.000 0.000 ↓ 0.0

Hash (cost=55.45..55.45 rows=3 width=2,533) (actual rows= loops=)

702. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=54.61..55.45 rows=3 width=2,533) (actual rows= loops=)

  • Hash Cond: ("KQ_CAR_MONTHLY_BUDGET".k_id = ck_id.id)
703. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_CAR_MONTHLY_BUDGET" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

704. 0.000 0.000 ↓ 0.0

Hash (cost=54.57..54.57 rows=3 width=2,501) (actual rows= loops=)

705. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=53.74..54.57 rows=3 width=2,501) (actual rows= loops=)

  • Hash Cond: ("KQ_CUST_LBC_CATEGORY".k_id = ck_id.id)
706. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_CUST_LBC_CATEGORY" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

707. 0.000 0.000 ↓ 0.0

Hash (cost=53.70..53.70 rows=3 width=2,469) (actual rows= loops=)

708. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=52.70..53.70 rows=3 width=2,469) (actual rows= loops=)

  • Hash Cond: (ck_id.id = "KQ_ADV_USE_COMMUNICATION_AGENCY".k_id)
709. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=52.60..53.56 rows=3 width=2,437) (actual rows= loops=)

  • Hash Cond: (ck_id.id = "KQ_ADV_TARGETING".k_id)
710. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=52.50..53.42 rows=3 width=2,405) (actual rows= loops=)

  • Hash Cond: (ck_id.id = "KQ_RE_NS_AREA".k_id)
711. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=52.40..53.28 rows=3 width=2,373) (actual rows= loops=)

  • Hash Cond: (ck_id.id = "KQ_RE_ADSERVING_SUPPORT_RENTAL".k_id)
712. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=52.18..53.01 rows=3 width=2,341) (actual rows= loops=)

  • Hash Cond: ("KQ_RE_NS_ANNUAL_PREMARKET".k_id = ck_id.id)
713. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_RE_NS_ANNUAL_PREMARKET" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

714. 0.000 0.000 ↓ 0.0

Hash (cost=52.14..52.14 rows=3 width=2,309) (actual rows= loops=)

715. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=51.30..52.14 rows=3 width=2,309) (actual rows= loops=)

  • Hash Cond: ("KQ_RE_REASON_ADS_HOLY_RENTAL".k_id = ck_id.id)
716. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_RE_REASON_ADS_HOLY_RENTAL" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

717. 0.000 0.000 ↓ 0.0

Hash (cost=51.26..51.26 rows=3 width=2,277) (actual rows= loops=)

718. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=50.43..51.26 rows=3 width=2,277) (actual rows= loops=)

  • Hash Cond: ("KQ_CAR_LBC_ADSERVING_MODE".k_id = ck_id.id)
719. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_CAR_LBC_ADSERVING_MODE" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

720. 0.000 0.000 ↓ 0.0

Hash (cost=50.39..50.39 rows=3 width=2,245) (actual rows= loops=)

721. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=49.47..50.39 rows=3 width=2,245) (actual rows= loops=)

  • Hash Cond: (ck_id.id = "KQ_ADV_CAMPAIGN_DURATION".k_id)
722. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=49.37..50.25 rows=3 width=2,213) (actual rows= loops=)

  • Hash Cond: (ck_id.id = "KQ_ADV_GOALS3".k_id)
723. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=49.27..50.11 rows=3 width=2,181) (actual rows= loops=)

  • Hash Cond: ("KQ_RE_MONTHLY_BUDGET".k_id = ck_id.id)
724. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_RE_MONTHLY_BUDGET" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

725. 0.000 0.000 ↓ 0.0

Hash (cost=49.24..49.24 rows=3 width=2,149) (actual rows= loops=)

726. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=48.40..49.24 rows=3 width=2,149) (actual rows= loops=)

  • Hash Cond: ("KQ_JOB_ANNUAL_VACANCIES_RANGE".k_id = ck_id.id)
727. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_JOB_ANNUAL_VACANCIES_RANGE" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

728. 0.000 0.000 ↓ 0.0

Hash (cost=48.36..48.36 rows=3 width=2,117) (actual rows= loops=)

729. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=47.52..48.36 rows=3 width=2,117) (actual rows= loops=)

  • Hash Cond: ("KQ_RE_OPTION_TYPE".k_id = ck_id.id)
730. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_RE_OPTION_TYPE" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

731. 0.000 0.000 ↓ 0.0

Hash (cost=47.49..47.49 rows=3 width=2,085) (actual rows= loops=)

732. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=46.65..47.49 rows=3 width=2,085) (actual rows= loops=)

  • Hash Cond: ("KQ_CUST_RUBRIQUE".k_id = ck_id.id)
733. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_CUST_RUBRIQUE" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

734. 0.000 0.000 ↓ 0.0

Hash (cost=46.61..46.61 rows=3 width=2,053) (actual rows= loops=)

735. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=45.77..46.61 rows=3 width=2,053) (actual rows= loops=)

  • Hash Cond: ("KQ_CAR_CONSULT_STAT".k_id = ck_id.id)
736. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_CAR_CONSULT_STAT" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

737. 0.000 0.000 ↓ 0.0

Hash (cost=45.74..45.74 rows=3 width=2,021) (actual rows= loops=)

738. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=44.78..45.74 rows=3 width=2,021) (actual rows= loops=)

  • Hash Cond: (ck_id.id = "KQ_ADV_AGE_RANGE".k_id)
739. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=44.68..45.60 rows=3 width=1,989) (actual rows= loops=)

  • Hash Cond: (ck_id.id = "KQ_RE_FLOW_TYPE".k_id)
740. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=44.58..45.46 rows=3 width=1,957) (actual rows= loops=)

  • Hash Cond: (ck_id.id = "KQ_RE_ACTIVITIES".k_id)
741. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=44.48..45.32 rows=3 width=1,925) (actual rows= loops=)

  • Hash Cond: ("KQ_RE_LBC_ADSERVING_MODE_HOLY_RENTAL".k_id = ck_id.id)
742. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_RE_LBC_ADSERVING_MODE_HOLY_RENTAL" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

743. 0.000 0.000 ↓ 0.0

Hash (cost=44.45..44.45 rows=3 width=1,893) (actual rows= loops=)

744. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=43.61..44.45 rows=3 width=1,893) (actual rows= loops=)

  • Hash Cond: ("KQ_JOB_CONTRACT".k_id = ck_id.id)
745. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_JOB_CONTRACT" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

746. 0.000 0.000 ↓ 0.0

Hash (cost=43.57..43.57 rows=3 width=1,861) (actual rows= loops=)

747. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=42.73..43.57 rows=3 width=1,861) (actual rows= loops=)

  • Hash Cond: ("KQ_CUST_CREDITCARD_USE".k_id = ck_id.id)
748. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_CUST_CREDITCARD_USE" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

749. 0.000 0.000 ↓ 0.0

Hash (cost=42.70..42.70 rows=3 width=1,829) (actual rows= loops=)

750. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=41.86..42.70 rows=3 width=1,829) (actual rows= loops=)

  • Hash Cond: ("KQ_RE_ANNUAL_OPTION_BUDGET".k_id = ck_id.id)
751. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_RE_ANNUAL_OPTION_BUDGET" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

752. 0.000 0.000 ↓ 0.0

Hash (cost=41.82..41.82 rows=3 width=1,797) (actual rows= loops=)

753. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=40.86..41.82 rows=3 width=1,797) (actual rows= loops=)

  • Hash Cond: (ck_id.id = "KQ_ADV_GOALS2".k_id)
754. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=40.76..41.68 rows=3 width=1,765) (actual rows= loops=)

  • Hash Cond: (ck_id.id = "KQ_ADV_GENDER".k_id)
755. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=40.66..41.54 rows=3 width=1,733) (actual rows= loops=)

  • Hash Cond: (ck_id.id = "KQ_CUST_EMPLOYEES_RANGE".k_id)
756. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=40.57..41.40 rows=3 width=1,701) (actual rows= loops=)

  • Hash Cond: ("KQ_CAR_OPTION_PERCENT".k_id = ck_id.id)
757. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_CAR_OPTION_PERCENT" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

758. 0.000 0.000 ↓ 0.0

Hash (cost=40.53..40.53 rows=3 width=1,669) (actual rows= loops=)

759. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=39.69..40.53 rows=3 width=1,669) (actual rows= loops=)

  • Hash Cond: ("KQ_CAR_SOFTWARE_LIST".k_id = ck_id.id)
760. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_CAR_SOFTWARE_LIST" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

761. 0.000 0.000 ↓ 0.0

Hash (cost=39.65..39.65 rows=3 width=1,637) (actual rows= loops=)

762. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=38.82..39.65 rows=3 width=1,637) (actual rows= loops=)

  • Hash Cond: ("KQ_JOB_SOFTWARE_LEC_LIST".k_id = ck_id.id)
763. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_JOB_SOFTWARE_LEC_LIST" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

764. 0.000 0.000 ↓ 0.0

Hash (cost=38.78..38.78 rows=3 width=1,605) (actual rows= loops=)

765. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=37.94..38.78 rows=3 width=1,605) (actual rows= loops=)

  • Hash Cond: ("KQ_RE_HOLIDAY_RENTAL".k_id = ck_id.id)
766. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_RE_HOLIDAY_RENTAL" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

767. 0.000 0.000 ↓ 0.0

Hash (cost=37.90..37.90 rows=3 width=1,573) (actual rows= loops=)

768. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=36.98..37.90 rows=3 width=1,573) (actual rows= loops=)

  • Hash Cond: (ck_id.id = "KQ_ADV_COMMUNICATION_RADIUS".k_id)
769. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=36.89..37.77 rows=3 width=1,541) (actual rows= loops=)

  • Hash Cond: (ck_id.id = "KQ_ADV_GOALS".k_id)
770. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=36.79..37.63 rows=3 width=1,509) (actual rows= loops=)

  • Hash Cond: ("KQ_RE_RANGE".k_id = ck_id.id)
771. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_RE_RANGE" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

772. 0.000 0.000 ↓ 0.0

Hash (cost=36.75..36.75 rows=3 width=1,477) (actual rows= loops=)

773. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=35.91..36.75 rows=3 width=1,477) (actual rows= loops=)

  • Hash Cond: ("KQ_CAR_ADSERVING_SUPPORT".k_id = ck_id.id)
774. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_CAR_ADSERVING_SUPPORT" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

775. 0.000 0.000 ↓ 0.0

Hash (cost=35.88..35.88 rows=3 width=1,445) (actual rows= loops=)

776. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=35.04..35.88 rows=3 width=1,445) (actual rows= loops=)

  • Hash Cond: ("KQ_JOB_MANAGEMENT".k_id = ck_id.id)
777. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_JOB_MANAGEMENT" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

778. 0.000 0.000 ↓ 0.0

Hash (cost=35.00..35.00 rows=3 width=1,413) (actual rows= loops=)

779. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=34.16..35.00 rows=3 width=1,413) (actual rows= loops=)

  • Hash Cond: ("KQ_JOB_CAREER_PAGE".k_id = ck_id.id)
780. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_JOB_CAREER_PAGE" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

781. 0.000 0.000 ↓ 0.0

Hash (cost=34.13..34.13 rows=3 width=1,381) (actual rows= loops=)

782. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=33.53..34.13 rows=3 width=1,381) (actual rows= loops=)

  • Hash Cond: ("KQ_JOB_ANNUAL_NEED".k_id = ck_id.id)
783. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_JOB_ANNUAL_NEED" (cost=0.00..0.48 rows=24 width=36) (actual rows= loops=)

784. 0.000 0.000 ↓ 0.0

Hash (cost=33.49..33.49 rows=3 width=1,349) (actual rows= loops=)

785. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=32.57..33.49 rows=3 width=1,349) (actual rows= loops=)

  • Hash Cond: (ck_id.id = "KQ_RE_ADSERVING_SUPPORT_NEW_SALES".k_id)
786. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=32.44..33.32 rows=3 width=1,317) (actual rows= loops=)

  • Hash Cond: (ck_id.id = "KQ_RE_AVERAGE_TIME_ACTION".k_id)
787. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=32.34..33.18 rows=3 width=1,285) (actual rows= loops=)

  • Hash Cond: ("KQ_CAR_DEALERSHIP_MODE".k_id = ck_id.id)
788. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_CAR_DEALERSHIP_MODE" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

789. 0.000 0.000 ↓ 0.0

Hash (cost=32.30..32.30 rows=3 width=1,253) (actual rows= loops=)

790. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=31.47..32.30 rows=3 width=1,253) (actual rows= loops=)

  • Hash Cond: ("KQ_RE_LBC_ADSERVING_MODE_NEW_SALES".k_id = ck_id.id)
791. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_RE_LBC_ADSERVING_MODE_NEW_SALES" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

792. 0.000 0.000 ↓ 0.0

Hash (cost=31.43..31.43 rows=3 width=1,221) (actual rows= loops=)

793. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=30.59..31.43 rows=3 width=1,221) (actual rows= loops=)

  • Hash Cond: ("KQ_CAR_STOCK".k_id = ck_id.id)
794. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_CAR_STOCK" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

795. 0.000 0.000 ↓ 0.0

Hash (cost=30.55..30.55 rows=3 width=1,189) (actual rows= loops=)

796. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=29.72..30.55 rows=3 width=1,189) (actual rows= loops=)

  • Hash Cond: ("KQ_CAR_USE_SOFTWARE".k_id = ck_id.id)
797. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_CAR_USE_SOFTWARE" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

798. 0.000 0.000 ↓ 0.0

Hash (cost=29.68..29.68 rows=3 width=1,157) (actual rows= loops=)

799. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=28.84..29.68 rows=3 width=1,157) (actual rows= loops=)

  • Hash Cond: ("KQ_RE_OPTION_PERCENT".k_id = ck_id.id)
800. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_RE_OPTION_PERCENT" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

801. 0.000 0.000 ↓ 0.0

Hash (cost=28.80..28.80 rows=3 width=1,125) (actual rows= loops=)

802. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=3.88..28.80 rows=3 width=1,125) (actual rows= loops=)

  • Join Filter: ("KQ_CUST_USE_OPTION".k_id = ck_id.id)
803. 0.000 0.000 ↓ 0.0

Nested Loop (cost=3.88..28.57 rows=3 width=1,093) (actual rows= loops=)

804. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=3.60..3.66 rows=3 width=196) (actual rows= loops=)

  • Merge Cond: (ck_id.id = "KQ_CUST_SUB_KANTAR".k_id)
805. 0.000 0.000 ↓ 0.0

Sort (cost=3.51..3.52 rows=3 width=164) (actual rows= loops=)

  • Sort Key: ck_id.id DESC
806. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=2.65..3.49 rows=3 width=164) (actual rows= loops=)

  • Hash Cond: ("KQ_JOB_CATEGORY".k_id = ck_id.id)
807. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_JOB_CATEGORY" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

808. 0.000 0.000 ↓ 0.0

Hash (cost=2.61..2.61 rows=3 width=132) (actual rows= loops=)

809. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=1.78..2.61 rows=3 width=132) (actual rows= loops=)

  • Hash Cond: ("KQ_CAR_ANNUAL_OPTION_BUDGET".k_id = ck_id.id)
810. 0.000 0.000 ↓ 0.0

CTE Scan on "KQ_CAR_ANNUAL_OPTION_BUDGET" (cost=0.00..0.68 rows=34 width=36) (actual rows= loops=)

811. 0.000 0.000 ↓ 0.0

Hash (cost=1.74..1.74 rows=3 width=100) (actual rows= loops=)

812. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=0.90..1.74 rows=3 width=100) (actual rows= loops=)

  • Hash Cond: ("KQ_RE_REASON_ADS_RENTAL".k_id = ck_id.id)
813. 0.000 0.000 ↓ 0.0