Re: Postgres Traffic accounting

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 <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)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--

William Ivanski