## pg_stat_wal_receiver视图 pg_stat_wal_receiver视图只包含一行,显示来自该接收器连接的服务器 WAL 接收器的统计信息。(The pg_stat_wal_receiver view will contain only one row, showing statistics about the WAL receiver from that receiver's connected server.) pg_stat_wal_receiver视图定义如下...
pg_stat_wal_write() 描述:在CN或者DN上执行,记录当前实例的线程信息,并统计wal日志和数据页导入量及速率,这里以CN为例。 该函数仅8.2.0及以上集群版本支持。 返回值类型:
>> >> ``` >> postgres=# SELECT * from pg_stat_wal; >> -[ RECORD 1 ]---+--- >> wal_records | 2000224 >> wal_fpi | 47 >> wal_bytes | 248216337 >> wal_buffers_full | 20954 >> wal_init_file | 8 >> wal_write_backend | 20960 >> wal_write_walwriter | 46 >> wal_w...
> > pg_stat_io and pg_stat_wal respectively. > > > > This makes me think if we need to add WAL read I/O stats also to > > pg_stat_wal. Then, we can also add WALReadFromBuffers stats > > hits/misses there. With this approach, pg_stat_wal can be a one-stop > > view f...