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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 >
