Server statistics monitoring?

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

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

On 1/29/2015 2: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?

I would use Munin, along with the check_postgres.pl script from the
Bucardo project. check_postgres was developed for Nagios, but is quite
easy to use with Munin. you can monitor as many things as you like, the
script has some great options like pre table bloat.

--
john r pierce 37N 122W
somewhere on the middle of the left coast

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general