From: | "J(dot)V(dot)" <jvsrvcs(at)gmail(dot)com> |
---|---|
To: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: monitoring sql queries |
Date: | 2011-11-17 21:32:22 |
Message-ID: | 4EC57D66.6060101@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | J.V. | 2011-11-17 21:34:10 | Re: monitoring sql queries |
Previous Message | Joseph Shraibman | 2011-11-17 20:52:53 | Re: Performance degradation 8.4 -> 9.1 |