On Thu, Nov 17, 2011 at 4:32 PM, J.V. <jvsr...@gmail.com> 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 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<http://www.postgresql.org/mailpref/pgsql-general> >
