数据库工作台
数据库工作台
文档指南
请输入
- 文档首页
数据库工作台API参考运维管理SQL 洞察与审计DescribeSqlTemplatesContrast
复制全文
下载 pdfDescribeSqlTemplatesContrast
文档反馈
问问助手调用 DescribeSqlTemplatesContrast 接口查询两个时间段内全量 SQL 模板的聚合指标对比。
请求类型
同步请求。
请求参数
返回参数
请求示例
POST /?Action=DescribeSqlTemplatesContrast&Version=2018-01-01 HTTP/1.1
Content-Type: application/json
Host: dbw.cn-beijing.volcengineapi.com
Authorization: HMAC-SHA256 Credential=AKLTN2I0MmFiNzMxNWE5NDgzMzk4MmVjMTVkODlkZTZ****/20211202/cn-beijing/dbw/request,SignedHeaders=x-date, Signature=71d31fc7bcf990142851c9833c5656391486cda0ae2e0b8ada733b7c645****
{
"InstanceId": "mysql-cf8d83a2ea63",
"InstanceType": "MySQL",
"FirstStartTime": 1787562620,
"FirstEndTime": 1787566220,
"SecondStartTime": 1787562620,
"SecondEndTime": 1787566220,
"SortBy": "DESC",
"OrderBy": "ExecTime",
"DbName": "test_a",
"Tables": [
"-",
"example",
"SCHEMATA",
"TABLES",
"KEY_COLUMN_USAGE",
"REFERENTIAL_CONSTRAINTS",
"tables"
],
"NodeId": "mysql-cf8d83a2ea63-sb2e3-0",
"SqlCommands": [
"Connect",
"SET_OPTION",
"SELECT",
"SHOW_FIELDS",
"SHOW_KEYS",
"SHOW_CREATE",
"Quit",
"CREATE_TABLE"
],
"CollectSqlFingerprint": false,
"RegionId": "cn-beijing"
}
返回示例
{
"ResponseMetadata": {
"RequestId": "2026082418112882C3F79E243440D87214-15e625",
"Action": "DescribeSqlTemplatesContrast",
"Version": "2018-01-01",
"Service": "dbw",
"Region": "cn-beijing"
},
"Result": {
"Details": [
{
"DbName": "test_a",
"FirstTemplatesDetail": {
"BinlogSyncTime": 0,
"BytesSent": 0,
"CclWaitTime": 0,
"Count": 2,
"CpuTime": 490,
"DBName": "test_zhudi",
"ExecTime": 794,
"GroupFollowerWaitTime": 0,
"InnodbIoReadBytes": 0,
"InnodbIoReads": 0,
"InnodbPageAccess": 16,
"InstanceID": "mysql-cf8d83a2ea63",
"IsCollectSqlFingerprint": false,
"LatchWaitTime": 0,
"MdlWaitTime": 0,
"RedoLogFlushTime": 0,
"RowlockWaitTime": 0,
"RowsAffected": 0,
"RowsExamined": 4,
"RowsSent": 0,
"SemiSyncWaitTime": 0,
"ServerPort": "",
"SocketSendTime": 0,
"SqlFingerprint": "01c4dbcc021b24e3beff902d78115f5e",
"SqlTable": "TABLES",
"SqlTemplate": "SELECT `TABLE_NAME` FROM `information_schema`.`TABLES` WHERE `TABLE_SCHEMA`=? AND `TABLE_TYPE` IN (?+) LIMIT ?+",
"SqlType": "SELECT",
"TablelockWaitTime": 0,
"TcCommitTime": 0,
"TcFlushTime": 0,
"TenantID": "2100067216",
"ThreadSchedTime": 3,
"ThreadWaitTime": 0,
"TmpDiskTables": 0,
"TotalCpuTime": 980,
"TotalExecTime": 1588,
"TrxCommitTime": 0,
"WaitLockTime": 0
},
"SecondTemplatesDetail": {
"BinlogSyncTime": 0,
"BytesSent": 0,
"CclWaitTime": 0,
"Count": 14,
"CpuTime": 0,
"DBName": "test_zhudi",
"ExecTime": 8,
"GroupFollowerWaitTime": 0,
"InnodbIoReadBytes": 0,
"InnodbIoReads": 0,
"InnodbPageAccess": 0,
"InstanceID": "mysql-cf8d83a2ea63",
"IsCollectSqlFingerprint": false,
"LatchWaitTime": 0,
"MdlWaitTime": 0,
"RedoLogFlushTime": 0,
"RowlockWaitTime": 0,
"RowsAffected": 0,
"RowsExamined": 0,
"RowsSent": 0,
"SemiSyncWaitTime": 0,
"ServerPort": "",
"SocketSendTime": 0,
"SqlFingerprint": "quit",
"SqlTable": "-",
"SqlTemplate": "",
"SqlType": "Quit",
"TablelockWaitTime": 0,
"TcCommitTime": 0,
"TcFlushTime": 0,
"TenantID": "2100067216",
"ThreadSchedTime": 5,
"ThreadWaitTime": 0,
"TmpDiskTables": 0,
"TotalCpuTime": 0,
"TotalExecTime": 113,
"TrxCommitTime": 0,
"WaitLockTime": 0
},
"SqlFingerprint": "quit",
"SqlType": "Quit",
"TbName": "-"
}
],
"Total": 1
}
}
错误码
最近更新时间：2026.09.01 14:02:02
这个页面对您有帮助吗？
有用
有用
无用
无用