Log sources and fields
Each event is a row in the ClickHouse logs table. Filter the source column to select a service. The tables below list its fields; a field is not necessarily populated on every event.
id, timestamp, event_message, severity_text, and source are top-level columns. Service fields are string values in log_attributes, even when the original event contains a number or boolean. Use the ClickHouse query field column directly. See Query logs with SQL for casting and field discovery.
Sources
source | Events |
|---|---|
edge_logs | HTTP requests through the API gateway, including REST and GraphQL |
postgres_logs | Database activity, statements, and errors |
postgrest_logs | PostgREST server logs |
auth_logs | Auth server: login, JWT, OAuth, email |
auth_audit_logs | Auth audit events |
storage_logs | Storage API: uploads and object access |
realtime_logs | Realtime server: channels, presence, broadcast |
function_edge_logs | HTTP request and response for an Edge Function invocation |
function_logs | console output from inside an Edge Function |
supavisor_logs | Shared pooler: pooling and timeouts |
pgbouncer_logs | Dedicated pooler |
pg_upgrade_logs | Database version upgrade |
For postgres_logs, statement text and error details can appear in event_message. A missing structured field does not mean the event has no detail.
Captured HTTP headers
API Gateway logs capture only the headers below. Other headers still reach the application and client but are omitted from these logs.
Request headers:
acceptcf-connecting-ipcf-ipcountryhostuser-agentx-forwarded-protoreferercontent-lengthx-real-ipx-client-infox-forwarded-user-agentrangeprefer
Response headers:
cf-cache-statuscf-raycontent-locationcontent-rangecontent-typecontent-lengthdatetransfer-encodingx-kong-proxy-latencyx-kong-upstream-latencysb-gateway-modesb-gateway-version
Capture limits
- Hosted Postgres events longer than 100,000 characters and Edge Function log messages longer than 10,000 characters are truncated.
- Internal Supabase service connection events are not recorded in hosted Postgres logs.
- An Edge Function invocation uses
function_edge_logs; its console output usesfunction_logs. - For API Load Balancer traffic,
log_attributes['load_balancer_redirect_identifier']identifies the upstream database.
Fields by source
Interactive on supabase.com
This part of the page is a table of shared data (SharedData), which supabase.com draws live. See it on the original page.