solved. the problem is that miss the line ":: 1 localhost" in /etc/hosts
thanks
On 6/3/07, Diego Fernando Arce <[EMAIL PROTECTED]> wrote:
hello again
if, but, I need it is real time not in archives
lynx /usr/share/doc/postgresql-8.1.8/html/monitoring-stats.html
SELECT pg_stat_get_backend_pi
hello again
if, but, I need it is real time not in archives
lynx /usr/share/doc/postgresql-8.1.8/html/monitoring-stats.html
SELECT pg_stat_get_backend_pid(s.backendid) AS procpid,
pg_stat_get_backend_activity(s.backendid) AS current_query
FROM (SELECT pg_stat_get_backend_idset() AS bac
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
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
-+--
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 =
this is a part of postgrsql.conf
log_statement = 'all' # none, mod, ddl, all
#log_hostname = off
#---
# RUNTIME STATISTICS
#---
# -
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
