【翻译】我是如何学会使用 wal_inspect 的

注意： 需要pg的版本是15或者以上

-- 需要先切换到对应的数据库里去安装扩展
create extension  pg_walinspect;

select pg_current_wal_insert_lsn(); 
记下这里的值，假设是 '17797/A167C8E8' 

select pg_current_wal_insert_lsn() 
记下这里的值，假设是 '17797/FEDE0CC8'


-- 使用pg_get_wal_stats函数检查下这段LSN内的WAL记录
select * from  pg_get_wal_stats('17797/A167C8E8', '17797/FEDE0CC8', true);  

select * from pg_get_wal_records_info('17797/A167C8E8', '17797/FEDE0CC8')
where 
resource_manager='Heap'
and record_type='LOCK';

select * from pg_class where oid =10229951;

或
SELECT
    c.oid,
    current_database() AS database_name,
    n.nspname AS schema_name,
    c.relname AS table_name,
    c.relkind
FROM
    pg_class c
JOIN
    pg_namespace n ON c.relnamespace = n.oid
WHERE
    -- c.relkind = 'r'  -- 只查询普通表
    -- AND n.nspname NOT LIKE 'pg_%'
    -- AND n.nspname != 'information_schema'
    c.oid =10229951
ORDER BY
    n.nspname,
    c.relname;

select * from this_customer_logs.this_database_log_t_2025_07_25 
where query like '%this_table_name%';