Improved Database Dashboards

July 14, 2017 - 10:00AM

We are pleased to announce some improvements on the database dashboards. We’ve added long awaiting features like logs and metrics display for all database addons. For Scalingo Postgresql users, we’ve also added a “running queries” panel.

Connection infos

Basic connection infos are now listed in the “Overview” tab. It’s now more clear on how to access directly your database, either by establishing an SSH tunnel via our CLI tool or by launching an interactive console.

Scalingo MongoDB Overview Tab

Metrics

The same Metrics module that you’ve enjoyed for 1 year is now available for your database dashboard as well:

Scalingo Postgresql Metrics Tab

For the moment, it includes the same metrics than your application containers. It reports CPU, RAM and Swap usage and you can see the last 3, 12, 24, 48 or 72 hours in the past.

Logs

Real time logs is here as well. Very practical when you need to audit the last operations done by your database.

Scalingo MongoDB Logs Tab

Running Queries for Scalingo Postgresql

In this round of implementation, we took extra care of Postgreql users with the “Running Queries” tab. It shows you the current running queries on your PG database. You can then cancel or terminate those queries (with pg_cancel_backend and pg_terminate_backend). With those two functions you won’t be stuck anymore and you will be able to take care of your database all by yourself.

Scalingo Postgresql Running Queries Tab

The Future

We know that having a nice view of slow queries is still missing. We’ll add a new panel in the future for the Scalingo Postgresql addon, based on the pg_stat_statements extension.

In the mean time we’re hard at work to propose in the coming months multiple node setup for our database addons. Think about replicasets for MongoDB, cluster for Elasticsearch and hot standby for Postgresql.