aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorWen Heping <wen@FreeBSD.org>2025-03-07 06:31:10 +0000
committerWen Heping <wen@FreeBSD.org>2025-03-07 06:32:38 +0000
commita3381d5c2f0e57045e766bef1d46e2f4f403de79 (patch)
treee1ca1859cf4d84da875e033ed70c86f0b1a540cf
parentaa6c40debfb19e4d0dcf6b5b400287cfad2aecb3 (diff)
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
-rw-r--r--databases/Makefile1
-rw-r--r--databases/pg_store_plans/Makefile21
-rw-r--r--databases/pg_store_plans/distinfo3
-rw-r--r--databases/pg_store_plans/pkg-descr2
-rw-r--r--databases/pg_store_plans/pkg-plist3
5 files changed, 30 insertions, 0 deletions
diff --git a/databases/Makefile b/databases/Makefile
index 03f32ad50efd..ebe46100e150 100644
--- a/databases/Makefile
+++ b/databases/Makefile
@@ -557,6 +557,7 @@
SUBDIR += pg_repack
SUBDIR += pg_similarity
SUBDIR += pg_stat_kcache
+ SUBDIR += pg_store_plans
SUBDIR += pg_tileserv
SUBDIR += pgaccess
SUBDIR += pgadmin3
diff --git a/databases/pg_store_plans/Makefile b/databases/pg_store_plans/Makefile
new file mode 100644
index 000000000000..7fcfe0aea4b1
--- /dev/null
+++ b/databases/pg_store_plans/Makefile
@@ -0,0 +1,21 @@
+PORTNAME= pg_store_plans
+DISTVERSION= 1.8
+CATEGORIES= databases
+
+MAINTAINER= joseph@2egos.de
+COMMENT= Enables Postgresql to store query execution plans in the Instance
+WWW= https://github.com/ossc-db/pg_store_plans
+
+LICENSE= Custom
+LICENSE_NAME= Custom
+LICENSE_FILE= ${WRKSRC}/LICENSE
+LICENSE_PERMS= auto-accept
+
+USE_GITHUB= yes
+GH_ACCOUNT= ossc-db
+
+USES= gmake pgsql:15+
+WANT_PGSQL= server
+MAKE_ARGS= USE_PGXS=YES
+
+.include <bsd.port.mk>
diff --git a/databases/pg_store_plans/distinfo b/databases/pg_store_plans/distinfo
new file mode 100644
index 000000000000..1b26378bf304
--- /dev/null
+++ b/databases/pg_store_plans/distinfo
@@ -0,0 +1,3 @@
+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
diff --git a/databases/pg_store_plans/pkg-descr b/databases/pg_store_plans/pkg-descr
new file mode 100644
index 000000000000..2e78df78c569
--- /dev/null
+++ b/databases/pg_store_plans/pkg-descr
@@ -0,0 +1,2 @@
+The pg_store_plans module provides a means for tracking execution
+plan statistics of all SQL statements executed by a server.
diff --git a/databases/pg_store_plans/pkg-plist b/databases/pg_store_plans/pkg-plist
new file mode 100644
index 000000000000..e17389eb7400
--- /dev/null
+++ b/databases/pg_store_plans/pkg-plist
@@ -0,0 +1,3 @@
+lib/postgresql/pg_store_plans.so
+share/postgresql/extension/pg_store_plans--1.8.sql
+share/postgresql/extension/pg_store_plans.control