proposal - psql - show longest tables
От | Pavel Stehule |
---|---|
Тема | proposal - psql - show longest tables |
Дата | |
Msg-id | CAFj8pRCOQK0Yh4_pk2of5gr8_tjkJSZXjevR-qJKagU83QA+=Q@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: proposal - psql - show longest tables
|
Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: