Table Of Contents
Table Of Contents

Release Notes

May 10, 2023 (v2023.05)

Features

1. 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. See Tooling

2. Other

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

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

  1. After updating the token for agentless connections, the Live360 module is no longer functioning.

Please refer to the documentation to Upgrade Datasentinel

March 13, 2023 (v2023.03)

Features

1. LDAP authentication

Datasentinel seamlessly integrates with LDAP for user authentication. See LDAP settings

Fixes

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

Please refer to the documentation to Upgrade Datasentinel

February 15, 2023 (v2023.02)

Features

1. 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.
PostgreSQL alerts and notifications group by instance
Learn about how this feature works by referring to the Lock explorer documentation.

You can experience the feature through our Live demo

IMPORTANT: To be able to benefit from this feature, agents must be updated to the latest version (version 3.2 minimum)

2. 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.

3. 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.

4. Collection Level

The Agent version 3.2, introduces the Collection level feature allowing you to choose the metrics to monitor.
The agent enables customizable metric collection through Agent CLI or Agent API. UI-based modification planned (mid 2023).

5. Other

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

Fixes

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

Please refer to the documentation to Upgrade Datasentinel

November 13, 2022 (v2022.11)

Features

1. Alerting

Alerting is now available with this new version. You can easily monitor your PostgreSQL clusters and be notified in case of problems
PostgreSQL alerts and notifications group by instance
See the Alerting documentation on how to configure and manage alerts.

You can also create your own alerts through the Alerting API

IMPORTANT: To be able to benefit from alerting, agents must be updated to the latest version (version 3.0 minimum)

2. WAL activity

A new dashboard displaying the WAL and archiving activity for an instance has been added. Live demo
WAL and archiving activity for a PostgreSQL instance

3. Replication

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

4. PostgreSQL 15

Support for PostgreSQL 15

Fixes

Minor bugs fixed

Note

Since this version, loggging nginx access and influxdb queries are disabled by default on a fresh installation.

Take a look at the Frequently asked questions if you upgrade to this version, to configure logging generated by nginx and influxdb

July 19, 2022 (v2022.07)

Features

1. Audit

Audit user actions. See Audit settings

June 20, 2022 (v2022.06)

Features

1. Top queries

The flag per execution has been added in the Top queries module allowing you to compute metrics per execution.
Example: show the queries performing the most disk reads for each execution

Fixes

  1. Retrieval of query execution statistics improved

June 1, 2022 (v2022.05)

Features

1. Session history

The session workload module has been renamed to session history for clarity

2. Cascading replication

Datasentinel now makes it possible to monitor all the clusters (primary, replicas) of a cascading PostgreSQL replication (needs agent version 2.9.5 minimum)

May 5, 2022 (v2022.04)

Features

1. System metrics

Some system metrics can now be displayed, in addition to existing PostgreSQL metrics, in the small graphs present on the session history, top queries, top tables/indexes dashboards.
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
Distinct execution plans

2. 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)
Distinct execution plans

Fixes

  1. Better fluidity of navigation on the graphical interface

March 31, 2022 (v2022.03)

Fixes

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

March 7, 2022 (v2022.02)

Features

1. Reporting

Customize and generate a report in a few clicks (see Reporting)
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:
- Session history report PDF
- Top queries report PDF
- Table report PDF
- Instance report PDF
- Server report PDF
- Data size report PDF
- Full report (includes all previous reports) PDF
- Detailed report of a query PDF

January 31, 2022 (v2022.01)

Fixes

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

October 18, 2021 (v2021.10)

Features

1. Docker / Kubernetes

The platform is now available on Docker, Kubernetes

2. User API

A comment property has been added to User Management API

3. PostgreSQL 14

Datasentinel is compatible with the latest version 14 of Postgresql:
Taking into account the query_id column in the sampling of active sessions (pg_stat_activity)

4. Progress reporting

- COPY progress reporting in the Live360 module

July 26, 2021 (v2021.07)

Features

1. User management via API

User and Role management with API ( See our Blog Post )

2. Linux distributions

The platform is now available on Debian Buster and Debian Stretch distributions (see On-premises platform installation)

3. Docker

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 Session history, 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 Session history 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

Session history

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 API
  2. The Datasentinel extension is no longer required. (Required only when you choose the high level of collection). See Session history

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 API

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

  3. Query statistics display the minum and maximum execution time

  4. Session history 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 session history and queries

Fixes

  • Query id with unkonwn filters

October 2019 (v1.0.0)

Features

  • Session history

  • 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