How to view database storage usage (PostgreSQL engine) - PolarDB

You can view the database storage usage of your cluster in the PolarDB console. This topic describes how to view database storage usage.

Procedure

Centralized PolarDB for PostgreSQL clusters

Log in to the PolarDB console，In the navigation pane on the left, click Clusters. Select the Region where the cluster is deployed, and then click the cluster ID to go to the cluster details page。
On the Basic Information page, view Database Storage Usage in the Distributed Storage section.

Note

Each cluster specification has a corresponding maximum storage capacity. To increase the storage capacity limit, upgrade the cluster specification. For more information, see Change configuration.

PolarDB for PostgreSQL Distributed Edition clusters

Log in to the PolarDB console，In the navigation pane on the left, click Clusters. Select the Region where the cluster is deployed, and then click the cluster ID to go to the cluster details page。
On the Basic Information page, view the Storage Size of each node in the Cluster Topology section. Taking List View as an example, you can view the distributed storage information of Compute Node and Data Node, including the billing type (pay-as-you-go), storage type, Storage Size (e.g. 3.96 GB), Blktag limit, and Inode limit.

Note

Each cluster specification has a corresponding maximum storage capacity. To increase the storage capacity limit, upgrade the cluster specification. For more information, see Change configuration.

FAQ

Why does the database storage space viewed through SQL statements differ from the data space usage shown in the console?

When you use SQL statements to view database storage space, the logical size of the target database is returned. The data space usage displayed in the console is the physical storage space size from the file system perspective.