查询请求分析
更新时间：2026-01-08
查询请求分析
接口描述
本接口用于查询请求分析。
请求结构
Plain Text
1GET /v{version}ddc/ob/instance/{instanceId}/tenant/{tenantId}/sqls/digest?startTime=2025-12-24T06%3A46%3A00Z&endTime=2025-12-24T07%3A46%3A00Z HTTP/1.1
2Host: ddc.bj.baidubce.com
3Authorization: authorization string请求头域
除公共头域外，无其它特殊头域。
请求参数
| 参数名称 | 类型 | 是否必选 | 参数位置 | 描述 |
|---|---|---|---|---|
| version | String | 是 | URL参数 | API版本号。 |
| instanceId | String | 是 | URL参数 | 集群ID。 |
| tenantId | String | 是 | URL参数 | 租户ID。 |
| startTime | String | 是 | Query参数 | 开始时间。格式：2025-11-24T21:14:57Z。 |
| endTime | String | 是 | Query参数 | 结束时间。格式：2025-11-24T21:14:57Z。 |
| dbName | String | 否 | Query参数 | 数据库名。 |
响应头域
除公共头域外，无其它特殊头域。
响应参数
| 参数名称 | 类型 | 描述 |
|---|---|---|
| executionStat | List<ExecutionStatItem> | 执行次数统计。 |
| databaseStat | List<DatabaseStat> | 数据库维度的执行次数统计。 |
| tableStat | List<TableStat> | 表维度的执行次数统计。 |
| sqlStat | List<SqlStat> | SQL维度的执行次数统计。 |
ExecutionStatItem
| 参数名称 | 类型 | 描述 |
|---|---|---|
| time | string | 采样点时间 |
| sqlTypeStats | List<SqlTypeStat> | 按SqlType和响应时间区间的执行次数统计 |
SqlTypeStat
| 参数名称 | 类型 | 描述 |
|---|---|---|
| minElapsedTimeMs | Long | 响应时间区间的下边界（毫秒） |
| maxElapsedTimeMs | Long | 响应时间区间的上边界（毫秒），null表示无上限 |
| selectCount | Long | SELECT语句的执行次数 |
| insertCount | Long | INSERT语句的执行次数 |
| replaceCount | Long | REPLACE语句的执行次数 |
| deleteCount | Long | DELETE语句的执行次数 |
| updateCount | Long | UPDATE语句的执行次数 |
| otherCount | Long | 其他类型SQL的执行次数 |
| totalCount | Long | 总执行次数 |
DatabaseStat
| 参数名称 | 类型 | 描述 |
|---|---|---|
| dbName | String | 数据库名称 |
| sqlType | String | SQL类型，当该字段为空时，表示Total |
| total | Boolean | 是否是统计整体数据 |
| avgElapsedTime | Double | 平均响应时间 |
| elapsedTimeRatio | Double | 响应时间占比 |
| elapsedTime | Double | 该数据库该类型SQL的总响应时间 |
| sumElapsedTime | Double | 所有数据库该类型SQL的总响应时间 |
| executions | Double | 该数据库下该类型SQL的总执行次数 |
| sumExecutions | Double | 所有数据库下该类型SQL的总执行次数 |
| executionRatio | Double | 执行次数占比 |
| executionRatioOfType | Double | 某一个SQL类型执行次数/该数据库下所有SQL类型执行次数的占比 |
| elapsedTimeTrend | List<ElapsedTimeTrendItem> | 响应时间趋势 |
TableStat
| 参数名称 | 类型 | 描述 |
|---|---|---|
| tableName | String | 表名 |
| sqlType | String | SQL类型，当该字段为空时，表示Total |
| total | Boolean | 是否是统计整体数据 |
| avgElapsedTime | Double | 平均响应时间 |
| elapsedTimeRatio | Double | 响应时间占比 |
| elapsedTimeOfType | Double | 该表某一个SQL类型的总响应时间 |
| executionsOfType | Double | 该表在某一个SQL类型总的执行次数 |
| executionRatioOfType | Double | 某一个SQL类型执行次数/该表下所有SQL类型执行次数的占比 |
| sumElapsedTime | Double | 该表所有SQL类型的总响应时间 |
| sumExecutions | Double | 该表所有SQL类型的总的执行次数 |
| executionRatio | Double | 执行次数占比 |
| elapsedTimeTrend | List<ElapsedTimeTrendItem> | 响应时间趋势 |
SqlStat
| 参数名称 | 类型 | 描述 |
|---|---|---|
| databaseName | String | 数据库名 |
| exeDatabaseName | String | 执行数据库名 |
| tableName | String | 表名 |
| sqlId | String | SQL语句ID |
| sqlText | String | SQL语句文本 |
| sqlType | String | SQL类型，当该字段为空时，表示Total |
| total | Boolean | 是否是统计整体数据 |
| avgElapsedTime | Double | 平均响应时间 |
| elapsedTimeRatio | Double | 响应时间占比 |
| elapsedTimeOfSql | Double | 该库/表 当前sql的总响应时间 |
| executionsOfSql | Double | 该库/表 当前sql总的执行次数 |
| executionRatio | Double | 执行次数占比 |
| sumElapsedTime | Double | 该库/表 所有sql的总响应时间 |
| sumExecutions | Double | 该库/表 所有sql的总的执行次数 |
| elapsedTimeTrend | List<ElapsedTimeTrendItem> | 响应时间趋势 |
ElapsedTimeTrendItem
| 参数名称 | 类型 | 描述 |
|---|---|---|
| time | String | 采样点时间 |
| avgElapsedTime | Long | 平均响应时间 |
请求示例
Plain Text
1GET http://ddc.bj.baidubce.com/v1/ddc/ob/instance/ob7cpcvj73o934/tenant/t7cpiwq9ketb4/sqls/digest?startTime=2025-12-24T06:46:00Z&endTime=2025-12-24T07:46:00Z
2Host: ddc.bj.baidubce.com
3Authorization: bce-auth-v1/f81d3b34e48048fbb2634dc7882d7e21/2015-08-11T04:17:29Z/3600/host/74c506f68c65e26c633bfa104c863fffac5190fdec1ec24b7c03eb5d67d2e1de响应示例
Plain Text
1HTTP/1.1 200 OK
2Content-Type: application/json;charset=UTF-8
3Date: Wed, 08 Jul 2015 03:28:11 GMT
4x-bce-request-id: d8752367-38e8-45e4-b4c7-e53be3137ce5
5Server: BWS
6{
7 "executionStat": [
8 {
9 "time": "2025-12-24T06:46:00Z",
10 "sqlTypeStats": []
11 },
12 {
13 "time": "2025-12-24T06:50:00Z",
14 "sqlTypeStats": []
15 },
16 {
17 "time": "2025-12-24T06:54:00Z",
18 "sqlTypeStats": []
19 },
20 {
21 "time": "2025-12-24T06:58:00Z",
22 "sqlTypeStats": []
23 },
24 {
25 "time": "2025-12-24T07:02:00Z",
26 "sqlTypeStats": []
27 },
28 {
29 "time": "2025-12-24T07:06:00Z",
30 "sqlTypeStats": [
31 {
32 "minElapsedTimeMs": 0,
33 "maxElapsedTimeMs": 10,
34 "selectCount": 1,
35 "insertCount": 0,
36 "replaceCount": 0,
37 "deleteCount": 0,
38 "updateCount": 0,
39 "otherCount": 3,
40 "totalCount": 4
41 },
42 {
43 "minElapsedTimeMs": 100,
44 "maxElapsedTimeMs": 500,
45 "selectCount": 0,
46 "insertCount": 0,
47 "replaceCount": 0,
48 "deleteCount": 0,
49 "updateCount": 0,
50 "otherCount": 1,
51 "totalCount": 1
52 }
53 ]
54 },
55 {
56 "time": "2025-12-24T07:10:00Z",
57 "sqlTypeStats": [
58 {
59 "minElapsedTimeMs": 0,
60 "maxElapsedTimeMs": 10,
61 "selectCount": 1,
62 "insertCount": 2,
63 "replaceCount": 0,
64 "deleteCount": 0,
65 "updateCount": 0,
66 "otherCount": 0,
67 "totalCount": 3
68 }
69 ]
70 },
71 {
72 "time": "2025-12-24T07:14:00Z",
73 "sqlTypeStats": []
74 }
75 ],
76 "databaseStat": [
77 {
78 "dbName": "clltestdb",
79 "sqlType": "SELECT",
80 "total": false,
81 "avgElapsedTime": 2.76,
82 "elapsedTimeRatio": 1.0,
83 "elapsedTime": 5.53,
84 "sumElapsedTime": 5.53,
85 "executions": 2.0,
86 "sumExecutions": 2.0,
87 "executionRatio": 1.0,
88 "executionRatioOfType": 0.25,
89 "elapsedTimeTrend": [
90 {
91 "time": "2025-12-24T07:10:00Z",
92 "avgElapsedTime": 0
93 },
94 {
95 "time": "2025-12-24T07:14:00Z",
96 "avgElapsedTime": 5
97 }
98 ]
99 },
100 {
101 "dbName": "clltestdb",
102 "sqlType": "OTHER",
103 "total": false,
104 "avgElapsedTime": 53.78,
105 "elapsedTimeRatio": 1.0,
106 "elapsedTime": 215.12,
107 "sumElapsedTime": 215.12,
108 "executions": 4.0,
109 "sumExecutions": 4.0,
110 "executionRatio": 1.0,
111 "executionRatioOfType": 0.5,
112 "elapsedTimeTrend": [
113 {
114 "time": "2025-12-24T07:10:00Z",
115 "avgElapsedTime": 209
116 }
117 ]
118 },
119 {
120 "dbName": "clltestdb",
121 "sqlType": "INSERT",
122 "total": false,
123 "avgElapsedTime": 4.36,
124 "elapsedTimeRatio": 1.0,
125 "elapsedTime": 8.71,
126 "sumElapsedTime": 8.71,
127 "executions": 2.0,
128 "sumExecutions": 2.0,
129 "executionRatio": 1.0,
130 "executionRatioOfType": 0.25,
131 "elapsedTimeTrend": [
132 {
133 "time": "2025-12-24T07:14:00Z",
134 "avgElapsedTime": 4
135 }
136 ]
137 },
138 {
139 "dbName": "clltestdb",
140 "sqlType": null,
141 "total": true,
142 "avgElapsedTime": 28.67,
143 "elapsedTimeRatio": 1.0,
144 "elapsedTime": 229.36,
145 "sumElapsedTime": 229.36,
146 "executions": 8.0,
147 "sumExecutions": 8.0,
148 "executionRatio": 1.0,
149 "executionRatioOfType": null,
150 "elapsedTimeTrend": [
151 {
152 "time": "2025-12-24T07:10:00Z",
153 "avgElapsedTime": 43
154 },
155 {
156 "time": "2025-12-24T07:14:00Z",
157 "avgElapsedTime": 4
158 }
159 ]
160 }
161 ],
162 "tableStat": [
163 {
164 "tableName": "users",
165 "sqlType": "SELECT",
166 "total": false,
167 "avgElapsedTime": 5.05,
168 "elapsedTimeRatio": 0.91,
169 "elapsedTimeOfType": 5.05,
170 "executionsOfType": 1.0,
171 "executionRatioOfType": 0.25,
172 "elapsedTimeTrend": [
173 {
174 "time": "2025-12-24T07:14:00Z",
175 "avgElapsedTime": 5
176 }
177 ]
178 },
179 {
180 "tableName": "users",
181 "sqlType": "OTHER",
182 "total": false,
183 "avgElapsedTime": 209.8,
184 "elapsedTimeRatio": 0.98,
185 "elapsedTimeOfType": 209.8,
186 "executionsOfType": 1.0,
187 "executionRatioOfType": 0.25,
188 "elapsedTimeTrend": [
189 {
190 "time": "2025-12-24T07:10:00Z",
191 "avgElapsedTime": 209
192 }
193 ]
194 },
195 {
196 "tableName": "users",
197 "sqlType": "INSERT",
198 "total": false,
199 "avgElapsedTime": 4.36,
200 "elapsedTimeRatio": 1.0,
201 "elapsedTimeOfType": 8.71,
202 "executionsOfType": 2.0,
203 "executionRatioOfType": 0.5,
204 "elapsedTimeTrend": [
205 {
206 "time": "2025-12-24T07:14:00Z",
207 "avgElapsedTime": 4
208 }
209 ]
210 },
211 {
212 "tableName": "users",
213 "total": true,
214 "avgElapsedTime": 55.89,
215 "elapsedTimeRatio": 0.97,
216 "sumElapsedTime": 223.56,
217 "sumExecutions": 4.0,
218 "executionRatio": 0.5,
219 "elapsedTimeTrend": [
220 {
221 "time": "2025-12-24T07:10:00Z",
222 "avgElapsedTime": 209
223 },
224 {
225 "time": "2025-12-24T07:14:00Z",
226 "avgElapsedTime": 4
227 }
228 ]
229 }
230 ],
231 "sqlStat": [
232 {
233 "databaseName": "clltestdb",
234 "exeDatabaseName": "clltestdb",
235 "tableName": "users",
236 "sqlId": "BB9C0634B57A73F27671FD5A598EB080",
237 "sqlText": "CREATE TABLE users (\n id INT NOT NULL AUTO_INCREMENT,\n username VARCHAR(50) NOT NULL,\n emai",
238 "sqlType": "OTHER",
239 "total": false,
240 "avgElapsedTime": 209.8,
241 "elapsedTimeRatio": 0.94,
242 "elapsedTimeOfSql": 209.8,
243 "executionsOfSql": 1.0,
244 "executionRatio": 0.25,
245 "elapsedTimeTrend": [
246 {
247 "time": "2025-12-24T07:10:00Z",
248 "avgElapsedTime": 209
249 }
250 ]
251 },
252 {
253 "databaseName": "clltestdb",
254 "exeDatabaseName": "clltestdb",
255 "tableName": "users",
256 "sqlId": "ECA0DA3224EE1CAAEC974E1C9CAE9F39",
257 "sqlText": "INSERT INTO users(username, email, created_at)\nVALUES (?, ?, ?)",
258 "sqlType": "INSERT",
259 "total": false,
260 "avgElapsedTime": 1.1,
261 "elapsedTimeRatio": 0.0,
262 "elapsedTimeOfSql": 1.1,
263 "executionsOfSql": 1.0,
264 "executionRatio": 0.25,
265 "elapsedTimeTrend": [
266 {
267 "time": "2025-12-24T07:14:00Z",
268 "avgElapsedTime": 1
269 }
270 ]
271 },
272 {
273 "databaseName": "clltestdb",
274 "exeDatabaseName": "clltestdb",
275 "tableName": "users",
276 "sqlId": "19A1F14EFC0F221D30AFCB1E1344BEBD",
277 "sqlText": "select * from users",
278 "sqlType": "SELECT",
279 "total": false,
280 "avgElapsedTime": 5.05,
281 "elapsedTimeRatio": 0.02,
282 "elapsedTimeOfSql": 5.05,
283 "executionsOfSql": 1.0,
284 "executionRatio": 0.25,
285 "elapsedTimeTrend": [
286 {
287 "time": "2025-12-24T07:14:00Z",
288 "avgElapsedTime": 5
289 }
290 ]
291 },
292 {
293 "databaseName": "clltestdb",
294 "exeDatabaseName": "clltestdb",
295 "tableName": "users",
296 "sqlId": "B5B0A3B03418D06A92A84DC09ADFDC2A",
297 "sqlText": "INSERT INTO users (username, email, created_at) \nVALUES (?, ?, ?)",
298 "sqlType": "INSERT",
299 "total": false,
300 "avgElapsedTime": 7.61,
301 "elapsedTimeRatio": 0.03,
302 "elapsedTimeOfSql": 7.61,
303 "executionsOfSql": 1.0,
304 "executionRatio": 0.25,
305 "elapsedTimeTrend": [
306 {
307 "time": "2025-12-24T07:14:00Z",
308 "avgElapsedTime": 7
309 }
310 ]
311 },
312 {
313 "total": true,
314 "sumElapsedTime": 223.56,
315 "sumExecutions": 4.0
316 }
317 ]
318}评价此篇文章