Postgres Pro
Downloads
Home   >   mailing lists

Re: monitoring options for postgresql under AWS/RDS? - Mailing list pgsql-performance

From Justin Pryzby
Subject Re: monitoring options for postgresql under AWS/RDS?
Date
Msg-id 20190404174322.GD17544@telsasoft.com
Whole thread Raw
In response to monitoring options for postgresql under AWS/RDS?  ("Mamet, Eric (GfK)" <Eric.Mamet@gfk.com>)
List pgsql-performance
Tree view 
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
certainamount 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
RDSlog... not very easy to use and maybe too heavy for a production system
 

You can set log_min_duration_statement='1500ms'

Justin

pgsql-performance by date:

Previous
From: "Mamet, Eric (GfK)"
Date:
Subject: monitoring options for postgresql under AWS/RDS?
Next
From: Justin Pryzby
Date:
Subject: Re: RAM usage of PostgreSql