On Wed, 2003-08-20 at 12:14, Ramil Sagum wrote: > anyway, does anyone know of a way to get the queries currently being passed > onto postgres other than > > select * from pg_stat_activity; > > ? It's good, but i need something that updates in real time. (like a file > being "tail -f"-ed)
Make it log queries in /var/log/messages or syslog. :) Cheers, -- .''`. Jan Alonzo jmalonzo at spaceants dot org : :' : PGP fp: DB23 8CB2 E050 7737 B3C4 BB2C 5368 864B C70C 894A `. `' ID: C70C894A `- -- Philippine Linux Users' Group (PLUG) Mailing List [EMAIL PROTECTED] (#PLUG @ irc.free.net.ph) Official Website: http://plug.linux.org.ph Searchable Archives: http://marc.free.net.ph . To leave, go to http://lists.q-linux.com/mailman/listinfo/plug . Are you a Linux newbie? To join the newbie list, go to http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie
