| From: | Sam Stearns <sam(dot)stearns(at)dat(dot)com> |
|---|---|
| To: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Cc: | Henry Ashu <henry(dot)ashu(at)dat(dot)com> |
| Subject: | Postgres Load Profile |
| Date: | 2025-11-03 22:56:27 |
| Message-ID: | CAN6TVjmH8=dszn3WqSE4MsYEZgCT1gQhufoSnPBn-Omcu9-EkQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2025-11-04 02:49:01 | Re: Postgres Load Profile |
| Previous Message | Xuneng Zhou | 2025-11-01 00:41:33 | Re: Question on pg_stat_io showing zero reads/writes for I/O workers |