2.0.1 Bugfix: - Fix compilation for PG11- on some platforms (Julien Rouhaud, per report from Devrim Gündüz) 2.0.0 New features: - Handle statistics on selectivity estimation errors (Julien Rouhaud, per idea from Oleg Bartunov) - Add an index advisor feature (Julien Rouhaud) - Allow pgqs to work locally without being in shared_preload_libraries (Julien Rouhaud) Bugfix: - Fix handling of quals of the form Constant Operator Val where the operator doesn't have a commutator - Compute the same identifier whether the operator was commuted or not - Correctly discard all quals not referencing a relation - Fix (unique)qualid computation to only consider AND-ed quals Miscellaneous: - Add missing fields description (Julien Rouhaud) 1.0.9 Bugfix: - Fix constant value truncation when multibyte encoding characters are used (thanks to Gürkan Gür for the report) Miscellaneous: - Remove unneeded cast, that prevented compilation at least on Solaris 10 SPARC (thanks to github user edechaux for the report) 1.0.8 Miscellaneous: - Fix pg12 compatibility - Fix possible issue with array processing 1.0.7 Bugfix: - Fix a bug for queries having JOIN or WHERE predicates on foreign tables or custom scans (Julien Rouhaud). Thanks a lot to Andrej Urvantsev, Raymond Barbiero and mbroxson who all reported this issue, and especially to mbroxson who provided a reproducer! Miscellaneous: - Fix debian packaging to ignore debian/* tags (Christoph Berg) 1.0.6 Bugfix: - Fix bug for handling of nodes having multiple children, such as Append node (Julien Rouhaud). Miscellaneous: - Fix compilation issue with C90 compatibility (Julien Rouhaud) - Fix README.d installation in debian packaging (Thanks to Andreas Beckmann for the report) 1.0.5: Incompatibilites: - Due to changes in pg_stat_statements in 11, queryid is now on 64 bits. SQL functions no longer use oid type but bigint for queryid attribute (even for PG prior to 11). Miscellaneous: - Add pg 11 compatibility (Adrien Nayrat helped by Julien Rouhaud and Thomas Reiss) - Warn if incorrect configuration setting is used 1.0.4: - Fix a bug in Bitmap Index Scan nodes handling for PostgreSQL 10+ (Fix by Julien Rouhaud, thanks to Marc Cousin and Adrien Nayrat for reporting the issue) - Fix sampled array buffer overflow (Fix by Julien Rouhaud, reporting and much testing by Nicolas Gollet) 1.0.3: Bugfix: - Fix a missing call to InstrEndLoop (Tomas Vondra) - Sample all nested queries when top level statement is sampled (Julien Rouhaud) - Make sure hash keys can be compared using memcmp (Julien Rouhaud) - Fix behavior with parallel queries (Julien Rouhaud based on a patch by Tomas Vondra) - Fix bug on TEXTCONST not being byval (Ronan Dunklau) - Fix 64bits counters on pass-by-ref float8 architectures (Julien Rouhaud) - Fix bug in pg_qualstats_names (Ronan Dunklau) - Fix bug in const position (Julien Rouhaud) - Fix pg_qualstats_pretty to use text instead of regoper, allowing usage of pg_upgrade when pg_qualstats is installed (Julien Rouhaud) - Fix segfault when interleaved executors cause bad sampling detection (Julien Rouhaud, reported by Andreas Seltenreich) Miscellaneous: - Add pg 10 compatibility (Julien Rouhaud) - Do not install docs anymore (Ronan Dunklau) - Add missing occurences/nbfiltered fields to pg_qualstats_pretty and pg_qualstats_all views (Julien Rouhaud) 1.0.2: Bugfix - Fix infinite loop for queries having a huge number of WHERE or JOIN clauses 1.0.1: Bugfix - Fix impossibility to install pg_qualstats if intarray extension is installed 1.0.0: Incompatibilites: - RenameGUC from sample_ratio to sample_rate Bugfix: - only get the exclusive lock on shared memory when needed - Fix bugs related to outer var resolution - Add missing function prototype Miscellaneous: - Add 9.6 compatibility - Code and comment cleanup Thanks to Thomas Vondra and Julien Rouhaud ! 0.0.9: - add sample_ratio hook - fix mistake while releasing 0.0.8 0.0.8: - add sample_ratio parameter 0.0.7: - fix counters for 32 bits builds - handle different collations for constants sampling - add a new "occurences" field, displaying the number of qual call - keep a unnormalized query string for each queryid - fix a bug with operator id retrieval - handles casts - add stats collection for nestedloops - handle FuncExpr and MinMaxExpr - improve performances for queries having multiple quals 0.0.6: - order quals and constants by their text positions. - fix bug with Index-Only Scans, which where not correctly supported - make pg_config configurable from the make invocation - ensure pg_qualstats is in shared_preload_libraries 0.0.5: - fix bug with = ANY(NULL) expressions 0.0.4: - add inline documentation in the sql script - fix a bug with 32bits builds (thanks to Alain Delorme for reporting it)