Re: monitoring options for postgresql under AWS/RDS?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux