Im also seeing a weird thing. If I do show stats_start_collector; inside psql, it says off.
Ive also restarted my server many times after making all the changes. As per 8.2 doc, http://www.postgresql.org/docs/8.2/interactive/runtime-config-statistics.htm l, stats_start_collector is on by default. -----Original Message----- From: Guillaume Lelarge [mailto:[email protected]] Sent: Wednesday, March 31, 2010 1:02 PM To: [email protected] Cc: [email protected] Subject: Re: [ADMIN] Statistics Collector not collecting server activities Le 31/03/2010 08:41, Gnanakumar a écrit : > Hi, > > > > Even though I've enabled statistics collector in our server, it is not > collecting statistics, and because of this autovacuum is also not running as > expected. > > > > PostgreSQL version 8.2 > > > > Parameters enabled related to this are: > > # - Query/Index Statistics Collector - > > > > #stats_command_string = on > > #update_process_title = on > > > > #stats_start_collector = on > > > > > #stats_block_level = off > > #stats_row_level = off > > stats_block_level = on > > stats_row_level = on > > #stats_reset_on_server_start = off > > > > # - Statistics Monitoring - > > > > #log_parser_stats = off > > #log_planner_stats = off > > #log_executor_stats = off > > #log_statement_stats = off > > > > I'm always getting zero value for all the tables. > > > > select pg_stat_get_tuples_inserted((select oid from pg_class where relname = > 'mytable')); > > select pg_stat_get_tuples_updated((select oid from pg_class where relname = > 'mytable')); > > select pg_stat_get_tuples_deleted((select oid from pg_class where relname = > 'mytable')); > > If the stats collector was disabled before, did you restart PostgreSQL? if you did restart, you should drop the # in front of "stats_start_collector = on" and restart once again PostgreSQL. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
