pg_total_relation_size

6min
Overview
The pg_total_relation_size function allows you to retrieve the size of a table. This function is useful for monitoring the storage requirements.
Syntax
The syntax for the pg_total_relation_size function is as follows:
Pgsql
|
pg_total_relation_size('relation_name');
pg_total_relation_size('relation_name');
﻿
Here, relation_name is the name of the table for which you want to determine the size.
Output
The pg_total_relation_size function returns the size of the specified table in bytes.
Example
1) First, let’s assume we have a table named users. Use the below query to create the table.
Pgsql
|
CREATE TABLE users (
    username TEXT,
    email TEXT
);
INSERT INTO users (username, email) VALUES
    ('john_doe', '[email protected]'),
    ('jane_smith', '[email protected]'),
    ('alice_smith', '[email protected]'),
    ('bob_jones', '[email protected]'),
    ('susan_wilson', '[email protected]'),
    ('michael_jackson', '[email protected]'),
    ('lisa_johnson', '[email protected]'),
    ('david_smith', '[email protected]');
CREATE TABLE users (
    username TEXT,
    email TEXT
);
INSERT INTO users (username, email) VALUES
    ('john_doe', 'john.doe@example.com'),
    ('jane_smith', 'jane.smith@example.com'),
    ('alice_smith', 'alice.smith@example.com'),
    ('bob_jones', 'bob.jones@example.com'),
    ('susan_wilson', 'susan.wilson@example.com'),
    ('michael_jackson', 'michael.jackson@example.com'),
    ('lisa_johnson', 'lisa.johnson@example.com'),
    ('david_smith', 'david.smith@example.com');
﻿
2) In this case, we will use the pg_total_relation_size function to determine the size of a users table.
Pgsql
|
SELECT pg_total_relation_size('users');
SELECT pg_total_relation_size('users');
﻿
3) This query will return the size of the users table in bytes.
Pgsql
|
 pg_total_relation_size 
------------------------
                    556
 pg_total_relation_size 
------------------------
                    556
﻿
﻿
Updated 13 Sep 2023
Did this page help you?
NULLIF
has_schema_privilege()
Docs powered by
Archbee
TABLE OF CONTENTS