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 < diegof.hykova@gmail.com> 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 <shoaibmir@gmail.com > 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 <diegof.hykova@gmail.com > 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 <shoaibmir@gmail.com > 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 <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