К основному контенту

PostgreSQL get WAL name by LSN


select pg_walfile_name('1B60/BAFCE900')

select pg_walfile_name(sent_lsn), pg_walfile_name(write_lsn), * from pg_stat_replication

select * from pg_ls_waldir() where name = '000000010000000000000033';

Комментарии

Популярные сообщения из этого блога

Repeat Linux command every x seconds

watch -n 5 "ps -ef | grep COPY" watch -n 10 "psql -U postgres -c \"select clock_timestamp() - query_start as duration, substr(query,1,50) from pg_stat_activity where pid <> pg_backend_pid() and state='active' order by 1 desc\"" for i in {1..10}; do ps -ef | grep COPY; date ; sleep 5; done while true; do ps -ef | grep COPY ; date ; sleep 5; done