PG_RELFILENODE_SIZE¶
The PG_RELFILENODE_SIZE system catalog provides file-level space statistics. Each record in the catalog corresponds to a physical file on the disk and the size of the file.
Name | Type | Description |
---|---|---|
databaseid | oid | OID of the database that the physical file belongs to If a system catalog is shared across databases, its value is 0. |
tablespaceid | oid | Tablespace OID of the physical file |
relfilenode | oid | Serial number of the physical file |
backendid | integer | ID of the background thread that creates the physical file. Generally, the value is -1. |
type | integer | Type of the physical file.
|
filesize | bigint | Size of the physical file, in bytes. |