Re: monitor stats

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