Re: Measuring database IO for AWS RDS costings - Mailing list pgsql-admin

From David Osborne
Subject Re: Measuring database IO for AWS RDS costings
Date
Msg-id CAKmpXCeJMJ-VsisJe8_Cc2d3soKH4VvgZmUz5oTquxcVvK7bkw@mail.gmail.com
Whole thread Raw
In response to Re: Measuring database IO for AWS RDS costings  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgsql-admin

You're right that they are 8kB blocks (by default). But it's not read from disk, is more "postgresql asks the OS to give it the blocks". They may come from the disk, but they also may come from the OS disk cache. You can't find actual disk reads and writes from PostgreSQL.

Thanks.
That makes it a bit tricky then.
So my best bet might be running iostat on the physical server and calculating Blk_read + Blk_wrtn for a period (4kb blocks in this case) and using that to estimate how many 16kb IO's that might translate to on AWS's RDS service for a month.


--
David 

pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_upgrade hangs
Next
From: John Scalia
Date:
Subject: Re: pg_upgrade hangs