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
kBpublic| zamestnanci | table | eshop_owner | 16 kB
What do you think about this proposal? Comments, notes?
Regards
Pavel Stehule