From: | Japin Li <japinli(at)hotmail(dot)com> |
---|---|
To: | "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | pg_relation_size on partitioned table |
Date: | 2022-03-25 12:52:40 |
Message-ID: | MEYP282MB1669B820AE730A48B2FC6E6FB61A9@MEYP282MB1669.AUSP282.PROD.OUTLOOK.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi, hackers
When I try to get total size of partition tables though partitioned table
name using pg_relation_size(), it always returns zero. I can use the
following SQL to get total size of partition tables, however, it is a bit
complex.
SELECT
pg_size_pretty(sum(pg_relation_size(i.inhrelid)))
FROM
pg_class c JOIN pg_inherits i ON c.oid = i.inhparent
WHERE
relname = 'parent';
Could we provide a function to get the total size of the partition table
though the partitioned table name? Maybe we can extend
the pg_relation_size() to get the total size of partition tables through
the partitioned table name.
--
Regrads,
Japin Li.
ChengDu WenWu Information Technology Co.,Ltd.
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2022-03-25 12:59:13 | Re: pg_relation_size on partitioned table |
Previous Message | Dagfinn Ilmari Mannsåker | 2022-03-25 12:42:18 | Re: Small TAP tests cleanup for Windows and unused modules |