Re: query execution

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(at)yahoo(dot)com> wrote in message
news:20051005074002(dot)27199(dot)qmail(at)web35203(dot)mail(dot)mud(dot)yahoo(dot)com(dot)(dot)(dot)
> 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
>