MIME-Version: 1.0
From: Sam Stearns <sam.stearns@dat.com>
Date: Mon, 3 Nov 2025 14:56:27 -0800
Message-ID: 
 <CAN6TVjmH8=dszn3WqSE4MsYEZgCT1gQhufoSnPBn-Omcu9-EkQ@mail.gmail.com>
Subject: Postgres Load Profile
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Cc: Henry Ashu <henry.ashu@dat.com>
Content-Type: multipart/alternative; boundary="000000000000c2a7390642b8a0f4"
Archived-At: 
 <https://www.postgresql.org/message-id/CAN6TVjmH8%3Ddszn3WqSE4MsYEZgCT1gQhufoSnPBn-Omcu9-EkQ%40mail.gmail.com>
Precedence: bulk

--000000000000c2a7390642b8a0f4
Content-Type: text/plain; charset="UTF-8"

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)
   - User calls
   - Parses (SQL)
   - Hard parses (SQL)
   - Executes (SQL)
   - Transactions per second

Thanks,

Sam

-- 

Samuel Stearns
Team Lead - Database
c: 971 762 6879 | o: 971 762 6879 | DAT.com

<https://www.dat.com/?utm_medium=email&utm_source=DAT_email_signature_link>

--000000000000c2a7390642b8a0f4
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Howdy,</div><div><br></div><div>Does Postgres have an=
y tables you can query to find out information such as:</div><div><ul><li>L=
ogical reads</li><li>Block changes</li><li>Physical reads</li><li>Physical =
writes</li><li>Read IO requests</li><li>Write IO requests</li><li>Read IO (=
MB)</li><li>Write IO (MB)</li><li>User calls</li><li>Parses (SQL)</li><li>H=
ard parses (SQL)</li><li>Executes (SQL)</li><li>Transactions per second</li=
></ul><div>Thanks,</div></div><div><br></div><div>Sam</div><div><br></div><=
span class=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=
=3D"gmail_signature" data-smartmail=3D"gmail_signature"><div dir=3D"ltr"><s=
pan><p dir=3D"ltr" style=3D"line-height:1.38;margin-top:10pt;margin-bottom:=
10pt"><span style=3D"font-size:11pt;font-family:Inter,sans-serif;color:rgb(=
51,51,51);background-color:transparent;font-weight:700;vertical-align:basel=
ine">Samuel Stearns</span><span style=3D"font-size:11pt;font-family:Inter,s=
ans-serif;color:rgb(51,51,51);background-color:transparent;font-weight:700;=
vertical-align:baseline"><br></span><span style=3D"font-size:11pt;font-fami=
ly:Inter,sans-serif;color:rgb(102,102,102);background-color:transparent;ver=
tical-align:baseline">Team Lead - Database</span><span style=3D"font-size:1=
1pt;font-family:Inter,sans-serif;color:rgb(102,102,102);background-color:tr=
ansparent;vertical-align:baseline"><br></span><span style=3D"font-size:11pt=
;font-family:Inter,sans-serif;color:rgb(102,102,102);background-color:trans=
parent;vertical-align:baseline">c: 971 762 6879 </span><span style=3D"font-=
size:11pt;font-family:Inter,sans-serif;color:rgb(147,149,152);background-co=
lor:transparent;vertical-align:baseline">|</span><span style=3D"font-size:1=
1pt;font-family:Inter,sans-serif;color:rgb(102,102,102);background-color:tr=
ansparent;vertical-align:baseline"> o: 971 762 6879 </span><span style=3D"f=
ont-size:11pt;font-family:Inter,sans-serif;color:rgb(147,149,152);backgroun=
d-color:transparent;vertical-align:baseline">|</span><span style=3D"font-si=
ze:11pt;font-family:Inter,sans-serif;color:rgb(102,102,102);background-colo=
r:transparent;vertical-align:baseline"> DAT.com</span></p><p dir=3D"ltr" st=
yle=3D"line-height:1.38;margin-top:0pt;margin-bottom:0pt"><a href=3D"https:=
//www.dat.com/?utm_medium=3Demail&amp;utm_source=3DDAT_email_signature_link=
" target=3D"_blank"><span style=3D"font-size:11pt;font-family:Arial,sans-se=
rif;color:rgb(17,85,204);background-color:transparent;vertical-align:baseli=
ne"><span style=3D"border:none;display:inline-block;overflow:hidden;width:1=
26px;height:54px"><img src=3D"https://lh7-rt.googleusercontent.com/docsz/AD=
_4nXchMTXZiU3P-OkN7UwPyrdxiCAOkHWIArmSrehhAl-cXaYxECakbMV5owUfMaMjAZZcbjttr=
8pEtSGrZjUSRNaxbLxumAthLgYlFE5iT2P2eOJu4jtqizp_fYM0Mq1DZyFUeHMhpGKjiGIzqD_n=
y_hPIzlt?key=3Dz3dM0-Cr9WzKyLauPVBgWw" width=3D"126" height=3D"54" style=3D=
"margin-left:0px;margin-top:0px"></span></span></a></p><div><br></div></spa=
n></div></div></div>

--000000000000c2a7390642b8a0f4--