On Sun, Jul 21, 2013 at 12:47 AM, Pavel Stehule <pavel.steh...@gmail.com> wrote: > Hello all > > I very often use a little bit adjusted psql system queries to > detection TOP N sized tables. I am thinking so it can be useful for > all users > > I propose a few new commands > > \dts [N|size] ... show N largest tables | show tables larger than size > ordered by size > \dis [N|size] ... show N largest indexes | show indexes larger than > size ordered by size > \dtst [N|size] ... show N largest total size | show tables where total > size is larger than size ordered by total size > \dtr [N] ... show N largest tables (ordered by rows) > > example: > > \dts 10 --- top 10 tables ordered by size > \dts 10MB -- tables larger than 10MB ordered by size > > Schema | Name | Type | Owner | Size > --------+-------------+-------+-------------+-------+------------- > public | eshop_users | table | eshop_owner | 16 kB > public | zamestnanci | table | eshop_owner | 16 kB > > What do you think about this proposal? Comments, notes?
I think our \d commands are in inscrutable morass of indecipherable gobbledygook as it is, and this is only one more step down the road to complete insanity. :-( Rather than just continuing to add more imposible-to-remember syntax, we really need a better design here. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
