pg_total_relation_size()

Overview

The pg_total_relation_size() is a database object size function that retrieves the size of a table and is useful for monitoring the storage requirements.

Syntax

The syntax for the pg_total_relation_size() function is as follows:

pg_total_relation_size('relation_name');

It returns the size of the specified table in bytes.

Parameters

The following parameters are required to execute this function:

• relation_name: name of the table for which you want to determine the size

Example

For the needs of this section, we will create a users table

CREATE TABLE users (
    username TEXT,
    email TEXT
);
INSERT INTO users (username, email) VALUES
    ('john_doe', '[e-mail]'),
    ('jane_smith', '[e-mail]'),
    ('alice_smith', '[e-mail]'),
    ('bob_jones', '[e-mail]'),
    ('susan_wilson', '[e-mail]'),
    ('michael_jackson', '[e-mail]'),
    ('lisa_johnson', '[e-mail]'),
    ('david_smith', '[e-mail]');

Now we would like to use the pg_total_relation_size() function to determine the size of the users table (in bytes)

SELECT pg_total_relation_size('users');

By executing the query above, we will get the following output:

 pg_total_relation_size 
------------------------
                    556