Release notes¶
June 20, 2022 (v2022.06)¶
Features
- 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
- Retrieval of query execution statistics improved
June 1, 2022 (v2022.05)¶
Features
- 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 (needs agent version 2.9.5 minimum)
May 5, 2022 (v2022.04)¶
Features
- 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 efficientAvailable 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)
Fixes
- Better fluidity of navigation on the graphical interface
March 31, 2022 (v2022.03)¶
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)
March 7, 2022 (v2022.02)¶
Advanced reporting features
- 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 APIMultiple types of predefined reports:- Session history report
PDF
- Top queries reportPDF
- Table reportPDF
- Instance reportPDF
- Server reportPDF
- Data size reportPDF
- Full report (includes all previous reports)PDF
- Detailed report of a queryPDF
January 31, 2022 (v2022.01)¶
Fixes
- Performance improvements on the homepage
- Better handling when an influxdb problem occurs. (Agent detection)
October 18, 2021 (v2021.10)¶
Features
- The platform is now available on Docker, Kubernetes
- A comment property has been added to User Management API
- 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)- COPY progress reporting in the Live360 module
July 26, 2021 (v2021.07)¶
Features
- User and Role management with API ( See our Blog Post )
- The platform is now available on Debian Buster and Debian Stretch distributions (see On-premises platform installation)
- The agent is available as a container image (See Docker Hub)
Fixes
- 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
- High Availability ArchitectureYou 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
- Directly view the activity of your instances or groups of instances thanks to the Home page customisable charts
- Customisable charts have also been added to the Session history, top queries and top tables/indexes modules, in order to easily correlate activity metrics
- The main queries execution statistics from pg_stat_statements are now displayed in the Session history module when available
- Query samples are now collected (Maximum 1 per hour). This feature can be disabled at the instance level via API.
- A moonlight icon is available on the top right of the screen allowing to switch between dark or light mode
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
- Live360 cache usage
Home page customisable charts¶

Session history¶

Feb 01, 2021 (v2021.02)¶
Features
- 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° DocumentationView our demo video
Dec 09, 2020 (v2020.12)¶
Features
- Datasentinel can retrieve system metrics with the Agentless method if you install the system_stats extension
- Easily display the most frequently used Tables or Indexes (By disk reads, Cache activity or any other metric)
- New version name convention
May 11, 2020 (v1.6.0)¶
Features
- 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 managementor with the Connection Management API
User interface connection management¶

March 30, 2020 (v1.5.0)¶
Features
- Added Reporting. (Here is an example
pdf
)You can also generate your report with Workload API 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.

February 18, 2020 (v1.4.0)¶
Features
Added API to export metrics. See Workload API
Query statistics display the minum and maximum execution time
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
January 14, 2020 (v1.3.0)¶
Features
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

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

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

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

Fixes
November 12, 2019 (v1.1.0)¶
Features
Upgrade to grafana 6.4.4
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