Re: [PERFORM] [ADMIN] Monitoring tool for Postgres Database

On 05/25/2017 07:15 PM, Scott Mead wrote: Thanks ravi We use Zabbix. JD -- Command Prompt, Inc. http://the.postgres.company/ +1-503-667-4564 PostgreSQL Centered full stack support, consulting and development.

Re: [PERFORM] [ADMIN] Monitoring tool for Postgres Database

> We use Zabbix. There's a Zabbix template for PostgreSQL called "pg_monz". http://pg-monz.github.io/pg_monz/index-en.html Best regards, -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese:http://www.sraoss.co.jp -- Sent via pgsql-performance mailing

Re: [PERFORM] [ADMIN] Monitoring tool for Postgres Database

Hi Ravi, We use the nagios to monitor the Postgresql Database . Nagios provide the dedicated API for Postgresql and you can customize the same. Thanks. On May 26, 2017 1:19 AM, "Ravi Tammineni" wrote: > Hi, > > > > What is the best monitoring tool for

Re: [PERFORM] Monitoring tool for Postgres Database

We have been using Nagios to monitor the system level stats. The database level stats that we gather are custom scripts that we have nagios poll to get the database health. You could use pg badger to generate reports against your database logs as well. Pg_badger reports are your bffs for

[PERFORM] Client Server performance & UDS

Hi, This is a general question around this performance area rather than a specific performance problem.so I apologise now for a lack of a specific detail. We have an application that does many small actions on the DB - and it's a small DB (a 50/100 Mbytes)

Re: FW: Re: [PERFORM] Query is running very slow......

Am 26.05.2017 um 14:31 schrieb Dinesh Chandra 12108: Hi Thomas, Thanks for your reply. Yes, the query is absolutely same which I posted. Please suggest if something need to change in query. As Per your comment... The query you posted includes there two join conditions:

Re: FW: Re: [PERFORM] Query is running very slow......

Hi Thomas, Thanks for your reply. Yes, the query is absolutely same which I posted. Please suggest if something need to change in query. As Per your comment... The query you posted includes there two join conditions: evidence_to_do.project_id = tool_performance.project_id

Re: [PERFORM] Monitoring tool for Postgres Database

+1 for Datadog. It is highly configurable, but out of the box the postgres integration collects a good amount of useful stuff. Tech support is also good. http://docs.datadoghq.com/integrations/postgresql/ Grant Evans Enova Inc. gev...@enova.com On 5/26/17 5:19 AM, Rick Otten wrote: On

Re: [PERFORM] More cores or higer frequency ?

Are you already on SSDs? That will be the dominant factor I think. Then memory After that, more cores are good for parallelism (especially with 9.6, although that requires solid memory support). Faster cores will be better if you expect complex calculations in memory, i.e., some analytics

Re: [PERFORM] Monitoring tool for Postgres Database

We've found pghero to be a good first line of defence. It doesn't have alerting yet, but it's great for a quick high level healthcheck. Also +1 for Datadog. Extremely flexible and elegant UI + powerful alerting capabilities. On Fri, May 26, 2017 at 10:32 AM, Sunkara, Amrutha

Re: [PERFORM] Monitoring tool for Postgres Database

On Thu, May 25, 2017 at 3:48 PM, Ravi Tammineni < rtammin...@partner.aligntech.com> wrote: > Hi, > > > > What is the best monitoring tool for Postgres database? Something like > Oracle Enterprise Manager. > > > > Specifically I am interested in tools to help: > > > > Alert DBAs to problems with