May be you can find more informaion in the following link-
and also let us know if you find anything new or more
( firstresptime - StartTime HOUR(2) TO SECOND(2) ) AS Elapsedtime
FROM dbc.qrylog WHERE username='XXXXX';
The Above Query will help you to find Elapsed Time.
The above query will give you the total time the query spent on the system (including active time and delay time). If you want to calculate the total Active Execution Time of the query on the system (this will not include the time it spent in the delay state), you can use:
( ( firstresptime - firststeptime ) HOUR( 4 ) TO SECOND( 2 ) )