Re: monitor stats

["Diego Fernando Arce" <diegof(dot)hykova(at)gmail(dot)com>]

this is a part of postgrsql.conf

 

log_statement = 'all'                   # none, mod, ddl, all
#log_hostname = off

#---------------------------------------------------------------------------
# RUNTIME STATISTICS
#---------------------------------------------------------------------------

# - Statistics Monitoring -

#log_parser_stats = off
#log_planner_stats = off
#log_executor_stats = off
#log_statement_stats = off

# - Query/Index Statistics Collector -

stats_start_collector = on
stats_command_string = on
#stats_block_level = off
#stats_row_level = off
#stats_reset_on_server_start = off

 

 

in 8.1.6 and 8.1.4 it works

 

 

On 5/29/07, Shoaib Mir <shoaibmir(at)gmail(dot)com> wrote:

Did you try doing "log_statements = all" in your postgresql.conf file?

--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 5/29/07, Diego Fernando Arce <diegof(dot)hykova(at)gmail(dot)com > wrote:

hello, I have a question, does not work monitor stats in postgres 8.1.8

 

I cannot see querys in execution

 

help me please..........

 

DiegoF