Re: Query to get the number of documents processed from PostgreSQL

2018-10-09 Thread Romaric Pighetti
Thanks Karl for the quick answer. I guess to get only the documents completed while the job is running i will have to fiddle around with the status, for which potential values are expressed in the JobQueue class. I noticed that sometimes (mainly when pausing and restarting a job), selecting

Re: Query to get the number of documents processed from PostgreSQL

2018-10-08 Thread Karl Wright
If you want all the documents for a specific job, the query is: select count(*) from jobqueue where jobid= Karl On Mon, Oct 8, 2018 at 4:23 AM Romaric Pighetti < romaric.pighe...@francelabs.com> wrote: > Hi Karl, > > I am currently facing the need of getting the number of documents >

Query to get the number of documents processed from PostgreSQL

2018-10-08 Thread Romaric Pighetti
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