Thread: Postgres Traffic accounting
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
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@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
On 05/12/2016 14:35, William Ivanski wrote:
I guess he'd have to use some tool like this :Does it need to be done by listening to network packets? You can get statistics by query and user with pgbadger.
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.
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
-- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt
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@unix-solution.de > <mailto:mailinglist@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 >
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@unix-solution.de>mailinglist@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 >
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@unix-solution.de>mailinglist@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 >