Documentation Index
Fetch the complete documentation index at: https://private-7c7dfe99-page-updates.mintlify.app/llms.txt
Use this file to discover all available pages before exploring further.
ClickPipes for PostgreSQL CDC
This section outlines the pricing model for the Postgres Change Data Capture (CDC) connector in ClickPipes. In designing this model, the goal was to keep pricing highly competitive while staying true to our core vision:Making it seamless and affordable for customers to move data from Postgres to ClickHouse for real-time analytics.The connector is over 5x more cost-effective than external ETL tools and similar features in other database platforms.
Pricing dimensions
There are two main dimensions to pricing:- Ingested Data: The raw, uncompressed bytes coming from Postgres and ingested into ClickHouse.
- Compute: The compute units provisioned per service manage multiple Postgres CDC ClickPipes and are separate from the compute units used by the ClickHouse Cloud service. This additional compute is dedicated specifically to Postgres CDC ClickPipes. Compute is billed at the service level, not per individual pipe. Each compute unit includes 2 vCPUs and 8 GB of RAM.
Ingested data
The Postgres CDC connector operates in two main phases:- Initial load / resync: This captures a full snapshot of Postgres tables and occurs when a pipe is first created or re-synced.
- Continuous Replication (CDC): Ongoing replication of changes—such as inserts, updates, deletes, and schema changes—from Postgres to ClickHouse.
| Phase | Cost |
|---|---|
| Initial load / resync | $0.10 per GB |
| Continuous Replication (CDC) | $0.20 per GB |
Compute
This dimension covers the compute units provisioned per service just for Postgres ClickPipes. Compute is shared across all Postgres pipes within a service. It is provisioned when the first Postgres pipe is created and deallocated when no Postgres CDC pipes remain. The amount of compute provisioned depends on your organization’s tier:| Tier | Cost |
|---|---|
| Basic Tier | 0.5 compute unit per service — $0.10 per hour |
| Scale or Enterprise Tier | 1 compute unit per service — $0.20 per hour |
Example
Let’s say your service is in Scale tier and has the following setup:- 2 Postgres ClickPipes running continuous replication
- Each pipe ingests 500 GB of data changes (CDC) per month
- When the first pipe is kicked off, the service provisions 1 compute unit under the Scale Tier for Postgres CDC
Monthly cost breakdown
Ingested Data (CDC): Compute:FAQ for Postgres CDC ClickPipes
Is the ingested data measured in pricing based on compressed or uncompressed size?
Is the ingested data measured in pricing based on compressed or uncompressed size?
When will Postgres CDC pricing start appearing on my bills?
When will Postgres CDC pricing start appearing on my bills?
Will I be charged if I pause my pipes?
Will I be charged if I pause my pipes?
How can I estimate my pricing?
How can I estimate my pricing?
Can I scale the compute allocated for Postgres CDC in my service?
Can I scale the compute allocated for Postgres CDC in my service?
What is the pricing granularity?
What is the pricing granularity?
- Compute: Billed per hour. Partial hours are rounded up to the next hour.
- Ingested Data: Measured and billed per gigabyte (GB) of uncompressed data.
Can I use my ClickHouse Cloud credits for Postgres CDC via ClickPipes?
Can I use my ClickHouse Cloud credits for Postgres CDC via ClickPipes?
How much additional cost should I expect from Postgres CDC ClickPipes in my existing monthly ClickHouse Cloud spend?
How much additional cost should I expect from Postgres CDC ClickPipes in my existing monthly ClickHouse Cloud spend?