Re: proposal - psql - show longest tables - Mailing list pgsql-hackers

From Tom Lane
Subject Re: proposal - psql - show longest tables
Date
Msg-id 29128.1374536220@sss.pgh.pa.us
Whole thread Raw
In response to Re: proposal - psql - show longest tables  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: proposal - psql - show longest tables
List pgsql-hackers
Jeff Janes <jeff.janes@gmail.com> writes:
> Is looking for the biggest tables a common enough thing that it should
> be available to everyone, without needing custom customization?

I don't really think so.  It's surely not much harder than
select relname, pg_relation_size(oid) from pg_class order by 2 desc;

Moreover, the people who need this likely don't need it as a psql
command, but rather as something available to monitoring tools.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: ALTER SYSTEM SET command to change postgresql.conf parameters (RE: Proposal for Allow postgresql.conf values to be changed via SQL [review])
Next
From: Andrew Dunstan
Date:
Subject: Re: proposal - psql - show longest tables