PasteZap
🌐 简体中文
免费 · 无需注册

免费 · 网络与 IT 基础设施

数据库容量计算器.

根据表、行数、索引、副本和预留空间,估算数据库当前容量和数月增长后的容量。

开始之前

部分技术控件使用英语。支持 Unicode 文本;文件格式和输出语言取决于具体工具。

下面以英语列出技术限制。处理大型文件或使用结果之前,请先查看这些限制。

CALCULATED IN YOUR BROWSER · NOTHING IS UPLOADED
Tables
Data at 24 months57.11 GBper copy
Data now
17.49 GB
Growth per month
1.65 GB
Disk per server (with reserve)
74.25 GB
Total for 2 copies
148.5 GB

Tables

TableSize nowSize at horizonRows at horizon
customers169 MB298.79 MB442,000
orders624 MB1.37 GB2,640,000
order_items1.09 GB2.4 GB8,800,000
events15.6 GB53.04 GB170,000,000
  • Measure real sizes when possible: PostgreSQL pg_total_relation_size(), MySQL information_schema.TABLES (data_length + index_length), SQL Server sp_spaceused.
  • Add room for write-ahead logs, temporary files, backups and maintenance (VACUUM, index rebuilds) on the same volume.

使用方法: 数据库容量计算器

输入数据或选择文件,调整设置并生成结果。复制或下载之前,请检查结果。

限制与支持格式

输入内容在您的设备上处理。

英语技术说明

An estimate; real size depends on engine, types, fill factor and compression. Write-ahead logs and backups are not included. Everything is calculated in your browser; nothing is sent or probed on the network.

Size = rows × (row + index bytes) × (1 + overhead), now and at the horizon; disk adds the free-space reserve and multiplies by the number of copies.

Four tables with 55 million rows today grow to about 57 GB in 24 months, 148 GB of disk for two copies with reserve.