From: | basti <mailinglist(at)unix-solution(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Postgres Traffic accounting |
Date: | 2016-12-05 13:16:40 |
Message-ID: | 99b4c390-b94c-3d90-5650-cc1c73ddfa67@unix-solution.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Rich Shepard | 2016-12-05 13:42:27 | Re: Postgres and LibreOffice's 'Base' |
Previous Message | Achilleas Mantzios | 2016-12-05 13:12:43 | Re: Postgres Traffic accounting |