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


_10
select id, storage_logs.timestamp, event_message, r.statusCode, e.message as errorMessage e.raw as rawError
_10
from storage_logs
_10
cross join unnest(metadata) as m
_10
cross join unnest(m.res) as r
_10
cross join unnest(m.error) as e
_10
where r.statusCode >= 500
_10
order by timestamp desc
_10
limit 100

Filter by status 4XX error


_10
select id, storage_logs.timestamp, event_message, r.statusCode, e.message as errorMessage e.raw as rawError
_10
from storage_logs
_10
cross join unnest(metadata) as m
_10
cross join unnest(m.res) as r
_10
cross join unnest(m.error) as e
_10
where r.statusCode >= 400 and r.statusCode < 500
_10
order by timestamp desc
_10
limit 100

Filter by method


_10
select id, storage_logs.timestamp, event_message, r.method
_10
from
_10
storage_logs
_10
cross join unnest(metadata) as m
_10
cross join unnest(m.req) as r
_10
where r.method in ("POST")
_10
order by timestamp desc
_10
limit 100;

Filter by IP address


_10
select id, storage_logs.timestamp, event_message, r.remoteAddress
_10
from
_10
storage_logs
_10
cross join unnest(metadata) as m
_10
cross join unnest(m.req) as r
_10
where r.remoteAddress in ("IP_ADDRESS")
_10
order by timestamp desc
_10
limit 100;