Searches without login should now work. You must get asked to click a button.
Some translations wanted please.
New RSS 2.0 and Atom feeds are here. The old /backend/ feeds still work, but will be redirected later, so please update your subscriptions. Details.
Port details
pg_store_plans Enables Postgresql to store query execution plans in the Instance
1.8 databases Σ=0 search for ports that depend on this port Find issues related to this port Report an issue related to this port View this port on Repology. pkg-fallout 1.8Version of this port present on the latest quarterly branch.
Maintainer: joseph@2egos.de search for ports maintained by this maintainer
Port Added: 2025-03-07 06:36:05
Last Update: 2025-05-01 08:47:37
Commit Hash: ef55a00
License: Custom
WWW:
https://github.com/ossc-db/pg_store_plans
Description: #
The pg_store_plans module provides a means for tracking execution plan statistics of all SQL statements executed by a server.
Homepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb - no subversion history for this port
Manual pages: #
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist #
Expand this list (9 items)
Collapse this list.
  1. /usr/local/share/licenses/pg_store_plans-1.8/catalog.mk
  2. /usr/local/share/licenses/pg_store_plans-1.8/LICENSE
  3. /usr/local/share/licenses/pg_store_plans-1.8/Custom
  4. lib/postgresql/pg_store_plans.so
  5. share/postgresql/extension/pg_store_plans--1.8.sql
  6. share/postgresql/extension/pg_store_plans.control
  7. @owner
  8. @group
  9. @mode
Collapse this list.
USE_RC_SUBR (Service Scripts)
  • no SUBR information found for this port
Dependency lines:
  • pg_store_plans>0:databases/pg_store_plans
To install the port: #
cd /usr/ports/databases/pg_store_plans/ && make install clean
We doubt a package is available for this port because we see it marked as:
  • Package not available
Packages are normally not provided for ports that are marked as above.
To add the package, run one of these commands:
  • pkg install databases/pg_store_plans
  • pkg install pg_store_plans
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.
PKGNAME: there is no package for this port: _LICENSE_RESTRICTED = delete-package delete-distfiles
Flavors: #
there is no flavor information for this port.
distinfo: #
TIMESTAMP = 1741163719 SHA256 (ossc-db-pg_store_plans-1.8_GH0.tar.gz) = 1ca9ad08d9840c71634913171576001ea7ea5ca9c69cee2bb3521088d048faa7 SIZE (ossc-db-pg_store_plans-1.8_GH0.tar.gz) = 86481

No package information for this port in our database #
Sometimes this happens. Not all ports have packages. Perhaps there is a build error. Check the fallout link: pkg-fallout
Dependencies #
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies: #
  1. gmake>=4.4.1 : devel/gmake
  2. postgres : databases/postgresql16-server
Runtime dependencies: #
  1. postgres : databases/postgresql16-server
There are no ports dependent upon this port #

Configuration Options: #
No options to configure
Options name: #
databases_pg_store_plans
USES: #
gmake pgsql:15+
pkg-message: #
FreshPorts was unable to extract/find any pkg message
Master Sites: #
Expand this list (1 items)
Collapse this list.
  1. https://codeload.github.com/ossc-db/pg_store_plans/tar.gz/1.8?dummy=/
Collapse this list.

Number of commits found: 3 #

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
1.8
01 May 2025 08:47:37
commit hash: ef55a0053d89f93f68748d37c6f1cf0dad72eb8dcommit hash: ef55a0053d89f93f68748d37c6f1cf0dad72eb8dcommit hash: ef55a0053d89f93f68748d37c6f1cf0dad72eb8dcommit hash: ef55a0053d89f93f68748d37c6f1cf0dad72eb8d files touched by this commit
Kevin Bowling (kbowling) search for other commits by this committer
databases/pg_store_plans: Fix syntax

PR:		286165
1.8
01 May 2025 08:44:57
commit hash: 3438d062f0de5c906840a57bd4ae404fffb4a6e7commit hash: 3438d062f0de5c906840a57bd4ae404fffb4a6e7commit hash: 3438d062f0de5c906840a57bd4ae404fffb4a6e7commit hash: 3438d062f0de5c906840a57bd4ae404fffb4a6e7 files touched by this commit
Kevin Bowling (kbowling) search for other commits by this committer
databases/pg_store_plans: Ignore on pgsql > 16

Upstream created a broken new version, what a mess.. ignore for now on
pgsql > 16.

PR:		286165
Approved by:	maintainer timeout
1.8
07 Mar 2025 06:32:38
commit hash: a3381d5c2f0e57045e766bef1d46e2f4f403de79commit hash: a3381d5c2f0e57045e766bef1d46e2f4f403de79commit hash: a3381d5c2f0e57045e766bef1d46e2f4f403de79commit hash: a3381d5c2f0e57045e766bef1d46e2f4f403de79 files touched by this commit
Wen Heping (wen) search for other commits by this committer
databases/pg_store_plans: New port

The pg_store_plans module provides a means for tracking execution
plan statistics of all SQL statements executed by a server.

PR:		283560
Reported by:	joseph@2egos.de

Number of commits found: 3