pg_walinspect last query typo

On 25 May 2023, at 11:13, jian he <jian.universality@gmail.com> wrote:

hi.
https://www.postgresql.org/docs/current/pgwalinspect.html

last query should be:
SELECT * FROM pg_get_wal_stats('0/1E847D00', '0/1E84F500')
WHERE count > 0 AND
"resource_manager/record_type" = 'Transaction'
LIMIT 1;

Nice catch, the LIMIT 1 has indeed landed in the wrong place. Will fix.

--
Daniel Gustafsson