How do I turn on query logger?

Started by Jennifer Treyabout 17 years ago3 messagesgeneral
Jump to latest
#1Jennifer Trey
jennifer.trey@gmail.com

I am new to postgreSQL and I am running queries from JAVA and would like to
see what queries are being run.

How can I achieve that ? I am running PostgreSQL 8.3 on Windows and like
using pgAdmin to do most things.

Jennifer Trey

#2Justin
justin@emproshunts.com
In reply to: Jennifer Trey (#1)
Re: How do I turn on query logger?

Jennifer Trey wrote:

I am new to postgreSQL and I am running queries from JAVA and would
like to see what queries are being run.

How can I achieve that ? I am running PostgreSQL 8.3 on Windows and
like using pgAdmin to do most things.

Open PG admin from the menu bar Tools->Server Status-> Status Tab will
have current running queries and active users

#3Fernando Moreno
azazel.7@gmail.com
In reply to: Jennifer Trey (#1)
Re: How do I turn on query logger?

Check out the "log_statement" option in the postgresql.conf file
(there's an entire section (18.7) in the docs about logging).