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

~/logs/postgres.logs

1767275238314899 event body

{
  "appname": "supabase-db",
  "event_message": "",
  "id": "94664817-8b75-428f-90bb-b1a827b02325",
  "project": "default",
  "timestamp": 1767275238314899
}

1767275238316631 selecting dynamic shared memory implementation ... posix event body

{
  "appname": "supabase-db",
  "event_message": "selecting dynamic shared memory implementation ... posix",
  "id": "045624dc-403f-462a-8b8d-1d0d1b62236b",
  "project": "default",
  "timestamp": 1767275238316631
}

1767275238468718 creating configuration files ... ok event body

{
  "appname": "supabase-db",
  "event_message": "creating configuration files ... ok",
  "id": "d7d20c75-e73f-482c-98a7-683e2c1cab2f",
  "project": "default",
  "timestamp": 1767275238468718
}

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

{
  "appname": "supabase-db",
  "event_message": "performing post-bootstrap initialization ... ok",
  "id": "217be2d4-7445-433c-a3f9-55d15143bd34",
  "project": "default",
  "timestamp": 1767275239793454
}

1767275240029307 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": "4a465897-dabf-45fd-9fe6-c6916829ca4c",
  "project": "default",
  "timestamp": 1767275240029307
}

1767275240029327 event body

{
  "appname": "supabase-db",
  "event_message": "",
  "id": "ef86e12d-a201-4e8e-b079-f795f24865a1",
  "project": "default",
  "timestamp": 1767275240029327
}

1767275240298742 server started event body

{
  "appname": "supabase-db",
  "event_message": "server started",
  "id": "dfe5f861-a767-47e2-a4f1-4aedaaafb29c",
  "project": "default",
  "timestamp": 1767275240298742
}

1767275240469302 CREATE SCHEMA event body

{
  "appname": "supabase-db",
  "event_message": "CREATE SCHEMA",
  "id": "488f955c-a3af-4337-8a02-0dc952f8aa34",
  "project": "default",
  "timestamp": 1767275240469302
}

1767275240496793 GRANT ROLE event body

{
  "appname": "supabase-db",
  "event_message": "GRANT ROLE",
  "id": "0b9a7ffc-e894-4035-9af8-98865c2a4782",
  "project": "default",
  "timestamp": 1767275240496793
}

1767275240641908 GRANT ROLE event body

{
  "appname": "supabase-db",
  "event_message": "GRANT ROLE",
  "id": "23adad3d-acf4-4cc6-93b4-6d12cc15af6e",
  "project": "default",
  "timestamp": 1767275240641908
}

1767275240642925 GRANT ROLE event body

{
  "appname": "supabase-db",
  "event_message": "GRANT ROLE",
  "id": "b3f79b10-2c50-4548-8b15-7288c83a695e",
  "project": "default",
  "timestamp": 1767275240642925
}

1767275240648047 ALTER DEFAULT PRIVILEGES event body

{
  "appname": "supabase-db",
  "event_message": "ALTER DEFAULT PRIVILEGES",
  "id": "05470463-4f42-497b-96dc-c21a2b61f106",
  "project": "default",
  "timestamp": 1767275240648047
}

1767275240652207 ALTER ROLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER ROLE",
  "id": "09c44e93-76ea-490f-a8f1-752ede6a516b",
  "project": "default",
  "timestamp": 1767275240652207
}

1767275240656724 ALTER ROLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER ROLE",
  "id": "d3c40e3a-5e6d-4e51-af49-fe4ce46ca0b7",
  "project": "default",
  "timestamp": 1767275240656724
}

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

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/init-scripts/00000000000001-auth-schema.sql",
  "id": "0580622f-5340-4885-bdf6-69a59769e13c",
  "project": "default",
  "timestamp": 1767275240658502
}

1767275240697190 CREATE INDEX event body

{
  "appname": "supabase-db",
  "event_message": "CREATE INDEX",
  "id": "324f3659-e4a1-4443-81ba-bcd304c9caf3",
  "project": "default",
  "timestamp": 1767275240697190
}

1767275240700417 CREATE INDEX event body

{
  "appname": "supabase-db",
  "event_message": "CREATE INDEX",
  "id": "49fd2812-9bcf-45cd-878c-13407168356f",
  "project": "default",
  "timestamp": 1767275240700417
}

1767275240713405 CREATE INDEX event body

{
  "appname": "supabase-db",
  "event_message": "CREATE INDEX",
  "id": "69c04a66-d380-406c-9db7-76f743a79e26",
  "project": "default",
  "timestamp": 1767275240713405
}

1767275240726435 COMMENT event body

{
  "appname": "supabase-db",
  "event_message": "COMMENT",
  "id": "504a538d-8dc8-4684-a18a-fc9a9ad3fb5b",
  "project": "default",
  "timestamp": 1767275240726435
}

1767275240771681 CREATE INDEX event body

{
  "appname": "supabase-db",
  "event_message": "CREATE INDEX",
  "id": "0fc65f8e-e70d-426d-83fe-99c2cce0fa63",
  "project": "default",
  "timestamp": 1767275240771681
}

1767275240779335 COMMENT event body

{
  "appname": "supabase-db",
  "event_message": "COMMENT",
  "id": "1e127370-4eaf-48c7-8de0-7cdec042733f",
  "project": "default",
  "timestamp": 1767275240779335
}

1767275240783342 CREATE FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE FUNCTION",
  "id": "c6186d4a-1722-4aec-8bab-dfa83f3de965",
  "project": "default",
  "timestamp": 1767275240783342
}

1767275240791364 ALTER ROLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER ROLE",
  "id": "7aa9d808-5014-4ca1-880d-6ed5d05fb04e",
  "project": "default",
  "timestamp": 1767275240791364
}

1767275240823773 ALTER DEFAULT PRIVILEGES event body

{
  "appname": "supabase-db",
  "event_message": "ALTER DEFAULT PRIVILEGES",
  "id": "bdf48763-6771-454c-80ce-00ca210287ed",
  "project": "default",
  "timestamp": 1767275240823773
}

1767275240855386 CREATE INDEX event body

{
  "appname": "supabase-db",
  "event_message": "CREATE INDEX",
  "id": "d7830df3-b75f-4547-8f07-0ae33750efa9",
  "project": "default",
  "timestamp": 1767275240855386
}

1767275240887896 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "a73837da-2d31-4430-92f4-17f81a42d673",
  "project": "default",
  "timestamp": 1767275240887896
}

1767275240890411 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "5082be84-0299-462a-872b-7f64354236eb",
  "project": "default",
  "timestamp": 1767275240890411
}

1767275240892483 ALTER ROLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER ROLE",
  "id": "002e3600-bfaa-4936-8f4d-6ae96a2d3513",
  "project": "default",
  "timestamp": 1767275240892483
}

1767275240896738 ALTER TABLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER TABLE",
  "id": "3252ecca-bce5-4fdd-83b6-ae130b4e7402",
  "project": "default",
  "timestamp": 1767275240896738
}

1767275240898878 ALTER FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "ALTER FUNCTION",
  "id": "927da3af-27bf-4098-9f32-5835bb458a67",
  "project": "default",
  "timestamp": 1767275240898878
}

1767275240899860 ALTER FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "ALTER FUNCTION",
  "id": "37361ecf-e1d5-46c9-99f4-7fbbc0aa43c9",
  "project": "default",
  "timestamp": 1767275240899860
}

1767275240920400 ALTER ROLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER ROLE",
  "id": "af20949d-c9b0-4be5-9507-092cdc27243a",
  "project": "default",
  "timestamp": 1767275240920400
}

1767275240928109 COMMENT event body

{
  "appname": "supabase-db",
  "event_message": "COMMENT",
  "id": "6371c689-9205-41fc-87bd-4794a1bc0a82",
  "project": "default",
  "timestamp": 1767275240928109
}

1767275240931474 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "1cb85768-37e0-4615-83ef-e867f70d733e",
  "project": "default",
  "timestamp": 1767275240931474
}

1767275240939391 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "1aa08f3a-19d3-4b67-891e-9a4db75600e5",
  "project": "default",
  "timestamp": 1767275240939391
}

1767275240954838 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "f6f2873e-8093-4ddf-89b6-f57d65d8b6b3",
  "project": "default",
  "timestamp": 1767275240954838
}

1767275240979610 BEGIN event body

{
  "appname": "supabase-db",
  "event_message": "BEGIN",
  "id": "760de317-f68a-4b1c-9060-e1dbf21635b8",
  "project": "default",
  "timestamp": 1767275240979610
}

1767275241028838 ALTER DEFAULT PRIVILEGES event body

{
  "appname": "supabase-db",
  "event_message": "ALTER DEFAULT PRIVILEGES",
  "id": "6faed8e0-66c1-49af-b553-072c89b86cc8",
  "project": "default",
  "timestamp": 1767275241028838
}

1767275241029688 ALTER DEFAULT PRIVILEGES event body

{
  "appname": "supabase-db",
  "event_message": "ALTER DEFAULT PRIVILEGES",
  "id": "3db8aac6-2579-4642-b71a-7ee9e12eb3ff",
  "project": "default",
  "timestamp": 1767275241029688
}

1767275241076804 CREATE TABLE event body

{
  "appname": "supabase-db",
  "event_message": "CREATE TABLE",
  "id": "aca7e444-02bb-4418-948d-9a4abd698c78",
  "project": "default",
  "timestamp": 1767275241076804
}

1767275241088074 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "b1242cdb-a21f-404b-bb2c-9d3152f10da4",
  "project": "default",
  "timestamp": 1767275241088074
}

1767275241088359 ALTER ROLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER ROLE",
  "id": "e3ab375c-c0ee-4be4-82d5-d2f1e2ad5f83",
  "project": "default",
  "timestamp": 1767275241088359
}

1767275241090597 ALTER FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "ALTER FUNCTION",
  "id": "925c6c34-cea9-45b2-a124-d43203f053a7",
  "project": "default",
  "timestamp": 1767275241090597
}

1767275241095100 CREATE FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE FUNCTION",
  "id": "06bdc105-f210-419b-b800-073197dc3bed",
  "project": "default",
  "timestamp": 1767275241095100
}

1767275241096075 DO event body

{
  "appname": "supabase-db",
  "event_message": "DO",
  "id": "503e195e-fd2c-4e9e-86fd-d72ac40470e7",
  "project": "default",
  "timestamp": 1767275241096075
}

1767275241097973 REVOKE event body

{
  "appname": "supabase-db",
  "event_message": "REVOKE",
  "id": "946be8a3-0b70-4125-9908-9128b684ad73",
  "project": "default",
  "timestamp": 1767275241097973
}

1767275241126368 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/init-scripts/99-roles.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/init-scripts/99-roles.sql",
  "id": "47002348-1fba-413c-a654-c319c07297b3",
  "project": "default",
  "timestamp": 1767275241126368
}

1767275241178618 ALTER ROLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER ROLE",
  "id": "ace62051-501b-40b3-b2b2-c97d6239a10f",
  "project": "default",
  "timestamp": 1767275241178618
}

1767275241195375 ALTER ROLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER ROLE",
  "id": "d30c4370-e404-4b4d-82e5-f43e3fd3a5c9",
  "project": "default",
  "timestamp": 1767275241195375
}

1767275241208623 ALTER ROLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER ROLE",
  "id": "e6124a47-f4ce-478e-972a-fcf2e801230d",
  "project": "default",
  "timestamp": 1767275241208623
}

1767275241254262 ALTER ROLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER ROLE",
  "id": "94953c69-371e-4ff9-976d-3c76ede501a5",
  "project": "default",
  "timestamp": 1767275241254262
}

1767275241293929 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": "e5ca2498-0921-4456-9a41-b1e9d2be418d",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "NOTICE",
      "timestamp": "2026-01-01T13:47:21.293929722Z"
    }
  },
  "project": "default",
  "timestamp": 1767275241293929
}

1767275241398021 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "5f6e8d62-0fe5-44e5-92f4-44c02dd37dc9",
  "project": "default",
  "timestamp": 1767275241398021
}

1767275241400954 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "874c99d5-86bd-484c-b76b-f70913aafed7",
  "project": "default",
  "timestamp": 1767275241400954
}

1767275241445064 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "b9769381-0ee0-4b1a-bc21-4b6300a73bfd",
  "project": "default",
  "timestamp": 1767275241445064
}

1767275241448676 ALTER TABLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER TABLE",
  "id": "27961b27-755a-47ea-b6be-5a590e54cf28",
  "project": "default",
  "timestamp": 1767275241448676
}

1767275241582524 /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": "50c5e117-8176-416c-89d7-e51d17c9127f",
  "project": "default",
  "timestamp": 1767275241582524
}

1767275241626624 ALTER DEFAULT PRIVILEGES event body

{
  "appname": "supabase-db",
  "event_message": "ALTER DEFAULT PRIVILEGES",
  "id": "abae7e89-d96e-47bf-8884-268920d8a62d",
  "project": "default",
  "timestamp": 1767275241626624
}

1767275241627758 ALTER DEFAULT PRIVILEGES event body

{
  "appname": "supabase-db",
  "event_message": "ALTER DEFAULT PRIVILEGES",
  "id": "f67854c6-b924-4a0d-9314-06f64c873717",
  "project": "default",
  "timestamp": 1767275241627758
}

1767275241710956 DROP FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "DROP FUNCTION",
  "id": "4352956f-23ac-4f06-bb65-d7f35935721a",
  "project": "default",
  "timestamp": 1767275241710956
}

1767275241713320 CREATE FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE FUNCTION",
  "id": "7e6f6d75-6ae8-40ce-b2dc-89f219a094a6",
  "project": "default",
  "timestamp": 1767275241713320
}

1767275241714402 CREATE FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE FUNCTION",
  "id": "94657c79-4864-45de-89ae-6cc27a02c093",
  "project": "default",
  "timestamp": 1767275241714402
}

1767275241715546 CREATE EVENT TRIGGER event body

{
  "appname": "supabase-db",
  "event_message": "CREATE EVENT TRIGGER",
  "id": "1071618f-805d-453d-9336-31694cc6dbf5",
  "project": "default",
  "timestamp": 1767275241715546
}

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

{
  "appname": "supabase-db",
  "event_message": "psql:/docker-entrypoint-initdb.d/migrations/20220126121436_finer-postgrest-triggers.sql:64: NOTICE:  event trigger \"pgrst_drop_watch\" does not exist, skipping",
  "id": "5bb90d33-8333-4043-939d-2066c456e294",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "NOTICE",
      "timestamp": "2026-01-01T13:47:21.715871329Z"
    }
  },
  "project": "default",
  "timestamp": 1767275241715871
}

1767275241769031 /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": "64fdf99c-44a0-4b25-adb4-275c487ca841",
  "project": "default",
  "timestamp": 1767275241769031
}

1767275241822962 ALTER DEFAULT PRIVILEGES event body

{
  "appname": "supabase-db",
  "event_message": "ALTER DEFAULT PRIVILEGES",
  "id": "66abe521-4961-4cba-8ad3-9dd3efaef750",
  "project": "default",
  "timestamp": 1767275241822962
}

1767275241830466 DROP EVENT TRIGGER event body

{
  "appname": "supabase-db",
  "event_message": "DROP EVENT TRIGGER",
  "id": "a30471f7-04c6-4871-bdf2-49b79f58c2b5",
  "project": "default",
  "timestamp": 1767275241830466
}

1767275241887286 DROP FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "DROP FUNCTION",
  "id": "ddc9b021-6d5a-4dbb-8111-0977f090182f",
  "project": "default",
  "timestamp": 1767275241887286
}

1767275241896513 CREATE FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE FUNCTION",
  "id": "03065965-aecd-4982-941e-f7b155c87c14",
  "project": "default",
  "timestamp": 1767275241896513
}

1767275241905456 DROP EVENT TRIGGER event body

{
  "appname": "supabase-db",
  "event_message": "DROP EVENT TRIGGER",
  "id": "2da9cf38-e487-4d49-99be-be0abe2d00fb",
  "project": "default",
  "timestamp": 1767275241905456
}

1767275241944392 ALTER ROLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER ROLE",
  "id": "97938222-c0fe-490b-bcdb-83cb0324ebb4",
  "project": "default",
  "timestamp": 1767275241944392
}

1767275241997048 CREATE FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE FUNCTION",
  "id": "5357cdea-0b1b-4896-a7d2-12c42d435ef5",
  "project": "default",
  "timestamp": 1767275241997048
}

1767275241999892 psql:/docker-entrypoint-initdb.d/migrations/20220404205710_pg_graphql-on-by-default.sql:142: NOTICE: extension "pg_graphql" does not exist, skipping event body

{
  "appname": "supabase-db",
  "event_message": "psql:/docker-entrypoint-initdb.d/migrations/20220404205710_pg_graphql-on-by-default.sql:142: NOTICE:  extension \"pg_graphql\" does not exist, skipping",
  "id": "0c7f2ccc-0f31-42e4-969d-e3f1003c62e2",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "NOTICE",
      "timestamp": "2026-01-01T13:47:21.999892980Z"
    }
  },
  "project": "default",
  "timestamp": 1767275241999892
}

1767275242039039 DO event body

{
  "appname": "supabase-db",
  "event_message": "DO",
  "id": "45e231a4-6755-4c89-b97e-8b72c3d7a64d",
  "project": "default",
  "timestamp": 1767275242039039
}

1767275242040728 /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": "ff5310c0-1fd7-4397-a0f8-131ad7e05b2b",
  "project": "default",
  "timestamp": 1767275242040728
}

1767275242085495 GRANT ROLE event body

{
  "appname": "supabase-db",
  "event_message": "GRANT ROLE",
  "id": "88e65155-0282-469e-ba03-30776c86d5b8",
  "project": "default",
  "timestamp": 1767275242085495
}

1767275242128985 CREATE FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE FUNCTION",
  "id": "94e121d7-333c-41ab-bd34-698b13a15773",
  "project": "default",
  "timestamp": 1767275242128985
}

1767275242137013 DROP EXTENSION event body

{
  "appname": "supabase-db",
  "event_message": "DROP EXTENSION",
  "id": "91cbb768-ca0e-46ee-bb9f-4ed58cf88e7f",
  "project": "default",
  "timestamp": 1767275242137013
}

1767275242244973 DO event body

{
  "appname": "supabase-db",
  "event_message": "DO",
  "id": "ba750c39-9ec0-4095-8b1e-a139673a4bed",
  "project": "default",
  "timestamp": 1767275242244973
}

1767275242246461 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20221028101028_set_authenticator_timeout.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20221028101028_set_authenticator_timeout.sql",
  "id": "4050c4c6-f54b-43ae-9185-94cf7c22f29e",
  "project": "default",
  "timestamp": 1767275242246461
}

1767275242428956 /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": "ff631bb3-fc0f-4c49-b5c0-35ed978ca95a",
  "project": "default",
  "timestamp": 1767275242428956
}

1767275242558631 GRANT ROLE event body

{
  "appname": "supabase-db",
  "event_message": "GRANT ROLE",
  "id": "f2c95e56-8f0a-4514-a58a-ff29a08506f0",
  "project": "default",
  "timestamp": 1767275242558631
}

1767275242903790 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20240606060239_grant_predefined_roles_to_postgres.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20240606060239_grant_predefined_roles_to_postgres.sql",
  "id": "a7babae9-3315-43d0-b8f7-0a20b548eebe",
  "project": "default",
  "timestamp": 1767275242903790
}

1767275242940301 /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": "e44cc3ae-8506-4575-b608-3834dc6d3b90",
  "project": "default",
  "timestamp": 1767275242940301
}

1767275243020366 DO event body

{
  "appname": "supabase-db",
  "event_message": "DO",
  "id": "c4512112-2868-4911-8f6e-15f58ae44dd8",
  "project": "default",
  "timestamp": 1767275243020366
}

1767275243060537 /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": "4eeb310f-5d1f-4472-8631-8461113ed406",
  "project": "default",
  "timestamp": 1767275243060537
}

1767275243177330 DO event body

{
  "appname": "supabase-db",
  "event_message": "DO",
  "id": "dcf71e48-1069-476e-8114-e1a5e1240bba",
  "project": "default",
  "timestamp": 1767275243177330
}

1767275243223036 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20250402065937_alter_internal_event_triggers_owner_to_supabase_admin.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20250402065937_alter_internal_event_triggers_owner_to_supabase_admin.sql",
  "id": "e8903a7f-f214-4da7-a383-120ae54fd4ae",
  "project": "default",
  "timestamp": 1767275243223036
}

1767275243260049 CREATE EVENT TRIGGER event body

{
  "appname": "supabase-db",
  "event_message": "CREATE EVENT TRIGGER",
  "id": "2cefb62d-f824-43b0-8fc8-9fc9abdb9cf4",
  "project": "default",
  "timestamp": 1767275243260049
}

1767275243301823 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20250421084701_revoke_admin_roles_from_postgres.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20250421084701_revoke_admin_roles_from_postgres.sql",
  "id": "b895ef4b-b497-472f-a0fd-caca3156bf3d",
  "project": "default",
  "timestamp": 1767275243301823
}

1767275243572992 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": "275b012e-fadd-4a66-9f9a-362c17dd1df0",
  "project": "default",
  "timestamp": 1767275243572992
}

1767275243573754 /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": "fb81a4a3-6f26-495d-9643-998b471ecc38",
  "project": "default",
  "timestamp": 1767275243573754
}

1767275243639051 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": "d88a9784-fc49-4e3a-bb9c-c86d8f7ccef6",
  "project": "default",
  "timestamp": 1767275243639051
}

1767275243641321 CREATE SCHEMA event body

{
  "appname": "supabase-db",
  "event_message": "CREATE SCHEMA",
  "id": "8eab0f37-5b15-46f5-ac80-39cc854c7564",
  "project": "default",
  "timestamp": 1767275243641321
}

1767275243709590 CREATE SCHEMA event body

{
  "appname": "supabase-db",
  "event_message": "CREATE SCHEMA",
  "id": "14b655d3-a7dd-4934-acbc-2b87f0cd739d",
  "project": "default",
  "timestamp": 1767275243709590
}

1767275243754546 event body

{
  "appname": "supabase-db",
  "event_message": " ",
  "id": "152b800b-31dd-4ebe-b1ff-5d230bfd7318",
  "project": "default",
  "timestamp": 1767275243754546
}

1767275243754552 (1 row) event body

{
  "appname": "supabase-db",
  "event_message": "(1 row)",
  "id": "073f45f8-316e-465e-a1b2-dd4c56bd205b",
  "project": "default",
  "timestamp": 1767275243754552
}

1767275243754579 --------------- event body

{
  "appname": "supabase-db",
  "event_message": "---------------",
  "id": "7b8cb6db-cbca-43c5-a2e1-77136689d635",
  "project": "default",
  "timestamp": 1767275243754579
}

1767275243754599 event body

{
  "appname": "supabase-db",
  "event_message": "",
  "id": "0f6d14b8-0ce7-403f-8d8c-8c1980afc4f2",
  "project": "default",
  "timestamp": 1767275243754599
}

1767275243761724 waiting for server to shut down.... 2026-01-01 13:47:23.761 UTC [62] LOG: pg_cron scheduler shutting down event body

{
  "appname": "supabase-db",
  "event_message": "waiting for server to shut down.... 2026-01-01 13:47:23.761 UTC [62] LOG:  pg_cron scheduler shutting down",
  "id": "0eb05a48-d2a1-4a1d-a136-567b34fd0eac",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "LOG",
      "timestamp": "2026-01-01T13:47:23.761724216Z"
    }
  },
  "project": "default",
  "timestamp": 1767275243761724
}

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.

bcfe81d1-7213-40f3-aa23-b56ba85b1c8d

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=Y_nSonHWuOih&source=bcfe81d1-7213-40f3-aa23-b56ba85b1c8d"

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=Y_nSonHWuOih&source=bcfe81d1-7213-40f3-aa23-b56ba85b1c8d"

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=Y_nSonHWuOih&source=bcfe81d1-7213-40f3-aa23-b56ba85b1c8d

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=Y_nSonHWuOih&source=bcfe81d1-7213-40f3-aa23-b56ba85b1c8d
        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=Y_nSonHWuOih&source=bcfe81d1-7213-40f3-aa23-b56ba85b1c8d

Or send generic JSON events yourself.

          
    curl -X "POST" "http://localhost:4000/logs/json?source=bcfe81d1-7213-40f3-aa23-b56ba85b1c8d" \
         -H 'Content-Type: application/json; charset=utf-8' \
         -H 'X-API-KEY: Y_nSonHWuOih' \
         -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=bcfe81d1-7213-40f3-aa23-b56ba85b1c8d" \
    -H 'Content-Type: application/json' \
    -H 'X-API-KEY: Y_nSonHWuOih' \
    -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 = "bcfe81d1-7213-40f3-aa23-b56ba85b1c8d"
        const apiKey = "Y_nSonHWuOih"

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