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

From: hyelluas <helen_yelluas(at)mcafee(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: can I show number of records returned by a query in a log?
Date: 2011-11-17 01:07:05
Message-ID: 1321492025536-4999630.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I'm trying to capture amount of data moving from client app to the server &
back.
The client is executable (c#) gue on windows, server is lunix centOS,
PostgreSQL 8.4.
We see serious performance difference between execution via LAN & VPN.

I enabled the logging and used pgFouine to analyzed the logs and it looks
very strange - 2000-3000 queries in 10 min.

In one case I see the client (user is the client dbuser) query "select *
from vw_abc" sent 10 times in 1 sec ( timestamp is the same), is it realy
10 times or it was logged 10 times ?

I see 900 queries sent by 1 client in 7 min with 1 click on the screen -
does the log show the real thing?

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

thank you.
Helen

--
View this message in context: http://postgresql.1045698.n5.nabble.com/can-I-show-number-of-records-returned-by-a-query-in-a-log-tp4999630p4999630.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alan Hodgson 2011-11-17 01:19:31 Re: can I show number of records returned by a query in a log?
Previous Message Jason Buberel 2011-11-17 00:24:25 Is it ever necessary to vacuum a table that only gets inserts/updates?