2018-06-01 17:15 GMT+02:00 Ashutosh Bapat <ashutosh.ba...@enterprisedb.com>:
> On Fri, Jun 1, 2018 at 12:56 AM, Pavel Stehule <pavel.steh...@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 >
