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


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

Filter by status 4XX error


_15
select
_15
id,
_15
storage_logs.timestamp,
_15
event_message,
_15
r.statusCode,
_15
e.message as errorMessage,
_15
e.raw as rawError
_15
from
_15
storage_logs
_15
cross join unnest(metadata) as m
_15
cross join unnest(m.res) as r
_15
cross join unnest(m.error) as e
_15
where r.statusCode >= 400 and r.statusCode < 500
_15
order by timestamp desc
_15
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;