Make sure there are some queries been executed on the server from pg_stat_activity. Make sure your logging level for log files is such that it can log the queries in db server log file.
In addition to log_statement you can also set log_min_duration_statement to 0 and that will also log queries in your log file. -- Shoaib Mir EnterpriseDB (www.enterprisedb.co,) On 5/29/07, Diego Fernando Arce <[EMAIL PROTECTED]> wrote:
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.conffile? > > > > > > -- > > > 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 > > > > > > > > > > > > >
