show log_statement; log_statement --------------- all (1 fila)
select pg_stat_get_backend_pid(s.backendid),pg_stat_get_backend_activity( s.backendid) from (select pg_stat_get_backend_idset() as backendid)s; pg_stat_get_backend_pid | pg_stat_get_backend_activity -------------------------+------------------------------ (0 filas) executing in another terminal other query On 5/30/07, Shoaib Mir <[EMAIL PROTECTED]> wrote:
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 > > > > > > > >
