Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qeDxG-006AFv-0Z for psycopg@arkaria.postgresql.org; Thu, 07 Sep 2023 12:17:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qeDxE-001jlp-CM for psycopg@arkaria.postgresql.org; Thu, 07 Sep 2023 12:17:48 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qeDxD-001jlX-W3 for psycopg@lists.postgresql.org; Thu, 07 Sep 2023 12:17:47 +0000 Received: from mail-dbaeur03on2058.outbound.protection.outlook.com ([40.107.104.58] helo=EUR03-DBA-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qeDxA-003fWy-0z for psycopg@postgresql.org; Thu, 07 Sep 2023 12:17:46 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=QfIlO224X029b2d3gEiej8iC0qeeXN+AZhnPEiLhsoy2qnTX+bwkYxXn2wrom00KMSdUuQqqCZorIi7X5uv1lxHm5ZiT4HUcigPNau8wTpDvpu5sFh6rjhIApsRvQ0/sFpxKOubuQfr0z3+w40DpqlAGkY99cX2g/yChO+NLTQQhjHxWJxCPdp6PzlfGLHkc7BbaO/A+DNA/pY7DxzCae4OYQW9LVbZ33KfTx7Jms3k0sjv8IDkCNe/fTFGx4wI3AsMG46Haij4U6ly9z0wPoGROjXKdOZWCquAZtvWdBgDo+EyFzSomOoPACx3l6noHjEDaoTlqdHjPf4VUsmSKfw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=55AV9ijP6CXh9jmSBMZQjZZpz4O0RikBCUw3xWMRDgs=; b=E+rsTCsVbvZ5eCDUI2oYOjn5Kp7IkSpGf+qFI6zwwSO3E/35CV/TN/jL10Ysx7Xp2NKUEbzRSIveV4HS+ZmfnFE6fKrfplBGg9flk/JENshEqwFx9w8uK2HD4c4Ipbm+Xaby8o+uCQ37HJj10x1WBRrukCrHa/RvHbmGzLNh3vzBLqxsSp+uTtce1dEyjjNJxMp76y478khj0i8mci60uIiBzSfK8SqHl184p7e3rSSxNdSsZQA7p+eo+Y9+Nq8au6cCJaPAz840RSEbMZ6GJ0oDihQN2nqWzGu5lold/rDPUbcU683Nbv9bC5qXw7yqNQQoi3yteelT4UTtqkSrkQ== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=tomtom.com; dmarc=pass action=none header.from=tomtom.com; dkim=pass header.d=tomtom.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=tomtom.com; s=selector2; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=55AV9ijP6CXh9jmSBMZQjZZpz4O0RikBCUw3xWMRDgs=; b=Ns43LURjMecmDIV+gSdjngd9hFzyoT/IwFEDzBcaII/a/ESrXXiDvY6QnVOzQYrwFzlBQ2oTCzT0vgtZItBsPTqC+UlFFcDlTUPou74V8Xm2J+KpHaj2hV4uQhAuF+5gjcjhWtgevZzjEsfrSsc6npdq8ep/piZJYDrUS7OTXgo= Received: from DB7PR07MB3916.eurprd07.prod.outlook.com (2603:10a6:5:7::33) by DU0PR07MB8545.eurprd07.prod.outlook.com (2603:10a6:10:313::14) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.6745.34; Thu, 7 Sep 2023 12:17:40 +0000 Received: from DB7PR07MB3916.eurprd07.prod.outlook.com ([fe80::ad9a:cf80:52d5:859f]) by DB7PR07MB3916.eurprd07.prod.outlook.com ([fe80::ad9a:cf80:52d5:859f%7]) with mapi id 15.20.6745.030; Thu, 7 Sep 2023 12:17:40 +0000 From: David Raymond To: Daniele Varrazzo CC: "psycopg@postgresql.org" Subject: RE: CPU usage for queries, psycopg 2 vs 3 Thread-Topic: CPU usage for queries, psycopg 2 vs 3 Thread-Index: AdngG2Om+7oR5OUYTk6QRCXQ7I8s9wA+0WmAABtShdA= Date: Thu, 7 Sep 2023 12:17:40 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=tomtom.com; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: DB7PR07MB3916:EE_|DU0PR07MB8545:EE_ x-ms-office365-filtering-correlation-id: 26104c4c-1ece-4e29-1c76-08dbaf9c6e52 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: SFsY6mq7iSBVS9hbqRVF/iVpXJmy0DskPdPnM2bT5U3EMwyPf5ZqcYgUgKVCm1TxQbUyQNmgtA5jLXXpeFDq+693c1WTkDEPIQcMMXuXSn2RWy1ulCZbhGQT/G566PsBaz9EQFKs2LhdolEIpMWBMyangXH6PnAwd3HB47MGDe1y2K+5hhmxFkOnf+kkcicfFfE3olxAini1TXdoHrejUhsJT8qFlAoPISAXooFtmcit2Vo9eMBhF1nEFzmuNZ+6dMTG5AZ6MtX+uN1558yr/G9QlyXhhmiWGWp+Mupx9hK1hHil+2HGJVyPFoRr1zg8VLDQX0ZPPh3qeb5oql0DT+/6ckYtvUgccQB0oGTdsk6+JD5E7DjFeZEukkkqqexXPiwMzLOOn37ePuHSB2FYXJoYFKZBDy0Zd90I2jem8BEmY4L/fFszHubfZEhvj4CcGwRVZyty62ydlgz0OVhRRmFlg09k8aYVofNpZI/ls33C+j9dtqNRssHVxRoaZYyeFdIcOL9rQrj0ZjGvfae6s8pzKm2SlhnjT1TI91ngdFGphjHktp06GfPBJ3b1HY/3aA3bL67WukZiQVoA75f01yel7/4Cbp9NvHaKoRlJo0aN4TVzFgAmLAvpVBwI70eyz8DupGZ6jCvOF9GPCkL+B9xiBHLti9WNA0DDYPUxT3k= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:DB7PR07MB3916.eurprd07.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230031)(376002)(136003)(396003)(366004)(346002)(39860400002)(186009)(451199024)(1800799009)(122000001)(71200400001)(7696005)(6506007)(9686003)(33656002)(86362001)(55016003)(38070700005)(38100700002)(26005)(4744005)(478600001)(41300700001)(52536014)(76116006)(8676002)(8936002)(4326008)(5660300002)(6916009)(2906002)(316002)(66476007)(66446008)(66946007)(64756008)(66556008);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?Windows-1252?Q?aXDB6buDJaidoQ6PxbxtMfb8b3A9RDq2LMP5I0o3WjqyggHmLzuwk1pn?= =?Windows-1252?Q?MBPzvTdAoMZyo4vygNE73TeWRVpOuM43CfP94rOrURoKIEgcJCBaznIt?= =?Windows-1252?Q?te4nOrJhzFYUXZf9FmhgS0frKIQ+B08gQ8FsqcO/xPrPOlreaA9pmmKW?= =?Windows-1252?Q?1sWI8SNIMUIp/K4PmWcAWPrLP8I8a1BCQyXgRLVnsnyEV60Iww4oFu94?= =?Windows-1252?Q?0L/s2ZVRIrBoLhhA2RSk4aZsbfIjgVUpOqxcRQeUkR5pKYRyg3BpVvD1?= =?Windows-1252?Q?13oElS1qf1i6Y3OZsYKFi7fvlhVmZm9vO77IDr5AbTfu/ulw79QHv89L?= =?Windows-1252?Q?xxoZu1WHoymwtR3szGSVSLgo6rz0Itx7vI0lZcRsny30pce+AkYTApXO?= =?Windows-1252?Q?ceNT3piD1V16+UVAhIDEmP2nYSN1jIYOkl/dWuLXjuxqAcYq8LJqA7i+?= =?Windows-1252?Q?alarE1bqKh4RSSjtaRiD2hdINQyyuV9ptMNoFObI85Hkno+cgf2w/XHA?= =?Windows-1252?Q?VD3y/mvaJW6YSgtne9nBAi71KFV9RQcgVjcHV99fj4DhVtaR5qoxYAO8?= =?Windows-1252?Q?4FdiEUvr+wM1cnd2jH+dwo1d+hAa7O9TQuKBQEg+GXlNBwqjvwYj0CKG?= =?Windows-1252?Q?VKDXh8Nhb3LHs1g0IlXQ4wFK+dgEFEkiyaqmhrwr+I58zzS3kfl7jrAC?= =?Windows-1252?Q?C6cMrFuZWexcsZucgVE1dL63fEzgVJUpKxhc79fus7/buGby1Xx9gpKa?= =?Windows-1252?Q?Ct0Js4i53hx2Q8lPmmcH4nnHgjkDb22GqbQKYZ51hNWXYtZ384a8YIPD?= =?Windows-1252?Q?zocRyHBodC+w9fZGY50c2fAY6Wd0RrwhzPRdxzF9v8cxJA47DggdPIaW?= =?Windows-1252?Q?tCvJWygP1glc4G+E9yKl0ZT1hL3DZAKGmuYM5o8B+b3WKV6lvqMFCzLW?= =?Windows-1252?Q?9SCptJL58q2fZK2xI8RpnRQQhAc5pHBAj3r2RVnjNg3bXWb/74fuafXW?= =?Windows-1252?Q?OaQchK3qmRdGYswbTfvd+ESx8ZuD7n1YE/0P58O1EKAhNxv6mYMuCfI5?= =?Windows-1252?Q?cOXDfmv2/XbzK22F83BkW3SI20c9mdFG9sTnIZltEHpk3XkH32mtuWxC?= =?Windows-1252?Q?LIXeq+Y+nrMg/SH+JpQMoHTtLr+r+7zCC9ch+681vSAUZWybsQr3DBxl?= =?Windows-1252?Q?JCLLGj3nEu8dUbZclZMAv03/B5py8tsfTtcF/Lz2RL6YJJ3JtRcGqSE3?= =?Windows-1252?Q?aZVoTJBOu12Jq+aMdtb0ChwM7nvrwj2c3IMqFWyDD4NDb7euuhFlVP2C?= =?Windows-1252?Q?Vsi2msRHrdkluLZN8vt1kzbsvniuydI28eY9HC5Q6UrfxMDaaTp07l4Q?= =?Windows-1252?Q?H1HDSMIfPeY/HNu11kzOxdnHjfgtRLpfaGb1Cg5R1wBgiTNNE4dTAp5s?= =?Windows-1252?Q?hpm1rHuQbI3n9A/JNpWW+O3D4bh61D1PbuNCIcVnF3tQ8SvGcDDthRR+?= =?Windows-1252?Q?99Odbsly53rhtFyQZWyjEuZDPfhB06LilqUg7VOyEl03FeeoR2GDTQ09?= =?Windows-1252?Q?xoHVB93x21I12p1J3C1PYSMLMA6ToYOuZFH/eyN0ENcwHArOc/3SDhZb?= =?Windows-1252?Q?ZUm7XUU5/pGLWservxTpIjqZPrxck9lgm7cdYd6xtbO0EikdgG6nRqFo?= =?Windows-1252?Q?tgaYK2/URkuOvGA+1gVp89Sl0W2NUDzt?= Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-OriginatorOrg: tomtom.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: DB7PR07MB3916.eurprd07.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 26104c4c-1ece-4e29-1c76-08dbaf9c6e52 X-MS-Exchange-CrossTenant-originalarrivaltime: 07 Sep 2023 12:17:40.3148 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 374f8026-7b54-4a3a-b87d-328fa26ec10d X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: YFRQ8xxvPp63qLs7NSZkw1OpyGLu8Zq+jpITqas1DcPJTK3Dmm2p0U5q3iHSvnEpqjdQvVbE3n8Dg5+TY8GX9Unli4FenVrWalmc/AWt438= X-MS-Exchange-Transport-CrossTenantHeadersStamped: DU0PR07MB8545 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > Could you please be so kind as to repeat your tests with psycopg 3.1.4? Tried with 3.1.4 and it has idle processor usage while waiting for the 8 re= sults, just like psycopg2. Tried with 3.1.5 and it spikes up to 62% reported CPU usage while waiting f= or the 8 results, just like the current release. > Also, did you try only to connect on localhost? Are you able to run the s= ame test with a server running on a different network location? Have now tried with both a local host, and spreading the connections out ov= er a number of remote servers, and the results are the same for both situat= ions.