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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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:
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 <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
--
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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general