From ac9726b6655968cd9c5a77ae0615c0e57b9429f9 Mon Sep 17 00:00:00 2001 From: asau Date: Fri, 10 Dec 2010 19:21:06 +0000 Subject: Import PostgreSQL 9.0 monitoring modules as databases/postgresql90-monitoring This package provides the following PostgreSQL modules: - auto_explain - pg_buffercache - pg_stat_statements - pgstattuple The "auto_explain" module provides a means for logging execution plans of slow statements automatically, without having to run EXPLAIN(7) by hand. This is especially helpful for tracking down un-optimized queries in large applications. The "pg_buffercache" module provides a means for examining what's happening in the shared buffer cache in real time. The "pg_stat_statements" module provides a means for tracking execution statistics of all SQL statements executed by a server. The "pgstattuple" module provides various functions to obtain tuple-level statistics. --- databases/postgresql90-monitoring/DESCR | 19 +++++++++++++++++++ databases/postgresql90-monitoring/Makefile | 22 ++++++++++++++++++++++ databases/postgresql90-monitoring/PLIST | 11 +++++++++++ 3 files changed, 52 insertions(+) create mode 100644 databases/postgresql90-monitoring/DESCR create mode 100644 databases/postgresql90-monitoring/Makefile create mode 100644 databases/postgresql90-monitoring/PLIST diff --git a/databases/postgresql90-monitoring/DESCR b/databases/postgresql90-monitoring/DESCR new file mode 100644 index 00000000000..a7d6d0fd016 --- /dev/null +++ b/databases/postgresql90-monitoring/DESCR @@ -0,0 +1,19 @@ +This package provides the following PostgreSQL modules: + - auto_explain + - pg_buffercache + - pg_stat_statements + - pgstattuple + +The "auto_explain" module provides a means for logging execution +plans of slow statements automatically, without having to run +EXPLAIN(7) by hand. This is especially helpful for tracking down +un-optimized queries in large applications. + +The "pg_buffercache" module provides a means for examining what's +happening in the shared buffer cache in real time. + +The "pg_stat_statements" module provides a means for tracking +execution statistics of all SQL statements executed by a server. + +The "pgstattuple" module provides various functions to obtain +tuple-level statistics. diff --git a/databases/postgresql90-monitoring/Makefile b/databases/postgresql90-monitoring/Makefile new file mode 100644 index 00000000000..9928e1ed327 --- /dev/null +++ b/databases/postgresql90-monitoring/Makefile @@ -0,0 +1,22 @@ +# $NetBSD: Makefile,v 1.1.1.1 2010/12/10 19:21:06 asau Exp $ + +PKGNAME= postgresql90-monitoring-${BASE_VERS} +COMMENT= PostgreSQL monitoring tools + +PKG_DESTDIR_SUPPORT= user-destdir + +DEPENDS+= postgresql90-server>=${BASE_VERS}:../../databases/postgresql90-server + +.include "../../databases/postgresql90/Makefile.common" + +BUILD_DIRS+= contrib/auto_explain +BUILD_DIRS+= contrib/pg_buffercache +BUILD_DIRS+= contrib/pg_stat_statements +BUILD_DIRS+= contrib/pgstattuple + +USE_LIBTOOL= yes +PKG_LIBTOOL= ${PKG_SHLIBTOOL} + +.include "../../databases/postgresql90-client/buildlink3.mk" + +.include "../../mk/bsd.pkg.mk" diff --git a/databases/postgresql90-monitoring/PLIST b/databases/postgresql90-monitoring/PLIST new file mode 100644 index 00000000000..aa0d0ea9eba --- /dev/null +++ b/databases/postgresql90-monitoring/PLIST @@ -0,0 +1,11 @@ +@comment $NetBSD: PLIST,v 1.1.1.1 2010/12/10 19:21:06 asau Exp $ +${PG_SUBPREFIX}lib/libauto_explain.la +${PG_SUBPREFIX}lib/libpg_buffercache.la +${PG_SUBPREFIX}lib/libpg_stat_statements.la +${PG_SUBPREFIX}lib/libpgstattuple.la +${PG_SUBPREFIX}share/postgresql/contrib/pg_buffercache.sql +${PG_SUBPREFIX}share/postgresql/contrib/pg_stat_statements.sql +${PG_SUBPREFIX}share/postgresql/contrib/pgstattuple.sql +${PG_SUBPREFIX}share/postgresql/contrib/uninstall_pg_buffercache.sql +${PG_SUBPREFIX}share/postgresql/contrib/uninstall_pg_stat_statements.sql +${PG_SUBPREFIX}share/postgresql/contrib/uninstall_pgstattuple.sql -- cgit v1.2.3