数据库工作台
数据库工作台
数据库工作台
文档指南
请输入
产品动态
操作指南
MySQL 用户指南
数据管理
SQL 窗口
工单列表
SQL 审核工单
数据清理归档工单
运维管理
企业安全管理
veDB MySQL 用户指南
数据管理
SQL 窗口
工单列表
SQL 审核工单
数据清理归档工单
运维管理
企业安全管理
PostgreSQL 用户指南
数据管理
工单列表
企业安全管理
SQL Server 用户指南
Redis 用户指南
数据管理
运维管理
企业安全管理
MongoDB 用户指南
开发者工具
最佳实践
API参考
SQL 任务
运维管理
SQL 限流
审计日志管理
慢日志与优化建议
诊断与快照
SQL 洞察与审计
工单管理
安全管控
常见问题
权限管理 FAQ
产品通用 FAQ
故障排查
- 文档首页
数据库工作台API参考运维管理SQL 洞察与审计DescribeFullSQLFingerprintExample
复制全文
下载 pdfDescribeFullSQLFingerprintExample
文档反馈
问问助手调用 DescribeFullSQLFingerprintExample 接口根据 SQL 指纹查询全量 SQL 明细样例。
请求类型
同步请求。
请求参数
名称 | 类型 | 是否必选 | 示例值 | 描述 |
名称 | 类型 | 是否必选 | 示例值 | 描述 |
FollowInstanceID | String | 是 | mysql-fcfc2c****** | 实例 ID。 说明 您可以按需选择以下接口查询实例 ID：
|
InstanceType | String | 是 | MySQL | 数据库类型，当前支持的数据库如下所示。
|
StartTime | Integer | 是 | 1719820800 | 查询开始时间，使用秒级时间戳。 |
EndTime | Integer | 是 | 1719824400 | 查询结束时间，使用秒级时间戳。 结束时间需晚于开始时间。 |
RegionId | String | 是 | cn-beijing | 地域 ID。 |
SearchParam | 否 | { "DisplaySqlTemplate": true, "SqlFingerprints": [ "17c76a2458cb3cca182d8247f43f7333" ] } | 查询过滤条件。 说明 建议传入该参数信息，否则接口将不会按照指纹返回数据。 |
返回参数
名称 | 类型 | 示例值 | 描述 |
名称 | 类型 | 示例值 | 描述 |
DescribeFullSQLDetailRows | [ { "BinlogSyncTime": 0, "BytesSent": 0, "CclWaitTime": 0, "ClientIp": "172.30.116.80", "ClientPort": "60778", "ComponentType": "", "CpuTime": 0, "DBName": "test_a", "EndTimestamp": "1787566212356016", "ExecErrorMsg": "", "ExecErrorNo": "", "ExecTime": 73, "GroupFollowerWaitTime": 0, "GroupIds": "", "InnodbIOReadBytes": 0, "InnodbIOReads": 0, "InnodbIoWait": 0, "InnodbPageAccess": 0, "IsBroadcast": false, "IsCollectSqlFingerprint": false, "LatchWaitTime": 0, "LockTime": 0, "LogId": "", "LogLevel": "Normal", "LogType": "-", "MaxMem": 0, "MdlWaitTime": 0, "NodeId": "mysql-cf8d83******-sb2e3-0", "ProcessId": "", "ProxyTraceID": "", "QueryString": "", "QueryTruncated": "false", "RdbBlockCacheHitCount": 0, "RdbBlockDecompressTime": 0, "RdbBlockReadByte": 0, "RdbBlockReadCount": 0, "RdbBlockReadTime": 0, "RdbFindNextUserEntryTime": 0, "RdbInternalKeySkipCount": 0, "RdbInternalRecentSkipCount": 0, "RdbLockWaitTime": 0, "RdbNewTableBlockIterTime": 0, "RdbSeekInternalTime": 0, "RdbTrxId": "", "RecordId": "5fc409b1-cdc8-4ac9-964a-d484df056587", "RedoLogFlushTime": 0, "RequestSize": 0, "RowAffected": 0, "RowlockWaitTime": 0, "RowsExamined": 0, "RowsSent": 0, "SemiSyncWaitTime": 0, "ServerCommand": "Connect", "ServerExecs": "", "ServerPort": "0", "SessionID": "662029", "ShardID": "", "ShardIds": "", "SocketSendTime": 28, "SqlFingerprint": "connect", "SqlTable": "-", "SqlTemplate": "", "SqlType": "Connect", "StartTimestamp": "1787566212355943", "TablelockWaitTime": 0, "TcCommitTime": 0, "TcFlushTime": 0, "ThreadSchedTime": 0, "ThreadWaitTime": 16, "TmpDiskTables": 0, "TraceID": "0", "TrxCommitTime": 0, "TrxId": "0", "UserName": "test-a", "UserPsm": "", "Version": "4", "WaitLockTime": 0, "WarningNum": 0 } ] | SQL 指纹对应的全量 SQL 明细样例列表。每个指纹最多返回一条样例。 |
请求示例
POST /?Action=DescribeFullSQLFingerprintExample&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****
{
"FollowInstanceID": "mysql-cf8d83******",
"InstanceType": "MySQL",
"StartTime": 1787562620,
"EndTime": 1787566220,
"SearchParam": {
"DisplaySqlTemplate": true,
"SqlFingerprints": [
"connect"
]
},
"RegionId": "cn-beijing"
}
返回示例
{
"ResponseMetadata": {
"RequestId": "2026082418112882C3F79E243440D87217-7c6e18",
"Action": "DescribeFullSQLFingerprintExample",
"Version": "2018-01-01",
"Service": "dbw",
"Region": "cn-beijing"
},
"Result": {
"DescribeFullSQLDetailRows": [
{
"BinlogSyncTime": 0,
"BytesSent": 0,
"CclWaitTime": 0,
"ClientIp": "172.30.116.80",
"ClientPort": "60778",
"ComponentType": "",
"CpuTime": 0,
"DBName": "test_a",
"EndTimestamp": "1787566212356016",
"ExecErrorMsg": "",
"ExecErrorNo": "",
"ExecTime": 73,
"GroupFollowerWaitTime": 0,
"GroupIds": "",
"InnodbIOReadBytes": 0,
"InnodbIOReads": 0,
"InnodbIoWait": 0,
"InnodbPageAccess": 0,
"IsBroadcast": false,
"IsCollectSqlFingerprint": false,
"LatchWaitTime": 0,
"LockTime": 0,
"LogId": "",
"LogLevel": "Normal",
"LogType": "-",
"MaxMem": 0,
"MdlWaitTime": 0,
"NodeId": "mysql-cf8d83******-sb2e3-0",
"ProcessId": "",
"ProxyTraceID": "",
"QueryString": "",
"QueryTruncated": "false",
"RdbBlockCacheHitCount": 0,
"RdbBlockDecompressTime": 0,
"RdbBlockReadByte": 0,
"RdbBlockReadCount": 0,
"RdbBlockReadTime": 0,
"RdbFindNextUserEntryTime": 0,
"RdbInternalKeySkipCount": 0,
"RdbInternalRecentSkipCount": 0,
"RdbLockWaitTime": 0,
"RdbNewTableBlockIterTime": 0,
"RdbSeekInternalTime": 0,
"RdbTrxId": "",
"RecordId": "5fc409b1-cdc8-4ac9-964a-d484df056587",
"RedoLogFlushTime": 0,
"RequestSize": 0,
"RowAffected": 0,
"RowlockWaitTime": 0,
"RowsExamined": 0,
"RowsSent": 0,
"SemiSyncWaitTime": 0,
"ServerCommand": "Connect",
"ServerExecs": "",
"ServerPort": "0",
"SessionID": "662029",
"ShardID": "",
"ShardIds": "",
"SocketSendTime": 28,
"SqlFingerprint": "connect",
"SqlTable": "-",
"SqlTemplate": "",
"SqlType": "Connect",
"StartTimestamp": "1787566212355943",
"TablelockWaitTime": 0,
"TcCommitTime": 0,
"TcFlushTime": 0,
"ThreadSchedTime": 0,
"ThreadWaitTime": 16,
"TmpDiskTables": 0,
"TraceID": "0",
"TrxCommitTime": 0,
"TrxId": "0",
"UserName": "test-a",
"UserPsm": "",
"Version": "4",
"WaitLockTime": 0,
"WarningNum": 0
}
]
}
}
错误码
最近更新时间：2026.09.01 14:02:01
这个页面对您有帮助吗？
有用
有用
无用
无用