Long Running Query Monitoring

[moxious]

I would really love a config something like: dbms.log.long_running_query=true and dbms.log.long_running_query_threshold=X so that we don't have to jump through hoops trying to figure out what the query/queries are that cause huge GCs/OOMs - it's painful and time consuming for us and customers to get thread/heap dumps for this and it's usually the case that we get involved after the fact so it's not possible to get them and things like listQueries() / listTransations() can't help

basically log any query that has been running for some specified amount of time

(Ship)