- Fixed Docker image for
linux/arm64
- Updated pg_query to 5.1+ to fix installation on Windows
- Fixed error with
--pg-stat-statements
and--min-calls
- Fixed issue with processing over 500 query fingerprints (introduced in 0.5.3)
- Require google-protobuf < 4
- Fixed error with hypothetical index limit
- Fixed error with foreign tables
- Added Docker image for
linux/arm64
- Switched to
GENERIC_PLAN
for Postgres 16 - Fixed error with
auto_explain
- Fixed warning with Ruby 3.3
- Fixed
JSON::NestingError
- Added support for normalized queries
- Added
--stdin
option (now required to read from stdin) - Added
--enable-hypopg
option (now required to enable HypoPG) - Improved output when HypoPG not installed
- Changed
--pg-stat-activity
to sample 10 times and exit - Detect input format based on file extension
- Dropped support for experimental
--log-table
option - Dropped support for Linux packages for Ubuntu 18.04 and Debian 10
- Dropped support for Ruby < 2.7
- Dropped support for Postgres < 11
- Added experimental
--log-table
option - Improved help
- Require pg_query < 4
- Fixed
--pg-stat-statements
option for Postgres 13+
- Added support for
json
format
- Added support for pg_query 2
- Switched to monotonic time
- Dropped support for Ruby < 2.5
- Require pg_query < 2
- Added
--tablespace
option
- Colorize output
- Fixed error when unable to parse view definitions
- Fixed help output
- Fixed warning with Ruby 2.7
- Added
sql
input format - Fixed error for queries with double dash comments
- Fixed connection threading issue with
--pg-stat-activity
option
- Fixed
--username
option - Fixed
JSON::NestingError
- Added
--pg-stat-activity
option
- Added support for views and materialized views
- Better handle case when multiple indexes are found for a query
- Added
--min-cost-savings-pct
option
- Fixed parsing issue with named prepared statements
- Fixed parsing issue with multiline queries in csv format
- Better explanations for indexing decisions
- Added support for queries with bind variables
- Fixed error with streaming logs as csv format
- Handle malformed CSV gracefully
- Added support for schemas
- Added support for csv format
- Added
--analyze
option and do not analyze by default - Added
--min-calls
option - Fixed debug output when indexes not found
- Fixed bad suggestions
- Improved debugging output
- Added same connection options as
psql
- Added support for multiple files
- Added
error
log level - Better error messages when cannot connect
Breaking
-h
option changed to--host
instead of--help
for consistency withpsql
- Significant performance improvements
- Added
--include
option
- Added support for non-
SELECT
queries - Added
--pg-stat-statements
option - Added advisory locks
- Added support for running as a non-superuser
- Added support for multicolumn indexes
- Fixed error with non-lowercase columns
- Fixed error with
json
columns
- Added
--exclude
option - Added
--log-sql
option
- Added
--interval
option - Added
--min-time
option - Added
--log-level
option
- Launched