On Jan 29, 2015, at 1:20 PM, Michael Heaney <mhea...@jcvi.org> wrote:
> 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. Thanks. I'll give it a shot. ----------------------------------------------- Israel Brewster Systems Analyst II Ravn Alaska 5245 Airport Industrial Rd Fairbanks, AK 99709 (907) 450-7293 ----------------------------------------------- > > -- > Michael Heaney > JCVI >
