I wanted to know if it's possible to log SQL statements executed in Pega (for a particular rule) which includes the execution time as well. Please note that I am not looking for DB trace because I don't want it for debugging but for logging actual db query execution time for an actual functionality in production.
I am also not looking for generating alerts or checking AES/PDC.
Is it possible to add some logger to log sql statements? or in some other way?
That's how we've been doing so far. But there is an ask to have a mechanism to have some sort of reporting/logging that provides the execution time of sql calls during a particular round trip (e.g. during NBA calls in CDH).