FreshPorts -- The Place For Ports If you buy from Amazon USA, please support us by using this link.
Follow us
Blog
Twitter

Port details
powa-archivist PostgreSQL workload analyzer background worker
3.1.1.a.20161106 databases on this many watch lists=0 search for ports that depend on this port Find issues related to this port Report an issue related to this port
Maintainer: girgen@FreeBSD.org search for ports maintained by this maintainer
Port Added: 29 Sep 2016 22:42:29
License: PostgreSQL
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
SVNWeb : Homepage : PortsMon

To install the port: cd /usr/ports/databases/powa-archivist/ && make install clean
To add the package: pkg install powa-archivist

PKGNAME: powa-archivist

distinfo:

TIMESTAMP = 1496357604
SHA256 (dalibo-powa-archivist-3.1.1.a.20161106-521fdf_GH0.tar.gz) = 9d1a613800ba527e987af0b37fa571924be17d66e7c783faa9190e88fc60e533
SIZE (dalibo-powa-archivist-3.1.1.a.20161106-521fdf_GH0.tar.gz) = 58175


NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.

Build dependencies:
  1. gmake : devel/gmake
  2. vacuumlo : databases/postgresql95-contrib
  3. postgres : databases/postgresql95-server
Runtime dependencies:
  1. pg_stat_kcache.so : databases/pg_stat_kcache
  2. pg_qualstats.so : databases/pg_qualstats
  3. vacuumlo : databases/postgresql95-contrib
  4. postgres : databases/postgresql95-server
There are no ports dependent upon this port

Configuration Options
     No options to configure

USES:
gmake pgsql:9.4+

pkg-message:
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.

Master Sites:
  1. https://codeload.github.com/dalibo/powa-archivist/tar.gz/521fdf?dummy=/

Number of commits found: 4

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
10 Aug 2017 08:24:05
Original commit files touched by this commit  3.1.1.a.20161106
Revision:447667
girgen search for other commits by this committer
Update to a preversion 3.1.1

This fixes a problem with an infinite loop.
25 Oct 2016 22:28:22
Original commit files touched by this commit  3.1.0
Revision:424658
mat search for other commits by this committer
Cleanup USE_GITHUB usage.

Sponsored by:	Absolight
01 Oct 2016 14:23:23
Original commit files touched by this commit  3.1.0
Revision:423065
girgen search for other commits by this committer
powa-archivist requires PostgreSQL 9.4 or greater
29 Sep 2016 22:42:19
Original commit files touched by this commit  3.1.0
Revision:422953
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: 4

Login
User Login
Create account

Servers and bandwidth provided by
New York Internet, SuperNews, and RootBSD

This site
What is FreshPorts?
About the authors
Issues
FAQ
How big is it?
The latest upgrade!
Privacy
Forums
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
curlOct 23
mariadb100-server*Oct 23
mariadb101-server*Oct 23
mariadb102-server*Oct 23
mariadb55-server*Oct 23
mysql55-server*Oct 23
mysql56-server*Oct 23
mysql57-server*Oct 23
percona55-server*Oct 23
percona56-server*Oct 23
percona57-server*Oct 23
irssiOct 22
chromiumOct 21
arjOct 19
cactiOct 19

26 vulnerabilities affecting 111 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 31618
Broken 153
Deprecated 79
Ignore 423
Forbidden 0
Restricted 176
No CDROM 78
Vulnerable 58
Expired 16
Set to expire 72
Interactive 0
new 24 hours 2
new 48 hours4
new 7 days24
new fortnight52
new month267

Servers and bandwidth provided by
New York Internet, SuperNews, and RootBSD
Valid HTML, CSS, and RSS.
Copyright © 2000-2017 Dan Langille. All rights reserved.