Re: ToDo: show size of partitioned table
| От | Pavel Stehule |
|---|---|
| Тема | Re: ToDo: show size of partitioned table |
| Дата | |
| Msg-id | CAFj8pRBVCe-XFxH=Hthr13yjbo8WKuo6QMndQZDEHtBgx6KqQQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: ToDo: show size of partitioned table (Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>) |
| Ответы |
Re: ToDo: show size of partitioned table
|
| Список | pgsql-hackers |
2018-06-01 17:15 GMT+02:00 Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>:
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
В списке pgsql-hackers по дате отправления: