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';
Windows netstat -a -o -n -b | findstr "10.0.0.25" kill $process (last column) or check in TaskManager -> Processes -> Sort by ID Linux netstat -4 -6 -a -n -p
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
Комментарии
Отправить комментарий