|
On 1/29/2015 5:12 PM, Israel Brewster
wrote:
I'm working on setting up a new PostgreSQL database server, and
would like to be able to monitor a number of statistics on it,
such as:
number of connections
number of queries
query times
etc.
All these stats are easily available, either from the
pg_stat_statements view (which I have enabled) and the like, or
the log file (turn on log connects/disconnects), and I figured
there would be a plethora of options available for monitoring
these things. However, in searching around so far all I've found
are a couple of hosted solutions. Granted, they look fairly
nice, but we'd much prefer to keep this in-house. Paid
solutions are fine, as long as the cost is reasonable, but we do
want full-control. Before I spend my time writing my own
solution, is there anything out there that can make nice graphs
of various postgresql metrics? Thanks.
Take a look at PoWA:
http://dalibo.github.io/powa/
I've downloaded but haven't installed it yet, so can't give you any
feedback on its performance or usability.
--
Michael Heaney
JCVI
|
