If you want all the documents for a specific job, the query is: select count(*) from jobqueue where jobid=<the_job_id>
Karl On Mon, Oct 8, 2018 at 4:23 AM Romaric Pighetti < [email protected]> wrote: > Hi Karl, > > I am currently facing the need of getting the number of documents > processed by MCF in a specific job. > This number is getting bigger than the limit set for the web interface > and i don't want to increase this limit because of the stress it will > put on the database (openning the tab in the UI will pop queries for all > the jobs, and I know from previous readings that these queries are heavy > to process for postgre). > Thus i would like to know if you can provide me with the query used in > the interface to display the number of processed documents so that i can > fire it to postgreSQL manually and request it only for the job i am > interested in; lowering the impact on postgre. > > Thanks for your help. > Romaric > > -- > Romaric Pighetti > France Labs – Les experts du Search > > Les créateurs de Datafari 4, LA solution de recherche pour entreprise > > www.francelabs.com > >
