Stats and Logs - Stats table - Duration Column value

[Anonymous]

Hi,

I have set up a stats table in database and selected 'Use tstatcatcher' and 'On Database' in the project setting.

I run my job with the project setting as described above and data is inserted in the stats table in the database

For the begin and end there are two rows inserted every time I run the job. 

The duration column for the begin row shows 'null' and the end row shows '51513'

What is the meaning of this number 51513?

Also, every time I run the job, the duration column value for begin is always null, shouldn't it have the begin time?

Thanks in advance
Rathi

[Anonymous]

This is because there is little point to a duration column to be honest. The duration column is just the time difference (in milliseconds) between the "moment" timestamps of the begin and end records. It is perfectly correct that the begin record has a null value since nothing has happened at that point. So your job took 51.5 seconds

[Anonymous]

Thanks for the explanation rhall.
I get it. But the moment column, for the begin row says '2017-02-17 07:09:20' and the end row says '2017-02-17 07:17:55'.
But, the difference between these two doesn't come up-to 51.5 seconds. What am I missing here?
Thanks in advance
Rathi

[Anonymous]

Are the PID values the same? The PID identifies the Process Id for the job which should be the same for both rows if they are for the same job.

[Anonymous]

Yes the pids are the same
How will I know the latest begin and end rows from this stats table?

[Anonymous]

Hang on, I've re-looked at this.  07:09:20 to 07:17:55 is 515 seconds. Are you sure 51513 is correct? It looks like there should be another number after 3. 
You link the rows by PID and the latest rows will be the identified by the last "end" row (using the moment field).

[Anonymous]

Hey rhall, I missed the right number , its 515153. I get it now as to how to find the latest rows.
Thanks again,
Rathi