Measuring database IO for AWS RDS costings

From: David Osborne <david(at)qcode(dot)co(dot)uk>
To: pgsql-admin(at)postgresql(dot)org
Subject: Measuring database IO for AWS RDS costings
Date: 2014-08-13 13:45:52
Message-ID: CAKmpXCfownh7ZuEgPPeZLX+Hs0D4aGZMvSiwWdpw3qC3-A533g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

We have a test Postgresql AWS RDS instance running with a view to
transferring our Live physical Postgresql workload to AWS.

Apart from the cost of the instance, AWS also bill for IO requests per
month.

We are trying to work out how to estimate the IO costs our Live workload
would attract.
So if we can confirm metrics x+y measured from within our test Postgresql
instance on RDS maps to z billable IO requests, then we can measure the
same metrics from our Live Postgresql server and estimate costs.

I believe in the AWS world an IO request is each 16kb read or written to
disk.
How would I go about measuring 16kb blocks read or written to disk from
within Postgresql?

I was hopeful of pg_stat_database which has blks_read (which I believe are
8kb blocks), but there doesn't seem to be an equivalent for blks_written?

Can anyone give us any pointers?

Regards,
--
David

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Guillaume Lelarge 2014-08-13 18:50:13 Re: Measuring database IO for AWS RDS costings
Previous Message Craig James 2014-08-11 14:24:16 Re: Replication: Latest, greatest resources?