Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is there a way of logging of user queries in Postgresql than writing logs on the server side? A proxy or something like that.

Pgbouncer don't logging queries, tsung-recorder log them into xml without timestamps and user information.

share|improve this question
Have a look at the pg_stat_statements module: – a_horse_with_no_name Oct 4 '13 at 7:18
Do you mean an other way? If yes, why do you need it outside the server? – dezso Oct 4 '13 at 7:56
Because on the server side logs take up too much disk space (about 0.5 Gb per minute). – bhavenger Oct 7 '13 at 9:54
And I need logging only users from office for some security reasons, not apps from server. – bhavenger Oct 7 '13 at 9:56

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.