目录

pg_wal_summary_contents()

显示WAL摘要内容的函数

pg_wal_summary_contents() 是一个用于显示WAL摘要详细信息的系统函数。

pg_wal_summary_contents() 在 PostgreSQL 17 中引入。

用法

pg_wal_summary_contents ( tli bigint, start_lsn pg_lsn, end_lsn pg_lsn ) → 
        setof record ( relfilenode oid, 
                       reltablespace oid,
                       reldatabase oid,
                       relforknumber smallint,
                       relblocknumber bigint,
                       is_limit_block boolean )

变更历史

示例

pg_wal_summary_contents() 的基本用法示例

postgres=# SELECT * FROM pg_available_wal_summaries() LIMIT 1;
 tli | start_lsn |  end_lsn  
-----+-----------+-----------
   1 | 0/14F3F40 | 0/14F4290
(1 row)

postgres=# SELECT * FROM pg_wal_summary_contents(1, '0/14F3F40', '0/14F4290');
 relfilenode | reltablespace | reldatabase | relforknumber | relblocknumber | is_limit_block 
-------------+---------------+-------------+---------------+----------------+----------------
        2396 |          1664 |           0 |             0 |              0 | f
        2397 |          1664 |           0 |             0 |              1 | f
(2 rows)

分类

系统函数、WAL

另请参阅

pg_available_wal_summaries(), pg_get_wal_summarizer_state(), summarize_wal, wal_summary_keep_time

反馈

就“pg_wal_summary_contents()”提交任何评论、建议或更正，请在此处 提交。