logging long running teiid queries

[ravikatkar]

Hi List,

How to log or pull the teiid queries   running for long time do we have any api to to pull ?.

Thanks,

Ravi katkar

[shawkins]

The command log will contain all user/source query activity, and you can glean running time from there.  For actively running queries you can use several of the admin/console apps to see if there are long running queries.  For example with the admin api you can issue getRequests.

There is a config parameter for query threshold in seconds that is used by our JON monitoring to display long running queries, but otherwise we don't have a notion of a long running query on the server.