Entao, muito estranho mesmo, pq tem uma variavel no banco dizendo uma coisa
e no arquivo de configuracao dizendo outra:
track_counts = on (NA CONF)
track_counts = OFF ( NO BANCO)
banco=# SHOW track_counts;
track_counts
--------------
off
(1 row)
CONF --->
# RUNTIME STATISTICS
#------------------------------------------------------------------------------
# - Query/Index Statistics Collector -
track_activities = on
track_counts = on
#track_functions = none # none, pl, all
#track_activity_query_size = 1024
#update_process_title = on
#stats_temp_directory = 'pg_stat_tmp'
# - Statistics Monitoring -
#log_parser_stats = off
#log_planner_stats = off
#log_executor_stats = off
#log_statement_stats = off
BANCO ->
name | setting
---------------------------+-------------
log_executor_stats | off
log_parser_stats | off
log_planner_stats | off
log_statement_stats | off
stats_temp_directory | pg_stat_tmp
track_activities | on
track_activity_query_size | 1024
track_counts | off
track_functions | none
update_process_title | on
2012/9/27 Marcone <[email protected]>
> Em 27 de setembro de 2012 15:18, jorge sanfelice
> <[email protected]> escreveu:
> > Alguem teve algum problema parecido que o servidor parou de coletar
> > estatisticas, etc... ?
>
> Nunca vi isso!
>
> Qual o resultados dos seguintes comandos:
>
> no psql:
> select *
> from pg_settings
> where name in ('track_activities', 'track_activity_query_size',
> 'track_counts', 'track_functions',
> 'update_process_title', 'stats_temp_directory',
> 'log_statement_stats', 'log_parser_stats',
> 'log_planner_stats', 'log_executor_stats');
>
> no shell:
> $ grep -A 20 -i 'RUNTIME STATISTICS' postgresql.conf
>
> --
> Marcone Peres - DBA
> http://www.linkedin.com/in/marconeperes
> @marconeperes
> (61) 8146-0028
> _______________________________________________
> pgbr-geral mailing list
> [email protected]
> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
>
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
