Version 1.9

16.02.2022

New features and improvements

  • SQL Profiler:

    • Added SQL query detail functionality with granularity to plans, with the ability to analyze its execution parameters, number of calls and other useful data. This improvement provides insight into why sometimes queries are not executed efficiently enough. The extension pg_store_plans and further developed by Tantor Labs are used to get information about plans. You can find more information in the SOL Profiler User Guide. This feature is not available for PostgreSQL RDS;

  • Configuration Management

    • Added “Disk Type” button to select the type of disk on which the PostgreSQL DB is running: SSD, HDD or Network Storage. Configuring this option affects some configuration recommendations;

    • Changed indicator color from green to gray for parameters with values other than default;

    • Changed logic for the “Use Recommended Value” button. If the recommended value is the same as the current value of the parameter, the button is green;

    • Added an information message saying that the parameters were or were not applied;

  • Maintenance

    • Changed bloat and wraparound information collection logic to “on-demand” with data caching. This enhancement is primarily adapted for large DBs (terabytes) with many objects (>hundreds of thousands), allowing information to be collected in time slots when the DB is least loaded;

  • DB Inspector

    • Changed logic for collecting DB information and running healthchecks to “on-demand” with data caching. A “Collect Data” button has been added, similar to the Maintenance module. This enhancement is primarily adapted for large DBs (terabytes) with many objects (>hundreds of thousands), allowing information to be collected in time slots when the DB is least loaded;

  • Instances Screen

    • Added operating system information to the Instances table. This functionality is not available for RDS;

  • Alert Description

    • Changes have been made to the Alerts module to add useful information in future releases.