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...
> There a way to watch queries execute on the pgsql
> server as queries come in from the network and are
> processed?
>
> Thanks
> MP
>
>
>
> __________________________________
> Yahoo! Mail - PC Magazine Editors' Choice 2005
> http://mail.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>