Total number of milliseconds for "PDFBox_1_8_9_20150316_single_thread" by file extension
FILE_EXTENSION | Elapsed Milliseconds A | NUM_FILES | Average Number of Milliseconds per File |
pdf
| 45943061
| 231229
| 198.7
|
SELECT comparisons.FILE_EXTENSION, sum(ifnull(ELAPSED_TIME_MILLIS_A, 0)) as "Elapsed Milliseconds A", extensions_total.NUM_FILES as "Total Number of Files", DEC_PATTERN((1.0*sum(ifnull(ELAPSED_TIME_MILLIS_A, 0))/extensions_total.NUM_FILES), '###,###.#') as "Average Number of Milliseconds per File" from comparisons left outer join extensions_total on comparisons.FILE_EXTENSION=extensions_total.FILE_EXTENSION where JSON_EX_A is null and SORT_STACK_TRACE_A is null group by comparisons.FILE_EXTENSION order by "Average Number of Milliseconds per File" desc;