On 05/12/2016 14: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.
I guess he'd have to use some tool like this : https://www.vividcortex.com/resources/network-analyzer-for-postgresql https://www.vividcortex.com/blog/2015/05/13/announcing-vividcortex-network-analyzer-mysql-postgresql/ This works by listening to the network and then correlate network activity with PIDs and then somehow via (pg_stat_* or ps) with queries.
Em 9h41 Seg, 05/12/2016, basti <mailingl...@unix-solution.de <mailto: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 <mailto:pgsql-general@postgresql.org>) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- William Ivanski
-- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt
