query execution

Matthew Peter wrote:

There a way to watch queries execute on the pgsql
server as queries come in from the network and are
processed?

You could try "SELECT * FROM pg_stat_activity", though it's not
guaranteed to be complete. Look in the manuals for the chapter
"Monitoring Database Activity".

--
Richard Huxton
Archonet Ltd

in your postgresql.conf file near the bottom you need to enable statement
logging -- set log_statement = 'all'
and then you can

tail -f /var/logs/postgresql/postgresql.log

or tail -f wherever your postgres log is...

from the 'Nix command line

"Matthew Peter" <survivedsushi@yahoo.com> wrote in message
news:20051005074002.27199.qmail@web35203.mail.mud.yahoo.com...