Re: Server statistics monitoring?

On Jan 29, 2015, at 1:20 PM, Michael Heaney <mheaney(at)jcvi(dot)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
>