← Dashboards Databases — Postgres and MySQL Standard Part 2
Postgres and MySQL vitals from the native SQL checks: connections, transactions, cache hit ratio, replication lag, threads, questions and slow queries.
Panels light up when the source family's data is in the store.
Postgres connections by state Part 2 avg:postgres.connections{*} by {host, state}
Postgres commits (per 5 min) Part 2 sum:postgres.transactions.commit{*}.rollup(sum, 300) by {host}
Postgres cache hit ratio Part 2 avg:postgres.cache.hit_ratio{*} by {host}
Postgres replication lag Part 2 avg:postgres.replication.lag{*} by {host}
Postgres database size Part 2 avg:postgres.database.size{*} by {host}
MySQL threads connected Part 2 avg:mysql.performance.threads_connected{*} by {host}
MySQL questions (per 5 min) Part 2 sum:mysql.performance.questions{*}.rollup(sum, 300) by {host}
MySQL InnoDB buffer pool hit ratio Part 2 avg:mysql.innodb.buffer_pool_hit_ratio{*} by {host}
MySQL slow queries (per 5 min) Part 2 sum:mysql.performance.slow_queries{*}.rollup(sum, 300) by {host}