Add support for PostgreSQL pg_stat_monitor extension in RDS/Aurora

Amazon Aurora PostgreSQL and RDS PostgreSQL supports the extensions described in the AWS documentation below, but as you know, unfortunately, this extension does not include “pg_stat_monitor”.

[+] https://docs.aws.amazon.com/AmazonRDS/latest/PostgreSQLReleaseNotes/postgresql-extensions.html

[+] https://docs.aws.amazon.com/AmazonRDS/latest/PostgreSQLReleaseNotes/postgresql-extensions.html

However, I would like to kindly inform you that a request for this feature has already been prepared to support "pg_stat_monitor", an our internal team is continuously working on it to add this feature to support

please note , such additionally requests are rigorously tested and validated before customers use them. Therefore, unfortunately, as a support engineer, we are unable to provide an ETA on when the feature will be implemented and released because the schedule for the release of the new feature is unknown.

So please keep an eye out for future announcements about our blog posts, new news, and the requested feature release on the forum page below.

[+] RDS News - https://aws.amazon.com/new/

[+] AWS Database Blog - https://aws.amazon.com/blogs/database/

[+] AWS Forums - https://forums.aws.amazon.com/forum.jspa?forumID=60

However Currently you can kindly use the pg_stats_extension, where it tracks statistics across all databases of the server. To access and manipulate these statistics, the module provides views pg_stat_statements and pg_stat_statements_info, and the utility functions pg_stat_statements_reset and pg_stat_statements.

https://www.postgresql.org/docs/current/pgstatstatements.html