A Slow Query log script for Tomcat Access logs
Run this at midnight and you will have all the slow queries in the slow_query.log file
LOGFILE="slow_query.$NOW.log" ## 800 msec is a maximum value for solr. Let's filter everything above that
This snippet will output your queries that have QTime's above 800msec. Do have you better snippets? Please post them in the comments