Logflare
Logflare is a centralized web-based log management solution to easily access Cloudflare, Vercel & Elixir logs.
The Logflare Wrapper allows you to read data from Logflare endpoints within your Postgres database.
Preparation
Before you can query Logflare, you need to enable the Wrappers extension and store your credentials in Postgres.
Enable Wrappers
Make sure the wrappers
extension is installed on your database:
1 |
|
Enable the Logflare Wrapper
Enable the logflare_wrapper
FDW:
1 2 3 |
|
Store your credentials (optional)
By default, Postgres stores FDW credentials inside pg_catalog.pg_foreign_server
in plain text. Anyone with access to this table will be able to view these credentials. Wrappers is designed to work with Vault, which provides an additional level of security for storing credentials. We recommend using Vault to store your credentials.
1 2 3 4 5 6 7 |
|
Connecting to Logflare
We need to provide Postgres with the credentials to connect to Logflare, and any additional options. We can do this using the create server
command:
1 2 3 4 5 |
|
1 2 3 4 5 |
|
Create a schema
We recommend creating a schema to hold all the foreign tables:
1 |
|
Options
The full list of foreign table options are below:
endpoint
- Logflare endpoint UUID or name, required.
Entities
Logflare
This is an object representing Logflare endpoint data.
Ref: Logflare docs
Operations
Object | Select | Insert | Update | Delete | Truncate |
---|---|---|---|---|---|
Logflare | ✅ | ❌ | ❌ | ❌ | ❌ |
Usage
1 2 3 4 5 6 7 8 9 |
|
Notes
Meta Column _result
:
- Data type must be
text
- Stores the whole result record in JSON string format
- Use JSON queries to extract fields:
_result::json->>'field_name'
Query Parameters:
- Use parameter columns with prefix
_param_
- Example:
_param_org_id
,_param_iso_timestamp_start
- Parameters are passed to the Logflare endpoint
Query Pushdown Support
This FDW doesn't support query pushdown.
Limitations
This section describes important limitations and considerations when using this FDW:
- Full result sets are loaded into memory, which can impact PostgreSQL performance with large datasets
- Parameter names must be prefixed with 'param' and match the expected endpoint parameters exactly
- Materialized views using these foreign tables may fail during logical backups
Examples
Basic Example
Given a Logflare endpoint response:
1 2 3 4 5 6 |
|
You can create and query a foreign table:
1 2 3 4 5 6 7 8 9 10 11 |
|
Query Parameters Example
For an endpoint accepting parameters:
- org_id
- iso_timestamp_start
- iso_timestamp_end
With response format:
1 2 3 4 5 6 7 8 |
|
Create and query the table with parameters:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 |
|