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