Gentoo Packages

Search

Install

Install this package:

emerge -a dev-db/pg_qualstats

If the package is masked, you can unmask it using the autounmask tool or standard emerge options:

autounmask dev-db/pg_qualstats

Or alternatively:

emerge --autounmask-write -a dev-db/pg_qualstats

Package Information

Description:: pg_qualstats is a PostgreSQL extension keeping statistics on predicates found in WHERE statements and JOIN clauses. This is useful if you want to be able to analyze what are the most-often executed quals (predicates) on your database. The powa project makes use of this to provide advances index suggestions. It also allows you to identify correlated columns, by identifying which columns are most frequently queried together. The extension works by looking for known patterns in queries. Currently, this includes: - Binary OpExpr where at least one side is a column from a table. Whenever possible, the predicate will be swaped so that CONST OP VAR expressions are turned into VAR COMMUTED_OP CONST. AND and OR expression members are counted as separate entries. Ex: WHERE column1 = 2, WHERE column1 = column2, WHERE 3 = column3 - ScalarArrayOpExpr where the left side is a VAR, and the right side is an array constant. Those will be counted one time per element in the array. Ex: WHERE column1 IN (2, 3) will be counted as 2 occurences for the (column1, '=') operator pair - BooleanTest where the expression is a simple boolean column reference Ex: WHERE column1 IS TRUE Please not that clauses like WHERE columns1, WHERE NOT column1 won't be processed by pg_qualstats (yet)
Homepage:: https://github.com/powa-team/pg_qualstats
License:: Apache-2.0

Versions

Version	EAPI	Keywords
2.1.2	7	~amd64 ~x86
2.1.1	7	~amd64 ~x86
2.1.0	7	~amd64 ~x86

Metadata

Description

pg_qualstats is a PostgreSQL extension keeping statistics on predicates found in WHERE statements and JOIN clauses. This is useful if you want to be able to analyze what are the most-often executed quals (predicates) on your database. The powa project makes use of this to provide advances index suggestions. It also allows you to identify correlated columns, by identifying which columns are most frequently queried together. The extension works by looking for known patterns in queries. Currently, this includes: - Binary OpExpr where at least one side is a column from a table. Whenever possible, the predicate will be swaped so that CONST OP VAR expressions are turned into VAR COMMUTED_OP CONST. AND and OR expression members are counted as separate entries. Ex: WHERE column1 = 2, WHERE column1 = column2, WHERE 3 = column3 - ScalarArrayOpExpr where the left side is a VAR, and the right side is an array constant. Those will be counted one time per element in the array. Ex: WHERE column1 IN (2, 3) will be counted as 2 occurences for the (column1, '=') operator pair - BooleanTest where the expression is a simple boolean column reference Ex: WHERE column1 IS TRUE Please not that clauses like WHERE columns1, WHERE NOT column1 won't be processed by pg_qualstats (yet)

Maintainers

Dan Molik (dan@d3fy.net) - Type: person

Raw Metadata XML

<pkgmetadata>
	<maintainer type="person">
		<email>dan@d3fy.net</email>
		<name>Dan Molik</name>
	</maintainer>
	<longdescription lang="en">
		pg_qualstats is a PostgreSQL extension keeping statistics on predicates found
		in WHERE statements and JOIN clauses.

		This is useful if you want to be able to analyze what are the most-often
		executed quals (predicates) on your database. The powa project makes use of
		this to provide advances index suggestions.

		It also allows you to identify correlated columns, by identifying which
		columns are most frequently queried together.

		The extension works by looking for known patterns in queries. Currently,
		this includes:

		- Binary OpExpr where at least one side is a column from a table. Whenever
		possible, the predicate will be swaped so that CONST OP VAR expressions are
		turned into VAR COMMUTED_OP CONST. AND and OR expression members are counted
		as separate entries.
		Ex: WHERE column1 = 2, WHERE column1 = column2, WHERE 3 = column3

		- ScalarArrayOpExpr where the left side is a VAR, and the right side is an
		array constant. Those will be counted one time per element in the array.
		Ex: WHERE column1 IN (2, 3) will be counted as 2 occurences
		for the (column1, '=') operator pair

		- BooleanTest where the expression is a simple boolean column reference
		Ex: WHERE column1 IS TRUE Please not that clauses like WHERE columns1,
		WHERE NOT column1 won't be processed by pg_qualstats (yet)
	</longdescription>
</pkgmetadata>

Lint Warnings

[Warning] USE flag 'static-libs' in ebuild 2.1.2 is not documented in metadata.xml
[Warning] USE flag 'static-libs' in ebuild 2.1.1 is not documented in metadata.xml
[Warning] USE flag 'static-libs' in ebuild 2.1.0 is not documented in metadata.xml
[Error] Missing md5-cache for ebuild pg_qualstats-2.1.2
[Error] Missing md5-cache for ebuild pg_qualstats-2.1.1
[Error] Missing md5-cache for ebuild pg_qualstats-2.1.0

USE Flags

Manage flags for this package: euse -i <flag> -p dev-db/pg_qualstats | euse -E <flag> -p dev-db/pg_qualstats | euse -D <flag> -p dev-db/pg_qualstats

Flag	Description	2.1.2	2.1.1	2.1.0
static-libs	⚠️	✓	✓	✓

Manifest

Type	File	Size	Versions
DIST	pg_qualstats-2.1.0.tar.gz	37478 bytes	2.1.0
DIST	pg_qualstats-2.1.1.tar.gz	42652 bytes	2.1.1
DIST	pg_qualstats-2.1.2.tar.gz	46286 bytes	2.1.2

Unmatched Entries

Type	File	Size

dev-db/pg_qualstats (defiance)