After upgrading, most of the metrics ahve a unit of Connections things like Request rate whitch should be Seconds. I put in a ticket with support. This is what they sent.
- I found a related case where a customer found a possible workaround. "The issue stems froma change where "databases session metrics for postgreSQL databases have been deprecated and replaced by database connections. The upgrade script that handles this transition appears to have incorrectly mapped the vase majority of metrics to the db_connections base_r_id, regardless of their actual metric type."
- Informed that this issue may hit a BUG.
- Provided the workaround to the customer: The r_id field in that table contains an expanded version of the data that is in the base_r_id field. A series of selection statements and update statements to revise each metric type in the base_r_id field carefully. (Note; they did not send me these actual select statements)
So I would like to fix these, but don't know what they should be set to (I could guess). Anyone have a list that I could use that I can update, or better yet the SQL to update them?
