存储

日志

访问存储日志可以检查存储服务的所有传入请求日志。您还可以筛选日志并深入分析请求的特定方面。

常用日志查询

按5XX状态码错误筛选

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
select  id,  storage_logs.timestamp,  event_message,  r.statusCode,  e.message as errorMessage,  e.raw as rawErrorfrom  storage_logs  cross join unnest(metadata) as m  cross join unnest(m.res) as r  cross join unnest(m.error) as ewhere r.statusCode >= 500order by timestamp desclimit 100;

按4XX状态码错误筛选

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
select  id,  storage_logs.timestamp,  event_message,  r.statusCode,  e.message as errorMessage,  e.raw as rawErrorfrom  storage_logs  cross join unnest(metadata) as m  cross join unnest(m.res) as r  cross join unnest(m.error) as ewhere r.statusCode >= 400 and r.statusCode < 500order by timestamp desclimit 100;

按请求方法筛选

1
2
3
4
5
6
7
8
select id, storage_logs.timestamp, event_message, r.methodfrom  storage_logs  cross join unnest(metadata) as m  cross join unnest(m.req) as rwhere r.method in ("POST")order by timestamp desclimit 100;

按IP地址筛选

1
2
3
4
5
6
7
8
select id, storage_logs.timestamp, event_message, r.remoteAddressfrom  storage_logs  cross join unnest(metadata) as m  cross join unnest(m.req) as rwhere r.remoteAddress in ("IP_ADDRESS")order by timestamp desclimit 100;