Error Codes

1
{
2
  "code": "42703",
3
  "details": null,
4
  "hint": "Perhaps you meant to reference the column some_table.fake_col",
5
  "message": "column some_table.fake_col does not exist"
6
}

1
select
2
  cast(postgres_logs.timestamp as datetime) as timestamp,
3
  event_message,
4
  parsed.error_severity,
5
  parsed.user_name,
6
  parsed.query,
7
  parsed.detail,
8
  parsed.hint,
9
  parsed.sql_state_code,
10
  parsed.backend_type
11
from
12
  postgres_logs
13
  cross join unnest(metadata) as metadata
14
  cross join unnest(metadata.parsed) as parsed
15
where
16
  regexp_contains(parsed.error_severity, 'ERROR|FATAL|PANIC')
17
  and parsed.user_name = 'authenticator' -- the authenticator role represents the database API
18
order by timestamp desc
19
limit 100;

1
select
2
  cast(postgres_logs.timestamp as datetime) as timestamp,
3
  event_message,
4
  parsed.error_severity,
5
  parsed.user_name,
6
  parsed.query,
7
  parsed.detail,
8
  parsed.hint,
9
  parsed.sql_state_code,
10
  parsed.backend_type
11
from
12
  postgres_logs
13
  cross join unnest(metadata) as metadata
14
  cross join unnest(metadata.parsed) as parsed
15
where parsed.sql_state_code like '42501' and parsed.user_name = 'authenticator' -- the authenticator role represents the database API
16
order by timestamp desc
17
limit 100;

1
select
2
  cast(timestamp as datetime) as timestamp,
3
  status_code,
4
  event_message,
5
  coalesce(proxy_status, 'not_recorded') as error_codes,
6
  path
7
from
8
  edge_logs
9
  cross join unnest(metadata) as metadata
10
  cross join unnest(response) as response
11
  cross join unnest(request) as request
12
where
13
  status_code >= 300
14
  and regexp_contains(path, '^/rest/v1/')
15
  and regexp_contains(proxy_status, '(?i)THE_RELEVANT_STATUS_CODE');

1
select
2
  format_timestamp(
3
    "%c",
4
    timestamp_trunc(cast(edge_logs.timestamp as timestamp), hour),
5
    "UTC"
6
  ) as hour,
7
  count(proxy_status) as error_count,
8
  path,
9
  coalesce(proxy_status, 'not_recorded') as error_codes
10
from
11
  edge_logs
12
  cross join unnest(metadata) as metadata
13
  cross join unnest(response) as response
14
  cross join unnest(response.headers) as headers
15
  cross join unnest(request) as request
16
where status_code >= 300 and regexp_contains(path, '^/rest/v1/')
17
group by hour, proxy_status, path;

1
select
2
  cast(timestamp as datetime) as timestamp,
3
  event_message,
4
  cf_connecting_ip as requesters_ip,
5
  url as request_url,
6
  request.method as request_method,
7
  sb.auth_user as user_id,
8
  apikey_payload.role as apikey_role,
9
  authorization_payload.role as authorization_token_role,
10
  user_agent,
11
  city,
12
  country,
13
  continent,
14
  postalCode
15
from
16
  edge_logs
17
  cross join unnest(metadata) as metadata
18
  cross join unnest(request) as request
19
  cross join unnest(sb) as sb
20
  cross join unnest(jwt) as jwt
21
  cross join unnest(jwt.apikey) as jwt_apikey
22
  cross join unnest(jwt_apikey.payload) as apikey_payload
23
  cross join unnest(authorization) as authorization_key
24
  cross join unnest(authorization_key.payload) as authorization_payload
25
  cross join unnest(headers) as headers
26
  cross join unnest(cf) as cf
27
  cross join unnest(response) as response
28
where regexp_contains(path, '^/rest/v1/') and sb.auth_user = 'SOME_USER_ID' -- <---ADD USER_ID from auth.users table
29
order by timestamp desc;