databases/powa-archivist: Update to 5.3.0 Release notes: https://github.com/powa-team/powa-archivist/blob/master/CHANGELOG.mda6f1534d00
Port details
databases/powa-archivist 5.3.0
PostgreSQL workload analyzer background worker
Port info
- Maintainer
- girgen@FreeBSD.org
- Packages
- latest: 5.3.0
- Upstream
- up to date
- Last update
- to 5.3.0 · a6f1534d00
- Quarterly
- 2026Q4: 5.3.0
- WWW
- https://powa.readthedocs.io/en/stable/components/powa-archivist/
- Links
- cgit · VuXML
Install
- Package
# pkg install powa-archivistinstalls 5.3.0 fromlatest; fromquarterly(2026Q4) 5.3.0- Port
# cd /usr/ports/databases/powa-archivist && make install clean- Size
- 58 KiB download · 2.8 MiB installed
- Depends on
- databases/pg_qualstats 2.1.4, databases/pg_stat_kcache 2.3.2, databases/postgresql18-contrib 18.6, databases/postgresql18-server 18.6
- License
- PostgreSQL
- pkg-message
Shown after installing
To activate powa-archvist on your PostgreSQL server, add 'powa' to the list of shared_preload_libraries in $PGDATA/postgresql.conf: shared_preload_libraries = 'pg_stat_statements,powa' track_io_timing = on Also, create the powa database and add extensions createdb powa psql -d powa -c " CREATE EXTENSION pg_stat_statements; CREATE EXTENSION btree_gist; CREATE EXTENSION powa; " After this, restart postgresql to start the background worker. See http://powa.readthedocs.org/en/latest/powa-archivist/installation.html#id1 for detailed installation instructions. Optionally, but warmly recommended, is the use of databases/pg_qualstats and databases/pg_stat_kcache together with powa. Use the databases/powa-web port to visualize the data.
Packages by version and architecture
latest
| FreeBSD version | amd64 | aarch64 | i386 |
|---|---|---|---|
| FreeBSD 16 | 5.3.0 | 5.3.0 | – |
| FreeBSD 15 | 5.3.0 | 5.3.0 | – |
| FreeBSD 14 | 5.3.0 | 5.3.0 | 5.3.0 |
quarterly (2026Q4)
| FreeBSD version | amd64 | aarch64 | i386 |
|---|---|---|---|
| FreeBSD 15 | 5.3.0 | 5.3.0 | – |
| FreeBSD 14 | 5.3.0 | 5.3.0 | 5.3.0 |
version as in the ports tree (latest) or the most common one (quarterly) · different version · ✗ not built · – no packages for this platform. Package sets that have not been rebuilt for 60 days are left out.
Unaddressed and VuXML only (0)
No unaddressed CVE and nothing reported by
pkg audit for the packaged version 5.3.0.Fixed (0)
No VuXML entries for this package.
Problem reports (0) · open in Bugzilla, most recently changed first
None.
Commits (30)
database/powa-(archivist|web): Update to 5.2.0 Release notes: https://github.com/powa-team/powa-web/releases/tag/5.2.0 https://github.com/powa-team/powa-archivist/releases/tag/REL_5_2_09cec673f4b
databases/powa-archivist: Update to 5.1.2 Release notes: https://github.com/powa-team/powa-archivist/releases/tag/REL_5_1_2c831d94d1e
databases/powa-archivist: Update to 5.1.1 Release notes: https://github.com/powa-team/powa-archivist/releases/tag/REL_5_1_18320d3ac79
databases/powa-archivist: Update to 5.1.0 Release notes: https://github.com/powa-team/powa-archivist/releases/tag/REL_5_1_02b4e0502ca
databases/powa-archivist: Update to 5.0.3 Release notes: https://github.com/powa-team/powa-archivist/releases/tag/REL_5_0_3a44e30058b
databases/powa-archivist: Update to 5.0.2 Release notes: https://github.com/powa-team/powa-archivist/releases/tag/REL_5_0_2f3c53f533d
databases/powa-archivist: Update to 5.0.1 Release notes: https://github.com/powa-team/powa-archivist/releases/tag/REL_5_0_1452bd85ebb
databases/powa-archivist: Update to 5.0.0 Release notes: https://github.com/powa-team/powa-archivist/releases/tag/REL_5_0_06436f1a997
databases/powa-archivist: Update the WWW property4e1134e14d
databases/powa-archivist: Upgrade to 4.2.2. Release notes: https://github.com/powa-team/powa-archivist/releases/tag/REL_4_2_2c9efdf4124
databases/powa-archivist: update to 4.2.1 Release notes: https://github.com/powa-team/powa-archivist/releases/tag/REL_4_2_1c0882251e2
databases/powa-archivist: Update to 4.2.0. Release notes: https://github.com/powa-team/powa-archivist/releases/tag/REL_4_2_0e0bf6028cc
*/*: Remove pointers to EOLed pgsql versions - Remove dotted pgsql versions Approved by: portmgra40c0e7d83
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)fb16dfecae
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. This commit implements such a proposal and moves one of the WWW: entries of each pkg-descr file into the respective port's Makefile. A heuristic attempts to identify the most relevant URL in case there is more than one WWW: entry in some pkg-descr file. URLs that are not moved into the Makefile are prefixed with "See also:" instead of "WWW:" in the pkg-descr files in order to preserve them. There are 1256 ports that had no WWW: entries in pkg-descr files. These ports will not be touched in this commit. The portlint port has been adjusted to expect a WWW entry in each port Makefile, and to flag any remaining "WWW:" lines in pkg-descr files as deprecated. Approved by: portmgr (tcberner)b7f05445c0
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> * Aldis Berjoza <graudeejs@gmail.com> * Alessando Sagratini <ale_sagra@hotmail.com> * Alex Dupre <ale@FreeBSD.org> * Alex Samorukov <samm@freebsd.org> * Alexander Logvinov <ports@logvinov,com> * Alexander Logvinov <ports@logvinov.com> * Alexander Nedotsukov <bland@FreeBSD.org> * Alexander Novitsky * Alexander Zhuravlev <zaa@zaa.pp.ru> * Alexey Degtyarev <alexey@renatasystems.org> * Alexey Dokuchaev <danfe@FreeBSD.org> * Anders Nordby <anders@fix.no> * Andrei Antoukh <niwi@niwi.be> * Andrew McNaughton <andrew@scoop.co.nz> * Andrew Pantyukhin <infofarmer@FreeBSD.org> * Andrey Kostenko <andrey@kostenko.name> * Andrey Simonenko * Andrey Zakhvatov * Anes Mukhametov <anes@anes.su> * Anton Berezin <tobez@FreeBSD.org> * Anton Berezin <tobez@tobez.org> * Antonio Carlos Venancio Junior (<antonio@inf.ufsc.br>) * Antonio Carlos Venancio Junior (<antonio@php.net>) * Autrijus Tang <autrijus@autrijus.org> * Babak Farrokhi <farrokhi@FreeBSD.org> * Bartek Rutkowski <r@robakdesign.com> * Bernard Spil <brnrd@FreeBSD.org> * Brent J. Nordquist <bjn@visi.com> * Cezary Morga <cm@therek.net> * Cheng-Lung Sung <clsung@FreeBSD.org> * Choe, Cheng-Dae * Chris D. Faulhaber <jedgar@FreeBSD.org> * Chris Larsen <darth@vader.dk> * Damian Gerow <dgerow@afflictions.org> * Daniel O'Connor * Daniel Wijnands <daniel@itxl.nl> * Dave Green <dg@fastmail.co.uk> * David Thiel <lx@FreeBSD.org> * Davíð Steinn Geirsson <david@isnic.is> * Denis Generalov <gd.workbox@gmail.com> * Denis Generalov <gd@rambler-co.ru> * Denis Shaposhnikov <dsh@bamus.cz> * Dermot Tynan <dtynan@kalopa.com> * Dmitry Liakh <dliakh@ukr.net> * Dmitry Sivachenko <demon@FreeBSD.org> * Dmitry Sivachenko <dima@Chg.RU> * Dmitry Sivachenko <mitya@yandex-team.ru> * Domas Mituzas <midom@dammit.lt> * Dominic Mitchell * Don Owens <don@regexguy.com> * Dryice Dong Liu <dryice@dryice.name> * Edwin Groothuis (edwin@mavetju.org) * Eric Freeman <freebsdports@chillibear.com> * Espen Tagestad <espen@tagestad.no> * Espen Volden aka voldern <voldern@hoeggen.net> * Evan Sarmiento <bsdports@wayfair.com> * Fernan Aguero <fernan@iib.unsam.edu.ar> * Frank Wall <fw@moov.de> * Ganbold Tsagaankhuu <ganbold@FreeBSD.org> * Gary Palmer <gpalmer@FreeBSD.org> * Gea-Suan Lin <gslin@gslin.org> * Geraud CONTINSOUZAS <geraud@gcu.info> * Gerrit Beine <tux@pinguru.net> * Greg Larkin <glarkin@FreeBSD.org> * Grzegorz Blach <gblach@FreeBSD.org> * Hansjoerg Pehofer <hansjoerg.pehofer@uibk.ac.at> * Henk van Oers <hvo.pm@xs4all.nl> * Henrik Hodne <henrik@hodne.io> * Hiroyuki Hanai <hanai@FreeBSD.org> * Horia Racoviceanu <horia@racoviceanu.com> * Hye-Shik Chang * Hye-Shik Chang <perky@python.or.kr> * Ilia Chipitsine <ilia@jane.cgu.chel.su> * Ivan Voras <ivoras@FreeBSD.org> * J.F. Dockes * Jaap Boender <jaapb@kerguelen.org> * Jake Smith <jake@xz.cx> * James FitzGibbon <jfitz@FreeBSD.org> * Janos Mohacsi <janos.mohacsi@bsd.hu> * Janos.Mohacsi@bsd.hu * Jason Helfman <jgh@FreeBSD.org> * Jens Rehsack <rehsack@liwing.de> * Jeremy Chadwick <koitsu@FreeBSD.org> * Jev Björsell <ports@ecadlabs.com> * Jim Ohlstein <jim@ohlste.in> * Jin-Shan Tseng <tjs@cdpa.nsysu.edu.tw> * Joe Horn <joehorn@gmail.com> * Joe Marcus Clarke <marcus@FreeBSD.org> * Johannes Meixner <johannes@perceivon.net> * John Chen <johnpupu@gmail.com> * John Marino <marino@FreeBSD.org> * John Merryweather Cooper * John Merryweather Cooper et al * Jon Nistor <nistor@snickers.org> * Jonathan Weiss (<jw@innerewut.de>) * Jose Jachuf <jjachuf@gmail.com> * Joshua D. Abraham <jabra@ccs.neu.edu> * Jov <amutu@amutu.com> * Jov amutu@amutu.com * Jui-Nan Lin <jnlin@freebsd.cs.nctu.edu.tw> * Julien Laffaye <kimelto@gmail.com> * Jyun-Yan You <jyyou@cs.nctu.edu.tw> * Keith Gaughan <k@sterechro.me> * Kevin Bowling <kbowling@freebsd.org> * Kimo <kimor79@yahoo.com> * Kimura Fuyuki <fuyuki@nigredo.org> * Koop Mast <kwm@FreeBSD.org> * Lars Balker Rasmussen <lbr@FreeBSD.org * Lars Balker Rasmussen <lbr@FreeBSD.org> * Lars Eggert <larse@isi.edu> * Lars Thegler <lars@thegler.dk> * Lars Thegler <lth@FreeBSD.org> * Li-Wen Hsu <lwhsu@FreeBSD.org> * Loïc BARTOLETTI * Loïc BARTOLETTI <lbartoletti@FreeBSD.org> * Lubomir Marinov <lubomir_m@abv.bg> * Mahdi Mokhtari <mokhi64@gmail.com> * Mahlon E. Smith <mahlon@martini.nu> * Marc G. Fournier <scrappy@FreeBSD.org> * Mark Felder <feld@FreeBSD.org> * Markus Brueffer <markus@FreeBSD.org> * Martin Matuska <martin@matuska.org> * Martin Matuska <mm@FreeBSD.org> * Martin Wilke <miwi@FreeBSD.org> * Mathieu Arnold <m@absolight.net> * Matthew Seaman * Matthias Andree <mandree@FreeBSD.org> * Matthias Fechner <mfechner@FreeBSD.org> * Matthias Petermann <matthias@petermann-it.de> * Max Khon * Max Khon <fjoe@FreeBSD.org> * Michael Johnson <ahze@FreeBSD.org> * Michael Johnson <ahze@ahze.net> * Michael Winking <mwfp@foldl.net> * Mikael URANKAR and Loïc BARTOLETTI * Mike Carlson (carlson39@llnl.gov) * Mikhail T. <michael@fun-box.ru> * Mikhail Teterin * Mikhail Teterin <mi@aldan.algebra.com> * Mikolaj Golub <trociny@FreeBSD.org> * Mirko Zinn <mail@derzinn.de> * Mohammad S. Babaei <info@babaei.net> * Muhammad Moinur Rahman <bofh@FreeBSD.org> * Nick Hibma <n_hibma@freebsd.org> * Nick Hilliard <nick@foobar.org> * Nick Sayer <nsayer@FreeBSD.org> * Nicola Vitale <nivit@FreeBSD.org> * Nicolas Embriz <nbari@tequila.io> * Nicolas de Bari Embriz <nbari@dalmp.com> * Oleg Sharoiko <os@rsu.ru> * Olexander Melnyk <olexander.v.melnyk@gmail.com> * Oliver Eikemeier <eikemeier@fillmore-labs.com> * Olivier Duchateau <duchateau.olivier@gmail.com> * Palle Girgensohn <girgen@FreeBSD.org> * Palle Girgensohn <girgen@partitur.se> * Palle Girgensohn <girgen@pingpong.net> * Parv <parv@pair.org> * Pete Fritchman <petef@databits.net> * Peter Avalos <pavalos@theshell.com> * Philip M. Gollucci * Philip M. Gollucci <philip@p6m7g8.com> * Philip Stoev <philip.stoev@galeracluster.com> * Pierre-Emmanuel Andre <pea@raveland.org> * Pietro Cerutti <gahr@FreeBSD.org> * Piotr Kubaj <pkubaj@anongoth.pl> * Po-Chuan Hsieh <sunpoet@FreeBSD.org> * Qing Feng <qingfeng@douban.com> * Quinton Dolan <q@onthenet.com.au> * Radim Kolar * Rainer Hurling <rhurlin@gwdg.de> * Rick Miller * Robert Kruus <rob.kruus@gmail.com> * Rod Taylor <ports@rbt.ca> * Roland van Laar <roland@micite.net> * Rong-En Fan <rafan@FreeBSD.org> * Roy Boerner * Rozhuk Ivan <rozhuk.im@gmail.com> * Rusty Nejdl * Ryan Steinmetz <rpsfa@rit.edu> * Ryan Steinmetz <zi@FreeBSD.org> * Ryan T. Dean <rtdean@cytherianage.net> * Sam Lawrance <boris@brooknet.com.au> * Scott McWhirter <scott@surreytech.co.uk> * Seamus Venasse <svenasse@polaris.ca> * Sean Chittenden <seanc@FreeBSD.org> * Sergei Kolobov <sergei@kolobov.com> * Sergei Vyshenski <svysh.fbsd@gmail.com> * Sergey A. Osokin <osa@FreeBSD.org.ru> * Sergey A. Osokin <osa@FreeBSD.org> * Sergey Matveychuk <sem@FreeBSD.org> * Sergey Skvortsov <skv@FreeBSD.org> * Sergey Skvortsov <skv@protey.ru> * Sevan Janiyan <venture37@geeklan.co.uk> * Sheldon Hearn <sheldonh@FreeBSD.org> * Stanislav Svirid <count@211.ru> * Stefan Schmidt <stefan.schmidt@stadtbuch.de> * Steve Wills <swills@FreeBSD.org> * Steve Wills <swills@freebsd.org> * Steven Kreuzer <skreuzer@FreeBSD.org> * Sunpoet Po-Chuan Hsieh <sunpoet@FreeBSD.org> * Sunpoet Po-Chuan Hsieh <sunpoet@sunpoet.net> * T. William Wells <bill@twwells.com> * TAKATSU Tomonari <tota@FreeBSD.org> * Thierry Thomas (<thierry@pompo.net>) * Thomas Gellekum <tg@FreeBSD.org> * Timur I. Bakeyev <bat@cpan.org> * Tom Judge <tj@FreeBSD.org> * Torsten Zuehlsdorff <ports@toco-domains.de> * Torsten Zuhlsdorff <ports@toco-domains.de> * Toshiya Saitoh (<toshiya@saitoh.nu>) * Tsung-Han Yeh <snowfly@yuntech.edu.tw> * Vasil Dimov <vd@FreeBSD.org> * Veniamin Gvozdikov <vg@FreeBSD.org> * Vladimir Timofeev <vovkasm@gmail.com> * Wen Heping * Wen Heping <wen@FreeBSD.org> * Wen Heping <wenheping@gmail.com> * Wen heping <wenheping@gmail.com> * William Grzybowski <wg@FreeBSD.org> * Xin Li <delphij@FreeBSD.org> * Yarema <yds@CoolRat.org> * Yarema <yds@Necessitu.de> * Yen-Ming Lee <leeym@FreeBSD.org> * Ying-Chieh Liao <ijliao@FreeBSD.org> * Yoichi NAKAYAMA <yoichi@FreeBSD.org> * Yuri Victorovich <yuri@rawbw.com> * Zach Thompson <hideo@lastamericanempire.com> * Zach Thompson <lin-chi@lastamericanempire.com> * ache@FreeBSD.org * alfred * alp@sfedu.ru * andrew@scoop.co.nz * andrey@kostenko.name * chinsan * chinsan <chinsan.tw@gmail.com> * clive * clive@FreeBSD.org * clsung@dragon2.net * dcf@aracnet.com * elvstone@gmail.com * erikhb@bgnett.no * erwin@FreeBSD.org * gahr * ijliao * ijlioa * ivoras * johnpupu <johnpupu@gmail.com> * kirk@daycos.com * kuriyama * lbartoletti <lbartoletti@FreeBSD.org> * loïc bartoletti <lbartoletti@FreeBSD.org> * mharo@FreeBSD.org * michael johnson <ahze@ahze.net> * milki <milki@rescomp.berkeley.edy> * mm@FreeBSD.org * nbm * nectar@FreeBSD.org * nork@FreeBSD.org * nork@cityfujisawa.ne.jp * olevole@olevole.ru * proler@gmail.com * sergey@migsoft.com.ua * sobomax * spam@rm-rf.kiev.ua * stas * tobez * tremere@cainites.net * vanilla * vanilla@ * wen@FreeBSD.org * wenheping<wenheping@gmail.com> * wolman@cs.washington.edu * # Created by Kevin Bowling <kbowling@FreeBSD.org> * # Created by Matthias Fechner <mfechner@FreeBSD.org> With hat: portmgrd076ad94e2
databases/powa-archivist: update to 4.1.4 Release notes: https://github.com/powa-team/powa-archivist/releases/tag/REL_4_1_41f3ab6c64a
databases/powa-archivist: update to 4.1.38868e125ba
Remove # $FreeBSD$ from Makefiles.305f148f48
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/releases7a719fbbf7
Convert to UCL & cleanup pkg-message (categories d)78d1aff1fc
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: 238330ea8c8ec7da
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: 231590a9f015d155
Fix USE_GITHUB usage.cb6b6b50f9
Upgrade powa-archivist and siblings pg_qualstat-1.0.6 pg_stat_kcache-2.1.1 powa-archvist-3.2.0 Release notes: https://github.com/powa-team/powa-archivist/blob/REL_3_2_0/CHANGELOG.md https://github.com/powa-team/pg_qualstats/blob/1.0.6/CHANGELOG https://github.com/powa-team/pg_stat_kcache/blob/REL2_1_1/CHANGELOG.md4b49964033
Update to a preversion 3.1.1 This fixes a problem with an infinite loop.35c8396c5e
Cleanup USE_GITHUB usage. Sponsored by: Absolightd17f126e64
powa-archivist requires PostgreSQL 9.4 or greatere83148747a
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 clauses4eb50a146e