Traffic monitor postgres

From: basti <mailinglist(at)unix-solution(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Traffic monitor postgres
Date: 2016-11-30 13:05:36
Message-ID: 5526be9f-b42b-564c-30d0-f1abef2c5e06@unix-solution.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Attachment Content-Type Size
image/png 29.5 KB

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Howard News 2016-11-30 13:11:58 Re: Verify Option with pg_dump
Previous Message Cachique 2016-11-30 13:04:09 Re: Monitoring Replication - Postgres 9.2