User SQL runtime

General
Enthusiast

User SQL runtime

Hi 

I am trying to figure out how to measure the query runtime (from start to finish) for each SQL query executed by a user.

e.g.

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.

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

Table: dbc.dbqlogtbl

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?

Thank you,

Herman

2 REPLIES
Enthusiast

Re: User SQL runtime

Yes, DBC.DBQLogTbl or VIEW DBC.Qrylog  is what will help you.

For more info, refer this thread: http://forums.teradata.com/forum/database/measuring- query-reponse-time

Enthusiast

Re: User SQL runtime

Thanks Sachin.  This what I needed to know.

Kind regs,

H