On Thu, Nov 17, 2011 at 02:32:22PM -0700, J.V. wrote:
> 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?
please chec
On 17 Listopad 2011, 22:34, J.V. wrote:
> What is a GUC and how do I use it?
It just means there's a config option log_min_duration_statement that you
can set in postgresql.conf. Set it e.g. to 100, reload the configuration
(e.g. by restarting the server or sending HUP signal to the process) and
a
On Thu, Nov 17, 2011 at 4:32 PM, J.V. 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 th
On Thu, 17 Nov 2011 14:32:22 -0700
"J.V." wrote:
> How is this accomplished?
The best way that I know if is to use pgFouine.
The documentation for pgFouine should get you started.
HTH,
Bill
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscri
What is a GUC and how do I use it?
On 11/17/2011 9:46 AM, Tomas Vondra wrote:
On 17 Listopad 2011, 17:32, 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 q
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 0
On Thu, Nov 17, 2011 at 11:46 AM, Tomas Vondra wrote:
> On 17 Listopad 2011, 17:32, 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
On 17 Listopad 2011, 17:32, 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.
>>
>
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 h
