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.96) (envelope-from ) id 1vXhw0-002Ydi-1s for pgsql-admin@arkaria.postgresql.org; Mon, 22 Dec 2025 15:34:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vXhvz-00FJAW-1b for pgsql-admin@arkaria.postgresql.org; Mon, 22 Dec 2025 15:34:56 +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.96) (envelope-from ) id 1vXhvz-00FJAN-0S for pgsql-admin@lists.postgresql.org; Mon, 22 Dec 2025 15:34:55 +0000 Received: from mail-yx1-xb135.google.com ([2607:f8b0:4864:20::b135]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vXhvx-0028si-1I for pgsql-admin@lists.postgresql.org; Mon, 22 Dec 2025 15:34:55 +0000 Received: by mail-yx1-xb135.google.com with SMTP id 956f58d0204a3-64669a2ecb5so3531327d50.1 for ; Mon, 22 Dec 2025 07:34:53 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1766417692; x=1767022492; darn=lists.postgresql.org; h=mime-version:content-language:accept-language:message-id:date :thread-index:thread-topic:subject:to:from:from:to:cc:subject:date :message-id:reply-to; bh=iE8ZjioZarWuDKwgLTgJ1q3jahee+ySF8vgJEucVNls=; b=R5pyknlds/Zac7rTdtluU4xQttlmXysdXRnB4Hqrry6efbdbIBPDWRMSIOwTA9EHby P3QcaWppEgCdGuRXWxt0hM1XaNQk5xsxiV9BE9szNlP3pNyDxz2+kXVUgwzYLDkQLRoy vPJ4LVRpSAzzFubEjhNCk5b3lDYRWpv7qgzY2xHCmIiRTCiG3tFRR0q0kWtiS4lOrWi9 jbVf/YZV7pVvie91HyjxUoSmwTvIwYRbOeWkK7EZlvs4bEhHljkAF71roV8CaF0PQNSb m250NtwAG0n9Jfq96Oie0HoRrR05G05sVmnMOR2tHEkCShNUKp8tLFqPOI8jjp6sir4T YT8g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1766417692; x=1767022492; h=mime-version:content-language:accept-language:message-id:date :thread-index:thread-topic:subject:to:from:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=iE8ZjioZarWuDKwgLTgJ1q3jahee+ySF8vgJEucVNls=; b=flHCE9fDjIN+HK4gtY1N8BG+bN5aw8k6TlSmby6YKuyNrzrgedFbnyHbCYMoLcLAKG aavvIjzDfhfapa/nKMj72rNQqTiBA5QeY+LsjqwYHXVQ7OhL2f9101JODY/c9jH6yjvP XGwLYqBZWBYdsjm6b9fKGkFAjfRoW+sgvU3HWOPeIzHW3DeDy+XIvIyjUAeBIrKj7tNQ JPM4NpJh82CtnBSAZZFb5nfEqeh264nonCHBKKlJpV+WvHZsvykWshZN22TUTRqu/jqm ynxudbnmSeBgZ20Bdgm5fmvK4qYzTJga7pc5g9jLiFwWvBygfjUCsargPU7Po+WGZTji IhlA== X-Gm-Message-State: AOJu0YwFd/UZMBd+pi/NJxsKkvheHgmbccTP5SRF/Tmh4zlDnPZE0W5H m2mlCBcGzOf2A+T2qSi8J7Nd6cWJJM5XVlbyGZ1eKs3d4AtLaUtw8QJ6e1Ndhg== X-Gm-Gg: AY/fxX6nm9/v/dFZHdi49eG2xlD1e8D98l43t2G/1f7WZHZnG/RRCnk/lMP4JdmtQI9 I7E+b02w0ADqGWVUGoNgWEcL+1XpkS9qurJkMR3xxQAnWjYmyDunOI/Do2ho0lEPqyHibxQLp8r RmOKQ5dgLazN1cPobQUpbTvKFCb1mmC5C3BdYZor0GaVAzZDSf+djanqCioEzBRNS/FHf+8oUaZ 8ElNIdvCxhRKFgGt2M+DB6Gk53eoMPteCv2sgflF4ArxwYxHaeknWcY3YRU3Xjs+iw3BbMFS0z9 DI0R8WQcqsDWhVEpYc3lwW9YJS2dHzgvb4v+IOBaSLUEiCeimYTmtZIgGU05bHpdQnjmrEr1dwd 8HyL7pThzB/WxZYw+JR3col7T5MIZm5gPxRl1Y5mxziWKIiiz118+AUdh7dj7jeymNaoGcPI4Ix 0Wf3z+10mm/Qye7ZnYj6liB8SYl9wHrL12QtrPwVhCwNJ+rlT4bTTepfLJZLSGxWdgCyeSSWj1e g94 X-Google-Smtp-Source: AGHT+IFeuCPonBvD0WFSv+hk5RFAfNTC8aRmQPozPxpO05NHPH6dPUfxSn/hRDf3buJv9fc4fqsHEw== X-Received: by 2002:a05:690e:1187:b0:646:44ef:cede with SMTP id 956f58d0204a3-64669dd8b9fmr8174120d50.39.1766417691983; Mon, 22 Dec 2025 07:34:51 -0800 (PST) Received: from FRWP190MB2604.EURP190.PROD.OUTLOOK.COM ([2603:1026:c0d:1450::5]) by smtp.gmail.com with ESMTPSA id 956f58d0204a3-6466a8bcee0sm5649691d50.6.2025.12.22.07.34.51 for (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 22 Dec 2025 07:34:51 -0800 (PST) From: =?iso-8859-1?Q?P=E4r_Mattsson?= To: Pgsql-admin Subject: Performance issue! Thread-Topic: Performance issue! Thread-Index: AQHcc1gpS55HrR09V06QXzKgro8FZQ== X-MS-Exchange-MessageSentRepresentingType: 1 Date: Mon, 22 Dec 2025 15:34:48 +0000 Message-ID: Accept-Language: sv-SE, en-US Content-Language: sv-SE X-MS-Has-Attach: X-MS-Exchange-Organization-SCL: -1 X-MS-TNEF-Correlator: X-MS-Exchange-Organization-RecordReviewCfmType: 0 x-ms-reactions: allow Content-Type: multipart/alternative; boundary="_000_FRWP190MB260478E9A1595A5CF2810BBCA2B4AFRWP190MB2604EURP_" MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_FRWP190MB260478E9A1595A5CF2810BBCA2B4AFRWP190MB2604EURP_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi! Anyone who have performance scripts with nice output to share. I am in a new project where we got lots of questions about performance on t= he database! Mvh P=E4r --_000_FRWP190MB260478E9A1595A5CF2810BBCA2B4AFRWP190MB2604EURP_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi!
Anyone who have performance scripts with nice output to share.

I am in a new project where we got lots of questions about performance on t= he database!


Mvh P=E4r
--_000_FRWP190MB260478E9A1595A5CF2810BBCA2B4AFRWP190MB2604EURP_--