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