Re: ToDo: show size of partitioned table

čt 29. 11. 2018 v 7:58 odesílatel Michael Paquier <michael(at)paquier(dot)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
>