Release notes

July 26, 2021 (v2021.07)

Features

  1. User and Role management with API ( See our Blog Post )
  2. The platform is now available on Debian Buster and Debian Stretch distributions (see On-premises platform installation)
  3. The agent is available as a container image (See Docker Hub)

Fixes

  1. Live360 module:
    When switching to a new PostgreSQL cluster, Datasentinel now selects automatically All databases when the keeped database selection does not exist, avoiding an error.

Minimum Agent version : 2.6.0

May 01, 2021 (v2021.05)

Features

  1. High Availability Architecture
    You can now monitor your entire architecture (master + read only replicas) See our Blog Post

Minimum Agent version : 2.6.0

Apr 01, 2021 (v2021.04)

Features

  1. Directly view the activity of your instances or groups of instances thanks to the Home page customisable charts
  2. Customisable charts have also been added to the Sessions workload, top queries and top tables/indexes modules, in order to easily correlate activity metrics
  3. The main queries execution statistics from pg_stat_statements are now displayed in the Sessions workload module when available
  4. Query samples are now collected (Maximum 1 per hour). This feature can be disabled at the instance level via API.
  5. A moonlight icon is available on the top right of the screen allowing to switch between dark or light mode

Fixes

  1. Sql Text format option in query dashboard
  2. Live360 Blocking sessions, maintenance operations when using PostgreSQL 9.6
  3. Live360 layout in sessions dashboard when using a small screen resolution
  4. Live360 cache usage

Home page customisable charts

Home page charts

Sessions workload

Customisable charts and queries statistics

Feb 01, 2021 (v2021.02)

Features

  1. Datasentinel introduces its new Live360° feature:

    Thanks to direct connections, this feature provides precision and additional information on the context, which will offer you a valuable and indispensable help during your performance analyzes
    - Current and blocking sessions
    - Relations Explorer to view statistics in detail (tables, indexes, columns, extended statistics, …)
    - Disk and memory cache usage
    - Generate execution plans from any query and analyze them thanks to our execution plan visualizer
    - In progress reporting (Vacuum, analyze, create index, …)

    See Live 360° Documentation

    View our demo video
    Live360 user

Dec 09, 2020 (v2020.12)

Features

  1. Datasentinel can retrieve system metrics with the Agentless method if you install the system_stats extension
  2. Easily display the most frequently used Tables or Indexes (By disk reads, Cache activity or any other metric)
  3. New version name convention

May 11, 2020 (v1.6.0)

Features

  1. New Agentless version allowing you to monitor all kinds of PostgreSQL instances
    - AWS RDS, Aurora
    - Microsoft Azure database, hyperscale,
    - Google Cloud SQL and other cloud providers.

    It can also be used in your own environment. (See which method to use Agent-based or Agentless?

    Connections can be created either with the User interface connection management

User interface connection management

connection management

March 30, 2020 (v1.5.0)

Features

  1. Added Reporting. (Here is an example pdf)
    You can also generate your report with Workload API
  2. The Datasentinel extension is no longer required. (Required only when you choose the high level of collection). See Sessions workload

Fixes

  • Fix pagination on some dashboards in the UI.

Export your workload in PDF format

Select a PostgreSQL instance, a time window and the sections to export.

Export workload in PDF format

February 18, 2020 (v1.4.0)

Features

  1. Added API to export metrics. See Workload API

  2. The metrics can now be downloaded directly from the UI

  3. Query statistics display the minum and maximum execution time

  4. Session workload sampling can be low (every 10 seconds) or high (every second). Updatable with the Agent

Fixes

  • Fix layout in the top queries dashboard

  • Fix tab layout in the instance dashboard

The metrics can now be downloaded directly from the UI

JSON or CSV format

Download metrics

January 14, 2020 (v1.3.0)

Features

1. Execution plan viewer

2. Index usage statistics

Fixes

  • In the Top queries dashboard, labels display the sql text (truncated if needed) instead of the query md5 id.

1. Execution plan viewer

The execution plans can be easily analyzed thanks to the plan viewer feature.

You can copy/paste an existing plan (format text or json) or view it directly in the execution plans dashboard

PostgreSQL Execution plans

2. Index usage statistics

Index usage statistics are now available. You can see what are the most used indexes.

PostgreSQL indexes usage statistics

Fixes

  • In the Top queries dashboard, labels display the sql text (truncated if needed) instead of the query md5 id.

December 19, 2019 (v1.2.0)

Features

1. Starred instances

2. Instance tags:

Fixes

  • When updating a user email, the user properties are lost

  • Home page reload does not work properly in some cases

1. Starred instances

The postgresql instances can be starred. You can choose to see your starred instances only

Starred instances

2. Instance tags:

The instance tags can be displayed in the home page and in the instances dashboard. You can then easily filter by tag

Starred instances

Fixes

November 12, 2019 (v1.1.0)

Features

  1. Upgrade to grafana 6.4.4

  2. Developer or data admin user profile. A developer profile has only access to sessions workload and queries

Fixes

  • Query id with unkonwn filters

October 2019 (v1.0.0)

Features

  • Sessions workload

  • Sqls statistics

  • Instances, databases statistics

  • Powerfull filters

  • Consolidated or detailed view of the activity

  • Real time or past view with zooming feature on the desired periods