[patch] Add schema total size to psql \dn+

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-hackers by date

  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