From: | Gilles Darold <gilles(dot)darold(at)dalibo(dot)com> |
---|---|
To: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
Subject: | Re: [patch] Add schema total size to psql \dn+ |
Date: | 2019-02-21 10:49:29 |
Message-ID: | 0fd222d4-605d-03f2-0a37-385988fb815f@dalibo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Le 20/02/2019 à 23:26, Gilles Darold a écrit :
> 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.
Improve this patch by using LATERAL JOIN when version >= 9.3.
--
Gilles Darold
Consultant PostgreSQL
http://dalibo.com - http://dalibo.org
Attachment | Content-Type | Size |
---|---|---|
psql-schema-size-v2.diff | text/x-patch | 1.6 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Frost | 2019-02-21 10:50:25 | Re: WAL insert delay settings |
Previous Message | Christoph Berg | 2019-02-21 09:37:02 | Re: Reporting script runtimes in pg_regress |