Yandex MPP Analytics for PostgreSQL pricing policy

In this section, you can find the Yandex MPP Analytics for PostgreSQL pricing policy and effective prices for its resources.

The prices for service products are also available in the price list.

All prices below do not include VAT.

Cluster statusCluster status

The prices apply differently depending on the cluster status:

• For a Running cluster, you pay for both the computing resources and the size of your storage and backups.
• For a Stopped cluster, you only pay for the size of your storage and backups.

What goes into the cost of using Yandex MPP Analytics for PostgreSQLWhat goes into the cost of using Yandex MPP Analytics for PostgreSQL

The Yandex MPP Analytics for PostgreSQL usage cost includes:

• Disk type and storage size.
• Computing resources allocated to cluster hosts and host type.
• Settings and number of backups.
• Egress traffic from Yandex Cloud to the internet.

In all calculations: 1 GB = 2³⁰ bytes, 1 MB = 2²⁰ bytes.

Using cluster hostsUsing cluster hosts

There are different ways to calculate the cost depending on the host type:

• Standard hosts

  The host operation cost is charged per hour based on what computing resources you allocate for it.

• Dedicated hosts

  The cost is made up of two components: the cost of Yandex Compute Cloud computing resources and Yandex MPP Analytics for PostgreSQL charges for these resources.

You can find the supported resource configurations in the Host classes section. For the vCPU and RAM prices, see Prices.

The minimum billing unit is one minute, e.g., 1.5 minutes of host operation cost the same as two minutes. You will not be charged for the time when the Greenplum® host is unavailable for basic operations.

Disk space usageDisk space usage

You pay for the following:

• Storage allocated for clusters.

  • You can only order local SSD storage (local-ssd) for clusters with two master hosts:

    • For Intel Cascade Lake: In increments of 100 GB.
    • For Intel Ice Lake: In increments of 368 GB.

  • You can only order non-replicated SSD (network-ssd-nonreplicated) storage for clusters with two master hosts, in increments of 93 GB.

  To pay less for storage, export AO and AOCO tables from disks within the Greenplum® cluster to a cold storage in Yandex Object Storage. The data will be stored in a service bucket in compressed and encrypted form, which is more cost-efficient. The cost of such storage is calculated based on the Object Storage pricing policy.

• Space occupied by DB backups beyond the storage size specified for the cluster.

  • Backups are stored free of charge as long as the combined size of the DB and all backups is smaller than the selected storage size.

  • Automatic backups in Yandex MPP Analytics for PostgreSQL do not create a new copy but capture changes made to a database since its previous backup. It means the storage space used by automatic backups only increases in proportion to the amount of changed data.

  • The number of hosts in a cluster does not affect the storage size and, consequently, the amount of free backups.

The price covers one month of use based on 720 hours per month. The minimum billing unit is 1 GB per minute; e.g., storing 1 GB for 1.5 minutes costs the same as for 2 minutes.

Example of cluster cost calculationExample of cluster cost calculation

Let's calculate the cost of using a cluster with the following properties for 30 days:

• Standard hosts: Three s3-c8-m32 hosts, Intel Ice Lake, 8 × 100% vCPU, 32 GB RAM.
• Storage for standard hosts: 100 GB of network HDD storage.
• Dedicated hosts: Three s2.medium hosts, Intel Cascade Lake, 8 × 100% vCPU, 32 GB RAM.
• Storage for dedicated hosts: 50 GB of local SSD storage.

Cost calculation for standard hosts:

3 × (8 × $0.0193 + 32 × $0.0051) = $0.95

Total: $0.95: Cost of operation of standard hosts per hour.

Where:

• 3: Number of standard hosts.
• 8: Number of vCPUs.
• $0.0193: Cost of using 100% vCPU per hour.
• 32: Amount of RAM per standard host (in GB).
• $0.0051: Cost of using 1 GB of RAM at 100% vCPU per hour.

Cost calculation for dedicated hosts:

3 × (8 × $0.0108 + 32 × $0.0028) = $0.53

Total: $0.53: Cost of operation of dedicated hosts per hour.

Where:

• 3: Number of dedicated hosts.
• 8: Number of vCPUs.
• $0.0108: Cost of using 100% vCPU per hour.
• 32: Amount of RAM per dedicated host (in GB).
• $0.0028: Cost of using 1 GB of RAM at 100% vCPU per hour.

Calculation for the storage cost and total cost:

(720 × $0.95 + 3 × (100 × $0.0288)) + (720 × $0.53 + 3 × (50 × $0.1171)) = $1,092.38

Total: $1,092.38, cost of using the cluster for 30 days.

Where:

• 720: Number of hours in 30 days.
• $0.95: Cost of operation of standard hosts per hour.
• 3: Number of hosts.
• 100: Amount of network HDD storage (in GB) for standard hosts.
• $0.0288: Cost of using 1 GB of network HDD storage per month.
• $0.53: Cost of operation of dedicated hosts per hour.
• 50: Amount of local SSD storage (in GB) for dedicated hosts.
• $0.1171: Cost of using 1 GB of local SSD storage per month.

Discount for committed volume of services (CVoS)Discount for committed volume of services (CVoS)

You can get a guaranteed discount on service resource usage when you plan for 6 or 12 months ahead. To view the resources eligible for this discount:

1. Navigate to Yandex Cloud Billing.
2. Click the billing account.
3. Select Committed volume in the left-hand menu.

A CVoS guarantees a discount on usage, but does not guarantee the availability of the resources you order. You can read more about CVoS in the relevant Yandex Cloud Billing article.

Yandex MPP Analytics for PostgreSQL provides two types of CVoS: on vCPUs and on RAM for the hosts you intend to use in your DB clusters. In the management console, you can see how much you can potentially save with CVoS at the current consumption level. You can also estimate your monthly payments for the required number of vCPUs and RAM.

Prices for the Russia regionPrices for the Russia region

Host prices are calculated in different ways depending on the selected host type.

The price of local SSD storage (local-ssd) also depends on the host type.

The monthly prices are based on 720 hours per month.

The cost calculation varies depending on the host configuration:

• For i2 and i3 hosts (io-optimized), you should add the cost of the computing resources of Greenplum® hosts and the cost of using a software-accelerated network.
• For hosts with other configurations, you only pay for their computing resources.

The cost of dedicated hosts is a sum of the price for Yandex Compute Cloud computing resources and Yandex MPP Analytics for PostgreSQL markup on these resources.

Outgoing trafficOutgoing traffic

When using the service, you pay for traffic from Yandex Cloud to the internet. Traffic between internal IP addresses of Yandex Cloud services and incoming internet traffic is free.

The first 100 GB of outgoing traffic per month are free of charge.

The minimum billing unit is 1 MB.

Greenplum® and Greenplum Database® are registered trademarks or trademarks of Broadcom Inc. in the United States and/or other countries.