Is there a library/technique to perform database analysis in RStudio ?
I've my RStudio connected to Postgres using library(DBI). Now can we identify database performance metrics and start performing analysis such as;
Database Throughput
Database Response or Latency
Other indicators
Basically, some database analysis report on their performance metrics.