I am trying to get some runtime statistics from some jobs I have submitted on a local instance of galaxy. Essentially I want the Job Start Time and the Job End Time as listed on each job information pane.
I have investigated the database using the tutorial from the GCC2015. I also have used the mappings.py file to try and identify which table I should be obtaining these metrics from.
Currently I am doing the following:
For all the states that belong to a particular job of interest, I find a state title "running" and store the create_time as the start time. then I find the state titled "ok" and store the create_time as the end time.
This may very well be wrong. Times seem to be off by a few milli seconds when compared to the Galaxy Job information pane. I have also noticed that some jobs lack a running state (maybe because they are too short lived?).
Any how, I just want to know how to I obtain those two values, as seen on the Galaxy Job information pane from the galaxy database. (i.e. what create_time or update_time should I be looking for and from which table?)