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@xxxxxxxxxxxxxxxx > <mailto:mailinglist@xxxxxxxxxxxxxxxx>> 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@xxxxxxxxxxxxxx > <mailto:pgsql-general@xxxxxxxxxxxxxx>) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > > -- > > William Ivanski > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
