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

时间：2023-11-22 14:18:32

应用示例

查询集群当前正在执行的语句，以及这些语句分别产生的wal日志的总量和平均速率、数据页总量和平均速率，以及这些信息各自DN上的分布情况。

SELECT * FROM PGXC_STAT_WAL;
     query_id      |          query_start          | global_wal | global_avg_wal_speed | global_datapage | global_avg_datapage_speed | min_wal_node | min_wal  | max_wal_node | max_wal  | min_datapage_node | min_data_page | max_datapage_node | max_data_page | avg_wal_per_node |
avg_datapage_per_node |                    query
-------------------+-------------------------------+------------+----------------------+-----------------+---------------------------+--------------+----------+--------------+----------+-------------------+---------------+-------------------+---------------+------------------+-
----------------------+----------------------------------------------
 72620543991351767 | 2022-11-10 16:49:47.743291+08 |    7579052 |               419000 |       284057600 |                  15740000 | datanode1    |  7579052 | datanode1    |  7579052 | datanode1         |     284057600 | datanode1         |     284057600 |          7579052 |
            284057600 | insert into mpptest3 select * from mpptest3;
 72620543991351781 | 2022-11-10 16:50:00.616697+08 |   55022176 |             10638000 |               0 |                         0 | datanode1    | 55022176 | datanode1    | 55022176 | datanode1         |             0 | datanode1         |             0 |         55022176 |
                    0 | insert into mpptest1 select * from mpptest1;
(2 rows)