数据仓库服务 GAUSSDB(DWS)-GS_OBS_WRITE_TRAFFIC:应用示例

时间：2024-09-24 17:40:41

应用示例

查询当前视图，统计OBS写流量和平均写带宽，统计结果按10分钟聚集。

  
       select * from gs_obs_write_traffic;
   nodename   |     hostname     |      traffic_mb      | bandwidth_mb_per_s  | reqcount |        logtime
--------------+------------------+----------------------+---------------------+----------+------------------------
 dn_1         | rhel_10_90_45_56 |  .000738143920898438 | .000289970820362525 |       12 | 2022-10-24 16:10:00+08
 dn_1         | rhel_10_90_45_56 |  .000354766845703125 | .000386063466694153 |        7 | 2022-10-24 18:50:00+08
 dn_1         | rhel_10_90_45_56 | 9.34600830078125e-05 | .000143659648687162 |        2 | 2022-11-07 09:20:00+08
 dn_1         | rhel_10_90_45_56 | 4.10079956054688e-05 | .000186667253592502 |        1 | 2022-11-07 09:30:00+08
 dn_1         | rhel_10_90_45_56 |     2048.17834663391 |    27.2766632219637 |        2 | 2022-11-22 16:10:00+08
 dn_1         | rhel_10_90_45_56 |     3747.23722648621 |    28.0842938534546 |        4 | 2022-11-22 16:20:00+08
(6 row)