1 Reply Latest reply on Dec 29, 2014 10:54 AM by Steven Hawkins

    logging long running teiid queries

    ravi katkar Newbie

      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

        • 1. Re: logging long running teiid queries
          Steven Hawkins Master

          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.