Total number of milliseconds for "tika_1_6" by file extension
FILE_EXTENSION | ELAPSED_TIME_MILLIS_A | TOTAL_FILES | Average number of milliseconds per file |
pptx
| 44515
| 35
| 1271.86
|
pps
| 66612
| 160
| 416.32
|
ppt
| 4651122
| 11884
| 391.38
|
pdf
| 20128266
| 52020
| 386.93
|
zip
| 379
| 1
| 379.00
|
docx
| 5569
| 18
| 309.39
|
xlsx
| 551
| 2
| 275.50
|
java
| 11187
| 54
| 207.17
|
doc
| 3066366
| 16156
| 189.80
|
text
| 53258
| 321
| 165.91
|
xls
| 1188541
| 7868
| 151.06
|
rtf
| 15494
| 246
| 62.98
|
fits
| 4930
| 79
| 62.41
|
gz
| 91572
| 1567
| 58.44
|
log
| 46787
| 830
| 56.37
|
vrml
| 54
| 1
| 54.00
|
sgml
| 686
| 15
| 45.73
|
ps
| 101921
| 2396
| 42.54
|
html
| 2166631
| 52983
| 40.89
|
kmz
| 1889
| 47
| 40.19
|
swf
| 3066
| 78
| 39.31
|
fm
| 115
| 3
| 38.33
|
jpg
| 565815
| 14894
| 37.99
|
eps
| 5748
| 153
| 37.57
|
data
| 75
| 2
| 37.50
|
odp
| 37
| 1
| 37.00
|
unk
| 32244
| 879
| 36.68
|
f
| 9327
| 257
| 36.29
|
xml
| 66990
| 1862
| 35.98
|
txt
| 991400
| 27671
| 35.83
|
wp
| 3285
| 95
| 34.58
|
wk1
| 32
| 1
| 32.00
|
tmp
| 307
| 10
| 30.70
|
troff
| 1184
| 39
| 30.36
|
gif
| 115437
| 4103
| 28.13
|
csv
| 54019
| 1937
| 27.89
|
dwf
| 425
| 16
| 26.56
|
png
| 18781
| 728
| 25.80
|
bmp
| 408
| 16
| 25.50
|
sql
| 437
| 19
| 23.00
|
kml
| 898
| 42
| 21.38
|
ttf
| 20
| 1
| 20.00
|
tex
| 1957
| 98
| 19.97
|
dbase3
| 6782
| 372
| 18.23
|
hlp
| 385
| 24
| 16.04
|
pub
| 45
| 3
| 15.00
|
gls
| 101
| 10
| 10.10
|
py
| 9
| 1
| 9.00
|
g3
| 8
| 1
| 8.00
|
SELECT comparisons.FILE_EXTENSION, sum(ifnull(ELAPSED_TIME_MILLIS_A, 0)) as ELAPSED_TIME_MILLIS_A, extensions_total.NUM_FILES as TOTAL_FILES, printf("%.2f ", (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 (1.0*sum(ifnull(ELAPSED_TIME_MILLIS_A, 0))/extensions_total.NUM_FILES) desc;