SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-09-2008, 02:55 PM
| ||||
| ||||
 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-Querie....html#a9829374 Sent from the PostgreSQL - general mailing list archive at Nabble.com. ---------------------------(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      |
|
04-09-2008, 02:56 PM
| ||||
| ||||
| Re: Finding Queries that have been done on a DB 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/curre...g-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/ ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster |
Linear Mode
