This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 64%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Does the duration contains the time from DB completed query and the client successfully received the data?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 93%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
These are the statistics for a particular query over time giving the execution count and the duration it ran for. Here is a document explaining that in detail.
Please go through the same and get back to us for any questions.
Regards
Navtej S
Thanks, Navtej, but I want to confirm that does the duration contains the time from db to client? After the DB complete the query, it need to return the query result to client, so if the client has the network issue, this process must be slow, so does this time included in the duration?
Query duration is aggregation of time for compiling and executing the query. More details here.
Please let us know if you need further information regarding this,
Regards
Navtej S
@Matthew Shi Please let us know if you need further help regarding this.