Procpid: Process idstart: process start time lap: elapsed time current_query: how to stop the SQL statement being executed sqlSELECTpg_cancel_backend (process id); or use the system function kill-9 process id; PostgreSQLSELECTprocpid, start, now ()
Procpid: process id start: process start time lap: elapsed time current_query: How to stop executing SQL SELECT pg_cancel_backend (process id ); or use the system function kill-9 process id; PostgreSQL SELECT procpid, start, now ()-start AS lap, current_query FROM
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;
PostgreSQL
SELECT procpid, start, now() - start AS lap, current_query FROM (SELECT backendid, pg_stat_get_backend_pid(S.backendid) AS procpid, pg_stat_get_backend_activity_start(S.backendid) AS start, pg_stat_get_backend_activity(S.backendid) AS current_query FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS S ) AS S WHERE current_query <> '
' ORDER BY lap DESC;