| From: | Gilles Darold <gilles(dot)darold(at)dalibo(dot)com> |
|---|---|
| To: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Subject: | [patch] Add schema total size to psql \dn+ |
| Date: | 2019-02-20 22:26:00 |
| Message-ID: | 2d6d2ebf-4dbc-4f74-17d8-05461f4782e2@dalibo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi all,
When we want to get total size of all relation in a schema we have to
execute one of our favorite DBA query. It is quite simple but what
about displaying schema size when using \dn+ in psql ?
gilles=# \dn+
List of schemas
Name | Owner | Access privileges | Size | Description
--------+----------+----------------------+---------+------------------------
public | postgres | postgres=UC/postgres+| 608 kB | standard public schema
| | =UC/postgres | |
test | gilles | | 57 MB |
empty | gilles | | 0 bytes |
(3 rows)
The attached simple patch adds this feature. Is there any cons adding
this information? The patch tries to be compatible to all PostgreSQL
version. Let me know if I have missed something.
Best regards,
--
Gilles Darold
Consultant PostgreSQL
http://dalibo.com - http://dalibo.org
| Attachment | Content-Type | Size |
|---|---|---|
| psql-schema-size.diff | text/x-patch | 768 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2019-02-20 22:46:50 | Re: Pluggable Storage - Andres's take |
| Previous Message | David Rowley | 2019-02-20 21:56:17 | Re: Delay locking partitions during INSERT and UPDATE |