Re: pg_relation_size on partitioned table - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: pg_relation_size on partitioned table
Date
Msg-id Yj6tOqsJGGlQJ/vi@paquier.xyz
Whole thread Raw
In response to pg_relation_size on partitioned table  (Japin Li <japinli@hotmail.com>)
Responses Re: pg_relation_size on partitioned table
List pgsql-hackers
On Fri, Mar 25, 2022 at 08:52:40PM +0800, Japin Li wrote:
> 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.

There are already many replies on this thread, but nobody has
mentioned pg_partition_tree() yet, so here you go.  You could use that
in combination with pg_relation_size() to get the whole size of a tree
depending on your needs.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Corruption during WAL replay
Next
From: Justin Pryzby
Date:
Subject: Re: Add LZ4 compression in pg_dump