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

Поиск
Список
Период
Сортировка
От Alan Hodgson
Тема Re: can I show number of records returned by a query in a log?
Дата
Msg-id 201111161719.31561.ahodgson@simkin.ca
обсуждение исходный текст
Ответ на can I show number of records returned by a query in a log?  (hyelluas <helen_yelluas@mcafee.com>)
Список 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.

В списке pgsql-general по дате отправления:

Предыдущее
От: hyelluas
Дата:
Сообщение: can I show number of records returned by a query in a log?
Следующее
От: "Tomas Vondra"
Дата:
Сообщение: Re: can I show number of records returned by a query in a log?