How is this accomplished? Is it possible to log queries to a table with additional information?
1) num rows returned (if a select) 2) time to complete the query 3) other info? How is enabling this actually done? On 11/17/2011 9:32 AM, hubert depesz lubaczewski wrote:
On Thu, Nov 17, 2011 at 09:29:11AM -0700, J.V. wrote: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.just enable logging of queries. Best regards, depesz
-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
