> On 25 May 2023, at 11:13, jian he <jian.universal...@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