postgresql:9.6
xlog 写入WAL buffer位置
select pg_current_xlog_insert_location();
xlog 写入WAL文件位置
select pg_current_xlog_location();
xlog 当前文件名
select pg_xlogfile_name(pg_current_xlog_location());
xlog文件名及十进制偏移量
select pg_xlogfile_name_offset(pg_current_xlog_location());
xlog buffer 未刷入磁盘byte
select pg_xlog_location_diff(pg_current_xlog_insert_location(),pg_current_xlog_location());