Get the Run times by table for a full load (inital sync/ re sync)

[choudarybabu]

I will need the load times of all tables , how long each table in a task took during the initial sync or a re sync 

is it possible to get the list from sql lite database or from the UI ?

[john_wang · Accepted solution]

Hello @choudarybabu ,

You may get the Full Load completion information for every table in Task --> Monitor --> Full Load, I think you are looking for the column "Load Duration", and you can sort the result by other columns, see my screen sample:

hope this helps.

Regards,

John.

[Heinvandenheuvel · Accepted solution]

>> is it possible to get the list from sql lite database or from the UI ?

You can get that info from 'everywhere'

• As @john_wang  indicates - UI - tasks - task - monitor - fulload : Check out the download TSV option.
• From the reptask__<taskname>.log look for (TASK_MANAGER|TARGET_LOAD) and (Start loading table|Load finished for table) then do the math. I have scripts to do so of course.
• From the Enterprise Manager REST API - notably 'GetTableStatuses'
• from REPCTL. REPCTL -d <replicate-data-dir>  gettablesstatus ?
• from SQLite: <replicate-data-dir>\tasks\<taskname>\task_tables.sqlite - tables_status:start_time/end_time

Good luck!

Hein