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 ) id 1n9T3X-0005Z5-Uo for pgsql-admin@arkaria.postgresql.org; Mon, 17 Jan 2022 14:32:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n9T3W-0005II-Mx for pgsql-admin@arkaria.postgresql.org; Mon, 17 Jan 2022 14:32:22 +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 ) id 1n9SBb-0007JS-UO for pgsql-admin@lists.postgresql.org; Mon, 17 Jan 2022 13:36:40 +0000 Received: from mtav7-2.ac-toulouse.fr ([194.214.242.24]) by makus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n9SBY-0007iC-LU for pgsql-admin@postgresql.org; Mon, 17 Jan 2022 13:36:38 +0000 Received: from sysres-msg-imsva-1.in.ac-toulouse.fr (f5-vlan-430-dmz-repart.in.ac-toulouse.fr [192.168.99.126]) by mtav7-2.ac-toulouse.fr (Postfix) with ESMTP id 8F1FC2E250D; Mon, 17 Jan 2022 14:36:34 +0100 (CET) Received: from sysres-msg-imsva-1.in.ac-toulouse.fr (unknown [127.0.0.1]) by IMSVA (Postfix) with ESMTP id 808766004D; Mon, 17 Jan 2022 14:36:34 +0100 (CET) Received: from sysres-msg-imsva-1.in.ac-toulouse.fr (unknown [127.0.0.1]) by IMSVA (Postfix) with ESMTP id 6C1D960051; Mon, 17 Jan 2022 14:36:34 +0100 (CET) Received: from mtav7-2.in.ac-toulouse.fr (unknown [192.168.99.126]) by sysres-msg-imsva-1.in.ac-toulouse.fr (Postfix) with ESMTP; Mon, 17 Jan 2022 14:36:34 +0100 (CET) Received: from msg-dag-2.academie.in.ac-toulouse.fr (sysres-msg-dag-2.in.ac-toulouse.fr [172.29.240.96]) by mtav7-2.in.ac-toulouse.fr (Postfix) with ESMTP id 4BD991103E8; Mon, 17 Jan 2022 14:36:34 +0100 (CET) DKIM-Filter: OpenDKIM Filter v2.11.0 mtav7-2.in.ac-toulouse.fr 4BD991103E8 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ac-toulouse.fr; s=mail; t=1642426657; bh=CgJ4OC8WRM2i+NTAFVTzw5xKv2ljncO02K6PFEA5x9U=; h=From:To:Subject:Date:Message-ID:Content-Type; b=eXcQwhnhY059LNhsp0Od/t+VsyOxBptcEVvzW58q/ippHh8MItTl5aRZ7JGNTyqmu I/AtQAxX8m6rHL6xE9AnJhwQ9teq4mTR6LxO4Wjb2Krg2zeIFs57LZgS9wyFoU/Q2u sr98dBgqkNyGyIRGSSjJsGfSd9WzeJFA7kDQ8BnE= Received: from msg-dag-1.academie.in.ac-toulouse.fr (172.29.240.95) by msg-dag-2.academie.in.ac-toulouse.fr (172.29.240.96) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256) id 15.1.2308.20; Mon, 17 Jan 2022 14:36:34 +0100 Received: from msg-dag-1.academie.in.ac-toulouse.fr ([fe80::6156:eeea:10de:307f]) by msg-dag-1.academie.in.ac-toulouse.fr ([fe80::6156:eeea:10de:307f%2]) with mapi id 15.01.2308.020; Mon, 17 Jan 2022 14:36:33 +0100 From: Halat-Pruvot Sylvie To: liam saffioti CC: "pgsql-admin@postgresql.org" Subject: RE: postgresql wait event and high active connection Thread-Topic: postgresql wait event and high active connection Thread-Index: AQHX8xcoQXa2oh8w3EiBRYJsCQJy26xnV4bg Date: Mon, 17 Jan 2022 13:36:33 +0000 Message-ID: References: In-Reply-To: Accept-Language: fr-FR, en-US Content-Language: fr-FR X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [192.168.99.247] Content-Type: multipart/alternative; boundary="_000_cf9694ae15e44171aaee9b88d972b6fbactoulousefr_" MIME-Version: 1.0 X-TM-AS-GCONF: 00 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_cf9694ae15e44171aaee9b88d972b6fbactoulousefr_ Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 SGVsbG8gTGlhbSwNCg0KSSBoYXZlIHRoZSBzYW1lIGlzc3VlIHdpdGggMzUwIGFjdGl2ZSBjb25u ZXhpb25zIGFuZCBoYXZlIHlvdSBmaW5kIGEgcGFyYW1ldGVyIHNvbHZpbmcgdGhpcyA/DQoNClRo YW5rcw0KQmVzdCByZWdhcmRzDQpTeWx2aWUNCg0KRGUgOiBsaWFtIHNhZmZpb3RpIDxsaWFtLnNh ZmZpb3R0aUBnbWFpbC5jb20+DQpFbnZvecOpIDogdmVuZHJlZGkgMTcgZMOpY2VtYnJlIDIwMjEg MDg6MjQNCsOAIDogcGdzcWwtYWRtaW5AcG9zdGdyZXNxbC5vcmcNCk9iamV0IDogcG9zdGdyZXNx bCB3YWl0IGV2ZW50IGFuZCBoaWdoIGFjdGl2ZSBjb25uZWN0aW9uDQoNCkhlbGxvIHRlYW0sDQpJ IGhhdmUgYSBwcm9ibGVtIHdpdGggdGhlIG51bWJlciBvZiBhY3RpdmUgY29ubmVjdGlvbnMuIFRo ZXJlIGFyZSBtb3JlIHRoYW4gMzAwIGFjdGl2ZSBjb25uZWN0aW9ucyBpbiB0aGUgZGF0YWJhc2Ug Y3VycmVudGx5LiBXaGVuIEkgY2hlY2tlZCwgbW9zdCBjb25uZWN0aW9ucyBhcmUgd2FpdGluZyBh cyBidWZmZXJfbWFwcGluZy4gKHdhaXRfZXZlbnQpLiBUaGlzIHByb2JsZW0gaGFwcGVucyBmcm9t IHRpbWUgdG8gdGltZSwgaXQncyBub3QgYSBjb25zdGFudCBwcm9ibGVtLg0KDQpDYW4geW91IGhl bHAgbWUgZmlndXJlIG91dCB3aHkgdGhlIHByb2JsZW0gaXMgb2NjdXJyaW5nPw0KSSBjYW4gc2Vu ZCB5b3UgYW55IG90aGVyIGluZm9ybWF0aW9uIHlvdSB3YW50IGFib3V0IHRoZSBkYXRhYmFzZS4N Cg0KVGhhbmsgeW91IGZvciB5b3VyIGhlbHAsDQpCZXN0LA0KTGlhbQ0K --_000_cf9694ae15e44171aaee9b88d972b6fbactoulousefr_ Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: base64 PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVy bjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIgeG1sbnM6dz0idXJuOnNjaGVt YXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6d29yZCIgeG1sbnM6bT0iaHR0cDovL3NjaGVtYXMubWlj cm9zb2Z0LmNvbS9vZmZpY2UvMjAwNC8xMi9vbW1sIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcv VFIvUkVDLWh0bWw0MCI+DQo8aGVhZD4NCjxtZXRhIGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSIg Y29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PXV0Zi04Ij4NCjxtZXRhIG5hbWU9IkdlbmVyYXRv ciIgY29udGVudD0iTWljcm9zb2Z0IFdvcmQgMTUgKGZpbHRlcmVkIG1lZGl1bSkiPg0KPHN0eWxl PjwhLS0NCi8qIEZvbnQgRGVmaW5pdGlvbnMgKi8NCkBmb250LWZhY2UNCgl7Zm9udC1mYW1pbHk6 IkNhbWJyaWEgTWF0aCI7DQoJcGFub3NlLTE6MiA0IDUgMyA1IDQgNiAzIDIgNDt9DQpAZm9udC1m YWNlDQoJe2ZvbnQtZmFtaWx5OkNhbGlicmk7DQoJcGFub3NlLTE6MiAxNSA1IDIgMiAyIDQgMyAy IDQ7fQ0KLyogU3R5bGUgRGVmaW5pdGlvbnMgKi8NCnAuTXNvTm9ybWFsLCBsaS5Nc29Ob3JtYWws IGRpdi5Nc29Ob3JtYWwNCgl7bWFyZ2luOjBjbTsNCgltYXJnaW4tYm90dG9tOi4wMDAxcHQ7DQoJ Zm9udC1zaXplOjEyLjBwdDsNCglmb250LWZhbWlseToiVGltZXMgTmV3IFJvbWFuIixzZXJpZjt9 DQphOmxpbmssIHNwYW4uTXNvSHlwZXJsaW5rDQoJe21zby1zdHlsZS1wcmlvcml0eTo5OTsNCglj b2xvcjojMDU2M0MxOw0KCXRleHQtZGVjb3JhdGlvbjp1bmRlcmxpbmU7fQ0KYTp2aXNpdGVkLCBz cGFuLk1zb0h5cGVybGlua0ZvbGxvd2VkDQoJe21zby1zdHlsZS1wcmlvcml0eTo5OTsNCgljb2xv cjojOTU0RjcyOw0KCXRleHQtZGVjb3JhdGlvbjp1bmRlcmxpbmU7fQ0KcC5tc29ub3JtYWwwLCBs aS5tc29ub3JtYWwwLCBkaXYubXNvbm9ybWFsMA0KCXttc28tc3R5bGUtbmFtZTptc29ub3JtYWw7 DQoJbXNvLW1hcmdpbi10b3AtYWx0OmF1dG87DQoJbWFyZ2luLXJpZ2h0OjBjbTsNCgltc28tbWFy Z2luLWJvdHRvbS1hbHQ6YXV0bzsNCgltYXJnaW4tbGVmdDowY207DQoJZm9udC1zaXplOjEyLjBw dDsNCglmb250LWZhbWlseToiVGltZXMgTmV3IFJvbWFuIixzZXJpZjt9DQpzcGFuLkVtYWlsU3R5 bGUxOA0KCXttc28tc3R5bGUtdHlwZTpwZXJzb25hbC1yZXBseTsNCglmb250LWZhbWlseToiQ2Fs aWJyaSIsc2Fucy1zZXJpZjsNCgljb2xvcjojMUY0OTdEO30NCi5Nc29DaHBEZWZhdWx0DQoJe21z by1zdHlsZS10eXBlOmV4cG9ydC1vbmx5Ow0KCWZvbnQtc2l6ZToxMC4wcHQ7DQoJZm9udC1mYW1p bHk6IkNhbGlicmkiLHNhbnMtc2VyaWY7DQoJbXNvLWZhcmVhc3QtbGFuZ3VhZ2U6RU4tVVM7fQ0K QHBhZ2UgV29yZFNlY3Rpb24xDQoJe3NpemU6NjEyLjBwdCA3OTIuMHB0Ow0KCW1hcmdpbjo3MC44 NXB0IDcwLjg1cHQgNzAuODVwdCA3MC44NXB0O30NCmRpdi5Xb3JkU2VjdGlvbjENCgl7cGFnZTpX b3JkU2VjdGlvbjE7fQ0KLS0+PC9zdHlsZT48IS0tW2lmIGd0ZSBtc28gOV0+PHhtbD4NCjxvOnNo YXBlZGVmYXVsdHMgdjpleHQ9ImVkaXQiIHNwaWRtYXg9IjEwMjYiIC8+DQo8L3htbD48IVtlbmRp Zl0tLT48IS0tW2lmIGd0ZSBtc28gOV0+PHhtbD4NCjxvOnNoYXBlbGF5b3V0IHY6ZXh0PSJlZGl0 Ij4NCjxvOmlkbWFwIHY6ZXh0PSJlZGl0IiBkYXRhPSIxIiAvPg0KPC9vOnNoYXBlbGF5b3V0Pjwv eG1sPjwhW2VuZGlmXS0tPg0KPC9oZWFkPg0KPGJvZHkgbGFuZz0iRlIiIGxpbms9IiMwNTYzQzEi IHZsaW5rPSIjOTU0RjcyIj4NCjxkaXYgY2xhc3M9IldvcmRTZWN0aW9uMSI+DQo8cCBjbGFzcz0i TXNvTm9ybWFsIj48c3BhbiBzdHlsZT0iZm9udC1zaXplOjExLjBwdDtmb250LWZhbWlseTomcXVv dDtDYWxpYnJpJnF1b3Q7LHNhbnMtc2VyaWY7Y29sb3I6IzFGNDk3RDttc28tZmFyZWFzdC1sYW5n dWFnZTpFTi1VUyI+SGVsbG8gTGlhbSw8bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFzcz0i TXNvTm9ybWFsIj48c3BhbiBzdHlsZT0iZm9udC1zaXplOjExLjBwdDtmb250LWZhbWlseTomcXVv dDtDYWxpYnJpJnF1b3Q7LHNhbnMtc2VyaWY7Y29sb3I6IzFGNDk3RDttc28tZmFyZWFzdC1sYW5n dWFnZTpFTi1VUyI+PG86cD4mbmJzcDs8L286cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05v cm1hbCI+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMS4wcHQ7Zm9udC1mYW1pbHk6JnF1b3Q7Q2Fs aWJyaSZxdW90OyxzYW5zLXNlcmlmO2NvbG9yOiMxRjQ5N0Q7bXNvLWZhcmVhc3QtbGFuZ3VhZ2U6 RU4tVVMiPkkgaGF2ZSB0aGUgc2FtZSBpc3N1ZSB3aXRoIDM1MCBhY3RpdmUgY29ubmV4aW9ucyBh bmQgaGF2ZSB5b3UgZmluZCBhIHBhcmFtZXRlciBzb2x2aW5nIHRoaXMgPzxvOnA+PC9vOnA+PC9z cGFuPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJmb250LXNpemU6MTEu MHB0O2ZvbnQtZmFtaWx5OiZxdW90O0NhbGlicmkmcXVvdDssc2Fucy1zZXJpZjtjb2xvcjojMUY0 OTdEO21zby1mYXJlYXN0LWxhbmd1YWdlOkVOLVVTIj48bzpwPiZuYnNwOzwvbzpwPjwvc3Bhbj48 L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0iZm9udC1zaXplOjExLjBwdDtm b250LWZhbWlseTomcXVvdDtDYWxpYnJpJnF1b3Q7LHNhbnMtc2VyaWY7Y29sb3I6IzFGNDk3RDtt c28tZmFyZWFzdC1sYW5ndWFnZTpFTi1VUyI+VGhhbmtzPG86cD48L286cD48L3NwYW4+PC9wPg0K PHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMS4wcHQ7Zm9udC1m YW1pbHk6JnF1b3Q7Q2FsaWJyaSZxdW90OyxzYW5zLXNlcmlmO2NvbG9yOiMxRjQ5N0Q7bXNvLWZh cmVhc3QtbGFuZ3VhZ2U6RU4tVVMiPkJlc3QgcmVnYXJkczxvOnA+PC9vOnA+PC9zcGFuPjwvcD4N CjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJmb250LXNpemU6MTEuMHB0O2ZvbnQt ZmFtaWx5OiZxdW90O0NhbGlicmkmcXVvdDssc2Fucy1zZXJpZjtjb2xvcjojMUY0OTdEO21zby1m YXJlYXN0LWxhbmd1YWdlOkVOLVVTIj5TeWx2aWU8bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBj bGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0iZm9udC1zaXplOjExLjBwdDtmb250LWZhbWls eTomcXVvdDtDYWxpYnJpJnF1b3Q7LHNhbnMtc2VyaWY7Y29sb3I6IzFGNDk3RDttc28tZmFyZWFz dC1sYW5ndWFnZTpFTi1VUyI+PG86cD4mbmJzcDs8L286cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9 Ik1zb05vcm1hbCI+PGI+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMS4wcHQ7Zm9udC1mYW1pbHk6 JnF1b3Q7Q2FsaWJyaSZxdW90OyxzYW5zLXNlcmlmIj5EZSZuYnNwOzo8L3NwYW4+PC9iPjxzcGFu IHN0eWxlPSJmb250LXNpemU6MTEuMHB0O2ZvbnQtZmFtaWx5OiZxdW90O0NhbGlicmkmcXVvdDss c2Fucy1zZXJpZiI+IGxpYW0gc2FmZmlvdGkgJmx0O2xpYW0uc2FmZmlvdHRpQGdtYWlsLmNvbSZn dDsNCjxicj4NCjxiPkVudm95w6kmbmJzcDs6PC9iPiB2ZW5kcmVkaSAxNyBkw6ljZW1icmUgMjAy MSAwODoyNDxicj4NCjxiPsOAJm5ic3A7OjwvYj4gcGdzcWwtYWRtaW5AcG9zdGdyZXNxbC5vcmc8 YnI+DQo8Yj5PYmpldCZuYnNwOzo8L2I+IHBvc3RncmVzcWwgd2FpdCBldmVudCBhbmQgaGlnaCBh Y3RpdmUgY29ubmVjdGlvbjxvOnA+PC9vOnA+PC9zcGFuPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3Jt YWwiPjxvOnA+Jm5ic3A7PC9vOnA+PC9wPg0KPGRpdj4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPkhl bGxvIHRlYW0sPG86cD48L286cD48L3A+DQo8ZGl2Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+SSBo YXZlIGEgcHJvYmxlbSB3aXRoIHRoZSBudW1iZXIgb2YgYWN0aXZlIGNvbm5lY3Rpb25zLiBUaGVy ZSBhcmUgbW9yZSB0aGFuIDMwMCBhY3RpdmUgY29ubmVjdGlvbnMgaW4gdGhlIGRhdGFiYXNlIGN1 cnJlbnRseS4mbmJzcDtXaGVuIEkgY2hlY2tlZCwgbW9zdCBjb25uZWN0aW9ucyBhcmUgd2FpdGlu ZyBhcyBidWZmZXJfbWFwcGluZy4gKHdhaXRfZXZlbnQpLiZuYnNwO1RoaXMgcHJvYmxlbSBoYXBw ZW5zIGZyb20gdGltZSB0bw0KIHRpbWUsIGl0J3Mgbm90IGEgY29uc3RhbnQgcHJvYmxlbS48bzpw PjwvbzpwPjwvcD4NCjwvZGl2Pg0KPGRpdj4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxvOnA+Jm5i c3A7PC9vOnA+PC9wPg0KPC9kaXY+DQo8ZGl2Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+Q2FuIHlv dSBoZWxwIG1lIGZpZ3VyZSBvdXQgd2h5IHRoZSBwcm9ibGVtIGlzIG9jY3VycmluZz88bzpwPjwv bzpwPjwvcD4NCjwvZGl2Pg0KPGRpdj4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPkkgY2FuIHNlbmQg eW91IGFueSBvdGhlciBpbmZvcm1hdGlvbiB5b3Ugd2FudCBhYm91dCB0aGUgZGF0YWJhc2UuPG86 cD48L286cD48L3A+DQo8L2Rpdj4NCjxkaXY+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48bzpwPiZu YnNwOzwvbzpwPjwvcD4NCjwvZGl2Pg0KPGRpdj4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPlRoYW5r IHlvdSBmb3IgeW91ciBoZWxwLDxvOnA+PC9vOnA+PC9wPg0KPC9kaXY+DQo8ZGl2Pg0KPHAgY2xh c3M9Ik1zb05vcm1hbCI+QmVzdCw8bzpwPjwvbzpwPjwvcD4NCjwvZGl2Pg0KPGRpdj4NCjxwIGNs YXNzPSJNc29Ob3JtYWwiPkxpYW08bzpwPjwvbzpwPjwvcD4NCjwvZGl2Pg0KPC9kaXY+DQo8L2Rp dj4NCjwvYm9keT4NCjwvaHRtbD4NCg== --_000_cf9694ae15e44171aaee9b88d972b6fbactoulousefr_--