Amazon Aurora PostgreSQL monitoring metrics

[WenG]

1. May I know if Dynatrace support Aurora Postgresql V14 ? 
2. Dynatrace has all Aurora Postgresql Available Metrics ?   
3. My support team said Dynatrace only support on Aurora Postgresql V11 ?  but we are running on V14.
4. Please advise how Dynatrace ingests metrics on Aurora Postgresql ? 

[DanielS]

Hi @WenG 

1. PostgreSQL 9.4+
2. Collected metrics
      

   Active connections	Number of active connections to all databases running under PostgreSQL
   Buffer hit	Number of times disk blocks were found in buffer cache so that a read was not necessary (only includes hits in the PostgreSQL buffer cache, not the OS file system cache)
   Cache hits ratio	Percentage of accesses that result in cache hits
   Block reads	Number of disk blocks read in the database per second
   Rows returned by index scans	Number of live rows fetched by index scans
   Rows updated	Number of rows updated by queries in the database per second
   Rows inserted	Number of rows inserted by queries in the database per second
   Rows deleted	Number of rows deleted by queries in the database per second
   Rows returned by sequential scans	Number of sequential scans fetched on the table per second
   Index scans	Number of index scans initiated on the table per second
   Commits	Number of transactions committed to the database per second
   Rollbacks	Number of rolled-back transactions in the database per second

   
3. I cannot confirm v14 but running versions 11+ without problems, so...
   
4. do you want to ingest metrics? please clarify.

[WenG]

Yes, we would like to request some of aws.aurora metrics (ie. ext:cloud.aws.aurora.queries) to be ingest in Dynatrace.  are we able to do it if we are runing aurora version V14 now ? 

[WenG]

My Id only can see chart on CPUUtilization Average (ext:cloud.aws.aurora.cpuUtilizationAverage)

My Id not able to see data for the rest above metrics. But Last written​ on 2023-02-23 11:15.  Advise ? 

[DanielS]

To add or edit metrics, you can do the following:

[WenG]

Thank you so much.  

[DanielS · Accepted solution]

I guess so, I'm running 13.7 without problems. For sure v14 is supported, at least is documented.

[WenG]

I am now asking my Dynatrace support team to enable the metrics.  

By any chance you can share Dynatrace on Aurora v14 document link ?   Thanks

[DanielS]

Yes, it says 9.4 and above.

https://www.dynatrace.com/support/help/shortlink/postgresql-monitoring