Re: Postgres Traffic accounting

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/2016, basti <mailinglist@unix-solution.de
> <mailto: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
>