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