Re: Postgres Traffic accounting

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 <mailinglist(at)unix-solution(dot)de <mailto: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