Question

Tool to automate Postgresql session monitoring?

  • 3 February 2022
  • 2 replies
  • 6 views
B

I have a question that is indirectly related to FME.

In short, we have a series of ETL scripts that process data that eventually gets used for FME transformations. These scripts populate a Postgresql database and are scheduled to run on a periodic basis.

Occasionally, a script will fail in its processing, leading to some database table to remain locked, for example. Currently we are using the pgadmin tool dashboard to manually detect such events and to resolve them.

I was wondering if you are aware of any tool that could be used to automate the monitoring of database sessions, like sending alerts if a query takes longer then "n minutes" to complete.

 

Thanks!

Bruno

2 replies

JennaKAtSafe
Rank
Badge +6

Hi @blisak, interesting use case here! Where are you looking to receive this monitoring data? Are you looking for a formatted log file or rather have a workflow pause if a query takes too long?

B

Hi Jenna,

For our needs, a tool that can simply send out a notification (email or other) when it detects a query that is running longer than some configured amount of time would be just the thing we need.

Thanks!

Reply


Community Stats

28,670
Posts
109,366
Replies
36,531
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.