Re: Postgres Traffic accounting - Mailing list pgsql-general

From basti
Subject Re: Postgres Traffic accounting
Date
Msg-id bca1d0ff-9020-9dfb-630e-8f0b7a0269e8@unix-solution.de
Whole thread Raw
In response to Re: Postgres Traffic accounting  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
List pgsql-general
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 have to use some tool like this :
> https://www.vividcortex.com/resources/network-analyzer-for-postgresql
> https://www.vividcortex.com/blog/2015/05/13/announcing-vividcortex-network-analyzer-mysql-postgresql/
>
> This works by listening to the network and then correlate network
> activity with PIDs and then somehow via (pg_stat_* or ps) with queries.
>
>>
>> Em 9h41 Seg, 05/12/2016, basti
>> <<mailto:mailinglist@unix-solution.de>mailinglist@unix-solution.de>
>> 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 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 and
>>     its very old (year 2004).
>>
>>     Is there a way to see traffic network of postgres sort by query?
>>
>>     best regards
>>     basti
>>
>>
>>     --
>>     Sent via pgsql-general mailing list (pgsql-general@postgresql.org
>>     <mailto:pgsql-general@postgresql.org>)
>>     To make changes to your subscription:
>>     http://www.postgresql.org/mailpref/pgsql-general
>>
>> --
>>
>> William Ivanski
>>
>
>
> --
> Achilleas Mantzios
> IT DEV Lead
> IT DEPT
> Dynacom Tankers Mgmt
>


pgsql-general by date:

Previous
From: Martin Collins
Date:
Subject: Re: Postgres and LibreOffice's 'Base'
Next
From: Rich Shepard
Date:
Subject: Re: Postgres and LibreOffice's 'Base'