Search Postgresql Archives

Re: Postgres Traffic accounting

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@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



-- 
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux