| | 65 | You can see the names and sizes of all precomputed tables by running this SQL query in psql: |
|---|
| | 66 | {{{ |
|---|
| | 67 | SELECT relname,category,pg_size_pretty(pg_relation_size(oid)) FROM pg_class, precompute_index WHERE relname NOT LIKE 'pg_%' and relname = name ORDER BY pg_relation_size(oid) DESC; |
|---|
| | 68 | }}} |
|---|
| | 69 | Note that this only lists the table sizes, there may be many indexes associated with each table which may also be large. To see the size of all tables and indexes in the database use: |
|---|
| | 70 | {{{ |
|---|
| | 71 | SELECT relname,pg_size_pretty(pg_relation_size(oid)) FROM pg_class WHERE relname NOT LIKE 'pg_%' ORDER BY pg_relation_size(oid) DESC; |
|---|
| | 72 | }}} |
|---|
| | 73 | |
|---|
