|
lication_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | waiting | current_query -------+----------+---------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------- -----------+-------------------------------+---------+--------------------------------- 12699 | postgres | 10918 | 10 | postgres | psql | | | -1 | 2013-12-03 15:25:12.613672+08 | 2013-12-03 15:30:29 .544088+08 | 2013-12-03 15:30:29.544088+08 | f | select * from pg_stat_activity; 通过以上实验理解起来应该 很简单了，procpid=10305在pg_cancel_backend()下，session还在，事物回退，在pg_terminate_backend()操作后，session消失，事物回退。如果在某些时候pg_terminate_backend()不能杀死session，那么可以在os层面，直接kill -9 pid
|