yexinru/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
Files
sgode-patch-2
doc-exports/docs/dws/dev/dws_04_1098.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

224 lines
29 KiB
HTML
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

<a name="EN-US_TOPIC_0000001777636126"></a><a name="EN-US_TOPIC_0000001777636126"></a>
<h1 class="topictitle1">PGXC_BULKLOAD_INFO</h1>
<div id="body8662426"><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p834182964818">By querying the <strong id="EN-US_TOPIC_0000001777636126__b372815511559">PGXC_BULKLOAD_INFO</strong> view on CNs, you can obtain historical statistics information for interconnection, GDS, COPY, and \COPY business executions after they have completed. This view summarizes the historical execution information of import and export business that have already completed on each node of the current cluster (including the interconnection cluster address, import and export business type, maximum, minimum, and total number of rows and bytes written to disk on DNs, etc.), to obtain historical information on import and export business execution and assist in performance troubleshooting.</p>
<p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p2995116201">This view does not record abnormal interruptions of import and export jobs. The data is directly obtained from the system catalog <strong id="EN-US_TOPIC_0000001777636126__b142095113570">GS_WLM_SESSION_INFO</strong>, and the <strong id="EN-US_TOPIC_0000001777636126__b1807182018574">loader_status</strong> field is parsed to obtain import and export service information.</p>
<p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p12221064549">System administrator rights are required to access this view.</p>
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_table158732593611" frame="border" border="1" rules="all"><caption><b>Table 1 </b>PGXC_BULKLOAD_INFO columns</caption><thead align="left"><tr id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_row2936459564"><th align="left" class="cellrowborder" valign="top" width="21.682168216821683%" id="mcps1.3.4.2.4.1.1"><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_af6d6f889d09c4bbc83f5cdc4ca2e446d"><strong id="EN-US_TOPIC_0000001777636126__b11983825812">Column</strong></p>
</th>
<th align="left" class="cellrowborder" valign="top" width="25.57255725572557%" id="mcps1.3.4.2.4.1.2"><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_a520753062fd84b56b345fd11568a4c23"><strong id="EN-US_TOPIC_0000001777636126__b955715315586">Type</strong></p>
</th>
<th align="left" class="cellrowborder" valign="top" width="52.74527452745274%" id="mcps1.3.4.2.4.1.3"><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_aa4223d4b95904277a4d79610e87bff01"><strong id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_b15814084111">Description</strong></p>
</th>
</tr>
</thead>
<tbody><tr id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_row14936159365"><td class="cellrowborder" valign="top" width="21.682168216821683%" headers="mcps1.3.4.2.4.1.1 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_en-us_topic_0112535431_p6601473915">datid</p>
</td>
<td class="cellrowborder" valign="top" width="25.57255725572557%" headers="mcps1.3.4.2.4.1.2 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_en-us_topic_0112535431_p36013463914">OID</p>
</td>
<td class="cellrowborder" valign="top" width="52.74527452745274%" headers="mcps1.3.4.2.4.1.3 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_en-us_topic_0112535431_p16084113913">OID of the database the backend is connected to.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_row179375598614"><td class="cellrowborder" valign="top" width="21.682168216821683%" headers="mcps1.3.4.2.4.1.1 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_en-us_topic_0112535431_p12609418397">dbname</p>
</td>
<td class="cellrowborder" valign="top" width="25.57255725572557%" headers="mcps1.3.4.2.4.1.2 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_en-us_topic_0112535431_p3606417399">Text</p>
</td>
<td class="cellrowborder" valign="top" width="52.74527452745274%" headers="mcps1.3.4.2.4.1.3 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_a841134a52c9b4bed993cacbdff41698b">Name of the database the backend is connected to.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_row593720596613"><td class="cellrowborder" valign="top" width="21.682168216821683%" headers="mcps1.3.4.2.4.1.1 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_en-us_topic_0112535431_p560348390">schemaname</p>
</td>
<td class="cellrowborder" valign="top" width="25.57255725572557%" headers="mcps1.3.4.2.4.1.2 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_en-us_topic_0112535431_p10605483915">Text</p>
</td>
<td class="cellrowborder" valign="top" width="52.74527452745274%" headers="mcps1.3.4.2.4.1.3 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_en-us_topic_0112535431_p6601744397">Schema name.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_row7937185911610"><td class="cellrowborder" valign="top" width="21.682168216821683%" headers="mcps1.3.4.2.4.1.1 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_en-us_topic_0112535431_p17602418392">nodename</p>
</td>
<td class="cellrowborder" valign="top" width="25.57255725572557%" headers="mcps1.3.4.2.4.1.2 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_a09c81250f5fd4a3092f01c10d3377bea">Text</p>
</td>
<td class="cellrowborder" valign="top" width="52.74527452745274%" headers="mcps1.3.4.2.4.1.3 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_en-us_topic_0112535431_p146015473916">Name of the CN where the statement is run.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_row2093775919616"><td class="cellrowborder" valign="top" width="21.682168216821683%" headers="mcps1.3.4.2.4.1.1 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_en-us_topic_0112535431_p15601141394">username</p>
</td>
<td class="cellrowborder" valign="top" width="25.57255725572557%" headers="mcps1.3.4.2.4.1.2 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_en-us_topic_0112535431_p156034123911">Text</p>
</td>
<td class="cellrowborder" valign="top" width="52.74527452745274%" headers="mcps1.3.4.2.4.1.3 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_en-us_topic_0112535431_p1860649397">Username for connecting to the backend.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_row493745917613"><td class="cellrowborder" valign="top" width="21.682168216821683%" headers="mcps1.3.4.2.4.1.1 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_en-us_topic_0112535431_p26019419397">application_name</p>
</td>
<td class="cellrowborder" valign="top" width="25.57255725572557%" headers="mcps1.3.4.2.4.1.2 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_en-us_topic_0112535431_p15601246399">Text</p>
</td>
<td class="cellrowborder" valign="top" width="52.74527452745274%" headers="mcps1.3.4.2.4.1.3 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_en-us_topic_0112535431_p7626415391">Name of the application that is connected to the backend.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_row793716591261"><td class="cellrowborder" valign="top" width="21.682168216821683%" headers="mcps1.3.4.2.4.1.1 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_en-us_topic_0112535431_p116216453913">client_addr</p>
</td>
<td class="cellrowborder" valign="top" width="25.57255725572557%" headers="mcps1.3.4.2.4.1.2 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_en-us_topic_0112535431_p166219413396">inet</p>
</td>
<td class="cellrowborder" valign="top" width="52.74527452745274%" headers="mcps1.3.4.2.4.1.3 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_en-us_topic_0112535431_p11628410399">IP address of the client connected to the backend. If this column is null, it indicates that the client is connected via a Unix socket on the server machine or that it is an internal process, such as autovacuum.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_row8937105920618"><td class="cellrowborder" valign="top" width="21.682168216821683%" headers="mcps1.3.4.2.4.1.1 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_a222709e1834a465783cc443c6c2ef0d5">client_hostname</p>
</td>
<td class="cellrowborder" valign="top" width="25.57255725572557%" headers="mcps1.3.4.2.4.1.2 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_en-us_topic_0112535431_p562174113919">Text</p>
</td>
<td class="cellrowborder" valign="top" width="52.74527452745274%" headers="mcps1.3.4.2.4.1.3 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_en-us_topic_0112535431_p262643393">Host name of the client, which is obtained by reverse DNS lookup of <strong id="EN-US_TOPIC_0000001777636126__b18957114512219">client_addr</strong>. This column is only non-null when <strong id="EN-US_TOPIC_0000001777636126__b1050351010318">log_hostname</strong> is enabled and IP connection is used.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_row1993710599617"><td class="cellrowborder" valign="top" width="21.682168216821683%" headers="mcps1.3.4.2.4.1.1 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_en-us_topic_0112535431_p146254113911">client_port</p>
</td>
<td class="cellrowborder" valign="top" width="25.57255725572557%" headers="mcps1.3.4.2.4.1.2 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_ac2f69fd2f8d34dc49e3a5d5a3599fc7f">Integer</p>
</td>
<td class="cellrowborder" valign="top" width="52.74527452745274%" headers="mcps1.3.4.2.4.1.3 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_en-us_topic_0112535431_p86216411395">TCP port number used by the client to communicate with the backend. If a Unix socket is used, it is <strong id="EN-US_TOPIC_0000001777636126__b5412461737">–1</strong>.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_row193716595618"><td class="cellrowborder" valign="top" width="21.682168216821683%" headers="mcps1.3.4.2.4.1.1 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_en-us_topic_0112535431_p9621544396">query_band</p>
</td>
<td class="cellrowborder" valign="top" width="25.57255725572557%" headers="mcps1.3.4.2.4.1.2 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_en-us_topic_0112535431_p136210419393">Text</p>
</td>
<td class="cellrowborder" valign="top" width="52.74527452745274%" headers="mcps1.3.4.2.4.1.3 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_en-us_topic_0112535431_p106213410394">Job type, which can be set using the GUC parameter <strong id="EN-US_TOPIC_0000001777636126__b07791465312">query_band</strong> and is a null string by default.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_row169382591365"><td class="cellrowborder" valign="top" width="21.682168216821683%" headers="mcps1.3.4.2.4.1.1 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_en-us_topic_0112535431_p116218463915">block_time</p>
</td>
<td class="cellrowborder" valign="top" width="25.57255725572557%" headers="mcps1.3.4.2.4.1.2 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_a4c028966a7ed41c7ad9d8ceffd9e8fc7">Bigint</p>
</td>
<td class="cellrowborder" valign="top" width="52.74527452745274%" headers="mcps1.3.4.2.4.1.3 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p1562813408418">Blocking time before statement execution, including statement parsing and optimization time, in milliseconds.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_row093865911616"><td class="cellrowborder" valign="top" width="21.682168216821683%" headers="mcps1.3.4.2.4.1.1 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_en-us_topic_0112535431_p4621749395">start_time</p>
</td>
<td class="cellrowborder" valign="top" width="25.57255725572557%" headers="mcps1.3.4.2.4.1.2 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_a14945b86c07a4f46b794d2011157ce1e">Timestamp with time zone</p>
</td>
<td class="cellrowborder" valign="top" width="52.74527452745274%" headers="mcps1.3.4.2.4.1.3 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_en-us_topic_0112535431_p10629483918">Start time of statement execution.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_row149381059160"><td class="cellrowborder" valign="top" width="21.682168216821683%" headers="mcps1.3.4.2.4.1.1 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_en-us_topic_0112535431_p19628493917">finish_time</p>
</td>
<td class="cellrowborder" valign="top" width="25.57255725572557%" headers="mcps1.3.4.2.4.1.2 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_en-us_topic_0112535431_p183487172297">Timestamp with time zone</p>
</td>
<td class="cellrowborder" valign="top" width="52.74527452745274%" headers="mcps1.3.4.2.4.1.3 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_a2ca725dd9a1544789401c7e484439d2e">End time of statement execution.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_row378219515114"><td class="cellrowborder" valign="top" width="21.682168216821683%" headers="mcps1.3.4.2.4.1.1 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p107821512114">status</p>
</td>
<td class="cellrowborder" valign="top" width="25.57255725572557%" headers="mcps1.3.4.2.4.1.2 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p678211518112">Text</p>
</td>
<td class="cellrowborder" valign="top" width="52.74527452745274%" headers="mcps1.3.4.2.4.1.3 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p177832518117">End status of statement execution: <strong id="EN-US_TOPIC_0000001777636126__b21191795913">finished</strong> for normal and <strong id="EN-US_TOPIC_0000001777636126__b625216151693">aborted</strong> for abnormal. The statement status recorded here should be the database server execution status. When the server-side execution is successful and an error occurs when the result set is returned, the statement should be <strong id="EN-US_TOPIC_0000001777636126__b101317291898">finished</strong>.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_row8938135917618"><td class="cellrowborder" valign="top" width="21.682168216821683%" headers="mcps1.3.4.2.4.1.1 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p188621735113914">queryid</p>
</td>
<td class="cellrowborder" valign="top" width="25.57255725572557%" headers="mcps1.3.4.2.4.1.2 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p1486253511398">Bigint</p>
</td>
<td class="cellrowborder" valign="top" width="52.74527452745274%" headers="mcps1.3.4.2.4.1.3 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p168481935193917">Internal query ID used for statement execution.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_row1660712219260"><td class="cellrowborder" valign="top" width="21.682168216821683%" headers="mcps1.3.4.2.4.1.1 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p3608112172617">query</p>
</td>
<td class="cellrowborder" valign="top" width="25.57255725572557%" headers="mcps1.3.4.2.4.1.2 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p760822116268">Text</p>
</td>
<td class="cellrowborder" valign="top" width="52.74527452745274%" headers="mcps1.3.4.2.4.1.3 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p1860882114265">Executed statement.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_row207678207282"><td class="cellrowborder" valign="top" width="21.682168216821683%" headers="mcps1.3.4.2.4.1.1 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p1376882052818">session_id</p>
</td>
<td class="cellrowborder" valign="top" width="25.57255725572557%" headers="mcps1.3.4.2.4.1.2 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p476852012288">Text</p>
</td>
<td class="cellrowborder" valign="top" width="52.74527452745274%" headers="mcps1.3.4.2.4.1.3 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p9768172012282">A session uniquely identified in the database system, in the format of <strong id="EN-US_TOPIC_0000001777636126__b1936120164107">session_start_time.tid.node_name</strong>.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_row1541018544281"><td class="cellrowborder" valign="top" width="21.682168216821683%" headers="mcps1.3.4.2.4.1.1 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p114104543289">address</p>
</td>
<td class="cellrowborder" valign="top" width="25.57255725572557%" headers="mcps1.3.4.2.4.1.2 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p4410115472811">Text</p>
</td>
<td class="cellrowborder" valign="top" width="52.74527452745274%" headers="mcps1.3.4.2.4.1.3 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p24101154172819">Server address of the interconnection peer cluster. When not empty, it indicates an interconnection service, and the source cluster will additionally obtain the remote cluster port number.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_row11873792119"><td class="cellrowborder" valign="top" width="21.682168216821683%" headers="mcps1.3.4.2.4.1.1 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p087320951113">direction</p>
</td>
<td class="cellrowborder" valign="top" width="25.57255725572557%" headers="mcps1.3.4.2.4.1.2 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p9873179181114">Text</p>
</td>
<td class="cellrowborder" valign="top" width="52.74527452745274%" headers="mcps1.3.4.2.4.1.3 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p49357523389">Type of import and export service, including <strong id="EN-US_TOPIC_0000001777636126__b17527812161117">gds to file</strong>, <strong id="EN-US_TOPIC_0000001777636126__b11392814171118">gds from file</strong>, <strong id="EN-US_TOPIC_0000001777636126__b1447311712111">gds to pipe</strong>, <strong id="EN-US_TOPIC_0000001777636126__b18661142051111">gds from pipe</strong>, <strong id="EN-US_TOPIC_0000001777636126__b7927132419116">copy from</strong>, and <strong id="EN-US_TOPIC_0000001777636126__b16311127151110">copy to</strong>.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_row1414571415116"><td class="cellrowborder" valign="top" width="21.682168216821683%" headers="mcps1.3.4.2.4.1.1 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p15145131419116">min_done_lines</p>
</td>
<td class="cellrowborder" valign="top" width="25.57255725572557%" headers="mcps1.3.4.2.4.1.2 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p1414571415116">json</p>
</td>
<td class="cellrowborder" valign="top" width="52.74527452745274%" headers="mcps1.3.4.2.4.1.3 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p914515145112">Minimum number of rows of a statement across all DNs.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_row9438153117344"><td class="cellrowborder" valign="top" width="21.682168216821683%" headers="mcps1.3.4.2.4.1.1 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p843816318349">max_done_lines</p>
</td>
<td class="cellrowborder" valign="top" width="25.57255725572557%" headers="mcps1.3.4.2.4.1.2 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p20438173113414">json</p>
</td>
<td class="cellrowborder" valign="top" width="52.74527452745274%" headers="mcps1.3.4.2.4.1.3 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p243873193415">Maximum number of rows of a statement across all DNs.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_row11981103917344"><td class="cellrowborder" valign="top" width="21.682168216821683%" headers="mcps1.3.4.2.4.1.1 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p11981739133418">total_done_lines</p>
</td>
<td class="cellrowborder" valign="top" width="25.57255725572557%" headers="mcps1.3.4.2.4.1.2 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p109811739163414">json</p>
</td>
<td class="cellrowborder" valign="top" width="52.74527452745274%" headers="mcps1.3.4.2.4.1.3 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p798193923414">Total number of rows of a statement across all DNs.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_row199271634153412"><td class="cellrowborder" valign="top" width="21.682168216821683%" headers="mcps1.3.4.2.4.1.1 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p4927153411348">min_done_bytes</p>
</td>
<td class="cellrowborder" valign="top" width="25.57255725572557%" headers="mcps1.3.4.2.4.1.2 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p159271934153416">json</p>
</td>
<td class="cellrowborder" valign="top" width="52.74527452745274%" headers="mcps1.3.4.2.4.1.3 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p8927183443414">Minimum number of bytes of a statement across all DNs.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_row20171243113412"><td class="cellrowborder" valign="top" width="21.682168216821683%" headers="mcps1.3.4.2.4.1.1 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p91784303412">max_done_bytes</p>
</td>
<td class="cellrowborder" valign="top" width="25.57255725572557%" headers="mcps1.3.4.2.4.1.2 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p161764317349">json</p>
</td>
<td class="cellrowborder" valign="top" width="52.74527452745274%" headers="mcps1.3.4.2.4.1.3 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p41794323417">Maximum number of bytes of a statement across all DNs.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_row107144614349"><td class="cellrowborder" valign="top" width="21.682168216821683%" headers="mcps1.3.4.2.4.1.1 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p5715463343">total_done_bytes</p>
</td>
<td class="cellrowborder" valign="top" width="25.57255725572557%" headers="mcps1.3.4.2.4.1.2 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p771104614344">json</p>
</td>
<td class="cellrowborder" valign="top" width="52.74527452745274%" headers="mcps1.3.4.2.4.1.3 "><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p871946193416">Total number of bytes of a statement across all DNs.</p>
</td>
</tr>
</tbody>
</table>
</div>
<div class="note" id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_note1671181192518"><img src="public_sys-resources/note_3.0-en-us.png"><span class="notetitle"> </span><div class="notebody"><ul id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_ul12931465406"><li id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_li18350825114219">Abnormal interruptions of import and export jobs are not recorded in the view.</li><li id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_li1435217510616">The implementation mechanism of GDS foreign tables and interconnection foreign tables is different. When querying, GDS records the full amount, while interconnection records the actual amount.</li><li id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_li0498104618913">For non-full import and export foreign tables with a limit, due to the special execution plan of limit, the data displayed is collected from one DN, which appears as a maximum value of all and a minimum value of 0.</li><li id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_li109471447131012">If the import and export table is a non-partitioned table:<ul id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_ul13561161321318"><li id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_li14443191311134">When the GDS partitioned table is small, if one DN has finished collecting data and the other DNs have not started collecting data, they will not collect data. Therefore, when the data volume of GDS from non-partitioned tables is small, the minimum value may be 0, but it is not 0 when the table data volume is large.</li><li id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_li1081572012135">When exporting non-partitioned tables from the interconnection source cluster, all DNs will be recorded, and only one DN's data will be collected, so the minimum value is 0.</li><li id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_li15353102961319">When exporting replication tables from the interconnection remote cluster, only one DN will be recorded, so it is equivalent to having only one DN, and the minimum and maximum values are the same.</li></ul>
</li><li id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_li6203312101415">Historical monitoring of import and export is implemented by reusing the historical TopSQL function, which follows the precautions, prerequisites, and operation steps of TopSQL. For details, refer to <a href="dws_04_0398.html">Historical Top SQL</a>.</li><li id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_li6867953122315">Due to the large amount of data recorded by TopSQL, you are advised to query and use it as needed by combining fields such as <strong id="EN-US_TOPIC_0000001777636126__b8916150151710">start_time</strong> and <strong id="EN-US_TOPIC_0000001777636126__b1550553121711">finish_time</strong> to improve query performance, or to reduce query frequency.</li></ul>
</div></div>
<div class="section" id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_section18600715131514"><h4 class="sectiontitle">Example</h4><p id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_p65001319131517">Use the <strong id="EN-US_TOPIC_0000001777636126__b3618165951714">PGXC_BULKLOAD_INFO</strong> view to query interconnection import service.</p>
<pre class="screen" id="EN-US_TOPIC_0000001777636126__en-us_topic_0000001712999121_screen7355155183215">SELECT * FROM PGXC_BULKLOAD_INFO;
datid | dbname | schemaname | nodename | username | application_name | client_addr | client_hostname | client_port | query_band | block_time | start_time | finish_time | status
s | queryid | query
| session_id | address | direction | min_done_lines | max_done_lines | total_done_lines | min_done_by
tes | max_done_bytes | total_done_bytes
-------+----------+----------------+--------------+----------------+------------------+-------------+-----------------+-------------+------------+------------+-------------------------------+-------------------------------+-------
---+-------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------+-----------------------------------------+-------------------+---------------+----------------+----------------+------------------+------------
----+----------------+------------------
16134 | postgres | "$user",public | coordinator1 | interconn_user | gsql | | | -1 | | 0 | 2023-09-25 10:27:47.184696+08 | 2023-09-25 10:27:48.709665+08 | finish
ed | 72339069014639035 | INSERT INTO interconn_user.lineitem_dest SELECT * FROM interconn_user.ft_lineitem_local;
| 1695608841.140482657154648.coordinator1 | 10.90.45.56:63755 | gds from pipe | 19479 | 20971 | 60175 | 3251258
| 3500876 | 10038234
16134 | postgres | "$user",public | coordinator1 | interconn_user | interconnection | 10.90.45.56 | | 47668 | | 0 | 2023-09-25 10:27:47.256095+08 | 2023-09-25 10:27:48.582366+08 | finish
ed | 72339069014639046 | INSERT INTO pg_temp.ft_lineitem_local_72339069014639035_wo SELECT l_orderkey, l_partkey, l_suppkey, l_linenumber, l_quantity, l_extendedprice, l_discount, l_tax, l_returnflag, l_linestatus, l_shipdate, l_c
ommitdate, l_receiptdate, l_shipinstruct, l_shipmode, l_comment FROM public.lineitem; | 1695608867.140482657156768.coordinator1 | 10.90.45.56 | gds to pipe | 19476 | 20934 | 60175 | 3249308
| 3489789 | 10038234
(2 rows)</pre>
</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>
View Git Blame Copy Permalink