wrouesnel / postgres_exporter
66%

DEFAULT BRANCH: master
Repo Added
Files 2
Badge
Embed ▾
README BADGES
x

If you need to use a raster PNG badge, change the '.svg' to '.png' in the link

Markdown

Textile

RDoc

HTML

Rst

LAST BUILD ON BRANCH master
branch: SELECT
CHANGE BRANCH
x

coverage: 66.403% (-0.3%) from 66.667%
762

push

travis-ci

web-flow 
User defined configuration to run the query for different database server version from single yml file (#428)

* Run the query for specific database version if provided from yml file.
By default query will run on all the databases if "runonserver" is not provided.

If user want the query to be run on multiple database versions, use below string.
  runonserver: "9.5, 9.6"

Example yml file as below. ( e.g. below query will run only on database version 9.5 )

pg_replication:
  query: "SELECT EXTRACT(EPOCH FROM (now() - pg_last_xact_replay_timestamp())) as lag"
  master: true
  runonserver: "9.5"
  metrics:
    - lag:
        usage: "GAUGE"
        description: "Replication lag behind master in seconds"

* Fixed the below review comments given by Ashesh Vashi

    Instead of having db version string from yml file, user can define the range of
    database server version where query is to be executed.

    If user want to run the query on database version greater than 10.0.0, use below format.
      runonserver: ">=10.0.0"

      Below are the example of db version range user can defined in yml file.
            <=10.1.0
            >=12.1.0
            =11.0.0
            <9.6.0 || >=11.0.0

* Remove the call from unused places where 'runOnServer' is not required.
Only Server type hold that value.

* Fix compilation issues.

* Fix the issue with Debugln to print the database server version

6 of 6 new or added lines in 1 file covered. (100.0%)

755 of 1137 relevant lines covered (66.4%)

23.28 hits per line

Relevant lines Covered
1137 RELEVANT LINES 755 COVERED LINES
23.28 HITS PER LINE
Source Files on master

Recent builds

Builds Branch Commit Type Ran Committer Via Coverage
762 master User defined configuration to run the query for different database server version from single yml file (#428) * Run the query for specific database version if provided from yml file. By default query will run on all the databases if "runonserver... push web-flow travis-ci
66.4
760 master Merge c1b508702 into 301976c21 Pull #428 web-flow travis-ci
66.05
753 master Detect SIReadLock locks in the pg_locks metric (#421) Co-authored-by: Will Rouesnel <wrouesnel@wrouesnel.com> push web-flow travis-ci
66.67
754 docker-build Merge ec7b242b8 into 301976c21 Pull #333 web-flow travis-ci
66.67
750 discover-support-connstrings <a href="https://github.com/wrouesnel/postgres_exporter/commit/041699a46">&lt;a href=&quot;https://github.com/wrouesnel/postgres_exporter/commit/</a><a class="double-link" href="https://github.com/wrouesnel/postgres_... Pull #473 web-flow travis-ci
66.67
733 patch-1 Merge 1e3373c88 into 3864bbc9c Pull #421 web-flow travis-ci
64.23
732 docker-build Merge af3f02b16 into 3864bbc9c Pull #333 web-flow travis-ci
64.23
731 master Update queries.yml (#433) Update query for pg_stat_user_tables: * Split up to multi-line format to make it easier to read. * Remove duplicate of column `COALESCE(last_vacuum, '1970-01-01Z')`. Signed-off-by: Ben Kochie <superq@gmail.com> push web-flow travis-ci
64.23
727 master Do not panic on incorrect env (#457) * do not panic when envs are set incorrectly * do not panic when envs are set incorrectly - fix tests Co-authored-by: Will Rouesnel <wrouesnel@wrouesnel.com> push web-flow travis-ci
64.23
725 master Add query for 'pg_replication_slots' (#465) The existing 'pg_stat_replication' data does not include stats for inactive replication slots. This commit adds a minimal amount of metrics from 'pg_replication_slots' to know if a slot is active an... push web-flow travis-ci
64.7
See All Builds (438)