Re: monitoring sql queries

On Thu, Nov 17, 2011 at 4:32 PM, J.V. <jvsrvcs(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/**mailpref/pgsql-general<http://www.postgresql.org/mailpref/pgsql-general>
>