Comments (13)

Created

Jul 24, 2012

How to find long running queries.

Posted by Henry Saginor

Inefficient JCR queries can often be the cause of poor performance. So how do you find queries that take too long to execute?

In CQ 5.5 you can login to Felix Console. Then go to JMX tab and click on QueryStat MBean.

In older versions of CQ you can enable additional logging as described in the Knowledge Base article How to debug JCR Queries.

Once you have query logging you can sort this log file using querylog.jar to find queries with longest execution time. Bellow is an examle of how to use this.

java -Xmx512m -jar querylog.jar query.log > query_sorted.log

COMMENTS

  • By e-papierosy - 12:23 PM on Mar 30, 2013   Reply
    n CQ 5.5 you can login to Felix Console. Then go to JMX tab and click on QueryStat MBean.

    In older versions of CQ you can enable additional logging as described in the Knowledge Base article How to debug JCR Queries.
  • By jual propolis murah - 12:00 PM on Apr 05, 2013   Reply
    informative post, its so useful, keep it up
  • By manfaat madu - 12:00 PM on Apr 05, 2013   Reply
    wow, i dont know that, this is a great share, thank you
  • By belly bands for dogs - 12:00 PM on Apr 05, 2013   Reply
    nice share, it open my mind even more now, thanks
  • By wooden dog crates - 12:01 PM on Apr 05, 2013   Reply
    i dont know at first that it will be a useful information, but really, thank you for posting it
  • By bee propolis hd - 12:02 PM on Apr 05, 2013   Reply
    This information really helped me understand Things beyond my expertise. websites like this expanding knowledge everyone and I hope something like this will continue to grow
  • By dien dan seo - 5:47 AM on Apr 15, 2013   Reply
    this is a great share, thank you
  • By hdi bee propolis - 9:25 AM on Apr 21, 2013   Reply
    awesome information man, thx
  • By kangaroo - 8:44 AM on Apr 25, 2013   Reply
    Wow..informative post, its so useful, keep it up
  • By manfaat madu asli - 10:21 AM on Apr 27, 2013   Reply
    what a great post, thx for the share
  • By nj photo booth - 5:01 PM on Apr 27, 2013   Reply
    Thanks for keeping us informed
  • By best wedding photographer nj - 9:43 PM on Apr 27, 2013   Reply
    Its great to see you taking the time to share this information