Request a Demo
Home   >   mailing lists

Postgres Load Profile - Mailing list pgsql-admin

From Sam Stearns
Subject Postgres Load Profile
Date
Msg-id CAN6TVjmH8=dszn3WqSE4MsYEZgCT1gQhufoSnPBn-Omcu9-EkQ@mail.gmail.com
Whole thread Raw
Responses Re: Postgres Load Profile
Re: Postgres Load Profile
List pgsql-admin
Tree view
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


pgsql-admin by date:

Previous
From: Xuneng Zhou
Date:
Subject: Re: Question on pg_stat_io showing zero reads/writes for I/O workers
Next
From: Ron Johnson
Date:
Subject: Re: Postgres Load Profile