Hi Theo,
yes you can log every SQL statement.
Just edit the postgresql.conf and delete the remark (#) from the following line:
#log_statement = false
Then restart postgres.
After this you can find every statement in the postgresql.log. On Gentoo you can
find this log in /var/lib/postgresql/data.
Title: Postgres SQL Monitor tool
Is there a log file, or a method of logging all the SQL statements a postgres server processes. I can look at pg_stat_activity which tells me each postgres process and the current query running, however I wanted to see a log file, similar to SQL Servers Profile
