From: | Jose Alberto Lopez <alberto(at)ecsagency(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Statics collector |
Date: | 2015-06-16 23:28:25 |
Message-ID: | CALwnVE5K7kJW5a2mqyvLmFBLzm703f52MutghvBA2GbsA4oZkA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi, I'm working in postgresSQL 9.3, I want to monitoring my server and I
try to use Statistics Collector, in the documentation said the parameters
that it need to configurate (only erease the #, isn't it?) and it see like:
# - 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
I want to see the information in pg_stat_tmp but it doesn't have anything.
What I need to configure? I hope you can help me..
From | Date | Subject | |
---|---|---|---|
Next Message | m8r-geob63 | 2015-06-17 00:06:50 | BUG #13447: Zombie postgres.exe processes |
Previous Message | Lacey Powers | 2015-06-16 22:12:36 | Re: [GENERAL] pg_xlog on a hot_standby slave filling up |