You need to enable JavaScript to run this app.
文档中心
数据库工作台

数据库工作台

复制全文
下载 pdf
诊断与快照
DescribeDialogDetailSnapshot
复制全文
下载 pdf
DescribeDialogDetailSnapshot
调用 DescribeDialogDetailSnapshot 接口查询会话快照会话信息详情。​
注意事项​
该接口仅适用于云数据库 MySQL 版、云数据库 veDB MySQL 版、云数据库 PostgreSQL 版和文档数据库 MongoDB 版的实例。​
请求类型​
同步请求。​
请求参数​
​
参数​
类型​
是否必选​
示例值​
说明​
InstanceId​
​
String​
​
是​
mysql-c******​
数据库实例 ID。​
DSType​
String​
是​
MySQL​
数据库类型,当前支持的数据库如下所示。​
  • MySQL:云数据库 MySQL 版。​
  • VeDBMySQL:云数据库 veDB MySQL 版。​
  • Postgres:云数据库 PostgreSQL 版。​
  • Mongo:文档数据库 MongoDB 版。​
SnapshotTime​
Integer​
是​
1782349500​
会话快照的时间点,格式为秒级时间戳。​
PageNumber​
Integer​
是​
1​
分页页码。​
PageSize​
Integer​
是​
20​
分页大小。​
NodeId​
String​
否​
mysql-c****-0​
数据库实例节点 ID。​
QueryFilter​
否​
​
{​
"ShowSleepConnection":true​
}​
​
会话快照的筛选条件。​
​
返回参数​
​
参数​
类型​
示例值​
描述​
Total​
Integer​
100​
会话快照总数。​
DialogDetails​
Array of DialogDetailst​
​
{​
"BlockingPid": "",​
"Command": "Sleep",​
"DB": "mysql",​
"Desc": "",​
"Host": "11.192.56.112:50256",​
"Info": "NULL",​
"Namespace": "",​
"NodeId": "mysql-c******-ma822-0",​
"PSM": "-",​
"PlanSummary": "",​
"ProcessID": "267808",​
"SnapshotTime": 1782791281,​
"State": "",​
"Time": "4s",​
"User": "test_user"​
}​
​
会话快照详情。​
​
​
请求示例​
​
POST /?Action=DescribeDialogDetailSnapshot&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****​
​
{​
"DSType":"MySQL",​
"InstanceId":"mysql-c******",​
"SnapshotTime":1782791281,​
"PageNumber":1,​
"PageSize":20,​
"QueryFilter":{​
"ShowSleepConnection":true​
}​
}​
​
返回示例​
​
{​
"ResponseMetadata": {​
"RequestId": "202606301149113CB9F2FE036AB424B75C-d9b210",​
"Action": "DescribeDialogDetailSnapshot",​
"Version": "2018-01-01",​
"Service": "dbw",​
"Region": "cn-beijing"​
},​
"Result": {​
"DialogDetails": [​
{​
"BlockingPid": "",​
"Command": "Sleep",​
"DB": "mysql",​
"Desc": "",​
"Host": "11.192.56.112:50256",​
"Info": "NULL",​
"Namespace": "",​
"NodeId": "mysql-c******-ma822-0",​
"PSM": "-",​
"PlanSummary": "",​
"ProcessID": "267808",​
"SnapshotTime": 1782791281,​
"State": "",​
"Time": "4s",​
"User": "test_user"​
}​
],​
"Total": 1​
}​
}​
​
错误码​
更多详情,请参见错误码。​
最近更新时间:2026.10.14 14:12:44
这个页面对您有帮助吗?
有用
有用
无用
无用