Thread: Finding Queries that have been done on a DB
Hello all! This is my first post! I am interested in finding out what queries have been made against a particular database in postgres. The version of Postgres is 8.0 running on Mandrake 10. The queries are made by client computers over the network. What steps must I take to accomplish such a task? Is this even at all a feasible goal? Much Thanks!!!! -- View this message in context: http://www.nabble.com/Finding-Queries-that-have-been-done-on-a-DB-tf3523303.html#a9829374 Sent from the PostgreSQL - general mailing list archive at Nabble.com.
4wheels wrote: > Hello all! > This is my first post! I am interested in finding out what queries have > been made against a particular database in postgres. The version of Postgres > is 8.0 running on Mandrake 10. The queries are made by client computers > over the network. What steps must I take to accomplish such a task? Is > this even at all a feasible goal? Yep it is. http://www.postgresql.org/docs/current/static/runtime-config-logging.html If you set 'log_statement = all' in your postgresql.conf file and look at the other params you'll get what you need. That will log all statements to the db, not just to a particular database. Though you could use 'log_line_prefix' to put in the database name and then a grep of the log will get you what you want :) -- Postgresql & php tutorials http://www.designmagick.com/