From: | basti <mailinglist(at)unix-solution(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Postgres Traffic accounting |
Date: | 2016-12-05 15:55:53 |
Message-ID: | a7292cf2-04d0-b2d1-8c08-5b0b4f4825f5@unix-solution.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)unix-solution(dot)de>mailinglist(at)unix-solution(dot)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(at)postgresql(dot)org
>> <mailto:pgsql-general(at)postgresql(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Devin Smith | 2016-12-05 16:59:52 | Re: Bad query? Or planner? |
Previous Message | Tom DalPozzo | 2016-12-05 15:52:25 | Re: INSERT - UPDATE throughput oscillating and SSD activity after stopping the client |