From: | Jose Alberto Lopez <alberto(at)ecsagency(dot)com> |
---|---|
To: | pgsql-es-ayuda(at)postgresql(dot)org |
Subject: | colector de estadisticas |
Date: | 2015-06-17 19:40:04 |
Message-ID: | CALwnVE5R11sR6ARHVV7=y2aoLjvJRDnTgPSgiNJjewUwP=ZkHw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
Hola,estoy trabajando con postgresql 9.3 y quiero monitorear mi servidor
usando el colector de estadisticas, en la doumentacion señala los
parametros que son necesarios configurar (borrando el caracter #) se ve
mas o menos asi:
# - Query/Index Statistics Collector -
track_activities = on
track_counts = on
track_io_timing = off
track_functions = all # none, pl, all
track_activity_query_size = 1024 # (change requires restart)
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
Cuando busco informacion en pg_stat_tmp esta vacio, no tiene
informacion alguna. Es necesario configurar algo mas?? espero puedan
ayudarme.
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2015-06-18 13:28:07 | Re: colector de estadisticas |
Previous Message | Alvaro Herrera | 2015-06-17 13:18:01 | Re: Query plan remoto postgresql-oracle |