sysadmin:postgresql
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | Next revisionBoth sides next revision | ||
| sysadmin:postgresql [2014/11/25 08:48] – wiki syntax feroda | sysadmin:postgresql [2014/11/25 09:38] – [Occupazione disco per tabelle] - tolto LIMIT 20 feroda | ||
|---|---|---|---|
| Line 96: | Line 96: | ||
| FROM information_schema.tables | FROM information_schema.tables | ||
| WHERE table_schema NOT IN (' | WHERE table_schema NOT IN (' | ||
| - | ORDER BY size DESC, total_size DESC LIMIT 20 | + | ORDER BY size DESC, total_size DESC |
| ) AS basic_infos | ) AS basic_infos | ||
| JOIN pg_class | JOIN pg_class | ||