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 = onstats_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@gmail.com > wrote:Did you try doing "log_statements = all" in your postgresql.conf file? -- Shoaib MirEnterpriseDB (www.enterprisedb.com)On 5/29/07, Diego Fernando Arce <diegof.hykova@gmail.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
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 = onstats_command_string = on#stats_block_level = off#stats_row_level = off#stats_reset_on_server_start = off
Did you try doing "log_statements = all" in your postgresql.conf file? -- Shoaib MirEnterpriseDB (www.enterprisedb.com)On 5/29/07, Diego Fernando Arce <diegof.hykova@gmail.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
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
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных