postgREST_errors.sql

select
  cast(timestamp as datetime) as timestamp,
  event_message,
  status_code
from edge_logs
  cross join unnest(metadata) as metadata
  cross join unnest(metadata.request) as request
  cross join unnest(metadata.response) as response
where
  -- only look for requests through the database API
  path like '%rest/v1%'
    and
  -- only look for errors
  status_code > 399
    and
  regexp_contains(event_message, 'create_secret')
order by
  timestamp desc
limit 100