forked from docs/doc-exports
luhuayi
177cd61a57
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com> Co-authored-by: luhuayi <luhuayi@huawei.com> Co-committed-by: luhuayi <luhuayi@huawei.com>
143 lines
13 KiB
HTML
143 lines
13 KiB
HTML
<a name="EN-US_TOPIC_0000001764491296"></a><a name="EN-US_TOPIC_0000001764491296"></a>
|
|
|
|
<h1 class="topictitle1">GLOBAL_WORKLOAD_SQL_ELAPSE_TIME</h1>
|
|
<div id="body1578647607412"><p id="EN-US_TOPIC_0000001764491296__p8060118"><strong id="EN-US_TOPIC_0000001764491296__b1130131719147">GLOBAL_WORKLOAD_SQL_ELAPSE_TIME</strong> displays statistics on the response time of SQL statements in all workload Cgroups in a cluster, including the maximum, minimum, average, and total response time of <strong id="EN-US_TOPIC_0000001764491296__b11825317144">SELECT</strong>, <strong id="EN-US_TOPIC_0000001764491296__b12631639161417">UPDATE</strong>, <strong id="EN-US_TOPIC_0000001764491296__b1858314559146">INSERT</strong>, and <strong id="EN-US_TOPIC_0000001764491296__b118908218152">DELETE</strong> statements. The unit is microsecond.</p>
|
|
|
|
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" id="EN-US_TOPIC_0000001764491296__table991091311370" frame="border" border="1" rules="all"><caption><b>Table 1 </b><strong id="EN-US_TOPIC_0000001764491296__b199477472362">GLOBAL_WORKLOAD_SQL_ELAPSE_TIME</strong> columns</caption><thead align="left"><tr id="EN-US_TOPIC_0000001764491296__row1910213113713"><th align="left" class="cellrowborder" valign="top" width="33.33333333333333%" id="mcps1.3.2.2.4.1.1"><p id="EN-US_TOPIC_0000001764491296__p891011343715"><strong id="EN-US_TOPIC_0000001764491296__b62921013443553">Column</strong></p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="33.33333333333333%" id="mcps1.3.2.2.4.1.2"><p id="EN-US_TOPIC_0000001764491296__p391181312379">Type</p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="33.33333333333333%" id="mcps1.3.2.2.4.1.3"><p id="EN-US_TOPIC_0000001764491296__p179111813103711">Description</p>
|
|
</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody><tr id="EN-US_TOPIC_0000001764491296__row291161343720"><td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764491296__p2911141393712">workload</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764491296__p1391131311379">Name</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764491296__p291111135377">Workload Cgroup name</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764491296__row14911713133715"><td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764491296__p18907134714148">total_select_elapse</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764491296__p139115137375">Bigint</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764491296__p814611507147">Total response time of <strong id="EN-US_TOPIC_0000001764491296__b55206121315">SELECT</strong> statements</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764491296__row865082410399"><td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764491296__p1390604718142">max_select_elapse</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764491296__p17650424113914">Bigint</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764491296__p131451503147">Maximum response time of <strong id="EN-US_TOPIC_0000001764491296__b42262038134">SELECT</strong> statements</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764491296__row1856242117391"><td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764491296__p690514715141">min_select_elapse</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764491296__p1656211214395">Bigint</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764491296__p1114513507145">Minimum response time of <strong id="EN-US_TOPIC_0000001764491296__b96921746135">SELECT</strong> statements</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764491296__row16171519143913"><td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764491296__p3904194741411">avg_select_elapse</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764491296__p5171419163917">Bigint</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764491296__p11144050121415">Average response time of <strong id="EN-US_TOPIC_0000001764491296__b1727426151312">SELECT</strong> statements</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764491296__row1241918143919"><td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764491296__p119039473146">total_update_elapse</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764491296__p542098193912">Bigint</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764491296__p14143115011144">Total response time of <strong id="EN-US_TOPIC_0000001764491296__b179131071132">UPDATE</strong> statements</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764491296__row1150012153912"><td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764491296__p8902194710146">max_update_elapse</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764491296__p171509128395">Bigint</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764491296__p15141950151418">Maximum response time of <strong id="EN-US_TOPIC_0000001764491296__b56285911311">UPDATE</strong> statements</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764491296__row10911121313715"><td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764491296__p1488024712145">min_update_elapse</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764491296__p1791141312378">Bigint</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764491296__p16140650121417">Minimum response time of <strong id="EN-US_TOPIC_0000001764491296__b1016541271317">UPDATE</strong> statements</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764491296__row144016536152"><td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764491296__p10401353131513">avg_update_elapse</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764491296__p14015539159">Bigint</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764491296__p140195315152">Average response time of <strong id="EN-US_TOPIC_0000001764491296__b1519013144136">UPDATE</strong> statements</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764491296__row2475856181514"><td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764491296__p20475155618155">total_insert_elapse</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764491296__p12475205661512">Bigint</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764491296__p14751356201516">Total response time of <strong id="EN-US_TOPIC_0000001764491296__b107232161131">INSERT</strong> statements</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764491296__row566014591152"><td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764491296__p1166015911514">max_insert_elapse</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764491296__p17660185911513">Bigint</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764491296__p9660195921511">Maximum response time of <strong id="EN-US_TOPIC_0000001764491296__b946831821316">INSERT</strong> statements</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764491296__row1482443191619"><td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764491296__p1282443101615">min_insert_elapse</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764491296__p2082443161614">Bigint</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764491296__p2824153201611">Minimum response time of <strong id="EN-US_TOPIC_0000001764491296__b2344102014133">INSERT</strong> statements</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764491296__row129051116160"><td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764491296__p690611115169">avg_insert_elapse</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764491296__p10906111161614">Bigint</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764491296__p5906201191615">Average response time of <strong id="EN-US_TOPIC_0000001764491296__b19210102210137">INSERT</strong> statements</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764491296__row14524448181610"><td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764491296__p1652510483169">total_delete_elapse</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764491296__p552514488168">Bigint</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764491296__p45251848101612">Total response time of <strong id="EN-US_TOPIC_0000001764491296__b87591233134">DELETE</strong> statements</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764491296__row147971351111618"><td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764491296__p0798185151610">max_delete_elapse</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764491296__p179855114162">Bigint</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764491296__p379845171615">Maximum response time of <strong id="EN-US_TOPIC_0000001764491296__b82381627101313">DELETE</strong> statements</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764491296__row15464958111619"><td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764491296__p184641458191612">min_delete_elapse</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764491296__p1646595816165">Bigint</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764491296__p14465135831620">Minimum response time of <strong id="EN-US_TOPIC_0000001764491296__b112133131318">DELETE</strong> statements</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764491296__row092812545162"><td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764491296__p10928135491616">avg_delete_elapse</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764491296__p159281554121618">Bigint</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764491296__p11928155415169">Average response time of <strong id="EN-US_TOPIC_0000001764491296__b15560142931314">DELETE</strong> statements</p>
|
|
</td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</div>
|
|
<div>
|
|
<div class="familylinks">
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="dws_04_0639.html">System Views</a></div>
|
|
</div>
|
|
</div>
|
|
|