I am trying to figure out how to measure the query runtime (from start to finish) for each SQL query executed by a user.
UserName, StartTime, QueryRunTime, etc., etc., etc.,
bob, 2013/01/30 09:10:00.00, 00:00:00:05:, etc., etc., etc.,
bob, '2013/01/30 09:11:00.00', 00:01:23:00, etc., etc., etc.
(QueryRunTime format: hh:mm:ss:ms. To calculate query run time, I used dbqlogtbl.FirstRespTime - dbqlogtbl.StartTime)
I am not clued up with Teradata, so I've been thumbling around in the dark.
Platform: Teradata v13
I've looked at the DBC tables and the only one that seem to sort of provide an answer is DBC.DBQLogTbl.
Are there any other tables that will provide the answers for me?