获取Redis实例慢日志列表
更新时间：2025-09-10
接口描述
获取Redis数据库指定时间范围内的慢日志列表，包含执行时间、查询语句、数据库名称等详细信息。
权限说明
鉴权认证机制的详细内容请参见鉴权认证。
请求结构
Plain
1GET /api/v{version}/diagnosis/redis/slowlog/list?appId=string
2&nodeId=string
3&start=string
4&end=string
5&dbEngine=dbEngine
6&orderBy=string
7&order=string
8&page=int
9&pageSize=int HTTP/1.1
10Host: dbsc.bj.baidubce.com
11Authorization: authorization string请求头域
除公共头域外，无其它特殊头域。
请求参数
| 参数名称 | 类型 | 必选 | 参数位置 | 描述 |
|---|---|---|---|---|
| version | string | 是 | Path参数 | API版本号 |
| appId | string | 是 | Query参数 | 实例ID |
| nodeId | string | 是 | Query参数 | 节点ID |
| start | string | 是 | Query参数 | 查询开始时间，UTC格式，例如：2025-08-01T00:00:00Z |
| end | string | 是 | Query参数 | 查询结束时间，UTC格式，例如：2025-08-02T00:00:00Z |
| dbEngine | string | 是 | Query参数 | 数据库名称， 例如redis， pega。 |
| page | int | 否 | Query参数 | 分页页码，默认值为1 |
| pageSize | int | 否 | Query参数 | 每页记录数，默认值为20 |
| orderBy | string | 否 | Query参数 | 排序字段，默认为log_time, 支持排序字段log_time, slow_log_id, log_duration |
| order | string | 否 | Query参数 | 排序方向，可选值为asc和desc，默认为desc |
响应头域
无。
响应参数
| 参数名称 | 类型 | 描述 |
|---|---|---|
| appId | string | 集群ID |
| nodeId | string | 节点ID |
| requestId | string | 请求ID |
| start | string | 慢日志起始时间范围节点 |
| end | string | 慢日志结束时间范围节点 |
| totalRecordCount | int | 慢日志总数 |
| maxRecordCountPerPage | int | 每页返回日志的最大数量 |
| pageNumber | int | 当前页码 |
| recordCountInCurrentPage | int | 当前页慢日志数量 |
| records | []SCSSlowlogInfo | 慢日志信息列表 |
SCSSlowLogInfo结构
| 字段名 | 类型 | 说明 |
|---|---|---|
| content | string | 慢日志内容 |
| logDuration | int64 | 执行耗时（单位：微妙） |
| logKey | string | 操作的key |
| logSql | string | 命令 |
| logTime | string | 生成日志时间 |
| slowLogId | int64 | 慢日志ID |
| ClientIP | string | IP地址以及端口号 |
请求示例
Plain
1GET /api/v1/diagnosis/redis/slowlog/list?appId=scs-bj-iklvdbhcvpcg&nodeId=scs-bj-iklvdbhcvpcg_redis_558348_1&dbEngine=redis&start=2025-08-21T02:00:00Z&end=2025-08-28T11:00:00Z HTTP/1.1
2Host: dbsc.bj.baidu.com
3Content-Type: application/json
4Authorization: bce-auth-v1/f81d3b34e48048fbb2634dc7882d7e21/2023-07-11T11:17:29Z/3600/host/74c506f68c65e26c633bfa104c863fffac5190fdec1ec24b7c03eb5d67d2e1de响应示例
JSON
1{
2 "start": "2025-08-21T02:00:00Z",
3 "end": "2025-08-28T11:00:00Z",
4 "requestId": "4800dacd-f721-478e-b756-b802812adb64",
5 "recordCountInCurrentPage": 10,
6 "totalRecordCount": 547635,
7 "maxRecordCountPerPage": 10,
8 "pageNumber": 1,
9 "appId": "scs-bj-mqopuganwugp",
10 "dbEngine": "redis",
11 "nodeId": "scs-bj-mqopuganwugp_redis_341491_1",
12 "records": [
13 {
14 "logTime": "2025-08-27T04:44:18Z",
15 "content": "UNLINK BDRP_STATICS_ONLINE_QA_TEST::15318",
16 "slowLogId": 14210946,
17 "logDuration": 0,
18 "logSql": "UNLINK",
19 "logKey": "BDRP_STATICS_ONLINE_QA_TEST::15318",
20 "clientIp": "172.17.35.11:6106"
21 },
22 {
23 "logTime": "2025-08-27T04:44:18Z",
24 "content": "UNLINK BDRP_STATICS_ONLINE_QA_TEST::55780",
25 "slowLogId": 14210949,
26 "logDuration": 1,
27 "logSql": "UNLINK",
28 "logKey": "BDRP_STATICS_ONLINE_QA_TEST::55780",
29 "clientIp": "172.17.35.11:6106"
30 },
31 {
32 "logTime": "2025-08-27T04:44:18Z",
33 "content": "PING",
34 "slowLogId": 14210942,
35 "logDuration": 0,
36 "logSql": "",
37 "logKey": "",
38 "clientIp": "127.0.0.1:53147"
39 },
40 {
41 "logTime": "2025-08-27T04:44:18Z",
42 "content": "UNLINK BDRP_STATICS_ONLINE_QA_TEST::24078",
43 "slowLogId": 14210947,
44 "logDuration": 0,
45 "logSql": "UNLINK",
46 "logKey": "BDRP_STATICS_ONLINE_QA_TEST::24078",
47 "clientIp": "172.17.35.11:6106"
48 },
49 {
50 "logTime": "2025-08-27T04:44:18Z",
51 "content": "AUTH (redacted)",
52 "slowLogId": 14210943,
53 "logDuration": 3,
54 "logSql": "AUTH",
55 "logKey": "(redacted)",
56 "clientIp": "127.0.0.1:53151"
57 },
58 {
59 "logTime": "2025-08-27T04:44:18Z",
60 "content": "AUTH (redacted)",
61 "slowLogId": 14210950,
62 "logDuration": 5,
63 "logSql": "AUTH",
64 "logKey": "(redacted)",
65 "clientIp": "127.0.0.1:53187"
66 },
67 {
68 "logTime": "2025-08-27T04:44:18Z",
69 "content": "UNLINK BDRP_STATICS_ONLINE_QA_TEST::55783",
70 "slowLogId": 14210945,
71 "logDuration": 5,
72 "logSql": "UNLINK",
73 "logKey": "BDRP_STATICS_ONLINE_QA_TEST::55783",
74 "clientIp": "172.17.35.11:6106"
75 },
76 {
77 "logTime": "2025-08-27T04:44:18Z",
78 "content": "UNLINK BDRP_STATICS_ONLINE_QA_TEST::23008",
79 "slowLogId": 14210948,
80 "logDuration": 0,
81 "logSql": "UNLINK",
82 "logKey": "BDRP_STATICS_ONLINE_QA_TEST::23008",
83 "clientIp": "172.17.35.11:6106"
84 },
85 {
86 "logTime": "2025-08-27T04:44:18Z",
87 "content": "AUTH (redacted)",
88 "slowLogId": 14210941,
89 "logDuration": 4,
90 "logSql": "AUTH",
91 "logKey": "(redacted)",
92 "clientIp": "127.0.0.1:53147"
93 },
94 {
95 "logTime": "2025-08-27T04:44:18Z",
96 "content": "INFO Replication",
97 "slowLogId": 14210944,
98 "logDuration": 8,
99 "logSql": "INFO",
100 "logKey": "Replication",
101 "clientIp": "127.0.0.1:53151"
102 }
103 ]
104}