# Logs field reference

Supabase Logs field reference

Refer to the full field reference for each available source below. To access each nested key, you need to perform the [necessary unnesting joins](https://supabase.com/docs/guides/monitoring-and-debugging/advanced-log-filtering#unnesting-arrays)

#### API Gateway
 - `event_message`, `string`
 - `id`, `string`
 - `identifier`, `string`
 - `metadata.load_balancer_redirect_identifier`, `string`
 - `metadata.request.cf.asn`, `number`
 - `metadata.request.cf.asOrganization`, `string`
 - `metadata.request.cf.botManagement.corporateProxy`, `boolean`
 - `metadata.request.cf.botManagement.detectionIds`, `number[]`
 - `metadata.request.cf.botManagement.ja3Hash`, `string`
 - `metadata.request.cf.botManagement.score`, `number`
 - `metadata.request.cf.botManagement.staticResource`, `boolean`
 - `metadata.request.cf.botManagement.verifiedBot`, `boolean`
 - `metadata.request.cf.city`, `string`
 - `metadata.request.cf.clientTcpRtt`, `number`
 - `metadata.request.cf.clientTrustScore`, `number`
 - `metadata.request.cf.colo`, `string`
 - `metadata.request.cf.continent`, `string`
 - `metadata.request.cf.country`, `string`
 - `metadata.request.cf.edgeRequestKeepAliveStatus`, `number`
 - `metadata.request.cf.httpProtocol`, `string`
 - `metadata.request.cf.latitude`, `string`
 - `metadata.request.cf.longitude`, `string`
 - `metadata.request.cf.metroCode`, `string`
 - `metadata.request.cf.postalCode`, `string`
 - `metadata.request.cf.region`, `string`
 - `metadata.request.cf.timezone`, `string`
 - `metadata.request.cf.tlsCipher`, `string`
 - `metadata.request.cf.tlsClientAuth.certPresented`, `string`
 - `metadata.request.cf.tlsClientAuth.certRevoked`, `string`
 - `metadata.request.cf.tlsClientAuth.certVerified`, `string`
 - `metadata.request.cf.tlsExportedAuthenticator.clientFinished`, `string`
 - `metadata.request.cf.tlsExportedAuthenticator.clientHandshake`, `string`
 - `metadata.request.cf.tlsExportedAuthenticator.serverFinished`, `string`
 - `metadata.request.cf.tlsExportedAuthenticator.serverHandshake`, `string`
 - `metadata.request.cf.tlsVersion`, `string`
 - `metadata.request.headers.cf_connecting_ip`, `string`
 - `metadata.request.headers.cf_ipcountry`, `string`
 - `metadata.request.headers.cf_ray`, `string`
 - `metadata.request.headers.host`, `string`
 - `metadata.request.headers.referer`, `string`
 - `metadata.request.headers.x_client_info`, `string`
 - `metadata.request.headers.x_forwarded_proto`, `string`
 - `metadata.request.headers.x_real_ip`, `string`
 - `metadata.request.host`, `string`
 - `metadata.request.method`, `string`
 - `metadata.request.path`, `string`
 - `metadata.request.protocol`, `string`
 - `metadata.request.search`, `string`
 - `metadata.request.url`, `string`
 - `metadata.response.headers.cf_cache_status`, `string`
 - `metadata.response.headers.cf_ray`, `string`
 - `metadata.response.headers.content_location`, `string`
 - `metadata.response.headers.content_range`, `string`
 - `metadata.response.headers.content_type`, `string`
 - `metadata.response.headers.date`, `string`
 - `metadata.response.headers.sb_gateway_version`, `string`
 - `metadata.response.headers.transfer_encoding`, `string`
 - `metadata.response.headers.x_kong_proxy_latency`, `string`
 - `metadata.response.origin_time`, `number`
 - `metadata.response.status_code`, `number`
 - `timestamp`, `datetime`

#### Auth
 - `event_message`, `string`
 - `id`, `string`
 - `metadata.auth_event.action`, `string`
 - `metadata.auth_event.actor_id`, `string`
 - `metadata.auth_event.actor_username`, `string`
 - `metadata.auth_event.actor_via_sso`, `boolean`
 - `metadata.auth_event.log_type`, `string`
 - `metadata.auth_event.traits.provider`, `string`
 - `metadata.auth_event.traits.user_email`, `string`
 - `metadata.auth_event.traits.user_id`, `string`
 - `metadata.auth_event.traits.user_phone`, `string`
 - `metadata.component`, `string`
 - `metadata.duration`, `number`
 - `metadata.host`, `string`
 - `metadata.level`, `string`
 - `metadata.method`, `string`
 - `metadata.msg`, `string`
 - `metadata.path`, `string`
 - `metadata.referer`, `string`
 - `metadata.remote_addr`, `string`
 - `metadata.status`, `number`
 - `metadata.timestamp`, `string`
 - `timestamp`, `datetime`

#### Auth Audit Logs
 - `event_message`, `string`
 - `id`, `string`
 - `identifier`, `string`
 - `metadata.auth_audit_event.action`, `string`
 - `metadata.auth_audit_event.actor_id`, `string`
 - `metadata.auth_audit_event.actor_name`, `string`
 - `metadata.auth_audit_event.actor_username`, `string`
 - `metadata.auth_audit_event.actor_via_sso`, `boolean`
 - `metadata.auth_audit_event.audit_log_id`, `string`
 - `metadata.auth_audit_event.created_at`, `string`
 - `metadata.auth_audit_event.log_type`, `string`
 - `metadata.auth_audit_event.request_id`, `string`
 - `metadata.auth_audit_event.user_agent`, `string`
 - `metadata.host`, `string`
 - `metadata.level`, `string`
 - `metadata.msg`, `string`
 - `timestamp`, `datetime`

#### Storage
 - `event_message`, `string`
 - `id`, `string`
 - `metadata.context.host`, `string`
 - `metadata.context.pid`, `number`
 - `metadata.level`, `string`
 - `metadata.project`, `string`
 - `metadata.rawError`, `string`
 - `metadata.req.headers.accept`, `string`
 - `metadata.req.headers.cf_connecting_ip`, `string`
 - `metadata.req.headers.cf_ray`, `string`
 - `metadata.req.headers.content_length`, `string`
 - `metadata.req.headers.content_type`, `string`
 - `metadata.req.headers.host`, `string`
 - `metadata.req.headers.referer`, `string`
 - `metadata.req.headers.user_agent`, `string`
 - `metadata.req.headers.x_client_info`, `string`
 - `metadata.req.headers.x_forwarded_proto`, `string`
 - `metadata.req.hostname`, `string`
 - `metadata.req.method`, `string`
 - `metadata.req.remoteAddress`, `string`
 - `metadata.req.remotePort`, `number`
 - `metadata.req.url`, `string`
 - `metadata.reqId`, `string`
 - `metadata.res.headers.content_length`, `number`
 - `metadata.res.headers.content_type`, `string`
 - `metadata.res.statusCode`, `number`
 - `metadata.responseTime`, `number`
 - `metadata.tenantId`, `string`
 - `timestamp`, `datetime`

#### Function Edge
 - `event_message`, `string`
 - `id`, `string`
 - `metadata.deployment_id`, `string`
 - `metadata.execution_time_ms`, `number`
 - `metadata.function_id`, `string`
 - `metadata.project_ref`, `string`
 - `metadata.request.headers.accept`, `string`
 - `metadata.request.headers.content_length`, `string`
 - `metadata.request.headers.host`, `string`
 - `metadata.request.headers.user_agent`, `string`
 - `metadata.request.host`, `string`
 - `metadata.request.method`, `string`
 - `metadata.request.pathname`, `string`
 - `metadata.request.protocol`, `string`
 - `metadata.request.url`, `string`
 - `metadata.response.headers.content_length`, `string`
 - `metadata.response.headers.content_type`, `string`
 - `metadata.response.headers.date`, `string`
 - `metadata.response.headers.server`, `string`
 - `metadata.response.headers.vary`, `string`
 - `metadata.response.status_code`, `number`
 - `metadata.version`, `string`
 - `timestamp`, `datetime`

#### Function Runtime
 - `event_message`, `string`
 - `id`, `string`
 - `metadata.deployment_id`, `string`
 - `metadata.event_type`, `string`
 - `metadata.execution_id`, `string`
 - `metadata.function_id`, `string`
 - `metadata.level`, `string`
 - `metadata.project_ref`, `string`
 - `metadata.region`, `string`
 - `metadata.timestamp`, `string`
 - `metadata.version`, `string`
 - `timestamp`, `datetime`

#### Postgres
 - `event_message`, `string`
 - `id`, `string`
 - `identifier`, `string`
 - `metadata.host`, `string`
 - `metadata.parsed.backend_type`, `string`
 - `metadata.parsed.command_tag`, `string`
 - `metadata.parsed.connection_from`, `string`
 - `metadata.parsed.database_name`, `string`
 - `metadata.parsed.error_severity`, `string`
 - `metadata.parsed.process_id`, `number`
 - `metadata.parsed.query_id`, `number`
 - `metadata.parsed.session_id`, `string`
 - `metadata.parsed.session_line_num`, `number`
 - `metadata.parsed.session_start_time`, `string`
 - `metadata.parsed.sql_state_code`, `string`
 - `metadata.parsed.timestamp`, `string`
 - `metadata.parsed.transaction_id`, `number`
 - `metadata.parsed.user_name`, `string`
 - `metadata.parsed.virtual_transaction_id`, `string`
 - `timestamp`, `datetime`

#### Realtime
 - `event_message`, `string`
 - `id`, `string`
 - `metadata.external_id`, `string`
 - `metadata.level`, `string`
 - `metadata.measurements.connected`, `number`
 - `metadata.measurements.connected_cluster`, `number`
 - `metadata.measurements.limit`, `number`
 - `metadata.measurements.sum`, `number`
 - `timestamp`, `datetime`

#### PostgREST
 - `event_message`, `string`
 - `id`, `string`
 - `identifier`, `string`
 - `metadata.host`, `string`
 - `timestamp`, `datetime`

#### Supavisor (Shared Pooler)
 - `event_message`, `string`
 - `id`, `string`
 - `metadata.context.application`, `string`
 - `metadata.context.domain`, `string[]`
 - `metadata.context.file`, `string`
 - `metadata.context.function`, `string`
 - `metadata.context.gl`, `string`
 - `metadata.context.line`, `number`
 - `metadata.context.mfa`, `string[]`
 - `metadata.context.module`, `string`
 - `metadata.context.pid`, `string`
 - `metadata.context.time`, `number`
 - `metadata.context.vm.node`, `string`
 - `metadata.db_name`, `string`
 - `metadata.instance_id`, `string`
 - `metadata.level`, `string`
 - `metadata.project`, `string`
 - `metadata.region`, `string`
 - `metadata.type`, `string`
 - `metadata.user`, `string`
 - `timestamp`, `datetime`

#### PgBouncer (Dedicated Pooler)
 - `event_message`, `string`
 - `file`, `string`
 - `id`, `string`
 - `metadata.host`, `string`
 - `project`, `string`
 - `timestamp`, `datetime`

#### Database Version Upgrade
 - `event_message`, `string`
 - `id`, `string`
 - `timestamp`, `datetime`

#### Multigres
 - `cluster`, `string`
 - `component`, `string`
 - `event_message`, `string`
 - `id`, `string`
 - `namespace`, `string`
 - `node_name`, `string`
 - `pod_name`, `string`
 - `project`, `string`
 - `region`, `string`
 - `stack`, `string`
 - `timestamp`, `datetime`