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 1sADki-008JRd-CF for pgsql-admin@arkaria.postgresql.org; Thu, 23 May 2024 19:05:25 +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 1sADkg-00FOd9-AE for pgsql-admin@arkaria.postgresql.org; Thu, 23 May 2024 19:05:22 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sADkf-00FOd0-V1 for pgsql-admin@lists.postgresql.org; Thu, 23 May 2024 19:05:21 +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 1sADkc-001fFE-7u for pgsql-admin@lists.postgresql.org; Thu, 23 May 2024 19:05:20 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id 75F8C38133C; Thu, 23 May 2024 21:05:15 +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 6kBQgfHMikEq; Thu, 23 May 2024 21:05:15 +0200 (CEST) Received: from [172.16.0.162] (unknown [139.28.68.141]) by rs.plausibolo.de (Postfix) with ESMTPSA id C5A8638042E; Thu, 23 May 2024 21:05:14 +0200 (CEST) Message-ID: Date: Thu, 23 May 2024 21:05:13 +0200 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.12.0 Subject: Re: query execution time for last 24 hours in PostgreSQL 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="------------YVlZ6WbRUKHEqKe0WH8pq6vB" 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) --------------YVlZ6WbRUKHEqKe0WH8pq6vB Content-Type: multipart/mixed; boundary="------------j1gAGUyZnUCmRDEwrg6qiMiJ"; protected-headers="v1" From: Holger Jakobs To: pgsql-admin@lists.postgresql.org Message-ID: Subject: Re: query execution time for last 24 hours in PostgreSQL References: In-Reply-To: --------------j1gAGUyZnUCmRDEwrg6qiMiJ Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 QW0gMjMuMDUuMjQgdW0gMjA6MDcgc2NocmllYiBuaWtoaWwga3VtYXI6DQo+IEhpIFRlYW0s DQo+DQo+IENhbiB5b3UgcGxlYXNlIGxldCBtZSBrbm93IGFueW9uZSBob3cgdG8gZ2V0IGVh Y2ggcXVlcnkgZXhlY3V0aW9uIHRpbWUgDQo+IGZyb20gbGFzdCAyNCBob3VycyBpbiBQb3N0 Z3JlU1FMDQo+DQo+IEkgdHJpZWQgdGhlIGJlbG93IHF1ZXJ5IGJ1dCBnaXZpbmfCoHRoZSB3 cm9uZ8KgaW5mb3JtYXRpb24uDQo+DQo+IFNFTEVDVCBzYS5jbGllbnRfYWRkciwNCj4gc2Eu dXNlbmFtZSwNCj4gc2EuZGF0bmFtZSwNCj4gc2Euc3RhdGUsDQo+IHNhLnF1ZXJ5LA0KPiBz YS5xdWVyeV9zdGFydCwNCj4gRVhUUkFDVCAoRVBPQ0ggRlJPTSAoY3VycmVudF90aW1lc3Rh bXAgc2EucXVlcnlfc3RhcnQpKSBBUyANCj4gZXhlY3V0aW9uX3RpbWVfc2Vjb25kcw0KPiBG Uk9NIHBnX3N0YXRfYWN0aXZpdHkgc2ENCj4gV0hFUkUgc2EucXVlcnlfc3RhcnQgPj0gY3Vy cmVudF90aW1lc3RhbXAgaW50ZXJ2YWwgJzI0IGhvdXJzJzsNCj4NCj4gVGhhbmtzLA0KPiBO aWtoaWwsDQo+IFBvc3RncmVTUUwgREJBLA0KPiA4MDc0NDMwODU2Lg0KDQpwZ19zdGF0X2Fj dGl2aXR5IHNob3dzIGN1cnJlbnQgYWN0aXZpdHksIG5vdCBoaXN0b3JpYyBhY3Rpdml0eS4N Cg0KVW5sZXNzIHlvdSB1c2UgYW4gZXh0ZW5zaW9uIGxpa2UgcGdfc3RhdF9zdGF0ZW1lbnRz LCBvciBsb2cgeW91ciANCnN0YXRlbWVudHMsIHRoZSBpbmZvcm1hdGlvbiB3b24ndCBiZSBh dmFpbGFibGUuDQoNClJlZ2FyZHMsDQpIb2xnZXINCg0KLS0gDQoNCkhvbGdlciBKYWtvYnMs IEJlcmdpc2NoIEdsYWRiYWNoDQoNCg== --------------j1gAGUyZnUCmRDEwrg6qiMiJ-- --------------YVlZ6WbRUKHEqKe0WH8pq6vB Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCZk+TaQUDAAAAAAAKCRCKV5yTsxlhuorS AKCIJbIbzhwHTX6cG9goEaC+AAuHxQCdGBOE8i7IQ5E5ggRuLWBfkRTt/tc= =HK4S -----END PGP SIGNATURE----- --------------YVlZ6WbRUKHEqKe0WH8pq6vB--