Add support for PostgreSQL pg_stat_monitor extension in RDS/Aurora

2

Seems to be superior to the pg_stat_statements extension:

https://docs.percona.com/pg-stat-monitor/

profile picture
asked 6 months ago511 views
1 Answer
0

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

AWS
SUPPORT ENGINEER
answered 6 months ago
profile picture
EXPERT
reviewed 6 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions