PostgreSQL Sizing

Use Sizing to see how big one PostgreSQL instance is, how fast it grows, which tables grow, and how much room its disks have left.

Before you begin

  • You need the View PostgreSQL and View Sizing permissions.
  • Once a day, Scops takes a picture of the databases and of their tables of 8 MB or more. Every hour, it reads the WAL, the temporary files, the server log, the tablespaces and the file systems.
  • Scops keeps the table sizes for 90 days and the database and disk sizes for 365 days by default (see Retention).
  • The free disk space needs an OS credential on the instance (see PostgreSQL permissions).
  • To show one database, select it in the database bar. The page then has only the Overview and Tables tabs.

Choose the window

  1. Select 1W, 1M (the default) or 1Y. The window ends on the newest picture.

  2. For a different window, click the calendar button. Select two days that have a picture in From and to, then click Apply.

  3. To read the window again, click the refresh button.

The page compares the picture at the start of the window with the picture at its end.

Read the values at the top

ValueWhat it shows
SizeThe size of all databases together at the end of the window.
GrewHow much the size changed between the two pictures of the window. The label shows the days, for example Grew in 30 days.
WALThe files in pg_wal at the newest hourly reading.
Free spaceThe file system with the least room left: its free percent, its mount point and when it is full. Red under 3% free or when full within 7 days. Amber under 10% free or when full within 30 days.

Follow the WAL and the free space

  1. Click WAL or Free space at the top. The Space window opens on its tab.

  2. Select a period: 1D, 1W (the default), 1M or 1Y.

WAL shows the size of the WAL directory by the hour. A size that rises and does not fall is bad. Free Space shows the free space of each file system by the hour.

Read the charts

  • Size shows the size day by day. It starts after the second daily picture.
  • Change per day shows how much the size changed each day.
  1. To see what changed on one day, click its bar in Change per day. The tabs compare that day with the picture before it.

  2. To show the full window again, click the chip in the chart header.

Find the tables that grew

The Overview tab shows two lists: Grew the most and Shrank the most, 15 tables each. Each row shows the change, its share of the list, and the size that the table came to.

  • new: the table was not in the first picture of the window.
  • gone: the table was not in the last picture.

Find a table

The Tables tab lists the 200 largest tables of the window. To find a different table, type part of its name in Search tables.

ColumnWhat it shows
TableThe schema and the name. A partitioned table shows the count of its partitions.
Total SizeThe table, its indexes and its TOAST together.
Table, Indexes, TOASTThe size of each part.
ChangeThe change between the two pictures.

≈ before a size means an estimate from the page count of the table, not from its files.

Open a table

Click a row. The row shows:

  • Last 30 days: the total size of the table, day by day.
  • Indexes: each index with its size, its scans and its last scan. The tags show primary key, unique or invalid. For a partitioned table, the row shows its largest partitions.
  • Bloat: only when the pgstattuple extension is in the database of the table.

Measure the bloat of a table

  1. Open the row of the table.

  2. In Bloat, click Measure.

Scops reads the table now and shows its Free space, its Dead rows and what A rewrite gives back. The values are amber when free space and dead rows are 20% of the table or more. To measure again, click Measure Again.

The measure reads the pages of the table that vacuum did not mark as all-visible. On a large table, this adds read I/O. Scops stops the measure after 15 seconds.

Compare the databases

The Databases tab lists each database with its Size, its % of Instance and its Change. The tag not read means that Scops could not read the tables of that database, for example without CONNECT on it. Point to the tag to see why.

See where the space goes

The Disk space tab groups the places that PostgreSQL writes to by file system. The places are the data, the WAL, the server log, the temporary files and each tablespace. For each file system, the tab shows what PostgreSQL uses, the free space, and when it is full.

Updated November 22, 2026