From: | Jeevan Ladhe <jeevan(dot)ladhe(at)enterprisedb(dot)com> |
---|---|
To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
Cc: | Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: ToDo: show size of partitioned table |
Date: | 2018-06-19 17:41:10 |
Message-ID: | CAOgcT0OABjNbJLbybf2jSuRDy7evUW7WH_AOZNEgPfjC5ngV5Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Fri, Jun 1, 2018 at 8:51 PM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
wrote:
>
>
> 2018-06-01 17:15 GMT+02:00 Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com
> >:
>
>> On Fri, Jun 1, 2018 at 12:56 AM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)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.
>
>
Yes, or maybe we can add that info in "Description".
> Some is missing still - there is not any total size across all partitions.
>
> maybe new command like
>
> \dtP+ .. show partitioned tables and their size
>
+1
Regards,
Jeevan Ladhe
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Geoghegan | 2018-06-19 17:43:10 | Re: Making all nbtree entries unique by having heap TIDs participate in comparisons |
Previous Message | David G. Johnston | 2018-06-19 17:41:00 | Re: Fast default stuff versus pg_upgrade |