Re: monitoring sql queries

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
>

In response to

Responses

Browse pgsql-general by date

  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