Db2 (On Premises and Cloud)

Expand all | Collapse all

DMC 3.1.5 - Query execution time

  • 1.  DMC 3.1.5 - Query execution time

    Posted Thu July 08, 2021 04:06 PM
    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

    Top 10
    SQL statement
    Query execution time
    CPU time
    Executions
    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
    ------------------------------


  • 2.  RE: DMC 3.1.5 - Query execution time

    Posted Fri July 09, 2021 05:38 AM
    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
    ------------------------------



  • 3.  RE: DMC 3.1.5 - Query execution time

    Posted Fri July 09, 2021 12:56 PM
    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
    ------------------------------



  • 4.  RE: DMC 3.1.5 - Query execution time

    Posted Fri July 09, 2021 11:49 AM

    My "wild" guess would be 2 Days, 9 Hours, 41 Minutes, 57 Seconds 157/1000 sec...

    :-)



    ------------------------------
    Jan Nelken
    ------------------------------



  • 5.  RE: DMC 3.1.5 - Query execution time

    Posted Fri July 09, 2021 12:58 PM
    Thanks Jan.

    ------------------------------
    Krishna Rao Murakonda
    ------------------------------