Re: [GENERAL] Postgres Traffic accounting

2016-12-05 Thread basti
I have try the network-analyzer-for-postgresql but I get no data. On 05.12.2016 14:12, Achilleas Mantzios wrote: > On 05/12/2016 14:35, William Ivanski wrote: >> >> Does it need to be done by listening to network packets? You can get >> statistics by query and user with pgbadger. >> > I guess he'

Re: [GENERAL] Postgres Traffic accounting

2016-12-05 Thread basti
I have try the network-analyzer-for-postgresql but I get no data. On 05.12.2016 14:12, Achilleas Mantzios wrote: > On 05/12/2016 14:35, William Ivanski wrote: >> >> Does it need to be done by listening to network packets? You can get >> statistics by query and user with pgbadger. >> > I guess he'd

Re: [GENERAL] Postgres Traffic accounting

2016-12-05 Thread basti
As I can see pgbadger is a log Analyzer. I need to know how many traffic (in kb or mb) does a query produce. On 05.12.2016 13:35, William Ivanski wrote: > Does it need to be done by listening to network packets? You can get > statistics by query and user with pgbadger. > > > Em 9h41 Seg, 05/12/

Re: [GENERAL] Postgres Traffic accounting

2016-12-05 Thread Achilleas Mantzios
On 05/12/2016 14:35, William Ivanski wrote: Does it need to be done by listening to network packets? You can get statistics by query and user with pgbadger. I guess he'd have to use some tool like this : https://www.vividcortex.com/resources/network-analyzer-for-postgresql https://www.vividco

Re: [GENERAL] Postgres Traffic accounting

2016-12-05 Thread William Ivanski
Does it need to be done by listening to network packets? You can get statistics by query and user with pgbadger. Em 9h41 Seg, 05/12/2016, basti escreveu: > Hallo, > > I have to try traffic accounting for postgres using tcpdump and nfdump. > I can see what traffic is produced but cant see the que

[GENERAL] Postgres Traffic accounting

2016-12-05 Thread basti
Hallo, I have to try traffic accounting for postgres using tcpdump and nfdump. I can see what traffic is produced but cant see the query / activity who do it. because there is an ssl connection. use plain text is not an option. I also try to use tcap-postgres. this does not compile on my server a