Posted On: Jul 27, 2021

Amazon Aurora PostgreSQL-Compatible Edition adds support for the pg_proctab extension in AWS GovCloud (US) regions. pg_proctab is a collection of stored functions that can access the operating systems process table so that system statistics can be queried through the database. pg_proctab functions make it easier to collect data on your PostgreSQL database including up-to-date information on processor and I/O statistics on SQL queries which makes troubleshooting easier.

You can view a list of all PostgreSQL extensions supported on RDS on the AWS User Guide. With this regional expansion, pg_proctab is available in all commercial regions. For full feature parity list, head to our feature parity page, and to see all the regions that support Amazon Aurora head to our region page.

Amazon Aurora combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. It provides up to three times better performance than the typical PostgreSQL database, together with increased scalability, durability, and security. For more information, please visit the Amazon Aurora product page. To get started with Amazon Aurora, take a look at our getting started page.

Don't see an extension you'd like to use? Let us know through the AWS Forum, through AWS Enterprise supporct.

Modified 9/27/2021 – In an effort to ensure a great experience, expired links in this post have been updated or removed from the original post.