How to calculate Total end to end query elapsed time

Database

How to calculate Total end to end query elapsed time

Can you let us know how to measure the time taken by the session in RESPONSE state. In dbqlogtbl there is a time stamp for active

state,delay state but I am not able to find the appropriate field.

Case is :

There is one session in responding state for 9 hours and its total duration is 9:15 hours(according to Viewpoint), so when I try to fetch

information from dbc.dbqlogtbl I am not able to get total time stamp as 9:15 hours, it is giving 15mins which must be related to the time

spent in Active/Delay state and not including the time spent in Responding State, so how can I calculate the total time elapsed by the

query(end to end) including all states.

Please let us know how to resolve this, any information will be really helpful.

Thank you !!