Total number of milliseconds for "pdfbox_1_8_9_20150316" by file extension
FILE_EXTENSION | Elapsed Time(Millis) B | NUM_FILES | Average Number of Milliseconds per File |
pdf
| 64068571
| 231229
| 277.1
|
SELECT comparisons.FILE_EXTENSION, sum(ifnull(ELAPSED_TIME_MILLIS_B, 0)) as "Elapsed Time(Millis) B", extensions_total.NUM_FILES as TOTAL_FILES, DEC_PATTERN((1.0*sum(ifnull(ELAPSED_TIME_MILLIS_B, 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_B is null and SORT_STACK_TRACE_B is null group by comparisons.FILE_EXTENSION order by "Average Number of Milliseconds per File" desc;