Pessoal, Fiz essa query pra retornar alguns valores de linhas na tabela pra análise de performance.
select quote_ident(schemaname)||'.'||quote_ident(relname) "Tabela", cast(n_dead_tup+n_live_tup as decimal(10,0)) "Total", pg_size_pretty(pg_relation_size(schemaname||'.'||relname)) "Tamanho", pg_size_pretty(pg_relation_size(schemaname||'.'||relname)/(n_dead_tup+n_live_tup)) "Tamanho_linha" , cast(8192.0/(pg_relation_size(schemaname||'.'||relname)/(n_dead_tup+n_live_tup)) as decimal(10,2)) "Linhas_por_pagina" FROM pg_stat_user_tables WHERE (n_dead_tup+n_live_tup)>0 and pg_relation_size(schemaname||'.'||relname)/(n_dead_tup+n_live_tup)>0 Vocês teriam alguma sugestão ou esses retornos aproximado está bom? Luiz carlos
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
