I am in need of a tool or method to see each/every SQL query that hits
the PostgreSQL database. By query I mean the query in SQL syntax with
all the parameters passed.
What I want to do is:
1) see the query
2) Determine how long the query takes to execute
3) Possibly log both of the above to a log file
Is there any tool internal to PostgreSQL that would allow me to do this?
I cannot monitor it from the code that is actually connecting & sending
the query.
any help or pointers would be greatly appreciated.
J.V.