Hi, At 19:55 20/06/2005, Dan Harris wrote:
Also, I'm sure some people will respond with "turn on query logging".. I've explored that option and the formatting of the log file and the fact that EVERY query is logged is not what I'm after for this project.
You can log just those queries that take "a little bit too much time". See log_min_duration_statement in postgresql.conf. Set it really high, and you'll only get those queries you're after.
Jacques. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
