Olá, 2009/11/27 mateusgra <[email protected]>
> > Ola a todos, > > Temos hj as colunas n_tup_ins , n_tup_upd , n_tup_del e para "select", tem > como saber qtos selects são executados por dia no postgres mas sem > habilitar > o log_min_duration_statement e logar todos os comandos. > SELECT sum(seq_scan+idx_scan) AS total_de_leituras FROM pg_stat_user_tables WHERE relname='nome_da_tabela'; > -- > View this message in context: > http://old.nabble.com/Estatisticas-Select-tp26543085p26543085.html > Sent from the PostgreSQL - Brasil mailing list archive at Nabble.com. > > _______________________________________________ > pgbr-geral mailing list > [email protected] > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > []s -- JotaComm http://jotacomm.wordpress.com
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
