🩺Platform Diagnostics Tools

Starting with version 2025.11, two new diagnostic scripts are available to help identify issues and assist the support team.

These tools collect and display key information about the Datasentinel platform, making it easier to troubleshoot problems efficiently and provide faster resolutions.

Diagnostics

/datasentinel/soft/datasentinel_backend/scripts/datasentinel_diagnostics.sh

This script provides:

1. Detailed OS Information – Including memory usage by Datasentinel components (+ InfluxDB) and data directory sizes.

2. InfluxDB Diagnostics – Connects to the InfluxDB database to retrieve retention policies, system metrics, shard usage, and configuration settings.

3. Monitored Instance Details – Displays key information about all monitored PostgreSQL instances.

The script outputs the information directly in the terminal and also writes the results to a file located at: /tmp/datasentinel_diagnostics_<HOST_NAME>.txt

SQL Collection Limit Analysis

/datasentinel/soft/datasentinel_backend/scripts/dump_top_instance_query_texts.sh 10

This script identifies the top N PostgreSQL instances that have reached their daily SQL collection limit and extracts the query texts collected for the current day.

It accepts an optional parameter to specify the top N instances (default 5) to include in the output.

It helps analyze which queries were captured before the limit was hit, providing useful insights for troubleshooting or fine-tuning monitoring settings.

The results are saved to files /tmp/<INSTANCE_NAME>.txt