Check out our free resources and eBooks like: "Effective Indexing in Postgres"

2022.08.0 Release

Docker tag: quay.io/pganalyze/enterprise:v2022.08.0

Notes

  • This release requires a database migration when coming from older releases, be sure to follow the recommended upgrade steps
  • Important! This release has known issues with Postgres connections and IAM authentication that were fixed in the v2022.08.1 release

Features

  • The new pganalyze Index Advisor, powered by the pganalyze Indexing Engine
    • This is a completely new version of Index Advisor that runs per-table (instead of per-query) and gives you a recommendation that optimizes for multiple queries
    • The new Index Write Overhead metric has been introduced to balance improved read performance with the added write overhead
    • The new table writes / minute measurement helps understand which tables may see higher impact from additional indexes
    • After upgrading, expect index recommendations to show within 48 hours
    • For the best recommendations, you may need to install the new pganalyze.get_column_stats_helper
    • Read more details in the Index Advisor documentation
    • If you are not seeing any recommendations (but believe there should be recommendations), or see errors, please let us know
  • Update collector inside pganalyze Enterprise Server image to v0.45.0
  • Single Sign-On: Allow entering SAML IdP metadata manually instead of via metadata URL
    • This enables easier configuration for providers that list out the configuration instead of providing the metadata URL
  • Add support for Aiven for PostgreSQL and Google AlloyDB for PostgreSQL managed database providers
  • Connection Traces: Display query age for each connection and sort by it
  • Improved experience when adding new servers
    • This clarifies how the collector works for Enterprise Server, and gives more clarity on when to run the collector within the pganalyze Enterprise Server container, vs when to run it separately
  • New "Collector Configuration Test" function on server settings page
    • This is only available when using the collector within the pganalyze Enterprise Server container, and fulfills the same function as pganalyze-collector --test when running the collector separately
  • Support for Log Insights when monitoring self-managed servers using the collector within the pganalyze Enterprise Server container
    • To enable this functionality, make sure the "Enable Log Insights" checkbox is enabled for the server
    • This utilizes the built-in Postgres function pg_read_file to directly read the server log files over the Postgres connection (avoiding a separate collector install)
    • If you are using the restricted monitoring user this requires additional setup steps

Performance

  • New Rust-based compact snapshot workers are enabled by default
    • This improves the performance when processing a lot of log or activity data
    • If you've set a high concurrency for workers previously, you may be able to reduce the SIDEKIQ_CONCURRENCY setting (but verify there are no queue backlogs when lowering the setting)
  • Avoid timeouts when loading EXPLAIN plan list for entire server
  • Improved statistics processing performance for servers with a lot of tables

Bugfixes

  • Fix search term debouncing on query list search form
    • This was showing as slugish responsiveness and clobbered input in some cases
  • Fix storing VACUUM+ANALYZE events that have the exact same timestamp on the same table
    • Previously the ANALYZE even would not have been recorded in such situations, potentially leading to inaccurate "stale stats" EXPLAIN insights
  • Hide settings for collector running inside pganalyze Enterprise Server container when using a collector running separately
    • These settings did not have any effect before, but may have let to confusion as to which configuration is authorative
  • EXPLAIN plans
    • Add information for Incremental Sort node
    • Don't show loop count when there is no loop info due to plan without ANALYZE
  • Query details page
    • Fix Query Details page trend comparison tooltips (incorrect timestamps were shown before)
    • Don't break if we haven't received a full snapshot yet
  • Fix inaccurate member counts for member roles tab in organization settings
  • Skip data from hidden databases during compact snapshot processing
  • Fix pre-aggregation calculation (incorrect hourly aggregated data may have shown in rare cases)
  • Query parsing: Look for table references inside case expressions
  • Table/index tree map: Fix display issue if the same table name is used in different schemas

Security


Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →