Import Statistics query

The Import Statistics query displays the number of files of each type and state and the average run times. This query does not represent end-to-end run times because the files are processed in parallel.

select filetype

, filestate

, to_char(creationtime, 'YYYYMMDD')

, count(*)

, avg(extract(minute from endtime - starttime) * 60 + extract(second from endtime - starttime)) avg_run_time

, avg((filesize / 32) / (extract(minute from endtime - starttime) * 60 + extract(second from endtime - starttime))) avg_recs_per_sec

, max((filesize / 32) / (extract(minute from endtime - starttime) * 60 + extract(second from endtime - starttime))) max_recs_per_sec

, min((filesize / 32) / (extract(minute from endtime - starttime) * 60 + extract(second from endtime - starttime))) min_recs_per_sec

, min(starttime)

, max(endtime)

, max(endtime) - min(starttime) as ElapsedTime from fileinventory

group by filetype, filestate, to_char(creationtime, 'YYYYMMDD') order by to_char(creationtime, 'YYYYMMDD'), filetype, filestate;

Related topics:

• FileInventory table

• Interpreting ARI file types and states

• Reads Processed query

• Failed Reads query

• Reading table