Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to kill the executing sql statement in PostgreSql". In the daily operation, I believe that many people have doubts about how to kill the executing sql statement in PostgreSql. The editor consulted all kinds of information and sorted out a simple and useful method of operation. I hope it will be helpful to answer the question of "how to kill the executing sql statement in PostgreSql". Next, please follow the editor to study!

Although you can use kill-9 to force the deletion of user processes, it is not recommended.

Because: for statements that execute update, kill drops the process, which may cause Postgres to enter the recovery mode

Under recovery mode, tables are locked and database links are not allowed.

In general: use the following statement

= # select datname,procpid,query_start,current_query,waiting,client_addr from pg_stat_activity where waiting='t'

To see which SQL is being executed.

Through the command:

= # select pg_cancel_backend (thread id)

To kill the specified SQL statement.

(this function can only be queried by kill Select, but updae,delete DML does not take effect.)

Use

= # select pg_terminate_backend (pid int)

You can kill various DML (SELECT,UPDATE,DELETE,DROP) operations

At this point, the study of "how to kill the executing sql statement in PostgreSql" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.