Link copied to clipboard!

Database Schema

The database covers five clouds, each with the table prefix aws, gcp, azure, stackit or ovh. Prices are Linux on-demand rates in USD per hour from one low-price reference region per cloud (AWS: us-east-1, GCP: us-central1, Azure: eastus, STACKIT: eu01, OVHcloud: standard region; EUR prices converted at the ECB reference rate).

Table / ViewContents
<cloud>_allEvery instance type of that cloud. All five tables share an identical 27-column schema, so clouds are directly comparable, e.g. select * from aws_all union all select * from gcp_all.
<cloud>Comparable slice: current-generation, priced, non-burstable, non-accelerator, non-metal instances ("strange instances" dropped).
<cloud>_familyOne representative instance per family (not available for GCP).
<cloud>_accelGPU/accelerator instances.
<cloud>_burstBurstable / shared-core instances (vcpus_base < vcpus).
benchmarkSPEC CPU results for AWS instances: instance, benchmark, value.

Columns of <cloud>_all

Values a cloud does not publish are NULL.

ColumnDescription
instanceFull instance name (e.g. c7g.medium)
familyInstance family (name prefix before the size, e.g. c7g)
categoryProvider's instance category (e.g. General purpose, Compute optimized)
price_hourLinux on-demand price per hour in USD (reference region)
ram_gibMain memory in GiB
vcpusNumber of vCPUs (hyperthreads)
vcpus_baseBaseline vCPUs; burstable/shared-core instances run below vcpus, equals vcpus otherwise
coresNumber of physical cores
processor_modelProcessor model (granularity varies by cloud)
archProcessor architecture (x86_64, arm64)
net_gbitpsBaseline network bandwidth in Gbit/s
net_peak_gbitpsPeak (burst) network bandwidth in Gbit/s
storage_gbTotal local instance storage in GB
storage_countNumber of local storage devices
storage_is_ssdWhether local storage is SSD
storage_is_nvmeWhether local storage is NVMe
ebs_iopsBaseline remote block storage (EBS-style) IOPS
ebs_gbitpsBaseline remote block storage bandwidth in Gbit/s
ebs_peak_iopsMaximum (burst) remote block storage IOPS
ebs_peak_gbitpsMaximum (burst) remote block storage bandwidth in Gbit/s
acceleratorsNumber of attached accelerators (GPU/FPGA/...)
accelerator_modelAccelerator model
accelerator_gibTotal accelerator memory in GiB
is_currentWhether this is a current-generation instance type
storage_read_iopsLocal-storage random read IOPS
storage_write_iopsLocal-storage random write IOPS
release_yearRelease date as a fractional year, year + (month-1)/12