topic Re: Stats and Logs - Stats table - Duration Column value in Talend Studio

Stats and Logs - Stats table - Duration Column value

Anonymous — Fri, 17 Feb 2017 08:25:28 GMT

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

Re: Stats and Logs - Stats table - Duration Column value

Anonymous — Fri, 17 Feb 2017 08:47:12 GMT

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

Re: Stats and Logs - Stats table - Duration Column value

Anonymous — Fri, 17 Feb 2017 10:27:49 GMT

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

Re: Stats and Logs - Stats table - Duration Column value

Anonymous — Fri, 17 Feb 2017 11:09:25 GMT

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.

Re: Stats and Logs - Stats table - Duration Column value

Anonymous — Fri, 17 Feb 2017 11:53:56 GMT

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

Re: Stats and Logs - Stats table - Duration Column value

Anonymous — Fri, 17 Feb 2017 12:22:59 GMT

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).

Re: Stats and Logs - Stats table - Duration Column value

Anonymous — Fri, 17 Feb 2017 12:31:46 GMT

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