Raise performance of K000 check
Description
As found during profiling the K000 check, code of generating separated files with query contributes to the main delay. In current PR
- 2 calls of jq with full json replaced by one
- calculation of query length and generating link moved to SQL code
- code for generating unused
readable_queryid
variable remove.
As a result, we can see a rise in performance of K000 group of reports to 4 times with processing 500 queries. For example before:
[2019-07-15T21:59:09+0300] === Run on 'db2': ./resources/checks/K000_query_analysis.sh ===
[2019-07-15T22:03:25+0300] === End of running ===
after:
[2019-07-15T22:04:01+0300] === Run on 'db2': ./resources/checks/K000_query_analysis.sh ===
[2019-07-15T22:04:57+0300] === End of running ===
Related issue
Closes #421 (closed)
Edited by Anna