The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.

Changes for version 2.0 - 2022-02-11

  • Add Pg::Explain::Hinter to look through Pg::Explain plans, and suggest optimizations. For now two automatically found optimizations are there:
    • DISK_SORT - when there is Sort node that is using disk sort
    • INDEXABLE_SEQSCAN_SIMPLE - when there is Seq Scan (or Parallel Seq Scan) that is using simple expression on one column that can be indexed
  • Fix dependency on List::Util by requiring v. 1.44+
  • use JSON::MaybeXS instead of JSON, due to talk on irc/#mojo (suggestion by ether with comments from Grinnz)

Modules

Object approach at reading explain analyze output
Some helper methods to analyze explains
Object to store buffers information about node in PostgreSQL's explain analyze
Base class for parsers of non-text explain formats.
Parser for explains in JSON format
Parser for text based explains
Parser for explains in XML format
Parser for explains in YAML format
Review Pg::Explain plans and return hints, if there are any
Single hint for Pg::Explain plan
Stores information about JIT from PostgreSQL's explain analyze.
Class representing single node from query plan
Class to anonymize sets of strings