Reads Processed query

The Reads Process query displays the numbers related to fileinventory and fileinventorysegment files, the number of imported reads, and how many are ready to be imported.

select 'fileinventory' || filetype, count(*) from fileinventory group by filetype

union

select 'fileinventorysegment', count(*) from fileinventorysegment union

select 'numimportedreads', sum(numvread + numeread + numnread) from fileinventorysegment fis

join fileinventory fi on (fis.fileid = fi.fileid) where fi.filetype = 2

and endtime is not null and filestate = 1  union

select 'numreadyreads', sum(numvread + numeread + numnread) from fileinventorysegment fis

join fileinventory fi on (fis.fileid = fi.fileid) where fi.filetype = 2

and (endtime is null or filestate = 0);

Related topics:

• FileInventory table

• Interpreting ARI file types and states

• Import Statistics query

• Failed Reads query

• Reading table