Package: postgresql-13-pg-hint-plan Source: pg-hint-plan-13 Version: 1.3.11-1.pgdg26.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 207 Depends: postgresql-13, 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.11-1.pgdg26.04+1_amd64.deb Size: 52396 SHA256: 9bfc3dce27e0db78e45da05befa273ca4e5f270eb18269c53aecd8846b32069a SHA1: 906b9a768d86704d9f6dc76e7de41a53e75bb54c MD5sum: 0ecfde5d2f72a4b975fad4bcdf84d8c0 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) */.