Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1mt6nw-0003d3-CY
	for pgsql-admin@arkaria.postgresql.org; Fri, 03 Dec 2021 11:32:40 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1mt6nv-0005In-8i
	for pgsql-admin@arkaria.postgresql.org; Fri, 03 Dec 2021 11:32:39 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <samed@reddoc.net>)
	id 1mt6nu-0005IY-Tb
	for pgsql-admin@lists.postgresql.org; Fri, 03 Dec 2021 11:32:38 +0000
Received: from forward500p.mail.yandex.net ([77.88.28.110])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <samed@reddoc.net>)
	id 1mt6nr-00071k-N1
	for pgsql-admin@lists.postgresql.org; Fri, 03 Dec 2021 11:32:37 +0000
Received: from myt5-36442628f0be.qloud-c.yandex.net
 (myt5-36442628f0be.qloud-c.yandex.net
 [IPv6:2a02:6b8:c12:1c0c:0:640:3644:2628])
	by forward500p.mail.yandex.net (Yandex) with ESMTP id AABA4F01EB2;
	Fri,  3 Dec 2021 14:32:31 +0300 (MSK)
Received: from 2a02:6b8:c12:259d:0:640:4218:ece6
 (2a02:6b8:c12:259d:0:640:4218:ece6 [2a02:6b8:c12:259d:0:640:4218:ece6])
	by myt5-36442628f0be.qloud-c.yandex.net (mxback/Yandex) with HTTP id
 UWNu4B1et8c1-WVeCTeIY;
	Fri, 03 Dec 2021 14:32:31 +0300
X-Yandex-Fwd: 1
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=reddoc.net; s=mail;
 t=1638531151;
	bh=KGJZFZpCvXHl34AFs+2GrARJHsnphkyqQfWK6wfOciA=;
	h=Message-Id:References:Date:Subject:In-Reply-To:To:From;
	b=QYLSSRSFFS40dEloaCS4m6WECrfOdgOZjYhkDeH7oAM0qs2vq25IzDSe9PxIPzfit
	 QsE6Fa+T8jGbEpKBB2Ruu6yhPGYb5r8IG3h3W7GTYwdEqetewCMjE9RLmvUbM857Gj
	 MTacyvwL/7dgAUbvu513TNs5hQoL3WkUA61W7NVs=
Authentication-Results: myt5-36442628f0be.qloud-c.yandex.net;
 dkim=pass header.i=@reddoc.net
Received: by myt6-4218ece6190d.qloud-c.yandex.net with HTTP;
	Fri, 03 Dec 2021 14:32:31 +0300
From: Samed YILDIRIM <samed@reddoc.net>
To: liam saffioti <liam.saffiotti@gmail.com>,
	pgsql-admin <pgsql-admin@lists.postgresql.org>,
	Julien Rouhaud <rjuju123@gmail.com>
In-Reply-To: 
 <CAGHjuaZkGZVRK6OC4ifBJVQ+=1Y=0CXdDnZ7sjHkdfY2wkACVg@mail.gmail.com>
References: 
 <CAGHjuaZkGZVRK6OC4ifBJVQ+=1Y=0CXdDnZ7sjHkdfY2wkACVg@mail.gmail.com>
Subject: Re: postgresql long running query
MIME-Version: 1.0
X-Mailer: Yamail [ http://yandex.ru ] 5.0
Date: Fri, 03 Dec 2021 14:32:31 +0300
Message-Id: <1421201638531123@mail.yandex.com.tr>
Content-Transfer-Encoding: base64
Content-Type: text/html; charset=utf-8
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/1421201638531123%40mail.yandex.com.tr>
Precedence: bulk

PGRpdj48ZGl2PkhlbGxvIExpYW0sPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+LSBIYXZlIHlvdSBj
aGVja2VkIGxvZ3MgdG8gc2VlIHdoYXQgaGFwcGVuZWQgaW4gdGhlIG1vcm5pbmc/PC9kaXY+PGRp
dj4tIElzIHRoZSBsb2dfbG9ja193YWl0cyBwYXJhbWV0ZXIgZW5hYmxlZD88L2Rpdj48ZGl2Pi0g
V2hhdCBwb3N0Z3JlcyB2ZXJzaW9uIGRvIHlvdSB1c2U/PC9kaXY+PGRpdj4tIElzIDQzIG1pbiAx
MSBzZWNvbmRzIHRvdGFsIGR1cmF0aW9uIG9yIG1heCBkdXJhdGlvbj88L2Rpdj48L2Rpdj48ZGl2
PsKgPC9kaXY+PGRpdj5CZXN0IHJlZ2FyZHMuPC9kaXY+PGRpdj5TYW1lZCBZSUxESVJJTTwvZGl2
PjxkaXY+wqA8L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+MDMuMTIuMjAyMSwg
MTQ6MjQsICJsaWFtIHNhZmZpb3RpIiAmbHQ7bGlhbS5zYWZmaW90dGlAZ21haWwuY29tJmd0Ozo8
L2Rpdj48YmxvY2txdW90ZT48ZGl2PjxkaXY+SGVsbG8gVGVhbSw8ZGl2PsKgPC9kaXY+PGRpdj5J
IGhhdmUgYSBwcm9ibGVtIHdpdGggYSBxdWVyeSB0aGF0IGNvbnN1bWVzIGEgbG9uZyB0aW1lLsKg
PC9kaXY+PGRpdj5UaGUgcXVlcnknIGV4ZWN1dGlvbiBwbGFuIGlzIDo8L2Rpdj48ZGl2PsKgPC9k
aXY+PGRpdj7CoDwvZGl2PjxkaXY+RVhQTEFJTiBBTkFMWVpFIFNFTEVDVCB4LiJIaXN0b3J5SWQi
LCB4LiJTbGFEZWZpbml0aW9uIiBGUk9NICJUX0NNTl9TTEFISVNUT1JZIiBBUyB4IFdIRVJFIHgu
IkRlZmluaXRpb25JZCIgPSAnMzAyJzs8YnIgLz7CoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC
oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC
oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCBRVUVSWSBQTEFOIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg
IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg
IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgPGJyIC8+LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS08YnIgLz7CoEJpdG1hcCBIZWFwIFNjYW4gb24gIlRfQ01OX1NMQUhJ
U1RPUlkiIHggwqAoY29zdD0yMTQ0Ljc3Li4zNTA4Ni40MiByb3dzPTEzOTAxMiB3aWR0aD04KSAo
YWN0dWFsIHRpbWU9NTguODA2Li4xMTYuODc0IHJvd3M9MTM1NDk4IGxvb3BzPTEpPGJyIC8+wqAg
wqBSZWNoZWNrIENvbmQ6ICgiRGVmaW5pdGlvbklkIiA9IDMwMik8YnIgLz7CoCDCoEhlYXAgQmxv
Y2tzOiBleGFjdD0yMTc1PGJyIC8+wqAgwqAtJmd0OyDCoEJpdG1hcCBJbmRleCBTY2FuIG9uICJJ
bmRleC0yMDE4MDcxMi0xOTI3MzkiIMKgKGNvc3Q9MC4wMC4uMjExMC4wMiByb3dzPTEzOTAxMiB3
aWR0aD0wKSAoYWN0dWFsIHRpbWU9NTcuMDQzLi41Ny4wNDUgcm93cz0xMzU0OTggbG9vcHM9MSk8
YnIgLz7CoCDCoCDCoCDCoCDCoEluZGV4IENvbmQ6ICgiRGVmaW5pdGlvbklkIiA9IDMwMik8YnIg
Lz7CoFBsYW5uaW5nIFRpbWU6IDExLjEzMiBtczxiciAvPsKgRXhlY3V0aW9uIFRpbWU6IDEyMC4z
MjAgbXM8L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PkJ1
dCwgdGhlIHF1ZXJ5IGV4ZWN1dGlvbiB0aW1lIHdhcyA0M21pbiAxMXNlY29uZHMgaW4gdGhlIG1v
cm5pbmcgaW4gcGdiYWRnZXIgcmVwb3J0LsKgSSBkb24ndCB1bmRlcnN0YW5kIHdoeSB0aGUgcXVl
cnkgaXMgdGFraW5nIHNvIGxvbmcuIENhbiB5b3UgZ3VpZGUgbWU/PC9kaXY+PGRpdj7CoDwvZGl2
PjxkaXY+VGhhbmsgeW91IHNvIG11Y2guPC9kaXY+PGRpdj7CoDwvZGl2PjwvZGl2PjwvZGl2Pjwv
YmxvY2txdW90ZT4=