notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Want a good monitor light? See my photosAll times are UTC
Ukraine

Newsfeed changes

The news feed page[s] were not laid out well. Two pages, disjointed information, hard to figure out how to use the optional parameters...

Thankfully, someone told me.

The new page is ready for your review. Please compare these two:

You may also be interested in the Github issue.
Port details
pg_store_plans Enables Postgresql to store query execution plans in the Instance
1.8 databasesnew! on this many watch lists=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 Package not present on quarterly.This port was created during this quarter. It will be in the next quarterly branch but not the current one.
Maintainer: joseph@2egos.de search for ports maintained by this maintainer
Port Added: 2025-03-07 06:36:05
Last Update: 2025-03-07 06:32:38
Commit Hash: a3381d5
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.
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 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+
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: 1

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
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: 1