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>
52 lines
3.7 KiB
HTML
52 lines
3.7 KiB
HTML
<a name="EN-US_TOPIC_0000001764650976"></a><a name="EN-US_TOPIC_0000001764650976"></a>
|
|
|
|
<h1 class="topictitle1">PGXC_GLOBAL_TEMP_ATTACHED_PIDS</h1>
|
|
<div id="body0000001541259789"><p id="EN-US_TOPIC_0000001764650976__p083619348362">This view displays information about sessions of resources occupied by global temporary tables on CNs. This view is supported only by clusters of 8.2.1.220 and later versions.</p>
|
|
|
|
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" id="EN-US_TOPIC_0000001764650976__t9122edbdebbc48188e7df458f47ce6bb" frame="border" border="1" rules="all"><caption><b>Table 1 </b>PG_GLOBAL_TEMP_ATTACHED_PIDS columns</caption><thead align="left"><tr id="EN-US_TOPIC_0000001764650976__rd543d9f2781c4473b24ff9011a702ca7"><th align="left" class="cellrowborder" valign="top" width="20%" id="mcps1.3.2.2.4.1.1"><p id="EN-US_TOPIC_0000001764650976__a5e16576510594213ad42550ff08157fb"><strong id="EN-US_TOPIC_0000001764650976__b11400686684388">Column</strong></p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="20%" id="mcps1.3.2.2.4.1.2"><p id="EN-US_TOPIC_0000001764650976__a0f92ba1b3b024c4c9da4168c43885884">Type</p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="60%" id="mcps1.3.2.2.4.1.3"><p id="EN-US_TOPIC_0000001764650976__a0879059221d741dc955f852944dca391">Description</p>
|
|
</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody><tr id="EN-US_TOPIC_0000001764650976__row14202111816425"><td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764650976__p220261884219">nodename</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764650976__p120231824213">Name</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="60%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764650976__p420231874220">Node name</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764650976__rd04191852edc4f9e9917584e376b16df"><td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764650976__a95be0f4521c347fbabff5094c48350d3">schemaname</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764650976__a012866c2bb2f41419c6d824c53adc043">Name</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="60%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764650976__p182391621164019">Schema name</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764650976__r9b648b87db49427a9cd97f8e7433f9e4"><td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764650976__a345d5feb0d484b5eba5fea0177bcc6fd">tablename</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764650976__p277815411391">Name</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="60%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764650976__a8f4e2f127ff44ede8c92a113a32bfd03">Table name</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764650976__rad664a80ae30462bb0501c1b53a0bc4d"><td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764650976__abfe54b238b0049438df106a8a5c689d9">pid</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764650976__a1efe8fbd175842efb582782e77c24de8">Bigint</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="60%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764650976__a71527b2907ee498cb0a421ccb998e8c9">PID of a session</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>
|
|
|