monitoring options for postgresql under AWS/RDS?

From: "Mamet, Eric (GfK)" <Eric(dot)Mamet(at)gfk(dot)com>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: monitoring options for postgresql under AWS/RDS?
Date: 2019-04-04 16:28:04
Message-ID: e99f3db07f4541aea078f05e9a2656dd@DCEW-EXPCM72.gfk.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi there,

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.
I would like to know which query took over that time (and how long), when and which parameters it used.
The exact parameters are important because the amount of data retrieved varies a lot depending on parameters.
I would like to know when it happened to be able to correlate it with the overall system activity.

I came across

* pg_stat_statements is very useful BUT it gives me stats rather than specific executions.
In particular, I don't know the exact time it happened and the parameters used

* 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

* pg_hero is great but looks like an interactive tool (unless I missed something) and I don't think it gives me the exact parameters and time (not sure...)

Is there a tool I could use to achieve that?

Thanks

Eric

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Justin Pryzby 2019-04-04 17:43:22 Re: monitoring options for postgresql under AWS/RDS?
Previous Message Jeff Janes 2019-04-04 15:14:07 Re: Commit(?) overhead