2018.02.0 Release

Docker tag: quay.io/pganalyze/enterprise:v2018.02.0

New features

  • Mobile friendly layout

    • pganalyze is now usable on mobile web - although not all views work well on small screens, this allows you to navigate around and see current database issues
  • Secondary navigation on detail pages

    • Detail pages for queries, tables and other objects have been redone
  • Allow overriding the default organization for LDAP signups

    • You can now specify the DEFAULT_ORG_NAME environment variable to automatically assign new LDAP sign-ins to a specific organization (alternatively the first organization is chosen)
  • Add "Query Origins" data collection

    • Query origins are annotations on the query using SQL comments, like this: /* controller:pages */ SELECT 1, which will then show up on the query details page in a grouped form
    • You can use existing tooling such as marginalia for Rails to automatically annotate queries
  • Add DOMAIN_NAME environment variable

    • Set this to the hostname of your pganalyze installation, in order for alert emails and other links that include the hostname to be correct
  • Add Queries tab on table details

    • This shows all queries that reference a particular table on the table details page
  • Add "Usage Statistics" section to organization settings
  • Allow self-serve creation of read-only API keys
  • Stop hiding truncated and unidentified queries from the overview

    • This is a behavior change from previously, and is intended to show you truncated queries (i.e. queries whose text was too long to be stored) in order to gauge whether they represent a substantial part of your workload
  • Log Insights improvements

    • Additional classifications for log events
    • Add Log Analysis for Temp File Created log events
    • Add Log Analysis for "Checkpoint Starting" log event
    • Always show server-wide log lines on database-specific Log Insights page
    • Store log event details as JSONB
  • Show system data for Heroku Postgres, show 90/100% limit for I/O utilization
  • Add Cache Hit Ratio graph to query detail page
  • Replication check: Don't fail for servers that had no snapshots yet

Bugfixes

  • Normalize multi-row VALUES lists better
  • Polyfill Promise and Array#forEach to fix IE11 support
  • Vacuum overview/details: Allow table to be null
  • Fix per-query sample count and log line count with multiple fingerprints
  • Fix bug that makes system tab crash when system_info.data is null
  • Fix display bug for Heroku Postgres databases on System tab
  • Normalize: Fix bug with VALUES lists that contain function calls
  • Clean up repetitive (?), (?), ... query text
  • Correctly parse config values that have multiples of megabytes as units

Performance improvements

  • Add index on log_files(server_id, collected_at)
  • Reduce the amount of query origins fetched for query details page
  • Add indices for snapshot deletion task
  • Speed up query detail page for queries with many samples or log lines

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