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.
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.
The same Metrics module that you’ve enjoyed for 1 year is now available for your database dashboard as well:
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.
Real time logs is here as well. Very practical when you need to audit the last operations done by your database.
Running Queries for Scalingo PostgreSQL
In this round of implementation, we took extra care of PostgreSQL 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.
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 replica sets for MongoDB, cluster for Elasticsearch and hot standby for PostgreSQL.