📣Release Notes
Last updated
Last updated
Please refer to the documentation to upgrade Datasentinel.
Oct 18, 2024
Fully compatible with the latest PostgreSQL 17 release
The backend includes upgraded third-party libraries for better performance, security, and compatibility
Refer to the Agent Release Notes
Tags are lost in memory (though still persisted on disk) when updating an agentless connection without specifying them.
Apr 10, 2024
Users can be assigned multiple roles, moving beyond the previous one-role limit. This update offers increased flexibility and precision in access control, available both through the UI and API, enhancing both ease of use and security
Please be aware that the
rolefield in our User API has been deprecated. We've introduced the new fieldrolesas its replacement.rolesis designed to accommodate multiple roles for a single user.
Refer to the Agent Release Notes
Feb 15, 2024
We've introduced an option to manage access for users created via LDAP integration. By default, such users have access to all instances. With this update, you can choose to restrict user access until a specific role is assigned in their properties. This option is configurable through the Global Settings Dashboard, offering better control over permissions.
Fixed a bug where the backend API failed to start if the PID in /datasentinel/log/.pid_datasentinel_apis was active but belonged to another process.
Jan 22, 2024
PostgreSQL 16 introduces an exciting enhancement to database monitoring and performance tuning with the pg_stat_io system view.
This feature provides detailed insights into the I/O behavior of PostgreSQL servers. A new dashboard has been introduced, starting from version 16, to facilitate a deeper understanding of I/O insights.
Updated wait event descriptions to reflect the latest version's details. Refer to our Documentation for guidance on displaying wait event descriptions effectively in your monitoring workflow.
Update colors in main Session History chart for more clarity. Real-time illustration ▶
Transformed the Top Queries chart into a staircase chart for enhanced data visualization Real-time illustration ▶
Each monitored instance now displays its corresponding local agent Id. This makes it easier for users to identify specific instances, especially when managing a large number of databases.
Dynamic Filters for Enhanced Navigation
Monitoring Status Filter Quickly filter instances by their monitoring status
Connection State Filter This filter allows users to view instances based on their connection state, enabling quick toggling between enabled or disabled states.
Agent ID Filter Efficiently locate instances using their local agent Id.
We've enhanced our Agentless service startup, ensuring quicker launch times and improved performance, especially beneficial for large-instance environments during system boots or post-upgrade reboots.
Log any issues encountered during instance monitoring, such as initialization errors, directly into the platform. These issues are then displayed in the UI.
Each registered instance now displays its monitoring status.
Added Monitoring Status Filter Quickly filter instances by their monitoring status Real-time illustration ▶
A new tool,
dump_config.sh, has been incorporated into our suite of scripts, in order to dump defined roles, user settings, agentless connections, and alert rules.These are saved in multiple
dump*.txtfiles in InfluxQL format, perfect for restoration or migration purposes on other platforms.
The API now supports the creation of LDAP users.
Enhance your dashboard experience with two new buttons!
The first button brings you a Tip of the Day, offering daily insights to improve your usage and knowledge of Datasentinel. The second button instantly connects you to relevant documentation for your current dashboard context, making information access quick and effortless.
The embedded PostgreSQL database is now in version 15.5 during a full installation
Fully compatible with the newest release, PostgreSQL Version 16.
Updated third-party libraries.
Send any issues encountered during instance monitoring directly to the platform.
In the blocked session panel, the database and users are reversed, displaying user information under database and vice versa. Real-time illustration ▶
The total size of the Generated WAL displayed is inaccurate in the PostgreSQL Instance Information panel. Real-time illustration ▶
Tooltip display issue in the charts on the homepage when using the Dark Theme. Real-time illustration ▶
When a user is configured with Role-Based Access, the Server Metrics fail to display.
Sep 1, 2023
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.
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 ▶️
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.
May 10, 2023
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.
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.
March 13, 2023
Datasentinel seamlessly integrates with LDAP for user authentication.
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)
February 15, 2023
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
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 ▶️
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.
The Agent version 3.2, introduces the Collection Level feature allowing you to choose the metrics to monitor.
The embedded PostgreSQL database is now in version 14 during a full installation
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.
November 13, 2022
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
A new dashboard displaying the WAL and Archiving activity for an instance has been added. Real-time illustration ▶️
The number of physical replications is now displayed as a badge in the instance statistics dashboard.
Support for PostgreSQL 15
Minor bugs fixed
July 19, 2022
User action auditing mechanism.
June 20, 2022
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.
Retrieval of query execution statistics improved
June 1, 2022
The session workload module has been renamed to Session History for clarity
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
May 5, 2022
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
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)
Better fluidity of navigation on the graphical interface
March 31, 2022
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)
March 7, 2022
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.
January 31, 2022
Performance improvements on the homepage
Better handling when an influxdb problem occurs. (Agent detection)
Oct 18, 2021
The platform is now accessible via Docker and Kubernetes.
A comment property has been added to User Management API
Datasentinel is compatible with PostgreSQL 14, taking into account the query_id column in the sampling of active sessions (pg_stat_activity)
Real-time progress reporting for COPY operations is now implemented in the Live360 module.
July 26, 2021
Manage users and roles through the API.
The platform is now available on Debian Buster and Debian Stretch distributions
The agent is available as a container image.
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
May 01, 2021
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
Apr 01, 2021
Directly view the activity of your instances or groups of instances thanks to the customisable charts.
Customizable charts have been introduced to the Session History, Top Queries, and Top Tables modules. These charts facilitate the seamless correlation of activity metrics.
Execution statistics from pg_stat_statements are now presented in the Session History module.
Query samples are now collected, with a maximum of one per hour. This feature can be disabled at the instance level through the API.
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.
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
Feb 01, 2021
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.
Dec 09, 2020
Datasentinel can obtain system metrics using the Agentless method by installing the system_stats extension
Visualize the most commonly used Tables or Indexes, based on metrics like disk reads, cache activity, or any other specified criterion.
New version name convention
May 11, 2020
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.
Mar 30, 2020
We've introduced a Reporting feature, which includes the ability to generate PDF reports. Additionally, you can create your reports programmatically using the API.
Fix pagination on some dashboards in the UI.
Feb 18, 2020
Query statistics display the minimum and maximum execution time
Metrics can now be directly downloaded from the user interface. JSON or CSV format
Fix layout in the top queries dashboard
Fix tab layout in the instance dashboard
Jan 14, 2020
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.
Index usage statistics are now accessible, allowing you to identify the most frequently used indexes.
In the Top Queries dashboard, labels display the sql text (truncated if needed) instead of the query md5 id.
Dec 19, 2019
You now have the option to star PostgreSQL instances. This enables you to filter and view only your starred instances.
Instance tags are now visible on both the home page and the instances dashboard. This enables convenient filtering by tag for streamlined navigation.
When updating a user email, the user properties are lost
Home page reload does not work properly in some cases
Nov 12, 2019
Upgraded to version 6.4.4
We've introduced two user profiles: Developer and Data Admin. The Developer profile offers access exclusively to the Session History and Top Queries sections.
Query id with unknown filters
Oct 2019
The inaugural release of Datasentinel is now available
Docker
Kubernetes
