Ci-dessous, les différences entre deux révisions de la page.
Dernière révision Les deux révisions suivantes | |||
support:trucs_et_astuces:trouver_facilement_la_taille_d_une_table_de_ses_index_et_son_nombre_de_tuples [2008/10/15 16:54] ioguix créée |
support:trucs_et_astuces:trouver_facilement_la_taille_d_une_table_de_ses_index_et_son_nombre_de_tuples [2010/04/28 10:50] jp |
||
---|---|---|---|
Ligne 40: | Ligne 40: | ||
Jean-Paul ARGUDO\\ | Jean-Paul ARGUDO\\ | ||
http:// | http:// | ||
+ | |||
+ | Merci pour cette vue.\\ | ||
+ | Apres migration en postgres 8.4 j'ai du la modifier pour qu' | ||
+ | En esperant que cela soit utile. | ||
+ | <code sql>drop view vue_stats; | ||
+ | |||
+ | create view vue_stats as | ||
+ | SELECT | ||
+ | c.relname as nom, | ||
+ | c.reltuples:: | ||
+ | pg_total_relation_size(CAST(c.relname AS TEXT)) as volume_total, | ||
+ | pg_relation_size(CAST(c.relname AS TEXT)) as volume_donnees, | ||
+ | pg_total_relation_size(CAST(c.relname AS TEXT))-pg_relation_size(CAST(c.relname AS TEXT)) as volume_index | ||
+ | FROM pg_catalog.pg_class c | ||
+ | JOIN pg_catalog.pg_roles r ON r.oid = c.relowner | ||
+ | LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace | ||
+ | WHERE c.relkind = ' | ||
+ | AND n.nspname NOT IN (' | ||
+ | AND pg_catalog.pg_table_is_visible(c.oid) | ||
+ | ORDER BY 1, | ||
+ | -- \\ | ||
+ | Jean-Philippe FARCY\\ | ||
+ | http:// |