Re: ToDo: show size of partitioned table

čt 29. 11. 2018 v 7:58 odesílatel Michael Paquier <michael@paquier.xyz> napsal:

On Thu, Nov 22, 2018 at 03:47:11PM +0100, Pavel Stehule wrote:
> I have not feel well when I see in one report numbers 40 and 16, I see much
> more comfortable when I see 24 and 16, but for this I need a different
> perspective
>
> What do you think about it?

Maybe, my thought is that this would be a separate patch, and that we
had better keep it simple for now because that's complicated enough :)

any time, the behave should be consistent.

I agree, so there can be another patch, that reports more about partitioned table for \d+

So I would rather have a wrapper on top of pg_partition_tree which is
useful for the user with matching patterns, which shows roughly:
- the size of the whole partition tree from the root.
- its direct parent if any.  Potentially in the verbose output.  This
depends on how much users have multi-level partitions.  My bet would be
not that much, but more input from others is welcome.
- perhaps its level in the hierarchy, if integrated most likely as part
of the verbose output.

Then with the set of commands, have a mapping close to how \d treats
indexes and relations:
- \dp shows information about partitioned tables or indexes, if no pattern
is defined tables show up.  If a partitioned index pattern shows up,
then index information is displayed.

ok

- \dpi and \dpt for respectively partitioned indexes and tables.

--
Michael