Greenplum Process Session Management Chapter

--1. Querying the active session under the specified library, the Procpid field represents the session proc  select * from pg_stat_activity where datname = ' dbname ';    --2. Interrupt query, ${procpid} indicates that the above query corresponds to the procpid, the same as  select Pg_cancel_backend (${procpid});     --3. Interrupt session Connection  Select Pg_terminate_backend (${procpid});     --4. If you need to terminate or disconnect a connection session in bulk, you can write a function or simply piece it together and perform it manually, such as:  select ' Select Pg_terminate_backend (' | | procpid| | '); ', * from pg_stat_activity where datname = ' dbname ';    Select ' Select Pg_cancel_backend (' | | procpid| | '); ', * from pg_stat_activity where datname = ' dbname ';  

　　

Greenplum Process Session Management Chapter