Fix DatabaseConnectionsCurrentlySessionPinned metric on RDS Proxy dashboard
Currently on the default dashboard for RDS proxy the DatabaseConnectionsCurrentlySessionPinned metric is always empty despite the fact that hundreds of connections are being pinned. After consulting AWS support we were informed that this metric is actually a snapshot which is quite confusing and not useful for users.
The DatabaseConnectionsCurrentlySessionPinned metric in RDS proxy dashboard should be fixed so it actually matches the number of occurrences of connection pinning. We can see the correct metric if we access that via Cloudwatch metrics, the same metric query should be used to populate the default RDS proxy dashboard.
Hi Andre de Camargo
I understand that on the default dashboard for RDS proxy the DatabaseConnectionsCurrentlySessionPinned metric is always empty despite the fact that hundreds of connections are being pinned. After consulting AWS support we were informed that this metric is actually a snapshot which is quite confusing and not useful for users. Please correct me if my understanding is wrong.
The above metrics is a direct result of Dimension set. You can use the following commands to verify that all components of the connection mechanism can communicate with the other components. Examine the proxy itself using the describe-db-proxies command. Also examine the associated target group using the describe-db-proxy-target-groups Check that the details of the targets match the RDS DB instance or Aurora DB cluster that you intend to associate with the proxy.
Use the following commands. aws rds describe-db-proxies --db-proxy-name $DB_PROXY_NAME aws rds describe-db-proxy-target-groups --db-proxy-name $DB_PROXY_NAME
You can change certain settings associated with a proxy after you create the proxy. You do so by modifying the proxy itself, its associated target group, or both. Each proxy has an associated target group.
I hope the above information is helpful.
Seems like CloudWatch console you can see the metrics but not from the RDS console. I would suggest raise a feature request or bug report request from the RDS console lower left corner Feedback button.
Seems like you also have support plan available, you may raise the same concern through support case as well.
As this metrics is a periodic snapshots, using the RDS proxy log to search "The client session was pinned to the database connection" can be another method of seeing the actual pined sessions.
About expecific metric in rds awsasked a month ago
RDS Proxy Metricsasked 6 months ago
RDS Proxy on MySQL Lambda Function (C# .Net Core 3.1 Runtime)asked 6 months ago
Some metrics missing for RDS proxy MySql AuroraAccepted Answerasked 6 months ago
Why the LoginFailures metric showing no data for RDS MySQL instance?asked 3 years ago
Behavior with regard to open connections when changing rds proxy targetasked a month ago
RDS (OS) update is available - Don´t see it in RDS Dashboardasked a month ago
Fix DatabaseConnectionsCurrentlySessionPinned metric on RDS Proxy dashboardasked 20 days ago
RDS Proxy raises InvalidParameterValue errorAccepted Answerasked 2 years ago
RDS: Postgress Instances missing from dashboardasked 5 months ago