pg_enhanced_query_logging (PEQL) is a new PostgreSQL extension that emits slow query logs in the MySQL/Percona Server slow log format, making them directly consumable by pt-query-digest. It hooks into PostgreSQL's executor and planner to capture timing, buffer I/O, WAL, JIT, and row-count metrics for queries exceeding a configurable threshold. Key features include statistical sampling (1-in-N per query or session), a dedicated log file separate from PostgreSQL's error log, rate limiting by queries and bytes per second, always-log overrides for extreme outliers, embedded EXPLAIN ANALYZE plans, and automatic pause when disk space runs low. The tool enables the familiar 'worst-performing query family' workflow MySQL DBAs have used for years, now applied to PostgreSQL. Future plans include a more compact native log format to reduce I/O overhead and companion tooling for analysis.
