I have try the network-analyzer-for-postgresql but I get no data. On 05.12.2016 14:12, Achilleas Mantzios wrote: > 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 >> <<mailto:mailinglist@xxxxxxxxxxxxxxxx>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 >> > > > -- > Achilleas Mantzios > IT DEV Lead > IT DEPT > Dynacom Tankers Mgmt > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general