postgREST.logs.prod | Logflare | Cloudflare, Vercel & Elixir Logging

~/logs/postgREST.logs.prod

1761903826000000 Attempting to reconnect to the database in 1 seconds... event body

{
  "appname": "supabase-rest",
  "event_message": "Attempting to reconnect to the database in 1 seconds...",
  "id": "aaa0fdb9-d5a9-4eb5-8cc6-743710eeff72",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1761903826000000
}

1761903826000000 Retrying listening for notifications in 2 seconds... event body

{
  "appname": "supabase-rest",
  "event_message": "Retrying listening for notifications in 2 seconds...",
  "id": "26f82f44-9203-4780-aa88-766077e477a7",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1761903826000000
}

1761903826000000 Config reloaded event body

{
  "appname": "supabase-rest",
  "event_message": "Config reloaded",
  "id": "784bd7e2-687a-4eb1-9be0-4bcb4b638db4",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1761903826000000
}

1761903826000000 Failed listening for notifications on the "pgrst" channel. ExitFailure 1 event body

{
  "appname": "supabase-rest",
  "event_message": "Failed listening for notifications on the \"pgrst\" channel. ExitFailure 1",
  "id": "035a60b6-254a-4c05-8ff5-9a5f83fe3010",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1761903826000000
}

1761903826145451 31/Oct/2025:09:43:46 +0000: Failed listening for notifications on the "pgrst" channel. Just "connection to server at \"db\" (172.18.0.17), port 5432 failed: Connection refused\n\tIs the server running on that host and accepting TCP/IP connections?\n" event body

{
  "appname": "supabase-rest",
  "event_message": "31/Oct/2025:09:43:46 +0000: Failed listening for notifications on the \"pgrst\" channel. Just \"connection to server at \\\"db\\\" (172.18.0.17), port 5432 failed: Connection refused\\n\\tIs the server running on that host and accepting TCP/IP connections?\\n\"",
  "id": "df4c2db9-89b0-4753-809a-47ce28960ca3",
  "project": "default",
  "timestamp": 1761903826145451
}

1761903826150422 31/Oct/2025:09:43:46 +0000: Failed to query the role settings. {"code":"PGRST000","details":"connection to server at \"db\" (172.18.0.17), port 5432 failed: Connection refused\n\tIs the server running on that host and accepting TCP/IP connections?\n","hint":null,"message":"Database connection error. Retrying the connection."} event body

{
  "appname": "supabase-rest",
  "event_message": "31/Oct/2025:09:43:46 +0000: Failed to query the role settings. {\"code\":\"PGRST000\",\"details\":\"connection to server at \\\"db\\\" (172.18.0.17), port 5432 failed: Connection refused\\n\\tIs the server running on that host and accepting TCP/IP connections?\\n\",\"hint\":null,\"message\":\"Database connection error. Retrying the connection.\"}",
  "id": "fb8e8678-ead2-408b-8a4a-0b759090de07",
  "project": "default",
  "timestamp": 1761903826150422
}

1761903826151748 31/Oct/2025:09:43:46 +0000: Failed to load the schema cache. {"code":"PGRST000","details":"connection to server at \"db\" (172.18.0.17), port 5432 failed: Connection refused\n\tIs the server running on that host and accepting TCP/IP connections?\n","hint":null,"message":"Database connection error. Retrying the connection."} event body

{
  "appname": "supabase-rest",
  "event_message": "31/Oct/2025:09:43:46 +0000: Failed to load the schema cache. {\"code\":\"PGRST000\",\"details\":\"connection to server at \\\"db\\\" (172.18.0.17), port 5432 failed: Connection refused\\n\\tIs the server running on that host and accepting TCP/IP connections?\\n\",\"hint\":null,\"message\":\"Database connection error. Retrying the connection.\"}",
  "id": "e3571833-8b69-4f26-9b0a-8da53ea3891a",
  "project": "default",
  "timestamp": 1761903826151748
}

1761903828000000 Config reloaded event body

{
  "appname": "supabase-rest",
  "event_message": "Config reloaded",
  "id": "a54704dc-9dd5-458e-8780-2a4070b09d33",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1761903828000000
}

1761903828000000 Attempting to reconnect to the database in 2 seconds... event body

{
  "appname": "supabase-rest",
  "event_message": "Attempting to reconnect to the database in 2 seconds...",
  "id": "3a098398-c9ce-4883-b395-51ee825a4b94",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1761903828000000
}

1761903829000000 Schema cache loaded in 4.3 milliseconds event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache loaded in 4.3 milliseconds",
  "id": "8b7f5cec-8c23-4572-ab84-cd87320774cc",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1761903829000000
}

1761903829000000 Schema cache queried in 9.1 milliseconds event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache queried in 9.1 milliseconds",
  "id": "6c5b2fb9-5c8a-4af4-9b96-8e985fdae15b",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1761903829000000
}

1761903829000000 Config reloaded event body

{
  "appname": "supabase-rest",
  "event_message": "Config reloaded",
  "id": "79625ca2-c546-49d0-985c-8aa4b02e580b",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1761903829000000
}

1761903829000000 Schema cache loaded 60 Relations, 57 Relationships, 19 Functions, 0 Domain Representations, 4 Media Type Handlers, 1194 Timezones event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache loaded 60 Relations, 57 Relationships, 19 Functions, 0 Domain Representations, 4 Media Type Handlers, 1194 Timezones",
  "id": "ea56c84b-e554-4278-95d3-5822a5a2e1c3",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1761903829000000
}

1761903829000000 Schema cache loaded 60 Relations, 57 Relationships, 19 Functions, 0 Domain Representations, 4 Media Type Handlers, 1194 Timezones event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache loaded 60 Relations, 57 Relationships, 19 Functions, 0 Domain Representations, 4 Media Type Handlers, 1194 Timezones",
  "id": "841929bb-3c6c-43ba-ace9-074d02237fb9",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1761903829000000
}

1761905316000000 Schema cache loaded in 1.3 milliseconds event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache loaded in 1.3 milliseconds",
  "id": "316ed08a-ff0f-4486-8ba3-eb1190cc60c9",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1761905316000000
}

1761905316000000 Schema cache loaded 60 Relations, 57 Relationships, 19 Functions, 0 Domain Representations, 4 Media Type Handlers, 1194 Timezones event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache loaded 60 Relations, 57 Relationships, 19 Functions, 0 Domain Representations, 4 Media Type Handlers, 1194 Timezones",
  "id": "43e30115-f2e0-46b0-96f5-3ba77adc36d1",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1761905316000000
}

1761905316000000 Successfully connected to PostgreSQL 15.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 13.2.0, 64-bit event body

{
  "appname": "supabase-rest",
  "event_message": "Successfully connected to PostgreSQL 15.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 13.2.0, 64-bit",
  "id": "4f334c9d-5980-410f-8555-da0474e8108b",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1761905316000000
}

1761905316000000 Schema cache queried in 7.3 milliseconds event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache queried in 7.3 milliseconds",
  "id": "92bf0672-ff2b-4ae4-b814-913d520d625b",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1761905316000000
}

1761905316000000 Received a schema cache reload message on the "pgrst" channel event body

{
  "appname": "supabase-rest",
  "event_message": "Received a schema cache reload message on the \"pgrst\" channel",
  "id": "c043636c-ff74-4b21-b21a-93ee14fdbee9",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1761905316000000
}

1761905316000000 Config reloaded event body

{
  "appname": "supabase-rest",
  "event_message": "Config reloaded",
  "id": "2fadf937-9e3d-4972-a9fb-095c4385ac74",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1761905316000000
}

1761920763000000 Schema cache queried in 5.0 milliseconds event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache queried in 5.0 milliseconds",
  "id": "f3323948-853e-4df3-aab5-bf1bd6e5cf08",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1761920763000000
}

1761920763000000 Schema cache loaded 60 Relations, 57 Relationships, 19 Functions, 0 Domain Representations, 4 Media Type Handlers, 1194 Timezones event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache loaded 60 Relations, 57 Relationships, 19 Functions, 0 Domain Representations, 4 Media Type Handlers, 1194 Timezones",
  "id": "b0e17ddc-ded6-4a63-857f-a9486f30276d",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1761920763000000
}

1761920763000000 Received a schema cache reload message on the "pgrst" channel event body

{
  "appname": "supabase-rest",
  "event_message": "Received a schema cache reload message on the \"pgrst\" channel",
  "id": "177c2a55-77b6-49ae-b160-b2873c0b05ae",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1761920763000000
}

1761920763000000 Config reloaded event body

{
  "appname": "supabase-rest",
  "event_message": "Config reloaded",
  "id": "e77e00cc-97dc-4d27-a454-abb0578498b1",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1761920763000000
}

1761920763000000 Successfully connected to PostgreSQL 15.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 13.2.0, 64-bit event body

{
  "appname": "supabase-rest",
  "event_message": "Successfully connected to PostgreSQL 15.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 13.2.0, 64-bit",
  "id": "36fe2861-23a9-48b0-8e65-3f2f8cf1f544",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1761920763000000
}

1761920763000000 Schema cache loaded in 1.1 milliseconds event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache loaded in 1.1 milliseconds",
  "id": "a4e2698a-1128-41ce-8729-4c1f59ad5cc0",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1761920763000000
}

1761991995000000 Received a schema cache reload message on the "pgrst" channel event body

{
  "appname": "supabase-rest",
  "event_message": "Received a schema cache reload message on the \"pgrst\" channel",
  "id": "f1791996-4b2f-4284-9628-cffad19378bf",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1761991995000000
}

1761991995000000 Config reloaded event body

{
  "appname": "supabase-rest",
  "event_message": "Config reloaded",
  "id": "7059977b-253a-44fd-bd8e-6dc252d7961a",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1761991995000000
}

1761991995000000 Schema cache loaded 60 Relations, 57 Relationships, 19 Functions, 0 Domain Representations, 4 Media Type Handlers, 1194 Timezones event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache loaded 60 Relations, 57 Relationships, 19 Functions, 0 Domain Representations, 4 Media Type Handlers, 1194 Timezones",
  "id": "4059e705-f5ed-455e-ae39-c1d980e85ae7",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1761991995000000
}

1761991995000000 Successfully connected to PostgreSQL 15.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 13.2.0, 64-bit event body

{
  "appname": "supabase-rest",
  "event_message": "Successfully connected to PostgreSQL 15.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 13.2.0, 64-bit",
  "id": "d5f9e2c1-f9da-4df9-84ae-dfe1bcb1ff50",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1761991995000000
}

1762002243000000 Successfully connected to PostgreSQL 15.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 13.2.0, 64-bit event body

{
  "appname": "supabase-rest",
  "event_message": "Successfully connected to PostgreSQL 15.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 13.2.0, 64-bit",
  "id": "a30113a9-342b-4a68-917e-59baac97cf58",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762002243000000
}

1762002243000000 Received a schema cache reload message on the "pgrst" channel event body

{
  "appname": "supabase-rest",
  "event_message": "Received a schema cache reload message on the \"pgrst\" channel",
  "id": "7553e2cd-2991-470c-9bb9-c5d21d1e1efb",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762002243000000
}

1762002243000000 Config reloaded event body

{
  "appname": "supabase-rest",
  "event_message": "Config reloaded",
  "id": "cfc54bcb-7922-4871-8e4d-32d0090f6fb4",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762002243000000
}

1762002243000000 Schema cache loaded in 2.5 milliseconds event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache loaded in 2.5 milliseconds",
  "id": "3a025c64-236d-4772-b206-76a7452ae64d",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762002243000000
}

1762002243000000 Schema cache loaded 60 Relations, 57 Relationships, 19 Functions, 0 Domain Representations, 4 Media Type Handlers, 1194 Timezones event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache loaded 60 Relations, 57 Relationships, 19 Functions, 0 Domain Representations, 4 Media Type Handlers, 1194 Timezones",
  "id": "1c2b27a4-d62c-415c-8738-b975524e31bf",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762002243000000
}

1762002243000000 Schema cache queried in 4.7 milliseconds event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache queried in 4.7 milliseconds",
  "id": "a781e723-cbb1-4c45-a4e8-d1bda86805d8",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762002243000000
}

1762075987000000 Schema cache queried in 4.3 milliseconds event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache queried in 4.3 milliseconds",
  "id": "e826f03a-5058-4570-8fb8-239724ce30dd",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762075987000000
}

1762075987000000 Successfully connected to PostgreSQL 15.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 13.2.0, 64-bit event body

{
  "appname": "supabase-rest",
  "event_message": "Successfully connected to PostgreSQL 15.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 13.2.0, 64-bit",
  "id": "b5f8043a-4fd2-469e-bb70-deaf1ff27abc",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762075987000000
}

1762075987000000 Schema cache loaded in 1.0 milliseconds event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache loaded in 1.0 milliseconds",
  "id": "355aae10-e144-4b97-8271-a3cce05937af",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762075987000000
}

1762075987000000 Config reloaded event body

{
  "appname": "supabase-rest",
  "event_message": "Config reloaded",
  "id": "f369dfdb-d8fe-4784-a451-d8bcbe71674d",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762075987000000
}

1762082943000000 Config reloaded event body

{
  "appname": "supabase-rest",
  "event_message": "Config reloaded",
  "id": "253b5c44-474c-4c03-9a00-f896a5703d22",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762082943000000
}

1762082943000000 Schema cache queried in 4.2 milliseconds event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache queried in 4.2 milliseconds",
  "id": "55d15f50-1c9a-42cd-9fff-a79e759226c2",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762082943000000
}

1762082943000000 Successfully connected to PostgreSQL 15.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 13.2.0, 64-bit event body

{
  "appname": "supabase-rest",
  "event_message": "Successfully connected to PostgreSQL 15.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 13.2.0, 64-bit",
  "id": "9f88cf97-a3b4-48fa-8c9e-13f00f8b85df",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762082943000000
}

1762082943000000 Schema cache loaded in 2.7 milliseconds event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache loaded in 2.7 milliseconds",
  "id": "c873da6f-cb06-44e6-b682-9110a48b98ec",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762082943000000
}

1762082943000000 Schema cache loaded 60 Relations, 57 Relationships, 19 Functions, 0 Domain Representations, 4 Media Type Handlers, 1194 Timezones event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache loaded 60 Relations, 57 Relationships, 19 Functions, 0 Domain Representations, 4 Media Type Handlers, 1194 Timezones",
  "id": "0e42dd2d-8cec-49c2-83e2-26665caed5be",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762082943000000
}

1762152884000000 Schema cache loaded in 2.0 milliseconds event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache loaded in 2.0 milliseconds",
  "id": "67e36b9d-d889-4ccc-b913-d7ba17f6b686",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762152884000000
}

1762152884000000 Successfully connected to PostgreSQL 15.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 13.2.0, 64-bit event body

{
  "appname": "supabase-rest",
  "event_message": "Successfully connected to PostgreSQL 15.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 13.2.0, 64-bit",
  "id": "9eaa3c5d-dd16-4d99-9d92-4848afa4bbd8",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762152884000000
}

1762152884000000 Schema cache queried in 3.9 milliseconds event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache queried in 3.9 milliseconds",
  "id": "f719ed24-37c3-47c9-bcaf-03ada2a5dd4d",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762152884000000
}

1762152884000000 Schema cache loaded 60 Relations, 57 Relationships, 19 Functions, 0 Domain Representations, 4 Media Type Handlers, 1194 Timezones event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache loaded 60 Relations, 57 Relationships, 19 Functions, 0 Domain Representations, 4 Media Type Handlers, 1194 Timezones",
  "id": "3d446910-431d-4fa8-b54a-dbe5f56594c2",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762152884000000
}

1762152884000000 Config reloaded event body

{
  "appname": "supabase-rest",
  "event_message": "Config reloaded",
  "id": "ffa79745-effb-4b3c-88dd-f8919d9e4aa9",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762152884000000
}

1762160583000000 Schema cache loaded 60 Relations, 57 Relationships, 19 Functions, 0 Domain Representations, 4 Media Type Handlers, 1194 Timezones event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache loaded 60 Relations, 57 Relationships, 19 Functions, 0 Domain Representations, 4 Media Type Handlers, 1194 Timezones",
  "id": "e395c10a-0240-4bdc-94d5-145fdf6f3e40",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762160583000000
}

1762160583000000 Schema cache queried in 5.9 milliseconds event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache queried in 5.9 milliseconds",
  "id": "c838b170-873d-43ba-a1e1-b011ce811db5",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762160583000000
}

1762160583000000 Successfully connected to PostgreSQL 15.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 13.2.0, 64-bit event body

{
  "appname": "supabase-rest",
  "event_message": "Successfully connected to PostgreSQL 15.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 13.2.0, 64-bit",
  "id": "a8d10896-eb27-41dc-acb3-5b8eb652c6ea",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762160583000000
}

1762160583000000 Received a schema cache reload message on the "pgrst" channel event body

{
  "appname": "supabase-rest",
  "event_message": "Received a schema cache reload message on the \"pgrst\" channel",
  "id": "31a76a98-dcfd-4a4f-a287-990be7e73720",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762160583000000
}

1762160583000000 Config reloaded event body

{
  "appname": "supabase-rest",
  "event_message": "Config reloaded",
  "id": "4cbd2fe0-9001-4f30-b345-5333bbb6fafe",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762160583000000
}

1762160583000000 Schema cache loaded in 3.5 milliseconds event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache loaded in 3.5 milliseconds",
  "id": "27758919-0c42-452d-94f2-53d4208e0410",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762160583000000
}

1762247303000000 Received a schema cache reload message on the "pgrst" channel event body

{
  "appname": "supabase-rest",
  "event_message": "Received a schema cache reload message on the \"pgrst\" channel",
  "id": "66a8390a-eb0c-428a-b1ef-53832692fa0e",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762247303000000
}

1762247303000000 Schema cache loaded in 1.2 milliseconds event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache loaded in 1.2 milliseconds",
  "id": "02c989d5-626d-4701-a555-c734ae1d7e1f",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762247303000000
}

1762259223000000 Received a schema cache reload message on the "pgrst" channel event body

{
  "appname": "supabase-rest",
  "event_message": "Received a schema cache reload message on the \"pgrst\" channel",
  "id": "d23f2945-c53b-4b40-b7ad-b71a850c7ae3",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762259223000000
}

1762259223000000 Successfully connected to PostgreSQL 15.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 13.2.0, 64-bit event body

{
  "appname": "supabase-rest",
  "event_message": "Successfully connected to PostgreSQL 15.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 13.2.0, 64-bit",
  "id": "9338ca5a-4b39-4163-9a51-c5192afcf7da",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762259223000000
}

1762259223000000 Schema cache loaded in 0.9 milliseconds event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache loaded in 0.9 milliseconds",
  "id": "6b677b99-3203-4827-8d6b-a4f908f5a027",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762259223000000
}

1762259223000000 Schema cache loaded 60 Relations, 57 Relationships, 19 Functions, 0 Domain Representations, 4 Media Type Handlers, 1194 Timezones event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache loaded 60 Relations, 57 Relationships, 19 Functions, 0 Domain Representations, 4 Media Type Handlers, 1194 Timezones",
  "id": "67de4532-1104-43fc-af66-cf62ed37d461",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762259223000000
}

1762259223000000 Config reloaded event body

{
  "appname": "supabase-rest",
  "event_message": "Config reloaded",
  "id": "b242c748-4e62-4179-807d-025a1d531783",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762259223000000
}

1762325223000000 Schema cache queried in 5.0 milliseconds event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache queried in 5.0 milliseconds",
  "id": "9dd6b37e-bb33-4105-baf7-7b28e23bd4fb",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762325223000000
}

1762325223000000 Config reloaded event body

{
  "appname": "supabase-rest",
  "event_message": "Config reloaded",
  "id": "258727a9-1b43-4af4-949f-fd4031ebe27b",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762325223000000
}

1762325223000000 Schema cache loaded in 3.5 milliseconds event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache loaded in 3.5 milliseconds",
  "id": "6822d6f3-7a5f-4fe0-af33-4319778662d1",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762325223000000
}

1762325223000000 Successfully connected to PostgreSQL 15.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 13.2.0, 64-bit event body

{
  "appname": "supabase-rest",
  "event_message": "Successfully connected to PostgreSQL 15.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 13.2.0, 64-bit",
  "id": "4735a685-a798-4c07-9493-a4aeb99785c7",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762325223000000
}

1762325223000000 Received a schema cache reload message on the "pgrst" channel event body

{
  "appname": "supabase-rest",
  "event_message": "Received a schema cache reload message on the \"pgrst\" channel",
  "id": "2b0e4b1b-c653-4a90-bcac-9205d521ed53",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762325223000000
}

1762339263000000 Config reloaded event body

{
  "appname": "supabase-rest",
  "event_message": "Config reloaded",
  "id": "b8ec75c2-370b-401d-8823-438c883436b0",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762339263000000
}

1762339263000000 Successfully connected to PostgreSQL 15.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 13.2.0, 64-bit event body

{
  "appname": "supabase-rest",
  "event_message": "Successfully connected to PostgreSQL 15.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 13.2.0, 64-bit",
  "id": "4094acad-66a8-4403-a0cd-70e0cbbf7452",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762339263000000
}

1762339263000000 Schema cache loaded in 2.2 milliseconds event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache loaded in 2.2 milliseconds",
  "id": "b65a6be7-72f7-41d8-8406-6087db50f6c4",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762339263000000
}

1762419829000000 Successfully connected to PostgreSQL 15.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 13.2.0, 64-bit event body

{
  "appname": "supabase-rest",
  "event_message": "Successfully connected to PostgreSQL 15.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 13.2.0, 64-bit",
  "id": "e63a0731-9f92-4731-86f1-ba428c52ee2f",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762419829000000
}

1762419829000000 Received a schema cache reload message on the "pgrst" channel event body

{
  "appname": "supabase-rest",
  "event_message": "Received a schema cache reload message on the \"pgrst\" channel",
  "id": "1390cc00-e966-40af-a66c-1305e08b57cd",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762419829000000
}

1762419829000000 Config reloaded event body

{
  "appname": "supabase-rest",
  "event_message": "Config reloaded",
  "id": "5de7b3d5-6675-4062-a41d-1cb04d84431f",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762419829000000
}

1762419829000000 Schema cache loaded 60 Relations, 57 Relationships, 19 Functions, 0 Domain Representations, 4 Media Type Handlers, 1194 Timezones event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache loaded 60 Relations, 57 Relationships, 19 Functions, 0 Domain Representations, 4 Media Type Handlers, 1194 Timezones",
  "id": "94d87cc3-231a-4905-a139-1aad22c3d21c",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762419829000000
}

1762419829000000 Schema cache queried in 4.7 milliseconds event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache queried in 4.7 milliseconds",
  "id": "d65d0bda-580b-4bb9-b6bb-91037123fb02",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762419829000000
}

1762434963000000 Received a schema cache reload message on the "pgrst" channel event body

{
  "appname": "supabase-rest",
  "event_message": "Received a schema cache reload message on the \"pgrst\" channel",
  "id": "c24f183b-1cd8-4970-80c9-46d522d78418",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762434963000000
}

1762434963000000 Schema cache loaded 60 Relations, 57 Relationships, 19 Functions, 0 Domain Representations, 4 Media Type Handlers, 1194 Timezones event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache loaded 60 Relations, 57 Relationships, 19 Functions, 0 Domain Representations, 4 Media Type Handlers, 1194 Timezones",
  "id": "bb0fc673-0f9b-4d2c-907f-591f36eaceba",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762434963000000
}

1762434963000000 Schema cache queried in 4.4 milliseconds event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache queried in 4.4 milliseconds",
  "id": "3da58814-ca5b-49e2-8d36-9f9194aee5c6",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762434963000000
}

1762434963000000 Config reloaded event body

{
  "appname": "supabase-rest",
  "event_message": "Config reloaded",
  "id": "2f4553aa-e5fc-4a0c-a276-f38f64b53294",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762434963000000
}

1762484283000000 Received a schema cache reload message on the "pgrst" channel event body

{
  "appname": "supabase-rest",
  "event_message": "Received a schema cache reload message on the \"pgrst\" channel",
  "id": "f878d273-90c8-4803-bf39-a7f84070e09e",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762484283000000
}

1762484283000000 Schema cache queried in 6.1 milliseconds event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache queried in 6.1 milliseconds",
  "id": "12ff55a6-b0a3-456e-be0d-2106dec099da",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762484283000000
}

1762484283000000 Config reloaded event body

{
  "appname": "supabase-rest",
  "event_message": "Config reloaded",
  "id": "b60edd22-9976-418e-a66d-1fe8ff46a77b",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762484283000000
}

1762484283000000 Config reloaded event body

{
  "appname": "supabase-rest",
  "event_message": "Config reloaded",
  "id": "db571bd6-177b-4c5b-bb33-710b2b5fa13a",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762484283000000
}

1762484283000000 Schema cache loaded 60 Relations, 57 Relationships, 19 Functions, 0 Domain Representations, 4 Media Type Handlers, 1194 Timezones event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache loaded 60 Relations, 57 Relationships, 19 Functions, 0 Domain Representations, 4 Media Type Handlers, 1194 Timezones",
  "id": "4b9ab0e4-8e5a-4067-8351-1cde7b2b6446",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762484283000000
}

1762484283000000 Schema cache queried in 6.2 milliseconds event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache queried in 6.2 milliseconds",
  "id": "9fbdd4a9-f08b-4970-83a3-dd6e54374266",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762484283000000
}

1762484283000000 Received a schema cache reload message on the "pgrst" channel event body

{
  "appname": "supabase-rest",
  "event_message": "Received a schema cache reload message on the \"pgrst\" channel",
  "id": "1c4b3055-c873-4cc5-ba22-cc8b2278d20f",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762484283000000
}

1762484283000000 Successfully connected to PostgreSQL 15.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 13.2.0, 64-bit event body

{
  "appname": "supabase-rest",
  "event_message": "Successfully connected to PostgreSQL 15.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 13.2.0, 64-bit",
  "id": "4ecf8351-891b-48d6-af15-0d941e448c0e",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762484283000000
}

1762484283000000 Successfully connected to PostgreSQL 15.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 13.2.0, 64-bit event body

{
  "appname": "supabase-rest",
  "event_message": "Successfully connected to PostgreSQL 15.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 13.2.0, 64-bit",
  "id": "c98d8c94-ab1f-490c-90fc-ba7712dd41ae",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762484283000000
}

1762484283000000 Schema cache loaded in 2.8 milliseconds event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache loaded in 2.8 milliseconds",
  "id": "d97a93a9-3fec-4d15-8b3b-acbdef6ddf64",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762484283000000
}

1762561804000000 Schema cache loaded 60 Relations, 57 Relationships, 19 Functions, 0 Domain Representations, 4 Media Type Handlers, 1194 Timezones event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache loaded 60 Relations, 57 Relationships, 19 Functions, 0 Domain Representations, 4 Media Type Handlers, 1194 Timezones",
  "id": "c3db74d4-48b9-439a-86ab-9b6eebeef439",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762561804000000
}

1762561804000000 Config reloaded event body

{
  "appname": "supabase-rest",
  "event_message": "Config reloaded",
  "id": "ef316694-b1cb-4062-9c06-90465c6a7d24",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762561804000000
}

1762561804000000 Schema cache queried in 5.7 milliseconds event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache queried in 5.7 milliseconds",
  "id": "0301e912-9538-4447-82a7-5d9f2198eea6",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762561804000000
}

1762561804000000 Received a schema cache reload message on the "pgrst" channel event body

{
  "appname": "supabase-rest",
  "event_message": "Received a schema cache reload message on the \"pgrst\" channel",
  "id": "5e9f2113-cdab-47c0-a682-03ecea602a0a",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762561804000000
}

1762561804000000 Schema cache queried in 4.9 milliseconds event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache queried in 4.9 milliseconds",
  "id": "32441454-07eb-4e14-a788-cac38bbc04c2",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762561804000000
}

1762561804000000 Received a schema cache reload message on the "pgrst" channel event body

{
  "appname": "supabase-rest",
  "event_message": "Received a schema cache reload message on the \"pgrst\" channel",
  "id": "7cd89a3c-a497-4e82-8248-a737d6d37aea",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762561804000000
}

1762561804000000 Successfully connected to PostgreSQL 15.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 13.2.0, 64-bit event body

{
  "appname": "supabase-rest",
  "event_message": "Successfully connected to PostgreSQL 15.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 13.2.0, 64-bit",
  "id": "b314dc43-b142-429a-96b1-db16f2c68ccd",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762561804000000
}

1762561804000000 Schema cache loaded in 2.6 milliseconds event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache loaded in 2.6 milliseconds",
  "id": "2c1b1dc6-055c-49c9-9eae-1d5df4f41a76",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762561804000000
}

1762561804000000 Schema cache loaded in 2.9 milliseconds event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache loaded in 2.9 milliseconds",
  "id": "7d12cd6e-b12c-4d0f-ade5-7f022d63936c",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762561804000000
}

1762561804000000 Schema cache loaded 60 Relations, 57 Relationships, 19 Functions, 0 Domain Representations, 4 Media Type Handlers, 1194 Timezones event body

{
  "appname": "supabase-rest",
  "event_message": "Schema cache loaded 60 Relations, 57 Relationships, 19 Functions, 0 Domain Representations, 4 Media Type Handlers, 1194 Timezones",
  "id": "bba54157-f815-4da4-97ef-384e3bb65092",
  "metadata": {
    "host": "default"
  },
  "project": "default",
  "timestamp": 1762561804000000
}

random(tips): Integers support greater and less than symobols (e.g. `m.response.origin_time:<1000`).

Source ID

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

494852b6-aedb-458f-92da-c32b6b1a608c

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=Rz5Uzxsh4RYW&source=494852b6-aedb-458f-92da-c32b6b1a608c"

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=Rz5Uzxsh4RYW&source=494852b6-aedb-458f-92da-c32b6b1a608c"

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=Rz5Uzxsh4RYW&source=494852b6-aedb-458f-92da-c32b6b1a608c

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=Rz5Uzxsh4RYW&source=494852b6-aedb-458f-92da-c32b6b1a608c
        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=Rz5Uzxsh4RYW&source=494852b6-aedb-458f-92da-c32b6b1a608c

Or send generic JSON events yourself.

          
    curl -X "POST" "http://localhost:4000/logs/json?source=494852b6-aedb-458f-92da-c32b6b1a608c" \
         -H 'Content-Type: application/json; charset=utf-8' \
         -H 'X-API-KEY: Rz5Uzxsh4RYW' \
         -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=494852b6-aedb-458f-92da-c32b6b1a608c" \
    -H 'Content-Type: application/json' \
    -H 'X-API-KEY: Rz5Uzxsh4RYW' \
    -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 = "494852b6-aedb-458f-92da-c32b6b1a608c"
        const apiKey = "Rz5Uzxsh4RYW"

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