Comment on page
📣
Release Notes
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.
- 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.
- 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.
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.
- 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
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
System Metrics
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
- 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.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.
Datasentinel is compatible with PostgreSQL 14, taking into account the query_id column in the sampling of active sessions (pg_stat_activity)
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.
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:
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
Export Metrics in 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.
Execution Plan viewer
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.
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
Last modified 2mo ago