Calculating the actual query run time

Database
Teradata Employee

Re: Calculating the actual query run time

In my opinion it would be nice to have back the total non-idle time in DBQL or a way to calculate it: going to the applications' logs is really unfeasible in most cases if not always.

I'm sure that it would be possible to get a reasonable estimate from the viewpoint database assuming a high-enough frequency of polling: anyone can point me to the right datastructure to interrogate?

Thanks

Marco

Fan

Re: Calculating the actual query run time

 
 
 
 

Why Not?

LastResponseTime - StartTime = ExecutionTime

 

What is the difference between LastResponseTime and FirstResponseTime.