Files
doc-exports/docs/dws/dev/dws_04_0565.html
luhuayi 177cd61a57 DWS DEVG 910.211 version
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: luhuayi <luhuayi@huawei.com>
Co-committed-by: luhuayi <luhuayi@huawei.com>
2025-05-05 07:44:03 +00:00

188 lines
18 KiB
HTML

<a name="EN-US_TOPIC_0000001811490717"></a><a name="EN-US_TOPIC_0000001811490717"></a>
<h1 class="topictitle1">GS_WLM_OPERATOR_INFO</h1>
<div id="body8662426"><p id="EN-US_TOPIC_0000001811490717__en-us_topic_0111176227_p8060118"><strong id="EN-US_TOPIC_0000001811490717__b089162420301">GS_WLM_OPERATOR_INFO</strong> records operators of completed jobs. The data is dumped from the kernel to a system catalog. If the GUC parameter <a href="dws_04_0922.html#EN-US_TOPIC_0000001811490709__s5f116e109a2944e3854abcc56772eaa1">enable_resource_record</a> is set to <strong id="EN-US_TOPIC_0000001811490717__b11409548161319">on</strong>, the system periodically imports records in <a href="dws_04_0702.html">GS_WLM_OPERATOR_HISTORY</a> to this system catalog. You are not advised to enable this function because it occupies storage space and affects performance. You are advised to disable it after performance locating and monitoring tasks are complete.</p>
<div class="notice" id="EN-US_TOPIC_0000001811490717__note11279204113212"><span class="noticetitle"><img src="public_sys-resources/notice_3.0-en-us.png"> </span><div class="noticebody"><ul id="EN-US_TOPIC_0000001811490717__ul878710833218"><li id="EN-US_TOPIC_0000001811490717__li1878718833219">The schema of the <strong id="EN-US_TOPIC_0000001811490717__b2800111917189">GS_WLM_OPERATOR_INFO</strong> system table is <strong id="EN-US_TOPIC_0000001811490717__b198005199182">dbms_om</strong>.</li><li id="EN-US_TOPIC_0000001811490717__li127872816326">The <strong id="EN-US_TOPIC_0000001811490717__b6593315131910">GS_WLM_OPERATOR_INFO</strong> system catalog can be queried only in the <strong id="EN-US_TOPIC_0000001811490717__b125936155195">postgres</strong> database. If it is queried in other databases, an error is reported.</li></ul>
</div></div>
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" id="EN-US_TOPIC_0000001811490717__ta2c1b3b6469742cd9a313f0843410206" frame="border" border="1" rules="all"><caption><b>Table 1 </b>GS_WLM_OPERATOR_INFO columns</caption><thead align="left"><tr id="EN-US_TOPIC_0000001811490717__r394f1a1ed92c49b2abfdd691232edd2d"><th align="left" class="cellrowborder" valign="top" width="22%" id="mcps1.3.3.2.4.1.1"><p id="EN-US_TOPIC_0000001811490717__acdafc26c873242d1b262dba53cadfcad"><strong id="EN-US_TOPIC_0000001811490717__b14138266824347">Column</strong></p>
</th>
<th align="left" class="cellrowborder" valign="top" width="19%" id="mcps1.3.3.2.4.1.2"><p id="EN-US_TOPIC_0000001811490717__en-us_topic_0111176227_p651816147513">Type</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="59%" id="mcps1.3.3.2.4.1.3"><p id="EN-US_TOPIC_0000001811490717__a41d0f6f6713842e28ee22c90026c3dfa">Description</p>
</th>
</tr>
</thead>
<tbody><tr id="EN-US_TOPIC_0000001811490717__row923413616325"><td class="cellrowborder" valign="top" width="22%" headers="mcps1.3.3.2.4.1.1 "><p id="EN-US_TOPIC_0000001811490717__p1723573693215">nodename</p>
</td>
<td class="cellrowborder" valign="top" width="19%" headers="mcps1.3.3.2.4.1.2 "><p id="EN-US_TOPIC_0000001811490717__p182351364322">Text</p>
</td>
<td class="cellrowborder" valign="top" width="59%" headers="mcps1.3.3.2.4.1.3 "><p id="EN-US_TOPIC_0000001811490717__p162355368322">Name of the CN where the statement is executed</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001811490717__r65e527276cad4724b3a3ef2334c88acb"><td class="cellrowborder" valign="top" width="22%" headers="mcps1.3.3.2.4.1.1 "><p id="EN-US_TOPIC_0000001811490717__a56b2e5bbc9f94d6c865861dce711347f">queryid</p>
</td>
<td class="cellrowborder" valign="top" width="19%" headers="mcps1.3.3.2.4.1.2 "><p id="EN-US_TOPIC_0000001811490717__a3ad2ab36e5fb41f0b5213a70b487dc24">Bigint</p>
</td>
<td class="cellrowborder" valign="top" width="59%" headers="mcps1.3.3.2.4.1.3 "><p id="EN-US_TOPIC_0000001811490717__a3075d2cebe6940eba60ad03dd992c01f">Internal query_id used for statement execution</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001811490717__r84eb34afa7554eaa9bb2436c9de2e45b"><td class="cellrowborder" valign="top" width="22%" headers="mcps1.3.3.2.4.1.1 "><p id="EN-US_TOPIC_0000001811490717__aadd9de83241341a2af7addce6a82d465">pid</p>
</td>
<td class="cellrowborder" valign="top" width="19%" headers="mcps1.3.3.2.4.1.2 "><p id="EN-US_TOPIC_0000001811490717__a3e4dc63cf2704dc5beeb3b5117634ade">Bigint</p>
</td>
<td class="cellrowborder" valign="top" width="59%" headers="mcps1.3.3.2.4.1.3 "><p id="EN-US_TOPIC_0000001811490717__en-us_topic_0111176227_p651921410511">Backend thread ID</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001811490717__r88b044a65aa24260ac117725154c42b6"><td class="cellrowborder" valign="top" width="22%" headers="mcps1.3.3.2.4.1.1 "><p id="EN-US_TOPIC_0000001811490717__a31b482d62ec742eaa18ab7404f00e070">plan_node_id</p>
</td>
<td class="cellrowborder" valign="top" width="19%" headers="mcps1.3.3.2.4.1.2 "><p id="EN-US_TOPIC_0000001811490717__a188fa99651af4dee87e58f7e084b43c7">Integer</p>
</td>
<td class="cellrowborder" valign="top" width="59%" headers="mcps1.3.3.2.4.1.3 "><p id="EN-US_TOPIC_0000001811490717__ac0eabcdc99a543fa85c9cecaa0cd77c2">plan_node_id of the execution plan of a query</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001811490717__rf75eab0903e2445993e02c25deb2b2c4"><td class="cellrowborder" valign="top" width="22%" headers="mcps1.3.3.2.4.1.1 "><p id="EN-US_TOPIC_0000001811490717__a13afb042c1904f758a87d31c088f22f6">plan_node_name</p>
</td>
<td class="cellrowborder" valign="top" width="19%" headers="mcps1.3.3.2.4.1.2 "><p id="EN-US_TOPIC_0000001811490717__a3001da8485d54defa88f66f8dd221ec1">Text</p>
</td>
<td class="cellrowborder" valign="top" width="59%" headers="mcps1.3.3.2.4.1.3 "><p id="EN-US_TOPIC_0000001811490717__a5916ef5ac8f94886b6cb71eecda446bb">Name of the operator corresponding to plan_node_id</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001811490717__r7a78f6ed6020408098b870c56bef2147"><td class="cellrowborder" valign="top" width="22%" headers="mcps1.3.3.2.4.1.1 "><p id="EN-US_TOPIC_0000001811490717__a52b290ba721c41b69ecc600fa6715547">start_time</p>
</td>
<td class="cellrowborder" valign="top" width="19%" headers="mcps1.3.3.2.4.1.2 "><p id="EN-US_TOPIC_0000001811490717__a4a9f932b044644b8863da04c93b6bba5">Timestamp with time zone</p>
</td>
<td class="cellrowborder" valign="top" width="59%" headers="mcps1.3.3.2.4.1.3 "><p id="EN-US_TOPIC_0000001811490717__en-us_topic_0111176227_p751971405113">Time when an operator starts to process the first data record</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001811490717__rdeb6648aa3a14eadafadb8594b392dd4"><td class="cellrowborder" valign="top" width="22%" headers="mcps1.3.3.2.4.1.1 "><p id="EN-US_TOPIC_0000001811490717__ad4704fde9f244ea593a46c7238508f92">duration</p>
</td>
<td class="cellrowborder" valign="top" width="19%" headers="mcps1.3.3.2.4.1.2 "><p id="EN-US_TOPIC_0000001811490717__a77d7af4ed1df4ec6b2af7c04d82a7b21">Bigint</p>
</td>
<td class="cellrowborder" valign="top" width="59%" headers="mcps1.3.3.2.4.1.3 "><p id="EN-US_TOPIC_0000001811490717__a8b553a22bd33465682818ff4a57949cd">Total execution time of an operator. The unit is ms.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001811490717__r8856a14584a6425ebc1bded7eefe42e4"><td class="cellrowborder" valign="top" width="22%" headers="mcps1.3.3.2.4.1.1 "><p id="EN-US_TOPIC_0000001811490717__a6e420436c0054446ac8b6d4159e5b1ee">query_dop</p>
</td>
<td class="cellrowborder" valign="top" width="19%" headers="mcps1.3.3.2.4.1.2 "><p id="EN-US_TOPIC_0000001811490717__a185d26ff62cb44039ae21544e5fb89ed">Integer</p>
</td>
<td class="cellrowborder" valign="top" width="59%" headers="mcps1.3.3.2.4.1.3 "><p id="EN-US_TOPIC_0000001811490717__a9461c107a1a0433da56093e3ce4c02df">Degree of parallelism (DOP) of the current operator</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001811490717__r7cb049a3d5864a34b752a81857ddc508"><td class="cellrowborder" valign="top" width="22%" headers="mcps1.3.3.2.4.1.1 "><p id="EN-US_TOPIC_0000001811490717__aeda2878b21cc445ead8716cba33a2ce4">estimated_rows</p>
</td>
<td class="cellrowborder" valign="top" width="19%" headers="mcps1.3.3.2.4.1.2 "><p id="EN-US_TOPIC_0000001811490717__a41ab7137acf74040a7f3657ccf78106a">Bigint</p>
</td>
<td class="cellrowborder" valign="top" width="59%" headers="mcps1.3.3.2.4.1.3 "><p id="EN-US_TOPIC_0000001811490717__a2b0575afb3254f598c9069f6df59208e">Number of rows estimated by the optimizer</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001811490717__rc7756a9aed7543319f7c3685fd58db2c"><td class="cellrowborder" valign="top" width="22%" headers="mcps1.3.3.2.4.1.1 "><p id="EN-US_TOPIC_0000001811490717__ad48609f62cf44f81aa49dfa2391bbd44">tuple_processed</p>
</td>
<td class="cellrowborder" valign="top" width="19%" headers="mcps1.3.3.2.4.1.2 "><p id="EN-US_TOPIC_0000001811490717__a713f0add387d4f008d05b40bbcf015f6">Bigint</p>
</td>
<td class="cellrowborder" valign="top" width="59%" headers="mcps1.3.3.2.4.1.3 "><p id="EN-US_TOPIC_0000001811490717__en-us_topic_0111176227_p55195145519">Number of elements returned by the current operator</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001811490717__rb482696b4f24400ab3b2f08cdd49c93a"><td class="cellrowborder" valign="top" width="22%" headers="mcps1.3.3.2.4.1.1 "><p id="EN-US_TOPIC_0000001811490717__en-us_topic_0111176227_p45193142511">min_peak_memory</p>
</td>
<td class="cellrowborder" valign="top" width="19%" headers="mcps1.3.3.2.4.1.2 "><p id="EN-US_TOPIC_0000001811490717__a4f302e41382b486ca144786d0e4494aa">Integer</p>
</td>
<td class="cellrowborder" valign="top" width="59%" headers="mcps1.3.3.2.4.1.3 "><p id="EN-US_TOPIC_0000001811490717__ab6f2b661b8344e9788a880fa138b9bd2">Minimum peak memory used by the current operator on all DNs. The unit is MB.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001811490717__r5618b05610e147a78e84dd5337d60303"><td class="cellrowborder" valign="top" width="22%" headers="mcps1.3.3.2.4.1.1 "><p id="EN-US_TOPIC_0000001811490717__a54d9a01e8da84274b9175ab79bbea0a1">max_peak_memory</p>
</td>
<td class="cellrowborder" valign="top" width="19%" headers="mcps1.3.3.2.4.1.2 "><p id="EN-US_TOPIC_0000001811490717__ad3b1e0bf09954e95bc49d88d9eb17d3a">Integer</p>
</td>
<td class="cellrowborder" valign="top" width="59%" headers="mcps1.3.3.2.4.1.3 "><p id="EN-US_TOPIC_0000001811490717__a659060c4e7db4f7286165fa805384f42">Maximum peak memory used by the current operator on all DNs. The unit is MB.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001811490717__r1233debc36ae4d119f5197d1b98aa573"><td class="cellrowborder" valign="top" width="22%" headers="mcps1.3.3.2.4.1.1 "><p id="EN-US_TOPIC_0000001811490717__a23dafedae219460c8fd76ac800a6b511">average_peak_memory</p>
</td>
<td class="cellrowborder" valign="top" width="19%" headers="mcps1.3.3.2.4.1.2 "><p id="EN-US_TOPIC_0000001811490717__aae495474831d4d1c9efa0137834513ee">Integer</p>
</td>
<td class="cellrowborder" valign="top" width="59%" headers="mcps1.3.3.2.4.1.3 "><p id="EN-US_TOPIC_0000001811490717__a0f15e3120afa48b29d074b6f3d621607">Average peak memory used by the current operator on all DNs. The unit is MB.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001811490717__ra9bd6c1dd9f94279b5ec47d588de7b61"><td class="cellrowborder" valign="top" width="22%" headers="mcps1.3.3.2.4.1.1 "><p id="EN-US_TOPIC_0000001811490717__en-us_topic_0111176227_p162135421546">memory_skew_percent</p>
</td>
<td class="cellrowborder" valign="top" width="19%" headers="mcps1.3.3.2.4.1.2 "><p id="EN-US_TOPIC_0000001811490717__en-us_topic_0111176227_p02131442948">Integer</p>
</td>
<td class="cellrowborder" valign="top" width="59%" headers="mcps1.3.3.2.4.1.3 "><p id="EN-US_TOPIC_0000001811490717__ac1dee150b73d4c999a457bf7970a7dd7">Memory usage skew of the current operator among DNs</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001811490717__r32d3fd4a77a2428987f0e1b7ae469f00"><td class="cellrowborder" valign="top" width="22%" headers="mcps1.3.3.2.4.1.1 "><p id="EN-US_TOPIC_0000001811490717__a632637c0837e4c589a4fddbc82bb4163">min_spill_size</p>
</td>
<td class="cellrowborder" valign="top" width="19%" headers="mcps1.3.3.2.4.1.2 "><p id="EN-US_TOPIC_0000001811490717__en-us_topic_0111176227_p952021419512">Integer</p>
</td>
<td class="cellrowborder" valign="top" width="59%" headers="mcps1.3.3.2.4.1.3 "><p id="EN-US_TOPIC_0000001811490717__p627672413297">Minimum spilled data among all DNs when a spill occurs. The unit is MB. The default value is <strong id="EN-US_TOPIC_0000001811490717__b842352706222527">0</strong>.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001811490717__rba9e7ad0e9eb4638bf8ecad6898c10b8"><td class="cellrowborder" valign="top" width="22%" headers="mcps1.3.3.2.4.1.1 "><p id="EN-US_TOPIC_0000001811490717__aba9600f5d73842ec84cadbab37c306c4">max_spill_size</p>
</td>
<td class="cellrowborder" valign="top" width="19%" headers="mcps1.3.3.2.4.1.2 "><p id="EN-US_TOPIC_0000001811490717__ae258bdbd40034a8d9f4593b07f5c821a">Integer</p>
</td>
<td class="cellrowborder" valign="top" width="59%" headers="mcps1.3.3.2.4.1.3 "><p id="EN-US_TOPIC_0000001811490717__p12771924162918">Maximum spilled data among all DNs when a spill occurs. The unit is MB. The default value is <strong id="EN-US_TOPIC_0000001811490717__b1768275604515">0</strong>.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001811490717__r16e98b885be641d4a067e8fcc5049fc6"><td class="cellrowborder" valign="top" width="22%" headers="mcps1.3.3.2.4.1.1 "><p id="EN-US_TOPIC_0000001811490717__a9003653b66e04b818d63b7cdcf3a669b">average_spill_size</p>
</td>
<td class="cellrowborder" valign="top" width="19%" headers="mcps1.3.3.2.4.1.2 "><p id="EN-US_TOPIC_0000001811490717__en-us_topic_0111176227_p752061414517">Integer</p>
</td>
<td class="cellrowborder" valign="top" width="59%" headers="mcps1.3.3.2.4.1.3 "><p id="EN-US_TOPIC_0000001811490717__p9277142492913">Average spilled data among all DNs when a spill occurs. The unit is MB. The default value is <strong id="EN-US_TOPIC_0000001811490717__b63581155469">0</strong>.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001811490717__r076994ff252d41ada266fb30e4dff109"><td class="cellrowborder" valign="top" width="22%" headers="mcps1.3.3.2.4.1.1 "><p id="EN-US_TOPIC_0000001811490717__ada08e42d0a064f15a6a987858d20cb9d">spill_skew_percent</p>
</td>
<td class="cellrowborder" valign="top" width="19%" headers="mcps1.3.3.2.4.1.2 "><p id="EN-US_TOPIC_0000001811490717__en-us_topic_0111176227_p85201141517">Integer</p>
</td>
<td class="cellrowborder" valign="top" width="59%" headers="mcps1.3.3.2.4.1.3 "><p id="EN-US_TOPIC_0000001811490717__a99097da79d6344bb837a18314a493939">DN spill skew when a spill occurs</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001811490717__rf2e424638e1b459d83eade9cba7742f4"><td class="cellrowborder" valign="top" width="22%" headers="mcps1.3.3.2.4.1.1 "><p id="EN-US_TOPIC_0000001811490717__ab65cbe57a8fd4f7995e41b618c21eca0">min_cpu_time</p>
</td>
<td class="cellrowborder" valign="top" width="19%" headers="mcps1.3.3.2.4.1.2 "><p id="EN-US_TOPIC_0000001811490717__en-us_topic_0111176227_p145200142510">Bigint</p>
</td>
<td class="cellrowborder" valign="top" width="59%" headers="mcps1.3.3.2.4.1.3 "><p id="EN-US_TOPIC_0000001811490717__en-us_topic_0111176227_p185204140516">Minimum execution time of the operator on all DNs. The unit is ms.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001811490717__r25ce7459994a4f58a784b3d9cdada88a"><td class="cellrowborder" valign="top" width="22%" headers="mcps1.3.3.2.4.1.1 "><p id="EN-US_TOPIC_0000001811490717__en-us_topic_0111176227_p752019149519">max_cpu_time</p>
</td>
<td class="cellrowborder" valign="top" width="19%" headers="mcps1.3.3.2.4.1.2 "><p id="EN-US_TOPIC_0000001811490717__aaa64b8f777c64db5bffb77a457339710">Bigint</p>
</td>
<td class="cellrowborder" valign="top" width="59%" headers="mcps1.3.3.2.4.1.3 "><p id="EN-US_TOPIC_0000001811490717__en-us_topic_0111176227_p65207145515">Maximum execution time of the operator on all DNs. The unit is ms.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001811490717__r870f95b5891c4c93a25e977c91014d61"><td class="cellrowborder" valign="top" width="22%" headers="mcps1.3.3.2.4.1.1 "><p id="EN-US_TOPIC_0000001811490717__a356c34ed056d4ff28bd35250b2894a0b">total_cpu_time</p>
</td>
<td class="cellrowborder" valign="top" width="19%" headers="mcps1.3.3.2.4.1.2 "><p id="EN-US_TOPIC_0000001811490717__a1a5df49995cc4b8e8fc71578326fab91">Bigint</p>
</td>
<td class="cellrowborder" valign="top" width="59%" headers="mcps1.3.3.2.4.1.3 "><p id="EN-US_TOPIC_0000001811490717__ab766b80f13f0401cb9dbd9c40693dbd4">Total execution time of the operator on all DNs. The unit is ms.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001811490717__r9fbd973f40d34a14b0b0ab6d26f6d3d8"><td class="cellrowborder" valign="top" width="22%" headers="mcps1.3.3.2.4.1.1 "><p id="EN-US_TOPIC_0000001811490717__a4a8f12f1d3464991bdedb95a4c695124">cpu_skew_percent</p>
</td>
<td class="cellrowborder" valign="top" width="19%" headers="mcps1.3.3.2.4.1.2 "><p id="EN-US_TOPIC_0000001811490717__a4c5bdb50bec94222965450d4c995d0e3">Integer</p>
</td>
<td class="cellrowborder" valign="top" width="59%" headers="mcps1.3.3.2.4.1.3 "><p id="EN-US_TOPIC_0000001811490717__a7b7bdff6158648e383c7ee1a9452fe6e">Skew of the execution time among DNs.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001811490717__rb31e1f1dc9614a11a6fc9316eab76dda"><td class="cellrowborder" valign="top" width="22%" headers="mcps1.3.3.2.4.1.1 "><p id="EN-US_TOPIC_0000001811490717__a705a3296d1824a908744df2d0cf69036">warning</p>
</td>
<td class="cellrowborder" valign="top" width="19%" headers="mcps1.3.3.2.4.1.2 "><p id="EN-US_TOPIC_0000001811490717__a8d80ed676a61435f8d0182dc3229101a">Text</p>
</td>
<td class="cellrowborder" valign="top" width="59%" headers="mcps1.3.3.2.4.1.3 "><p id="EN-US_TOPIC_0000001811490717__a6b1e9e6b8eb044c8b7a9ada59f0eb6e5">Warning. The following warnings are displayed:</p>
<ol id="EN-US_TOPIC_0000001811490717__ol51018198136"><li id="EN-US_TOPIC_0000001811490717__li1410151901318">Sort/SetOp/HashAgg/HashJoin spill</li><li id="EN-US_TOPIC_0000001811490717__li14101171915136">Spill file size large than 256MB</li><li id="EN-US_TOPIC_0000001811490717__li4101151911135">Broadcast size large than 100MB</li><li id="EN-US_TOPIC_0000001811490717__li110131931315">Early spill</li><li id="EN-US_TOPIC_0000001811490717__li14101191941317">Spill times is greater than 3</li><li id="EN-US_TOPIC_0000001811490717__li1210114198136">Spill on memory adaptive</li><li id="EN-US_TOPIC_0000001811490717__li19101101971319">Hash table conflict</li></ol>
</td>
</tr>
</tbody>
</table>
</div>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="dws_04_0561.html">System Catalogs</a></div>
</div>
</div>