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

~/logs/postgres.logs

1767559662453934 event body

{
  "appname": "supabase-db",
  "event_message": "",
  "id": "c113dbab-b2a6-4237-9409-3670bc7badb6",
  "project": "default",
  "timestamp": 1767559662453934
}

1767559662477158 The database cluster will be initialized with locale "en_US.UTF-8". event body

{
  "appname": "supabase-db",
  "event_message": "The database cluster will be initialized with locale \"en_US.UTF-8\".",
  "id": "242938b2-b2ff-4359-8b9e-3a66f0448fd0",
  "project": "default",
  "timestamp": 1767559662477158
}

1767559662477203 The default text search configuration will be set to "english". event body

{
  "appname": "supabase-db",
  "event_message": "The default text search configuration will be set to \"english\".",
  "id": "d6ceef95-1b2f-47bc-94ed-3dc844307014",
  "project": "default",
  "timestamp": 1767559662477203
}

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

{
  "appname": "supabase-db",
  "event_message": "selecting default time zone ... Etc/UTC",
  "id": "1e138fde-5136-4351-b0d6-773a94f2b1ca",
  "project": "default",
  "timestamp": 1767559662622543
}

1767559664672497 initdb: warning: enabling "trust" authentication for local connections event body

{
  "appname": "supabase-db",
  "event_message": "initdb: warning: enabling \"trust\" authentication for local connections",
  "id": "29ae7d8a-1a6f-49b4-b86c-6c9d36104555",
  "project": "default",
  "timestamp": 1767559664672497
}

1767559665026132 event body

{
  "appname": "supabase-db",
  "event_message": "",
  "id": "c78f3c63-44ec-443d-8568-2571c3492de9",
  "project": "default",
  "timestamp": 1767559665026132
}

1767559665089711 DO event body

{
  "appname": "supabase-db",
  "event_message": "DO",
  "id": "97035f76-53ee-48f0-9267-08232a43a3c6",
  "project": "default",
  "timestamp": 1767559665089711
}

1767559665119691 CREATE SCHEMA event body

{
  "appname": "supabase-db",
  "event_message": "CREATE SCHEMA",
  "id": "4ff0933d-4fd6-42db-908d-16e1c7650308",
  "project": "default",
  "timestamp": 1767559665119691
}

1767559665128051 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "6d0d800a-c3f5-4255-b2be-b6a2c77abf3f",
  "project": "default",
  "timestamp": 1767559665128051
}

1767559665128766 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/init-scripts/00000000000000-initial-schema.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/init-scripts/00000000000000-initial-schema.sql",
  "id": "fde31cee-9127-430a-acf1-4c8782ed214a",
  "project": "default",
  "timestamp": 1767559665128766
}

1767559665155663 CREATE ROLE event body

{
  "appname": "supabase-db",
  "event_message": "CREATE ROLE",
  "id": "e3c7b407-6853-4840-924b-76f799af65ac",
  "project": "default",
  "timestamp": 1767559665155663
}

1767559665159379 CREATE SCHEMA event body

{
  "appname": "supabase-db",
  "event_message": "CREATE SCHEMA",
  "id": "9f9cdd0c-eb0a-429b-b478-162496cc4675",
  "project": "default",
  "timestamp": 1767559665159379
}

1767559665175117 CREATE EXTENSION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE EXTENSION",
  "id": "42bfa7a0-e0c6-4edc-a439-ffc6321354cb",
  "project": "default",
  "timestamp": 1767559665175117
}

1767559665236686 GRANT ROLE event body

{
  "appname": "supabase-db",
  "event_message": "GRANT ROLE",
  "id": "77aa81d1-c620-4662-b857-a26b9bc9a80e",
  "project": "default",
  "timestamp": 1767559665236686
}

1767559665249159 ALTER ROLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER ROLE",
  "id": "ed6dfb6b-9fe8-44de-ba41-94dfdf4929c7",
  "project": "default",
  "timestamp": 1767559665249159
}

1767559665253957 ALTER DEFAULT PRIVILEGES event body

{
  "appname": "supabase-db",
  "event_message": "ALTER DEFAULT PRIVILEGES",
  "id": "8607cce7-27bc-49d3-a9b8-5cd69c14ce9c",
  "project": "default",
  "timestamp": 1767559665253957
}

1767559665303807 COMMENT event body

{
  "appname": "supabase-db",
  "event_message": "COMMENT",
  "id": "92ce0314-6e1c-4d33-a528-dc2b0308b891",
  "project": "default",
  "timestamp": 1767559665303807
}

1767559665316344 CREATE TABLE event body

{
  "appname": "supabase-db",
  "event_message": "CREATE TABLE",
  "id": "c1176040-72c2-4e1a-9a59-36832e0b9945",
  "project": "default",
  "timestamp": 1767559665316344
}

1767559665364394 COMMENT event body

{
  "appname": "supabase-db",
  "event_message": "COMMENT",
  "id": "ee36a354-538e-418c-a3da-7e672ae56519",
  "project": "default",
  "timestamp": 1767559665364394
}

1767559665381941 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "261445f9-1e3a-42fd-b569-d714b9e1ce58",
  "project": "default",
  "timestamp": 1767559665381941
}

1767559665383501 CREATE ROLE event body

{
  "appname": "supabase-db",
  "event_message": "CREATE ROLE",
  "id": "5c2ad3d1-dc51-4356-8b84-578ce4977916",
  "project": "default",
  "timestamp": 1767559665383501
}

1767559665391788 ALTER TABLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER TABLE",
  "id": "f032b826-3f47-4e17-9114-b9a61205eaf6",
  "project": "default",
  "timestamp": 1767559665391788
}

1767559665394112 ALTER TABLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER TABLE",
  "id": "12dc49ff-414c-4df2-87cd-7d47b28c5880",
  "project": "default",
  "timestamp": 1767559665394112
}

1767559665399943 ALTER TABLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER TABLE",
  "id": "6db7261b-c3fd-49a1-97ae-d9e01ad39cc3",
  "project": "default",
  "timestamp": 1767559665399943
}

1767559665420830 CREATE SCHEMA event body

{
  "appname": "supabase-db",
  "event_message": "CREATE SCHEMA",
  "id": "112460c9-5aae-465c-91c8-5c9280d5f8e7",
  "project": "default",
  "timestamp": 1767559665420830
}

1767559665447702 CREATE INDEX event body

{
  "appname": "supabase-db",
  "event_message": "CREATE INDEX",
  "id": "1c0ba868-efcf-467e-8106-7c97c9e3e0c2",
  "project": "default",
  "timestamp": 1767559665447702
}

1767559665460974 CREATE TABLE event body

{
  "appname": "supabase-db",
  "event_message": "CREATE TABLE",
  "id": "13ea775f-5491-4283-a7b7-34d03880bbc9",
  "project": "default",
  "timestamp": 1767559665460974
}

1767559665466242 CREATE INDEX event body

{
  "appname": "supabase-db",
  "event_message": "CREATE INDEX",
  "id": "50ddce3c-3f0a-4e90-ac98-bbbb35efe285",
  "project": "default",
  "timestamp": 1767559665466242
}

1767559665471375 CREATE INDEX event body

{
  "appname": "supabase-db",
  "event_message": "CREATE INDEX",
  "id": "01ffa19b-04ac-4363-be54-57ae0168d7d2",
  "project": "default",
  "timestamp": 1767559665471375
}

1767559665494476 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "9a1c2663-af8e-430b-916d-1139c2999f48",
  "project": "default",
  "timestamp": 1767559665494476
}

1767559665505337 ALTER FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "ALTER FUNCTION",
  "id": "eccc26d8-3859-4b13-9b85-ff22525170ac",
  "project": "default",
  "timestamp": 1767559665505337
}

1767559665512700 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/init-scripts/00000000000003-post-setup.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/init-scripts/00000000000003-post-setup.sql",
  "id": "32e1b5c2-4d8e-4475-8d07-9115ff90d0ea",
  "project": "default",
  "timestamp": 1767559665512700
}

1767559665544361 CREATE FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE FUNCTION",
  "id": "a1c2614f-8989-4a4d-88d9-c19656f2e85b",
  "project": "default",
  "timestamp": 1767559665544361
}

1767559665555043 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "04040d63-85b0-414e-94ec-55bebce083b7",
  "project": "default",
  "timestamp": 1767559665555043
}

1767559665565763 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "1c40559c-dc92-4fa1-aa13-c3257925bc04",
  "project": "default",
  "timestamp": 1767559665565763
}

1767559665648932 ALTER DEFAULT PRIVILEGES event body

{
  "appname": "supabase-db",
  "event_message": "ALTER DEFAULT PRIVILEGES",
  "id": "41629182-ffcb-4879-9f0e-74b25ccbbaff",
  "project": "default",
  "timestamp": 1767559665648932
}

1767559665649410 ALTER DEFAULT PRIVILEGES event body

{
  "appname": "supabase-db",
  "event_message": "ALTER DEFAULT PRIVILEGES",
  "id": "4c80d179-55d1-4793-8744-ee8de7ff96c1",
  "project": "default",
  "timestamp": 1767559665649410
}

1767559665658554 CREATE TABLE event body

{
  "appname": "supabase-db",
  "event_message": "CREATE TABLE",
  "id": "9b10d743-7ba1-4618-a8ba-4e4e12ba6349",
  "project": "default",
  "timestamp": 1767559665658554
}

1767559665670406 CREATE TABLE event body

{
  "appname": "supabase-db",
  "event_message": "CREATE TABLE",
  "id": "703cabd7-6fbf-4dd3-b729-0bf235be8636",
  "project": "default",
  "timestamp": 1767559665670406
}

1767559665681452 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "4aa90caf-5994-464b-a53e-472f7242b206",
  "project": "default",
  "timestamp": 1767559665681452
}

1767559665683511 ALTER TABLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER TABLE",
  "id": "e0b40a75-482e-41f8-9ffa-c3fbf48d8c83",
  "project": "default",
  "timestamp": 1767559665683511
}

1767559665684409 ALTER TABLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER TABLE",
  "id": "f5156488-fbcf-464c-87fa-d4c7f5087575",
  "project": "default",
  "timestamp": 1767559665684409
}

1767559665685963 DO event body

{
  "appname": "supabase-db",
  "event_message": "DO",
  "id": "b4fb6951-6a64-41f1-95db-33af77ef948c",
  "project": "default",
  "timestamp": 1767559665685963
}

1767559665689541 CREATE FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE FUNCTION",
  "id": "2876940d-abae-4e99-8d53-a87194281390",
  "project": "default",
  "timestamp": 1767559665689541
}

1767559665690873 DO event body

{
  "appname": "supabase-db",
  "event_message": "DO",
  "id": "23b2627a-edb3-481a-8ff5-e7423193d541",
  "project": "default",
  "timestamp": 1767559665690873
}

1767559665692005 ALTER FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "ALTER FUNCTION",
  "id": "a362cf49-11de-453b-9f33-9aedfeb3f170",
  "project": "default",
  "timestamp": 1767559665692005
}

1767559665692897 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "c791cbe5-029d-4f3c-b61d-7ed334e1cad6",
  "project": "default",
  "timestamp": 1767559665692897
}

1767559665696693 COMMIT event body

{
  "appname": "supabase-db",
  "event_message": "COMMIT",
  "id": "030b88ca-29e9-4271-af8f-2c5e0ec65801",
  "project": "default",
  "timestamp": 1767559665696693
}

1767559665782127 ALTER ROLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER ROLE",
  "id": "bb6a1c7b-8344-472e-bb3a-585b439e6456",
  "project": "default",
  "timestamp": 1767559665782127
}

1767559665828191 ALTER ROLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER ROLE",
  "id": "903e647b-1914-49e4-a3e1-1f4f5045f35d",
  "project": "default",
  "timestamp": 1767559665828191
}

1767559665861314 ALTER ROLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER ROLE",
  "id": "5c1d33ca-67a8-4ab5-b104-32585e9c54d8",
  "project": "default",
  "timestamp": 1767559665861314
}

1767559666021213 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "518e9652-936b-412c-b856-a6e5018d99d6",
  "project": "default",
  "timestamp": 1767559666021213
}

1767559666067713 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "f1b1749b-1ef7-4988-9517-6e10a1238ae7",
  "project": "default",
  "timestamp": 1767559666067713
}

1767559666079117 ALTER TABLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER TABLE",
  "id": "a546f4a5-6fc1-4d37-b107-f48e65da092d",
  "project": "default",
  "timestamp": 1767559666079117
}

1767559666081911 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "22c719c4-6a19-4629-a377-f610d3c29d02",
  "project": "default",
  "timestamp": 1767559666081911
}

1767559666083219 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "a69312cc-28f7-448a-9cce-3f4650b9afa1",
  "project": "default",
  "timestamp": 1767559666083219
}

1767559666089339 ALTER DEFAULT PRIVILEGES event body

{
  "appname": "supabase-db",
  "event_message": "ALTER DEFAULT PRIVILEGES",
  "id": "efdbac6d-2b7c-4dbd-8bc6-38c0a696c2ac",
  "project": "default",
  "timestamp": 1767559666089339
}

1767559666225575 DO event body

{
  "appname": "supabase-db",
  "event_message": "DO",
  "id": "7f1bc2b4-a39b-4060-a1ff-772013ee4c30",
  "project": "default",
  "timestamp": 1767559666225575
}

1767559666338152 DROP EVENT TRIGGER event body

{
  "appname": "supabase-db",
  "event_message": "DROP EVENT TRIGGER",
  "id": "d701f942-1c31-4202-b799-0e6cab5e13e1",
  "project": "default",
  "timestamp": 1767559666338152
}

1767559666338639 DROP FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "DROP FUNCTION",
  "id": "20eceb9e-ec4b-4d55-8426-e61c91543b96",
  "project": "default",
  "timestamp": 1767559666338639
}

1767559666346038 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": "e32f61c2-2407-4e90-a31a-2dada6af1cf9",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "NOTICE",
      "timestamp": "2026-01-04T20:47:46.346038238Z"
    }
  },
  "project": "default",
  "timestamp": 1767559666346038
}

1767559666442184 DROP FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "DROP FUNCTION",
  "id": "315311a5-8b5a-4e46-ba68-b21265760dd5",
  "project": "default",
  "timestamp": 1767559666442184
}

1767559666447074 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "0bb2bcc6-31d5-4663-a531-b0893f959ca9",
  "project": "default",
  "timestamp": 1767559666447074
}

1767559666452273 ALTER DEFAULT PRIVILEGES event body

{
  "appname": "supabase-db",
  "event_message": "ALTER DEFAULT PRIVILEGES",
  "id": "0bbfd373-79a9-4a7c-9736-7a5ec4d4f276",
  "project": "default",
  "timestamp": 1767559666452273
}

1767559666456387 ALTER DEFAULT PRIVILEGES event body

{
  "appname": "supabase-db",
  "event_message": "ALTER DEFAULT PRIVILEGES",
  "id": "b0489752-5f25-4c33-9c43-1a49363dd3d0",
  "project": "default",
  "timestamp": 1767559666456387
}

1767559666460666 CREATE EVENT TRIGGER event body

{
  "appname": "supabase-db",
  "event_message": "CREATE EVENT TRIGGER",
  "id": "f04f3b11-e4c1-4b0e-8570-594ce1650f3b",
  "project": "default",
  "timestamp": 1767559666460666
}

1767559666466581 CREATE FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE FUNCTION",
  "id": "6ee49cf5-23dc-47de-a9ad-2a3cf9560f7a",
  "project": "default",
  "timestamp": 1767559666466581
}

1767559666506059 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": "89c3cd38-a45d-450f-8d82-67753dc927d9",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "NOTICE",
      "timestamp": "2026-01-04T20:47:46.506059314Z"
    }
  },
  "project": "default",
  "timestamp": 1767559666506059
}

1767559666519518 DROP EVENT TRIGGER event body

{
  "appname": "supabase-db",
  "event_message": "DROP EVENT TRIGGER",
  "id": "48a1b62c-d9db-4eb5-bae7-60b6bff6dea6",
  "project": "default",
  "timestamp": 1767559666519518
}

1767559666520957 CREATE EVENT TRIGGER event body

{
  "appname": "supabase-db",
  "event_message": "CREATE EVENT TRIGGER",
  "id": "022c289e-52e7-42c8-8efb-19b179e6ac6b",
  "project": "default",
  "timestamp": 1767559666520957
}

1767559666884447 /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": "704b56c4-0b5d-4c4f-a468-c028fcef6067",
  "project": "default",
  "timestamp": 1767559666884447
}

1767559666925474 /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": "fdde1b32-d88a-4ecd-9321-aa77514951de",
  "project": "default",
  "timestamp": 1767559666925474
}

1767559667002617 DO event body

{
  "appname": "supabase-db",
  "event_message": "DO",
  "id": "beedd019-16d0-4eae-a549-27333a6b1029",
  "project": "default",
  "timestamp": 1767559667002617
}

1767559667004477 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20230201083204_grant_auth_roles_to_postgres.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20230201083204_grant_auth_roles_to_postgres.sql",
  "id": "eb4fde91-d506-447a-afad-5f8081bdb478",
  "project": "default",
  "timestamp": 1767559667004477
}

1767559667082931 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "6fbb2739-6a5f-4b6c-98bf-b8b0e22a88f3",
  "project": "default",
  "timestamp": 1767559667082931
}

1767559667095807 ALTER DEFAULT PRIVILEGES event body

{
  "appname": "supabase-db",
  "event_message": "ALTER DEFAULT PRIVILEGES",
  "id": "e8238df6-d7bf-469c-81b0-dd4f46dcb17f",
  "project": "default",
  "timestamp": 1767559667095807
}

1767559667099128 ALTER DEFAULT PRIVILEGES event body

{
  "appname": "supabase-db",
  "event_message": "ALTER DEFAULT PRIVILEGES",
  "id": "e650e9b3-b08d-4216-a64d-5cf09901aca4",
  "project": "default",
  "timestamp": 1767559667099128
}

1767559667426753 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20231020085357_revoke_writes_on_cron_job_from_postgres.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20231020085357_revoke_writes_on_cron_job_from_postgres.sql",
  "id": "ca226dbb-1e09-402a-86a9-046fb323dd66",
  "project": "default",
  "timestamp": 1767559667426753
}

1767559667469985 DO event body

{
  "appname": "supabase-db",
  "event_message": "DO",
  "id": "37ad4cd5-9e24-4ba0-8643-b4b8d373dbde",
  "project": "default",
  "timestamp": 1767559667469985
}

1767559667530645 ALTER ROLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER ROLE",
  "id": "50a15be4-b8ad-4c69-a3d4-0a67ca3db770",
  "project": "default",
  "timestamp": 1767559667530645
}

1767559667532494 /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": "c6c7df21-c0da-43b5-b4c8-6e3cea767c46",
  "project": "default",
  "timestamp": 1767559667532494
}

1767559667575944 ALTER FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "ALTER FUNCTION",
  "id": "dfa247eb-bda5-4b32-8b8a-8c286eeea5ec",
  "project": "default",
  "timestamp": 1767559667575944
}

1767559667684781 DO event body

{
  "appname": "supabase-db",
  "event_message": "DO",
  "id": "323117ea-e4e2-4c01-bbd2-9675cb6eeef5",
  "project": "default",
  "timestamp": 1767559667684781
}

1767559667786060 ALTER ROLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER ROLE",
  "id": "1d7fc87b-54f1-4d73-a358-feb4bec3f49d",
  "project": "default",
  "timestamp": 1767559667786060
}

1767559667788089 /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": "6dd7d83d-5359-4b61-8060-e6a467c728e7",
  "project": "default",
  "timestamp": 1767559667788089
}

1767559667932190 DO event body

{
  "appname": "supabase-db",
  "event_message": "DO",
  "id": "45c675a7-9d11-4d15-b012-b3fe470ecbac",
  "project": "default",
  "timestamp": 1767559667932190
}

1767559667933893 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20250312095419_pgbouncer_ownership.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20250312095419_pgbouncer_ownership.sql",
  "id": "2f14b798-38d6-4033-bac0-7d4198600273",
  "project": "default",
  "timestamp": 1767559667933893
}

1767559668019684 ALTER FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "ALTER FUNCTION",
  "id": "f245b3ef-8baa-44cb-abef-522644f8f94b",
  "project": "default",
  "timestamp": 1767559668019684
}

1767559668021301 CREATE EVENT TRIGGER event body

{
  "appname": "supabase-db",
  "event_message": "CREATE EVENT TRIGGER",
  "id": "e44c3b64-17a1-4dfb-a824-3fcf55417fd1",
  "project": "default",
  "timestamp": 1767559668021301
}

1767559668064623 CREATE FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE FUNCTION",
  "id": "8e95d481-01f2-4cd0-9bca-476fde8ba07d",
  "project": "default",
  "timestamp": 1767559668064623
}

1767559668117786 REVOKE event body

{
  "appname": "supabase-db",
  "event_message": "REVOKE",
  "id": "8ac48e95-7ae4-474f-876f-f0cf6b1dca6d",
  "project": "default",
  "timestamp": 1767559668117786
}

1767559668274115 /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": "13130842-9922-4f3d-8da4-20def0e16e35",
  "project": "default",
  "timestamp": 1767559668274115
}

1767559668353831 CREATE SCHEMA event body

{
  "appname": "supabase-db",
  "event_message": "CREATE SCHEMA",
  "id": "a4beefbf-eee8-479f-8452-fc45a43534ec",
  "project": "default",
  "timestamp": 1767559668353831
}

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

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/99-realtime.sql",
  "id": "71268a36-42ba-4062-a707-be7c0b1dec62",
  "project": "default",
  "timestamp": 1767559668468569
}

1767559668557866 pg_stat_statements_reset event body

{
  "appname": "supabase-db",
  "event_message": " pg_stat_statements_reset ",
  "id": "a1a6d93c-ee2f-4dd5-b85f-54badee6b1cf",
  "project": "default",
  "timestamp": 1767559668557866
}

1767559668557922 event body

{
  "appname": "supabase-db",
  "event_message": " ",
  "id": "49d3f077-1128-40ce-ae15-2ad3921d1f80",
  "project": "default",
  "timestamp": 1767559668557922
}

1767559668557925 (1 row) event body

{
  "appname": "supabase-db",
  "event_message": "(1 row)",
  "id": "031c6fcf-f44c-493c-b6e8-74cc2a1647ee",
  "project": "default",
  "timestamp": 1767559668557925
}

1767559668561248 /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/migrations event body

{
  "appname": "supabase-db",
  "event_message": "/usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/migrations",
  "id": "dc453b37-a700-4e9d-b84b-2ca5be337f4f",
  "project": "default",
  "timestamp": 1767559668561248
}

1767559668569987 waiting for server to shut down.... 2026-01-04 20:47:48.567 UTC [64] FATAL: terminating background worker "TimescaleDB Background Worker Launcher" due to administrator command event body

{
  "appname": "supabase-db",
  "event_message": "waiting for server to shut down.... 2026-01-04 20:47:48.567 UTC [64] FATAL:  terminating background worker \"TimescaleDB Background Worker Launcher\" due to administrator command",
  "id": "2572c7ca-9ae2-41c9-902e-20eada6864e1",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "FATAL",
      "timestamp": "2026-01-04T20:47:48.569987356Z"
    }
  },
  "project": "default",
  "timestamp": 1767559668569987
}

1767559668570032 2026-01-04 20:47:48.567 UTC [66] LOG: pg_cron scheduler shutting down event body

{
  "appname": "supabase-db",
  "event_message": " 2026-01-04 20:47:48.567 UTC [66] LOG:  pg_cron scheduler shutting down",
  "id": "1986d2fb-7c32-42b4-ac8a-97c56f6f5741",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "LOG",
      "timestamp": "2026-01-04T20:47:48.570032750Z"
    }
  },
  "project": "default",
  "timestamp": 1767559668570032
}

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.

c1e46e17-5b7b-40f1-a73b-8928b0dd4dc9

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=bTOsPXz41Fyu&source=c1e46e17-5b7b-40f1-a73b-8928b0dd4dc9"

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=bTOsPXz41Fyu&source=c1e46e17-5b7b-40f1-a73b-8928b0dd4dc9"

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=bTOsPXz41Fyu&source=c1e46e17-5b7b-40f1-a73b-8928b0dd4dc9

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=bTOsPXz41Fyu&source=c1e46e17-5b7b-40f1-a73b-8928b0dd4dc9
        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=bTOsPXz41Fyu&source=c1e46e17-5b7b-40f1-a73b-8928b0dd4dc9

Or send generic JSON events yourself.

          
    curl -X "POST" "http://localhost:4000/logs/json?source=c1e46e17-5b7b-40f1-a73b-8928b0dd4dc9" \
         -H 'Content-Type: application/json; charset=utf-8' \
         -H 'X-API-KEY: bTOsPXz41Fyu' \
         -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=c1e46e17-5b7b-40f1-a73b-8928b0dd4dc9" \
    -H 'Content-Type: application/json' \
    -H 'X-API-KEY: bTOsPXz41Fyu' \
    -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 = "c1e46e17-5b7b-40f1-a73b-8928b0dd4dc9"
        const apiKey = "bTOsPXz41Fyu"

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