- 论坛徽章:
- 3
|
osdba=# select schemaname,tablename,pg_relation_size(schemaname||'.'||tablename) as tabsize from pg_tables order by 3 desc;
schemaname | tablename | tabsize
--------------------+-------------------------+----------
public | blograwlog | 19243008
pg_catalog | pg_proc | 499712
pg_catalog | pg_depend | 409600
pg_catalog | pg_attribute | 352256
pg_catalog | pg_statistic | 221184
pg_catalog | pg_description | 172032
pg_catalog | pg_class | 122880
pg_catalog | pg_operator | 106496
public | blogstats | 81920
public | cnip | 73728
pg_catalog | pg_rewrite | 73728
pg_catalog | pg_type | 65536
information_schema | sql_features | 57344
pg_catalog | pg_index | 49152
public | gp_conf_icbu | 40960
public | gp_conf_ccbu | 40960
pg_catalog | pg_amop | 24576
pg_catalog | pg_conversion | 24576
public | gp_conf | 24576
pg_catalog | pg_ts_config_map | 16384
pg_catalog | pg_opclass | 16384
public | gp_conf_ccbu_20110930 | 16384
pg_catalog | pg_amproc | 16384
pg_catalog | pg_cast | 16384
pg_catalog | pg_ts_template | 8192
pg_catalog | pg_foreign_data_wrapper | 8192
pg_catalog | pg_namespace | 8192
information_schema | sql_implementation_info | 8192
information_schema | sql_languages | 8192
pg_catalog | pg_authid | 8192
information_schema | sql_packages | 8192
information_schema | sql_parts | 8192
pg_catalog | pg_database | 8192
information_schema | sql_sizing | 8192
pg_catalog | pg_enum | 8192
pg_catalog | pg_attrdef | 8192
pg_catalog | pg_constraint | 8192
pg_catalog | pg_inherits | 8192
pg_catalog | pg_opfamily | 8192
pg_catalog | pg_am | 8192
pg_catalog | pg_language | 8192
pg_catalog | pg_aggregate | 8192
pg_catalog | pg_trigger | 8192
pg_catalog | pg_tablespace | 8192
pg_catalog | pg_pltemplate | 8192
|
|