PostgreSQL lists and stops executing SQL statements

PostgreSQL lists SQL statements in progress

1. SELECT
2. Procpid,
3. Start,
4. Now ()-start AS lap,
5. Current_query
6. FROM
7. (SELECT
8. Backendid,
9. Pg_stat_get_backend_pid (S. backendid) AS procpid,
10. Pg_stat_get_backend_activity_start (S. backendid) AS start,
11. Pg_stat_get_backend_activity (S. backendid) AS current_query
12. FROM
13. (SELECT pg_stat_get_backend_idset () AS backendid) AS S
14. ) AS S
15. WHERE
16. Current_query <>'<IDLE>'
17. ORDER
18. Lap DESC;

Procpid: process id
Start: process start time
Lap: elapsed time
Current_query: SQL statement in execution

How to stop executing SQL statements
SELECT pg_cancel_backend (process id );

Or use system functions.

Kill-9 process id;