I recently had the need to identify long running communicatons/documents, i.e. the ones that take more than a few seconds between dropping the source data and the timestamp when the entire job was set to "finished". The goal is to identify bottlenecks and concurrency problems in a busy site.
In Supervisor I can list the trackers with their "creation time" and "last update time". But I cannot get a "duration" listed, other than to subtract the values manually and especially I cannot filter the list for "longer than 3 seconds" or whatever. And having a maximum of 100 in a non-exportable list is not really helpful.
I then tried to get the same information from querying the Exstream API (/v1/trackers) but again I cannot filter by duration or do any calculation in the "fields" enumeration. So again I am stuck with "get all and filter locally" which is quite a PITA, as the list is pretty BIG on this busy multi-server installation.
Did anybody have a similar task and was able to solve it reasonably without hacking the database?
