Re: can I show number of records returned by a query in a log?

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: can I show number of records returned by a query in a log?
Date: 2011-11-17 01:19:31
Message-ID: 201111161719.31561.ahodgson@simkin.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On November 16, 2011 05:07:05 PM hyelluas wrote:
> I see 900 queries sent by 1 client in 7 min with 1 click on the screen -
> does the log show the real thing?

The logs show the real thing. Gotta love ORMs.

>
>
> Is it possible to log the number of records returned by that query?

I doubt the record count or data volume is the problem. It's more likely the
latency cost of sending 900 queries one at a time and waiting for the replies
at VPN latencies.

I don't know how to log the result record count, though, maybe someone else
does.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tomas Vondra 2011-11-17 01:36:42 Re: can I show number of records returned by a query in a log?
Previous Message hyelluas 2011-11-17 01:07:05 can I show number of records returned by a query in a log?