Have you had experience tracking the state and performance of databases?

Yes, experience in monitoring the health and performance of databases includes using monitoring tools such as Prometheus, Grafana, Percona Monitoring and Management (PMM) for MySQL, or built-in tools like Performance Insights in AWS RDS. Key metrics to monitor include CPU load, memory usage, number of active connections, query response time, number of locks, and slow queries.

For example, for PostgreSQL, you can set up statistics collection for slow queries and use pg_stat_statements for performance analysis. This helps identify bottlenecks and optimize queries or database configuration.