explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7gQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.079 14.484 ↓ 0.0 0 1

Sort (cost=76,695.12..76,735.95 rows=16,331 width=154) (actual time=14.484..14.484 rows=0 loops=1)

  • Sort Key: collected_templates.callcase_uuid, collected_templates.ordernumber
  • Sort Method: quicksort Memory: 25kB
2.          

CTE subject_callcases

3. 0.001 14.263 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.28..123.17 rows=7 width=208) (actual time=14.263..14.263 rows=0 loops=1)

  • Join Filter: ((t1.case_uuid)::text = (mv_call_case.uuid)::text)
4. 14.262 14.262 ↓ 0.0 0 1

Index Scan using idx_mcc_creationdate on mv_call_case (cost=0.42..47.13 rows=7 width=142) (actual time=14.262..14.262 rows=0 loops=1)

  • Index Cond: ((creationdate >= '2019-02-07 07:00:00'::timestamp without time zone) AND (creationdate < '2019-02-07 07:30:00'::timestamp without time zone))
  • Filter: ((projectuuid)::text = 'corebo00000000000m5ooclt9jjo4238'::text)
5. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.85..13.49 rows=2 width=91) (never executed)

6. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.85..13.48 rows=2 width=91) (never executed)

7. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_der_out_ses_case on detail_outbound_sessions t2 (cost=0.43..4.58 rows=1 width=41) (never executed)

  • Index Cond: (case_uuid IS NULL)
  • Filter: ((attempt_start >= '2019-02-07 07:00:00'::timestamp without time zone) AND (attempt_start < '2019-02-07 07:30:00'::timestamp without time zone))
8. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_der_out_ses_case on detail_outbound_sessions t1 (cost=0.43..8.90 rows=1 width=91) (never executed)

  • Index Cond: ((case_uuid)::text = (t2.case_uuid)::text)
  • Filter: (attempt_start < t2.attempt_start)
9.          

SubPlan (forNested Loop Left Join)

10. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=8.90..8.91 rows=1 width=8) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_der_out_ses_case on detail_outbound_sessions (cost=0.43..8.89 rows=4 width=50) (never executed)

  • Index Cond: ((case_uuid)::text = (mv_call_case.uuid)::text)
12.          

CTE selector_value_codes

13. 0.001 0.025 ↓ 0.0 0 1

ProjectSet (cost=0.94..65.72 rows=2,300 width=178) (actual time=0.024..0.025 rows=0 loops=1)

14. 0.001 0.024 ↓ 0.0 0 1

Nested Loop (cost=0.94..53.70 rows=23 width=262) (actual time=0.024..0.024 rows=0 loops=1)

  • Join Filter: ((((mv_custom_form.jsondata -> (mv_custom_form_template.groupid)::text) -> (mv_custom_form_template.identifier_)::text) -> 'catalog'::text) IS NOT NULL)
15. 0.022 0.023 ↓ 0.0 0 1

Hash Join (cost=0.66..18.65 rows=1 width=299) (actual time=0.023..0.023 rows=0 loops=1)

  • Hash Cond: ((mv_custom_form.owneruuid)::text = (subject_callcases.uuid)::text)
16. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_custom_form_creat on mv_custom_form (cost=0.43..18.06 rows=95 width=168) (never executed)

  • Index Cond: ((creationdate >= '2019-02-07 07:00:00'::timestamp without time zone) AND (creationdate < '2019-02-07 07:30:00'::timestamp without time zone))
17. 0.000 0.001 ↓ 0.0 0 1

Hash (cost=0.14..0.14 rows=7 width=164) (actual time=0.001..0.001 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
18. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on subject_callcases (cost=0.00..0.14 rows=7 width=164) (actual time=0.001..0.001 rows=0 loops=1)

19. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_custom_form_template_id on mv_custom_form_template (cost=0.28..34.64 rows=23 width=78) (never executed)

  • Index Cond: ((projectuuid)::text = (subject_callcases.projectuuid)::text)
20.          

CTE selector_aggregated_values

21. 0.001 0.080 ↓ 0.0 0 1

WindowAgg (cost=631.73..632.05 rows=16 width=1,300) (actual time=0.080..0.080 rows=0 loops=1)

22. 0.023 0.079 ↓ 0.0 0 1

Sort (cost=631.73..631.77 rows=16 width=1,292) (actual time=0.079..0.079 rows=0 loops=1)

  • Sort Key: selector_value_codes.flex_id
  • Sort Method: quicksort Memory: 25kB
23. 0.001 0.056 ↓ 0.0 0 1

GroupAggregate (cost=631.01..631.41 rows=16 width=1,292) (actual time=0.056..0.056 rows=0 loops=1)

  • Group Key: selector_value_codes.callcase_uuid, selector_value_codes.callform_id, selector_value_codes.flex_id
24. 0.015 0.055 ↓ 0.0 0 1

Sort (cost=631.01..631.05 rows=16 width=788) (actual time=0.055..0.055 rows=0 loops=1)

  • Sort Key: selector_value_codes.callcase_uuid, selector_value_codes.callform_id, selector_value_codes.flex_id
  • Sort Method: quicksort Memory: 25kB
25. 0.002 0.040 ↓ 0.0 0 1

Merge Join (cost=588.51..630.69 rows=16 width=788) (actual time=0.040..0.040 rows=0 loops=1)

  • Merge Cond: ((selector_value_codes.cat_id = (mv_catalog_item.catalogcode)::text) AND (selector_value_codes.flex_valuecode = (mv_catalog_item.code)::text))
26. 0.013 0.038 ↓ 0.0 0 1

Sort (cost=174.43..180.18 rows=2,300 width=808) (actual time=0.038..0.038 rows=0 loops=1)

  • Sort Key: selector_value_codes.cat_id, selector_value_codes.flex_valuecode
  • Sort Method: quicksort Memory: 25kB
27. 0.025 0.025 ↓ 0.0 0 1

CTE Scan on selector_value_codes (cost=0.00..46.00 rows=2,300 width=808) (actual time=0.025..0.025 rows=0 loops=1)

28. 0.000 0.000 ↓ 0.0 0

Sort (cost=414.08..422.34 rows=3,303 width=83) (never executed)

  • Sort Key: mv_catalog_item.catalogcode, mv_catalog_item.code
29. 0.000 0.000 ↓ 0.0 0

Seq Scan on mv_catalog_item (cost=0.00..221.03 rows=3,303 width=83) (never executed)

30.          

CTE other_attributes

31. 0.006 0.018 ↓ 0.0 0 1

Append (cost=0.00..63,752.36 rows=16,086 width=150) (actual time=0.018..0.018 rows=0 loops=1)

32. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on subject_callcases subject_callcases_1 (cost=0.00..0.14 rows=7 width=634) (actual time=0.000..0.000 rows=0 loops=1)

33. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on subject_callcases subject_callcases_2 (cost=0.00..0.14 rows=7 width=200) (actual time=0.000..0.000 rows=0 loops=1)

34. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on subject_callcases subject_callcases_3 (cost=0.00..0.14 rows=7 width=634) (actual time=0.000..0.000 rows=0 loops=1)

35. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on subject_callcases subject_callcases_4 (cost=0.00..0.14 rows=7 width=634) (actual time=0.000..0.000 rows=0 loops=1)

36. 0.001 0.001 ↓ 0.0 0 1

Subquery Scan on *SELECT* 5 (cost=0.00..0.25 rows=7 width=150) (actual time=0.001..0.001 rows=0 loops=1)

37. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on subject_callcases subject_callcases_5 (cost=0.00..0.18 rows=7 width=150) (actual time=0.000..0.000 rows=0 loops=1)

38. 0.001 0.001 ↓ 0.0 0 1

Subquery Scan on *SELECT* 6 (cost=0.00..0.25 rows=7 width=150) (actual time=0.001..0.001 rows=0 loops=1)

39. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on subject_callcases subject_callcases_6 (cost=0.00..0.18 rows=7 width=150) (actual time=0.000..0.000 rows=0 loops=1)

40. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on subject_callcases subject_callcases_7 (cost=0.00..60.13 rows=7 width=336) (actual time=0.000..0.000 rows=0 loops=1)

41.          

SubPlan (forCTE Scan)

42. 0.000 0.000 ↓ 0.0 0

Index Scan using preaggregated_sessions_pkey on detail_outbound_sessions detail_outbound_sessions_3 (cost=0.55..8.57 rows=1 width=12) (never executed)

  • Index Cond: ((session_id)::text = (subject_callcases_7.last_attempt_id)::text)
43. 0.000 0.002 ↓ 0.0 0 1

Subquery Scan on *SELECT* 8 (cost=2.27..151.42 rows=7 width=150) (actual time=0.002..0.002 rows=0 loops=1)

44. 0.000 0.002 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.27..151.35 rows=7 width=150) (actual time=0.002..0.002 rows=0 loops=1)

45. 0.001 0.002 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.99..149.23 rows=7 width=137) (actual time=0.001..0.002 rows=0 loops=1)

46. 0.000 0.001 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.71..147.14 rows=7 width=148) (actual time=0.001..0.001 rows=0 loops=1)

47. 0.001 0.001 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.28..88.01 rows=7 width=123) (actual time=0.001..0.001 rows=0 loops=1)

48. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on subject_callcases subject_callcases_8 (cost=0.00..0.14 rows=7 width=90) (actual time=0.000..0.000 rows=0 loops=1)

49. 0.000 0.000 ↓ 0.0 0

Nested Loop Anti Join (cost=1.28..12.54 rows=1 width=66) (never executed)

50. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.86..11.87 rows=1 width=74) (never executed)

51. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mch_histuuid on mv_case_history t1_1 (cost=0.43..8.80 rows=4 width=49) (never executed)

  • Index Cond: ((historyuuid)::text = (subject_callcases_8.uuid)::text)
52. 0.000 0.000 ↓ 0.0 0

Index Scan using mv_pc_pk on mv_phone_call mpc_1 (cost=0.43..0.77 rows=1 width=41) (never executed)

  • Index Cond: (uuid = t1_1.inputcalluuid)
53. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mch_histuuid on mv_case_history t2_1 (cost=0.43..0.66 rows=1 width=41) (never executed)

  • Index Cond: ((t1_1.historyuuid)::text = (historyuuid)::text)
  • Filter: ((inputcalluuid IS NOT NULL) AND (uuid > t1_1.uuid))
54. 0.000 0.000 ↓ 0.0 0

Index Scan using mv_pc_pk on mv_phone_call mpc (cost=0.43..8.45 rows=1 width=41) (never executed)

  • Index Cond: (uuid = subject_callcases_8.lastcall)
55. 0.000 0.000 ↓ 0.0 0

Index Scan using mv_catitem_pk on mv_catalog_item mci (cost=0.28..0.30 rows=1 width=55) (never executed)

  • Index Cond: ((uuid)::text = (mpc.calldispositionuuid)::text)
56. 0.000 0.000 ↓ 0.0 0

Index Scan using mv_catitem_pk on mv_catalog_item mci2 (cost=0.28..0.30 rows=1 width=55) (never executed)

  • Index Cond: ((uuid)::text = (mpc_1.calldispositionuuid)::text)
57. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on subject_callcases subject_callcases_9 (cost=0.00..120.23 rows=7 width=336) (actual time=0.000..0.000 rows=0 loops=1)

58.          

SubPlan (forCTE Scan)

59. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.11..17.16 rows=1 width=10) (never executed)

  • Join Filter: ((mv_phone_call_1.sessionid)::text = (detail_outbound_sessions_2.session_id)::text)
60. 0.000 0.000 ↓ 0.0 0

Index Scan using preaggregated_sessions_pkey on detail_outbound_sessions detail_outbound_sessions_2 (cost=0.55..8.57 rows=1 width=60) (never executed)

  • Index Cond: ((session_id)::text = (subject_callcases_9.last_attempt_id)::text)
61. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mpc_sid on mv_phone_call mv_phone_call_1 (cost=0.56..8.57 rows=1 width=83) (never executed)

  • Index Cond: ((sessionid)::text = (subject_callcases_9.last_attempt_id)::text)
62. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on subject_callcases subject_callcases_10 (cost=0.00..120.23 rows=7 width=634) (actual time=0.000..0.000 rows=0 loops=1)

63.          

SubPlan (forCTE Scan)

64. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.11..17.16 rows=1 width=36) (never executed)

  • Join Filter: ((mv_phone_call.sessionid)::text = (detail_outbound_sessions_1.session_id)::text)
65. 0.000 0.000 ↓ 0.0 0

Index Only Scan using preaggregated_sessions_pkey on detail_outbound_sessions detail_outbound_sessions_1 (cost=0.55..8.57 rows=1 width=50) (never executed)

  • Index Cond: (session_id = (subject_callcases_10.last_attempt_id)::text)
  • Heap Fetches: 0
66. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mpc_sid on mv_phone_call (cost=0.56..8.57 rows=1 width=86) (never executed)

  • Index Cond: ((sessionid)::text = (subject_callcases_10.last_attempt_id)::text)
67. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on subject_callcases subject_callcases_11 (cost=0.00..0.14 rows=7 width=634) (actual time=0.000..0.000 rows=0 loops=1)

68. 0.001 0.001 ↓ 0.0 0 1

Subquery Scan on *SELECT* 12 (cost=0.00..0.23 rows=7 width=150) (actual time=0.001..0.001 rows=0 loops=1)

69. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on subject_callcases subject_callcases_12 (cost=0.00..0.16 rows=7 width=150) (actual time=0.000..0.000 rows=0 loops=1)

70. 0.000 0.001 ↓ 0.0 0 1

Subquery Scan on *SELECT* 13 (cost=0.56..9,018.13 rows=2,286 width=150) (actual time=0.001..0.001 rows=0 loops=1)

71. 0.001 0.001 ↓ 0.0 0 1

Nested Loop (cost=0.56..8,995.27 rows=2,286 width=150) (actual time=0.001..0.001 rows=0 loops=1)

72. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on subject_callcases subject_callcases_13 (cost=0.00..0.14 rows=7 width=90) (actual time=0.000..0.000 rows=0 loops=1)

73. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_custom_form_owner on mv_custom_form mcf (cost=0.56..1,280.93 rows=327 width=33) (never executed)

  • Index Cond: ((owneruuid)::text = (subject_callcases_13.uuid)::text)
  • Filter: (NOT removed)
74. 0.000 0.001 ↓ 0.0 0 1

Subquery Scan on *SELECT* 14 (cost=0.56..9,023.85 rows=2,286 width=150) (actual time=0.001..0.001 rows=0 loops=1)

75. 0.001 0.001 ↓ 0.0 0 1

Nested Loop (cost=0.56..9,000.99 rows=2,286 width=150) (actual time=0.001..0.001 rows=0 loops=1)

76. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on subject_callcases subject_callcases_14 (cost=0.00..0.14 rows=7 width=82) (actual time=0.000..0.000 rows=0 loops=1)

77. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_custom_form_owner on mv_custom_form mcf_1 (cost=0.56..1,280.93 rows=327 width=168) (never executed)

  • Index Cond: ((owneruuid)::text = (subject_callcases_14.uuid)::text)
  • Filter: (NOT removed)
78. 0.000 0.001 ↓ 0.0 0 1

Subquery Scan on *SELECT* 15 (cost=0.56..9,046.71 rows=2,286 width=150) (actual time=0.001..0.001 rows=0 loops=1)

79. 0.001 0.001 ↓ 0.0 0 1

Nested Loop (cost=0.56..9,023.85 rows=2,286 width=150) (actual time=0.001..0.001 rows=0 loops=1)

80. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on subject_callcases subject_callcases_15 (cost=0.00..0.14 rows=7 width=82) (actual time=0.000..0.000 rows=0 loops=1)

81. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_custom_form_owner on mv_custom_form mcf_2 (cost=0.56..1,280.93 rows=327 width=168) (never executed)

  • Index Cond: ((owneruuid)::text = (subject_callcases_15.uuid)::text)
  • Filter: (NOT removed)
82. 0.000 0.001 ↓ 0.0 0 1

Subquery Scan on *SELECT* 16 (cost=0.56..9,023.85 rows=2,286 width=150) (actual time=0.001..0.001 rows=0 loops=1)

83. 0.001 0.001 ↓ 0.0 0 1

Nested Loop (cost=0.56..9,000.99 rows=2,286 width=150) (actual time=0.001..0.001 rows=0 loops=1)

84. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on subject_callcases subject_callcases_16 (cost=0.00..0.14 rows=7 width=82) (actual time=0.000..0.000 rows=0 loops=1)

85. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_custom_form_owner on mv_custom_form mcf_3 (cost=0.56..1,280.93 rows=327 width=168) (never executed)

  • Index Cond: ((owneruuid)::text = (subject_callcases_16.uuid)::text)
  • Filter: (NOT removed)
86. 0.000 0.001 ↓ 0.0 0 1

Subquery Scan on *SELECT* 17 (cost=0.56..9,081.00 rows=2,286 width=150) (actual time=0.001..0.001 rows=0 loops=1)

87. 0.001 0.001 ↓ 0.0 0 1

Nested Loop (cost=0.56..9,058.14 rows=2,286 width=150) (actual time=0.001..0.001 rows=0 loops=1)

88. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on subject_callcases subject_callcases_17 (cost=0.00..0.14 rows=7 width=82) (actual time=0.000..0.000 rows=0 loops=1)

89. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_custom_form_owner on mv_custom_form mcf_4 (cost=0.56..1,280.93 rows=327 width=168) (never executed)

  • Index Cond: ((owneruuid)::text = (subject_callcases_17.uuid)::text)
  • Filter: (NOT removed)
90. 0.000 0.001 ↓ 0.0 0 1

Subquery Scan on *SELECT* 18 (cost=0.56..9,023.85 rows=2,286 width=150) (actual time=0.001..0.001 rows=0 loops=1)

91. 0.001 0.001 ↓ 0.0 0 1

Nested Loop (cost=0.56..9,000.99 rows=2,286 width=150) (actual time=0.001..0.001 rows=0 loops=1)

92. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on subject_callcases subject_callcases_18 (cost=0.00..0.14 rows=7 width=82) (actual time=0.000..0.000 rows=0 loops=1)

93. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_custom_form_owner on mv_custom_form mcf_5 (cost=0.56..1,280.93 rows=327 width=168) (never executed)

  • Index Cond: ((owneruuid)::text = (subject_callcases_18.uuid)::text)
  • Filter: (NOT removed)
94. 0.000 0.001 ↓ 0.0 0 1

Subquery Scan on *SELECT* 19 (cost=0.56..9,081.00 rows=2,286 width=150) (actual time=0.001..0.001 rows=0 loops=1)

95. 0.001 0.001 ↓ 0.0 0 1

Nested Loop (cost=0.56..9,058.14 rows=2,286 width=150) (actual time=0.000..0.001 rows=0 loops=1)

96. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on subject_callcases subject_callcases_19 (cost=0.00..0.14 rows=7 width=82) (actual time=0.000..0.000 rows=0 loops=1)

97. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_custom_form_owner on mv_custom_form mcf_6 (cost=0.56..1,280.93 rows=327 width=168) (never executed)

  • Index Cond: ((owneruuid)::text = (subject_callcases_19.uuid)::text)
  • Filter: (NOT removed)
98.          

CTE text_attributes

99. 0.004 14.300 ↓ 0.0 0 1

WindowAgg (cost=10,116.55..10,122.28 rows=229 width=145) (actual time=14.300..14.300 rows=0 loops=1)

100. 0.027 14.296 ↓ 0.0 0 1

Sort (cost=10,116.55..10,117.12 rows=229 width=262) (actual time=14.296..14.296 rows=0 loops=1)

  • Sort Key: mv_custom_form_template_1.title
  • Sort Method: quicksort Memory: 25kB
101. 0.001 14.269 ↓ 0.0 0 1

Hash Join (cost=136.38..10,107.58 rows=229 width=262) (actual time=14.269..14.269 rows=0 loops=1)

  • Hash Cond: ((subject_callcases_20.projectuuid)::text = (mv_custom_form_template_1.projectuuid)::text)
  • Join Filter: ((((mv_custom_form_1.jsondata -> (mv_custom_form_template_1.groupid)::text) -> (mv_custom_form_template_1.identifier_)::text) ->> 'value'::text) IS NULL)
102. 0.004 14.268 ↓ 0.0 0 1

Nested Loop (cost=0.56..8,989.56 rows=2,286 width=299) (actual time=14.268..14.268 rows=0 loops=1)

103. 14.264 14.264 ↓ 0.0 0 1

CTE Scan on subject_callcases subject_callcases_20 (cost=0.00..0.14 rows=7 width=164) (actual time=14.264..14.264 rows=0 loops=1)

104. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_custom_form_owner on mv_custom_form mv_custom_form_1 (cost=0.56..1,280.93 rows=327 width=168) (never executed)

  • Index Cond: ((owneruuid)::text = (subject_callcases_20.uuid)::text)
  • Filter: (NOT removed)
105. 0.000 0.000 ↓ 0.0 0

Hash (cost=110.60..110.60 rows=2,018 width=78) (never executed)

106. 0.000 0.000 ↓ 0.0 0

Seq Scan on mv_custom_form_template mv_custom_form_template_1 (cost=0.00..110.60 rows=2,018 width=78) (never executed)

  • Filter: ((title)::text <> 'Ответ'::text)
107.          

CTE collected_templates

108. 0.002 14.403 ↓ 0.0 0 1

Append (cost=0.00..530.15 rows=16,331 width=154) (actual time=14.403..14.403 rows=0 loops=1)

109. 14.300 14.300 ↓ 0.0 0 1

CTE Scan on text_attributes (cost=0.00..4.58 rows=229 width=638) (actual time=14.300..14.300 rows=0 loops=1)

110. 0.082 0.082 ↓ 0.0 0 1

CTE Scan on selector_aggregated_values (cost=0.00..0.32 rows=16 width=638) (actual time=0.082..0.082 rows=0 loops=1)

111. 0.000 0.019 ↓ 0.0 0 1

Subquery Scan on *SELECT* 3 (cost=0.00..522.80 rows=16,086 width=154) (actual time=0.019..0.019 rows=0 loops=1)

112. 0.019 0.019 ↓ 0.0 0 1

CTE Scan on other_attributes (cost=0.00..321.72 rows=16,086 width=150) (actual time=0.018..0.019 rows=0 loops=1)

113. 14.405 14.405 ↓ 0.0 0 1

CTE Scan on collected_templates (cost=0.00..326.62 rows=16,331 width=154) (actual time=14.405..14.405 rows=0 loops=1)