Add a suite of real time metrics tools for PostgreSQL

The PostgreSQL Workload Analyzer is performance tool for PostgreSQL 9.4 and
later, allowing to collect, aggregate and purge statistics on a PostgreSQL
instance from various sources. It is implemented as a background worker.

pg_qualstats, providing data about predicates, i.e. where clauses

6 files changed, 63 insertions, 0 deletions

diff --git a/databases/pg_qualstats/Makefile b/databases/pg_qualstats/Makefile
new file mode 100644
index 000000000000..855d7ac365a2
--- /dev/null
+++ b/databases/pg_qualstats/Makefile
@@ -0,0 +1,23 @@
+# Created by: Palle Girgensohn <girgen@FreeBSD.org>
+# $FreeBSD$
+
+PORTNAME=	pg_qualstats
+PORTVERSION=	1.0.1
+CATEGORIES=	databases
+
+MAINTAINER=	girgen@FreeBSD.org
+COMMENT=	PostgreSQL extension for collecting statistics about predicates
+
+LICENSE_FILE=	${WRKSRC}/LICENSE
+
+USE_GITHUB=	yes
+GH_ACCOUNT=	dalibo
+
+USES=		gmake pgsql:9.4+
+WANT_PGSQL=	server
+
+pre-patch:
+	@${MV} ${BUILD_WRKSRC}/doc/README.md ${BUILD_WRKSRC}/doc/${PORTNAME}-README.md ;\
+	${MV} ${BUILD_WRKSRC}/LICENSE ${BUILD_WRKSRC}/${PORTNAME}-LICENSE
+
+.include <bsd.port.mk>
diff --git a/databases/pg_qualstats/distinfo b/databases/pg_qualstats/distinfo
new file mode 100644
index 000000000000..b0ef4ff819ea
--- /dev/null
+++ b/databases/pg_qualstats/distinfo
@@ -0,0 +1,3 @@
+TIMESTAMP = 1475181222
+SHA256 (dalibo-pg_qualstats-1.0.1_GH0.tar.gz) = a1e39e65044b2b52f837067a3dccd70a22f5c51bcef898c95ac9ea4951aeee38
+SIZE (dalibo-pg_qualstats-1.0.1_GH0.tar.gz) = 22319
diff --git a/databases/pg_qualstats/files/patch-Makefile b/databases/pg_qualstats/files/patch-Makefile
new file mode 100644
index 000000000000..5daed1561a0a
--- /dev/null
+++ b/databases/pg_qualstats/files/patch-Makefile
@@ -0,0 +1,11 @@
+--- Makefile.orig	2016-08-11 13:49:47 UTC
++++ Makefile
+@@ -3,7 +3,7 @@ EXTVERSION   = $(shell grep default_vers
+ TESTS        = $(wildcard test/sql/*.sql)
+ REGRESS      = $(patsubst test/sql/%.sql,%,$(TESTS))
+ REGRESS_OPTS = --inputdir=test
+-DOCS         = $(wildcard doc/*.md)
++DOCS         = $(wildcard doc/*.md) $(wildcard *LICENSE)
+ MODULES      = $(patsubst %.c,%,$(wildcard *.c))
+ PG_CONFIG    ?= pg_config
+ 
diff --git a/databases/pg_qualstats/pkg-descr b/databases/pg_qualstats/pkg-descr
new file mode 100644
index 000000000000..a29c17d8ee3b
--- /dev/null
+++ b/databases/pg_qualstats/pkg-descr
@@ -0,0 +1,4 @@
+pg_qualstats is a PostgreSQL extension keeping statistics on predicates found
+in WHERE statements and JOIN clauses.
+
+WWW: https://github.com/dalibo/pg_qualstats
diff --git a/databases/pg_qualstats/pkg-message b/databases/pg_qualstats/pkg-message
new file mode 100644
index 000000000000..996a846ea30c
--- /dev/null
+++ b/databases/pg_qualstats/pkg-message
@@ -0,0 +1,7 @@
+To activate pg_qualstats on your PostgreSQL server, add 'pg_qualstats' to
+shared_preload_libraries in $PGDATA/postgresql.conf. For every database,
+run
+	CREATE EXTENSION IF NOT EXISTS pg_qualstats.
+
+Using databases/powa-web and databases/powa-archivist together with
+pg_qualstats is warmly recommended.
diff --git a/databases/pg_qualstats/pkg-plist b/databases/pg_qualstats/pkg-plist
new file mode 100644
index 000000000000..37ba90fb91ef
--- /dev/null
+++ b/databases/pg_qualstats/pkg-plist
@@ -0,0 +1,15 @@
+lib/postgresql/pg_qualstats.so
+share/postgresql/extension/pg_qualstats--0.0.1.sql
+share/postgresql/extension/pg_qualstats--0.0.2.sql
+share/postgresql/extension/pg_qualstats--0.0.3.sql
+share/postgresql/extension/pg_qualstats--0.0.4.sql
+share/postgresql/extension/pg_qualstats--0.0.5.sql
+share/postgresql/extension/pg_qualstats--0.0.6.sql
+share/postgresql/extension/pg_qualstats--0.0.7.sql
+share/postgresql/extension/pg_qualstats--0.0.8.sql
+share/postgresql/extension/pg_qualstats--0.0.9.sql
+share/postgresql/extension/pg_qualstats--1.0.0.sql
+share/postgresql/extension/pg_qualstats--1.0.1.sql
+share/postgresql/extension/pg_qualstats.control
+share/doc/postgresql/extension/pg_qualstats-README.md
+share/doc/postgresql/extension/pg_qualstats-LICENSE