Amazon Aurora PostgreSQL supports the pg_proctab extension to access PostgreSQL system stats in AWS GovCloud (US) Regions

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.

Source:: Amazon AWS