Logflare | Cloudflare, Vercel & Elixir Logging

~/logs/postgres.logs

1740544707574717 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": "37019caf-5c78-4780-911a-9a3b0820cd70",
  "project": "default",
  "timestamp": 1740544707574717
}

1740544707574794 event body

{
  "appname": "supabase-db",
  "event_message": null,
  "id": "7f94f5ca-9d4d-46af-9d30-6205ccb6a06a",
  "project": "default",
  "timestamp": 1740544707574794
}

1740544707574998 fixing permissions on existing directory /var/lib/postgresql/data ... ok event body

{
  "appname": "supabase-db",
  "event_message": "fixing permissions on existing directory /var/lib/postgresql/data ... ok",
  "id": "b33d8dd7-ca90-47d0-bbf8-f325b45972dd",
  "project": "default",
  "timestamp": 1740544707574998
}

1740544707578514 creating subdirectories ... ok event body

{
  "appname": "supabase-db",
  "event_message": "creating subdirectories ... ok",
  "id": "3a4a0d7f-7552-488b-9fc8-38955d3b6fb1",
  "project": "default",
  "timestamp": 1740544707578514
}

1740544707655575 selecting default max_connections ... 100 event body

{
  "appname": "supabase-db",
  "event_message": "selecting default max_connections ... 100",
  "id": "0ac032c1-a9f0-4cc1-b38c-280c7ed78942",
  "project": "default",
  "timestamp": 1740544707655575
}

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

{
  "appname": "supabase-db",
  "event_message": "initdb: warning: enabling \"trust\" authentication for local connections",
  "id": "4fa66456-70cf-4c79-8644-ad69f3f0b696",
  "project": "default",
  "timestamp": 1740544709487086
}

1740544709487163 event body

{
  "appname": "supabase-db",
  "event_message": null,
  "id": "619e80e1-9baa-4d29-8375-68a9b0d605cd",
  "project": "default",
  "timestamp": 1740544709487163
}

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

{
  "appname": "supabase-db",
  "event_message": "waiting for server to start.... done",
  "id": "14de833b-d6fb-4ae9-968b-a11163ab21f7",
  "project": "default",
  "timestamp": 1740544709977644
}

1740544709977699 server started event body

{
  "appname": "supabase-db",
  "event_message": "server started",
  "id": "91cde04d-814d-4bb5-9afa-3db50308a24d",
  "project": "default",
  "timestamp": 1740544709977699
}

1740544710048633 /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": "0f03b7f1-3880-482b-bfa0-1a81f9b43068",
  "project": "default",
  "timestamp": 1740544710048633
}

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

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/init-scripts/00-schema.sql",
  "id": "339f3426-4fc1-4eeb-8177-d8c6ae783fc9",
  "project": "default",
  "timestamp": 1740544710143071
}

1740544710173449 REVOKE event body

{
  "appname": "supabase-db",
  "event_message": "REVOKE",
  "id": "76615991-cb22-4a8a-96ec-8475757f640c",
  "project": "default",
  "timestamp": 1740544710173449
}

1740544710182470 /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": "9a9b2733-eba7-4a4a-9383-dcb1572f5138",
  "project": "default",
  "timestamp": 1740544710182470
}

1740544710211978 ALTER ROLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER ROLE",
  "id": "1dd509e2-115e-4144-81e9-4e4523d86552",
  "project": "default",
  "timestamp": 1740544710211978
}

1740544710214697 GRANT ROLE event body

{
  "appname": "supabase-db",
  "event_message": "GRANT ROLE",
  "id": "69f38571-7d3f-492f-b375-1af9e948d7a1",
  "project": "default",
  "timestamp": 1740544710214697
}

1740544710215542 CREATE SCHEMA event body

{
  "appname": "supabase-db",
  "event_message": "CREATE SCHEMA",
  "id": "7d4aaf78-c3e5-4d84-88af-51907caf8583",
  "project": "default",
  "timestamp": 1740544710215542
}

1740544710227802 CREATE EXTENSION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE EXTENSION",
  "id": "51e2efad-6a44-4d27-b7c3-6584de88c212",
  "project": "default",
  "timestamp": 1740544710227802
}

1740544710255510 CREATE EXTENSION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE EXTENSION",
  "id": "be2a3da9-916e-4069-9202-a2be99c2f325",
  "project": "default",
  "timestamp": 1740544710255510
}

1740544710256133 CREATE ROLE event body

{
  "appname": "supabase-db",
  "event_message": "CREATE ROLE",
  "id": "ee61d32b-fb28-4c24-8dd8-90a723f12065",
  "project": "default",
  "timestamp": 1740544710256133
}

1740544710258573 CREATE ROLE event body

{
  "appname": "supabase-db",
  "event_message": "CREATE ROLE",
  "id": "06076ef1-5eaf-4f17-901b-b9f46c31ba2d",
  "project": "default",
  "timestamp": 1740544710258573
}

1740544710260988 GRANT ROLE event body

{
  "appname": "supabase-db",
  "event_message": "GRANT ROLE",
  "id": "70eddfa8-62f2-475d-9764-94b8e764f1d4",
  "project": "default",
  "timestamp": 1740544710260988
}

1740544710264969 ALTER DEFAULT PRIVILEGES event body

{
  "appname": "supabase-db",
  "event_message": "ALTER DEFAULT PRIVILEGES",
  "id": "2aaac313-864f-4471-82dd-e2ef893fb071",
  "project": "default",
  "timestamp": 1740544710264969
}

1740544710266794 ALTER ROLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER ROLE",
  "id": "a16f3184-047f-4b39-a788-ce5cce957c29",
  "project": "default",
  "timestamp": 1740544710266794
}

1740544710301695 CREATE SCHEMA event body

{
  "appname": "supabase-db",
  "event_message": "CREATE SCHEMA",
  "id": "b43d4a3c-e7a4-4a13-9083-9c2bd06f54f2",
  "project": "default",
  "timestamp": 1740544710301695
}

1740544710322229 CREATE INDEX event body

{
  "appname": "supabase-db",
  "event_message": "CREATE INDEX",
  "id": "2052f290-a4d4-4e7a-ae6a-01c4e0834937",
  "project": "default",
  "timestamp": 1740544710322229
}

1740544710338489 CREATE INDEX event body

{
  "appname": "supabase-db",
  "event_message": "CREATE INDEX",
  "id": "c2fdca2f-32bd-453b-94d6-ef1341603166",
  "project": "default",
  "timestamp": 1740544710338489
}

1740544710341870 COMMENT event body

{
  "appname": "supabase-db",
  "event_message": "COMMENT",
  "id": "869c9c32-11e2-4b99-a6cb-ca6ed8181223",
  "project": "default",
  "timestamp": 1740544710341870
}

1740544710354693 CREATE TABLE event body

{
  "appname": "supabase-db",
  "event_message": "CREATE TABLE",
  "id": "ed2d588a-c3b3-4dd7-bb3e-6bea659de4e4",
  "project": "default",
  "timestamp": 1740544710354693
}

1740544710357827 COMMENT event body

{
  "appname": "supabase-db",
  "event_message": "COMMENT",
  "id": "808d4706-cc3a-4370-8cf7-c3ffc57ad023",
  "project": "default",
  "timestamp": 1740544710357827
}

1740544710362216 COMMENT event body

{
  "appname": "supabase-db",
  "event_message": "COMMENT",
  "id": "9c1eb685-b536-4fc4-90f9-cc0d1946e7ea",
  "project": "default",
  "timestamp": 1740544710362216
}

1740544710370092 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "7088dfd2-b4d4-4f08-8454-7c9432d51531",
  "project": "default",
  "timestamp": 1740544710370092
}

1740544710381047 ALTER TABLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER TABLE",
  "id": "7cad2d17-f2e0-4da6-9aca-ffaa2984d418",
  "project": "default",
  "timestamp": 1740544710381047
}

1740544710383416 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/init-scripts/00000000000002-storage-schema.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/init-scripts/00000000000002-storage-schema.sql",
  "id": "72fb81da-aa6c-4bef-be39-8e6e0940d15e",
  "project": "default",
  "timestamp": 1740544710383416
}

1740544710413658 CREATE SCHEMA event body

{
  "appname": "supabase-db",
  "event_message": "CREATE SCHEMA",
  "id": "6e4905cf-3b69-4424-bab5-4c931e5ac622",
  "project": "default",
  "timestamp": 1740544710413658
}

1740544710417318 ALTER DEFAULT PRIVILEGES event body

{
  "appname": "supabase-db",
  "event_message": "ALTER DEFAULT PRIVILEGES",
  "id": "3941983f-f185-44ea-9eaf-8ccd611377b1",
  "project": "default",
  "timestamp": 1740544710417318
}

1740544710450348 CREATE INDEX event body

{
  "appname": "supabase-db",
  "event_message": "CREATE INDEX",
  "id": "cbb95c1f-ff39-4651-96cb-aac516faa087",
  "project": "default",
  "timestamp": 1740544710450348
}

1740544710451448 ALTER TABLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER TABLE",
  "id": "c6cf18a9-052d-4e60-9343-e994185ebe04",
  "project": "default",
  "timestamp": 1740544710451448
}

1740544710453256 CREATE FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE FUNCTION",
  "id": "32769a1e-8698-43f1-9c99-333ebcefa896",
  "project": "default",
  "timestamp": 1740544710453256
}

1740544710464084 CREATE TABLE event body

{
  "appname": "supabase-db",
  "event_message": "CREATE TABLE",
  "id": "d7e48258-302b-4803-86ff-431224d55e45",
  "project": "default",
  "timestamp": 1740544710464084
}

1740544710468243 ALTER ROLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER ROLE",
  "id": "dc22debd-1b69-4c2f-b6ce-0aa406e77d09",
  "project": "default",
  "timestamp": 1740544710468243
}

1740544710469984 ALTER TABLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER TABLE",
  "id": "5cc7dcf3-85ea-42ed-a05f-fcab23fc731a",
  "project": "default",
  "timestamp": 1740544710469984
}

1740544710473693 ALTER FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "ALTER FUNCTION",
  "id": "fbe72c59-115b-4528-b36d-8351cc9e385b",
  "project": "default",
  "timestamp": 1740544710473693
}

1740544710475307 ALTER FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "ALTER FUNCTION",
  "id": "e4113bd9-dd06-4da1-a6e1-bf84de774705",
  "project": "default",
  "timestamp": 1740544710475307
}

1740544710512442 CREATE FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE FUNCTION",
  "id": "a65d7240-840d-44ac-98d8-4d4429994f36",
  "project": "default",
  "timestamp": 1740544710512442
}

1740544710520150 CREATE ROLE event body

{
  "appname": "supabase-db",
  "event_message": "CREATE ROLE",
  "id": "80b03572-c440-423f-9fbc-6e900f9fd850",
  "project": "default",
  "timestamp": 1740544710520150
}

1740544710524458 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "0bec00f8-4101-4574-9132-202dadc75df5",
  "project": "default",
  "timestamp": 1740544710524458
}

1740544710532118 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "6490a82e-0aa5-4546-9dad-5e19adff0bb2",
  "project": "default",
  "timestamp": 1740544710532118
}

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

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/init-scripts/98-webhooks.sql",
  "id": "f029489e-c68e-4091-8268-6f54ee44864d",
  "project": "default",
  "timestamp": 1740544710540996
}

1740544710619092 CREATE SCHEMA event body

{
  "appname": "supabase-db",
  "event_message": "CREATE SCHEMA",
  "id": "110e5fc0-781b-4a3e-baff-5aa5e0cc9ea5",
  "project": "default",
  "timestamp": 1740544710619092
}

1740544710619528 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "7ecb29b2-278d-496a-9f72-34052761095b",
  "project": "default",
  "timestamp": 1740544710619528
}

1740544710629228 INSERT 0 1 event body

{
  "appname": "supabase-db",
  "event_message": "INSERT 0 1",
  "id": "cfc5dd62-15d8-4589-b698-385eec29fb6b",
  "project": "default",
  "timestamp": 1740544710629228
}

1740544710639876 CREATE INDEX event body

{
  "appname": "supabase-db",
  "event_message": "CREATE INDEX",
  "id": "159f170c-d952-4801-a880-589446f8b653",
  "project": "default",
  "timestamp": 1740544710639876
}

1740544710642532 CREATE INDEX event body

{
  "appname": "supabase-db",
  "event_message": "CREATE INDEX",
  "id": "b7967325-b043-41d7-ac89-44fb28dafd81",
  "project": "default",
  "timestamp": 1740544710642532
}

1740544710647862 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "603f2479-7151-4e19-b077-a6e39559dd1c",
  "project": "default",
  "timestamp": 1740544710647862
}

1740544710652431 GRANT ROLE event body

{
  "appname": "supabase-db",
  "event_message": "GRANT ROLE",
  "id": "af0c5a47-b596-4566-8aac-5ade5dd675e5",
  "project": "default",
  "timestamp": 1740544710652431
}

1740544710657938 CREATE FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE FUNCTION",
  "id": "9003fdc9-8e04-441e-ab5d-ccea4ff78644",
  "project": "default",
  "timestamp": 1740544710657938
}

1740544710658194 COMMENT event body

{
  "appname": "supabase-db",
  "event_message": "COMMENT",
  "id": "c775fdca-682d-4238-9b49-412639a8b9d7",
  "project": "default",
  "timestamp": 1740544710658194
}

1740544710659777 INSERT 0 1 event body

{
  "appname": "supabase-db",
  "event_message": "INSERT 0 1",
  "id": "cfa1b02a-e558-47c9-adae-b3f4f3c59851",
  "project": "default",
  "timestamp": 1740544710659777
}

1740544710764212 ALTER ROLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER ROLE",
  "id": "445254f7-7727-413b-8385-34cdfa48413e",
  "project": "default",
  "timestamp": 1740544710764212
}

1740544710846997 ALTER ROLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER ROLE",
  "id": "bdc58394-d21b-4532-af93-57569615674d",
  "project": "default",
  "timestamp": 1740544710846997
}

1740544710955836 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": "905edfa0-1670-4f23-b54e-e146c2a38860",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "NOTICE",
      "timestamp": "2025-02-26T04:38:30.955836552Z"
    }
  },
  "project": "default",
  "timestamp": 1740544710955836
}

1740544711005182 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/10000000000000_demote-postgres.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/10000000000000_demote-postgres.sql",
  "id": "fd785d41-9cf1-4bd4-ab63-d3d798f882d8",
  "project": "default",
  "timestamp": 1740544711005182
}

1740544711074464 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "f7a28165-14f0-40b9-b300-237553104019",
  "project": "default",
  "timestamp": 1740544711074464
}

1740544711076503 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "5dd43a0f-84e6-47b8-8458-f25eebbad564",
  "project": "default",
  "timestamp": 1740544711076503
}

1740544711077180 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "c12b2444-ac8a-4ea2-b813-da56b97e325c",
  "project": "default",
  "timestamp": 1740544711077180
}

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

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20211115181400_update-auth-permissions.sql",
  "id": "c8af343e-17d8-4ded-842a-eeb2a6fe9c66",
  "project": "default",
  "timestamp": 1740544711091182
}

1740544711150648 ALTER TABLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER TABLE",
  "id": "8ba2cd74-141b-4330-9b3e-23efc95744a7",
  "project": "default",
  "timestamp": 1740544711150648
}

1740544711158508 GRANT event body

{
  "appname": "supabase-db",
  "event_message": "GRANT",
  "id": "eceea77d-f187-4efb-b65f-61aa9f46ca58",
  "project": "default",
  "timestamp": 1740544711158508
}

1740544711350525 DO event body

{
  "appname": "supabase-db",
  "event_message": "DO",
  "id": "ded41b6f-19e8-4fe2-98f2-a0e9792c931d",
  "project": "default",
  "timestamp": 1740544711350525
}

1740544711354401 /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": "c546337b-592e-46e3-a74e-870edc0964fa",
  "project": "default",
  "timestamp": 1740544711354401
}

1740544711410834 ALTER DEFAULT PRIVILEGES event body

{
  "appname": "supabase-db",
  "event_message": "ALTER DEFAULT PRIVILEGES",
  "id": "a1054d0f-3219-466f-ab1a-ae65a15ee5d9",
  "project": "default",
  "timestamp": 1740544711410834
}

1740544711411512 ALTER DEFAULT PRIVILEGES event body

{
  "appname": "supabase-db",
  "event_message": "ALTER DEFAULT PRIVILEGES",
  "id": "40ac52cd-fd68-4934-8e55-62569ab17c55",
  "project": "default",
  "timestamp": 1740544711411512
}

1740544711415178 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20220118070449_enable-safeupdate-postgrest.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20220118070449_enable-safeupdate-postgrest.sql",
  "id": "e35eebf6-5905-4e65-99b9-4c5757dc3ab8",
  "project": "default",
  "timestamp": 1740544711415178
}

1740544711479886 ALTER ROLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER ROLE",
  "id": "9ffb0ff9-26ef-4d84-a787-afbe7e7d908e",
  "project": "default",
  "timestamp": 1740544711479886
}

1740544711482806 /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": "5d8abe1b-7d6e-4623-b497-8f0078dfe8de",
  "project": "default",
  "timestamp": 1740544711482806
}

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

{
  "appname": "supabase-db",
  "event_message": "psql:/docker-entrypoint-initdb.d/migrations/20220126121436_finer-postgrest-triggers.sql:3: NOTICE:  event trigger \"api_restart\" does not exist, skipping",
  "id": "7a2d1f2f-1801-4ee1-bf96-28754f47a122",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "NOTICE",
      "timestamp": "2025-02-26T04:38:31.540393692Z"
    }
  },
  "project": "default",
  "timestamp": 1740544711540393
}

1740544711541632 DROP FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "DROP FUNCTION",
  "id": "90d99936-878d-4aff-ae66-6fa864cd542d",
  "project": "default",
  "timestamp": 1740544711541632
}

1740544711546913 DROP EVENT TRIGGER event body

{
  "appname": "supabase-db",
  "event_message": "DROP EVENT TRIGGER",
  "id": "adf91903-6f85-409e-909f-0f6557f42e66",
  "project": "default",
  "timestamp": 1740544711546913
}

1740544711547932 CREATE EVENT TRIGGER event body

{
  "appname": "supabase-db",
  "event_message": "CREATE EVENT TRIGGER",
  "id": "323356d8-a688-4785-9caf-4af1e0442f8a",
  "project": "default",
  "timestamp": 1740544711547932
}

1740544711717633 CREATE FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE FUNCTION",
  "id": "347dd944-a0b5-4014-9397-76c1f68af3aa",
  "project": "default",
  "timestamp": 1740544711717633
}

1740544711725946 CREATE EVENT TRIGGER event body

{
  "appname": "supabase-db",
  "event_message": "CREATE EVENT TRIGGER",
  "id": "b298a05d-d427-4280-9838-7b791112e1fd",
  "project": "default",
  "timestamp": 1740544711725946
}

1740544711786618 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": "78932e6e-ac1a-4b13-b416-488bc3bfc1c4",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "NOTICE",
      "timestamp": "2025-02-26T04:38:31.786618695Z"
    }
  },
  "project": "default",
  "timestamp": 1740544711786618
}

1740544711786698 psql:/docker-entrypoint-initdb.d/migrations/20220321174452_fix-postgrest-alter-type-event-trigger.sql:4: NOTICE: function extensions.notify_api_restart() does not exist, skipping event body

{
  "appname": "supabase-db",
  "event_message": "psql:/docker-entrypoint-initdb.d/migrations/20220321174452_fix-postgrest-alter-type-event-trigger.sql:4: NOTICE:  function extensions.notify_api_restart() does not exist, skipping",
  "id": "f9e7e93f-ab1c-4834-ac71-8efbf473c0d5",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "NOTICE",
      "timestamp": "2025-02-26T04:38:31.786698565Z"
    }
  },
  "project": "default",
  "timestamp": 1740544711786698
}

1740544711801102 CREATE EVENT TRIGGER event body

{
  "appname": "supabase-db",
  "event_message": "CREATE EVENT TRIGGER",
  "id": "42da89db-3ee3-4a9d-8cb7-cffb5104a79f",
  "project": "default",
  "timestamp": 1740544711801102
}

1740544712359352 ALTER ROLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER ROLE",
  "id": "9769d599-9142-40c5-8896-f5b7659ecad8",
  "project": "default",
  "timestamp": 1740544712359352
}

1740544713313660 GRANT ROLE event body

{
  "appname": "supabase-db",
  "event_message": "GRANT ROLE",
  "id": "ca557a2a-b0a4-403e-b555-0987f06b9bcd",
  "project": "default",
  "timestamp": 1740544713313660
}

1740544713430882 GRANT ROLE event body

{
  "appname": "supabase-db",
  "event_message": "GRANT ROLE",
  "id": "60039b7e-66ff-44d6-b059-02214bb4576a",
  "project": "default",
  "timestamp": 1740544713430882
}

1740544713490508 /docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20230529180330_alter_api_roles_for_inherit.sql event body

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20230529180330_alter_api_roles_for_inherit.sql",
  "id": "1a19fc04-1bac-4a2d-bf27-59e27c4a28a5",
  "project": "default",
  "timestamp": 1740544713490508
}

1740544713795246 CREATE FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "CREATE FUNCTION",
  "id": "599d1328-fd69-4eb4-a9ee-0eb3b5725e8f",
  "project": "default",
  "timestamp": 1740544713795246
}

1740544713917616 ALTER FUNCTION event body

{
  "appname": "supabase-db",
  "event_message": "ALTER FUNCTION",
  "id": "26ca173b-e2b5-4660-8549-c837d71d2094",
  "project": "default",
  "timestamp": 1740544713917616
}

1740544713920572 /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": "2ab7aefc-20ef-4c8a-8972-7ce75308745c",
  "project": "default",
  "timestamp": 1740544713920572
}

1740544713975747 GRANT ROLE event body

{
  "appname": "supabase-db",
  "event_message": "GRANT ROLE",
  "id": "6cb684f7-2d3e-476f-b28a-954822680885",
  "project": "default",
  "timestamp": 1740544713975747
}

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

{
  "appname": "supabase-db",
  "event_message": "/docker-entrypoint-initdb.d/migrate.sh: running /docker-entrypoint-initdb.d/migrations/20250205060043_disable_log_statement_on_internal_roles.sql",
  "id": "17689313-1e1d-4e50-af60-faeeb1bf9dfa",
  "project": "default",
  "timestamp": 1740544714125225
}

1740544714181361 ALTER ROLE event body

{
  "appname": "supabase-db",
  "event_message": "ALTER ROLE",
  "id": "c52928ee-c15f-46be-ab69-83f4b038712b",
  "project": "default",
  "timestamp": 1740544714181361
}

1740544714699358 CREATE SCHEMA event body

{
  "appname": "supabase-db",
  "event_message": "CREATE SCHEMA",
  "id": "5233a2fd-64ff-4b47-9e6f-640588eb5995",
  "project": "default",
  "timestamp": 1740544714699358
}

1740544714938205 CREATE SCHEMA event body

{
  "appname": "supabase-db",
  "event_message": "CREATE SCHEMA",
  "id": "6420a518-daf9-4c45-baf9-43f8ce1eaba0",
  "project": "default",
  "timestamp": 1740544714938205
}

1740544714998345 -------------------------- event body

{
  "appname": "supabase-db",
  "event_message": "--------------------------",
  "id": "42424c0d-2929-4c42-ae1c-8bdb3b2c4fb9",
  "project": "default",
  "timestamp": 1740544714998345
}

1740544714998415 event body

{
  "appname": "supabase-db",
  "event_message": " ",
  "id": "4c5f99ea-c9f0-469e-87fb-1c257dd1ba0d",
  "project": "default",
  "timestamp": 1740544714998415
}

1740544714998463 (1 row) event body

{
  "appname": "supabase-db",
  "event_message": "(1 row)",
  "id": "d0992bff-3c04-45c9-927c-16e95e983547",
  "project": "default",
  "timestamp": 1740544714998463
}

1740544715008214 waiting for server to shut down.... 2025-02-26 04:38:35.007 UTC [63] LOG: pg_cron scheduler shutting down event body

{
  "appname": "supabase-db",
  "event_message": "waiting for server to shut down.... 2025-02-26 04:38:35.007 UTC [63] LOG:  pg_cron scheduler shutting down",
  "id": "524bf601-abf7-4daf-aa0f-50caa5758b22",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "LOG",
      "timestamp": "2025-02-26T04:38:35.008214713Z"
    }
  },
  "project": "default",
  "timestamp": 1740544715008214
}

random(tips): Default behavior is to search the log message field (e.g. `error`).

Source ID

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

5edad462-e559-4b41-87ce-e450f96c312b

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=your-super-secret-and-long-logflare-key&source=5edad462-e559-4b41-87ce-e450f96c312b"

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=your-super-secret-and-long-logflare-key&source=5edad462-e559-4b41-87ce-e450f96c312b"

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=your-super-secret-and-long-logflare-key&source=5edad462-e559-4b41-87ce-e450f96c312b

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=your-super-secret-and-long-logflare-key&source=5edad462-e559-4b41-87ce-e450f96c312b
        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=your-super-secret-and-long-logflare-key&source=5edad462-e559-4b41-87ce-e450f96c312b

Or send generic JSON events yourself.

          
    curl -X "POST" "http://localhost:4000/logs/json?source=5edad462-e559-4b41-87ce-e450f96c312b" \
         -H 'Content-Type: application/json; charset=utf-8' \
         -H 'X-API-KEY: your-super-secret-and-long-logflare-key' \
         -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=5edad462-e559-4b41-87ce-e450f96c312b" \
    -H 'Content-Type: application/json' \
    -H 'X-API-KEY: your-super-secret-and-long-logflare-key' \
    -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 = "5edad462-e559-4b41-87ce-e450f96c312b"
        const apiKey = "your-super-secret-and-long-logflare-key"

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