On Thu, Nov 17, 2011 at 4:32 PM, J.V. <jvsrvcs@xxxxxxxxx> wrote:
How is this accomplished?
Is it possible to log queries to a table with additional information?
1) num rows returned (if a select)
This isn't logged
2) time to complete the query
This is logged
3) other info?
Take a look at the log_line_prefix parameter
How is enabling this actually done?
You enable this by using a GUC (global unified config) variable in the postgresql.conf file called log_min_duration_statement.
--Scott
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 thatjust enable logging of queries.
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.
Best regards,
depesz
--Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
