【PG】复制槽相关处理

 --查询复制槽使用情况
  select * from pg_replication_slots;

 --删除复制槽
--    SELECT pg_drop_replication_slot('pg_delete_bms_sa_settle_doc');  

-- 告知pg主动清理归档

CHECKPOINT
 -- 查询各flink任务的磁盘占用情况

select pg_size_pretty(pg_wal_lsn_diff(master_lsn, a.restart_lsn)) as latency ,* from pg_replication_slots a, pg_current_wal_lsn() as master_lsn order by latency asc;

-- 查看表OID，对应的是pg的base目录下的归档文件名称
SELECT oid, relname FROM pg_class WHERE relkind = 'r' and oid= '220596';