Re: monitoring options for postgresql under AWS/RDS?

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: "Mamet, Eric (GfK)" <Eric(dot)Mamet(at)gfk(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: monitoring options for postgresql under AWS/RDS?
Date: 2019-04-04 17:43:22
Message-ID: 20190404174322.GD17544@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Apr 04, 2019 at 04:28:04PM +0000, Mamet, Eric (GfK) wrote:
> I would like to monitor our postgresql instance under AWS-RDS to get some alert (or log) if any query runs over a certain amount of time, like 1.5 seconds.
...
> * log_statement but this time I don't see how I would filter on "slow" queries and it seems dumped into the RDS log... not very easy to use and maybe too heavy for a production system

You can set log_min_duration_statement='1500ms'

Justin

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Justin Pryzby 2019-04-04 17:46:30 Re: RAM usage of PostgreSql
Previous Message Mamet, Eric (GfK) 2019-04-04 16:28:04 monitoring options for postgresql under AWS/RDS?