Help Center/ Relational Database Service_RDS for PostgreSQL/ User Guide/ Problem Diagnosis and SQL Analysis/ Problem Diagnosis/ Managing Storage Capacity
Updated on 2026-06-15 GMT+08:00
View PDF
Share

Managing Storage Capacity

Function Description

Data and log storage space and its changes significantly impact database performance. RDS for PostgreSQL shows you the distribution and changes of used storage on the Storage Analysis page. It also provides storage autoscaling, intelligent tablespace diagnosis, and analysis of top 50 largest databases and tables.

Table 1 Function Description

Function

Description

Related Operations

Overview

You can view storage usage, available storage, total storage, daily increase in the last week, and estimated available days of storage.

Viewing the Storage Overview

Tablespaces

It helps you diagnose tables without primary keys.

Tablespaces

Top Databases

You can view the top 50 databases by physical file size and identify the databases with high usage based on storage space distribution.

Top Databases

Procedure

  1. Log in to the RDS console.
  2. Click in the upper left corner and select a region.
  3. On the Instances page, click the target instance name to go to the Summary page.
  4. In the navigation pane, choose Storage Analysis under DBA Assistant.
  5. Check your storage usage. If the storage is insufficient, scale it up. Or you can enable storage autoscaling.

    Figure 1 Overview

    If the total number of files in the storage space (including data space, WAL log space, audit log space, and temporary space) exceeds 100,000, the system may fail to collect statistics on the space distribution. To prevent this issue, limit the number of files.

    • Data space: storage space occupied by user data
    • WAL logs: storage space occupied by WAL logs
    • Audit logs: storage space occupied by audit logs
    • Temporary space: storage space occupied by temporary files

This function counts tables without primary keys. To use this function, upgrade DBA Assistant first.

  1. Click the Storage Analysis tab to view abnormal tables.

    Figure 2 Tablespace diagnosis

  2. Click Subscribe. The displayed dialog box shows details of enhanced features and pricing.

    Figure 3 Upgrading DBA Assistant

  3. After the upgrade is complete, view the table diagnosis results of your instance.

    Figure 4 Table diagnosis results

You can view the top 50 databases by physical file size and identify the databases with high usage based on storage space distribution.

  • Physical file sizes are precisely recorded, but other fields' values are estimated. If there is a large gap between a file size and another field, run ANALYZE TABLE on the table.
  • A database or table whose name contains special characters, including slashes (/) and #p#p, is not counted.
  • If your instance's memory usage is greater than 85% or it has more than 50,000 tables, RDS will not collect related information. This prevents performance slowdowns caused by collecting statistics on too many databases and tables.
Figure 5 Top 50 databases

Click View Chart to view data volume changes in the last 7 days, last 30 days, or a custom time period (spanning no more than 30 days).

Figure 6 Viewing data volume changes
Parent Topic: Problem Diagnosis