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
2024-11-06 Today brought in a new category: filesystems. Sadly, the website did not process it well. I am working on that. It may take a few days.
2024-11-07 Commit processing is halted. I have a fix for the new category. It is making its way through the system.
UPDATE: the backend is processing the original filesystems commit now. It should take about an hour.
UPDATE: as of 20:30 UTC, the filesystems commit has been processed. Commit processing is now up to date.
Port details
powa-web PostgreSQL Workload Analyzer is a performance tool for PostgreSQL
4.2.1 databases on this many watch lists=2 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 4.2.1Version of this port present on the latest quarterly branch.
Maintainer: girgen@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2016-09-29 22:42:29
Last Update: 2024-06-09 08:51:40
Commit Hash: 52ef478
People watching this port, also watch:: jdictionary, py311-Automat, py311-python-gdsii, py39-PyOpenGL, p5-Sane
Also Listed In: python
License: PostgreSQL
WWW:
https://powa.readthedocs.org/
Description:
The PostgreSQL Workload Analyzer is performance tool for PostgreSQL 9.4 and later versions, allowing to collect, aggregate and purge statistics on a PostgreSQL instance from various sources. It is implemented as a background worker. Install databases/powa-archivist on your database servers, and this port on any machine with psql access to the databases.
Homepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb

Manual pages:
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist
There is no configure plist information for this port.
Dependency lines:
  • ${PYTHON_PKGNAMEPREFIX}powa-web>0:databases/powa-web@${PY_FLAVOR}
To install the port:
cd /usr/ports/databases/powa-web/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/powa-web
  • pkg install py311-powa-web
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.
NOTE: This is a Python port. Instead of py311-powa-web listed in the above command, you can pick from the names under the Packages section.
PKGNAME: py311-powa-web
Package flavors (<flavor>: <package>)
  • py311: py311-powa-web
distinfo:
TIMESTAMP = 1717922338 SHA256 (powa-web-4.2.1.tar.gz) = 0ada7ce3a5d676b9a998dd7d88724b3a1be8d1601a5e3ec794067c3caccea1fd SIZE (powa-web-4.2.1.tar.gz) = 648606

Packages (timestamps in pop-ups are UTC):
py37-powa-web
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest--4.0.2---4.0.2-
FreeBSD:13:quarterly--------
FreeBSD:14:latest--------
FreeBSD:14:quarterly--------
FreeBSD:15:latest--n/a-n/a---
 
py39-powa-web
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest--------
FreeBSD:13:quarterly--4.1.4--4.2.04.2.04.2.0
FreeBSD:14:latest--4.1.3--4.1.4-4.1.4
FreeBSD:14:quarterly-----4.2.04.2.04.2.0
FreeBSD:15:latest--n/a-n/a4.2.04.2.04.2.0
 
py311-powa-web
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest4.2.14.2.1-4.2.14.2.1---
FreeBSD:13:quarterly4.2.14.2.1-4.2.14.2.1---
FreeBSD:14:latest4.2.14.2.1-4.2.14.2.1---
FreeBSD:14:quarterly4.2.14.2.1-4.2.14.2.1---
FreeBSD:15:latest4.2.14.2.1n/a4.2.1n/a---
 
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. py311-setuptools>=63.1.0 : devel/py-setuptools@py311
  2. python3.11 : lang/python311
Test dependencies:
  1. python3.11 : lang/python311
Runtime dependencies:
  1. py311-psycopg2>0 : databases/py-psycopg2@py311
  2. py311-sqlalchemy10>=1.0 : databases/py-sqlalchemy10@py311
  3. py311-tornado>=2.0 : www/py-tornado@py311
  4. py311-setuptools>=63.1.0 : devel/py-setuptools@py311
  5. python3.11 : lang/python311
There are no ports dependent upon this port

Configuration Options:
No options to configure
Options name:
databases_powa-web
USES:
python
FreshPorts was unable to extract/find any pkg message
Master Sites:
Expand this list (2 items)
Collapse this list.
  1. https://files.pythonhosted.org/packages/source/p/powa-web/
  2. https://pypi.org/packages/source/p/powa-web/
Collapse this list.

Number of commits found: 26

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
4.2.1
09 Jun 2024 08:51:40
commit hash: 52ef478b71c0c4bf449fa9ac7e03fc6fc3244663commit hash: 52ef478b71c0c4bf449fa9ac7e03fc6fc3244663commit hash: 52ef478b71c0c4bf449fa9ac7e03fc6fc3244663commit hash: 52ef478b71c0c4bf449fa9ac7e03fc6fc3244663 files touched by this commit
Palle Girgensohn (girgen) search for other commits by this committer
databases/powa-web: Update to 4.2.1

Release notes:	https://github.com/powa-team/powa-web/releases/tag/4.2.1
4.2.0
20 Sep 2023 08:38:20
commit hash: dbcd4aa99475e74fa87b671e2bfdbbf9227d744dcommit hash: dbcd4aa99475e74fa87b671e2bfdbbf9227d744dcommit hash: dbcd4aa99475e74fa87b671e2bfdbbf9227d744dcommit hash: dbcd4aa99475e74fa87b671e2bfdbbf9227d744d files touched by this commit
Palle Girgensohn (girgen) search for other commits by this committer
databases/powa-web: Upgrade to 4.2.0.

Release notes:	https://github.com/powa-team/powa-web/releases/tag/4.2.0
4.1.4
27 Jun 2023 19:34:34
commit hash: 3d9a815d9c5acbb71f4bb07738bdeab4879feacbcommit hash: 3d9a815d9c5acbb71f4bb07738bdeab4879feacbcommit hash: 3d9a815d9c5acbb71f4bb07738bdeab4879feacbcommit hash: 3d9a815d9c5acbb71f4bb07738bdeab4879feacb files touched by this commit
Rene Ladan (rene) search for other commits by this committer
all: remove explicit versions in USES=python for "3.x+"

The logic in USES=python will automatically convert this to 3.8+ by
itself.

Adjust two ports that only had Python 3.7 mentioned but build fine
on Python 3.8 too.

finance/quickfix: mark BROKEN with PYTHON

libtool: compile:  c++ -DHAVE_CONFIG_H -I. -I../.. -I -I. -I.. -I../.. -I../C++
-DLIBICONV_PLUG -DPYTHON_MAJOR_VERSION=3 -Wno-unused-variable
-Wno-maybe-uninitialized -O2 -pipe -DLIBICONV_PLUG -fstack-protector-strong
-fno-strict-aliasing -DLIBICONV_PLUG -Wall -ansi
-Wno-unused-command-line-argument -Wpointer-arith -Wwrite-strings
-Wno-overloaded-virtual -Wno-deprecated-declarations -Wno-deprecated -std=c++0x
-MT _quickfix_la-QuickfixPython.lo -MD -MP -MF
.deps/_quickfix_la-QuickfixPython.Tpo -c QuickfixPython.cpp  -fPIC -DPIC -o
.libs/_quickfix_la-QuickfixPython.o
warning: unknown warning option '-Wno-maybe-uninitialized'; did you mean
'-Wno-uninitialized'? [-Wunknown-warning-option]
QuickfixPython.cpp:175:11: fatal error: 'Python.h' file not found
          ^~~~~~~~~~
1 warning and 1 error generated.

Reviewed by:	portmgr, vishwin, yuri
Differential Revision:	<https://reviews.freebsd.org/D40568>
4.1.4
02 May 2023 16:09:37
commit hash: ebf38b08cc7e44b875d691c1328e5ead3e3dfbb9commit hash: ebf38b08cc7e44b875d691c1328e5ead3e3dfbb9commit hash: ebf38b08cc7e44b875d691c1328e5ead3e3dfbb9commit hash: ebf38b08cc7e44b875d691c1328e5ead3e3dfbb9 files touched by this commit
Palle Girgensohn (girgen) search for other commits by this committer
www/powa-web: Update to 4.1.4

Release notes:	https://github.com/powa-team/powa-web/releases/tag/4.1.4
4.1.3
11 Jan 2023 15:58:34
commit hash: 77d68471aded6907dbbcb5ef50d557e4c69db656commit hash: 77d68471aded6907dbbcb5ef50d557e4c69db656commit hash: 77d68471aded6907dbbcb5ef50d557e4c69db656commit hash: 77d68471aded6907dbbcb5ef50d557e4c69db656 files touched by this commit
Dmitry Marakasov (amdmi3) search for other commits by this committer
*/*: rename CHEESESHOP to PYPI in MASTER_SITES

PR:			267994
Differential revision:	D37518
Approved by:		bapt
07 Sep 2022 21:58:51
commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4 files touched by this commit
Stefan Eßer (se) search for other commits by this committer
Remove WWW entries moved into port Makefiles

Commit b7f05445c00f has added WWW entries to port Makefiles based on
WWW: lines in pkg-descr files.

This commit removes the WWW: lines of moved-over URLs from these
pkg-descr files.

Approved by:		portmgr (tcberner)
4.1.3
07 Sep 2022 21:10:59
commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52 files touched by this commit
Stefan Eßer (se) search for other commits by this committer
Add WWW entries to port Makefiles

It has been common practice to have one or more URLs at the end of the
ports' pkg-descr files, one per line and prefixed with "WWW:". These
URLs should point at a project website or other relevant resources.

Access to these URLs required processing of the pkg-descr files, and
they have often become stale over time. If more than one such URL was
present in a pkg-descr file, only the first one was tarnsfered into
the port INDEX, but for many ports only the last line did contain the
port specific URL to further information.

There have been several proposals to make a project URL available as
a macro in the ports' Makefiles, over time.
(Only the first 15 lines of the commit message are shown above View all of this commit message)
4.1.3
20 Jul 2022 14:21:07
commit hash: d076ad94e206dda108061fe99ddb860d93cc6d16commit hash: d076ad94e206dda108061fe99ddb860d93cc6d16commit hash: d076ad94e206dda108061fe99ddb860d93cc6d16commit hash: d076ad94e206dda108061fe99ddb860d93cc6d16 files touched by this commit
Tobias C. Berner (tcberner) search for other commits by this committer
databases: remove 'Created by' lines

A big Thank You to the original contributors of these ports:

  *  "Choe, Cheng-Dae" whitekid
  *  "Mahdi Mokhtari <mokhi64@gmail.com>"
  *  "Meikel Brandmeyer" <ocaml-sqlite3-port@kotka.de>
  *  <hvo.pm@xs4all.nl>
  *  <jsmith@resonatingmedia.com>
  *  <ports@c0decafe.net>
  *  Aaron Dalton <aaron@FreeBSD.org>
  *  Adam Weinberger <adamw@FreeBSD.org>
  *  Ade Lovett <ade@FreeBSD.org>
  *  Akinori MUSHA aka knu <knu@idaemons.org>
  *  Alan Snelson <Alan@Wave2.org>
(Only the first 15 lines of the commit message are shown above View all of this commit message)
4.1.3
16 May 2022 10:28:00
commit hash: 42b15f272256509c0864a52256dd277c860ad878commit hash: 42b15f272256509c0864a52256dd277c860ad878commit hash: 42b15f272256509c0864a52256dd277c860ad878commit hash: 42b15f272256509c0864a52256dd277c860ad878 files touched by this commit
Palle Girgensohn (girgen) search for other commits by this committer
databases/powa-web: update to 4.1.3
4.0.2
16 Oct 2021 07:09:25
commit hash: 394a5f426792bc6bf85aefb61aedc3b9b40c4ad5commit hash: 394a5f426792bc6bf85aefb61aedc3b9b40c4ad5commit hash: 394a5f426792bc6bf85aefb61aedc3b9b40c4ad5commit hash: 394a5f426792bc6bf85aefb61aedc3b9b40c4ad5 files touched by this commit
Jimmy Olgeni (olgeni) search for other commits by this committer
databases/powa-web: fix typos in pkg-descr.
4.0.2
06 Apr 2021 14:31:07
commit hash: 305f148f482daf30dcf728039d03d019f88344ebcommit hash: 305f148f482daf30dcf728039d03d019f88344ebcommit hash: 305f148f482daf30dcf728039d03d019f88344ebcommit hash: 305f148f482daf30dcf728039d03d019f88344eb files touched by this commit
Mathieu Arnold (mat) search for other commits by this committer
Remove # $FreeBSD$ from Makefiles.
4.0.2
28 Dec 2020 23:02:15
Revision:559531Original commit files touched by this commit
antoine search for other commits by this committer
Drop python 2.7 support from a few ports

With hat:	portmgr
4.0.2
31 Aug 2020 09:26:02
Revision:547159Original commit files touched by this commit
girgen search for other commits by this committer
Upgrade to 4.0.2

Release notes:	https://github.com/powa-team/powa-web/releases/tag/4.0.2
4.0.1
25 Jun 2020 08:21:56
Revision:540379Original commit files touched by this commit
girgen search for other commits by this committer
Update powa-* to 4.0.1

Release notes: https://github.com/powa-team/powa-archivist/releases
Release notes: https://github.com/powa-team/powa-web/releases
3.2.1
28 Mar 2020 10:45:36
Revision:529325Original commit files touched by this commit
girgen search for other commits by this committer
Update to 3.2.1

Release notes:	https://github.com/powa-team/powa-web/releases/tag/3.2.1
3.2.0_2
26 Jul 2019 20:46:57
Revision:507372Original commit files touched by this commit
gerald search for other commits by this committer
Bump PORTREVISION for ports depending on the canonical version of GCC
as defined in Mk/bsd.default-versions.mk which has moved from GCC 8.3
to GCC 9.1 under most circumstances now after revision 507371.

This includes ports
 - with USE_GCC=yes or USE_GCC=any,
 - with USES=fortran,
 - using Mk/bsd.octave.mk which in turn features USES=fortran, and
 - with USES=compiler specifying openmp, nestedfct, c11, c++0x, c++11-lang,
   c++11-lib, c++14-lang, c++17-lang, or gcc-c++11-lib
plus, everything INDEX-11 shows with a dependency on lang/gcc9 now.

PR:		238330
3.2.0_1
12 Dec 2018 01:35:36
Revision:487272Original commit files touched by this commit
gerald search for other commits by this committer
Bump PORTREVISION for ports depending on the canonical version of GCC
defined via Mk/bsd.default-versions.mk which has moved from GCC 7.4 t
GCC 8.2 under most circumstances.

This includes ports
 - with USE_GCC=yes or USE_GCC=any,
 - with USES=fortran,
 - using Mk/bsd.octave.mk which in turn features USES=fortran, and
 - with USES=compiler specifying openmp, nestedfct, c11, c++0x, c++11-lang,
   c++11-lib, c++14-lang, c++17-lang, or gcc-c++11-lib
plus, as a double check, everything INDEX-11 showed depending on lang/gcc7.

PR:		231590
3.2.0
05 Nov 2018 22:34:50
Revision:484253Original commit files touched by this commit
girgen search for other commits by this committer
Update to 3.2.0

Release notes:	https://github.com/powa-team/powa-web/blob/3.2.0/CHANGELOG
3.1.4
20 Jun 2018 17:05:44
Revision:472884Original commit files touched by this commit
mat search for other commits by this committer
Use PY_FLAVOR for dependencies.

FLAVOR is the current port's flavor, it should not be used outside of
this scope.

Sponsored by:	Absolight
3.1.4
30 Nov 2017 15:50:34
Revision:455210Original commit files touched by this commit Sanity Test Failure
mat search for other commits by this committer
Convert Python ports to FLAVORS.

  Ports using USE_PYTHON=distutils are now flavored.  They will
  automatically get flavors (py27, py34, py35, py36) depending on what
  versions they support.

  There is also a USE_PYTHON=flavors for ports that do not use distutils
  but need FLAVORS to be set.  A USE_PYTHON=noflavors can be set if
  using distutils but flavors are not wanted.

  A new USE_PYTHON=optsuffix that will add PYTHON_PKGNAMESUFFIX has been
  added to cope with Python ports that did not have the Python
  PKGNAMEPREFIX but are flavored.

  USES=python now also exports a PY_FLAVOR variable that contains the
(Only the first 15 lines of the commit message are shown above View all of this commit message)
3.1.4
02 Nov 2017 21:41:47
Revision:453381Original commit files touched by this commit
olgeni search for other commits by this committer
Fix whitespace issues (mixed tab/spaces, alignment) in a few ports.

This round is @FreeBSD.org residents except teams.
3.1.4
11 Oct 2017 07:23:38
Revision:451736Original commit files touched by this commit
girgen search for other commits by this committer
Update to 3.1.4
3.1.3
26 May 2017 15:34:18
Revision:441789Original commit files touched by this commit
girgen search for other commits by this committer
Update to latest version.
3.1.2
19 May 2017 21:25:30
Revision:441274Original commit files touched by this commit
girgen search for other commits by this committer
Update to 3.1.2
3.1.0
08 Oct 2016 13:02:12
Revision:423505Original commit files touched by this commit
girgen search for other commits by this committer
Update to 3.1.0
3.0.2
29 Sep 2016 22:42:19
Revision:422953Original commit files touched by this commit
girgen search for other commits by this committer
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

Number of commits found: 26