Thread: Traffic monitor postgres

Hello,

i have a problem with my postgres server. There is a DB with approx 30
GB. the traffic per day is between 20-50 GB on the outgoing interface.

one client has ~ 20 IDLE connections. i have sniffer this connections
with nfdump and get this traffic

2016-11-29 12:05:56.165  5854.304 TCP      xxx.xxx.xx.25:5432  ->
xxx.xxx.xx.178:35902    16398   74.8 M    20
2016-11-29 12:06:08.450  5826.815 TCP      xxx.xxx.xx.25:5432  ->
xxx.xxx.xx.178:56307    15414   68.5 M    20
2016-11-29 12:06:14.771  5630.078 TCP      xxx.xxx.xx.25:5432  ->
xxx.xxx.xx.178:40468    13967   61.6 M    21
2016-11-29 12:11:04.971  5528.725 TCP      xxx.xxx.xx.25:5432  ->
xxx.xxx.xx.178:56269    13767   59.9 M    19
2016-11-29 12:07:07.203  5791.580 TCP      xxx.xxx.xx.25:5432  ->
xxx.xxx.xx.178:46606    14728   59.4 M    22
2016-11-29 12:11:03.595  5497.724 TCP      xxx.xxx.xx.25:5432  ->
xxx.xxx.xx.178:40463    12551   54.3 M    20
2016-11-29 12:05:26.932  5651.347 TCP      xxx.xxx.xx.25:5432  ->
xxx.xxx.xx.178:48122    13068   52.5 M    22
2016-11-29 12:08:39.283  5611.296 TCP      xxx.xxx.xx.25:5432  ->
xxx.xxx.xx.178:40470    12811   52.0 M    19
2016-11-29 12:10:09.644  5560.621 TCP      xxx.xxx.xx.25:5432  ->
xxx.xxx.xx.178:59706    12782   48.3 M    20
2016-11-29 12:09:57.819  5569.701 TCP      xxx.xxx.xx.25:5432  ->
xxx.xxx.xx.178:59710    12670   47.9 M    21
2016-11-29 12:11:04.933  5433.838 TCP      xxx.xxx.xx.25:5432  ->
xxx.xxx.xx.178:56308    12801   47.7 M    20
2016-11-29 12:06:01.908  5799.515 TCP      xxx.xxx.xx.25:5432  ->
xxx.xxx.xx.178:40467    11833   46.8 M    25
2016-11-29 12:11:02.652  5334.349 TCP      xxx.xxx.xx.25:5432  ->
xxx.xxx.xx.178:59635    10878   43.5 M    20
2016-11-29 12:08:12.557  5772.403 TCP      xxx.xxx.xx.25:5432  ->
xxx.xxx.xx.178:40477    10626   40.6 M    22
2016-11-29 12:10:40.379  5566.667 TCP      xxx.xxx.xx.25:5432  ->
xxx.xxx.xx.178:59646    10347   40.2 M    21
2016-11-29 12:06:48.133  5852.796 TCP      xxx.xxx.xx.25:5432  ->
xxx.xxx.xx.178:59645    10328   30.9 M    21

My question is. what does send so much traffic on an idle connection
within an hour?

Is there a way to to monitor the traffic in postgres? or to see what is
done on the idle connection?

The other problem is that i see nothing in the pgAdmin Server-Status
(see attachment)

Server is 9.1
pgadmin is 1.22.1

best regards

On 30/11/2016 13:05, basti wrote:
> My question is. what does send so much traffic on an idle connection
> within an hour?
>

Presumably they are only idle at the point you are viewing the
connections. In my typical usage, the connections are in a connection
pool and are mostly idle. Monitored over a period of time however, the
traffic would be significant.