Links
Comment on page
📣

Release Notes

Please refer to the documentation to upgrade Datasentinel.

v2023.07

Sep 1, 2023

Agentless Configuration

Enhanced provider selection functionality: added the ability to choose a provider from a predefined list of values.Added Fujitsu Enterprise Postgres as a new provider option when configuring a new instance.
When selecting this provider, the port is automatically set to their default port.
Improved visual representation by displaying the Fujitsu Enterprise Postgres icon alongside each relevant PG instance in Datasentinel’s navigation.

System Metrics

Introduced direct access to system metric dashboards via the pg_instance name, eliminating the requirement for the server name and resolving filter-related issues. Real-time illustration ▶️

Fixes

  • Improved scrolling functionality in the dashboard for file-systems with a large number of entries.
    Added the ability to sort file-systems by any property. Real-time illustration ▶️
  • Inaccurate outcomes appear on the Top Queries dashboard when multiple query IDs are associated with a single statement in pg_stat_statements.

v2023.05

May 10, 2023

Tooling

Tooling is now available as scripts that can be run in a terminal window on one or multiple platforms, enabling you to collect information about Datasentinel’s configuration.

Linux Compatibility

Datasentinel is now available on Red Hat Linux 9-compatible distributions such as Rocky Linux 9 or AlmaLinux 9

Python Version

The version of Python used for the backend and the agent has been upgraded to a more recent version, as well as the dependencies used.

Fixes

  • After updating the token for Agentless connections, the Live360 module is no longer functioning.

v2023.03

March 13, 2023

LDAP Authentication

Datasentinel seamlessly integrates with LDAP for user authentication.

Fixes

  • Live360 does not work since upgraded to the version 2023.02
  • When multiple parameter changes are detected, only the last one is displayed (needs agent v3.3)
  • Error when retrieving query texts of specific queries (python drivers)

v2023.02

February 15, 2023

Lock Explorer

Lock explorer makes it easy to identify blocking sessions during blocked session issues, along with the associated queries and locks.
By continuously monitoring lock activity, Datasentinel offers insights into your database’s state and assists you in addressing issues by generating blocking scenarios that give comprehensive information about lock activity during blocked session incidents.
Learn about how this feature works by referring to the Lock explorer documentation.
To take advantage of lock explorer capabilities, ensure your agents are updated to at least version 3.0 or higher

Session History

The dashboard displaying activity by process id has been replaced by a more accurate version, now showing activity by user name and client host name. Real-time illustration ▶️

Changed Parameters

Improved detection of changed parameters. A graphical annotation is now included in the main dashboard graphs to clearly indicate when a parameter change has been detected.

Collection Level

The Agent version 3.2, introduces the Collection Level feature allowing you to choose the metrics to monitor.

PostgreSQL

The embedded PostgreSQL database is now in version 14 during a full installation

Fixes

  • Query and Session history reports do not complete if query texts cannot be integrated in the PDF.
  • Execution plans are not displayed when using pg_store_plans >=1.6 on a PostgreSQL cluster < 14.
  • Values of type Decimal returned from Postgresql cannot be serialized to JSON format when using the alerting module.

v2022.11

November 13, 2022

Alerting

Alerting is a new feature in this version, enabling seamless monitoring of your PostgreSQL clusters and providing instant notifications for any detected issues.
Refer the Alerting documentation on how to configure and manage alerts. You also have the capability to generate custom alerts using the Alerting API.
To take advantage of alerting capabilities, ensure your agents are updated to at least version 3.0 or higher

WAL activity

A new dashboard displaying the WAL and Archiving activity for an instance has been added. Real-time illustration ▶️

Replication

The number of physical replications is now displayed as a badge in the instance statistics dashboard.

PostgreSQL 15

Support for PostgreSQL 15

Fixes

  • Minor bugs fixed
Since this version, logging nginx access and influxdb queries are disabled by default on a fresh installation.
Refer to the FAQ, to configure logging generated by nginx and influxdb

v2022.07

July 19, 2022

Audit

User action auditing mechanism.

v2022.06

June 20, 2022

Top Queries

A flag per execution option has been introduced in the Top Queries module, enabling you to calculate metrics on a per-execution basis. For instance, you can display queries that incur the highest disk reads for each execution.

Fixes

  • Retrieval of query execution statistics improved

v2022.05

June 1, 2022

Session History

The session workload module has been renamed to Session History for clarity

Cascading Replication

Datasentinel now makes it possible to monitor all the clusters (primary, replicas) of a cascading PostgreSQL replication.
To take advantage of lock explorer capabilities, ensure your agents are updated to at least version 2.9.5 or higher

v2022.04

May 5, 2022

System Metrics

In addition to the existing PostgreSQL metrics, the 3 small graphs on the Session History, Top Queries, Top Tables dashboards now have the capability to display certain system metrics.
Correlating system activity with PostgreSQL activity becomes even easier and more efficient
Available metrics:
  • Server: busy time
  • Server: load
  • Server: server reads
  • Server: server writes
  • Server: read time
  • Server: write time
  • Server: swap
  • Server: swap activity
  • Server: memory
  • Server: network bytes
  • Server: network packets
System Metrics

Execution Plans

The number of distinct execution plans is now displayed as a badge allowing you to quickly see if multiple plans exist for a query (requires pg_store_plans extension)
Execution Plans

Fixes

  • Better fluidity of navigation on the graphical interface

v2022.03

March 31, 2022

Fixes

  • Stopping the backend service now kills any remaining process
  • The scheduler now works in local time and not in utc time
  • The platform and the agent are compatible with the latest version of pg_store_plans (1.6.1)

v2022.02

March 7, 2022

Reporting

Customize and generate a report in a few clicks.
Can include one or multiple instances.
Ability to filter the report on a particular database.
Schedule your daily or weekly reports at the chosen date and time with sending to a mailing list.
Reports can be generated in an automation flow thanks to the Reporting API.
Multiple types of predefined reports.

v2022.01

January 31, 2022

Fixes

  • Performance improvements on the homepage
  • Better handling when an influxdb problem occurs. (Agent detection)

v2021.10

Oct 18, 2021

Docker / Kubernetes

The platform is now accessible via Docker and Kubernetes.

User API

A comment property has been added to User Management API

PostgreSQL 14

Datasentinel is compatible with PostgreSQL 14, taking into account the query_id column in the sampling of active sessions (pg_stat_activity)

Progress Reporting

Real-time progress reporting for COPY operations is now implemented in the Live360 module.

v2021.07

July 26, 2021

User management via API

Manage users and roles through the API.

Linux Compatibility

The platform is now available on Debian Buster and Debian Stretch distributions

Docker

The agent is available as a container image.

Fixes

  • When transitioning to a new PostgreSQL cluster, DataSentinel now automatically selects all databases when the chosen database selection is unavailable. This prevents errors from occurring.
To take advantage of this fix, ensure your agents are updated to at least version 2.6.0 or higher

v2021.05

May 01, 2021

High Availability Architecture

You now have the capability to monitor your complete architecture, including both the master and read-only replicas.
To take advantage of this feature, ensure your agents are updated to at least version 2.6.0 or higher

v2021.04

Apr 01, 2021

Homepage

Directly view the activity of your instances or groups of instances thanks to the customisable charts.

Correlate Activity Metrics.

Customizable charts have been introduced to the Session History, Top Queries, and Top Tables modules. These charts facilitate the seamless correlation of activity metrics.

Session History

Execution statistics from pg_stat_statements are now presented in the Session History module.

Query Samples

Query samples are now collected, with a maximum of one per hour. This feature can be disabled at the instance level through the API.

Dark Mode

An icon resembling a moonlight is now situated at the top right corner of the screen. This enables users to easily toggle between dark and light modes.

Fixes

  • Sql Text format option in query dashboard
  • Live360 Blocking sessions, maintenance operations when using PostgreSQL 9.6
  • Live360 layout in sessions dashboard when using a small screen resolution

v2021.02

Feb 01, 2021

Live360

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, a tool designed to provide an in-depth view of statistics. This includes detailed insights into tables, indexes, columns, extended statistics, and more.
  • Disk and Memory cache usage.
  • Generate execution plans for any query and analyze them using our execution plan visualizer.
  • Real-time progress reporting for various operations such as Vacuum, Analyze, Index creation and more.

v2020.12

Dec 09, 2020

System Metrics

Datasentinel can obtain system metrics using the Agentless method by installing the system_stats extension

Top Tables

Visualize the most commonly used Tables or Indexes, based on metrics like disk reads, cache activity, or any other specified criterion.

Version Naming

New version name convention

v1.6.0

May 11, 2020

Agentless method

Introducing the latest Agentless version, offering comprehensive monitoring capabilities for a wide range of PostgreSQL instances, including:
  • AWS RDS and Aurora
  • Microsoft Azure databases, including hyperscale
  • Google Cloud SQL, as well as other cloud providers.

v1.5.0

Mar 30, 2020

Reporting

We've introduced a Reporting feature, which includes the ability to generate PDF reports. Additionally, you can create your reports programmatically using the API.

Fixes

  • Fix pagination on some dashboards in the UI.

v1.4.0

Feb 18, 2020

Top Queries

Query statistics display the minimum and maximum execution time

Export Metrics

Metrics can now be directly downloaded from the user interface. JSON or CSV format
Export Metrics in JSON or CSV format

Fixes

  • Fix layout in the top queries dashboard
  • Fix tab layout in the instance dashboard

v1.3.0

Jan 14, 2020

Execution Plans

Analyzing execution plans is now simplified with the Plan Viewer feature. You have the flexibility to copy/paste existing plans in text or JSON format, as well as view them directly within the execution plans dashboard.
Execution Plan viewer

Index usage

Index usage statistics are now accessible, allowing you to identify the most frequently used indexes.

Fixes

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

v1.2.0

Dec 19, 2019

Starred Instances

You now have the option to star PostgreSQL instances. This enables you to filter and view only your starred instances.
Starred Instances

Instance Tags

Instance tags are now visible on both the home page and the instances dashboard. This enables convenient filtering by tag for streamlined navigation.

Fixes

  • When updating a user email, the user properties are lost
  • Home page reload does not work properly in some cases

v1.1.0

Nov 12, 2019

Grafana

Upgraded to version 6.4.4

User profile

We've introduced two user profiles: Developer and Data Admin. The Developer profile offers access exclusively to the Session History and Top Queries sections.

Fixes

  • Query id with unknown filters

v1.0.0

Oct 2019

First Release

The inaugural release of Datasentinel is now available