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 1vGL0B-00CsGU-2Z for pgsql-admin@arkaria.postgresql.org; Tue, 04 Nov 2025 17:39:26 +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 1vGL0A-00FWOo-1I for pgsql-admin@arkaria.postgresql.org; Tue, 04 Nov 2025 17:39:25 +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 1vGL09-00FWOc-JR for pgsql-admin@lists.postgresql.org; Tue, 04 Nov 2025 17:39:24 +0000 Received: from mx0b-0039f802.pphosted.com ([205.220.176.45]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vGL04-005y8F-2K for pgsql-admin@lists.postgresql.org; Tue, 04 Nov 2025 17:39:23 +0000 Received: from pps.filterd (m0209982.ppops.net [127.0.0.1]) by mx0b-0039f802.pphosted.com (8.18.1.11/8.18.1.11) with ESMTP id 5A4GZVQd3531265 for ; Tue, 4 Nov 2025 09:39:17 -0800 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=dat.com; h=cc :content-type:date:from:in-reply-to:message-id:mime-version :references:subject:to; s=ppdk230404; bh=5vkzKpi8EK9C/9C3ne43s37 3KTmg0r/g/b9OiueBpVQ=; b=TKcj38DC7USGKTkuWXf4X7ZdQt13XzqdLRuW8Ss QEb5Q2GYKMrhATcbRhrBhhyklTJradpDGpLV+9zfLgklVbEMrPOyeqkbGSUs/nMo GJIdio9Hqcg2mdQ5bYKgKWTmMB2kJl9QMBqPjDOPQGet3XT3AX6V0QdXIWHeIaRh W/YAn+2Y5K6WMWfHtpBsO5L+g7xfAleWYQ6RmUD6YLBfElUMXMnhjrXCbDaca0Xj G3kBT+jTV+G1xMZCA50Rr1LTu4dwpjjKLiDMs5onefapBUc9+ykCT0jH150MgrHU R8exXmappcAXVgw+w3ZNL4FyEIZNDJxOzsl68giAO6xbWqA== Received: from mail-ej1-f72.google.com (mail-ej1-f72.google.com [209.85.218.72]) by mx0b-0039f802.pphosted.com (PPS) with ESMTPS id 4a6uq3tn2u-1 (version=TLSv1.3 cipher=TLS_AES_128_GCM_SHA256 bits=128 verify=NOT) for ; Tue, 04 Nov 2025 09:39:17 -0800 (PST) Received: by mail-ej1-f72.google.com with SMTP id a640c23a62f3a-b70b2b1ef82so299820366b.1 for ; Tue, 04 Nov 2025 09:39:17 -0800 (PST) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1762277956; x=1762882756; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=5vkzKpi8EK9C/9C3ne43s373KTmg0r/g/b9OiueBpVQ=; b=e1ZafFpouQz4lTfvfN+v+qeIBJDH+44xfQgic43NervNuMfNaL1EgFPANkdoJ2PLGV gpj9xp1K6lSVtnMmdWXPWpXZthjnmW5gznf33EKBRNkmsG2LcnFl3tsGMnEfMH/Kp5GQ 7hg3xwh29ixkbmZyqXhuGOZ6d4KyRGl5LKYZmP18zv824gBiecxvGr01GuZdx+7oIQ+u +MP+fAh6fkYpLDF8y5UB/d4LD1zhXF0K5HXe0yyA6ROA2j7XEwKg+PqdiSh5PV96SI53 Az6MF5Lf/U1WapRv5m3cPYidky8cl349rfRVyDeism7PyniQvjMWf5xd5yYD9ucIt5Pn +SkQ== X-Gm-Message-State: AOJu0Yyq1Ya5eYlUUssKMVWS44VKPQCB100A+Hz5uE0ya4/xWBRw/Vqe jzPbY43L4w9s8YiZh54FhdmthbUxqXeJpJhD5W2oMtTlIyK9aVHovvEn+Qjw2FEUbq9/8z73npq 9urMQOCm30pjRqDxwrBHvxX1DTrjnduK8lvO9J4bs9VdROjK/JllsERf9sStYeim6Xk4G/UgTJl vgDWj1vKwjL4+ULMhFlSym70pERdfdCV9ALbv3TIXM9TN14R4e7zI2mt6/sPQTYggytXEZSNtt1 QiDT5E= X-Gm-Gg: ASbGncu16kaI1anCXvAv823vBHj3LGG+AAwjdfdkGVIeSejCg3cK8gTGYvfbsJ8gMla Fee15Cc081Bqpg3FLErGDEabl2kEcHU2nsJy2Uj3eBk6gQyTYR8Z70e+KnNsRxAAJLxrLGDdJon 7TL7PucHMUxdI0U3wsecD3NTHDG6mnVRQibYoZ7uDVeAGMuRa9JrU6Xg== X-Received: by 2002:a17:907:3d0b:b0:b45:b078:c52d with SMTP id a640c23a62f3a-b70704c3de5mr1864918466b.35.1762277955714; Tue, 04 Nov 2025 09:39:15 -0800 (PST) X-Google-Smtp-Source: AGHT+IGZRPZSdXjhm2Gdn6noszaNHhrcfV5grKU0fFHqUHu/wjCKmiBQ4dOsYygjEcPPMKr/adOmxwSIvJz05hf3FVs= X-Received: by 2002:a17:907:3d0b:b0:b45:b078:c52d with SMTP id a640c23a62f3a-b70704c3de5mr1864915266b.35.1762277955261; Tue, 04 Nov 2025 09:39:15 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Sam Stearns Date: Tue, 4 Nov 2025 09:39:04 -0800 X-Gm-Features: AWmQ_blyLtjlC0nD4wobfcSYcRAfcxnOP5cmYDu_15O1B4KF7X4cifh9ePDxEh4 Message-ID: Subject: Re: Postgres Load Profile To: Ron Johnson Cc: Pgsql-admin Content-Type: multipart/alternative; boundary="00000000000084e8be0642c84f25" X-Proofpoint-Virus-Version: vendor=baseguard engine=ICAP:2.0.293,Aquarius:18.0.1121,Hydra:6.1.9,FMLib:17.12.100.49 definitions=2025-11-04_02,2025-11-03_03,2025-10-01_01 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000084e8be0642c84f25 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Thank you, Ron! On Mon, Nov 3, 2025 at 6:49=E2=80=AFPM Ron Johnson wrote: > On Mon, Nov 3, 2025 at 5: 56 PM Sam Stearns > wrote: Howdy, Does Postgres have any tables you can query to find out > information such as: Logical reads Block changes Physical reads Physical > writes Read IO requests Write > ZjQcmQRYFpfptBannerStart > This Message Is From an External Sender > This message came from outside your organization. > > ZjQcmQRYFpfptBannerEnd > On Mon, Nov 3, 2025 at 5:56=E2=80=AFPM Sam Stearns = wrote: > >> Howdy, >> >> Does Postgres have any tables you can query to find out information such >> as: >> >> - Logical reads >> - Block changes >> - Physical reads >> - Physical writes >> - Read IO requests >> - Write IO requests >> - Read IO (MB) >> - Write IO (MB) >> >> > https://www.postgresql.org/docs/17/monitoring-stats.html > > >> >> - User calls >> - Parses (SQL) >> - Hard parses (SQL) >> - Executes (SQL) >> >> Probably not unless you want to set log_statement=3Dall and then > parse log_directory/log_filename. > > >> >> - Transactions per second >> >> Does TPS make any sense beyond when DBMS is running a "strict > monoculture" application like OLTP with *zero* report generation? > Because a five hour SELECT that joins 42 tables in addition to 37 hairy > subqueries is just as much a transaction as is a 5 microsecond SELECT of > one customer's records using a hash index, and an equally fast INSERT of > three records. > > -- > Death to , and butter sauce. > Don't boil me, I'm still alive. > lobster! > --=20 Samuel Stearns Team Lead - Database c: 971 762 6879 | o: 971 762 6879 | DAT.com --00000000000084e8be0642c84f25 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thank you, Ron!

On Mon, Nov 3, 2025 a= t 6:49=E2=80=AFPM Ron Johnson <ronljohnsonjr@gmail.com> wrote:
On Mon, Nov 3, 2025 at 5:=E2=80=8A56 PM Sam Stearns <sam.=E2=80=8Astearn= s@=E2=80=8Adat.=E2=80=8Acom> wrote: Howdy, Does Postgres have any tables= you can query to find out information such as: Logical reads Block changes= Physical reads Physical writes Read IO requests Write
ZjQcmQRYFpfptBannerStart
This Message Is From an External Sender
This message came from outside your organization.
=C2=A0
ZjQcmQRYFpfptBannerEnd
On Mon, Nov 3, 2025 at 5:56=E2=80=AFPM Sa= m Stearns <sam.= stearns@dat.com> wrote:
Howdy,

Does Postgres have any tables you can query to find out in= formation such as:
  • Logical reads
  • Block changes
  • Physical reads
  • Physical writes
  • Read IO requests
    • <= li>Write IO requests
  • Read IO (MB)
  • Write IO (MB)

=C2=A0
  • User ca= lls
  • Parses (SQL)
  • Hard parses (SQL)
  • Executes (SQL)
Probably not unless you want to set= =C2=A0log_statement=3Dall and then parse=C2=A0log_directory/log_filename.
=C2=A0
  • Transactions per second
Does TPS make any sense beyond when DBMS is running a &= quot;strict monoculture" application like OLTP with zero=C2=A0r= eport generation?=C2=A0 Because a five hour SELECT that joins 42 tables in = addition to 37 hairy subqueries is just as much a transaction as is a 5 mic= rosecond SELECT of one customer's records using a hash index, and an eq= ually fast INSERT of three records.

--
Death to <Redacted>, and butter sauce.
Don'= ;t boil me, I'm still alive.
<Redacted> lobster!


--

Samuel Stearns
Team Lead - Databas= e
c: 971 76= 2 6879 = | o: 97= 1 762 6879 | D= AT.com


--00000000000084e8be0642c84f25--