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

~/logs/postgres.logs

1764340109273494 event body

{
  "appname": "supabase-db",
  "event_message": null,
  "id": "efe3d563-ba8e-467b-ad05-af7f2d2e301e",
  "project": "default",
  "timestamp": 1764340109273494
}

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

{
  "appname": "supabase-db",
  "event_message": "performing post-bootstrap initialization ... ok",
  "id": "b847492e-5789-4465-85c3-2dd23fd647d2",
  "project": "default",
  "timestamp": 1764340109726353
}

1764340109928368 initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb. event body

{
  "appname": "supabase-db",
  "event_message": "initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.",
  "id": "105af7e1-0d5b-4765-a1b0-1cbec53a8a78",
  "project": "default",
  "timestamp": 1764340109928368
}

1764340109928375 event body

{
  "appname": "supabase-db",
  "event_message": null,
  "id": "8c817c0b-0621-4da1-9421-3674864e6726",
  "project": "default",
  "timestamp": 1764340109928375
}

1764340109928378 event body

{
  "appname": "supabase-db",
  "event_message": null,
  "id": "99f263f0-3fcf-4ce7-84e4-17e3ad3c3807",
  "project": "default",
  "timestamp": 1764340109928378
}

1764340109928387 event body

{
  "appname": "supabase-db",
  "event_message": null,
  "id": "2c636975-042a-4dac-882f-c0bfe244caf2",
  "project": "default",
  "timestamp": 1764340109928387
}

1764340110049638 server started event body

{
  "appname": "supabase-db",
  "event_message": "server started",
  "id": "db72a601-dd81-43c7-8de2-c08b82ec0d75",
  "project": "default",
  "timestamp": 1764340110049638
}

1764340110091803 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/init-scripts/00-schema.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/init-scripts/00-schema.sql",
  "id": "c9d02387-4ee6-408d-8a31-f120202f0e24",
  "project": "default",
  "timestamp": 1764340110091803
}

1764340110098193 CREATE ROLE event body

{
  "appname": "supabase-db",
  "event_message": "CREATE ROLE",
  "id": "0ff1e508-0d20-4483-9602-379f1c61103a",
  "project": "default",
  "timestamp": 1764340110098193
}

1764340110109763 ALTER ROLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER ROLE",
  "id": "44463a4b-bbcb-42e3-ad13-eb4d3d1ec2e4",
  "project": "default",
  "timestamp": 1764340110109763
}

1764340110114594 CREATE EXTENSION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE EXTENSION",
  "id": "84c82d04-e68a-4e9f-a43c-a75cac48d43f",
  "project": "default",
  "timestamp": 1764340110114594
}

1764340110131941 GRANT ROLE event body

{
  "appname": "supabase-db",
  "event_message": "GRANT ROLE",
  "id": "a1316861-9f2b-4b65-b969-2e71060b46d9",
  "project": "default",
  "timestamp": 1764340110131941
}

1764340110133537 ALTER DEFAULT PRIVILEGES event body

{
  "appname": "supabase-db",
  "event_message": "ALTER DEFAULT PRIVILEGES",
  "id": "965be26a-760e-4ed2-9df8-eb0401b40308",
  "project": "default",
  "timestamp": 1764340110133537
}

1764340110134180 ALTER DEFAULT PRIVILEGES event body

{
  "appname": "supabase-db",
  "event_message": "ALTER DEFAULT PRIVILEGES",
  "id": "33f40213-e188-449c-b745-8d0896e04441",
  "project": "default",
  "timestamp": 1764340110134180
}

1764340110134533 ALTER DEFAULT PRIVILEGES event body

{
  "appname": "supabase-db",
  "event_message": "ALTER DEFAULT PRIVILEGES",
  "id": "4761d102-ea5a-4f9a-852d-0c37dd4febdb",
  "project": "default",
  "timestamp": 1764340110134533
}

1764340110134845 ALTER ROLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER ROLE",
  "id": "af45fa84-a8a0-43e9-ae25-6eadbe9a8188",
  "project": "default",
  "timestamp": 1764340110134845
}

1764340110140225 CREATE SCHEMA event body

{
  "appname": "supabase-db",
  "event_message": "CREATE SCHEMA",
  "id": "0a705258-8358-430f-9652-aa6c0dcd5e24",
  "project": "default",
  "timestamp": 1764340110140225
}

1764340110146258 CREATE INDEX event body

{
  "appname": "supabase-db",
  "event_message": "CREATE INDEX",
  "id": "ba905230-a6bc-4cfc-9553-4235330a3562",
  "project": "default",
  "timestamp": 1764340110146258
}

1764340110153220 CREATE TABLE event body

{
  "appname": "supabase-db",
  "event_message": "CREATE TABLE",
  "id": "de00ba2c-c211-4cec-ae67-1ea0bc4efee3",
  "project": "default",
  "timestamp": 1764340110153220
}

1764340110158223 CREATE FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE FUNCTION",
  "id": "617fe6c3-cc00-4b16-a7c7-4762bbaa8bc0",
  "project": "default",
  "timestamp": 1764340110158223
}

1764340110158413 CREATE FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE FUNCTION",
  "id": "8830b6bb-1e17-44f0-8bd5-0c83dbb3f535",
  "project": "default",
  "timestamp": 1764340110158413
}

1764340110159592 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "6e57ea78-956d-49fb-881b-1d0723ab5a71",
  "project": "default",
  "timestamp": 1764340110159592
}

1764340110161285 ALTER TABLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER TABLE",
  "id": "d7cabe8b-179a-4aef-b79d-b8a3ef706344",
  "project": "default",
  "timestamp": 1764340110161285
}

1764340110161993 ALTER TABLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER TABLE",
  "id": "1865ccb7-5dbc-4f02-b508-53e5a3b40b36",
  "project": "default",
  "timestamp": 1764340110161993
}

1764340110173937 CREATE TABLE event body

{
  "appname": "supabase-db",
  "event_message": "CREATE TABLE",
  "id": "6a20e631-b187-4ce7-b904-904ad79c9a79",
  "project": "default",
  "timestamp": 1764340110173937
}

1764340110178441 CREATE TABLE event body

{
  "appname": "supabase-db",
  "event_message": "CREATE TABLE",
  "id": "c62ce67d-f8f5-49ec-9075-043473a25d0a",
  "project": "default",
  "timestamp": 1764340110178441
}

1764340110180128 CREATE FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE FUNCTION",
  "id": "7ba9af04-7dd4-4784-9122-a2570a08c7f3",
  "project": "default",
  "timestamp": 1764340110180128
}

1764340110180462 CREATE FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE FUNCTION",
  "id": "e722f29f-bcde-4a0c-90cb-cf3568d5ec63",
  "project": "default",
  "timestamp": 1764340110180462
}

1764340110184215 ALTER TABLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER TABLE",
  "id": "2fc3600f-b604-442f-b7c3-55228a077e14",
  "project": "default",
  "timestamp": 1764340110184215
}

1764340110184665 ALTER TABLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER TABLE",
  "id": "f85a9ce5-046e-4573-bd40-d65c009720ed",
  "project": "default",
  "timestamp": 1764340110184665
}

1764340110185113 ALTER FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "ALTER FUNCTION",
  "id": "574aa231-be37-4a22-862d-2e8d990254fa",
  "project": "default",
  "timestamp": 1764340110185113
}

1764340110185352 ALTER FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "ALTER FUNCTION",
  "id": "581b1829-1517-40cb-b816-86b92feb7832",
  "project": "default",
  "timestamp": 1764340110185352
}

1764340110192268 CREATE FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE FUNCTION",
  "id": "a1692426-80b8-4467-bfda-56f1b5efa2d9",
  "project": "default",
  "timestamp": 1764340110192268
}

1764340110192579 CREATE EVENT TRIGGER event body

{
  "appname": "supabase-db",
  "event_message": "CREATE EVENT TRIGGER",
  "id": "8e55c6de-73bd-469a-be9e-f43090672d87",
  "project": "default",
  "timestamp": 1764340110192579
}

1764340110192787 COMMENT event body

{
  "appname": "supabase-db",
  "event_message": "COMMENT",
  "id": "4971c3db-caae-4beb-8494-439ad92eb314",
  "project": "default",
  "timestamp": 1764340110192787
}

1764340110193923 DO event body

{
  "appname": "supabase-db",
  "event_message": "DO",
  "id": "9c44d52f-65da-4449-aa47-aa58b9ff603d",
  "project": "default",
  "timestamp": 1764340110193923
}

1764340110195853 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "f482fbaf-747c-4406-851d-cdaac81cea0b",
  "project": "default",
  "timestamp": 1764340110195853
}

1764340110214724 CREATE EXTENSION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE EXTENSION",
  "id": "28243250-2ed6-4bec-af40-e642e453ffb1",
  "project": "default",
  "timestamp": 1764340110214724
}

1764340110215508 ALTER DEFAULT PRIVILEGES event body

{
  "appname": "supabase-db",
  "event_message": "ALTER DEFAULT PRIVILEGES",
  "id": "cf90ef3c-8cdb-4033-9335-31dc0014b7ea",
  "project": "default",
  "timestamp": 1764340110215508
}

1764340110221722 DO event body

{
  "appname": "supabase-db",
  "event_message": "DO",
  "id": "ca36d8ab-33ca-4758-9c0a-051224845ce4",
  "project": "default",
  "timestamp": 1764340110221722
}

1764340110221871 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "5843e274-5859-4802-b374-44eab426bea0",
  "project": "default",
  "timestamp": 1764340110221871
}

1764340110224360 COMMENT event body

{
  "appname": "supabase-db",
  "event_message": "COMMENT",
  "id": "7d61be98-4630-407d-8ec0-f1aeb63feab3",
  "project": "default",
  "timestamp": 1764340110224360
}

1764340110225035 REVOKE event body

{
  "appname": "supabase-db",
  "event_message": "REVOKE",
  "id": "462a206a-2d68-4021-bca9-c41fb3c6129b",
  "project": "default",
  "timestamp": 1764340110225035
}

1764340110232926 ALTER DATABASE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER DATABASE",
  "id": "dfdb0b1f-acb4-4278-b95b-e21fb9741702",
  "project": "default",
  "timestamp": 1764340110232926
}

1764340110300261 CREATE SCHEMA event body

{
  "appname": "supabase-db",
  "event_message": "CREATE SCHEMA",
  "id": "a2700d0f-60fa-4e74-ac2f-b22a01708cb0",
  "project": "default",
  "timestamp": 1764340110300261
}

1764340110300396 psql:/docker-entrypoint-initdb.d/migrations/00-extension.sql:1: NOTICE: schema "extensions" already exists, skipping event body

{
  "appname": "supabase-db",
  "event_message": "psql:/docker-entrypoint-initdb.d/migrations/00-extension.sql:1: NOTICE:  schema \"extensions\" already exists, skipping",
  "id": "8f3975b0-ce37-4801-af07-b0fae1ee5705",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "NOTICE",
      "timestamp": "2025-11-28T14:28:30.300396200Z"
    }
  },
  "project": "default",
  "timestamp": 1764340110300396
}

1764340110323629 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "ca355c12-7218-4646-94b3-7f9065abab3e",
  "project": "default",
  "timestamp": 1764340110323629
}

1764340110324386 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "46e52e4f-cd3c-4a98-943a-b2c6720dd0b1",
  "project": "default",
  "timestamp": 1764340110324386
}

1764340110329041 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20211115181400_update-auth-permissions.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20211115181400_update-auth-permissions.sql",
  "id": "4b421655-5776-4827-a0cd-df7558eee7bd",
  "project": "default",
  "timestamp": 1764340110329041
}

1764340110341682 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "f542ca22-25fa-41ff-9159-133bc0d6e039",
  "project": "default",
  "timestamp": 1764340110341682
}

1764340110346158 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "f9f81c5c-5022-4e8d-8806-401be97131b3",
  "project": "default",
  "timestamp": 1764340110346158
}

1764340110349410 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20211118015519_create-realtime-schema.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20211118015519_create-realtime-schema.sql",
  "id": "1ea776af-b6f9-460c-aa5d-6ab454fc93ce",
  "project": "default",
  "timestamp": 1764340110349410
}

1764340110391131 DO event body

{
  "appname": "supabase-db",
  "event_message": "DO",
  "id": "ed744840-b087-45b1-b728-844b24662543",
  "project": "default",
  "timestamp": 1764340110391131
}

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

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20211130151719_update-realtime-permissions.sql",
  "id": "db25f10e-e66d-4c35-87de-2fd9da9b2633",
  "project": "default",
  "timestamp": 1764340110391918
}

1764340110434149 psql:/docker-entrypoint-initdb.d/migrations/20220126121436_finer-postgrest-triggers.sql:4: NOTICE: function extensions.notify_api_restart() does not exist, skipping event body

{
  "appname": "supabase-db",
  "event_message": "psql:/docker-entrypoint-initdb.d/migrations/20220126121436_finer-postgrest-triggers.sql:4: NOTICE:  function extensions.notify_api_restart() does not exist, skipping",
  "id": "7b737bc3-c874-4a2b-995e-cfb0d05a7b67",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "NOTICE",
      "timestamp": "2025-11-28T14:28:30.434149998Z"
    }
  },
  "project": "default",
  "timestamp": 1764340110434149
}

1764340110435159 CREATE FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE FUNCTION",
  "id": "2773584b-7be7-4e58-911e-7a61439a6d42",
  "project": "default",
  "timestamp": 1764340110435159
}

1764340110435665 CREATE EVENT TRIGGER event body

{
  "appname": "supabase-db",
  "event_message": "CREATE EVENT TRIGGER",
  "id": "007e4853-bffc-4cd6-9a62-49257b4cd1d1",
  "project": "default",
  "timestamp": 1764340110435665
}

1764340110467496 psql:/docker-entrypoint-initdb.d/migrations/20220317095840_pg_graphql.sql:5: NOTICE: function graphql_public.graphql(text,text,jsonb) does not exist, skipping event body

{
  "appname": "supabase-db",
  "event_message": "psql:/docker-entrypoint-initdb.d/migrations/20220317095840_pg_graphql.sql:5: NOTICE:  function graphql_public.graphql(text,text,jsonb) does not exist, skipping",
  "id": "ca94ea11-33dd-4b56-8080-4c606dc93f0e",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "NOTICE",
      "timestamp": "2025-11-28T14:28:30.467496311Z"
    }
  },
  "project": "default",
  "timestamp": 1764340110467496
}

1764340110469246 ALTER DEFAULT PRIVILEGES event body

{
  "appname": "supabase-db",
  "event_message": "ALTER DEFAULT PRIVILEGES",
  "id": "5945aa9a-9afe-4e1f-8d48-cfd3fca98a44",
  "project": "default",
  "timestamp": 1764340110469246
}

1764340110470450 CREATE FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE FUNCTION",
  "id": "874802b6-936c-4e6c-bfbb-0ade5cdd5f4e",
  "project": "default",
  "timestamp": 1764340110470450
}

1764340110470676 psql:/docker-entrypoint-initdb.d/migrations/20220317095840_pg_graphql.sql:90: NOTICE: event trigger "issue_pg_graphql_access" does not exist, skipping event body

{
  "appname": "supabase-db",
  "event_message": "psql:/docker-entrypoint-initdb.d/migrations/20220317095840_pg_graphql.sql:90: NOTICE:  event trigger \"issue_pg_graphql_access\" does not exist, skipping",
  "id": "0c882c70-3a08-4e13-a3b5-dabe2f953006",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "NOTICE",
      "timestamp": "2025-11-28T14:28:30.470676565Z"
    }
  },
  "project": "default",
  "timestamp": 1764340110470676
}

1764340110470686 DROP EVENT TRIGGER event body

{
  "appname": "supabase-db",
  "event_message": "DROP EVENT TRIGGER",
  "id": "95cd3529-dbf5-42a1-b98d-e13c1190822c",
  "project": "default",
  "timestamp": 1764340110470686
}

1764340110486381 psql:/docker-entrypoint-initdb.d/migrations/20220321174452_fix-postgrest-alter-type-event-trigger.sql:4: NOTICE: function extensions.notify_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:4: NOTICE:  function extensions.notify_api_restart() does not exist, skipping",
  "id": "75d79676-4484-49c7-9129-b41d20e008e0",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "NOTICE",
      "timestamp": "2025-11-28T14:28:30.486381062Z"
    }
  },
  "project": "default",
  "timestamp": 1764340110486381
}

1764340110489247 CREATE FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE FUNCTION",
  "id": "51ef2bf7-20ad-4d35-91b8-4805f4e30517",
  "project": "default",
  "timestamp": 1764340110489247
}

1764340110489894 DROP EVENT TRIGGER event body

{
  "appname": "supabase-db",
  "event_message": "DROP EVENT TRIGGER",
  "id": "91632851-bfb2-4f80-8ca8-7ca42868ec19",
  "project": "default",
  "timestamp": 1764340110489894
}

1764340110490616 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20220322085208_gotrue-session-limit.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20220322085208_gotrue-session-limit.sql",
  "id": "4503790e-ceb2-4c03-86b4-dea187484295",
  "project": "default",
  "timestamp": 1764340110490616
}

1764340110503665 /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": "531042d1-7b02-4ab0-8dee-e5d35caa40c0",
  "project": "default",
  "timestamp": 1764340110503665
}

1764340110519027 CREATE FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE FUNCTION",
  "id": "74bc3e90-0bd8-4755-ac7f-98624c7394e9",
  "project": "default",
  "timestamp": 1764340110519027
}

1764340110520109 DROP EXTENSION event body

{
  "appname": "supabase-db",
  "event_message": "DROP EXTENSION",
  "id": "0f8ef197-a519-438c-88d8-380fecca810f",
  "project": "default",
  "timestamp": 1764340110520109
}

1764340110591688 DO event body

{
  "appname": "supabase-db",
  "event_message": "DO",
  "id": "6d611a46-90b0-404e-88d4-a29598b0c84b",
  "project": "default",
  "timestamp": 1764340110591688
}

1764340110610481 ALTER ROLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER ROLE",
  "id": "5ccb7745-6bc8-4603-9939-4c289d5ed3eb",
  "project": "default",
  "timestamp": 1764340110610481
}

1764340110685334 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "d10b2330-8087-4400-a468-a2ed6cccce7e",
  "project": "default",
  "timestamp": 1764340110685334
}

1764340110727037 ALTER ROLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER ROLE",
  "id": "5e0f6588-cd16-4bf5-9caf-9f3e0dd085de",
  "project": "default",
  "timestamp": 1764340110727037
}

1764340110728128 ALTER ROLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER ROLE",
  "id": "5b5e4f54-e264-4d24-b360-6138a57f00c9",
  "project": "default",
  "timestamp": 1764340110728128
}

1764340110728140 DO event body

{
  "appname": "supabase-db",
  "event_message": "DO",
  "id": "e00c09b6-6adb-4902-b81c-74c537b26d10",
  "project": "default",
  "timestamp": 1764340110728140
}

1764340110742339 GRANT ROLE event body

{
  "appname": "supabase-db",
  "event_message": "GRANT ROLE",
  "id": "41db4e16-ef0e-453b-b3e5-b7d4e226a2d5",
  "project": "default",
  "timestamp": 1764340110742339
}

1764340110784694 DO event body

{
  "appname": "supabase-db",
  "event_message": "DO",
  "id": "8b60e685-476e-45f9-be29-df46d5453594",
  "project": "default",
  "timestamp": 1764340110784694
}

1764340110787080 DROP EVENT TRIGGER event body

{
  "appname": "supabase-db",
  "event_message": "DROP EVENT TRIGGER",
  "id": "eac30eba-f20e-4291-a78f-9a6e047b4dae",
  "project": "default",
  "timestamp": 1764340110787080
}

1764340110787314 ALTER FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "ALTER FUNCTION",
  "id": "2ce91230-347d-477a-a6aa-bf37f5587988",
  "project": "default",
  "timestamp": 1764340110787314
}

1764340110787611 CREATE EVENT TRIGGER event body

{
  "appname": "supabase-db",
  "event_message": "CREATE EVENT TRIGGER",
  "id": "a053c7cd-af01-4afc-b8c5-ca18924f9c74",
  "project": "default",
  "timestamp": 1764340110787611
}

1764340110801388 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20240124080435_alter_lo_export_lo_import_owner.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20240124080435_alter_lo_export_lo_import_owner.sql",
  "id": "d8370cba-183a-4a19-bb98-5a7214612e67",
  "project": "default",
  "timestamp": 1764340110801388
}

1764340110862148 /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": "53a51b9d-5b94-449a-9620-d14f68a89e76",
  "project": "default",
  "timestamp": 1764340110862148
}

1764340110875972 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20250205144616_move_orioledb_to_extensions_schema.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20250205144616_move_orioledb_to_extensions_schema.sql",
  "id": "3ad7974c-9937-40b8-be0e-3eee42d7fd12",
  "project": "default",
  "timestamp": 1764340110875972
}

1764340110905127 /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": "a8f3cf06-e7ec-4005-9d8b-5afd3d67f9e7",
  "project": "default",
  "timestamp": 1764340110905127
}

1764340110919899 CREATE FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE FUNCTION",
  "id": "99d4cd88-a3e0-4c59-bc49-df0fbc011a37",
  "project": "default",
  "timestamp": 1764340110919899
}

1764340110921014 DO event body

{
  "appname": "supabase-db",
  "event_message": "DO",
  "id": "52b956d4-cdd2-4d13-a717-1c72f3b7d508",
  "project": "default",
  "timestamp": 1764340110921014
}

1764340110979356 REVOKE event body

{
  "appname": "supabase-db",
  "event_message": "REVOKE",
  "id": "a054e6eb-42e8-4b77-871d-99af79d3f205",
  "project": "default",
  "timestamp": 1764340110979356
}

1764340110980507 REVOKE event body

{
  "appname": "supabase-db",
  "event_message": "REVOKE",
  "id": "a2acd229-b9fb-401d-947d-c75a784347fa",
  "project": "default",
  "timestamp": 1764340110980507
}

1764340110986357 REVOKE event body

{
  "appname": "supabase-db",
  "event_message": "REVOKE",
  "id": "bfc9217f-79c3-451d-9b16-075c5b8194f2",
  "project": "default",
  "timestamp": 1764340110986357
}

1764340110986374 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/97-_supabase.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/97-_supabase.sql",
  "id": "da93a8e7-3dde-4416-99a7-35d491e232d4",
  "project": "default",
  "timestamp": 1764340110986374
}

1764340111028890 CREATE DATABASE event body

{
  "appname": "supabase-db",
  "event_message": "CREATE DATABASE",
  "id": "1ddd7b71-247b-4839-90cf-d808073acb38",
  "project": "default",
  "timestamp": 1764340111028890
}

1764340111055700 You are now connected to database "_supabase" as user "supabase_admin". event body

{
  "appname": "supabase-db",
  "event_message": "You are now connected to database \"_supabase\" as user \"supabase_admin\".",
  "id": "ac389ea7-a9c6-4ac8-9eb5-cbb95aefaf0d",
  "project": "default",
  "timestamp": 1764340111055700
}

1764340111055719 ALTER SCHEMA event body

{
  "appname": "supabase-db",
  "event_message": "ALTER SCHEMA",
  "id": "bfd49710-24f5-47e2-a1a5-bc3d202bb8c8",
  "project": "default",
  "timestamp": 1764340111055719
}

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

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/99-pooler.sql",
  "id": "74c9d23e-0d01-44bb-8b74-147888214108",
  "project": "default",
  "timestamp": 1764340111064586
}

1764340111111011 ALTER SCHEMA event body

{
  "appname": "supabase-db",
  "event_message": "ALTER SCHEMA",
  "id": "79c44058-e467-4a8b-ae7c-95b40a4ecba0",
  "project": "default",
  "timestamp": 1764340111111011
}

1764340111124130 event body

{
  "appname": "supabase-db",
  "event_message": null,
  "id": "248ef693-3027-473d-9c3e-c3f5c6ae5e7c",
  "project": "default",
  "timestamp": 1764340111124130
}

1764340111124139 (1 row) event body

{
  "appname": "supabase-db",
  "event_message": "(1 row)",
  "id": "bf1e65c2-78fb-46bb-ab57-8c415163a473",
  "project": "default",
  "timestamp": 1764340111124139
}

1764340111225758 server stopped event body

{
  "appname": "supabase-db",
  "event_message": "server stopped",
  "id": "dd7624a5-407a-4b02-986a-ed2a8e63ab40",
  "project": "default",
  "timestamp": 1764340111225758
}

1764340111226669 event body

{
  "appname": "supabase-db",
  "event_message": null,
  "id": "c6eedbc1-7605-4026-8f16-ce8c866d9f8d",
  "project": "default",
  "timestamp": 1764340111226669
}

1764340111226679 PostgreSQL init process complete; ready for start up. event body

{
  "appname": "supabase-db",
  "event_message": "PostgreSQL init process complete; ready for start up.",
  "id": "5240d523-5e76-4665-b411-699a895f901e",
  "project": "default",
  "timestamp": 1764340111226679
}

random(tips): Match a field with regex (e.g. `m.browser:~"Firefox 5\d"`).

Source ID

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

1609d2cd-d752-4e89-833e-21f636174808

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=Gr6Zm_cDpgtS&source=1609d2cd-d752-4e89-833e-21f636174808"

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=Gr6Zm_cDpgtS&source=1609d2cd-d752-4e89-833e-21f636174808"

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=Gr6Zm_cDpgtS&source=1609d2cd-d752-4e89-833e-21f636174808

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=Gr6Zm_cDpgtS&source=1609d2cd-d752-4e89-833e-21f636174808
        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=Gr6Zm_cDpgtS&source=1609d2cd-d752-4e89-833e-21f636174808

Or send generic JSON events yourself.

          
    curl -X "POST" "http://localhost:4000/logs/json?source=1609d2cd-d752-4e89-833e-21f636174808" \
         -H 'Content-Type: application/json; charset=utf-8' \
         -H 'X-API-KEY: Gr6Zm_cDpgtS' \
         -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=1609d2cd-d752-4e89-833e-21f636174808" \
    -H 'Content-Type: application/json' \
    -H 'X-API-KEY: Gr6Zm_cDpgtS' \
    -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 = "1609d2cd-d752-4e89-833e-21f636174808"
        const apiKey = "Gr6Zm_cDpgtS"

        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))
    })