Package: postgresql-13-pg-hint-plan Source: pg-hint-plan-13 Version: 1.3.10-1.pgdg22.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 346 Depends: postgresql-13, postgresql-13-jit-llvm (>= 15), libc6 (>= 2.14) Homepage: https://github.com/ossc-db/pg_hint_plan Priority: optional Section: database Filename: pool/main/p/pg-hint-plan-13/postgresql-13-pg-hint-plan_1.3.10-1.pgdg22.04+1_amd64.deb Size: 135404 SHA256: a5d8403a917ea4f0003f8fea4de42294d1b05614bf7348aca76a42f6f4794c2b SHA1: d98472f8702a155791972174128f024dd9298cfa MD5sum: c0b91db6d4b22e62dad5828b1bf4048b Description: support for optimizer hints in PostgreSQL PostgreSQL uses a cost-based optimizer that uses data statistics, not static rules. The planner (optimizer) estimates costs of each possible execution plans for a SQL statement, then executes the plan with the lowest cost. The planner does its best to select the best execution plan, but it is far from perfect, since it may not count some data properties, like correlation between columns. . pg_hint_plan makes it possible to tweak PostgreSQL execution plans using so-called "hints" in SQL comments, like /*+ SeqScan(a) */.