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 1qC2i2-0003U4-VJ for pgsql-admin@arkaria.postgresql.org; Wed, 21 Jun 2023 18:37:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qC2i1-0001tn-1M for pgsql-admin@arkaria.postgresql.org; Wed, 21 Jun 2023 18:37:37 +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 1qC2i0-0001te-Hi for pgsql-admin@lists.postgresql.org; Wed, 21 Jun 2023 18:37:36 +0000 Received: from jakobs.com ([85.214.83.89] helo=rs.plausibolo.de) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qC2hx-003Teq-GU for pgsql-admin@lists.postgresql.org; Wed, 21 Jun 2023 18:37:35 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id F1AB2380399; Wed, 21 Jun 2023 20:37:30 +0200 (CEST) Received: from rs.plausibolo.de ([127.0.0.1]) by localhost (h2367442.stratoserver.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id qimSzlK0gEcs; Wed, 21 Jun 2023 20:37:30 +0200 (CEST) Received: from [192.168.43.225] (ip-109-42-177-215.web.vodafone.de [109.42.177.215]) by rs.plausibolo.de (Postfix) with ESMTPSA id 9CE7D380395; Wed, 21 Jun 2023 20:37:30 +0200 (CEST) Message-ID: <85548e4d-b7ce-e061-e43e-8a8e332dc4e5@jakobs.com> Date: Wed, 21 Jun 2023 20:37:29 +0200 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.11.0 Subject: Re: Poor performance due to parallel seq scan on indexed date field Content-Language: de-DE To: pgsql-admin@lists.postgresql.org References: From: Holger Jakobs In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------0iGQs0CiwZ63Z6yKlZE4iX07" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --------------0iGQs0CiwZ63Z6yKlZE4iX07 Content-Type: multipart/mixed; boundary="------------ycr8bCHhYueevZ76mnQDmtk7"; protected-headers="v1" From: Holger Jakobs To: pgsql-admin@lists.postgresql.org Message-ID: <85548e4d-b7ce-e061-e43e-8a8e332dc4e5@jakobs.com> Subject: Re: Poor performance due to parallel seq scan on indexed date field References: In-Reply-To: --------------ycr8bCHhYueevZ76mnQDmtk7 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 DQpBbSAyMS4wNi4yMyB1bSAyMDozMSBzY2hyaWViIFdlbGxzIE9saXZlcjoNCj4gRGVhZCBz aW1wbGUgZGF0ZSBzY2FuIGFjcm9zcyBhIGJpZy1pc2ggdGFibGUgKGVzdC7CoDIzLDE1Myw2 NjYgcm93cykNCj4NCj4gZXhwbGFpbiBhbmFseXplIHNlbGVjdCBjb3VudCgqKSBmcm9tIHZ3 X3BpdGNoZXMgd2hlcmUgZ2FtZV9kYXRlID49IA0KPiAnMjAyMi0wNi0yMScgYW5kIGdhbWVf ZGF0ZSA8PSAnMjAyMy0wNi0yMSc7DQo+DQo+IFRoZSB2aWV3IGRvZXMgZG8gc29tZSBqb2lu cyBidXQgdGhvc2UgZG9uJ3Qgc2VlbSB0byBiZSB0aGUgaXNzdWUgdG8gbWUuDQo+DQo+IFBs YW5uZXIgZG9lczoNCj4NCj4gRmluYWxpemUgQWdncmVnYXRlIMKgKGNvc3Q9MzU5Njk5My44 OC4uMzU5Njk5My44OSByb3dzPTEgd2lkdGg9OCkgDQo+IChhY3R1YWwgdGltZT02OTk4MC40 OTEuLjY5OTgyLjA3NiByb3dzPTEgbG9vcHM9MSkNCj4gwqAgLT4gwqBHYXRoZXIgwqAoY29z dD0zNTk2OTkzLjQ2Li4zNTk2OTkzLjg3IHJvd3M9NCB3aWR0aD04KSAoYWN0dWFsIA0KPiB0 aW1lPTY5OTc5LjEzNy4uNjk5ODIuMDcxIHJvd3M9NSBsb29wcz0xKQ0KPiDCoCDCoCDCoCDC oCBXb3JrZXJzIFBsYW5uZWQ6IDQNCj4gwqAgwqAgwqAgwqAgV29ya2VycyBMYXVuY2hlZDog NA0KPiDCoCDCoCDCoCDCoCAtPiDCoFBhcnRpYWwgQWdncmVnYXRlIMKgKGNvc3Q9MzU5NTk5 My40Ni4uMzU5NTk5My40NyByb3dzPTEgDQo+IHdpZHRoPTgpIChhY3R1YWwgdGltZT02OTk3 NS4xMzYuLjY5OTc1LjEzNyByb3dzPTEgbG9vcHM9NSkNCj4gwqAgwqAgwqAgwqAgwqAgwqAg wqAgLT4gwqBOZXN0ZWQgTG9vcCDCoChjb3N0PTAuNDQuLjM1OTE0MDguMzcgcm93cz0xODM0 MDM0IA0KPiB3aWR0aD0wKSAoYWN0dWFsIHRpbWU9MC44ODIuLjY5ODc1LjkzNCByb3dzPTE0 NTg0MTkgbG9vcHM9NSkNCj4gwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgLT4gwqBQ YXJhbGxlbCBTZXEgU2NhbiBvbiBwaXRjaGVzIHAgDQo+IMKgKGNvc3Q9MC4wMC4uMzUzNzQz MS44OSByb3dzPTE4MzQyMTcgd2lkdGg9MTIpIChhY3R1YWwgDQo+IHRpbWU9MC44NTIuLjY4 OTE0LjI1NiByb3dzPTE0NTg0MTkgbG9vcHM9NSkNCj4gwqAgwqAgwqAgwqAgwqAgwqAgwqAg wqAgwqAgwqAgwqAgwqAgwqAgRmlsdGVyOiAoKGdhbWVfZGF0ZSA+PSAnMjAyMi0wNi0yMSc6 OmRhdGUpIA0KPiBBTkQgKGdhbWVfZGF0ZSA8PSAnMjAyMy0wNi0yMSc6OmRhdGUpKQ0KPiDC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCBSb3dzIFJlbW92ZWQgYnkg RmlsdGVyOiAzMjEyMzEwDQo+IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIC0+IMKg TWVtb2l6ZSDCoChjb3N0PTAuNDQuLjAuNDcgcm93cz0xIHdpZHRoPTQpIA0KPiAoYWN0dWFs IHRpbWU9MC4wMDAuLjAuMDAwIHJvd3M9MSBsb29wcz03MjkyMDk1KQ0KPiDCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCBDYWNoZSBLZXk6IHAucGl0Y2hlcl9pZGVu dGl0eV9pZA0KPiDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCBDYWNo ZSBNb2RlOiBsb2dpY2FsDQo+IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIEhpdHM6IDE0MzgwMDQgwqBNaXNzZXM6IDIxMDQyIMKgRXZpY3Rpb25zOiAwIA0KPiDC oE92ZXJmbG93czogMCDCoE1lbW9yeSBVc2FnZTogMjEzOGtCDQo+IMKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIFdvcmtlciAwOiDCoEhpdHM6IDE0Mjk2MzggwqBN aXNzZXM6IDIxMDEwIA0KPiDCoEV2aWN0aW9uczogMCDCoE92ZXJmbG93czogMCDCoE1lbW9y eSBVc2FnZTogMjEzNGtCDQo+IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIFdvcmtlciAxOiDCoEhpdHM6IDE0NTY3NTUgwqBNaXNzZXM6IDIxNDM1IA0KPiDCoEV2 aWN0aW9uczogMCDCoE92ZXJmbG93czogMCDCoE1lbW9yeSBVc2FnZTogMjE3N2tCDQo+IMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIFdvcmtlciAyOiDCoEhpdHM6 IDE0MzM1NTcgwqBNaXNzZXM6IDIxMjAxIA0KPiDCoEV2aWN0aW9uczogMCDCoE92ZXJmbG93 czogMCDCoE1lbW9yeSBVc2FnZTogMjE1NGtCDQo+IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIFdvcmtlciAzOiDCoEhpdHM6IDE0Mjg3MjcgwqBNaXNzZXM6IDIw NzI2IA0KPiDCoEV2aWN0aW9uczogMCDCoE92ZXJmbG93czogMCDCoE1lbW9yeSBVc2FnZTog MjEwNWtCDQo+IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIC0+IMKg SW5kZXggT25seSBTY2FuIHVzaW5nIGlkZW50aXR5X3BrZXkgb24gDQo+IGlkZW50aXR5IGlk cGl0Y2hlciDCoChjb3N0PTAuNDMuLjAuNDYgcm93cz0xIHdpZHRoPTQpIChhY3R1YWwgDQo+ IHRpbWU9MC4wMDcuLjAuMDA3IHJvd3M9MSBsb29wcz0xMDU0MTQpDQo+IMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIEluZGV4IENvbmQ6IChpZGVu dGl0eV9pZCA9IA0KPiBwLnBpdGNoZXJfaWRlbnRpdHlfaWQpDQo+IMKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIEhlYXAgRmV0Y2hlczogODMNCj4g UGxhbm5pbmcgVGltZTogMS40MDcgbXMNCj4gRXhlY3V0aW9uIFRpbWU6IDY5OTgyLjkyNyBt cw0KPg0KPiBJcyB0aGVyZSBzb21ldGhpbmcgdG8gYmUgZG9uZSBoZXJlPyBLaW5kIG9mIGEg ZnJlcXVlbnQgc3R5bGUgb2YgcXVlcnkgDQo+IGFuZCBxdWl0ZSBzbG93Lg0KPg0KQ291bGQg eW91IHByb3ZpZGUgdGhlIGRlZmluaXRpb24gb2YgdGhlIHZpZXcocykgZG93biB0byB0aGUg YmFzZSB0YWJsZXM/DQoNCi0tIA0KSG9sZ2VyIEpha29icywgQmVyZ2lzY2ggR2xhZGJhY2gs IFRlbC4gKzQ5LTE3OC05NzU5MDEyDQoNCg== --------------ycr8bCHhYueevZ76mnQDmtk7-- --------------0iGQs0CiwZ63Z6yKlZE4iX07 Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCZJNDaQUDAAAAAAAKCRCKV5yTsxlhuutC AKDUus5tVX67K6UxeomM0NyggEwGdgCfVgsssyHj3sIlNet299HWO2/3oSo= =FKFM -----END PGP SIGNATURE----- --------------0iGQs0CiwZ63Z6yKlZE4iX07--