5.6.4.58 +Now capable of monitoring PostgreSQL 9.1+. +Added Statement Tracking collection using pg_stat_statements module and extension if available in PostgreSQL DB. +New Agent Properties allow enabling/disabling Statement Tracking collection, specifying the number of top statements to collect, and sorting by several different metrics. +Added Statements dashboard. +Added statement statistics reset function in Admin on PostgreSQL Servers dashboard. +Added Workload metric for Server and Databases. Requires track_io_timing to be enabled, available only in v9.2+. 5.6.4.59 +Minor cosmetic and UI fixes to several pages. 5.6.4.60 +This and all future versions of the cartridge will use the normal Foglight licensing system. If you require a new license, e-mail your contact at SMA. 5.6.4.61 +Changed Server Overview to PostgreSQL Server Overview. +Added Conn Usage % and Locks Waiting metrics to Session Activity in PostgreSQL Server Overview. +Moved Replication Info to right column in PostgreSQL Server Overview. 5.6.4.62 +Fixed bug where agent did not properly close threads once they finished running. 5.6.4.63 +Reduced thread creation rate. 5.6.4.64 +Fixed CDT error with monitoringAgent being submitted for classes extended from DataObject. 5.6.4.65 +Includes PostgreSQL Quick View for inclusion in and compatibility with Databases_Global_View_UI 5.7.1.5 release 5.6.4.66 +Fixed bug with shared_buffers calculation. 5.6.4.76 +Bug fixes 5.6.4.77 +Added option to use SSL connection to database. 5.7.5 +Upgraded devkit to 5.8.5.2 +Agent now runs in-process and automatically requests additional memory for large instances. PostgreSQLAgent package pre-allocates memory for 4 agents when deployed. For sizing FglAM host memory, a Foglight for PostgreSQL Memory Tuning Worksheet is available on the SMA FTP. +Removed SQL renderer causing slow load time for Statement, Backends, and Current Locks tables. +Fixed initial null context for db/table summaries in drilldowns to Databases/Tables dashboards. +Fixed alarm dwell action in PostgreSQL Servers table pointing to MySQL module. -Known bug - Task for deploying agent package during upgrade may stall. After giving sufficient time for package to download, FglAM can be restarted manually to kill the threads. Upon starting, agents will be upgraded as normal. It is recommended that PostgreSQL agents on the FglAM in question be deactivated before upgrade to avoid encountering this bug entirely. 5.7.5.25 +Bug preventing proper agent shutdown has been fixed. 5.7.5.26 +Added schema and database names to alarm messages for table rules. 5.7.5.27 +Upgraded DB_Global_View_UI cartridge to 5.7.5.7 5.7.5.30 +Databases and Tables dashboards now include Age metric (the number of transactions from the cutoff XID to the current transaction's XID). +Tables dashboard table now contains columns for partition master and partition children in partitioned tables. These columns are hidden by default. To see a list of the partitioned tables for a partition master table, hover or click on the value in the "Partition Tables" column. 5.7.5.31 +Modified query for Table Highlights>Lowest Mem Block Hit % graph on Databases dashboard to exclude tables which no longer exist. 5.7.5.32 +Databases and tables on a standby server will no longer calculate age. +WAL_Sender identity property has been changed from client_hostname to a concatenation of address, hostname, and port in order to avoid identity error if client_hostname string is empty. This may require deleting existing WAL_Sender topology objects and restarting the FMS in order to prevent topology model conflicts. 5.7.5.33 +Added Individual Index Bloat rule. Triggers on bloat condition of individual index size rather than combined indexes for a table. 5.7.5.34 +Improved error logging. 5.7.5.35 +Fixed bug in Statement collection where values may exceed max value of int type. 5.7.5.37 +Fixed bug with Agent Host Name override not working properly. 5.7.5.67 21/Dec/16 +Upgraded statement collection to create persistent objects +New Statements and Statement Details dashboards +New rule: "High Average Response Time for Statement" +New Server Configuration collection and dashboard +Seven new reports: "Executive Summary", "Health Check Report", "Server Configuration", "Server Configuration Comparison", "Top Servers by Connections", "Top Statements", and "Top Tables" +Converted relevant database and table metrics to deltas +Updated PostgreSQL JDBC connector to 9.4.1211 +Various rule fixes 5.7.5.68 12/Jan/17 +Modified rule "High Average Response Time for Statement" to require 3 days of collection before alerting, added more information to alarm message. 5.7.5.74 19/Jan/17 +Added ability to request Explain Plans through Statement Details page if enabled in Agent Properties and the user has the "PostgreSQL Administrator" role. +Added Administration section to agent properties. Administrative operations will now only be performed through the Admin User provided rather than the user provided to regularly collect data. They may still be the same user if the administrator prefers. See the cartridge guide for more information. 5.7.5.75 16/Feb/17 +Updated DB Global View UI cartridge. 5.7.5.76 17/Feb/17 +Fixed error in rule "PostgreSQL Index Bloat - Individual" 5.7.5.86 05/May/17 +Remove redundant total column in "Disk Sizes" chart on Tables dashboard. +Tablespaces "Disk Space Distribution" chart now shows host monitoring data if available - no errors are generated in FMS log if host monitoring is not enabled. +Add navigation bar to top of dashboards. +Database names and table names are now in clickable Database dashboard and Tables dashboard respectively, updating dashboard to the selected item. +Maximize size of configuration table on configuration dashboard. +Maximize size of statement table on statement dashboard. +Retrieve earliest available configuration setting on statement table when monitoring began after the start of the selected period. +Fix bug preventing navigation to some statements' detail pages via the stacked chart on the Statements dashboard. +All errors encountered during explain plan execution now displayed in popup rather than refering user to FMS log for details. +All administrative actions now log at INFO level to agent log. +All administrative actions now log name of Foglight user initiating the action. 5.7.5.90 05/Sep/17 +Updated DB_Global_View_UI to 5.7.5.41. +Fixed bug with High Average Response Time rule not using registry variables. +Fixed bugs in Statements on Other Servers table. 5.7.5.93 05/Dec/17 +Limited upstream cache to 2MB. +Reduced memory usage for storing data between agent samples. +Added index definition to Index table. +Fixed OID appearing as tablespace name. +Fixed visibility of some report templates. +Fixed potential null exceptions in total_tablespace_size and total_calls derived metrics. 5.7.5.96 02/Jan/18 +Fixed potential bug in dynamic memory allocation making repeated requests. +Fixed PostgreSQL version string not parsing correctly when no release version is present. +Added popup for index definition string on Indexes page. 5.7.5.97 06/Feb/18 +Updated JDBC driver to 42.2.1. +Added a full change history (in page time range) for a selected property value on the Configuration dashboard. +Added last analyze/vacuum times to the Tables dashboard table (hidden by default). +Replication page link will appear in navbar if applicable. +Added Write Lag, Flush Lag, and Replay Lag metrics to WAL Senders table for all PostgreSQL versions. Log locations are still present, but hidden by default. +Fixed bug in WAL_Senders collection for PostgreSQL 10+. +Removed standby_log_diff derived metric, replaced by replay_lag metric. 5.7.5.98 14/Feb/18 +Fixed bug in WAL_Senders collection processing. 5.7.5.99 20/Apr/18 +Updated DB_Global_View_UI to 5.7.5.50. +Fixed bug with context not reloading in sub-containers for Server/Databases/Tables pages during higher-level context change. 5.7.5.105 11/May/18 +Fixed bug in replication WAL senders collection for PostgreSQL 10+. +Fixed bug where the name of a master partition table may not be collected in some situations. +Fixed potential dead objects showing up in Table Highlights graphs on Databases dashboard +Reduced PostgreSQLAgent pre-allocation count +from 4 to 2. 5.9.2.1 26/Jul/18 +Updated DB_Global_View_UI to 5.9.2.1. 5.9.2.2 18/Aug/18 +Updated JDBC driver to 42.2.4. +Updated devkit version to 5.9.2.1. +Compatible with AWS Aurora and RDS and Microsoft Azure. +Added unmonitorable rdsadmin and azure_maintenance databases to default DB ignore list in agent properties. +Tablespaces navigation link and Tablespaces info box do not appear for AWS and Azure PostgreSQL servers as Tablespaces are unmonitorable and irrelevant. +Added PostgreSQLRoot as Data Model and PostgreSQLServer object for agent independent data model root node. +Added dbType property. +Potential Deadlock Issue rule now lists unique queries in currently deadlocked transactions and continuously generates alarms if deadlock condition persists. +Increased threshold for High Average Response Time for Statement rule for standard deviation multiplier and added minimum average wait time. +Replication navigation link and info box do not appear if no WAL senders exist. +Removed Home Page purpose from dashboards. +Removed customized upstream queue settings from agent. +Minor fixes for error logging of null conditions. 5.9.3.10 7/Sep/18 +Fixed bug with missing variable in alarm message for High Percentage of Queries Waiting rule. +Modified property change table on Configurations page to show all available change history rather than just in selected time range. +Associated Reports with relevant dashboards. 5.9.3.10.13 18/Oct/18 +Added option to enable/disable dynamic memory allocation. +Added "Confirm Password" fields to PostgreSQL Agent Install Wizard. +Moved DB selector in Tables dashboard from action panel to table button and allowed multiple selections. +Statement collection now replaces '\x01' character in query text with '?' if present as workaround for FMS invalid character issue. +Fixed bug with Replication collection not parsing very high log position values. 5.9.3.20 09/Jan/19 +Email notification via Databases dashboard implemented. +Updated cartridge author. +Updated DB_Global_View_UI to v5.9.3.20. +Added SMA_DB_Global cartridge at v5.9.3.20. 5.9.3.20.10 18/Jan/19 +Fixed column sorting for Databases and Tables pages. 5.9.3.20.13 15/Feb/19 +Added UI Query to Report context selection for PostgreSQLAgent instances. +Modified default retention policy for PG_Index and PG_Table types - added new roll up data into 12 hour samples after 1 month and purge data after 3 months. 5.9.3.20.20 12/Mar/19 +Added advanced SSL options to agent properties. 5.9.4.10 17/Apr/19 +Fixed SSL option in Agent Installer Wizard. 5.9.4.20 26/Jul/19 +Updated DB_Global_View_UI to v5.9.4.20. +Updated SMA_DB_Global cartridge at v5.9.4.20. 5.9.4.33 7/Sep/19 +Tables collection is now Top Tables collection. Collection will be limited to x number of top tables per DB according to configuration in Agent Properties. +Added Tables Report collection and PostgreSQL Full Tables Report. Collection/Report will show all tables in the PostgreSQL server that meet conditions set in Agent Properties without creating persistent topology objects for them. +DB Overrides list now includes options to exclude tables, indexes, or functions by database as well as include in Table Report collection. When upgrading to this version, an existing list must be changed to a list supporting new format. Either a default list of DBOverrideDefaults can be used or a new list can be cloned from that. +Fixed bug where statement tracking would not happen if database object collection was disabled. 5.9.4.36 9/Sep/19 +Added dead tuples size to Table Report and parameters. +Added WAL sender slot information for PostgreSQL versions 9.5+. 5.9.5.10.14 6/Feb/20 +Released new Server Overview dashboard. +Added Background Writer page to navbar. +Updated SMA_DB_Global cartridge to v5.9.5.10.14. 5.9.7.10.16 21/Jul/20 +Added 10 Advisories for PostgreSQL and Advisory page to Overview dashboard. +Enabled FIPS compliancy. +Enabled PostgreSQL cartridge for FMS HA configuration. +Minor updates to BG Writer metrics. +Updated SMA_DB_Global cartridge to v5.9.7.10.13. +Update DB_Global_View_UI cartridge to 5.9.7.10. 5.9.7.10.17 7/Aug/20 +Updated SMA_DB_Global cartridge to v5.9.7.10.14, fixes potential issue with Advisory retention. 5.9.7.10.18 4/Sep/20 +Added statement text limit option to agent properties. 5.9.7.10.21 20/Oct/20 +Compatible with PostgreSQL version 13. 5.9.7.20.10 16/Feb/21 +Fixed bug with replication senders not associated with a replication slot not being collected for versions 9.5+.