| From: | Bernd Helmle <mailings(at)oopsware(dot)de> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | psql \dt and table size |
| Date: | 2011-03-21 17:44:51 |
| Message-ID: | 11AFCA7F6987BE68E91C000D@[172.26.14.62] |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
It stroke me today again, that \dt+ isn't displaying the acurate table size
for tables, since it uses pg_relation_size() till now. With having
pg_table_size() since PostgreSQL 9.0 available, i believe it would be more
useful to have the total acquired storage displayed, including implicit
objects (the mentioned case where it was not very useful atm was a table
with a big TOAST table).
Attached minor patch extends \dt to use pg_table_size() starting with
PostgreSQL 9.0, not sure if we backport such changes though. It would be
interesting for 9.1, however.
--
Thanks
Bernd
| Attachment | Content-Type | Size |
|---|---|---|
| psql_tablesize.patch | application/octet-stream | 1.5 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim Nasby | 2011-03-21 18:08:04 | Re: really lazy vacuums? |
| Previous Message | Tom Lane | 2011-03-21 17:40:41 | Re: Planner regression in 9.1: min(x) cannot use partial index with NOT NULL |