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