Hi Rui,
Thanks for the explanation, sounds good.
Wonder if there is a way for us to get the historical avg, min and max execution time(s) for a query in DMC.
------------------------------
Krishna Rao Murakonda
------------------------------
Original Message:
Sent: Fri July 09, 2021 05:37 AM
From: Rui Li
Subject: DMC 3.1.5 - Query execution time
Hi Krishna,
It is a formatted representation of time. Query execution time is 2d:09:41:57.157, means that the time is 2 days, 9 hours, 41 minutes, 57 seconds and 157 milliseconds.
In your example, this SQL statement was executed 207,858,056 times over the last 12 hours, for a total query execution time of more than two days, each execution takes 2d:09:41:57.157 / 207,858,056, about 1ms. And CPU time is the same.
------------------------------
Rui Li
Original Message:
Sent: Thu July 08, 2021 04:05 PM
From: Krishna Rao Murakonda
Subject: DMC 3.1.5 - Query execution time
We have configured recently DMC 3.1.5 and pulled report for last 12 hrs. The metrics shows as below for query execution time. So, how to read and understand this?
For each execution how much time its taking and the units of it? (is it in ms/sec/min ?)
Top 10 statements
Longest running queries
| | | | |
---|
1 | insert into OVN.USERTABLEPART16K (CREATE_DATE,YCSB_KEY, FIELD0)... | 2d:09:41:57.157 | 03:24:54.316 | 207,858,056 |
------------------------------
Krishna Rao Murakonda
------------------------------
#Db2