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
  timestamp,
3
  event_message,
4
  log_attributes['parsed.error_severity'] as error_severity,
5
  log_attributes['parsed.user_name'] as user_name,
6
  log_attributes['parsed.query'] as query,
7
  log_attributes['parsed.detail'] as detail,
8
  log_attributes['parsed.hint'] as hint,
9
  log_attributes['parsed.sql_state_code'] as sql_state_code,
10
  log_attributes['parsed.backend_type'] as backend_type
11
from logs
12
where
13
  source = 'postgres_logs'
14
  and log_attributes['parsed.error_severity'] in ('ERROR', 'FATAL', 'PANIC')
15
  and log_attributes['parsed.user_name'] = 'authenticator' -- the authenticator role represents the database API
16
order by timestamp desc
17
limit 100;

1
select
2
  timestamp,
3
  event_message,
4
  log_attributes['parsed.error_severity'] as error_severity,
5
  log_attributes['parsed.user_name'] as user_name,
6
  log_attributes['parsed.query'] as query,
7
  log_attributes['parsed.detail'] as detail,
8
  log_attributes['parsed.hint'] as hint,
9
  log_attributes['parsed.sql_state_code'] as sql_state_code,
10
  log_attributes['parsed.backend_type'] as backend_type
11
from logs
12
where
13
  source = 'postgres_logs'
14
  and log_attributes['parsed.sql_state_code'] = '42501'
15
  and log_attributes['parsed.user_name'] = 'authenticator' -- the authenticator role represents the database API
16
order by timestamp desc
17
limit 100;

1
select
2
  timestamp,
3
  log_attributes['response.status_code'] as status_code,
4
  log_attributes['response.headers.sb_error_code'] as gateway_error_code,
5
  log_attributes['request.path'] as path,
6
  event_message
7
from logs
8
where
9
  source = 'edge_logs'
10
  and toInt32OrZero(log_attributes['response.status_code']) >= 300
11
  and match(log_attributes['request.path'], '^/rest/v1/')
12
order by timestamp desc
13
limit 100;

1
select
2
  toStartOfHour(timestamp) as hour,
3
  count() as error_count,
4
  log_attributes['request.path'] as path
5
from logs
6
where
7
  source = 'edge_logs'
8
  and toInt32OrZero(log_attributes['response.status_code']) >= 300
9
  and match(log_attributes['request.path'], '^/rest/v1/')
10
group by hour, path
11
order by hour desc
12
limit 100;

1
select
2
  timestamp,
3
  event_message,
4
  log_attributes['request.headers.cf_connecting_ip'] as requesters_ip,
5
  log_attributes['request.url'] as request_url,
6
  log_attributes['request.method'] as request_method,
7
  log_attributes['request.sb.jwt.authorization.payload.subject'] as user_id,
8
  log_attributes['request.sb.jwt.apikey.payload.role'] as apikey_role,
9
  log_attributes['request.sb.jwt.authorization.payload.role'] as authorization_token_role,
10
  log_attributes['request.headers.user_agent'] as user_agent,
11
  log_attributes['request.cf.city'] as city,
12
  log_attributes['request.cf.country'] as country,
13
  log_attributes['request.cf.postalCode'] as postalCode
14
from logs
15
where
16
  source = 'edge_logs'
17
  and match(log_attributes['request.path'], '^/rest/v1/')
18
  and log_attributes['request.sb.jwt.authorization.payload.subject'] = 'SOME_USER_ID' -- <---ADD USER_ID from auth.users table
19
order by timestamp desc
20
limit 100;