Did you do a reload or restart of the server after doing this change?

what do you see when you do this query? --> show log_statement

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

On 5/29/07, Diego Fernando Arce <[EMAIL PROTECTED]> wrote:

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

Reply via email to