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.
Tip
To calculate the cost of using the service, use our calculator on the Yandex Cloud website or check out the pricing below.
The prices for service products are also available in the price list.
Note
Currency of Service rates (prices) depends on the company you made a contract with:
- Prices in US dollars are applicable to customers of Iron Hive doo Beograd (Serbia) or Direct Cursus Technology L.L.C. (Dubai).
- Prices in Russian roubles are applicable to customers of Yandex.Cloud LLC.
All prices below do not include VAT.
Cluster status
Pricing is applied differently depending on the cluster status:
- For a
Runningcluster, you are charged both for the computing resources and the size of storage and backup. - For a
Stoppedcluster, you are only charged for the storage and backup size.
Alert
If a cluster uses local SSD storage (local-ssd), its computing resources are not released when it's stopped. This means that you are charged in full even for a stopped cluster.
What 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.
- Outgoing traffic from Yandex Cloud.
In all calculations: 1 GB = 230 bytes, 1 MB = 220 bytes.
Using 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 (for example, 90 seconds of host operation count as two minutes). You do not pay for the time when the Greenplum® host is unable to perform its main functions.
Disk 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 only include the data that has been changed since the previous backup rather than a full DB. It means the storage space used by automatic backups only increases in proportion to the amount of changes.
-
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 (for example, storing 1 GB for 90 seconds counts as storing 1 GB for 2 minutes).
Example 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-m32hosts: Intel Ice Lake, 8 × 100% vCPU, 32 GB RAM. - Storage for standard hosts: 100 GB of network HDD storage.
- Dedicated hosts: Three
s2.mediumhosts: 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.019350 + 32 × $0.005130) = $0.956880
Total: $0.956880, cost of operation of standard hosts per hour.
Where:
- 3: Number of standard hosts.
- 8: Number of vCPUs.
- $0.019350: Cost of using 100% vCPU per hour.
- 32: Amount of RAM per standard host (in GB).
- $0.005130: Cost of using 1 GB of RAM at 100% vCPU per hour.
Cost calculation for dedicated hosts:
3 × (8 × $0.010800 + 32 × $0.002790) = $0.527040
Total: $0.527040, cost of operation of dedicated hosts per hour.
Where:
- 3: Number of dedicated hosts.
- 8: Number of vCPUs.
- $0.010800: Cost of using 100% vCPU per hour.
- 32: Amount of RAM per dedicated host (in GB).
- $0.002790: Cost of using 1 GB of RAM at 100% vCPU per hour.
Calculation for the storage cost and total cost:
(720 × $0.956880 + 3 × (100 × $0.028800)) + (720 × $0.527040 + 3 × (50 × $0.117090)) = $1,094.625900
Total: $1,094.625900, cost of using the cluster for 30 days.
Where:
- 720: Number of hours in 30 days.
- $0.956880, cost of operation of standard hosts per hour.
- 3: Number of hosts.
- 100: Amount of network HDD storage (in GB) for standard hosts.
- $0.028800: Cost of using 1 GB of network HDD storage per month.
- $0.527040, cost of operation of dedicated hosts per hour.
- 50: Amount of local SSD storage (in GB) for dedicated hosts.
- $0.117090: Cost of using 1 GB of local SSD storage per month.
Discount for committed volumes of services (CVoS)
You can get a guaranteed discount on service resource usage when you plan for six months or one year ahead. To see the resources you can get a discount on:
- Go to Yandex Cloud Billing.
- Click on the desired billing account.
- Select Committed volume in the left-hand menu.
A CVoS guarantees a discount on consumption but does not guarantee the availability of the resources you order. Read more about CVoS in the Yandex Cloud Billing documentation.
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 forecast your monthly payments for the required number of vCPUs and RAM.
Note
A CVoS discount is only available for certain resource types. For unsupported resource types, the relevant CVoS columns under Prices are blank. Currently, you cannot order storage, web traffic, and computing resources for dedicated hosts this way.
Prices for the Russia region
Note
Yandex Cloud resources are priced differently in different regions. For more information about the available regions, see Regions.
Your payment currency is determined by your contracting legal entity. For more information on creating an account, see Registering an account in Yandex Cloud.
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 usage rate is based on 720 hours a month.
Host computing resources
Standard hosts
Note
Access to the Intel Ice Lake (Compute Optimized) platform is available upon request. Contact support or your account manager.
The cost calculation varies depending on the host configuration:
- For i2 and i3 hosts (
io-optimized), the cost is made up of the price for Greenplum® host computing resources (see the table below) and the price for software-accelerated network usage. - For hosts with other configurations, you only pay for their computing resources:
Prices per hour
| Resource | Price per hour, without VAT |
Price with CVoS for 6 months, without VAT |
Price with CVoS for 1 year, without VAT |
|---|---|---|---|
| Intel Cascade Lake | |||
| 100% vCPU | $0.021510 | — | — |
| RAM (for 1 GB) | $0.005670 | — | — |
| Intel Ice Lake | |||
| 100% vCPU | $0.019350 | $0.016447 (-15%) | $0.015093 (-22%) |
| RAM (for 1 GB) | $0.005130 | $0.004360 (-15%) | $0.004001 (-22%) |
| Intel Ice Lake (Compute Optimized) | |||
| 100% vCPU | $0.030960 | — | — |
| RAM (for 1 GB) | $0.005940 | — | — |
| AMD Zen 4 | |||
| 100% vCPU | $0.019350 | $0.016447 (-15%) | $0.015093 (-22%) |
| RAM (for 1 GB) | $0.005130 | $0.004361 (-15%) | $0.004002 (-22%) |
| AMD Zen 4 HighFreq | |||
| 100% vCPU | $0.037625 | — | — |
| RAM (for 1 GB) | $0.007219 | — | — |
Prices per month
| Resource | Price per month, without VAT |
Price with CVoS for 6 months, without VAT |
Price with CVoS for 1 year, without VAT |
|---|---|---|---|
| Intel Cascade Lake | |||
| 100% vCPU | $15.487194 | — | — |
| RAM (for 1 GB) | $4.082399 | — | — |
| Intel Ice Lake | |||
| 100% vCPU | $13.931994 | $11.842195 (-15%) | $10.866956 (-22%) |
| RAM (for 1 GB) | $3.693599 | $3.139559 (-15%) | $2.881007 (-22%) |
| Intel Ice Lake (Compute Optimized) | |||
| 100% vCPU | $22.291191 | — | — |
| RAM (for 1 GB) | $4.276799 | — | — |
| AMD Zen 4 | |||
| 100% vCPU | $13.931994 | $11.842195 (-15%) | $10.867195 (-22%) |
| RAM (for 1 GB) | $3.693599 | $3.139799 (-15%) | $2.881199 (-22%) |
| AMD Zen 4 HighFreq | |||
| 100% vCPU | $27.089989 | — | — |
| RAM (for 1 GB) | $5.197798 | — | — |
Dedicated hosts
Note
Access to the Intel Ice Lake (Compute Optimized) platform is available upon request. Contact support or your account manager.
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.
| Resource | Yandex MPP Analytics for PostgreSQL markup for 1 hour, without VAT |
|---|---|
| Intel Cascade Lake | |
| 100% vCPU | $0.010800 |
| RAM (for 1 GB) | $0.002790 |
| Intel Ice Lake | |
| 100% vCPU | $0.009720 |
| RAM (for 1 GB) | $0.002520 |
| Intel Ice Lake (Compute Optimized) | |
| 100% vCPU | $0.015570 |
| RAM (for 1 GB) | $0.002880 |
| AMD Zen 4 | |
| 100% vCPU | $0.009720 |
| RAM (for 1 GB) | $0.002520 |
| AMD Zen 4 HighFreq | |
| 100% vCPU | $0.018922 |
| RAM (for 1 GB) | $0.003500 |
Storage and backups
Note
Access to local SSD storage when using standard Intel Ice Lake hosts is provided upon request. Contact support or your account manager.
| Service | Price of 1 GB per month, without VAT |
|---|---|
| Network HDD storage | $0.028800 |
| Non-replicated SSD storage | $0.117090 |
| Network SSD storage | $0.117090 |
| High-performance SSD storage | $0.196020 |
| Local SSD storage | $0.117090 |
| Backups beyond the storage size | $0.017280 |
The cost is made up of two components: the Yandex Compute Cloud storage cost and the Yandex MPP Analytics for PostgreSQL price for it. All prices are per GB, per month.
| Service | Compute Cloud price, without VAT |
MDB price, without VAT |
Total price, without VAT |
|---|---|---|---|
| Network HDD storage | - | $0.028800 | $0.028800 |
| Non-replicated SSD storage | - | $0.079200 | $0.079200 |
| Network SSD storage | - | $0.117090 | $0.117090 |
| High-performance SSD storage | - | $0.196020 | $0.196020 |
| Local SSD storage | $0.079200 | $0.037890 | $0.117090 |
| Backups beyond the storage size | - | $0.017280 | $0.017280 |
Outbound 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.
| Resource category | Price of 1 GB, without VAT |
|---|---|
| Outgoing traffic, 100 GB or less per month | Free |
| Outgoing traffic, over 100 GB per month | $0.013770 |
Greenplum® and Greenplum Database® are registered trademarks or trademarks of Broadcom Inc. in the United States and/or other countries.