explain.depesz.com

PostgreSQL's explain analyze made readable

Result: M1x6

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 3.788 ↑ 1.0 3 1

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

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

CTE ck_id

3. 0.022 0.073 ↑ 1.0 3 1

Nested Loop (cost=4.76..89.02 rows=3 width=36) (actual time=0.060..0.073 rows=3 loops=1)

4. 0.012 0.036 ↑ 2.3 3 1

Bitmap Heap Scan on callhistorian (cost=4.47..30.87 rows=7 width=12) (actual time=0.031..0.036 rows=3 loops=1)

  • Filter: (acc ~~ 'ACC312543'::text)
  • Heap Blocks: exact=3
5. 0.024 0.024 ↑ 2.3 3 1

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

  • Index Cond: (acc = 'ACC312543'::text)
6. 0.015 0.015 ↑ 1.0 1 3

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

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

CTE KQ_ADV_ANNUAL_NEED

8. 0.001 0.035 ↓ 0.0 0 1

GroupAggregate (cost=95.43..96.20 rows=31 width=36) (actual time=0.035..0.035 rows=0 loops=1)

  • Group Key: "KQ_ADV_ANNUAL_NEED_1".knowledge_id
9. 0.005 0.034 ↓ 0.0 0 1

Sort (cost=95.43..95.51 rows=31 width=8) (actual time=0.034..0.034 rows=0 loops=1)

  • Sort Key: "KQ_ADV_ANNUAL_NEED_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
10. 0.007 0.029 ↓ 0.0 0 1

Nested Loop (cost=4.37..94.66 rows=31 width=8) (actual time=0.029..0.029 rows=0 loops=1)

11. 0.001 0.001 ↑ 1.0 3 1

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

12. 0.000 0.021 ↓ 0.0 0 3

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

  • Recheck Cond: (knowledge_id = ck_id_1.id)
13. 0.021 0.021 ↓ 0.0 0 3

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

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

CTE KQ_CUST_SUB_KANTAR

15. 0.001 0.012 ↓ 0.0 0 1

GroupAggregate (cost=25.01..25.08 rows=3 width=36) (actual time=0.012..0.012 rows=0 loops=1)

  • Group Key: "KQ_CUST_SUB_KANTAR_1".knowledge_id
16. 0.003 0.011 ↓ 0.0 0 1

Sort (cost=25.01..25.01 rows=3 width=8) (actual time=0.011..0.011 rows=0 loops=1)

  • Sort Key: "KQ_CUST_SUB_KANTAR_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
17. 0.002 0.008 ↓ 0.0 0 1

Nested Loop (cost=0.28..24.98 rows=3 width=8) (actual time=0.008..0.008 rows=0 loops=1)

18. 0.000 0.000 ↑ 1.0 3 1

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

19. 0.006 0.006 ↓ 0.0 0 3

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 time=0.002..0.002 rows=0 loops=3)

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

CTE KQ_RE_REASON_ADS_RENTAL

21. 0.001 0.017 ↓ 0.0 0 1

GroupAggregate (cost=35.62..36.47 rows=34 width=36) (actual time=0.017..0.017 rows=0 loops=1)

  • Group Key: "KQ_RE_REASON_ADS_RENTAL_1".knowledge_id
22. 0.007 0.016 ↓ 0.0 0 1

Sort (cost=35.62..35.70 rows=34 width=8) (actual time=0.016..0.016 rows=0 loops=1)

  • Sort Key: "KQ_RE_REASON_ADS_RENTAL_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
23. 0.005 0.009 ↓ 0.0 0 1

Nested Loop (cost=2.91..34.75 rows=34 width=8) (actual time=0.009..0.009 rows=0 loops=1)

24. 0.001 0.001 ↑ 1.0 3 1

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

25. 0.000 0.003 ↓ 0.0 0 3

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 time=0.001..0.001 rows=0 loops=3)

  • Recheck Cond: (knowledge_id = ck_id_3.id)
26. 0.003 0.003 ↓ 0.0 0 3

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

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

CTE KQ_CAR_ANNUAL_OPTION_BUDGET

28. 0.001 0.025 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.024..0.025 rows=0 loops=1)

  • Group Key: "KQ_CAR_ANNUAL_OPTION_BUDGET_1".knowledge_id
29. 0.004 0.024 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.024..0.024 rows=0 loops=1)

  • Sort Key: "KQ_CAR_ANNUAL_OPTION_BUDGET_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
30. 0.003 0.020 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.020..0.020 rows=0 loops=1)

31. 0.002 0.002 ↑ 1.0 3 1

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

32. 0.000 0.015 ↓ 0.0 0 3

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 time=0.005..0.005 rows=0 loops=3)

  • Recheck Cond: (knowledge_id = ck_id_4.id)
33. 0.015 0.015 ↓ 0.0 0 3

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

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

CTE KQ_JOB_CATEGORY

35. 0.000 0.010 ↓ 0.0 0 1

GroupAggregate (cost=35.62..36.47 rows=34 width=36) (actual time=0.010..0.010 rows=0 loops=1)

  • Group Key: "KQ_JOB_CATEGORY_1".knowledge_id
36. 0.004 0.010 ↓ 0.0 0 1

Sort (cost=35.62..35.70 rows=34 width=8) (actual time=0.010..0.010 rows=0 loops=1)

  • Sort Key: "KQ_JOB_CATEGORY_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
37. 0.003 0.006 ↓ 0.0 0 1

Nested Loop (cost=2.91..34.75 rows=34 width=8) (actual time=0.006..0.006 rows=0 loops=1)

38. 0.000 0.000 ↑ 1.0 3 1

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

39. 0.000 0.003 ↓ 0.0 0 3

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

  • Recheck Cond: (knowledge_id = ck_id_5.id)
40. 0.003 0.003 ↓ 0.0 0 3

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

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

CTE KQ_CUST_USE_OPTION

42. 0.000 0.034 ↓ 0.0 0 1

GroupAggregate (cost=2.40..2.48 rows=3 width=36) (actual time=0.034..0.034 rows=0 loops=1)

  • Group Key: "KQ_CUST_USE_OPTION_1".knowledge_id
43. 0.003 0.034 ↓ 0.0 0 1

Sort (cost=2.40..2.41 rows=3 width=8) (actual time=0.034..0.034 rows=0 loops=1)

  • Sort Key: "KQ_CUST_USE_OPTION_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
44. 0.020 0.031 ↓ 0.0 0 1

Hash Join (cost=0.10..2.38 rows=3 width=8) (actual time=0.031..0.031 rows=0 loops=1)

  • Hash Cond: ("KQ_CUST_USE_OPTION_1".knowledge_id = ck_id_6.id)
45. 0.008 0.008 ↑ 1.0 91 1

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

46. 0.002 0.003 ↑ 1.0 3 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
47. 0.001 0.001 ↑ 1.0 3 1

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

48.          

CTE KQ_RE_AVERAGE_TIME_ACTION

49. 0.001 0.063 ↓ 0.0 0 1

GroupAggregate (cost=7.60..7.67 rows=3 width=36) (actual time=0.063..0.063 rows=0 loops=1)

  • Group Key: "KQ_RE_AVERAGE_TIME_ACTION_1".knowledge_id
50. 0.003 0.062 ↓ 0.0 0 1

Sort (cost=7.60..7.60 rows=3 width=8) (actual time=0.062..0.062 rows=0 loops=1)

  • Sort Key: "KQ_RE_AVERAGE_TIME_ACTION_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
51. 0.031 0.059 ↓ 0.0 0 1

Hash Join (cost=0.10..7.57 rows=3 width=8) (actual time=0.059..0.059 rows=0 loops=1)

  • Hash Cond: ("KQ_RE_AVERAGE_TIME_ACTION_1".knowledge_id = ck_id_7.id)
52. 0.025 0.025 ↑ 1.0 396 1

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

53. 0.002 0.003 ↑ 1.0 3 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
54. 0.001 0.001 ↑ 1.0 3 1

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

55.          

CTE KQ_RE_OPTION_PERCENT

56. 0.000 0.022 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.022..0.022 rows=0 loops=1)

  • Group Key: "KQ_RE_OPTION_PERCENT_1".knowledge_id
57. 0.003 0.022 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.022..0.022 rows=0 loops=1)

  • Sort Key: "KQ_RE_OPTION_PERCENT_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
58. 0.015 0.019 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.019..0.019 rows=0 loops=1)

59. 0.001 0.001 ↑ 1.0 3 1

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

60. 0.000 0.003 ↓ 0.0 0 3

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

  • Recheck Cond: (knowledge_id = ck_id_8.id)
61. 0.003 0.003 ↓ 0.0 0 3

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

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

CTE KQ_CAR_USE_SOFTWARE

63. 0.000 0.033 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.033..0.033 rows=0 loops=1)

  • Group Key: "KQ_CAR_USE_SOFTWARE_1".knowledge_id
64. 0.013 0.033 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.033..0.033 rows=0 loops=1)

  • Sort Key: "KQ_CAR_USE_SOFTWARE_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
65. 0.004 0.020 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.020..0.020 rows=0 loops=1)

66. 0.001 0.001 ↑ 1.0 3 1

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

67. 0.000 0.015 ↓ 0.0 0 3

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

  • Recheck Cond: (knowledge_id = ck_id_9.id)
68. 0.015 0.015 ↓ 0.0 0 3

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

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

CTE KQ_CAR_STOCK

70. 0.001 0.011 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.011..0.011 rows=0 loops=1)

  • Group Key: "KQ_CAR_STOCK_1".knowledge_id
71. 0.004 0.010 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.010..0.010 rows=0 loops=1)

  • Sort Key: "KQ_CAR_STOCK_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
72. 0.002 0.006 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.006..0.006 rows=0 loops=1)

73. 0.001 0.001 ↑ 1.0 3 1

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

74. 0.000 0.003 ↓ 0.0 0 3

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

  • Recheck Cond: (knowledge_id = ck_id_10.id)
75. 0.003 0.003 ↓ 0.0 0 3

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

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

CTE KQ_RE_LBC_ADSERVING_MODE_NEW_SALES

77. 0.000 0.009 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.009..0.009 rows=0 loops=1)

  • Group Key: "KQ_RE_LBC_ADSERVING_MODE_NEW_SALES_1".knowledge_id
78. 0.003 0.009 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.009..0.009 rows=0 loops=1)

  • Sort Key: "KQ_RE_LBC_ADSERVING_MODE_NEW_SALES_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
79. 0.003 0.006 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.006..0.006 rows=0 loops=1)

80. 0.000 0.000 ↑ 1.0 3 1

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

81. 0.000 0.003 ↓ 0.0 0 3

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 time=0.001..0.001 rows=0 loops=3)

  • Recheck Cond: (knowledge_id = ck_id_11.id)
82. 0.003 0.003 ↓ 0.0 0 3

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 time=0.001..0.001 rows=0 loops=3)

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

CTE KQ_RE_ADSERVING_SUPPORT_NEW_SALES

84. 0.001 0.024 ↓ 0.0 0 1

GroupAggregate (cost=1.96..2.06 rows=4 width=36) (actual time=0.024..0.024 rows=0 loops=1)

  • Group Key: "KQ_RE_ADSERVING_SUPPORT_NEW_SALES_1".knowledge_id
85. 0.003 0.023 ↓ 0.0 0 1

Sort (cost=1.96..1.97 rows=4 width=8) (actual time=0.023..0.023 rows=0 loops=1)

  • Sort Key: "KQ_RE_ADSERVING_SUPPORT_NEW_SALES_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
86. 0.013 0.020 ↓ 0.0 0 1

Hash Join (cost=0.10..1.92 rows=4 width=8) (actual time=0.020..0.020 rows=0 loops=1)

  • Hash Cond: ("KQ_RE_ADSERVING_SUPPORT_NEW_SALES_1".knowledge_id = ck_id_12.id)
87. 0.005 0.005 ↑ 1.0 57 1

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 time=0.002..0.005 rows=57 loops=1)

88. 0.001 0.002 ↑ 1.0 3 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
89. 0.001 0.001 ↑ 1.0 3 1

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

90.          

CTE KQ_CAR_DEALERSHIP_MODE

91. 0.001 0.012 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.012..0.012 rows=0 loops=1)

  • Group Key: "KQ_CAR_DEALERSHIP_MODE_1".knowledge_id
92. 0.004 0.011 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.011..0.011 rows=0 loops=1)

  • Sort Key: "KQ_CAR_DEALERSHIP_MODE_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
93. 0.003 0.007 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.007..0.007 rows=0 loops=1)

94. 0.001 0.001 ↑ 1.0 3 1

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

95. 0.000 0.003 ↓ 0.0 0 3

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

  • Recheck Cond: (knowledge_id = ck_id_13.id)
96. 0.003 0.003 ↓ 0.0 0 3

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

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

CTE KQ_JOB_CAREER_PAGE

98. 0.000 0.008 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.008..0.008 rows=0 loops=1)

  • Group Key: "KQ_JOB_CAREER_PAGE_1".knowledge_id
99. 0.001 0.008 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.008..0.008 rows=0 loops=1)

  • Sort Key: "KQ_JOB_CAREER_PAGE_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
100. 0.003 0.007 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.007..0.007 rows=0 loops=1)

101. 0.001 0.001 ↑ 1.0 3 1

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

102. 0.000 0.003 ↓ 0.0 0 3

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

  • Recheck Cond: (knowledge_id = ck_id_14.id)
103. 0.003 0.003 ↓ 0.0 0 3

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

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

CTE KQ_JOB_MANAGEMENT

105. 0.001 0.045 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.045..0.045 rows=0 loops=1)

  • Group Key: "KQ_JOB_MANAGEMENT_1".knowledge_id
106. 0.022 0.044 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.044..0.044 rows=0 loops=1)

  • Sort Key: "KQ_JOB_MANAGEMENT_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
107. 0.018 0.022 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.022..0.022 rows=0 loops=1)

108. 0.001 0.001 ↑ 1.0 3 1

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

109. 0.000 0.003 ↓ 0.0 0 3

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

  • Recheck Cond: (knowledge_id = ck_id_15.id)
110. 0.003 0.003 ↓ 0.0 0 3

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

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

CTE KQ_CAR_ADSERVING_SUPPORT

112. 0.000 0.012 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.012..0.012 rows=0 loops=1)

  • Group Key: "KQ_CAR_ADSERVING_SUPPORT_1".knowledge_id
113. 0.004 0.012 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.012..0.012 rows=0 loops=1)

  • Sort Key: "KQ_CAR_ADSERVING_SUPPORT_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
114. 0.005 0.008 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.008..0.008 rows=0 loops=1)

115. 0.000 0.000 ↑ 1.0 3 1

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

116. 0.000 0.003 ↓ 0.0 0 3

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

  • Recheck Cond: (knowledge_id = ck_id_16.id)
117. 0.003 0.003 ↓ 0.0 0 3

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

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

CTE KQ_JOB_ANNUAL_NEED

119. 0.051 0.114 ↑ 12.0 2 1

GroupAggregate (cost=89.19..89.79 rows=24 width=36) (actual time=0.105..0.114 rows=2 loops=1)

  • Group Key: "KQ_JOB_ANNUAL_NEED_1".knowledge_id
120. 0.010 0.063 ↑ 1.0 24 1

Sort (cost=89.19..89.25 rows=24 width=8) (actual time=0.061..0.063 rows=24 loops=1)

  • Sort Key: "KQ_JOB_ANNUAL_NEED_1".knowledge_id
  • Sort Method: quicksort Memory: 26kB
121. 0.025 0.053 ↑ 1.0 24 1

Nested Loop (cost=4.35..88.64 rows=24 width=8) (actual time=0.024..0.053 rows=24 loops=1)

122. 0.016 0.016 ↑ 1.0 3 1

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

123. 0.003 0.012 ↑ 1.0 8 3

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

  • Recheck Cond: (knowledge_id = ck_id_17.id)
  • Heap Blocks: exact=2
124. 0.009 0.009 ↑ 1.0 8 3

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

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

CTE KQ_RE_RANGE

126. 0.001 0.027 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.027..0.027 rows=0 loops=1)

  • Group Key: "KQ_RE_RANGE_1".knowledge_id
127. 0.004 0.026 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.026..0.026 rows=0 loops=1)

  • Sort Key: "KQ_RE_RANGE_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
128. 0.003 0.022 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.022..0.022 rows=0 loops=1)

129. 0.001 0.001 ↑ 1.0 3 1

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

130. 0.000 0.018 ↓ 0.0 0 3

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

  • Recheck Cond: (knowledge_id = ck_id_18.id)
131. 0.018 0.018 ↓ 0.0 0 3

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

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

CTE KQ_ADV_GOALS

133. 0.000 0.012 ↓ 0.0 0 1

GroupAggregate (cost=25.01..25.08 rows=3 width=36) (actual time=0.012..0.012 rows=0 loops=1)

  • Group Key: "KQ_ADV_GOALS_1".knowledge_id
134. 0.003 0.012 ↓ 0.0 0 1

Sort (cost=25.01..25.01 rows=3 width=8) (actual time=0.012..0.012 rows=0 loops=1)

  • Sort Key: "KQ_ADV_GOALS_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
135. 0.003 0.009 ↓ 0.0 0 1

Nested Loop (cost=0.28..24.98 rows=3 width=8) (actual time=0.009..0.009 rows=0 loops=1)

136. 0.000 0.000 ↑ 1.0 3 1

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

137. 0.006 0.006 ↓ 0.0 0 3

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 time=0.002..0.002 rows=0 loops=3)

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

CTE KQ_ADV_COMMUNICATION_RADIUS

139. 0.000 0.030 ↓ 0.0 0 1

GroupAggregate (cost=25.00..25.07 rows=3 width=36) (actual time=0.030..0.030 rows=0 loops=1)

  • Group Key: "KQ_ADV_COMMUNICATION_RADIUS_1".knowledge_id
140. 0.003 0.030 ↓ 0.0 0 1

Sort (cost=25.00..25.01 rows=3 width=8) (actual time=0.030..0.030 rows=0 loops=1)

  • Sort Key: "KQ_ADV_COMMUNICATION_RADIUS_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
141. 0.003 0.027 ↓ 0.0 0 1

Nested Loop (cost=0.28..24.98 rows=3 width=8) (actual time=0.027..0.027 rows=0 loops=1)

142. 0.000 0.000 ↑ 1.0 3 1

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

143. 0.024 0.024 ↓ 0.0 0 3

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 time=0.008..0.008 rows=0 loops=3)

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

CTE KQ_RE_HOLIDAY_RENTAL

145. 0.000 0.011 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.011..0.011 rows=0 loops=1)

  • Group Key: "KQ_RE_HOLIDAY_RENTAL_1".knowledge_id
146. 0.004 0.011 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.011..0.011 rows=0 loops=1)

  • Sort Key: "KQ_RE_HOLIDAY_RENTAL_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
147. 0.003 0.007 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.007..0.007 rows=0 loops=1)

148. 0.001 0.001 ↑ 1.0 3 1

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

149. 0.000 0.003 ↓ 0.0 0 3

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

  • Recheck Cond: (knowledge_id = ck_id_21.id)
150. 0.003 0.003 ↓ 0.0 0 3

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

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

CTE KQ_JOB_SOFTWARE_LEC_LIST

152. 0.001 0.026 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.026..0.026 rows=0 loops=1)

  • Group Key: "KQ_JOB_SOFTWARE_LEC_LIST_1".knowledge_id
153. 0.019 0.025 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.025..0.025 rows=0 loops=1)

  • Sort Key: "KQ_JOB_SOFTWARE_LEC_LIST_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
154. 0.003 0.006 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.006..0.006 rows=0 loops=1)

155. 0.000 0.000 ↑ 1.0 3 1

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

156. 0.000 0.003 ↓ 0.0 0 3

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 time=0.001..0.001 rows=0 loops=3)

  • Recheck Cond: (knowledge_id = ck_id_22.id)
157. 0.003 0.003 ↓ 0.0 0 3

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

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

CTE KQ_CUST_EMPLOYEES_RANGE

159. 0.008 0.025 ↑ 3.0 1 1

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

  • Group Key: "KQ_CUST_EMPLOYEES_RANGE_1".knowledge_id
160. 0.005 0.017 ↑ 3.0 1 1

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

  • Sort Key: "KQ_CUST_EMPLOYEES_RANGE_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
161. 0.002 0.012 ↑ 3.0 1 1

Nested Loop (cost=0.29..25.00 rows=3 width=8) (actual time=0.008..0.012 rows=1 loops=1)

162. 0.001 0.001 ↑ 1.0 3 1

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

163. 0.009 0.009 ↓ 0.0 0 3

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 time=0.003..0.003 rows=0 loops=3)

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

CTE KQ_CAR_SOFTWARE_LIST

165. 0.001 0.026 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.026..0.026 rows=0 loops=1)

  • Group Key: "KQ_CAR_SOFTWARE_LIST_1".knowledge_id
166. 0.018 0.025 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.025..0.025 rows=0 loops=1)

  • Sort Key: "KQ_CAR_SOFTWARE_LIST_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
167. 0.004 0.007 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.007..0.007 rows=0 loops=1)

168. 0.000 0.000 ↑ 1.0 3 1

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

169. 0.000 0.003 ↓ 0.0 0 3

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

  • Recheck Cond: (knowledge_id = ck_id_24.id)
170. 0.003 0.003 ↓ 0.0 0 3

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

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

CTE KQ_CAR_OPTION_PERCENT

172. 0.000 0.009 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.009..0.009 rows=0 loops=1)

  • Group Key: "KQ_CAR_OPTION_PERCENT_1".knowledge_id
173. 0.003 0.009 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.009..0.009 rows=0 loops=1)

  • Sort Key: "KQ_CAR_OPTION_PERCENT_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
174. 0.003 0.006 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.006..0.006 rows=0 loops=1)

175. 0.000 0.000 ↑ 1.0 3 1

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

176. 0.000 0.003 ↓ 0.0 0 3

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

  • Recheck Cond: (knowledge_id = ck_id_25.id)
177. 0.003 0.003 ↓ 0.0 0 3

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

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

CTE KQ_ADV_GENDER

179. 0.009 0.028 ↓ 0.0 0 1

GroupAggregate (cost=25.01..25.08 rows=3 width=36) (actual time=0.028..0.028 rows=0 loops=1)

  • Group Key: "KQ_ADV_GENDER_1".knowledge_id
180. 0.002 0.019 ↓ 0.0 0 1

Sort (cost=25.01..25.01 rows=3 width=8) (actual time=0.019..0.019 rows=0 loops=1)

  • Sort Key: "KQ_ADV_GENDER_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
181. 0.002 0.017 ↓ 0.0 0 1

Nested Loop (cost=0.28..24.98 rows=3 width=8) (actual time=0.017..0.017 rows=0 loops=1)

182. 0.000 0.000 ↑ 1.0 3 1

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

183. 0.015 0.015 ↓ 0.0 0 3

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 time=0.005..0.005 rows=0 loops=3)

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

CTE KQ_ADV_GOALS2

185. 0.000 0.089 ↓ 0.0 0 1

GroupAggregate (cost=10.88..10.95 rows=3 width=36) (actual time=0.089..0.089 rows=0 loops=1)

  • Group Key: "KQ_ADV_GOALS2_1".knowledge_id
186. 0.006 0.089 ↓ 0.0 0 1

Sort (cost=10.88..10.89 rows=3 width=8) (actual time=0.089..0.089 rows=0 loops=1)

  • Sort Key: "KQ_ADV_GOALS2_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
187. 0.045 0.083 ↓ 0.0 0 1

Hash Join (cost=0.10..10.86 rows=3 width=8) (actual time=0.083..0.083 rows=0 loops=1)

  • Hash Cond: ("KQ_ADV_GOALS2_1".knowledge_id = ck_id_27.id)
188. 0.033 0.033 ↑ 1.0 562 1

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

189. 0.004 0.005 ↑ 1.0 3 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
190. 0.001 0.001 ↑ 1.0 3 1

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

191.          

CTE KQ_RE_ANNUAL_OPTION_BUDGET

192. 0.001 0.012 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.012..0.012 rows=0 loops=1)

  • Group Key: "KQ_RE_ANNUAL_OPTION_BUDGET_1".knowledge_id
193. 0.004 0.011 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.011..0.011 rows=0 loops=1)

  • Sort Key: "KQ_RE_ANNUAL_OPTION_BUDGET_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
194. 0.003 0.007 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.007..0.007 rows=0 loops=1)

195. 0.001 0.001 ↑ 1.0 3 1

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

196. 0.000 0.003 ↓ 0.0 0 3

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 time=0.001..0.001 rows=0 loops=3)

  • Recheck Cond: (knowledge_id = ck_id_28.id)
197. 0.003 0.003 ↓ 0.0 0 3

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

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

CTE KQ_CUST_CREDITCARD_USE

199. 0.000 0.009 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.009..0.009 rows=0 loops=1)

  • Group Key: "KQ_CUST_CREDITCARD_USE_1".knowledge_id
200. 0.003 0.009 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.009..0.009 rows=0 loops=1)

  • Sort Key: "KQ_CUST_CREDITCARD_USE_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
201. 0.003 0.006 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.006..0.006 rows=0 loops=1)

202. 0.000 0.000 ↑ 1.0 3 1

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

203. 0.000 0.003 ↓ 0.0 0 3

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

  • Recheck Cond: (knowledge_id = ck_id_29.id)
204. 0.003 0.003 ↓ 0.0 0 3

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

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

CTE KQ_JOB_CONTRACT

206. 0.000 0.011 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.011..0.011 rows=0 loops=1)

  • Group Key: "KQ_JOB_CONTRACT_1".knowledge_id
207. 0.004 0.011 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.011..0.011 rows=0 loops=1)

  • Sort Key: "KQ_JOB_CONTRACT_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
208. 0.004 0.007 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.007..0.007 rows=0 loops=1)

209. 0.000 0.000 ↑ 1.0 3 1

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

210. 0.000 0.003 ↓ 0.0 0 3

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

  • Recheck Cond: (knowledge_id = ck_id_30.id)
211. 0.003 0.003 ↓ 0.0 0 3

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

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

CTE KQ_RE_ACTIVITIES

213. 0.001 0.084 ↓ 0.0 0 1

GroupAggregate (cost=10.59..10.67 rows=3 width=36) (actual time=0.083..0.084 rows=0 loops=1)

  • Group Key: "KQ_RE_ACTIVITIES_1".knowledge_id
214. 0.004 0.083 ↓ 0.0 0 1

Sort (cost=10.59..10.60 rows=3 width=8) (actual time=0.083..0.083 rows=0 loops=1)

  • Sort Key: "KQ_RE_ACTIVITIES_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
215. 0.043 0.079 ↓ 0.0 0 1

Hash Join (cost=0.10..10.57 rows=3 width=8) (actual time=0.079..0.079 rows=0 loops=1)

  • Hash Cond: ("KQ_RE_ACTIVITIES_1".knowledge_id = ck_id_31.id)
216. 0.034 0.034 ↑ 1.0 541 1

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

217. 0.001 0.002 ↑ 1.0 3 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
218. 0.001 0.001 ↑ 1.0 3 1

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

219.          

CTE KQ_RE_LBC_ADSERVING_MODE_HOLY_RENTAL

220. 0.000 0.009 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.009..0.009 rows=0 loops=1)

  • Group Key: "KQ_RE_LBC_ADSERVING_MODE_HOLY_RENTAL_1".knowledge_id
221. 0.003 0.009 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.009..0.009 rows=0 loops=1)

  • Sort Key: "KQ_RE_LBC_ADSERVING_MODE_HOLY_RENTAL_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
222. 0.003 0.006 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.006..0.006 rows=0 loops=1)

223. 0.000 0.000 ↑ 1.0 3 1

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

224. 0.000 0.003 ↓ 0.0 0 3

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 time=0.001..0.001 rows=0 loops=3)

  • Recheck Cond: (knowledge_id = ck_id_32.id)
225. 0.003 0.003 ↓ 0.0 0 3

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 time=0.001..0.001 rows=0 loops=3)

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

CTE KQ_RE_FLOW_TYPE

227. 0.000 0.071 ↓ 0.0 0 1

GroupAggregate (cost=7.58..7.66 rows=3 width=36) (actual time=0.071..0.071 rows=0 loops=1)

  • Group Key: "KQ_RE_FLOW_TYPE_1".knowledge_id
228. 0.005 0.071 ↓ 0.0 0 1

Sort (cost=7.58..7.59 rows=3 width=8) (actual time=0.071..0.071 rows=0 loops=1)

  • Sort Key: "KQ_RE_FLOW_TYPE_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
229. 0.034 0.066 ↓ 0.0 0 1

Hash Join (cost=0.10..7.56 rows=3 width=8) (actual time=0.066..0.066 rows=0 loops=1)

  • Hash Cond: ("KQ_RE_FLOW_TYPE_1".knowledge_id = ck_id_33.id)
230. 0.029 0.029 ↑ 1.0 395 1

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

231. 0.002 0.003 ↑ 1.0 3 1

Hash (cost=0.06..0.06 rows=3 width=4) (actual time=0.002..0.003 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
232. 0.001 0.001 ↑ 1.0 3 1

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

233.          

CTE KQ_ADV_AGE_RANGE

234. 0.000 0.014 ↓ 0.0 0 1

GroupAggregate (cost=25.01..25.08 rows=3 width=36) (actual time=0.014..0.014 rows=0 loops=1)

  • Group Key: "KQ_ADV_AGE_RANGE_1".knowledge_id
235. 0.005 0.014 ↓ 0.0 0 1

Sort (cost=25.01..25.01 rows=3 width=8) (actual time=0.013..0.014 rows=0 loops=1)

  • Sort Key: "KQ_ADV_AGE_RANGE_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
236. 0.003 0.009 ↓ 0.0 0 1

Nested Loop (cost=0.28..24.98 rows=3 width=8) (actual time=0.009..0.009 rows=0 loops=1)

237. 0.000 0.000 ↑ 1.0 3 1

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

238. 0.006 0.006 ↓ 0.0 0 3

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 time=0.002..0.002 rows=0 loops=3)

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

CTE KQ_CAR_CONSULT_STAT

240. 0.001 0.011 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.011..0.011 rows=0 loops=1)

  • Group Key: "KQ_CAR_CONSULT_STAT_1".knowledge_id
241. 0.004 0.010 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.010..0.010 rows=0 loops=1)

  • Sort Key: "KQ_CAR_CONSULT_STAT_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
242. 0.003 0.006 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.006..0.006 rows=0 loops=1)

243. 0.000 0.000 ↑ 1.0 3 1

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

244. 0.000 0.003 ↓ 0.0 0 3

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

  • Recheck Cond: (knowledge_id = ck_id_35.id)
245. 0.003 0.003 ↓ 0.0 0 3

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

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

CTE KQ_CUST_RUBRIQUE

247. 0.001 0.014 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.013..0.014 rows=0 loops=1)

  • Group Key: "KQ_CUST_RUBRIQUE_1".knowledge_id
248. 0.006 0.013 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.013..0.013 rows=0 loops=1)

  • Sort Key: "KQ_CUST_RUBRIQUE_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
249. 0.004 0.007 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.007..0.007 rows=0 loops=1)

250. 0.000 0.000 ↑ 1.0 3 1

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

251. 0.000 0.003 ↓ 0.0 0 3

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

  • Recheck Cond: (knowledge_id = ck_id_36.id)
252. 0.003 0.003 ↓ 0.0 0 3

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

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

CTE KQ_ADV_GOALS3

254. 0.001 0.034 ↓ 0.0 0 1

GroupAggregate (cost=2.31..2.38 rows=3 width=36) (actual time=0.034..0.034 rows=0 loops=1)

  • Group Key: "KQ_ADV_GOALS3_1".knowledge_id
255. 0.003 0.033 ↓ 0.0 0 1

Sort (cost=2.31..2.31 rows=3 width=8) (actual time=0.033..0.033 rows=0 loops=1)

  • Sort Key: "KQ_ADV_GOALS3_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
256. 0.016 0.030 ↓ 0.0 0 1

Hash Join (cost=0.10..2.28 rows=3 width=8) (actual time=0.030..0.030 rows=0 loops=1)

  • Hash Cond: ("KQ_ADV_GOALS3_1".knowledge_id = ck_id_37.id)
257. 0.012 0.012 ↑ 1.0 84 1

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

258. 0.001 0.002 ↑ 1.0 3 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
259. 0.001 0.001 ↑ 1.0 3 1

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

260.          

CTE KQ_ADV_CAMPAIGN_DURATION

261. 0.000 0.042 ↓ 0.0 0 1

GroupAggregate (cost=25.01..25.08 rows=3 width=36) (actual time=0.042..0.042 rows=0 loops=1)

  • Group Key: "KQ_ADV_CAMPAIGN_DURATION_1".knowledge_id
262. 0.003 0.042 ↓ 0.0 0 1

Sort (cost=25.01..25.01 rows=3 width=8) (actual time=0.042..0.042 rows=0 loops=1)

  • Sort Key: "KQ_ADV_CAMPAIGN_DURATION_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
263. 0.003 0.039 ↓ 0.0 0 1

Nested Loop (cost=0.28..24.98 rows=3 width=8) (actual time=0.039..0.039 rows=0 loops=1)

264. 0.000 0.000 ↑ 1.0 3 1

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

265. 0.036 0.036 ↓ 0.0 0 3

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 time=0.012..0.012 rows=0 loops=3)

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

CTE KQ_RE_OPTION_TYPE

267. 0.000 0.010 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.010..0.010 rows=0 loops=1)

  • Group Key: "KQ_RE_OPTION_TYPE_1".knowledge_id
268. 0.004 0.010 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.010..0.010 rows=0 loops=1)

  • Sort Key: "KQ_RE_OPTION_TYPE_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
269. 0.003 0.006 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.006..0.006 rows=0 loops=1)

270. 0.000 0.000 ↑ 1.0 3 1

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

271. 0.000 0.003 ↓ 0.0 0 3

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

  • Recheck Cond: (knowledge_id = ck_id_39.id)
272. 0.003 0.003 ↓ 0.0 0 3

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

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

CTE KQ_JOB_ANNUAL_VACANCIES_RANGE

274. 0.000 0.010 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.010..0.010 rows=0 loops=1)

  • Group Key: "KQ_JOB_ANNUAL_VACANCIES_RANGE_1".knowledge_id
275. 0.003 0.010 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.009..0.010 rows=0 loops=1)

  • Sort Key: "KQ_JOB_ANNUAL_VACANCIES_RANGE_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
276. 0.004 0.007 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.006..0.007 rows=0 loops=1)

277. 0.000 0.000 ↑ 1.0 3 1

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

278. 0.003 0.003 ↓ 0.0 0 3

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 time=0.001..0.001 rows=0 loops=3)

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

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

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

CTE KQ_RE_MONTHLY_BUDGET

281. 0.000 0.010 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.010..0.010 rows=0 loops=1)

  • Group Key: "KQ_RE_MONTHLY_BUDGET_1".knowledge_id
282. 0.004 0.010 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.010..0.010 rows=0 loops=1)

  • Sort Key: "KQ_RE_MONTHLY_BUDGET_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
283. 0.003 0.006 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.006..0.006 rows=0 loops=1)

284. 0.000 0.000 ↑ 1.0 3 1

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

285. 0.000 0.003 ↓ 0.0 0 3

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

  • Recheck Cond: (knowledge_id = ck_id_41.id)
286. 0.003 0.003 ↓ 0.0 0 3

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

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

CTE KQ_CAR_LBC_ADSERVING_MODE

288. 0.000 0.013 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.013..0.013 rows=0 loops=1)

  • Group Key: "KQ_CAR_LBC_ADSERVING_MODE_1".knowledge_id
289. 0.004 0.013 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.013..0.013 rows=0 loops=1)

  • Sort Key: "KQ_CAR_LBC_ADSERVING_MODE_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
290. 0.005 0.009 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.009..0.009 rows=0 loops=1)

291. 0.001 0.001 ↑ 1.0 3 1

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

292. 0.000 0.003 ↓ 0.0 0 3

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 time=0.001..0.001 rows=0 loops=3)

  • Recheck Cond: (knowledge_id = ck_id_42.id)
293. 0.003 0.003 ↓ 0.0 0 3

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

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

CTE KQ_RE_ADSERVING_SUPPORT_RENTAL

295. 0.001 0.056 ↓ 0.0 0 1

GroupAggregate (cost=3.12..3.30 rows=7 width=36) (actual time=0.056..0.056 rows=0 loops=1)

  • Group Key: "KQ_RE_ADSERVING_SUPPORT_RENTAL_1".knowledge_id
296. 0.004 0.055 ↓ 0.0 0 1

Sort (cost=3.12..3.14 rows=7 width=8) (actual time=0.055..0.055 rows=0 loops=1)

  • Sort Key: "KQ_RE_ADSERVING_SUPPORT_RENTAL_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
297. 0.015 0.051 ↓ 0.0 0 1

Hash Join (cost=0.10..3.02 rows=7 width=8) (actual time=0.051..0.051 rows=0 loops=1)

  • Hash Cond: ("KQ_RE_ADSERVING_SUPPORT_RENTAL_1".knowledge_id = ck_id_43.id)
298. 0.034 0.034 ↑ 1.0 135 1

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

299. 0.001 0.002 ↑ 1.0 3 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
300. 0.001 0.001 ↑ 1.0 3 1

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

301.          

CTE KQ_RE_NS_AREA

302. 0.000 0.024 ↓ 0.0 0 1

GroupAggregate (cost=1.87..1.94 rows=3 width=36) (actual time=0.024..0.024 rows=0 loops=1)

  • Group Key: "KQ_RE_NS_AREA_1".knowledge_id
303. 0.004 0.024 ↓ 0.0 0 1

Sort (cost=1.87..1.87 rows=3 width=8) (actual time=0.024..0.024 rows=0 loops=1)

  • Sort Key: "KQ_RE_NS_AREA_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
304. 0.012 0.020 ↓ 0.0 0 1

Hash Join (cost=0.10..1.84 rows=3 width=8) (actual time=0.020..0.020 rows=0 loops=1)

  • Hash Cond: ("KQ_RE_NS_AREA_1".knowledge_id = ck_id_44.id)
305. 0.006 0.006 ↑ 1.0 52 1

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

306. 0.001 0.002 ↑ 1.0 3 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
307. 0.001 0.001 ↑ 1.0 3 1

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

308.          

CTE KQ_ADV_TARGETING

309. 0.001 0.011 ↓ 0.0 0 1

GroupAggregate (cost=25.01..25.08 rows=3 width=36) (actual time=0.011..0.011 rows=0 loops=1)

  • Group Key: "KQ_ADV_TARGETING_1".knowledge_id
310. 0.002 0.010 ↓ 0.0 0 1

Sort (cost=25.01..25.01 rows=3 width=8) (actual time=0.010..0.010 rows=0 loops=1)

  • Sort Key: "KQ_ADV_TARGETING_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
311. 0.002 0.008 ↓ 0.0 0 1

Nested Loop (cost=0.28..24.98 rows=3 width=8) (actual time=0.008..0.008 rows=0 loops=1)

312. 0.000 0.000 ↑ 1.0 3 1

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

313. 0.006 0.006 ↓ 0.0 0 3

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 time=0.002..0.002 rows=0 loops=3)

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

CTE KQ_ADV_USE_COMMUNICATION_AGENCY

315. 0.001 0.012 ↓ 0.0 0 1

GroupAggregate (cost=25.01..25.08 rows=3 width=36) (actual time=0.012..0.012 rows=0 loops=1)

  • Group Key: "KQ_ADV_USE_COMMUNICATION_AGENCY_1".knowledge_id
316. 0.003 0.011 ↓ 0.0 0 1

Sort (cost=25.01..25.01 rows=3 width=8) (actual time=0.011..0.011 rows=0 loops=1)

  • Sort Key: "KQ_ADV_USE_COMMUNICATION_AGENCY_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
317. 0.002 0.008 ↓ 0.0 0 1

Nested Loop (cost=0.28..24.98 rows=3 width=8) (actual time=0.008..0.008 rows=0 loops=1)

318. 0.000 0.000 ↑ 1.0 3 1

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

319. 0.006 0.006 ↓ 0.0 0 3

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 time=0.002..0.002 rows=0 loops=3)

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

CTE KQ_RE_REASON_ADS_HOLY_RENTAL

321. 0.001 0.010 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.010..0.010 rows=0 loops=1)

  • Group Key: "KQ_RE_REASON_ADS_HOLY_RENTAL_1".knowledge_id
322. 0.003 0.009 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.009..0.009 rows=0 loops=1)

  • Sort Key: "KQ_RE_REASON_ADS_HOLY_RENTAL_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
323. 0.003 0.006 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.006..0.006 rows=0 loops=1)

324. 0.000 0.000 ↑ 1.0 3 1

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

325. 0.000 0.003 ↓ 0.0 0 3

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 time=0.001..0.001 rows=0 loops=3)

  • Recheck Cond: (knowledge_id = ck_id_47.id)
326. 0.003 0.003 ↓ 0.0 0 3

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

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

CTE KQ_RE_NS_ANNUAL_PREMARKET

328. 0.001 0.011 ↓ 0.0 0 1

GroupAggregate (cost=35.62..36.47 rows=34 width=36) (actual time=0.011..0.011 rows=0 loops=1)

  • Group Key: "KQ_RE_NS_ANNUAL_PREMARKET_1".knowledge_id
329. 0.003 0.010 ↓ 0.0 0 1

Sort (cost=35.62..35.70 rows=34 width=8) (actual time=0.010..0.010 rows=0 loops=1)

  • Sort Key: "KQ_RE_NS_ANNUAL_PREMARKET_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
330. 0.004 0.007 ↓ 0.0 0 1

Nested Loop (cost=2.91..34.75 rows=34 width=8) (actual time=0.007..0.007 rows=0 loops=1)

331. 0.000 0.000 ↑ 1.0 3 1

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

332. 0.000 0.003 ↓ 0.0 0 3

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 time=0.001..0.001 rows=0 loops=3)

  • Recheck Cond: (knowledge_id = ck_id_48.id)
333. 0.003 0.003 ↓ 0.0 0 3

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

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

CTE KQ_CUST_LBC_MONTH_RANGE_AD

335. 0.000 0.030 ↓ 0.0 0 1

GroupAggregate (cost=3.10..3.18 rows=3 width=36) (actual time=0.030..0.030 rows=0 loops=1)

  • Group Key: "KQ_CUST_LBC_MONTH_RANGE_AD_1".knowledge_id
336. 0.004 0.030 ↓ 0.0 0 1

Sort (cost=3.10..3.11 rows=3 width=8) (actual time=0.030..0.030 rows=0 loops=1)

  • Sort Key: "KQ_CUST_LBC_MONTH_RANGE_AD_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
337. 0.014 0.026 ↓ 0.0 0 1

Hash Join (cost=0.10..3.08 rows=3 width=8) (actual time=0.026..0.026 rows=0 loops=1)

  • Hash Cond: ("KQ_CUST_LBC_MONTH_RANGE_AD_1".knowledge_id = ck_id_49.id)
338. 0.010 0.010 ↑ 1.0 142 1

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 time=0.004..0.010 rows=142 loops=1)

339. 0.001 0.002 ↑ 1.0 3 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
340. 0.001 0.001 ↑ 1.0 3 1

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

341.          

CTE KQ_CUST_LBC_CATEGORY

342. 0.001 0.010 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.010..0.010 rows=0 loops=1)

  • Group Key: "KQ_CUST_LBC_CATEGORY_1".knowledge_id
343. 0.002 0.009 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.009..0.009 rows=0 loops=1)

  • Sort Key: "KQ_CUST_LBC_CATEGORY_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
344. 0.004 0.007 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.007..0.007 rows=0 loops=1)

345. 0.000 0.000 ↑ 1.0 3 1

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

346. 0.000 0.003 ↓ 0.0 0 3

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

  • Recheck Cond: (knowledge_id = ck_id_50.id)
347. 0.003 0.003 ↓ 0.0 0 3

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

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

CTE KQ_CAR_MONTHLY_BUDGET

349. 0.001 0.011 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.010..0.011 rows=0 loops=1)

  • Group Key: "KQ_CAR_MONTHLY_BUDGET_1".knowledge_id
350. 0.004 0.010 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.010..0.010 rows=0 loops=1)

  • Sort Key: "KQ_CAR_MONTHLY_BUDGET_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
351. 0.002 0.006 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.006..0.006 rows=0 loops=1)

352. 0.001 0.001 ↑ 1.0 3 1

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

353. 0.003 0.003 ↓ 0.0 0 3

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

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

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

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

CTE KQ_RE_LIST_SELLER

356. 0.000 0.021 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.021..0.021 rows=0 loops=1)

  • Group Key: "KQ_RE_LIST_SELLER_1".knowledge_id
357. 0.004 0.021 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.021..0.021 rows=0 loops=1)

  • Sort Key: "KQ_RE_LIST_SELLER_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
358. 0.002 0.017 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.017..0.017 rows=0 loops=1)

359. 0.000 0.000 ↑ 1.0 3 1

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

360. 0.003 0.015 ↓ 0.0 0 3

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

  • Recheck Cond: (knowledge_id = ck_id_52.id)
361. 0.012 0.012 ↓ 0.0 0 3

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

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

CTE KQ_ADV_COMMUNICATION_LOCATION

363. 0.000 0.014 ↓ 0.0 0 1

GroupAggregate (cost=25.01..25.08 rows=3 width=36) (actual time=0.014..0.014 rows=0 loops=1)

  • Group Key: "KQ_ADV_COMMUNICATION_LOCATION_1".knowledge_id
364. 0.005 0.014 ↓ 0.0 0 1

Sort (cost=25.01..25.01 rows=3 width=8) (actual time=0.014..0.014 rows=0 loops=1)

  • Sort Key: "KQ_ADV_COMMUNICATION_LOCATION_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
365. 0.002 0.009 ↓ 0.0 0 1

Nested Loop (cost=0.28..24.98 rows=3 width=8) (actual time=0.009..0.009 rows=0 loops=1)

366. 0.001 0.001 ↑ 1.0 3 1

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

367. 0.006 0.006 ↓ 0.0 0 3

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 time=0.002..0.002 rows=0 loops=3)

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

CTE KQ_RE_LBC_ADSERVING_MODE_RENTAL

369. 0.000 0.021 ↓ 0.0 0 1

GroupAggregate (cost=1.91..1.98 rows=3 width=36) (actual time=0.021..0.021 rows=0 loops=1)

  • Group Key: "KQ_RE_LBC_ADSERVING_MODE_RENTAL_1".knowledge_id
370. 0.003 0.021 ↓ 0.0 0 1

Sort (cost=1.91..1.92 rows=3 width=8) (actual time=0.021..0.021 rows=0 loops=1)

  • Sort Key: "KQ_RE_LBC_ADSERVING_MODE_RENTAL_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
371. 0.010 0.018 ↓ 0.0 0 1

Hash Join (cost=0.10..1.88 rows=3 width=8) (actual time=0.018..0.018 rows=0 loops=1)

  • Hash Cond: ("KQ_RE_LBC_ADSERVING_MODE_RENTAL_1".knowledge_id = ck_id_54.id)
372. 0.005 0.005 ↑ 1.0 55 1

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 time=0.003..0.005 rows=55 loops=1)

373. 0.002 0.003 ↑ 1.0 3 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
374. 0.001 0.001 ↑ 1.0 3 1

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

375.          

CTE KQ_RE_CATEGORIES

376. 0.000 0.011 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.011..0.011 rows=0 loops=1)

  • Group Key: "KQ_RE_CATEGORIES_1".knowledge_id
377. 0.004 0.011 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.011..0.011 rows=0 loops=1)

  • Sort Key: "KQ_RE_CATEGORIES_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
378. 0.004 0.007 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.007..0.007 rows=0 loops=1)

379. 0.000 0.000 ↑ 1.0 3 1

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

380. 0.000 0.003 ↓ 0.0 0 3

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

  • Recheck Cond: (knowledge_id = ck_id_55.id)
381. 0.003 0.003 ↓ 0.0 0 3

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

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

CTE KQ_JOB_ATS

383. 0.001 0.010 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.010..0.010 rows=0 loops=1)

  • Group Key: "KQ_JOB_ATS_1".knowledge_id
384. 0.003 0.009 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.009..0.009 rows=0 loops=1)

  • Sort Key: "KQ_JOB_ATS_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
385. 0.002 0.006 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.006..0.006 rows=0 loops=1)

386. 0.001 0.001 ↑ 1.0 3 1

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

387. 0.000 0.003 ↓ 0.0 0 3

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

  • Recheck Cond: (knowledge_id = ck_id_56.id)
388. 0.003 0.003 ↓ 0.0 0 3

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

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

CTE KQ_RE_NS_SOFTWARE_LIST

390. 0.001 0.013 ↓ 0.0 0 1

GroupAggregate (cost=35.62..36.47 rows=34 width=36) (actual time=0.013..0.013 rows=0 loops=1)

  • Group Key: "KQ_RE_NS_SOFTWARE_LIST_1".knowledge_id
391. 0.003 0.012 ↓ 0.0 0 1

Sort (cost=35.62..35.70 rows=34 width=8) (actual time=0.012..0.012 rows=0 loops=1)

  • Sort Key: "KQ_RE_NS_SOFTWARE_LIST_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
392. 0.005 0.009 ↓ 0.0 0 1

Nested Loop (cost=2.91..34.75 rows=34 width=8) (actual time=0.008..0.009 rows=0 loops=1)

393. 0.001 0.001 ↑ 1.0 3 1

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

394. 0.000 0.003 ↓ 0.0 0 3

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 time=0.001..0.001 rows=0 loops=3)

  • Recheck Cond: (knowledge_id = ck_id_57.id)
395. 0.003 0.003 ↓ 0.0 0 3

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

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

CTE KQ_JOB_STATUS

397. 0.023 0.038 ↑ 1.5 2 1

GroupAggregate (cost=25.01..25.09 rows=3 width=36) (actual time=0.035..0.038 rows=2 loops=1)

  • Group Key: "KQ_JOB_STATUS_1".knowledge_id
398. 0.005 0.015 ↑ 1.5 2 1

Sort (cost=25.01..25.02 rows=3 width=8) (actual time=0.015..0.015 rows=2 loops=1)

  • Sort Key: "KQ_JOB_STATUS_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
399. 0.001 0.010 ↑ 1.5 2 1

Nested Loop (cost=0.28..24.99 rows=3 width=8) (actual time=0.006..0.010 rows=2 loops=1)

400. 0.000 0.000 ↑ 1.0 3 1

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

401. 0.009 0.009 ↑ 1.0 1 3

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 time=0.003..0.003 rows=1 loops=3)

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

CTE KQ_RE_REASON_ADS

403. 0.000 0.019 ↓ 0.0 0 1

GroupAggregate (cost=1.85..1.93 rows=3 width=36) (actual time=0.019..0.019 rows=0 loops=1)

  • Group Key: "KQ_RE_REASON_ADS_1".knowledge_id
404. 0.003 0.019 ↓ 0.0 0 1

Sort (cost=1.85..1.86 rows=3 width=8) (actual time=0.019..0.019 rows=0 loops=1)

  • Sort Key: "KQ_RE_REASON_ADS_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
405. 0.009 0.016 ↓ 0.0 0 1

Hash Join (cost=0.10..1.83 rows=3 width=8) (actual time=0.016..0.016 rows=0 loops=1)

  • Hash Cond: ("KQ_RE_REASON_ADS_1".knowledge_id = ck_id_59.id)
406. 0.004 0.004 ↑ 1.0 51 1

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

407. 0.002 0.003 ↑ 1.0 3 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
408. 0.001 0.001 ↑ 1.0 3 1

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

409.          

CTE KQ_RE_SOFTWARE_LIST

410. 0.001 0.051 ↓ 0.0 0 1

GroupAggregate (cost=5.93..6.01 rows=3 width=36) (actual time=0.051..0.051 rows=0 loops=1)

  • Group Key: "KQ_RE_SOFTWARE_LIST_1".knowledge_id
411. 0.002 0.050 ↓ 0.0 0 1

Sort (cost=5.93..5.94 rows=3 width=8) (actual time=0.050..0.050 rows=0 loops=1)

  • Sort Key: "KQ_RE_SOFTWARE_LIST_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
412. 0.025 0.048 ↓ 0.0 0 1

Hash Join (cost=0.10..5.91 rows=3 width=8) (actual time=0.048..0.048 rows=0 loops=1)

  • Hash Cond: ("KQ_RE_SOFTWARE_LIST_1".knowledge_id = ck_id_60.id)
413. 0.021 0.021 ↑ 1.0 275 1

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

414. 0.001 0.002 ↑ 1.0 3 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
415. 0.001 0.001 ↑ 1.0 3 1

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

416.          

CTE KQ_CUST_KANTAR

417. 0.011 0.030 ↑ 1.5 2 1

GroupAggregate (cost=25.02..25.10 rows=3 width=36) (actual time=0.027..0.030 rows=2 loops=1)

  • Group Key: "KQ_CUST_KANTAR_1".knowledge_id
418. 0.008 0.019 ↑ 1.5 2 1

Sort (cost=25.02..25.03 rows=3 width=8) (actual time=0.019..0.019 rows=2 loops=1)

  • Sort Key: "KQ_CUST_KANTAR_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
419. 0.001 0.011 ↑ 1.5 2 1

Nested Loop (cost=0.29..25.00 rows=3 width=8) (actual time=0.007..0.011 rows=2 loops=1)

420. 0.001 0.001 ↑ 1.0 3 1

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

421. 0.009 0.009 ↑ 1.0 1 3

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 time=0.003..0.003 rows=1 loops=3)

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

CTE KQ_CAR_OPTION_TYPE

423. 0.001 0.011 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.011..0.011 rows=0 loops=1)

  • Group Key: "KQ_CAR_OPTION_TYPE_1".knowledge_id
424. 0.003 0.010 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.010..0.010 rows=0 loops=1)

  • Sort Key: "KQ_CAR_OPTION_TYPE_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
425. 0.003 0.007 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.007..0.007 rows=0 loops=1)

426. 0.001 0.001 ↑ 1.0 3 1

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

427. 0.000 0.003 ↓ 0.0 0 3

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

  • Recheck Cond: (knowledge_id = ck_id_62.id)
428. 0.003 0.003 ↓ 0.0 0 3

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

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

CTE KQ_RE_MONTH_CREDIT_BUDGET

430. 0.001 0.072 ↓ 0.0 0 1

GroupAggregate (cost=7.86..7.93 rows=3 width=36) (actual time=0.072..0.072 rows=0 loops=1)

  • Group Key: "KQ_RE_MONTH_CREDIT_BUDGET_1".knowledge_id
431. 0.004 0.071 ↓ 0.0 0 1

Sort (cost=7.86..7.87 rows=3 width=8) (actual time=0.071..0.071 rows=0 loops=1)

  • Sort Key: "KQ_RE_MONTH_CREDIT_BUDGET_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
432. 0.041 0.067 ↓ 0.0 0 1

Hash Join (cost=0.10..7.83 rows=3 width=8) (actual time=0.067..0.067 rows=0 loops=1)

  • Hash Cond: ("KQ_RE_MONTH_CREDIT_BUDGET_1".knowledge_id = ck_id_63.id)
433. 0.024 0.024 ↑ 1.0 415 1

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

434. 0.002 0.002 ↑ 1.0 3 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
435. 0.000 0.000 ↑ 1.0 3 1

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

436.          

CTE KQ_RE_USE_OPTION

437. 0.001 0.008 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.007..0.008 rows=0 loops=1)

  • Group Key: "KQ_RE_USE_OPTION_1".knowledge_id
438. 0.001 0.007 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.007..0.007 rows=0 loops=1)

  • Sort Key: "KQ_RE_USE_OPTION_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
439. 0.003 0.006 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.006..0.006 rows=0 loops=1)

440. 0.000 0.000 ↑ 1.0 3 1

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

441. 0.003 0.003 ↓ 0.0 0 3

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

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

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

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

CTE KQ_CUST_BUDGET_OPTION

444. 0.001 0.011 ↓ 0.0 0 1

GroupAggregate (cost=35.62..36.47 rows=34 width=36) (actual time=0.011..0.011 rows=0 loops=1)

  • Group Key: "KQ_CUST_BUDGET_OPTION_1".knowledge_id
445. 0.003 0.010 ↓ 0.0 0 1

Sort (cost=35.62..35.70 rows=34 width=8) (actual time=0.010..0.010 rows=0 loops=1)

  • Sort Key: "KQ_CUST_BUDGET_OPTION_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
446. 0.004 0.007 ↓ 0.0 0 1

Nested Loop (cost=2.91..34.75 rows=34 width=8) (actual time=0.007..0.007 rows=0 loops=1)

447. 0.000 0.000 ↑ 1.0 3 1

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

448. 0.000 0.003 ↓ 0.0 0 3

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

  • Recheck Cond: (knowledge_id = ck_id_65.id)
449. 0.003 0.003 ↓ 0.0 0 3

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

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

CTE KQ_RE_RANGE_NS_PROG

451. 0.001 0.019 ↓ 0.0 0 1

GroupAggregate (cost=35.62..36.47 rows=34 width=36) (actual time=0.019..0.019 rows=0 loops=1)

  • Group Key: "KQ_RE_RANGE_NS_PROG_1".knowledge_id
452. 0.003 0.018 ↓ 0.0 0 1

Sort (cost=35.62..35.70 rows=34 width=8) (actual time=0.018..0.018 rows=0 loops=1)

  • Sort Key: "KQ_RE_RANGE_NS_PROG_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
453. 0.006 0.015 ↓ 0.0 0 1

Nested Loop (cost=2.91..34.75 rows=34 width=8) (actual time=0.015..0.015 rows=0 loops=1)

454. 0.000 0.000 ↑ 1.0 3 1

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

455. 0.006 0.009 ↓ 0.0 0 3

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 time=0.003..0.003 rows=0 loops=3)

  • Recheck Cond: (knowledge_id = ck_id_66.id)
456. 0.003 0.003 ↓ 0.0 0 3

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

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

CTE KQ_ADV_COMMUNICATION_SUPPORT

458. 0.000 0.065 ↓ 0.0 0 1

GroupAggregate (cost=8.30..8.37 rows=3 width=36) (actual time=0.065..0.065 rows=0 loops=1)

  • Group Key: "KQ_ADV_COMMUNICATION_SUPPORT_1".knowledge_id
459. 0.004 0.065 ↓ 0.0 0 1

Sort (cost=8.30..8.31 rows=3 width=8) (actual time=0.065..0.065 rows=0 loops=1)

  • Sort Key: "KQ_ADV_COMMUNICATION_SUPPORT_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
460. 0.033 0.061 ↓ 0.0 0 1

Hash Join (cost=0.10..8.27 rows=3 width=8) (actual time=0.061..0.061 rows=0 loops=1)

  • Hash Cond: ("KQ_ADV_COMMUNICATION_SUPPORT_1".knowledge_id = ck_id_67.id)
461. 0.026 0.026 ↑ 1.0 447 1

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

462. 0.001 0.002 ↑ 1.0 3 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
463. 0.001 0.001 ↑ 1.0 3 1

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

464.          

CTE KQ_RE_ADSERVING_SUPPORT

465. 0.000 0.112 ↓ 0.0 0 1

GroupAggregate (cost=16.16..16.31 rows=6 width=36) (actual time=0.112..0.112 rows=0 loops=1)

  • Group Key: "KQ_RE_ADSERVING_SUPPORT_1".knowledge_id
466. 0.005 0.112 ↓ 0.0 0 1

Sort (cost=16.16..16.17 rows=6 width=8) (actual time=0.112..0.112 rows=0 loops=1)

  • Sort Key: "KQ_RE_ADSERVING_SUPPORT_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
467. 0.057 0.107 ↓ 0.0 0 1

Hash Join (cost=0.10..16.08 rows=6 width=8) (actual time=0.107..0.107 rows=0 loops=1)

  • Hash Cond: ("KQ_RE_ADSERVING_SUPPORT_1".knowledge_id = ck_id_68.id)
468. 0.047 0.047 ↑ 1.0 867 1

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

469. 0.002 0.003 ↑ 1.0 3 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
470. 0.001 0.001 ↑ 1.0 3 1

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

471.          

CTE KQ_RE_ADSERVING_SUPPORT_HOLY_RENTAL

472. 0.001 0.010 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.010..0.010 rows=0 loops=1)

  • Group Key: "KQ_RE_ADSERVING_SUPPORT_HOLY_RENTAL_1".knowledge_id
473. 0.003 0.009 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.009..0.009 rows=0 loops=1)

  • Sort Key: "KQ_RE_ADSERVING_SUPPORT_HOLY_RENTAL_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
474. 0.003 0.006 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.006..0.006 rows=0 loops=1)

475. 0.000 0.000 ↑ 1.0 3 1

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

476. 0.000 0.003 ↓ 0.0 0 3

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 time=0.001..0.001 rows=0 loops=3)

  • Recheck Cond: (knowledge_id = ck_id_69.id)
477. 0.003 0.003 ↓ 0.0 0 3

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

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

CTE KQ_JOB_MULTIPOSTER_LEC

479. 0.001 0.014 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.014..0.014 rows=0 loops=1)

  • Group Key: "KQ_JOB_MULTIPOSTER_LEC_1".knowledge_id
480. 0.006 0.013 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.013..0.013 rows=0 loops=1)

  • Sort Key: "KQ_JOB_MULTIPOSTER_LEC_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
481. 0.004 0.007 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.007..0.007 rows=0 loops=1)

482. 0.000 0.000 ↑ 1.0 3 1

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

483. 0.000 0.003 ↓ 0.0 0 3

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

  • Recheck Cond: (knowledge_id = ck_id_70.id)
484. 0.003 0.003 ↓ 0.0 0 3

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

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

CTE KQ_RE_REASON_ADS_NEW_SALE

486. 0.000 0.010 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.010..0.010 rows=0 loops=1)

  • Group Key: "KQ_RE_REASON_ADS_NEW_SALE_1".knowledge_id
487. 0.005 0.010 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.010..0.010 rows=0 loops=1)

  • Sort Key: "KQ_RE_REASON_ADS_NEW_SALE_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
488. 0.002 0.005 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.005..0.005 rows=0 loops=1)

489. 0.000 0.000 ↑ 1.0 3 1

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

490. 0.003 0.003 ↓ 0.0 0 3

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 time=0.001..0.001 rows=0 loops=3)

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

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

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

CTE KQ_CUST_WEBSITE

493. 0.000 0.011 ↓ 0.0 0 1

GroupAggregate (cost=25.01..25.08 rows=3 width=36) (actual time=0.011..0.011 rows=0 loops=1)

  • Group Key: "KQ_CUST_WEBSITE_1".knowledge_id
494. 0.003 0.011 ↓ 0.0 0 1

Sort (cost=25.01..25.01 rows=3 width=8) (actual time=0.011..0.011 rows=0 loops=1)

  • Sort Key: "KQ_CUST_WEBSITE_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
495. 0.002 0.008 ↓ 0.0 0 1

Nested Loop (cost=0.28..24.98 rows=3 width=8) (actual time=0.008..0.008 rows=0 loops=1)

496. 0.000 0.000 ↑ 1.0 3 1

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

497. 0.006 0.006 ↓ 0.0 0 3

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 time=0.002..0.002 rows=0 loops=3)

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

CTE KQ_CAR_USE_OPTION

499. 0.000 0.008 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.008..0.008 rows=0 loops=1)

  • Group Key: "KQ_CAR_USE_OPTION_1".knowledge_id
500. 0.003 0.008 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.008..0.008 rows=0 loops=1)

  • Sort Key: "KQ_CAR_USE_OPTION_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
501. 0.002 0.005 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.005..0.005 rows=0 loops=1)

502. 0.000 0.000 ↑ 1.0 3 1

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

503. 0.003 0.003 ↓ 0.0 0 3

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

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

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

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

CTE KQ_ADV_ANNUAL_NEED_3

506. 0.001 0.046 ↓ 0.0 0 1

GroupAggregate (cost=4.38..4.96 rows=14 width=36) (actual time=0.046..0.046 rows=0 loops=1)

  • Group Key: "KQ_ADV_ANNUAL_NEED_3_1".knowledge_id
507. 0.003 0.045 ↓ 0.0 0 1

Sort (cost=4.38..4.46 rows=33 width=8) (actual time=0.045..0.045 rows=0 loops=1)

  • Sort Key: "KQ_ADV_ANNUAL_NEED_3_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
508. 0.028 0.042 ↓ 0.0 0 1

Hash Join (cost=0.10..3.54 rows=33 width=8) (actual time=0.042..0.042 rows=0 loops=1)

  • Hash Cond: ("KQ_ADV_ANNUAL_NEED_3_1".knowledge_id = ck_id_74.id)
509. 0.010 0.010 ↑ 1.0 154 1

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

510. 0.003 0.004 ↑ 1.0 3 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
511. 0.001 0.001 ↑ 1.0 3 1

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

512.          

CTE KQ_JOB_ACTIVITY

513. 0.008 0.023 ↑ 3.0 1 1

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

  • Group Key: "KQ_JOB_ACTIVITY_1".knowledge_id
514. 0.006 0.015 ↑ 3.0 1 1

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

  • Sort Key: "KQ_JOB_ACTIVITY_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
515. 0.003 0.009 ↑ 3.0 1 1

Nested Loop (cost=0.29..25.00 rows=3 width=8) (actual time=0.006..0.009 rows=1 loops=1)

516. 0.000 0.000 ↑ 1.0 3 1

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

517. 0.006 0.006 ↓ 0.0 0 3

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 time=0.002..0.002 rows=0 loops=3)

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

CTE KQ_JOB_SOFTWARE_LIST

519. 0.000 0.010 ↓ 0.0 0 1

GroupAggregate (cost=35.62..36.47 rows=34 width=36) (actual time=0.010..0.010 rows=0 loops=1)

  • Group Key: "KQ_JOB_SOFTWARE_LIST_1".knowledge_id
520. 0.003 0.010 ↓ 0.0 0 1

Sort (cost=35.62..35.70 rows=34 width=8) (actual time=0.010..0.010 rows=0 loops=1)

  • Sort Key: "KQ_JOB_SOFTWARE_LIST_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
521. 0.004 0.007 ↓ 0.0 0 1

Nested Loop (cost=2.91..34.75 rows=34 width=8) (actual time=0.007..0.007 rows=0 loops=1)

522. 0.000 0.000 ↑ 1.0 3 1

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

523. 0.000 0.003 ↓ 0.0 0 3

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

  • Recheck Cond: (knowledge_id = ck_id_76.id)
524. 0.003 0.003 ↓ 0.0 0 3

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

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

CTE KQ_JOB_MULTIPOSTER

526. 0.001 0.018 ↓ 0.0 0 1

GroupAggregate (cost=35.62..36.47 rows=34 width=36) (actual time=0.018..0.018 rows=0 loops=1)

  • Group Key: "KQ_JOB_MULTIPOSTER_1".knowledge_id
527. 0.003 0.017 ↓ 0.0 0 1

Sort (cost=35.62..35.70 rows=34 width=8) (actual time=0.017..0.017 rows=0 loops=1)

  • Sort Key: "KQ_JOB_MULTIPOSTER_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
528. 0.002 0.014 ↓ 0.0 0 1

Nested Loop (cost=2.91..34.75 rows=34 width=8) (actual time=0.014..0.014 rows=0 loops=1)

529. 0.000 0.000 ↑ 1.0 3 1

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

530. 0.003 0.012 ↓ 0.0 0 3

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

  • Recheck Cond: (knowledge_id = ck_id_77.id)
531. 0.009 0.009 ↓ 0.0 0 3

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

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

CTE KQ_CUST_LBC_DEPOSIT

533. 0.000 0.013 ↓ 0.0 0 1

GroupAggregate (cost=25.01..25.08 rows=3 width=36) (actual time=0.013..0.013 rows=0 loops=1)

  • Group Key: "KQ_CUST_LBC_DEPOSIT_1".knowledge_id
534. 0.005 0.013 ↓ 0.0 0 1

Sort (cost=25.01..25.01 rows=3 width=8) (actual time=0.013..0.013 rows=0 loops=1)

  • Sort Key: "KQ_CUST_LBC_DEPOSIT_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
535. 0.002 0.008 ↓ 0.0 0 1

Nested Loop (cost=0.28..24.98 rows=3 width=8) (actual time=0.008..0.008 rows=0 loops=1)

536. 0.000 0.000 ↑ 1.0 3 1

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

537. 0.006 0.006 ↓ 0.0 0 3

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 time=0.002..0.002 rows=0 loops=3)

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

CTE KQ_RE_LBC_ADSERVING_MODE

539. 0.000 0.056 ↓ 0.0 0 1

GroupAggregate (cost=7.49..7.56 rows=3 width=36) (actual time=0.056..0.056 rows=0 loops=1)

  • Group Key: "KQ_RE_LBC_ADSERVING_MODE_1".knowledge_id
540. 0.003 0.056 ↓ 0.0 0 1

Sort (cost=7.49..7.49 rows=3 width=8) (actual time=0.056..0.056 rows=0 loops=1)

  • Sort Key: "KQ_RE_LBC_ADSERVING_MODE_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
541. 0.029 0.053 ↓ 0.0 0 1

Hash Join (cost=0.10..7.46 rows=3 width=8) (actual time=0.053..0.053 rows=0 loops=1)

  • Hash Cond: ("KQ_RE_LBC_ADSERVING_MODE_1".knowledge_id = ck_id_79.id)
542. 0.022 0.022 ↑ 1.0 388 1

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

543. 0.002 0.002 ↑ 1.0 3 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
544. 0.000 0.000 ↑ 1.0 3 1

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

545.          

CTE KQ_CUST_CREDITCARD

546. 0.000 0.014 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.014..0.014 rows=0 loops=1)

  • Group Key: "KQ_CUST_CREDITCARD_1".knowledge_id
547. 0.004 0.014 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.014..0.014 rows=0 loops=1)

  • Sort Key: "KQ_CUST_CREDITCARD_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
548. 0.004 0.010 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.010..0.010 rows=0 loops=1)

549. 0.000 0.000 ↑ 1.0 3 1

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

550. 0.003 0.006 ↓ 0.0 0 3

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

  • Recheck Cond: (knowledge_id = ck_id_80.id)
551. 0.003 0.003 ↓ 0.0 0 3

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

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

CTE KQ_ADV_SPC

553. 0.000 0.010 ↓ 0.0 0 1

GroupAggregate (cost=25.01..25.08 rows=3 width=36) (actual time=0.010..0.010 rows=0 loops=1)

  • Group Key: "KQ_ADV_SPC_1".knowledge_id
554. 0.003 0.010 ↓ 0.0 0 1

Sort (cost=25.01..25.01 rows=3 width=8) (actual time=0.010..0.010 rows=0 loops=1)

  • Sort Key: "KQ_ADV_SPC_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
555. 0.001 0.007 ↓ 0.0 0 1

Nested Loop (cost=0.28..24.98 rows=3 width=8) (actual time=0.007..0.007 rows=0 loops=1)

556. 0.000 0.000 ↑ 1.0 3 1

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

557. 0.006 0.006 ↓ 0.0 0 3

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 time=0.002..0.002 rows=0 loops=3)

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

CTE KQ_RE_CONTACT_TYPOLOGY

559. 0.000 0.008 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.008..0.008 rows=0 loops=1)

  • Group Key: "KQ_RE_CONTACT_TYPOLOGY_1".knowledge_id
560. 0.002 0.008 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.008..0.008 rows=0 loops=1)

  • Sort Key: "KQ_RE_CONTACT_TYPOLOGY_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
561. 0.003 0.006 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.005..0.006 rows=0 loops=1)

562. 0.000 0.000 ↑ 1.0 3 1

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

563. 0.000 0.003 ↓ 0.0 0 3

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

  • Recheck Cond: (knowledge_id = ck_id_82.id)
564. 0.003 0.003 ↓ 0.0 0 3

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

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

CTE KQ_JOB_SUPPORT

566. 0.008 0.021 ↑ 3.0 1 1

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

  • Group Key: "KQ_JOB_SUPPORT_1".knowledge_id
567. 0.003 0.013 ↑ 3.0 1 1

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

  • Sort Key: "KQ_JOB_SUPPORT_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
568. 0.001 0.010 ↑ 3.0 1 1

Nested Loop (cost=0.28..24.98 rows=3 width=8) (actual time=0.008..0.010 rows=1 loops=1)

569. 0.000 0.000 ↑ 1.0 3 1

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

570. 0.009 0.009 ↓ 0.0 0 3

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 time=0.003..0.003 rows=0 loops=3)

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

CTE KQ_ADV_NB_ANNUAL_CAMPAIGN

572. 0.000 0.011 ↓ 0.0 0 1

GroupAggregate (cost=25.01..25.08 rows=3 width=36) (actual time=0.011..0.011 rows=0 loops=1)

  • Group Key: "KQ_ADV_NB_ANNUAL_CAMPAIGN_1".knowledge_id
573. 0.004 0.011 ↓ 0.0 0 1

Sort (cost=25.01..25.01 rows=3 width=8) (actual time=0.011..0.011 rows=0 loops=1)

  • Sort Key: "KQ_ADV_NB_ANNUAL_CAMPAIGN_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
574. 0.001 0.007 ↓ 0.0 0 1

Nested Loop (cost=0.28..24.98 rows=3 width=8) (actual time=0.007..0.007 rows=0 loops=1)

575. 0.000 0.000 ↑ 1.0 3 1

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

576. 0.006 0.006 ↓ 0.0 0 3

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 time=0.002..0.002 rows=0 loops=3)

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

CTE KQ_RE_USE_SOFTWARE

578. 0.001 0.057 ↓ 0.0 0 1

GroupAggregate (cost=7.28..7.36 rows=3 width=36) (actual time=0.057..0.057 rows=0 loops=1)

  • Group Key: "KQ_RE_USE_SOFTWARE_1".knowledge_id
579. 0.003 0.056 ↓ 0.0 0 1

Sort (cost=7.28..7.29 rows=3 width=8) (actual time=0.056..0.056 rows=0 loops=1)

  • Sort Key: "KQ_RE_USE_SOFTWARE_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
580. 0.030 0.053 ↓ 0.0 0 1

Hash Join (cost=0.10..7.26 rows=3 width=8) (actual time=0.053..0.053 rows=0 loops=1)

  • Hash Cond: ("KQ_RE_USE_SOFTWARE_1".knowledge_id = ck_id_85.id)
581. 0.021 0.021 ↑ 1.0 373 1

Seq Scan on "KQ_RE_USE_SOFTWARE" "KQ_RE_USE_SOFTWARE_1" (cost=0.00..5.73 rows=373 width=8) (actual time=0.005..0.021 rows=373 loops=1)

582. 0.001 0.002 ↑ 1.0 3 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
583. 0.001 0.001 ↑ 1.0 3 1

CTE Scan on ck_id ck_id_85 (cost=0.00..0.06 rows=3 width=4) (actual time=0.000..0.001 rows=3 loops=1)

584.          

CTE KQ_JOB_USE_SOFTWARE

585. 0.001 0.012 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.012..0.012 rows=0 loops=1)

  • Group Key: "KQ_JOB_USE_SOFTWARE_1".knowledge_id
586. 0.004 0.011 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.011..0.011 rows=0 loops=1)

  • Sort Key: "KQ_JOB_USE_SOFTWARE_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
587. 0.004 0.007 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.007..0.007 rows=0 loops=1)

588. 0.000 0.000 ↑ 1.0 3 1

CTE Scan on ck_id ck_id_86 (cost=0.00..0.06 rows=3 width=4) (actual time=0.000..0.000 rows=3 loops=1)

589. 0.000 0.003 ↓ 0.0 0 3

Bitmap Heap Scan on "KQ_JOB_USE_SOFTWARE" "KQ_JOB_USE_SOFTWARE_1" (cost=1.57..10.12 rows=11 width=8) (actual time=0.001..0.001 rows=0 loops=3)

  • Recheck Cond: (knowledge_id = ck_id_86.id)
590. 0.003 0.003 ↓ 0.0 0 3

Bitmap Index Scan on "ix_lookup_KQ_JOB_USE_SOFTWARE_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual time=0.001..0.001 rows=0 loops=3)

  • Index Cond: (knowledge_id = ck_id_86.id)
591.          

CTE KQ_JOB_ADSERVING_SUPPORT

592. 0.001 0.010 ↓ 0.0 0 1

GroupAggregate (cost=31.62..32.47 rows=34 width=36) (actual time=0.010..0.010 rows=0 loops=1)

  • Group Key: "KQ_JOB_ADSERVING_SUPPORT_1".knowledge_id
593. 0.004 0.009 ↓ 0.0 0 1

Sort (cost=31.62..31.70 rows=34 width=8) (actual time=0.009..0.009 rows=0 loops=1)

  • Sort Key: "KQ_JOB_ADSERVING_SUPPORT_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
594. 0.002 0.005 ↓ 0.0 0 1

Nested Loop (cost=1.57..30.75 rows=34 width=8) (actual time=0.005..0.005 rows=0 loops=1)

595. 0.000 0.000 ↑ 1.0 3 1

CTE Scan on ck_id ck_id_87 (cost=0.00..0.06 rows=3 width=4) (actual time=0.000..0.000 rows=3 loops=1)

596. 0.003 0.003 ↓ 0.0 0 3

Bitmap Heap Scan on "KQ_JOB_ADSERVING_SUPPORT" "KQ_JOB_ADSERVING_SUPPORT_1" (cost=1.57..10.12 rows=11 width=8) (actual time=0.001..0.001 rows=0 loops=3)

  • Recheck Cond: (knowledge_id = ck_id_87.id)
597. 0.000 0.000 ↓ 0.0 0 3

Bitmap Index Scan on "ix_lookup_KQ_JOB_ADSERVING_SUPPORT_knowledge_id" (cost=0.00..1.57 rows=11 width=0) (actual time=0.000..0.000 rows=0 loops=3)

  • Index Cond: (knowledge_id = ck_id_87.id)
598.          

CTE KQ_ADV_ANNUAL_NEED_2

599. 0.001 0.020 ↓ 0.0 0 1

GroupAggregate (cost=46.79..47.59 rows=32 width=36) (actual time=0.019..0.020 rows=0 loops=1)

  • Group Key: "KQ_ADV_ANNUAL_NEED_2_1".knowledge_id
600. 0.006 0.019 ↓ 0.0 0 1

Sort (cost=46.79..46.87 rows=32 width=8) (actual time=0.019..0.019 rows=0 loops=1)

  • Sort Key: "KQ_ADV_ANNUAL_NEED_2_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
601. 0.005 0.013 ↓ 0.0 0 1

Nested Loop (cost=4.37..45.99 rows=32 width=8) (actual time=0.013..0.013 rows=0 loops=1)

602. 0.002 0.002 ↑ 1.0 3 1

CTE Scan on ck_id ck_id_88 (cost=0.00..0.06 rows=3 width=4) (actual time=0.001..0.002 rows=3 loops=1)

603. 0.003 0.006 ↓ 0.0 0 3

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 time=0.002..0.002 rows=0 loops=3)

  • Recheck Cond: (knowledge_id = ck_id_88.id)
604. 0.003 0.003 ↓ 0.0 0 3

Bitmap Index Scan on "ix_lookup_KQ_ADV_ANNUAL_NEED_2_knowledge_id" (cost=0.00..4.36 rows=11 width=0) (actual time=0.001..0.001 rows=0 loops=3)

  • Index Cond: (knowledge_id = ck_id_88.id)
605.          

CTE KQ_RE_NS_AD_MODE

606. 0.000 0.010 ↓ 0.0 0 1

GroupAggregate (cost=35.62..36.47 rows=34 width=36) (actual time=0.010..0.010 rows=0 loops=1)

  • Group Key: "KQ_RE_NS_AD_MODE_1".knowledge_id
607. 0.003 0.010 ↓ 0.0 0 1

Sort (cost=35.62..35.70 rows=34 width=8) (actual time=0.010..0.010 rows=0 loops=1)

  • Sort Key: "KQ_RE_NS_AD_MODE_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
608. 0.004 0.007 ↓ 0.0 0 1

Nested Loop (cost=2.91..34.75 rows=34 width=8) (actual time=0.007..0.007 rows=0 loops=1)

609. 0.000 0.000 ↑ 1.0 3 1

CTE Scan on ck_id ck_id_89 (cost=0.00..0.06 rows=3 width=4) (actual time=0.000..0.000 rows=3 loops=1)

610. 0.000 0.003 ↓ 0.0 0 3

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 time=0.001..0.001 rows=0 loops=3)

  • Recheck Cond: (knowledge_id = ck_id_89.id)
611. 0.003 0.003 ↓ 0.0 0 3

Bitmap Index Scan on "ix_lookup_KQ_RE_NS_AD_MODE_knowledge_id" (cost=0.00..2.90 rows=11 width=0) (actual time=0.001..0.001 rows=0 loops=3)

  • Index Cond: (knowledge_id = ck_id_89.id)
612.          

CTE KQ_AREA_LIST

613. 0.000 0.006 ↓ 0.0 0 1

GroupAggregate (cost=28.15..28.53 rows=19 width=36) (actual time=0.006..0.006 rows=0 loops=1)

  • Group Key: "KQ_AREA_LIST_1".knowledge_id
614. 0.004 0.006 ↓ 0.0 0 1

Sort (cost=28.15..28.20 rows=19 width=36) (actual time=0.006..0.006 rows=0 loops=1)

  • Sort Key: "KQ_AREA_LIST_1".knowledge_id
  • Sort Method: quicksort Memory: 25kB
615. 0.001 0.002 ↓ 0.0 0 1

Hash Join (cost=0.10..27.75 rows=19 width=36) (actual time=0.002..0.002 rows=0 loops=1)

  • Hash Cond: ("KQ_AREA_LIST_1".knowledge_id = ck_id_90.id)
616. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on "KQ_AREA_LIST" "KQ_AREA_LIST_1" (cost=0.00..22.70 rows=1,270 width=36) (actual time=0.001..0.001 rows=0 loops=1)

617. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.06..0.06 rows=3 width=4) (never executed)

618. 0.000 0.000 ↓ 0.0 0

CTE Scan on ck_id ck_id_90 (cost=0.00..0.06 rows=3 width=4) (never executed)

619. 0.005 3.723 ↑ 1.0 3 1

Merge Left Join (cost=76.52..76.58 rows=3 width=3,781) (actual time=3.721..3.723 rows=3 loops=1)

  • Merge Cond: (ck_id.id = "KQ_ADV_NB_ANNUAL_CAMPAIGN".k_id)
620. 0.009 3.703 ↑ 1.0 3 1

Sort (cost=76.44..76.45 rows=3 width=3,749) (actual time=3.703..3.703 rows=3 loops=1)

  • Sort Key: ck_id.id DESC
  • Sort Method: quicksort Memory: 25kB
621. 0.014 3.694 ↑ 1.0 3 1

Hash Right Join (cost=75.58..76.42 rows=3 width=3,749) (actual time=3.691..3.694 rows=3 loops=1)

  • Hash Cond: ("KQ_RE_NS_AD_MODE".k_id = ck_id.id)
622. 0.010 0.010 ↓ 0.0 0 1

CTE Scan on "KQ_RE_NS_AD_MODE" (cost=0.00..0.68 rows=34 width=36) (actual time=0.010..0.010 rows=0 loops=1)

623. 0.004 3.670 ↑ 1.0 3 1

Hash (cost=75.54..75.54 rows=3 width=3,717) (actual time=3.670..3.670 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
624. 0.017 3.666 ↑ 1.0 3 1

Hash Right Join (cost=74.70..75.54 rows=3 width=3,717) (actual time=3.663..3.666 rows=3 loops=1)

  • Hash Cond: ("KQ_JOB_ADSERVING_SUPPORT".k_id = ck_id.id)
625. 0.010 0.010 ↓ 0.0 0 1

CTE Scan on "KQ_JOB_ADSERVING_SUPPORT" (cost=0.00..0.68 rows=34 width=36) (actual time=0.010..0.010 rows=0 loops=1)

626. 0.004 3.639 ↑ 1.0 3 1

Hash (cost=74.67..74.67 rows=3 width=3,685) (actual time=3.639..3.639 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
627. 0.017 3.635 ↑ 1.0 3 1

Hash Right Join (cost=73.83..74.67 rows=3 width=3,685) (actual time=3.633..3.635 rows=3 loops=1)

  • Hash Cond: ("KQ_JOB_USE_SOFTWARE".k_id = ck_id.id)
628. 0.012 0.012 ↓ 0.0 0 1

CTE Scan on "KQ_JOB_USE_SOFTWARE" (cost=0.00..0.68 rows=34 width=36) (actual time=0.012..0.012 rows=0 loops=1)

629. 0.005 3.606 ↑ 1.0 3 1

Hash (cost=73.79..73.79 rows=3 width=3,653) (actual time=3.606..3.606 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
630. 0.010 3.601 ↑ 1.0 3 1

Hash Right Join (cost=73.00..73.79 rows=3 width=3,653) (actual time=3.598..3.601 rows=3 loops=1)

  • Hash Cond: ("KQ_ADV_ANNUAL_NEED_2".k_id = ck_id.id)
631. 0.020 0.020 ↓ 0.0 0 1

CTE Scan on "KQ_ADV_ANNUAL_NEED_2" (cost=0.00..0.64 rows=32 width=36) (actual time=0.020..0.020 rows=0 loops=1)

632. 0.006 3.571 ↑ 1.0 3 1

Hash (cost=72.96..72.96 rows=3 width=3,621) (actual time=3.571..3.571 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
633. 0.010 3.565 ↑ 1.0 3 1

Hash Right Join (cost=72.48..72.96 rows=3 width=3,621) (actual time=3.562..3.565 rows=3 loops=1)

  • Hash Cond: ("KQ_AREA_LIST".k_id = ck_id.id)
634. 0.007 0.007 ↓ 0.0 0 1

CTE Scan on "KQ_AREA_LIST" (cost=0.00..0.38 rows=19 width=36) (actual time=0.007..0.007 rows=0 loops=1)

635. 0.006 3.548 ↑ 1.0 3 1

Hash (cost=72.44..72.44 rows=3 width=3,589) (actual time=3.548..3.548 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
636. 0.010 3.542 ↑ 1.0 3 1

Hash Left Join (cost=71.48..72.44 rows=3 width=3,589) (actual time=3.535..3.542 rows=3 loops=1)

  • Hash Cond: (ck_id.id = "KQ_CUST_LBC_DEPOSIT".k_id)
637. 0.019 3.518 ↑ 1.0 3 1

Hash Left Join (cost=71.39..72.31 rows=3 width=3,557) (actual time=3.512..3.518 rows=3 loops=1)

  • Hash Cond: (ck_id.id = "KQ_RE_LBC_ADSERVING_MODE".k_id)
638. 0.010 3.442 ↑ 1.0 3 1

Hash Left Join (cost=71.29..72.17 rows=3 width=3,525) (actual time=3.437..3.442 rows=3 loops=1)

  • Hash Cond: (ck_id.id = "KQ_ADV_SPC".k_id)
639. 0.013 3.422 ↑ 1.0 3 1

Hash Right Join (cost=71.19..72.03 rows=3 width=3,493) (actual time=3.419..3.422 rows=3 loops=1)

  • Hash Cond: ("KQ_RE_CONTACT_TYPOLOGY".k_id = ck_id.id)
640. 0.008 0.008 ↓ 0.0 0 1

CTE Scan on "KQ_RE_CONTACT_TYPOLOGY" (cost=0.00..0.68 rows=34 width=36) (actual time=0.008..0.008 rows=0 loops=1)

641. 0.004 3.401 ↑ 1.0 3 1

Hash (cost=71.15..71.15 rows=3 width=3,461) (actual time=3.401..3.401 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
642. 0.011 3.397 ↑ 1.0 3 1

Hash Right Join (cost=70.32..71.15 rows=3 width=3,461) (actual time=3.394..3.397 rows=3 loops=1)

  • Hash Cond: ("KQ_CUST_CREDITCARD".k_id = ck_id.id)
643. 0.015 0.015 ↓ 0.0 0 1

CTE Scan on "KQ_CUST_CREDITCARD" (cost=0.00..0.68 rows=34 width=36) (actual time=0.015..0.015 rows=0 loops=1)

644. 0.004 3.371 ↑ 1.0 3 1

Hash (cost=70.28..70.28 rows=3 width=3,429) (actual time=3.371..3.371 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
645. 0.011 3.367 ↑ 1.0 3 1

Hash Right Join (cost=69.44..70.28 rows=3 width=3,429) (actual time=3.364..3.367 rows=3 loops=1)

  • Hash Cond: ("KQ_JOB_MULTIPOSTER".k_id = ck_id.id)
646. 0.018 0.018 ↓ 0.0 0 1

CTE Scan on "KQ_JOB_MULTIPOSTER" (cost=0.00..0.68 rows=34 width=36) (actual time=0.018..0.018 rows=0 loops=1)

647. 0.004 3.338 ↑ 1.0 3 1

Hash (cost=69.40..69.40 rows=3 width=3,397) (actual time=3.338..3.338 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
648. 0.009 3.334 ↑ 1.0 3 1

Merge Left Join (cost=69.13..69.40 rows=3 width=3,397) (actual time=3.327..3.334 rows=3 loops=1)

  • Merge Cond: (ck_id.id = "KQ_JOB_SUPPORT".k_id)
649. 0.016 3.300 ↑ 1.0 3 1

Merge Left Join (cost=69.05..69.27 rows=3 width=3,365) (actual time=3.294..3.300 rows=3 loops=1)

  • Merge Cond: (ck_id.id = "KQ_JOB_ACTIVITY".k_id)
650. 0.004 3.256 ↑ 1.0 3 1

Merge Left Join (cost=68.96..69.13 rows=3 width=3,333) (actual time=3.252..3.256 rows=3 loops=1)

  • Merge Cond: (ck_id.id = "KQ_ADV_ANNUAL_NEED_3".k_id)
651. 0.005 3.196 ↑ 1.0 3 1

Merge Left Join (cost=68.42..68.48 rows=3 width=3,301) (actual time=3.193..3.196 rows=3 loops=1)

  • Merge Cond: (ck_id.id = "KQ_CUST_WEBSITE".k_id)
652. 0.008 3.176 ↑ 1.0 3 1

Sort (cost=68.33..68.34 rows=3 width=3,269) (actual time=3.175..3.176 rows=3 loops=1)

  • Sort Key: ck_id.id DESC
  • Sort Method: quicksort Memory: 25kB
653. 0.011 3.168 ↑ 1.0 3 1

Hash Right Join (cost=67.47..68.31 rows=3 width=3,269) (actual time=3.165..3.168 rows=3 loops=1)

  • Hash Cond: ("KQ_JOB_SOFTWARE_LIST".k_id = ck_id.id)
654. 0.011 0.011 ↓ 0.0 0 1

CTE Scan on "KQ_JOB_SOFTWARE_LIST" (cost=0.00..0.68 rows=34 width=36) (actual time=0.011..0.011 rows=0 loops=1)

655. 0.004 3.146 ↑ 1.0 3 1

Hash (cost=67.43..67.43 rows=3 width=3,237) (actual time=3.146..3.146 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
656. 0.010 3.142 ↑ 1.0 3 1

Hash Right Join (cost=66.60..67.43 rows=3 width=3,237) (actual time=3.140..3.142 rows=3 loops=1)

  • Hash Cond: ("KQ_CAR_USE_OPTION".k_id = ck_id.id)
657. 0.009 0.009 ↓ 0.0 0 1

CTE Scan on "KQ_CAR_USE_OPTION" (cost=0.00..0.68 rows=34 width=36) (actual time=0.009..0.009 rows=0 loops=1)

658. 0.005 3.123 ↑ 1.0 3 1

Hash (cost=66.56..66.56 rows=3 width=3,205) (actual time=3.123..3.123 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
659. 0.012 3.118 ↑ 1.0 3 1

Hash Right Join (cost=65.72..66.56 rows=3 width=3,205) (actual time=3.115..3.118 rows=3 loops=1)

  • Hash Cond: ("KQ_RE_REASON_ADS_NEW_SALE".k_id = ck_id.id)
660. 0.010 0.010 ↓ 0.0 0 1

CTE Scan on "KQ_RE_REASON_ADS_NEW_SALE" (cost=0.00..0.68 rows=34 width=36) (actual time=0.010..0.010 rows=0 loops=1)

661. 0.005 3.096 ↑ 1.0 3 1

Hash (cost=65.68..65.68 rows=3 width=3,173) (actual time=3.096..3.096 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
662. 0.012 3.091 ↑ 1.0 3 1

Hash Right Join (cost=64.85..65.68 rows=3 width=3,173) (actual time=3.088..3.091 rows=3 loops=1)

  • Hash Cond: ("KQ_JOB_MULTIPOSTER_LEC".k_id = ck_id.id)
663. 0.014 0.014 ↓ 0.0 0 1

CTE Scan on "KQ_JOB_MULTIPOSTER_LEC" (cost=0.00..0.68 rows=34 width=36) (actual time=0.014..0.014 rows=0 loops=1)

664. 0.008 3.065 ↑ 1.0 3 1

Hash (cost=64.81..64.81 rows=3 width=3,141) (actual time=3.065..3.065 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
665. 0.008 3.057 ↑ 1.0 3 1

Hash Left Join (cost=63.85..64.81 rows=3 width=3,141) (actual time=3.049..3.057 rows=3 loops=1)

  • Hash Cond: (ck_id.id = "KQ_RE_ADSERVING_SUPPORT".k_id)
666. 0.008 2.936 ↑ 1.0 3 1

Hash Left Join (cost=63.65..64.57 rows=3 width=3,109) (actual time=2.929..2.936 rows=3 loops=1)

  • Hash Cond: (ck_id.id = "KQ_ADV_COMMUNICATION_SUPPORT".k_id)
667. 0.009 2.862 ↑ 1.0 3 1

Hash Left Join (cost=63.56..64.43 rows=3 width=3,077) (actual time=2.856..2.862 rows=3 loops=1)

  • Hash Cond: (ck_id.id = "KQ_RE_MONTH_CREDIT_BUDGET".k_id)
668. 0.028 2.781 ↑ 1.0 3 1

Hash Right Join (cost=63.46..64.30 rows=3 width=3,045) (actual time=2.776..2.781 rows=3 loops=1)

  • Hash Cond: ("KQ_RE_ADSERVING_SUPPORT_HOLY_RENTAL".k_id = ck_id.id)
669. 0.010 0.010 ↓ 0.0 0 1

CTE Scan on "KQ_RE_ADSERVING_SUPPORT_HOLY_RENTAL" (cost=0.00..0.68 rows=34 width=36) (actual time=0.010..0.010 rows=0 loops=1)

670. 0.005 2.743 ↑ 1.0 3 1

Hash (cost=63.42..63.42 rows=3 width=3,013) (actual time=2.743..2.743 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
671. 0.018 2.738 ↑ 1.0 3 1

Hash Right Join (cost=62.58..63.42 rows=3 width=3,013) (actual time=2.735..2.738 rows=3 loops=1)

  • Hash Cond: ("KQ_RE_RANGE_NS_PROG".k_id = ck_id.id)
672. 0.019 0.019 ↓ 0.0 0 1

CTE Scan on "KQ_RE_RANGE_NS_PROG" (cost=0.00..0.68 rows=34 width=36) (actual time=0.019..0.019 rows=0 loops=1)

673. 0.004 2.701 ↑ 1.0 3 1

Hash (cost=62.55..62.55 rows=3 width=2,981) (actual time=2.701..2.701 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
674. 0.011 2.697 ↑ 1.0 3 1

Hash Right Join (cost=61.71..62.55 rows=3 width=2,981) (actual time=2.694..2.697 rows=3 loops=1)

  • Hash Cond: ("KQ_CUST_BUDGET_OPTION".k_id = ck_id.id)
675. 0.011 0.011 ↓ 0.0 0 1

CTE Scan on "KQ_CUST_BUDGET_OPTION" (cost=0.00..0.68 rows=34 width=36) (actual time=0.011..0.011 rows=0 loops=1)

676. 0.003 2.675 ↑ 1.0 3 1

Hash (cost=61.67..61.67 rows=3 width=2,949) (actual time=2.675..2.675 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
677. 0.012 2.672 ↑ 1.0 3 1

Hash Right Join (cost=60.83..61.67 rows=3 width=2,949) (actual time=2.669..2.672 rows=3 loops=1)

  • Hash Cond: ("KQ_RE_USE_OPTION".k_id = ck_id.id)
678. 0.008 0.008 ↓ 0.0 0 1

CTE Scan on "KQ_RE_USE_OPTION" (cost=0.00..0.68 rows=34 width=36) (actual time=0.008..0.008 rows=0 loops=1)

679. 0.005 2.652 ↑ 1.0 3 1

Hash (cost=60.80..60.80 rows=3 width=2,917) (actual time=2.652..2.652 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
680. 0.010 2.647 ↑ 1.0 3 1

Hash Left Join (cost=59.79..60.80 rows=3 width=2,917) (actual time=2.638..2.647 rows=3 loops=1)

  • Hash Cond: (ck_id.id = "KQ_CUST_KANTAR".k_id)
681. 0.010 2.603 ↑ 1.0 3 1

Hash Left Join (cost=59.70..60.66 rows=3 width=2,885) (actual time=2.596..2.603 rows=3 loops=1)

  • Hash Cond: (ck_id.id = "KQ_RE_SOFTWARE_LIST".k_id)
682. 0.008 2.542 ↑ 1.0 3 1

Hash Left Join (cost=59.60..60.52 rows=3 width=2,853) (actual time=2.536..2.542 rows=3 loops=1)

  • Hash Cond: (ck_id.id = "KQ_RE_REASON_ADS".k_id)
683. 0.010 2.514 ↑ 1.0 3 1

Hash Left Join (cost=59.50..60.38 rows=3 width=2,821) (actual time=2.509..2.514 rows=3 loops=1)

  • Hash Cond: (ck_id.id = "KQ_JOB_STATUS".k_id)
684. 0.011 2.463 ↑ 1.0 3 1

Hash Right Join (cost=59.40..60.24 rows=3 width=2,789) (actual time=2.460..2.463 rows=3 loops=1)

  • Hash Cond: ("KQ_CAR_OPTION_TYPE".k_id = ck_id.id)
685. 0.011 0.011 ↓ 0.0 0 1

CTE Scan on "KQ_CAR_OPTION_TYPE" (cost=0.00..0.68 rows=34 width=36) (actual time=0.011..0.011 rows=0 loops=1)

686. 0.005 2.441 ↑ 1.0 3 1

Hash (cost=59.37..59.37 rows=3 width=2,757) (actual time=2.441..2.441 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
687. 0.016 2.436 ↑ 1.0 3 1

Hash Right Join (cost=58.53..59.37 rows=3 width=2,757) (actual time=2.433..2.436 rows=3 loops=1)

  • Hash Cond: ("KQ_RE_NS_SOFTWARE_LIST".k_id = ck_id.id)
688. 0.013 0.013 ↓ 0.0 0 1

CTE Scan on "KQ_RE_NS_SOFTWARE_LIST" (cost=0.00..0.68 rows=34 width=36) (actual time=0.013..0.013 rows=0 loops=1)

689. 0.005 2.407 ↑ 1.0 3 1

Hash (cost=58.49..58.49 rows=3 width=2,725) (actual time=2.407..2.407 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
690. 0.011 2.402 ↑ 1.0 3 1

Hash Right Join (cost=57.65..58.49 rows=3 width=2,725) (actual time=2.400..2.402 rows=3 loops=1)

  • Hash Cond: ("KQ_JOB_ATS".k_id = ck_id.id)
691. 0.010 0.010 ↓ 0.0 0 1

CTE Scan on "KQ_JOB_ATS" (cost=0.00..0.68 rows=34 width=36) (actual time=0.010..0.010 rows=0 loops=1)

692. 0.004 2.381 ↑ 1.0 3 1

Hash (cost=57.62..57.62 rows=3 width=2,693) (actual time=2.381..2.381 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
693. 0.011 2.377 ↑ 1.0 3 1

Hash Left Join (cost=56.65..57.62 rows=3 width=2,693) (actual time=2.371..2.377 rows=3 loops=1)

  • Hash Cond: (ck_id.id = "KQ_RE_LBC_ADSERVING_MODE_RENTAL".k_id)
694. 0.009 2.344 ↑ 1.0 3 1

Hash Left Join (cost=56.56..57.48 rows=3 width=2,661) (actual time=2.339..2.344 rows=3 loops=1)

  • Hash Cond: (ck_id.id = "KQ_ADV_COMMUNICATION_LOCATION".k_id)
695. 0.011 2.320 ↑ 1.0 3 1

Hash Left Join (cost=56.46..57.34 rows=3 width=2,629) (actual time=2.316..2.320 rows=3 loops=1)

  • Hash Cond: (ck_id.id = "KQ_CUST_LBC_MONTH_RANGE_AD".k_id)
696. 0.015 2.278 ↑ 1.0 3 1

Hash Right Join (cost=56.36..57.20 rows=3 width=2,597) (actual time=2.275..2.278 rows=3 loops=1)

  • Hash Cond: ("KQ_RE_CATEGORIES".k_id = ck_id.id)
697. 0.012 0.012 ↓ 0.0 0 1

CTE Scan on "KQ_RE_CATEGORIES" (cost=0.00..0.68 rows=34 width=36) (actual time=0.012..0.012 rows=0 loops=1)

698. 0.004 2.251 ↑ 1.0 3 1

Hash (cost=56.32..56.32 rows=3 width=2,565) (actual time=2.251..2.251 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
699. 0.010 2.247 ↑ 1.0 3 1

Hash Right Join (cost=55.49..56.32 rows=3 width=2,565) (actual time=2.245..2.247 rows=3 loops=1)

  • Hash Cond: ("KQ_RE_LIST_SELLER".k_id = ck_id.id)
700. 0.022 0.022 ↓ 0.0 0 1

CTE Scan on "KQ_RE_LIST_SELLER" (cost=0.00..0.68 rows=34 width=36) (actual time=0.022..0.022 rows=0 loops=1)

701. 0.004 2.215 ↑ 1.0 3 1

Hash (cost=55.45..55.45 rows=3 width=2,533) (actual time=2.215..2.215 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
702. 0.012 2.211 ↑ 1.0 3 1

Hash Right Join (cost=54.61..55.45 rows=3 width=2,533) (actual time=2.208..2.211 rows=3 loops=1)

  • Hash Cond: ("KQ_CAR_MONTHLY_BUDGET".k_id = ck_id.id)
703. 0.011 0.011 ↓ 0.0 0 1

CTE Scan on "KQ_CAR_MONTHLY_BUDGET" (cost=0.00..0.68 rows=34 width=36) (actual time=0.011..0.011 rows=0 loops=1)

704. 0.007 2.188 ↑ 1.0 3 1

Hash (cost=54.57..54.57 rows=3 width=2,501) (actual time=2.188..2.188 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
705. 0.013 2.181 ↑ 1.0 3 1

Hash Right Join (cost=53.74..54.57 rows=3 width=2,501) (actual time=2.176..2.181 rows=3 loops=1)

  • Hash Cond: ("KQ_CUST_LBC_CATEGORY".k_id = ck_id.id)
706. 0.011 0.011 ↓ 0.0 0 1

CTE Scan on "KQ_CUST_LBC_CATEGORY" (cost=0.00..0.68 rows=34 width=36) (actual time=0.011..0.011 rows=0 loops=1)

707. 0.004 2.157 ↑ 1.0 3 1

Hash (cost=53.70..53.70 rows=3 width=2,469) (actual time=2.157..2.157 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
708. 0.016 2.153 ↑ 1.0 3 1

Hash Left Join (cost=52.70..53.70 rows=3 width=2,469) (actual time=2.147..2.153 rows=3 loops=1)

  • Hash Cond: (ck_id.id = "KQ_ADV_USE_COMMUNICATION_AGENCY".k_id)
709. 0.008 2.125 ↑ 1.0 3 1

Hash Left Join (cost=52.60..53.56 rows=3 width=2,437) (actual time=2.119..2.125 rows=3 loops=1)

  • Hash Cond: (ck_id.id = "KQ_ADV_TARGETING".k_id)
710. 0.009 2.106 ↑ 1.0 3 1

Hash Left Join (cost=52.50..53.42 rows=3 width=2,405) (actual time=2.101..2.106 rows=3 loops=1)

  • Hash Cond: (ck_id.id = "KQ_RE_NS_AREA".k_id)
711. 0.011 2.072 ↑ 1.0 3 1

Hash Left Join (cost=52.40..53.28 rows=3 width=2,373) (actual time=2.069..2.072 rows=3 loops=1)

  • Hash Cond: (ck_id.id = "KQ_RE_ADSERVING_SUPPORT_RENTAL".k_id)
712. 0.012 2.005 ↑ 1.0 3 1

Hash Right Join (cost=52.18..53.01 rows=3 width=2,341) (actual time=2.003..2.005 rows=3 loops=1)

  • Hash Cond: ("KQ_RE_NS_ANNUAL_PREMARKET".k_id = ck_id.id)
713. 0.011 0.011 ↓ 0.0 0 1

CTE Scan on "KQ_RE_NS_ANNUAL_PREMARKET" (cost=0.00..0.68 rows=34 width=36) (actual time=0.011..0.011 rows=0 loops=1)

714. 0.004 1.982 ↑ 1.0 3 1

Hash (cost=52.14..52.14 rows=3 width=2,309) (actual time=1.982..1.982 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
715. 0.010 1.978 ↑ 1.0 3 1

Hash Right Join (cost=51.30..52.14 rows=3 width=2,309) (actual time=1.976..1.978 rows=3 loops=1)

  • Hash Cond: ("KQ_RE_REASON_ADS_HOLY_RENTAL".k_id = ck_id.id)
716. 0.011 0.011 ↓ 0.0 0 1

CTE Scan on "KQ_RE_REASON_ADS_HOLY_RENTAL" (cost=0.00..0.68 rows=34 width=36) (actual time=0.011..0.011 rows=0 loops=1)

717. 0.004 1.957 ↑ 1.0 3 1

Hash (cost=51.26..51.26 rows=3 width=2,277) (actual time=1.957..1.957 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
718. 0.014 1.953 ↑ 1.0 3 1

Hash Right Join (cost=50.43..51.26 rows=3 width=2,277) (actual time=1.950..1.953 rows=3 loops=1)

  • Hash Cond: ("KQ_CAR_LBC_ADSERVING_MODE".k_id = ck_id.id)
719. 0.014 0.014 ↓ 0.0 0 1

CTE Scan on "KQ_CAR_LBC_ADSERVING_MODE" (cost=0.00..0.68 rows=34 width=36) (actual time=0.014..0.014 rows=0 loops=1)

720. 0.004 1.925 ↑ 1.0 3 1

Hash (cost=50.39..50.39 rows=3 width=2,245) (actual time=1.925..1.925 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
721. 0.010 1.921 ↑ 1.0 3 1

Hash Left Join (cost=49.47..50.39 rows=3 width=2,245) (actual time=1.916..1.921 rows=3 loops=1)

  • Hash Cond: (ck_id.id = "KQ_ADV_CAMPAIGN_DURATION".k_id)
722. 0.010 1.868 ↑ 1.0 3 1

Hash Left Join (cost=49.37..50.25 rows=3 width=2,213) (actual time=1.864..1.868 rows=3 loops=1)

  • Hash Cond: (ck_id.id = "KQ_ADV_GOALS3".k_id)
723. 0.011 1.823 ↑ 1.0 3 1

Hash Right Join (cost=49.27..50.11 rows=3 width=2,181) (actual time=1.820..1.823 rows=3 loops=1)

  • Hash Cond: ("KQ_RE_MONTHLY_BUDGET".k_id = ck_id.id)
724. 0.011 0.011 ↓ 0.0 0 1

CTE Scan on "KQ_RE_MONTHLY_BUDGET" (cost=0.00..0.68 rows=34 width=36) (actual time=0.011..0.011 rows=0 loops=1)

725. 0.004 1.801 ↑ 1.0 3 1

Hash (cost=49.24..49.24 rows=3 width=2,149) (actual time=1.801..1.801 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
726. 0.021 1.797 ↑ 1.0 3 1

Hash Right Join (cost=48.40..49.24 rows=3 width=2,149) (actual time=1.795..1.797 rows=3 loops=1)

  • Hash Cond: ("KQ_JOB_ANNUAL_VACANCIES_RANGE".k_id = ck_id.id)
727. 0.010 0.010 ↓ 0.0 0 1

CTE Scan on "KQ_JOB_ANNUAL_VACANCIES_RANGE" (cost=0.00..0.68 rows=34 width=36) (actual time=0.010..0.010 rows=0 loops=1)

728. 0.004 1.766 ↑ 1.0 3 1

Hash (cost=48.36..48.36 rows=3 width=2,117) (actual time=1.766..1.766 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
729. 0.009 1.762 ↑ 1.0 3 1

Hash Right Join (cost=47.52..48.36 rows=3 width=2,117) (actual time=1.760..1.762 rows=3 loops=1)

  • Hash Cond: ("KQ_RE_OPTION_TYPE".k_id = ck_id.id)
730. 0.011 0.011 ↓ 0.0 0 1

CTE Scan on "KQ_RE_OPTION_TYPE" (cost=0.00..0.68 rows=34 width=36) (actual time=0.011..0.011 rows=0 loops=1)

731. 0.004 1.742 ↑ 1.0 3 1

Hash (cost=47.49..47.49 rows=3 width=2,085) (actual time=1.742..1.742 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
732. 0.010 1.738 ↑ 1.0 3 1

Hash Right Join (cost=46.65..47.49 rows=3 width=2,085) (actual time=1.736..1.738 rows=3 loops=1)

  • Hash Cond: ("KQ_CUST_RUBRIQUE".k_id = ck_id.id)
733. 0.014 0.014 ↓ 0.0 0 1

CTE Scan on "KQ_CUST_RUBRIQUE" (cost=0.00..0.68 rows=34 width=36) (actual time=0.014..0.014 rows=0 loops=1)

734. 0.004 1.714 ↑ 1.0 3 1

Hash (cost=46.61..46.61 rows=3 width=2,053) (actual time=1.714..1.714 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
735. 0.009 1.710 ↑ 1.0 3 1

Hash Right Join (cost=45.77..46.61 rows=3 width=2,053) (actual time=1.708..1.710 rows=3 loops=1)

  • Hash Cond: ("KQ_CAR_CONSULT_STAT".k_id = ck_id.id)
736. 0.011 0.011 ↓ 0.0 0 1

CTE Scan on "KQ_CAR_CONSULT_STAT" (cost=0.00..0.68 rows=34 width=36) (actual time=0.011..0.011 rows=0 loops=1)

737. 0.006 1.690 ↑ 1.0 3 1

Hash (cost=45.74..45.74 rows=3 width=2,021) (actual time=1.690..1.690 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
738. 0.008 1.684 ↑ 1.0 3 1

Hash Left Join (cost=44.78..45.74 rows=3 width=2,021) (actual time=1.678..1.684 rows=3 loops=1)

  • Hash Cond: (ck_id.id = "KQ_ADV_AGE_RANGE".k_id)
739. 0.014 1.661 ↑ 1.0 3 1

Hash Left Join (cost=44.68..45.60 rows=3 width=1,989) (actual time=1.656..1.661 rows=3 loops=1)

  • Hash Cond: (ck_id.id = "KQ_RE_FLOW_TYPE".k_id)
740. 0.010 1.576 ↑ 1.0 3 1

Hash Left Join (cost=44.58..45.46 rows=3 width=1,957) (actual time=1.572..1.576 rows=3 loops=1)

  • Hash Cond: (ck_id.id = "KQ_RE_ACTIVITIES".k_id)
741. 0.011 1.482 ↑ 1.0 3 1

Hash Right Join (cost=44.48..45.32 rows=3 width=1,925) (actual time=1.479..1.482 rows=3 loops=1)

  • Hash Cond: ("KQ_RE_LBC_ADSERVING_MODE_HOLY_RENTAL".k_id = ck_id.id)
742. 0.010 0.010 ↓ 0.0 0 1

CTE Scan on "KQ_RE_LBC_ADSERVING_MODE_HOLY_RENTAL" (cost=0.00..0.68 rows=34 width=36) (actual time=0.010..0.010 rows=0 loops=1)

743. 0.004 1.461 ↑ 1.0 3 1

Hash (cost=44.45..44.45 rows=3 width=1,893) (actual time=1.461..1.461 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
744. 0.009 1.457 ↑ 1.0 3 1

Hash Right Join (cost=43.61..44.45 rows=3 width=1,893) (actual time=1.455..1.457 rows=3 loops=1)

  • Hash Cond: ("KQ_JOB_CONTRACT".k_id = ck_id.id)
745. 0.012 0.012 ↓ 0.0 0 1

CTE Scan on "KQ_JOB_CONTRACT" (cost=0.00..0.68 rows=34 width=36) (actual time=0.011..0.012 rows=0 loops=1)

746. 0.004 1.436 ↑ 1.0 3 1

Hash (cost=43.57..43.57 rows=3 width=1,861) (actual time=1.435..1.436 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
747. 0.010 1.432 ↑ 1.0 3 1

Hash Right Join (cost=42.73..43.57 rows=3 width=1,861) (actual time=1.430..1.432 rows=3 loops=1)

  • Hash Cond: ("KQ_CUST_CREDITCARD_USE".k_id = ck_id.id)
748. 0.010 0.010 ↓ 0.0 0 1

CTE Scan on "KQ_CUST_CREDITCARD_USE" (cost=0.00..0.68 rows=34 width=36) (actual time=0.010..0.010 rows=0 loops=1)

749. 0.003 1.412 ↑ 1.0 3 1

Hash (cost=42.70..42.70 rows=3 width=1,829) (actual time=1.412..1.412 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
750. 0.011 1.409 ↑ 1.0 3 1

Hash Right Join (cost=41.86..42.70 rows=3 width=1,829) (actual time=1.406..1.409 rows=3 loops=1)

  • Hash Cond: ("KQ_RE_ANNUAL_OPTION_BUDGET".k_id = ck_id.id)
751. 0.012 0.012 ↓ 0.0 0 1

CTE Scan on "KQ_RE_ANNUAL_OPTION_BUDGET" (cost=0.00..0.68 rows=34 width=36) (actual time=0.012..0.012 rows=0 loops=1)

752. 0.005 1.386 ↑ 1.0 3 1

Hash (cost=41.82..41.82 rows=3 width=1,797) (actual time=1.386..1.386 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
753. 0.008 1.381 ↑ 1.0 3 1

Hash Left Join (cost=40.86..41.82 rows=3 width=1,797) (actual time=1.375..1.381 rows=3 loops=1)

  • Hash Cond: (ck_id.id = "KQ_ADV_GOALS2".k_id)
754. 0.008 1.283 ↑ 1.0 3 1

Hash Left Join (cost=40.76..41.68 rows=3 width=1,765) (actual time=1.277..1.283 rows=3 loops=1)

  • Hash Cond: (ck_id.id = "KQ_ADV_GENDER".k_id)
755. 0.010 1.247 ↑ 1.0 3 1

Hash Left Join (cost=40.66..41.54 rows=3 width=1,733) (actual time=1.242..1.247 rows=3 loops=1)

  • Hash Cond: (ck_id.id = "KQ_CUST_EMPLOYEES_RANGE".k_id)
756. 0.021 1.209 ↑ 1.0 3 1

Hash Right Join (cost=40.57..41.40 rows=3 width=1,701) (actual time=1.206..1.209 rows=3 loops=1)

  • Hash Cond: ("KQ_CAR_OPTION_PERCENT".k_id = ck_id.id)
757. 0.009 0.009 ↓ 0.0 0 1

CTE Scan on "KQ_CAR_OPTION_PERCENT" (cost=0.00..0.68 rows=34 width=36) (actual time=0.009..0.009 rows=0 loops=1)

758. 0.004 1.179 ↑ 1.0 3 1

Hash (cost=40.53..40.53 rows=3 width=1,669) (actual time=1.179..1.179 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
759. 0.023 1.175 ↑ 1.0 3 1

Hash Right Join (cost=39.69..40.53 rows=3 width=1,669) (actual time=1.160..1.175 rows=3 loops=1)

  • Hash Cond: ("KQ_CAR_SOFTWARE_LIST".k_id = ck_id.id)
760. 0.026 0.026 ↓ 0.0 0 1

CTE Scan on "KQ_CAR_SOFTWARE_LIST" (cost=0.00..0.68 rows=34 width=36) (actual time=0.026..0.026 rows=0 loops=1)

761. 0.004 1.126 ↑ 1.0 3 1

Hash (cost=39.65..39.65 rows=3 width=1,637) (actual time=1.125..1.126 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
762. 0.029 1.122 ↑ 1.0 3 1

Hash Right Join (cost=38.82..39.65 rows=3 width=1,637) (actual time=1.119..1.122 rows=3 loops=1)

  • Hash Cond: ("KQ_JOB_SOFTWARE_LEC_LIST".k_id = ck_id.id)
763. 0.026 0.026 ↓ 0.0 0 1

CTE Scan on "KQ_JOB_SOFTWARE_LEC_LIST" (cost=0.00..0.68 rows=34 width=36) (actual time=0.026..0.026 rows=0 loops=1)

764. 0.005 1.067 ↑ 1.0 3 1

Hash (cost=38.78..38.78 rows=3 width=1,605) (actual time=1.067..1.067 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
765. 0.010 1.062 ↑ 1.0 3 1

Hash Right Join (cost=37.94..38.78 rows=3 width=1,605) (actual time=1.060..1.062 rows=3 loops=1)

  • Hash Cond: ("KQ_RE_HOLIDAY_RENTAL".k_id = ck_id.id)
766. 0.012 0.012 ↓ 0.0 0 1

CTE Scan on "KQ_RE_HOLIDAY_RENTAL" (cost=0.00..0.68 rows=34 width=36) (actual time=0.012..0.012 rows=0 loops=1)

767. 0.005 1.040 ↑ 1.0 3 1

Hash (cost=37.90..37.90 rows=3 width=1,573) (actual time=1.040..1.040 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
768. 0.025 1.035 ↑ 1.0 3 1

Hash Left Join (cost=36.98..37.90 rows=3 width=1,573) (actual time=1.029..1.035 rows=3 loops=1)

  • Hash Cond: (ck_id.id = "KQ_ADV_COMMUNICATION_RADIUS".k_id)
769. 0.031 0.980 ↑ 1.0 3 1

Hash Left Join (cost=36.89..37.77 rows=3 width=1,541) (actual time=0.974..0.980 rows=3 loops=1)

  • Hash Cond: (ck_id.id = "KQ_ADV_GOALS".k_id)
770. 0.014 0.936 ↑ 1.0 3 1

Hash Right Join (cost=36.79..37.63 rows=3 width=1,509) (actual time=0.932..0.936 rows=3 loops=1)

  • Hash Cond: ("KQ_RE_RANGE".k_id = ck_id.id)
771. 0.027 0.027 ↓ 0.0 0 1

CTE Scan on "KQ_RE_RANGE" (cost=0.00..0.68 rows=34 width=36) (actual time=0.027..0.027 rows=0 loops=1)

772. 0.008 0.895 ↑ 1.0 3 1

Hash (cost=36.75..36.75 rows=3 width=1,477) (actual time=0.895..0.895 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
773. 0.030 0.887 ↑ 1.0 3 1

Hash Right Join (cost=35.91..36.75 rows=3 width=1,477) (actual time=0.884..0.887 rows=3 loops=1)

  • Hash Cond: ("KQ_CAR_ADSERVING_SUPPORT".k_id = ck_id.id)
774. 0.013 0.013 ↓ 0.0 0 1

CTE Scan on "KQ_CAR_ADSERVING_SUPPORT" (cost=0.00..0.68 rows=34 width=36) (actual time=0.013..0.013 rows=0 loops=1)

775. 0.005 0.844 ↑ 1.0 3 1

Hash (cost=35.88..35.88 rows=3 width=1,445) (actual time=0.844..0.844 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
776. 0.010 0.839 ↑ 1.0 3 1

Hash Right Join (cost=35.04..35.88 rows=3 width=1,445) (actual time=0.837..0.839 rows=3 loops=1)

  • Hash Cond: ("KQ_JOB_MANAGEMENT".k_id = ck_id.id)
777. 0.045 0.045 ↓ 0.0 0 1

CTE Scan on "KQ_JOB_MANAGEMENT" (cost=0.00..0.68 rows=34 width=36) (actual time=0.045..0.045 rows=0 loops=1)