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_1011.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

79 lines
7.7 KiB
HTML
Raw Permalink Blame History

<a name="EN-US_TOPIC_0000001811609949"></a><a name="EN-US_TOPIC_0000001811609949"></a>
<h1 class="topictitle1">GS_OBS_READ_TRAFFIC</h1>
<div id="body0000001460907569"><p id="EN-US_TOPIC_0000001811609949__aac1b8c836a3a48088f929312f81d2059">Collects statistics on the OBS read traffic and average read bandwidth. The statistical results are aggregated every 10 minutes. This view is supported only by clusters of version 8.2.0 or later.</p>
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" id="EN-US_TOPIC_0000001811609949__t31ba078e3a2c4118a4ea6b14c55dfa4d" frame="border" border="1" rules="all"><thead align="left"><tr id="EN-US_TOPIC_0000001811609949__rf2927ae718904758868651806363462c"><th align="left" class="cellrowborder" valign="top" width="20%" id="mcps1.3.2.1.4.1.1"><p id="EN-US_TOPIC_0000001811609949__aff66b6e58a61471f8af3a5e6f043cacc"><strong id="EN-US_TOPIC_0000001811609949__b126657309443558">Column</strong></p>
</th>
<th align="left" class="cellrowborder" valign="top" width="30%" id="mcps1.3.2.1.4.1.2"><p id="EN-US_TOPIC_0000001811609949__a314be7cbe37d4982b3e29d6a8bcdbb7b">Type</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="50%" id="mcps1.3.2.1.4.1.3"><p id="EN-US_TOPIC_0000001811609949__a579f4a5200714bb4b0341ff7bf494d5c">Description</p>
</th>
</tr>
</thead>
<tbody><tr id="EN-US_TOPIC_0000001811609949__rd1c0538b18304b53845ab9e0c08577d5"><td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.1.4.1.1 "><p id="EN-US_TOPIC_0000001811609949__p8198205741110">nodename</p>
</td>
<td class="cellrowborder" valign="top" width="30%" headers="mcps1.3.2.1.4.1.2 "><p id="EN-US_TOPIC_0000001811609949__p21982057181115">TEXT</p>
</td>
<td class="cellrowborder" valign="top" width="50%" headers="mcps1.3.2.1.4.1.3 "><p id="EN-US_TOPIC_0000001811609949__p11198115713118">Cluster node</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001811609949__rb1273822467b408b8115be34f2697c6b"><td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.1.4.1.1 "><p id="EN-US_TOPIC_0000001811609949__p119810573114">hostname</p>
</td>
<td class="cellrowborder" valign="top" width="30%" headers="mcps1.3.2.1.4.1.2 "><p id="EN-US_TOPIC_0000001811609949__p8198205711116">TEXT</p>
</td>
<td class="cellrowborder" valign="top" width="50%" headers="mcps1.3.2.1.4.1.3 "><p id="EN-US_TOPIC_0000001811609949__p319855711117">Server node</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001811609949__rcb3e4c22bf18467a85ce93f3a9a6f783"><td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.1.4.1.1 "><p id="EN-US_TOPIC_0000001811609949__p31991657191119">traffic_mb</p>
</td>
<td class="cellrowborder" valign="top" width="30%" headers="mcps1.3.2.1.4.1.2 "><p id="EN-US_TOPIC_0000001811609949__p4199145711111">float8</p>
</td>
<td class="cellrowborder" valign="top" width="50%" headers="mcps1.3.2.1.4.1.3 "><p id="EN-US_TOPIC_0000001811609949__p519975761110">OBS read traffic statistics during the 10 minutes before <strong id="EN-US_TOPIC_0000001811609949__b13329642122712">logtime</strong></p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001811609949__rcdb7e028f40a43cfaa3ad78c0afd869b"><td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.1.4.1.1 "><p id="EN-US_TOPIC_0000001811609949__p121996575115">bandwidth_mb_per_s</p>
</td>
<td class="cellrowborder" valign="top" width="30%" headers="mcps1.3.2.1.4.1.2 "><p id="EN-US_TOPIC_0000001811609949__p91991357111111">float8</p>
</td>
<td class="cellrowborder" valign="top" width="50%" headers="mcps1.3.2.1.4.1.3 "><p id="EN-US_TOPIC_0000001811609949__p8199185714114">Average bandwidth, in MB/s</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001811609949__r5c656d46787c4e40a1b826d7496c1f94"><td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.1.4.1.1 "><p id="EN-US_TOPIC_0000001811609949__p619945721118">reqcount</p>
</td>
<td class="cellrowborder" valign="top" width="30%" headers="mcps1.3.2.1.4.1.2 "><p id="EN-US_TOPIC_0000001811609949__p1619916571118">Bigint</p>
</td>
<td class="cellrowborder" valign="top" width="50%" headers="mcps1.3.2.1.4.1.3 "><p id="EN-US_TOPIC_0000001811609949__p19199757141113">Number of OBS reads during the 10 minutes before <strong id="EN-US_TOPIC_0000001811609949__b3728174917278">logtime</strong></p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001811609949__row0191175233919"><td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.1.4.1.1 "><p id="EN-US_TOPIC_0000001811609949__p0200757131118">logtime</p>
</td>
<td class="cellrowborder" valign="top" width="30%" headers="mcps1.3.2.1.4.1.2 "><p id="EN-US_TOPIC_0000001811609949__p2020075719112">Timestamp with time zone</p>
</td>
<td class="cellrowborder" valign="top" width="50%" headers="mcps1.3.2.1.4.1.3 "><p id="EN-US_TOPIC_0000001811609949__p1020055761118">Time when statistics are recorded</p>
</td>
</tr>
</tbody>
</table>
</div>
<div class="section" id="EN-US_TOPIC_0000001811609949__section18960115713514"><h4 class="sectiontitle">Examples</h4><p id="EN-US_TOPIC_0000001811609949__p143148471539">Query statistics on the OBS read traffic and average read bandwidth. The statistical results are aggregated every 10 minutes.</p>
<div class="codecoloring" codetype="Sql" id="EN-US_TOPIC_0000001811609949__screen148731630113710"><div class="highlight"><table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><span class="normal">1</span>
<span class="normal">2</span>
<span class="normal">3</span>
<span class="normal">4</span>
<span class="normal">5</span></pre></div></td><td class="code"><div><pre><span></span><span class="k">select</span><span class="w"> </span><span class="o">*</span><span class="w"> </span><span class="k">from</span><span class="w"> </span><span class="n">gs_obs_read_traffic</span><span class="p">;</span>
<span class="w"> </span><span class="n">nodename</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">hostname</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">traffic_mb</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">bandwidth_mb_per_s</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">reqcount</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">logtime</span>
<span class="c1">----------+------------------+------------------+--------------------+----------+------------------------</span>
<span class="w"> </span><span class="n">dn_1</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">rhel_10_90_45_56</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">101</span><span class="p">.</span><span class="mi">959338188171</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">5</span><span class="p">.</span><span class="mi">14830159670447</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">23</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">2022</span><span class="o">-</span><span class="mi">11</span><span class="o">-</span><span class="mi">26</span><span class="w"> </span><span class="mi">09</span><span class="p">:</span><span class="mi">50</span><span class="p">:</span><span class="mi">00</span><span class="o">+</span><span class="mi">08</span>
<span class="p">(</span><span class="mi">1</span><span class="w"> </span><span class="k">row</span><span class="p">)</span>
</pre></div></td></tr></table></div>
</div>
</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