v23 : Parameters specified at different levels and scope are analyzed. Named container, Patroni detection and many more

[jobinau]

Features

• New feature: Parameters specified at the user and db level will be displayed in the report along with other locations of parameter specification.
• Additional analysis queries for User and database-level settings
• parameter recommendation of bgwriter_lru_maxpages based on calculated values, row in parameters is highlighted only on those cases where it is required
• Checks for idle_session_timeout and idle_in_transaction_session_timeout
• New checkpointer effectiveness check
• Core : Global parameter array and Global string for collecting all emitted findings from different parts of the code
• Core : improvements to the despatcher functions and
• UI : Bottom menu rework. New format for Popup of section indexes for easy navigation.
• PostgreSQL 16 support included
• Indexes and unused indexes in per table summary popup
• Named docker container pg_gather and reuse if there is already one. Speeding up multiple report generations
• New fetch and hit data collection (Not yet in the report)
• Patroni/HA cluster detection with cluster name, Protection from accidental Aurora usage
• Invalid Indexes queries
• Unused indexes out of total indexes and space wasted is reported in findings

Documentation

1. Demo video on data collection
2. Demo video on report generation (manual)
3. Demo video on report generation using container

Fixes

1. SQL mistake which caused nulls appearing on parameter location
2. pg_gather unable to get the major version information in partial gathering
3. Bug fix for JS error if the obj.params.f1 is null
4. Hex conversion fixes
5. Emergency fix for last_archived_wal showing the history file

---

This discussion was created from the release v23 : Parameters specified at different levels and scope are analyzed. Named container, Patroni detection and many more.