DEFINITIONS

Definitions More Info.
Definition ID852
TitlePOSTGRESQL
CategoryNOTES
DefinitionKill only one session
Definition Descriptionhttps://stackoverflow.com/questions/35319597/how-to-stop-kill-a-query-in-postgresql
Find the process you want to kill 9.1 de
select * from pg_stat_activity

9.1 den sonra
SELECT
*
FROM
pg_stat_activity
WHERE
state = 'active';

TO kill type:
SELECT
pg_cancel_backend( 9646 )

If the process cannot be killed, try:

SELECT
pg_terminate_backend()
RecordBycunay
Record Date27-06-2018 21:30:48
Düzenle
Kopyala
Sil