Re: [GENERAL] Traffic monitor postgres

2016-11-30 Thread Howard News
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 ove

[GENERAL] Traffic monitor postgres

2016-11-30 Thread basti
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 x