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
demandé il y a 6 mois500 vues
1 réponse
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
INGÉNIEUR EN ASSISTANCE TECHNIQUE
répondu il y a 6 mois
profile picture
EXPERT
vérifié il y a 6 mois

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions