Storage

Logs

Accessing the Storage Logs allows you to examine all incoming request logs to your Storage service. You can also filter logs and delve into specific aspects of your requests.

Common log queries

Filter by status 5XX error

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;

Filter by status 4XX error

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;

Filter by method

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;

Filter by IP address

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;