postgres.logs | Logflare | Cloudflare, Vercel & Elixir Logging

~/logs/postgres.logs

1750219554835647 event body

{
  "appname": "supabase-db",
  "event_message": null,
  "id": "d68b7ead-3076-4240-87ad-ecc0c37de00c",
  "project": "default",
  "timestamp": 1750219554835647
}

1750219554836597 The default database encoding has accordingly been set to "UTF8". event body

{
  "appname": "supabase-db",
  "event_message": "The default database encoding has accordingly been set to \"UTF8\".",
  "id": "fff73718-75c3-4e98-81b8-d0d4336632f3",
  "project": "default",
  "timestamp": 1750219554836597
}

1750219554836667 event body

{
  "appname": "supabase-db",
  "event_message": null,
  "id": "4c80d1d1-fcc8-4ce4-acfc-cf8d287f05c5",
  "project": "default",
  "timestamp": 1750219554836667
}

1750219554856560 selecting default max_connections ... 100 event body

{
  "appname": "supabase-db",
  "event_message": "selecting default max_connections ... 100",
  "id": "84fc0852-54bf-474d-a674-46deabc867cc",
  "project": "default",
  "timestamp": 1750219554856560
}

1750219554895013 selecting default time zone ... Etc/UTC event body

{
  "appname": "supabase-db",
  "event_message": "selecting default time zone ... Etc/UTC",
  "id": "3d658417-d312-4a12-9b8f-e9f491de3ca0",
  "project": "default",
  "timestamp": 1750219554895013
}

1750219555016051 running bootstrap script ... ok event body

{
  "appname": "supabase-db",
  "event_message": "running bootstrap script ... ok",
  "id": "e98d41f2-c6c1-4897-b283-fd64a7445b8e",
  "project": "default",
  "timestamp": 1750219555016051
}

1750219555338690 performing post-bootstrap initialization ... ok event body

{
  "appname": "supabase-db",
  "event_message": "performing post-bootstrap initialization ... ok",
  "id": "e9b14646-53b4-45b1-83b4-468fc2e0ed85",
  "project": "default",
  "timestamp": 1750219555338690
}

1750219555495440 event body

{
  "appname": "supabase-db",
  "event_message": null,
  "id": "e460c3ee-0662-44f9-94da-9689b6ad59f2",
  "project": "default",
  "timestamp": 1750219555495440
}

1750219555724423 waiting for server to start.... done event body

{
  "appname": "supabase-db",
  "event_message": "waiting for server to start.... done",
  "id": "c976b24e-d23c-416c-af5d-b62be901ee45",
  "project": "default",
  "timestamp": 1750219555724423
}

1750219555724486 server started event body

{
  "appname": "supabase-db",
  "event_message": "server started",
  "id": "eea2cf90-fd28-4697-85e8-27864a02ac84",
  "project": "default",
  "timestamp": 1750219555724486
}

1750219555790528 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "0fbe4717-1fd5-4806-a3af-e366b97294de",
  "project": "default",
  "timestamp": 1750219555790528
}

1750219555801627 CREATE ROLE event body

{
  "appname": "supabase-db",
  "event_message": "CREATE ROLE",
  "id": "47842e94-c9d2-476e-92d7-bff80c0fa46a",
  "project": "default",
  "timestamp": 1750219555801627
}

1750219555828480 GRANT ROLE event body

{
  "appname": "supabase-db",
  "event_message": "GRANT ROLE",
  "id": "a2bd7009-a0f4-4953-becd-ea127e0237ef",
  "project": "default",
  "timestamp": 1750219555828480
}

1750219555836994 ALTER DEFAULT PRIVILEGES event body

{
  "appname": "supabase-db",
  "event_message": "ALTER DEFAULT PRIVILEGES",
  "id": "12747422-df61-4d97-b764-ea4117bb3024",
  "project": "default",
  "timestamp": 1750219555836994
}

1750219555840454 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/init-scripts/00000000000001-auth-schema.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/init-scripts/00000000000001-auth-schema.sql",
  "id": "c22e4347-6c1c-4531-92db-cf6a53cf072a",
  "project": "default",
  "timestamp": 1750219555840454
}

1750219555861005 CREATE INDEX event body

{
  "appname": "supabase-db",
  "event_message": "CREATE INDEX",
  "id": "c38eb3d8-c5f7-49f7-8e5a-ac0176ae3243",
  "project": "default",
  "timestamp": 1750219555861005
}

1750219555863001 CREATE INDEX event body

{
  "appname": "supabase-db",
  "event_message": "CREATE INDEX",
  "id": "8e44d1bd-eb86-42d1-a9e3-4c430767b447",
  "project": "default",
  "timestamp": 1750219555863001
}

1750219555869540 CREATE TABLE event body

{
  "appname": "supabase-db",
  "event_message": "CREATE TABLE",
  "id": "d55698ef-381e-4eb0-90bd-b776df557e0c",
  "project": "default",
  "timestamp": 1750219555869540
}

1750219555888726 CREATE INDEX event body

{
  "appname": "supabase-db",
  "event_message": "CREATE INDEX",
  "id": "d0c28a7e-b199-4a40-9c82-2a48c680a16a",
  "project": "default",
  "timestamp": 1750219555888726
}

1750219555891837 CREATE TABLE event body

{
  "appname": "supabase-db",
  "event_message": "CREATE TABLE",
  "id": "fa4b5e93-49f5-41b3-a4b8-e01ee1b02390",
  "project": "default",
  "timestamp": 1750219555891837
}

1750219555893430 INSERT 0 7 event body

{
  "appname": "supabase-db",
  "event_message": "INSERT 0 7",
  "id": "4e3cafc2-af6e-4407-93c5-e614a87d11a3",
  "project": "default",
  "timestamp": 1750219555893430
}

1750219555897121 CREATE ROLE event body

{
  "appname": "supabase-db",
  "event_message": "CREATE ROLE",
  "id": "706b24cf-b3ea-411d-9e4e-0e8df39b4563",
  "project": "default",
  "timestamp": 1750219555897121
}

1750219555899174 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "276fe5ff-9bd4-4e57-b187-fdcea6440e51",
  "project": "default",
  "timestamp": 1750219555899174
}

1750219555922445 CREATE TABLE event body

{
  "appname": "supabase-db",
  "event_message": "CREATE TABLE",
  "id": "40ec532c-db8b-4e29-804a-6b748c937532",
  "project": "default",
  "timestamp": 1750219555922445
}

1750219555931989 CREATE INDEX event body

{
  "appname": "supabase-db",
  "event_message": "CREATE INDEX",
  "id": "a747cc73-eedb-48ce-8774-db7aeddf7bc7",
  "project": "default",
  "timestamp": 1750219555931989
}

1750219555937388 CREATE FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE FUNCTION",
  "id": "ae2790e9-0e8c-41d9-b59d-ac383c40eaca",
  "project": "default",
  "timestamp": 1750219555937388
}

1750219555945423 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "2e88ede2-b4b4-440b-a5ca-c3c05947b7e0",
  "project": "default",
  "timestamp": 1750219555945423
}

1750219555948839 ALTER TABLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER TABLE",
  "id": "cf4fdc00-c9ea-4dcf-abbd-1335f80ae4ed",
  "project": "default",
  "timestamp": 1750219555948839
}

1750219555949599 ALTER FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "ALTER FUNCTION",
  "id": "b4b2c582-1a40-4c28-9cae-f65c506eb839",
  "project": "default",
  "timestamp": 1750219555949599
}

1750219555951116 ALTER FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "ALTER FUNCTION",
  "id": "a45c67b1-f676-4e4a-adb0-cb88ca810795",
  "project": "default",
  "timestamp": 1750219555951116
}

1750219555964444 COMMENT event body

{
  "appname": "supabase-db",
  "event_message": "COMMENT",
  "id": "4f899781-4eaa-4b59-8c5e-877377460c84",
  "project": "default",
  "timestamp": 1750219555964444
}

1750219555974395 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "f6a86a5b-79bd-4db9-932b-76ceb1515c52",
  "project": "default",
  "timestamp": 1750219555974395
}

1750219555978617 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/init-scripts/98-webhooks.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/init-scripts/98-webhooks.sql",
  "id": "f979b1f0-3211-4ac9-aa06-5d2397c4a95e",
  "project": "default",
  "timestamp": 1750219555978617
}

1750219555986177 BEGIN event body

{
  "appname": "supabase-db",
  "event_message": "BEGIN",
  "id": "cfe2a01b-396f-46a4-a408-d0336a93513b",
  "project": "default",
  "timestamp": 1750219555986177
}

1750219556007731 CREATE TABLE event body

{
  "appname": "supabase-db",
  "event_message": "CREATE TABLE",
  "id": "7dd0db81-c855-4505-a3b8-ffa15393034b",
  "project": "default",
  "timestamp": 1750219556007731
}

1750219556013962 CREATE INDEX event body

{
  "appname": "supabase-db",
  "event_message": "CREATE INDEX",
  "id": "c35df8d2-b553-465d-9cec-3b6c3e83e842",
  "project": "default",
  "timestamp": 1750219556013962
}

1750219556015070 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "0b9dd34c-2aab-4ecc-bfd8-c05414f07ab3",
  "project": "default",
  "timestamp": 1750219556015070
}

1750219556015398 ALTER ROLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER ROLE",
  "id": "eb3705cc-b324-4116-87b0-10af496cfba5",
  "project": "default",
  "timestamp": 1750219556015398
}

1750219556017135 COMMENT event body

{
  "appname": "supabase-db",
  "event_message": "COMMENT",
  "id": "a932c23e-e0ec-4972-96b1-4a3940107a86",
  "project": "default",
  "timestamp": 1750219556017135
}

1750219556017468 INSERT 0 1 event body

{
  "appname": "supabase-db",
  "event_message": "INSERT 0 1",
  "id": "f576ad90-e123-4db6-8091-c97bd6713df7",
  "project": "default",
  "timestamp": 1750219556017468
}

1750219556017569 ALTER FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "ALTER FUNCTION",
  "id": "eb79ece5-ee76-4448-80cd-86043a3e29c4",
  "project": "default",
  "timestamp": 1750219556017569
}

1750219556017820 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "d2eac89c-c8bb-4260-af34-2b4d83d7cb68",
  "project": "default",
  "timestamp": 1750219556017820
}

1750219556047955 ALTER ROLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER ROLE",
  "id": "2a938076-b79b-4851-8c65-3e2ecaa61293",
  "project": "default",
  "timestamp": 1750219556047955
}

1750219556067399 ALTER ROLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER ROLE",
  "id": "c26c900c-cf56-4f0a-adf5-ef902372c0e4",
  "project": "default",
  "timestamp": 1750219556067399
}

1750219556126464 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "3c7df88d-6bc5-4caa-9927-33e73e9d8143",
  "project": "default",
  "timestamp": 1750219556126464
}

1750219556147175 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "e184b542-8086-433d-970b-c61293653856",
  "project": "default",
  "timestamp": 1750219556147175
}

1750219556149220 ALTER TABLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER TABLE",
  "id": "c841d2c8-0f15-4d8e-b512-88ed18474c77",
  "project": "default",
  "timestamp": 1750219556149220
}

1750219556156545 ALTER DEFAULT PRIVILEGES event body

{
  "appname": "supabase-db",
  "event_message": "ALTER DEFAULT PRIVILEGES",
  "id": "0c4c3bcc-06bc-436b-a97a-dc791585357e",
  "project": "default",
  "timestamp": 1750219556156545
}

1750219556157853 ALTER DEFAULT PRIVILEGES event body

{
  "appname": "supabase-db",
  "event_message": "ALTER DEFAULT PRIVILEGES",
  "id": "0dc4cb31-3d53-451c-bcc8-648734a15aa9",
  "project": "default",
  "timestamp": 1750219556157853
}

1750219556174289 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20211122051245_update-realtime-permissions.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20211122051245_update-realtime-permissions.sql",
  "id": "912b48ac-c350-4ff9-a1a4-92eb2d3d8ca8",
  "project": "default",
  "timestamp": 1750219556174289
}

1750219556188933 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20211124212715_update-auth-owner.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20211124212715_update-auth-owner.sql",
  "id": "79d38eb5-9e3a-4e23-b7e8-011bbe2de1fa",
  "project": "default",
  "timestamp": 1750219556188933
}

1750219556247084 psql:/docker-entrypoint-initdb.d/migrations/20220126121436_finer-postgrest-triggers.sql:59: NOTICE: event trigger "pgrst_ddl_watch" does not exist, skipping event body

{
  "appname": "supabase-db",
  "event_message": "psql:/docker-entrypoint-initdb.d/migrations/20220126121436_finer-postgrest-triggers.sql:59: NOTICE:  event trigger \"pgrst_ddl_watch\" does not exist, skipping",
  "id": "4f6a8e30-f7d0-4c81-92ce-0fee90d8a6d1",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "NOTICE",
      "timestamp": "2025-06-18T04:05:56.247084648Z"
    }
  },
  "project": "default",
  "timestamp": 1750219556247084
}

1750219556247622 CREATE EVENT TRIGGER event body

{
  "appname": "supabase-db",
  "event_message": "CREATE EVENT TRIGGER",
  "id": "205e093e-59e2-487d-8fa0-d6a6ca674514",
  "project": "default",
  "timestamp": 1750219556247622
}

1750219556248470 CREATE EVENT TRIGGER event body

{
  "appname": "supabase-db",
  "event_message": "CREATE EVENT TRIGGER",
  "id": "3e717ff8-3534-4e5b-b1c2-d434f6178adb",
  "project": "default",
  "timestamp": 1750219556248470
}

1750219556249805 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20220224211803_fix-postgrest-supautils.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20220224211803_fix-postgrest-supautils.sql",
  "id": "87167c53-dc80-48c5-b91f-b69dfe111b11",
  "project": "default",
  "timestamp": 1750219556249805
}

1750219556309677 CREATE SCHEMA event body

{
  "appname": "supabase-db",
  "event_message": "CREATE SCHEMA",
  "id": "cc182170-40a4-4081-8e85-7189f544f361",
  "project": "default",
  "timestamp": 1750219556309677
}

1750219556309896 DROP FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "DROP FUNCTION",
  "id": "96da0136-891c-4270-ae23-332b88540a2d",
  "project": "default",
  "timestamp": 1750219556309896
}

1750219556313152 ALTER DEFAULT PRIVILEGES event body

{
  "appname": "supabase-db",
  "event_message": "ALTER DEFAULT PRIVILEGES",
  "id": "9aa44a92-a77a-4d6d-8b3b-e15f44752003",
  "project": "default",
  "timestamp": 1750219556313152
}

1750219556314503 ALTER DEFAULT PRIVILEGES event body

{
  "appname": "supabase-db",
  "event_message": "ALTER DEFAULT PRIVILEGES",
  "id": "01b9a703-d582-4fc6-95a1-8c343e341717",
  "project": "default",
  "timestamp": 1750219556314503
}

1750219556317541 DROP EVENT TRIGGER event body

{
  "appname": "supabase-db",
  "event_message": "DROP EVENT TRIGGER",
  "id": "b918b429-99c7-4747-85c0-f42e787dc0b0",
  "project": "default",
  "timestamp": 1750219556317541
}

1750219556319208 COMMENT event body

{
  "appname": "supabase-db",
  "event_message": "COMMENT",
  "id": "603bdce9-d039-4e9c-a022-e7f73b45aa63",
  "project": "default",
  "timestamp": 1750219556319208
}

1750219556321509 psql:/docker-entrypoint-initdb.d/migrations/20220317095840_pg_graphql.sql:143: NOTICE: event trigger "issue_graphql_placeholder" does not exist, skipping event body

{
  "appname": "supabase-db",
  "event_message": "psql:/docker-entrypoint-initdb.d/migrations/20220317095840_pg_graphql.sql:143: NOTICE:  event trigger \"issue_graphql_placeholder\" does not exist, skipping",
  "id": "03a80396-7f01-49ec-9ddd-6c1fe6415449",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "NOTICE",
      "timestamp": "2025-06-18T04:05:56.321509379Z"
    }
  },
  "project": "default",
  "timestamp": 1750219556321509
}

1750219556335977 DROP EVENT TRIGGER event body

{
  "appname": "supabase-db",
  "event_message": "DROP EVENT TRIGGER",
  "id": "4eef05d9-ee95-4dff-98c0-91e4b22cf4cb",
  "project": "default",
  "timestamp": 1750219556335977
}

1750219556336077 psql:/docker-entrypoint-initdb.d/migrations/20220321174452_fix-postgrest-alter-type-event-trigger.sql:3: NOTICE: event trigger "api_restart" does not exist, skipping event body

{
  "appname": "supabase-db",
  "event_message": "psql:/docker-entrypoint-initdb.d/migrations/20220321174452_fix-postgrest-alter-type-event-trigger.sql:3: NOTICE:  event trigger \"api_restart\" does not exist, skipping",
  "id": "4b788291-aec1-4039-9fa4-62b9a5c216e5",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "NOTICE",
      "timestamp": "2025-06-18T04:05:56.336077775Z"
    }
  },
  "project": "default",
  "timestamp": 1750219556336077
}

1750219556340282 CREATE FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE FUNCTION",
  "id": "98b6ccf5-70e4-4b86-9ad5-d356e2f17882",
  "project": "default",
  "timestamp": 1750219556340282
}

1750219556342229 DROP EVENT TRIGGER event body

{
  "appname": "supabase-db",
  "event_message": "DROP EVENT TRIGGER",
  "id": "bcce1090-49f0-4a07-9506-4f9098f105b7",
  "project": "default",
  "timestamp": 1750219556342229
}

1750219556357784 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20220404205710_pg_graphql-on-by-default.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20220404205710_pg_graphql-on-by-default.sql",
  "id": "a86ef60c-7c74-4b98-b234-29e1ee787a39",
  "project": "default",
  "timestamp": 1750219556357784
}

1750219556374335 CREATE FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE FUNCTION",
  "id": "1cb61458-992a-4341-9832-e47c2a49d226",
  "project": "default",
  "timestamp": 1750219556374335
}

1750219556378086 CREATE FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE FUNCTION",
  "id": "39ed3830-030a-4e81-8707-ee658c9fdd4a",
  "project": "default",
  "timestamp": 1750219556378086
}

1750219556380888 CREATE FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE FUNCTION",
  "id": "438fc845-fa6c-4aa8-864f-c573b27c23a1",
  "project": "default",
  "timestamp": 1750219556380888
}

1750219556381147 DROP EXTENSION event body

{
  "appname": "supabase-db",
  "event_message": "DROP EXTENSION",
  "id": "6eb5e6ed-207c-4cff-abb2-9b051993f828",
  "project": "default",
  "timestamp": 1750219556381147
}

1750219556397337 DO event body

{
  "appname": "supabase-db",
  "event_message": "DO",
  "id": "d958b260-c290-4a78-bfa9-75926db6f433",
  "project": "default",
  "timestamp": 1750219556397337
}

1750219556398332 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20220609081115_grant-supabase-auth-admin-and-supabase-storage-admin-to-postgres.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20220609081115_grant-supabase-auth-admin-and-supabase-storage-admin-to-postgres.sql",
  "id": "6d81bb4d-6aa9-4bc2-b454-0a530c365cc0",
  "project": "default",
  "timestamp": 1750219556398332
}

1750219556465322 DO event body

{
  "appname": "supabase-db",
  "event_message": "DO",
  "id": "27dd828b-f594-412c-9423-c557f5bd7878",
  "project": "default",
  "timestamp": 1750219556465322
}

1750219556485938 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20221103090837_revoke_admin.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20221103090837_revoke_admin.sql",
  "id": "e3387427-98e0-46ab-a378-b157939c41e0",
  "project": "default",
  "timestamp": 1750219556485938
}

1750219556500895 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20221207154255_create_pgsodium_and_vault.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20221207154255_create_pgsodium_and_vault.sql",
  "id": "7794c70d-0a3c-4f90-b6cc-d03a25e1455a",
  "project": "default",
  "timestamp": 1750219556500895
}

1750219556563846 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "5a11af5d-59b5-48ec-8587-73eb88fe9481",
  "project": "default",
  "timestamp": 1750219556563846
}

1750219556566200 ALTER DEFAULT PRIVILEGES event body

{
  "appname": "supabase-db",
  "event_message": "ALTER DEFAULT PRIVILEGES",
  "id": "8ab6a306-9c4a-40f6-b772-fc8cb7636991",
  "project": "default",
  "timestamp": 1750219556566200
}

1750219556626801 GRANT ROLE event body

{
  "appname": "supabase-db",
  "event_message": "GRANT ROLE",
  "id": "9ea2759b-0489-407b-bcc4-32a699fd6951",
  "project": "default",
  "timestamp": 1750219556626801
}

1750219556627941 REVOKE ROLE event body

{
  "appname": "supabase-db",
  "event_message": "REVOKE ROLE",
  "id": "eae47a98-9053-405a-9a12-21000ff7f1ce",
  "project": "default",
  "timestamp": 1750219556627941
}

1750219556628889 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20231017062225_grant_pg_graphql_permissions_for_custom_roles.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20231017062225_grant_pg_graphql_permissions_for_custom_roles.sql",
  "id": "544388c9-6152-4a66-a897-97cd841e7944",
  "project": "default",
  "timestamp": 1750219556628889
}

1750219556644416 CREATE FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE FUNCTION",
  "id": "d65073af-b30e-4d1c-8ef0-dc55fea4247a",
  "project": "default",
  "timestamp": 1750219556644416
}

1750219556649181 DROP EXTENSION event body

{
  "appname": "supabase-db",
  "event_message": "DROP EXTENSION",
  "id": "451bda10-363b-4471-9873-50d26f3e67bf",
  "project": "default",
  "timestamp": 1750219556649181
}

1750219556660760 DO event body

{
  "appname": "supabase-db",
  "event_message": "DO",
  "id": "29aa30e6-5e03-4ece-83f0-ffb1569ff175",
  "project": "default",
  "timestamp": 1750219556660760
}

1750219556676646 CREATE FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE FUNCTION",
  "id": "8b562bd8-358b-425c-aa85-e839069c412e",
  "project": "default",
  "timestamp": 1750219556676646
}

1750219556677725 DROP EVENT TRIGGER event body

{
  "appname": "supabase-db",
  "event_message": "DROP EVENT TRIGGER",
  "id": "2eabe914-acf7-4087-9b00-7cfd31f165a3",
  "project": "default",
  "timestamp": 1750219556677725
}

1750219556709103 ALTER FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "ALTER FUNCTION",
  "id": "61c3ab57-d6d0-4dd7-84a5-6fb7e3455805",
  "project": "default",
  "timestamp": 1750219556709103
}

1750219556725332 GRANT ROLE event body

{
  "appname": "supabase-db",
  "event_message": "GRANT ROLE",
  "id": "71887080-a693-47cc-91b3-7798c442515d",
  "project": "default",
  "timestamp": 1750219556725332
}

1750219556742254 DO event body

{
  "appname": "supabase-db",
  "event_message": "DO",
  "id": "1af9f29b-accc-4d38-be86-2f0766a640d7",
  "project": "default",
  "timestamp": 1750219556742254
}

1750219556757617 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20250205060043_disable_log_statement_on_internal_roles.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20250205060043_disable_log_statement_on_internal_roles.sql",
  "id": "788ed969-d9aa-4fd7-986e-0539d9fb34a0",
  "project": "default",
  "timestamp": 1750219556757617
}

1750219556771158 ALTER ROLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER ROLE",
  "id": "a15d74fb-c357-4579-8a60-c32932e7bfab",
  "project": "default",
  "timestamp": 1750219556771158
}

1750219556805987 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20250220051611_pg_net_perms_fix.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20250220051611_pg_net_perms_fix.sql",
  "id": "9d8a507a-e9e7-4b31-9f73-86c6c44f9ea9",
  "project": "default",
  "timestamp": 1750219556805987
}

1750219556908327 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/99-logs.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/99-logs.sql",
  "id": "0721c3bd-1616-4f77-a5e7-f418600f90b7",
  "project": "default",
  "timestamp": 1750219556908327
}

1750219556936900 CREATE SCHEMA event body

{
  "appname": "supabase-db",
  "event_message": "CREATE SCHEMA",
  "id": "9358029b-82b5-4a02-8eec-6ed9a5116ed7",
  "project": "default",
  "timestamp": 1750219556936900
}

1750219556944294 You are now connected to database "postgres" as user "supabase_admin". event body

{
  "appname": "supabase-db",
  "event_message": "You are now connected to database \"postgres\" as user \"supabase_admin\".",
  "id": "9dfd8ecb-b02c-42a5-8c66-ba22b6a94845",
  "project": "default",
  "timestamp": 1750219556944294
}

1750219556997009 ALTER SCHEMA event body

{
  "appname": "supabase-db",
  "event_message": "ALTER SCHEMA",
  "id": "c85aaa39-101c-4405-ba8d-686718f74549",
  "project": "default",
  "timestamp": 1750219556997009
}

1750219557010873 -------------------------- event body

{
  "appname": "supabase-db",
  "event_message": "--------------------------",
  "id": "4776146f-c2f4-4e9c-af07-6df2b1ffc82c",
  "project": "default",
  "timestamp": 1750219557010873
}

1750219557010895 event body

{
  "appname": "supabase-db",
  "event_message": " ",
  "id": "0c4f5f47-5eb9-4216-a5d2-9d78c54bf0d3",
  "project": "default",
  "timestamp": 1750219557010895
}

1750219557114261 server stopped event body

{
  "appname": "supabase-db",
  "event_message": "server stopped",
  "id": "1fb6c7f7-d199-428f-9bc5-3ba56bf499fe",
  "project": "default",
  "timestamp": 1750219557114261
}

1750219557116041 event body

{
  "appname": "supabase-db",
  "event_message": null,
  "id": "a263c65b-53b4-453c-b85d-c9afa4e1e708",
  "project": "default",
  "timestamp": 1750219557116041
}

random(tips): Integers support greater and less than symobols (e.g. `m.response.origin_time:<1000`).

Source ID

You'll need this source ID for some integrations or libraries.

2310e004-1ede-4936-b3b8-2c7993342124

If you're hosted on Vercel setup our Vercel integration!

Install the Vercel integration

Gigalixir

Install the Gigalixir command line tool, and navigate to your project directory.

          
    gigalixir drains:add "http://localhost:4000/logs/logplex?api_key=TjYyp9S-BILJ&source=2310e004-1ede-4936-b3b8-2c7993342124"

Cloudflare App

Already on Cloudflare? Install the Cloudflare app and start sending logs now.

Heroku

Add our log drain with a simple command.

          
    heroku drains:add "http://localhost:4000/logs/logplex?api_key=TjYyp9S-BILJ&source=2310e004-1ede-4936-b3b8-2c7993342124"

Elixir Logger

Using Elixir? Use our Logger backend to send your structured logs.

Setup the Logger backend

Elixir Agent

Watch log files on a server with our Elixir agent.

Install the agent

Javascript

Use our official Pino transport to send log events from your Javascript project.

Setup the Pino transport

Github Webhook

Set your Github webhook to this Logflare endpoint and we'll ingest Github webhooks for you. This endpoint drops all keys ending in _url so it keeps your Github payloads in check.

        
http://localhost:4000/logs/github?api_key=TjYyp9S-BILJ&source=2310e004-1ede-4936-b3b8-2c7993342124

Github Action

Use our Github Action (thanks @gr2m) to easily log events coming from your repositories.

Setup the Github Action

Fluent Bit

Watch log files on a server with this Fluent Bit output config.

          
    [INPUT]
        Name        tail
        Path        /var/log/syslog

    [OUTPUT]
        Name             http
        Match            *
        tls              On
        Host             api.logflare.app
        Port             443
        URI              /logs/json?api_key=TjYyp9S-BILJ&source=2310e004-1ede-4936-b3b8-2c7993342124
        Format           json
        Retry_Limit      5
        json_date_format iso8601
        json_date_key    timestamp

Generic Webhook

Use the generic JSON ingest endpoint to generate log events from an external webhook.

e.g. you can set a Github webhook to send events to:

          
http://localhost:4000/logs/json?api_key=TjYyp9S-BILJ&source=2310e004-1ede-4936-b3b8-2c7993342124

Or send generic JSON events yourself.

          
    curl -X "POST" "http://localhost:4000/logs/json?source=2310e004-1ede-4936-b3b8-2c7993342124" \
         -H 'Content-Type: application/json; charset=utf-8' \
         -H 'X-API-KEY: TjYyp9S-BILJ' \
         -d $'[
      {
        "yellow": true,
        "tags": [
          "popular, tropical, organic"
        ],
        "store": {
          "state": "AZ",
          "city": "Phoenix",
          "zip": 85016,
          "address": "123 W Main St"
        },
        "type": "fruit",
        "name": "banana",
        "qty": 12
      }
    ]'

Custom API Request

Send logs via an HTTP request. This request body payload lets you send over a human readable event message in the message field.

          
    curl -X "POST" "http://localhost:4000/logs?source=2310e004-1ede-4936-b3b8-2c7993342124" \
    -H 'Content-Type: application/json' \
    -H 'X-API-KEY: TjYyp9S-BILJ' \
    -d $'{
      "event_message": "This is another log message.",
      "metadata": {
        "ip_address": "100.100.100.100",
        "request_method": "POST",
        "custom_user_data": {
          "vip": true,
          "id": 38,
          "login_count": 154,
          "company": "Apple",
          "address": {
            "zip": "11111",
            "st": "NY",
            "street": "123 W Main St",
            "city": "New York"
          }
        },
        "datacenter": "aws",
        "request_headers": {
          "connection": "close",
          "user_agent": "chrome"
        }
      }
    }'

Custom Cloudflare Worker

Customize the Cloudflare worker using the template below.

          
    const makeid = length => {
        let text = ""
        const possible = "ABCDEFGHIJKLMNPQRSTUVWXYZ0123456789"
        for (let i = 0; i < length; i += 1) {
            text += possible.charAt(Math.floor(Math.random() * possible.length))
        }
        return text
    }

    const buildMetadataFromHeaders = headers => {
        const responseMetadata = {}
        Array.from(headers).forEach(([key, value]) => {
            responseMetadata[key.replace(/-/g, "_")] = value
        })
        return responseMetadata
    }

    const WORKER_ID = makeid(6)

    async function handleRequest(event) {
        const {
            request
        } = event;
        const rMeth = request.method
        const rUrl = request.url
        const uAgent = request.headers.get("user-agent")
        const rHost = request.headers.get("host")
        const cfRay = request.headers.get("cf-ray")
        const cIP = request.headers.get("cf-connecting-ip")
        const rCf = request.cf

        const requestMetadata = buildMetadataFromHeaders(request.headers)

        const sourceKey = "2310e004-1ede-4936-b3b8-2c7993342124"
        const apiKey = "TjYyp9S-BILJ"

        const t1 = Date.now()
        const response = await fetch(request)
        const originTimeMs = Date.now() - t1

        const statusCode = response.status

        const responseMetadata = buildMetadataFromHeaders(response.headers)

        const logEntry = `${rMeth} | ${statusCode} | ${cIP} | ${cfRay} | ${rUrl} | ${uAgent}`

        const logflareEventBody = {
            source: sourceKey,
            log_entry: logEntry,
            metadata: {
                response: {
                    headers: responseMetadata,
                    origin_time: originTimeMs,
                    status_code: response.status,
                },
                request: {
                    url: rUrl,
                    method: rMeth,
                    headers: requestMetadata,
                    cf: rCf,
                },
                logflare_worker: {
                    worker_id: WORKER_ID,
                },
            },
        }

        const init = {
            method: "POST",
            headers: {
                "X-API-KEY": apiKey,
                "Content-Type": "application/json",
                "User-Agent": `Cloudflare Worker via ${rHost}`
            },
            body: JSON.stringify(logflareEventBody),
        }

        event.waitUntil(fetch("http://localhost:4000/logs", init))

        return response
    }

    addEventListener("fetch", event => {
        event.passThroughOnException()

        event.respondWith(handleRequest(event))
    })