Re: monitor stats - Mailing list pgsql-general

From Shoaib Mir
Subject Re: monitor stats
Date
Msg-id bf54be870705291626m3a241606v606129e508163ea8@mail.gmail.com
Whole thread Raw
In response to Re: monitor stats  ("Diego Fernando Arce" <diegof.hykova@gmail.com>)
Responses Re: monitor stats
List pgsql-general
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





pgsql-general by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: 8.3
Next
From: Tom Allison
Date:
Subject: prepare()