Postgresql packages that are required for postgresql maintanance/monitoring: [[https://pg_top.gitlab.io/|PGTop]] \\ [[http://archives.postgresql.org/pgsql-hackers/2009-03/msg00489.php|Profiler]] \\ [[http://sources.redhat.com/git/gitweb.cgi?p=systemtap.git;a=shortlog|Systemtap]] maybe this instead of Profiler (DTrace alike) \\ [[http://pgfouine.projects.postgresql.org/|PGFouine]] PostgreSQL logs analyzer \\ [[https://reorg.github.io/pg_repack/|PG_Repack]] no clusterdb please!!! \\ [[http://collectd.org/|Collectd]] we also need to write //__NICE__// queries for the PostgreSQL plugin \\ [[http://www.postgresql.org/docs/current/static/pgbuffercache.html|PG_Buffercache]] included in 8.3.x contrib module in previous versions \\ [[http://pgspy.projects.postgresql.org|PGSpy]] libpcap based querry spying :-D \\ [[http://pgstatspack.projects.postgresql.org/|PGStatsPack]] this is a question mark... \\ [[http://veil.projects.postgresql.org/curdocs/index.html|Veil]] we might be interested in this for protecting privacy in shared hosting....