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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
