powa-archivist - PostgreSQL workload analyzer background worker

Property Value
Distribution FreeBSD 11
Repository FreeBSD Ports Latest i386
Package filename powa-archivist-3.2.0_2.txz
Package name powa-archivist
Package version 3.2.0
Package release 2
Package architecture i386
Package type txz
Category databases
Homepage http://powa.readthedocs.org/en/latest/powa-archivist/index.html
License PostgreSQL
Maintainer girgen@FreeBSD.org
Download size 30.97 KB
Installed size 543.02 KB
This project is the core extension of the PoWA project, a PostgreSQL Workload
Analyzer that gathers performance stats and provides real-time charts and
graphs to help monitor and tune your PostgreSQL servers.
WWW: http://powa.readthedocs.org/en/latest/powa-archivist/index.html
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;
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.


Package Version Architecture Repository
powa-archivist-3.2.0_2.txz 3.2.0 amd64 FreeBSD Ports Latest
powa-archivist-3.2.0_2.txz 3.2.0 i386 FreeBSD Ports Quarterly
powa-archivist-3.2.0_2.txz 3.2.0 amd64 FreeBSD Ports Quarterly
powa-archivist - - -


Name Value
pg_qualstats = 1.0.7_2
pg_stat_kcache = 2.1.1_2
postgresql95-contrib = 9.5.18_1
postgresql95-server = 9.5.18_1


Type URL
Mirror pkg.freebsd.org
Binary Package powa-archivist-3.2.0_2.txz
Source Package databases/powa-archivist

Install Howto

Install powa-archivist txz package:

# pkg install powa-archivist

See Also

Package Description
powder-115_3.txz Graphical dungeon crawling game
powder-toy-94.1_1.txz 'Falling sand' physics sandbox with air pressure and velocity support
powerarchitect-1.0.8.txz Data modeling and profiling tool
powerdns-4.2.0.txz Advanced DNS server with multiple backends including SQL
powerdns-recursor-4.2.0.txz Advanced DNS recursor
powerdxx-0.4.1_1.txz CPU clock speed/frequency daemon
powerline-fonts- Fixed width sans fonts for use with powerline
powerman-2.3.20_2.txz Tool for doing remote power control
powermanga-0.93.1.txz Arcade 2D shoot-em-up
powerpc64-binutils-2.32_1,1.txz GNU binutils for powerpc64 cross-development
powerpc64-gcc-6.4.0_7.txz Cross GNU Compiler Collection for powerpc64
powerpc64-xtoolchain-gcc-0.4_1.txz Pre seeded toolchain to cross build FreeBSD base
powwow-1.2.17.txz Client to play MUDs
poxml-19.08.2.txz Tools to translate Docbook XML using gettext
pp-1.03_1.txz Small and fast progress bar for pipe