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.
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? |