icydb_core/db/query/explain/
json.rs1use crate::db::{
7 TraceReuseArtifactClass,
8 query::{
9 admission::QueryAdmissionSummary,
10 explain::{
11 ExplainExecutionNodeDescriptor, FinalizedQueryDiagnostics,
12 access_projection::write_access_json,
13 execution::{execution_mode_label, ordering_source_label},
14 nodes::{
15 execution_mode_detail_label, fast_path_reason, fast_path_selected,
16 predicate_pushdown_mode,
17 },
18 writer::JsonWriter,
19 },
20 },
21};
22
23impl ExplainExecutionNodeDescriptor {
24 #[must_use]
26 pub fn render_json_canonical(&self) -> String {
27 let mut out = String::new();
28 let mut node_id_counter = 0_u64;
29 write_execution_node_json(self, &mut node_id_counter, &mut out);
30 out
31 }
32}
33
34impl FinalizedQueryDiagnostics {
35 #[must_use]
37 pub(in crate::db) fn render_json_canonical(&self) -> String {
38 let mut out = String::new();
39 let mut object = JsonWriter::begin_object(&mut out);
40 object.field_with("admission", |out| match self.admission() {
41 Some(admission) => write_admission_json(admission, out),
42 None => out.push_str("null"),
43 });
44 object.field_with("execution", |out| {
45 let mut node_id_counter = 0_u64;
46 write_execution_node_json(self.execution(), &mut node_id_counter, out);
47 });
48 object.field_str_slice("route_diagnostics", &self.route_diagnostics);
49 object.field_str_slice("logical_diagnostics", &self.logical_diagnostics);
50 object.field_with("reuse", |out| {
51 let Some(reuse) = self.reuse else {
52 out.push_str("null");
53 return;
54 };
55 let mut reuse_object = JsonWriter::begin_object(out);
56 reuse_object.field_str(
57 "artifact",
58 match reuse.artifact_class() {
59 TraceReuseArtifactClass::SharedPreparedQueryPlan => {
60 "shared_prepared_query_plan"
61 }
62 },
63 );
64 reuse_object.field_str("outcome", if reuse.is_hit() { "hit" } else { "miss" });
65 reuse_object.finish();
66 });
67 object.finish();
68
69 out
70 }
71}
72
73fn write_admission_json(admission: &QueryAdmissionSummary, out: &mut String) {
74 let mut object = JsonWriter::begin_object(out);
75 object.field_str("lane", admission.lane().as_str());
76 object.field_str("decision", admission.decision().as_str());
77 match admission.rejection() {
78 Some(rejection) => object.field_str("reason", rejection.as_str()),
79 None => object.field_null("reason"),
80 }
81 object.field_str("plan_shape", admission.plan_shape().as_str());
82 object.field_str("selected_access", admission.selected_access().as_str());
83 match admission.selected_index() {
84 Some(selected_index) => object.field_str("selected_index", selected_index),
85 None => object.field_null("selected_index"),
86 }
87 write_optional_u32(&mut object, "limit", admission.limit());
88 write_optional_u32(&mut object, "offset", admission.offset());
89 write_optional_u64(&mut object, "scan_bound", admission.scan_bound());
90 object.field_str("scan_bound_kind", admission.scan_bound_kind().as_str());
91 write_optional_u32(
92 &mut object,
93 "returned_row_bound",
94 admission.returned_row_bound(),
95 );
96 object.field_str(
97 "returned_row_bound_kind",
98 admission.returned_row_bound_kind().as_str(),
99 );
100 write_optional_u32(
101 &mut object,
102 "response_byte_bound",
103 admission.response_byte_bound(),
104 );
105 object.field_str(
106 "response_byte_bound_kind",
107 admission.response_byte_bound_kind().as_str(),
108 );
109 object.field_str("residual_filter", admission.residual_filter().as_str());
110 object.field_str("ordering", admission.ordering().as_str());
111 object.field_with("materialization", |out| {
112 let materialization = admission.materialization();
113 let mut materialization_object = JsonWriter::begin_object(out);
114 materialization_object.field_bool("materialized_sort", materialization.materialized_sort());
115 write_optional_u32(
116 &mut materialization_object,
117 "materialized_rows",
118 materialization.materialized_rows(),
119 );
120 materialization_object
121 .field_str("row_bound_kind", materialization.row_bound_kind().as_str());
122 materialization_object.finish();
123 });
124 object.field_with("grouped", |out| {
125 let Some(grouped) = admission.grouped() else {
126 out.push_str("null");
127 return;
128 };
129 let mut grouped_object = JsonWriter::begin_object(out);
130 grouped_object.field_u64("group_field_count", u64::from(grouped.group_field_count()));
131 grouped_object.field_u64("aggregate_count", u64::from(grouped.aggregate_count()));
132 grouped_object.field_u64("max_groups", grouped.max_groups());
133 grouped_object.field_u64("max_group_bytes", grouped.max_group_bytes());
134 grouped_object.field_bool("having_filter", grouped.has_having_filter());
135 grouped_object.finish();
136 });
137 object.finish();
138}
139
140fn write_optional_u32(object: &mut JsonWriter<'_>, key: &str, value: Option<u32>) {
141 match value {
142 Some(value) => object.field_u64(key, u64::from(value)),
143 None => object.field_null(key),
144 }
145}
146
147fn write_optional_u64(object: &mut JsonWriter<'_>, key: &str, value: Option<u64>) {
148 match value {
149 Some(value) => object.field_u64(key, value),
150 None => object.field_null(key),
151 }
152}
153
154fn write_execution_node_json(
155 node: &ExplainExecutionNodeDescriptor,
156 node_id_counter: &mut u64,
157 out: &mut String,
158) {
159 let node_id = *node_id_counter;
160 *node_id_counter = node_id_counter.saturating_add(1);
161 let mut object = JsonWriter::begin_object(out);
162
163 object.field_u64("node_id", node_id);
164 object.field_str("node_type", node.node_type().as_str());
165 object.field_str("layer", node.node_type().layer_label());
166 object.field_str(
167 "execution_mode",
168 execution_mode_label(node.execution_mode()),
169 );
170 object.field_str(
171 "execution_mode_detail",
172 execution_mode_detail_label(node.execution_mode()),
173 );
174 object.field_with("access_strategy", |out| {
175 match node.access_strategy().as_ref() {
176 Some(access) => write_access_json(access, out),
177 None => out.push_str("null"),
178 }
179 });
180 object.field_str("predicate_pushdown_mode", predicate_pushdown_mode(node));
181 match node.predicate_pushdown() {
182 Some(predicate_pushdown) => object.field_str("predicate_pushdown", predicate_pushdown),
183 None => object.field_null("predicate_pushdown"),
184 }
185 match node.filter_expr() {
186 Some(filter_expr) => object.field_str("filter_expr", filter_expr),
187 None => object.field_null("filter_expr"),
188 }
189 match node.residual_filter_expr() {
190 Some(residual_filter_expr) => {
191 object.field_str("residual_filter_expr", residual_filter_expr);
192 }
193 None => object.field_null("residual_filter_expr"),
194 }
195 match fast_path_selected(node) {
196 Some(selected) => object.field_bool("fast_path_selected", selected),
197 None => object.field_null("fast_path_selected"),
198 }
199 match fast_path_reason(node) {
200 Some(reason) => object.field_str("fast_path_reason", reason),
201 None => object.field_null("fast_path_reason"),
202 }
203 match node.residual_filter_predicate() {
204 Some(residual_filter_predicate) => {
205 object.field_value_debug("residual_filter_predicate", residual_filter_predicate);
206 }
207 None => object.field_null("residual_filter_predicate"),
208 }
209 match node.projection() {
210 Some(projection) => object.field_str("projection", projection),
211 None => object.field_null("projection"),
212 }
213 match node.ordering_source() {
214 Some(ordering_source) => {
215 object.field_str("ordering_source", ordering_source_label(ordering_source));
216 }
217 None => object.field_null("ordering_source"),
218 }
219 match node.limit() {
220 Some(limit) => object.field_u64("limit", u64::from(limit)),
221 None => object.field_null("limit"),
222 }
223 match node.cursor() {
224 Some(cursor) => object.field_bool("cursor", cursor),
225 None => object.field_null("cursor"),
226 }
227 match node.covering_scan() {
228 Some(covering_scan) => object.field_bool("covering_scan", covering_scan),
229 None => object.field_null("covering_scan"),
230 }
231 match node.rows_expected() {
232 Some(rows_expected) => object.field_u64("rows_expected", rows_expected),
233 None => object.field_null("rows_expected"),
234 }
235 object.field_with("children", |out| {
236 out.push('[');
237 for (index, child) in node.children().iter().enumerate() {
238 if index > 0 {
239 out.push(',');
240 }
241 write_execution_node_json(child, node_id_counter, out);
242 }
243 out.push(']');
244 });
245 object.field_debug_map("node_properties", node.node_properties());
246
247 object.finish();
248}