调用 DescribeDialogDetailSnapshot 接口查询会话快照会话信息详情。 ## 请求类型同步请求。 ## 请求参数 |**参数** |**类型** |**是否必选** |**示例值** |**说明** | |---|---|---|---|---| |InstanceId

|String

|是 |mysql\-c\*\*\*\*\*\* |数据库实例 ID。

* 调用 [DescribeDBInstances](https://www.volcengine.com/docs/6313/170652) 接口查询 MySQL 的实例 ID。

* 调用 [DescribeDBInstances](https://www.volcengine.com/docs/6357/96188) 接口查询 veDB MySQL 的实例 ID。

* 调用 [DescribeDBInstances](https://www.volcengine.com/docs/6438/1159935?_vtm_=a106466.b106468.0_0.0_0.0.2109_7610615829733918244&lang=zh) 接口查询 PostgreSQL 的实例 ID。

* 调用 [DescribeDBInstances](https://www.volcengine.com/docs/6447/100741?lang=zh) 接口查询 MongoDB 的实例 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 |[QueryFilter](https://docs.volcengine.com/docs/6956/152615?lang=zh#BpRWSHHr) |否 |```JSON```
```{```
``` "ShowSleepConnection":true```
```}```
|会话快照的筛选条件。 | ## 返回参数 |**参数** |**类型** |**示例值** |**描述** | |---|---|---|---| |Total |Integer |100 |会话快照总数。 | |DialogDetails |Array of [DialogDetailst](https://docs.volcengine.com/docs/6956/152615?lang=zh#MJyim8S9) |```JSON```
```{```
``` "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"```
```}```
|会话快照详情。

| ## 请求示例 ```JSON 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 } } ``` ## 返回示例 ```JSON { "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 } } ``` ## 错误码更多详情，请参见[错误码](https://www.volcengine.com/docs/6956/152613)。

数据库工作台