On Fri, Jun 1, 2018 at 12:56 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote: > Hi > > postgres=# SELECT count(*) from data; > ┌─────────┐ > │ count │ > ╞═════════╡ > │ 1000000 │ > └─────────┘ > (1 row) > > \dt+ can display actual size of partitioned table data - now zero is > displayed > > postgres=# \dt+ data > List of relations > ┌────────┬──────┬───────┬───────┬─────────┬─────────────┐ > │ Schema │ Name │ Type │ Owner │ Size │ Description │ > ╞════════╪══════╪═══════╪═══════╪═════════╪═════════════╡ > │ public │ data │ table │ pavel │ 0 bytes │ │ > └────────┴──────┴───────┴───────┴─────────┴─────────────┘ > (1 row)
I think we should at least display "Type" as "partitioned table" for a partitioned table, so that it's easy to understand why the size is 0; partitioned tables do not hold any data by themselves.
should be.
Some is missing still - there is not any total size across all partitions.
maybe new command like
\dtP+ .. show partitioned tables and their size
Regards
Pavel
-- Best Wishes, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database Company