Statics collector

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..

Responses

Browse pgsql-bugs by date

  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