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

~/logs/postgres.logs

1784158132596660 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": "0d3d4dc1-e3eb-45bd-a2e7-b963bee9d2e3",
  "project": "default",
  "timestamp": 1784158132596660
}

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

{
  "appname": "supabase-db",
  "event_message": "selecting default time zone ... Etc/UTC",
  "id": "6a4fe581-223c-4590-b1c9-2ffa0076e299",
  "project": "default",
  "timestamp": 1784158132670186
}

1784158132671511 creating configuration files ... ok event body

{
  "appname": "supabase-db",
  "event_message": "creating configuration files ... ok",
  "id": "90819c06-42ab-4541-bb01-3028d880639e",
  "project": "default",
  "timestamp": 1784158132671511
}

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

{
  "appname": "supabase-db",
  "event_message": "performing post-bootstrap initialization ... ok",
  "id": "5efd9d1d-77bc-4b63-a730-0da7c80f14cf",
  "project": "default",
  "timestamp": 1784158133163306
}

1784158133257956 syncing data to disk ... ok event body

{
  "appname": "supabase-db",
  "event_message": "syncing data to disk ... ok",
  "id": "9b2ff927-1b70-49fa-9f78-9a9aebc121ad",
  "project": "default",
  "timestamp": 1784158133257956
}

1784158133257980 Success. You can now start the database server using: event body

{
  "appname": "supabase-db",
  "event_message": "Success. You can now start the database server using:",
  "id": "58e81882-320d-4662-bb18-da27e71263ee",
  "project": "default",
  "timestamp": 1784158133257980
}

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

{
  "appname": "supabase-db",
  "event_message": "waiting for server to start.... done",
  "id": "e5dec190-532e-4e20-9a0a-64fb330a1ad3",
  "project": "default",
  "timestamp": 1784158133386627
}

1784158133387140 server started event body

{
  "appname": "supabase-db",
  "event_message": "server started",
  "id": "f960c459-ed73-47d1-b469-17faf015e1dd",
  "project": "default",
  "timestamp": 1784158133387140
}

1784158133406091 event body

{
  "appname": "supabase-db",
  "event_message": "",
  "id": "76e3fa92-9413-4ce1-8ddd-535db46d80c0",
  "project": "default",
  "timestamp": 1784158133406091
}

1784158133406107 /usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/migrate.sh event body

{
  "appname": "supabase-db",
  "event_message": "/usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/migrate.sh",
  "id": "1f1e7823-7c6a-4d6c-8710-1ba77bc0d0cd",
  "project": "default",
  "timestamp": 1784158133406107
}

1784158133432094 REVOKE event body

{
  "appname": "supabase-db",
  "event_message": "REVOKE",
  "id": "7688c8f7-6897-4c6c-9611-01710445fbd8",
  "project": "default",
  "timestamp": 1784158133432094
}

1784158133432667 CREATE SCHEMA event body

{
  "appname": "supabase-db",
  "event_message": "CREATE SCHEMA",
  "id": "d786999b-a1a2-4631-a6cd-68d7da182663",
  "project": "default",
  "timestamp": 1784158133432667
}

1784158133441587 CREATE PUBLICATION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE PUBLICATION",
  "id": "bed8bbf6-1c8d-4242-ad98-a432f8d32cd1",
  "project": "default",
  "timestamp": 1784158133441587
}

1784158133451420 CREATE EXTENSION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE EXTENSION",
  "id": "0b37d325-0e3e-4abb-b21b-9f03f3233f98",
  "project": "default",
  "timestamp": 1784158133451420
}

1784158133456352 CREATE ROLE event body

{
  "appname": "supabase-db",
  "event_message": "CREATE ROLE",
  "id": "c5ef9742-81d7-4572-abd9-976758fb835b",
  "project": "default",
  "timestamp": 1784158133456352
}

1784158133457985 GRANT ROLE event body

{
  "appname": "supabase-db",
  "event_message": "GRANT ROLE",
  "id": "3765dd17-ff32-4afc-9618-731890582737",
  "project": "default",
  "timestamp": 1784158133457985
}

1784158133459337 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "76494ecf-3d75-4678-9999-aa3af60e1cb5",
  "project": "default",
  "timestamp": 1784158133459337
}

1784158133486316 CREATE INDEX event body

{
  "appname": "supabase-db",
  "event_message": "CREATE INDEX",
  "id": "ee3cf8ac-e76b-4508-91f1-502383c1f6a3",
  "project": "default",
  "timestamp": 1784158133486316
}

1784158133488252 COMMENT event body

{
  "appname": "supabase-db",
  "event_message": "COMMENT",
  "id": "23b4784f-14ba-4a52-adb9-cf319a3f8f3e",
  "project": "default",
  "timestamp": 1784158133488252
}

1784158133490830 CREATE TABLE event body

{
  "appname": "supabase-db",
  "event_message": "CREATE TABLE",
  "id": "229df704-ec9c-4c19-aeac-d2dd4a8d53af",
  "project": "default",
  "timestamp": 1784158133490830
}

1784158133497085 CREATE TABLE event body

{
  "appname": "supabase-db",
  "event_message": "CREATE TABLE",
  "id": "c14f8f43-ccf7-42a9-a0f1-a91bfc57379c",
  "project": "default",
  "timestamp": 1784158133497085
}

1784158133498315 INSERT 0 7 event body

{
  "appname": "supabase-db",
  "event_message": "INSERT 0 7",
  "id": "30e657ee-ef77-47b9-b825-e91525b06b0b",
  "project": "default",
  "timestamp": 1784158133498315
}

1784158133504713 ALTER TABLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER TABLE",
  "id": "4444ff8e-cdef-4ba7-993a-aa8f25f61ce1",
  "project": "default",
  "timestamp": 1784158133504713
}

1784158133514040 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "3ef81e9c-5f51-4c0a-a47b-3c014b3fa903",
  "project": "default",
  "timestamp": 1784158133514040
}

1784158133519150 CREATE TABLE event body

{
  "appname": "supabase-db",
  "event_message": "CREATE TABLE",
  "id": "bc95852d-4976-4ef1-a3ee-9e378203029c",
  "project": "default",
  "timestamp": 1784158133519150
}

1784158133534009 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "09ba0916-e37b-4995-b1fc-2f32bdb2bb8d",
  "project": "default",
  "timestamp": 1784158133534009
}

1784158133534626 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "65b207e9-808c-44c4-a72f-039297fac78c",
  "project": "default",
  "timestamp": 1784158133534626
}

1784158133536236 ALTER TABLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER TABLE",
  "id": "dfb14ff1-4625-4c35-bfde-60865474d9a9",
  "project": "default",
  "timestamp": 1784158133536236
}

1784158133537847 ALTER TABLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER TABLE",
  "id": "6dcecff2-33a4-4af3-bab2-66f8acf9400e",
  "project": "default",
  "timestamp": 1784158133537847
}

1784158133538385 ALTER FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "ALTER FUNCTION",
  "id": "fd5d22e4-d5b4-41c3-918a-61d0a0a84824",
  "project": "default",
  "timestamp": 1784158133538385
}

1784158133540838 /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": "6ec23540-310e-4ce4-9aec-2994e2056bff",
  "project": "default",
  "timestamp": 1784158133540838
}

1784158133553398 CREATE ROLE event body

{
  "appname": "supabase-db",
  "event_message": "CREATE ROLE",
  "id": "94b11860-8929-446e-ad2b-c2b670c08129",
  "project": "default",
  "timestamp": 1784158133553398
}

1784158133556162 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "4d938d35-c807-41b3-9f20-7774070bb25a",
  "project": "default",
  "timestamp": 1784158133556162
}

1784158133556611 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "486a1bf5-3986-4bc3-8e83-fffb6ea3c765",
  "project": "default",
  "timestamp": 1784158133556611
}

1784158133557069 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "cf179d08-8fb7-4cd9-8b4e-ba1be82342db",
  "project": "default",
  "timestamp": 1784158133557069
}

1784158133570927 BEGIN event body

{
  "appname": "supabase-db",
  "event_message": "BEGIN",
  "id": "f93b5dcf-4b69-41e5-b5fa-1e6a99fef38e",
  "project": "default",
  "timestamp": 1784158133570927
}

1784158133584165 CREATE EXTENSION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE EXTENSION",
  "id": "3e092f62-4b60-4507-bbf8-78a13ef48ae0",
  "project": "default",
  "timestamp": 1784158133584165
}

1784158133596642 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "f5884eb3-beba-4d20-9ccc-72dea039a415",
  "project": "default",
  "timestamp": 1784158133596642
}

1784158133597407 ALTER TABLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER TABLE",
  "id": "4a5e0a2e-dc10-4266-adca-44681bdfbec5",
  "project": "default",
  "timestamp": 1784158133597407
}

1784158133597863 ALTER TABLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER TABLE",
  "id": "d36dc9d0-8e3d-427b-a5ac-b733c5d0b436",
  "project": "default",
  "timestamp": 1784158133597863
}

1784158133602389 COMMENT event body

{
  "appname": "supabase-db",
  "event_message": "COMMENT",
  "id": "397f92e2-7949-4689-be02-ceacc601e98a",
  "project": "default",
  "timestamp": 1784158133602389
}

1784158133602914 DO event body

{
  "appname": "supabase-db",
  "event_message": "DO",
  "id": "9fcff5c7-3a24-497d-9a79-95ebd0b8be5d",
  "project": "default",
  "timestamp": 1784158133602914
}

1784158133603811 ALTER FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "ALTER FUNCTION",
  "id": "e95ed0f5-bfc6-4409-8078-4ea3950a777e",
  "project": "default",
  "timestamp": 1784158133603811
}

1784158133604362 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "862b25c8-d287-49ed-b3c2-a9bab2fb6903",
  "project": "default",
  "timestamp": 1784158133604362
}

1784158133635753 ALTER ROLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER ROLE",
  "id": "2e01a763-71f3-4a62-a664-ff1ff3440228",
  "project": "default",
  "timestamp": 1784158133635753
}

1784158133647969 ALTER ROLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER ROLE",
  "id": "7a78b8ff-6cc7-46d5-aeed-4ad9a0fed356",
  "project": "default",
  "timestamp": 1784158133647969
}

1784158133688130 CREATE EXTENSION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE EXTENSION",
  "id": "75163690-15b2-411a-9862-2acee63d9e4e",
  "project": "default",
  "timestamp": 1784158133688130
}

1784158133702445 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "7fd8b177-575f-4df8-9b86-33e89e3e641d",
  "project": "default",
  "timestamp": 1784158133702445
}

1784158133705497 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "72d1cd37-ffb7-4d5e-a640-079bde791228",
  "project": "default",
  "timestamp": 1784158133705497
}

1784158133705904 ALTER ROLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER ROLE",
  "id": "22f88957-ab84-4ddf-87a7-68fd8d0accec",
  "project": "default",
  "timestamp": 1784158133705904
}

1784158133720385 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "3a830824-8d45-4416-a3f8-16f94fe78656",
  "project": "default",
  "timestamp": 1784158133720385
}

1784158133721921 ALTER TABLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER TABLE",
  "id": "c633a174-7084-4c0a-8ab9-c19827ed124b",
  "project": "default",
  "timestamp": 1784158133721921
}

1784158133722596 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "cb23212c-4ff5-4dcb-ab16-3db97f905713",
  "project": "default",
  "timestamp": 1784158133722596
}

1784158133724624 ALTER DEFAULT PRIVILEGES event body

{
  "appname": "supabase-db",
  "event_message": "ALTER DEFAULT PRIVILEGES",
  "id": "7675e9a9-7992-4e9d-8d55-b6db7e457740",
  "project": "default",
  "timestamp": 1784158133724624
}

1784158133739708 /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": "d45c229d-0eaa-41bf-8322-a1dae96dd959",
  "project": "default",
  "timestamp": 1784158133739708
}

1784158133752959 /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": "39d4ce19-68f9-43ea-b273-e445e34cae65",
  "project": "default",
  "timestamp": 1784158133752959
}

1784158133764387 DO event body

{
  "appname": "supabase-db",
  "event_message": "DO",
  "id": "7c20af7c-e704-4b9d-9321-77db6e1215ee",
  "project": "default",
  "timestamp": 1784158133764387
}

1784158133766626 /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": "b9975eb6-4621-446d-a429-325363658c86",
  "project": "default",
  "timestamp": 1784158133766626
}

1784158133778764 ALTER DEFAULT PRIVILEGES event body

{
  "appname": "supabase-db",
  "event_message": "ALTER DEFAULT PRIVILEGES",
  "id": "fe7f7485-6ee4-4964-8d6b-f25fa8af40cd",
  "project": "default",
  "timestamp": 1784158133778764
}

1784158133793824 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20220126121436_finer-postgrest-triggers.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20220126121436_finer-postgrest-triggers.sql",
  "id": "cd87820f-f348-47d9-a98f-c12a36135170",
  "project": "default",
  "timestamp": 1784158133793824
}

1784158133805084 DROP EVENT TRIGGER event body

{
  "appname": "supabase-db",
  "event_message": "DROP EVENT TRIGGER",
  "id": "2973865f-9590-408f-a66d-38689ff03e0d",
  "project": "default",
  "timestamp": 1784158133805084
}

1784158133805089 DROP FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "DROP FUNCTION",
  "id": "510b2b04-ef08-4af6-9925-6d80f5796f5b",
  "project": "default",
  "timestamp": 1784158133805089
}

1784158133807635 CREATE EVENT TRIGGER event body

{
  "appname": "supabase-db",
  "event_message": "CREATE EVENT TRIGGER",
  "id": "a488bb03-3bc0-4b9e-a8d9-aa4d2e1d447f",
  "project": "default",
  "timestamp": 1784158133807635
}

1784158133829837 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20220317095840_pg_graphql.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20220317095840_pg_graphql.sql",
  "id": "576c1519-0665-4971-a809-3c7bcfe807e5",
  "project": "default",
  "timestamp": 1784158133829837
}

1784158133845967 ALTER DEFAULT PRIVILEGES event body

{
  "appname": "supabase-db",
  "event_message": "ALTER DEFAULT PRIVILEGES",
  "id": "c5f1d971-fa20-448e-aa1a-8584851eff3d",
  "project": "default",
  "timestamp": 1784158133845967
}

1784158133847169 ALTER DEFAULT PRIVILEGES event body

{
  "appname": "supabase-db",
  "event_message": "ALTER DEFAULT PRIVILEGES",
  "id": "c93299eb-1d50-4709-b265-2594a4377f3d",
  "project": "default",
  "timestamp": 1784158133847169
}

1784158133849035 CREATE FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE FUNCTION",
  "id": "d0fd1b00-0ba5-4220-89d7-43a928759cb6",
  "project": "default",
  "timestamp": 1784158133849035
}

1784158133852502 CREATE EVENT TRIGGER event body

{
  "appname": "supabase-db",
  "event_message": "CREATE EVENT TRIGGER",
  "id": "3775007b-d15a-45a9-81dd-8f3e84c504c7",
  "project": "default",
  "timestamp": 1784158133852502
}

1784158133867910 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": "42dcac78-13fb-4f39-bd47-83ef62ac7589",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "NOTICE",
      "timestamp": "2026-07-15T23:28:53.867910762Z"
    }
  },
  "project": "default",
  "timestamp": 1784158133867910
}

1784158133868238 DROP EVENT TRIGGER event body

{
  "appname": "supabase-db",
  "event_message": "DROP EVENT TRIGGER",
  "id": "98d9d4aa-3497-4873-9423-29c0a20326eb",
  "project": "default",
  "timestamp": 1784158133868238
}

1784158133870959 CREATE FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE FUNCTION",
  "id": "7a782b60-73d9-4f30-8377-ab97b8247574",
  "project": "default",
  "timestamp": 1784158133870959
}

1784158133873198 CREATE EVENT TRIGGER event body

{
  "appname": "supabase-db",
  "event_message": "CREATE EVENT TRIGGER",
  "id": "167608a8-1de0-4a67-8c5a-a3174f1dad7d",
  "project": "default",
  "timestamp": 1784158133873198
}

1784158133873772 DROP EVENT TRIGGER event body

{
  "appname": "supabase-db",
  "event_message": "DROP EVENT TRIGGER",
  "id": "b64866c7-b1a4-4383-ad92-2bdbdcff74a4",
  "project": "default",
  "timestamp": 1784158133873772
}

1784158133875257 /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": "ab2ae5ff-acd5-4360-b027-d255a4368246",
  "project": "default",
  "timestamp": 1784158133875257
}

1784158133887412 /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": "43eb3b3a-d582-4a30-85f4-c59dd7cd9e9d",
  "project": "default",
  "timestamp": 1784158133887412
}

1784158133917226 /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": "c5003e40-4ab0-470b-9369-99dcf9a92429",
  "project": "default",
  "timestamp": 1784158133917226
}

1784158133929519 GRANT ROLE event body

{
  "appname": "supabase-db",
  "event_message": "GRANT ROLE",
  "id": "2cd8853a-6ff2-4f99-99dd-f5412778b8ad",
  "project": "default",
  "timestamp": 1784158133929519
}

1784158133946770 DROP EXTENSION event body

{
  "appname": "supabase-db",
  "event_message": "DROP EXTENSION",
  "id": "4abc2ee1-3a33-4cc4-a5b0-9224c0f76fd2",
  "project": "default",
  "timestamp": 1784158133946770
}

1784158134056041 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20230224042246_grant_extensions_perms_for_postgres.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20230224042246_grant_extensions_perms_for_postgres.sql",
  "id": "b8870c48-bb90-47b3-b63e-472bb01f341a",
  "project": "default",
  "timestamp": 1784158134056041
}

1784158134071546 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "9f3cfe4d-e4af-4699-92e9-66ed71a7c429",
  "project": "default",
  "timestamp": 1784158134071546
}

1784158134074173 ALTER DEFAULT PRIVILEGES event body

{
  "appname": "supabase-db",
  "event_message": "ALTER DEFAULT PRIVILEGES",
  "id": "ec4abde8-6241-4f77-aa18-7db92f12ef88",
  "project": "default",
  "timestamp": 1784158134074173
}

1784158134074958 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20230306081037_grant_pg_monitor_to_postgres.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20230306081037_grant_pg_monitor_to_postgres.sql",
  "id": "ef4c9953-ff46-4b87-90ef-b74079ebf1fe",
  "project": "default",
  "timestamp": 1784158134074958
}

1784158134088436 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20230327032006_grant_auth_roles_to_supabase_storage_admin.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20230327032006_grant_auth_roles_to_supabase_storage_admin.sql",
  "id": "dfbf6df4-8fcd-4d72-a80c-ff32a5fc9b14",
  "project": "default",
  "timestamp": 1784158134088436
}

1784158134130845 /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": "a406bac6-e505-4f69-845d-122624537334",
  "project": "default",
  "timestamp": 1784158134130845
}

1784158134144917 CREATE FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE FUNCTION",
  "id": "9f5bd2e5-8fb0-4a11-ad26-32c295019410",
  "project": "default",
  "timestamp": 1784158134144917
}

1784158134174402 CREATE FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE FUNCTION",
  "id": "8492319c-0d9a-49d4-9dd6-94952da0f64d",
  "project": "default",
  "timestamp": 1784158134174402
}

1784158134191942 /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": "5b18aab0-e4cf-4187-b50b-ac9221443814",
  "project": "default",
  "timestamp": 1784158134191942
}

1784158134220119 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20241031003909_create_orioledb.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20241031003909_create_orioledb.sql",
  "id": "9df838b9-079c-41b6-8eec-33a03ef1f2dc",
  "project": "default",
  "timestamp": 1784158134220119
}

1784158134236055 DO event body

{
  "appname": "supabase-db",
  "event_message": "DO",
  "id": "d9c5dedf-505c-4678-b1fd-cfa978b6db41",
  "project": "default",
  "timestamp": 1784158134236055
}

1784158134264036 ALTER ROLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER ROLE",
  "id": "a4a97f1a-731f-4918-8757-0798809f4dde",
  "project": "default",
  "timestamp": 1784158134264036
}

1784158134266274 /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": "87cd178c-ac91-4833-bc77-b5edc1047377",
  "project": "default",
  "timestamp": 1784158134266274
}

1784158134291305 DO event body

{
  "appname": "supabase-db",
  "event_message": "DO",
  "id": "ddb03fd1-b70f-4e17-b2c8-76503596aad7",
  "project": "default",
  "timestamp": 1784158134291305
}

1784158134402611 CREATE SCHEMA event body

{
  "appname": "supabase-db",
  "event_message": "CREATE SCHEMA",
  "id": "586fedf0-a93c-4989-9518-96156886dce5",
  "project": "default",
  "timestamp": 1784158134402611
}

1784158134428683 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": "1204011e-4f68-4c94-aa53-368810d02782",
  "project": "default",
  "timestamp": 1784158134428683
}

1784158134439620 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": "9a1f1854-0f2a-4571-9d90-520b65708eaf",
  "project": "default",
  "timestamp": 1784158134439620
}

1784158134451956 CREATE SCHEMA event body

{
  "appname": "supabase-db",
  "event_message": "CREATE SCHEMA",
  "id": "466bac0d-12d0-4fe4-be6a-3035cab57a95",
  "project": "default",
  "timestamp": 1784158134451956
}

1784158134464157 event body

{
  "appname": "supabase-db",
  "event_message": " ",
  "id": "6a892dd8-31ee-41ab-8158-4d7e4c787bcc",
  "project": "default",
  "timestamp": 1784158134464157
}

1784158134465702 event body

{
  "appname": "supabase-db",
  "event_message": "",
  "id": "a92b7f8f-1ad5-4ace-808e-ce885cef40ab",
  "project": "default",
  "timestamp": 1784158134465702
}

1784158134567324 done event body

{
  "appname": "supabase-db",
  "event_message": " done",
  "id": "049fa2b7-4062-4488-80a6-66da78ed18fc",
  "project": "default",
  "timestamp": 1784158134567324
}

1784158134568697 event body

{
  "appname": "supabase-db",
  "event_message": "",
  "id": "580eba15-614f-40b3-a6c8-aaf45c858267",
  "project": "default",
  "timestamp": 1784158134568697
}

random(tips): Exact match a string in a field (e.g. `m.response.cf_ray:"505c16f9a752cec8-IAD"`).

Source ID

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

edefd866-e706-47b1-8ed7-fe71f3b1d3e9

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=2uEyEM8s_3xy&source=edefd866-e706-47b1-8ed7-fe71f3b1d3e9"

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=2uEyEM8s_3xy&source=edefd866-e706-47b1-8ed7-fe71f3b1d3e9"

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=2uEyEM8s_3xy&source=edefd866-e706-47b1-8ed7-fe71f3b1d3e9

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=2uEyEM8s_3xy&source=edefd866-e706-47b1-8ed7-fe71f3b1d3e9
        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=2uEyEM8s_3xy&source=edefd866-e706-47b1-8ed7-fe71f3b1d3e9

Or send generic JSON events yourself.

          
    curl -X "POST" "http://localhost:4000/logs/json?source=edefd866-e706-47b1-8ed7-fe71f3b1d3e9" \
         -H 'Content-Type: application/json; charset=utf-8' \
         -H 'X-API-KEY: 2uEyEM8s_3xy' \
         -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=edefd866-e706-47b1-8ed7-fe71f3b1d3e9" \
    -H 'Content-Type: application/json' \
    -H 'X-API-KEY: 2uEyEM8s_3xy' \
    -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 = "edefd866-e706-47b1-8ed7-fe71f3b1d3e9"
        const apiKey = "2uEyEM8s_3xy"

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