Skip to content

collected metric was collected before with the same name and label values #998

New issue
New issue
Open
Open
collected metric was collected before with the same name and label values#998
@eriktelepovsky

Description

@eriktelepovsky
eriktelepovsky
opened on Jan 22, 2024

What did you do?

I started postgres-exporter using following docker-compose file:

  postgres-exporter:
    container_name: postgres-exporter
    image: prometheuscommunity/postgres-exporter
    environment:
      - DATA_SOURCE_NAME=postgresql://user:password@host:port/my_database  # I changed this for issue purpose 
    command:
      # - "--disable-default-metrics"  # doesn't matter if I run it with or without this argument 
      - "--collector.stat_statements"  # error: collected before with the same name and label values
    ports:
      - "9187:9187"

What did you expect to see?

Opening http://127.0.0.1:9187/metrics I expected to see all metrics including statements.

What did you see instead? Under which circumstances?

I see 120 errors instead, but only when using --collector.stat_statements:

An error has occurred while serving metrics:

120 error(s) occurred:
* collected metric "pg_stat_statements_calls_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:145094}} was collected before with the same name and label values
* collected metric "pg_stat_statements_seconds_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:1382.6511825559967}} was collected before with the same name and label values
* collected metric "pg_stat_statements_rows_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:435282}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_read_seconds_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_write_seconds_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_calls_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:145185}} was collected before with the same name and label values
* collected metric "pg_stat_statements_seconds_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:55.34379315600012}} was collected before with the same name and label values
* collected metric "pg_stat_statements_rows_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:871110}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_read_seconds_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_write_seconds_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_calls_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"_updb"}  counter:{value:2.173387e+06}} was collected before with the same name and label values
* collected metric "pg_stat_statements_seconds_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"_updb"}  counter:{value:47.36949219000851}} was collected before with the same name and label values
* collected metric "pg_stat_statements_rows_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"_updb"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_read_seconds_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"_updb"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_write_seconds_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"_updb"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_calls_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:145185}} was collected before with the same name and label values
* collected metric "pg_stat_statements_seconds_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:33.97874588199985}} was collected before with the same name and label values
* collected metric "pg_stat_statements_rows_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:290354}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_read_seconds_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_write_seconds_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_calls_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:431657}} was collected before with the same name and label values
* collected metric "pg_stat_statements_seconds_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:32.00555152200009}} was collected before with the same name and label values
* collected metric "pg_stat_statements_rows_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:1.294971e+06}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_read_seconds_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_write_seconds_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_calls_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:145185}} was collected before with the same name and label values
* collected metric "pg_stat_statements_seconds_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:22.935943721999884}} was collected before with the same name and label values
* collected metric "pg_stat_statements_rows_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:145185}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_read_seconds_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_write_seconds_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_calls_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"_updb"}  counter:{value:2.173386e+06}} was collected before with the same name and label values
* collected metric "pg_stat_statements_seconds_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"_updb"}  counter:{value:19.923873926997413}} was collected before with the same name and label values
* collected metric "pg_stat_statements_rows_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"_updb"}  counter:{value:2.173386e+06}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_read_seconds_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"_updb"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_write_seconds_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"_updb"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_calls_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:145185}} was collected before with the same name and label values
* collected metric "pg_stat_statements_seconds_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:16.86972648199979}} was collected before with the same name and label values
* collected metric "pg_stat_statements_rows_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:145185}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_read_seconds_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_write_seconds_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_calls_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:430448}} was collected before with the same name and label values
* collected metric "pg_stat_statements_seconds_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:11.949401952000116}} was collected before with the same name and label values
* collected metric "pg_stat_statements_rows_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:430448}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_read_seconds_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_write_seconds_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_calls_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"_updb"}  counter:{value:2.173387e+06}} was collected before with the same name and label values
* collected metric "pg_stat_statements_seconds_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"_updb"}  counter:{value:9.745451962989884}} was collected before with the same name and label values
* collected metric "pg_stat_statements_rows_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"_updb"}  counter:{value:2.173387e+06}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_read_seconds_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"_updb"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_write_seconds_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"_updb"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_calls_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:145185}} was collected before with the same name and label values
* collected metric "pg_stat_statements_seconds_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:8.085575071000099}} was collected before with the same name and label values
* collected metric "pg_stat_statements_rows_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:1.016295e+06}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_read_seconds_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_write_seconds_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_calls_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:430450}} was collected before with the same name and label values
* collected metric "pg_stat_statements_seconds_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:7.9014078029997465}} was collected before with the same name and label values
* collected metric "pg_stat_statements_rows_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:1.297141e+06}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_read_seconds_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_write_seconds_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_calls_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:290370}} was collected before with the same name and label values
* collected metric "pg_stat_statements_seconds_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:5.888327989999761}} was collected before with the same name and label values
* collected metric "pg_stat_statements_rows_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_read_seconds_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_write_seconds_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_calls_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"_updb"}  counter:{value:51}} was collected before with the same name and label values
* collected metric "pg_stat_statements_seconds_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"_updb"}  counter:{value:5.648648003}} was collected before with the same name and label values
* collected metric "pg_stat_statements_rows_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"_updb"}  counter:{value:51}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_read_seconds_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"_updb"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_write_seconds_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"_updb"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_calls_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:585396}} was collected before with the same name and label values
* collected metric "pg_stat_statements_seconds_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:5.033520371000066}} was collected before with the same name and label values
* collected metric "pg_stat_statements_rows_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:585396}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_read_seconds_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_write_seconds_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_calls_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:290370}} was collected before with the same name and label values
* collected metric "pg_stat_statements_seconds_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:4.884215216999991}} was collected before with the same name and label values
* collected metric "pg_stat_statements_rows_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_read_seconds_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_write_seconds_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_calls_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:142092}} was collected before with the same name and label values
* collected metric "pg_stat_statements_seconds_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:4.015534736999865}} was collected before with the same name and label values
* collected metric "pg_stat_statements_rows_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_read_seconds_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_write_seconds_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_calls_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:145185}} was collected before with the same name and label values
* collected metric "pg_stat_statements_seconds_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:3.905134878999939}} was collected before with the same name and label values
* collected metric "pg_stat_statements_rows_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:725925}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_read_seconds_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_write_seconds_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_calls_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:72344}} was collected before with the same name and label values
* collected metric "pg_stat_statements_seconds_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:3.298348626000012}} was collected before with the same name and label values
* collected metric "pg_stat_statements_rows_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:145663}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_read_seconds_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_write_seconds_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_calls_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"_updb"}  counter:{value:51}} was collected before with the same name and label values
* collected metric "pg_stat_statements_seconds_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"_updb"}  counter:{value:3.278106381000001}} was collected before with the same name and label values
* collected metric "pg_stat_statements_rows_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"_updb"}  counter:{value:51}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_read_seconds_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"_updb"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_write_seconds_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"_updb"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_calls_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:145185}} was collected before with the same name and label values
* collected metric "pg_stat_statements_seconds_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:3.211697052999987}} was collected before with the same name and label values
* collected metric "pg_stat_statements_rows_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:145185}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_read_seconds_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_write_seconds_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_calls_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:52}} was collected before with the same name and label values
* collected metric "pg_stat_statements_seconds_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:2.730091644}} was collected before with the same name and label values
* collected metric "pg_stat_statements_rows_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:52}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_read_seconds_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_write_seconds_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_calls_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"_updb"}  counter:{value:51}} was collected before with the same name and label values
* collected metric "pg_stat_statements_seconds_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"_updb"}  counter:{value:2.6115781110000005}} was collected before with the same name and label values
* collected metric "pg_stat_statements_rows_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"_updb"}  counter:{value:51}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_read_seconds_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"_updb"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_write_seconds_total" { label:{name:"datname"  value:"_updb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"_updb"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_calls_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:145185}} was collected before with the same name and label values
* collected metric "pg_stat_statements_seconds_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:1.297608032999997}} was collected before with the same name and label values
* collected metric "pg_stat_statements_rows_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:145185}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_read_seconds_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:0}} was collected before with the same name and label values
* collected metric "pg_stat_statements_block_write_seconds_total" { label:{name:"datname"  value:"defaultdb"}  label:{name:"queryid"  value:"unknown"}  label:{name:"user"  value:"postgres"}  counter:{value:0}} was collected before with the same name and label values

Environment

  • System information:

I tried on 2 systems:

  1. my MacBooks: Darwin 22.5.0 arm64
  2. my Linux server: Linux 5.10.0-18-amd64 x86_64
  • postgres_exporter version:

postgres_exporter, version 0.15.0 (branch: HEAD, revision: 68c176b)
build user: root@7c5a76bc737a
build date: 20231027-14:38:04
go version: go1.21.3
platform: linux/arm64
tags: unknown

  • postgres_exporter flags:
collector.stat_statements
  • PostgreSQL version:

14.10.0

  • Logs:
ts=2024-01-22T15:07:02.463Z caller=main.go:86 level=warn msg="Error loading config" err="Error opening config file \"postgres_exporter.yml\": open postgres_exporter.yml: no such file or directory"
ts=2024-01-22T15:07:02.464Z caller=proc.go:267 msg="Excluded databases" databases="[\"template0 template1 _updb defaultdb\"]"
ts=2024-01-22T15:07:02.464Z caller=main.go:103 level=warn msg="Scraping additional databases via auto discovery is DEPRECATED"
ts=2024-01-22T15:07:02.472Z caller=tls_config.go:274 level=info msg="Listening on" address=[::]:9187
ts=2024-01-22T15:07:02.472Z caller=tls_config.go:277 level=info msg="TLS is disabled." http2=false address=[::]:9187
ts=2024-01-22T15:07:02.946Z caller=server.go:74 level=info msg="Established new database connection" fingerprint=host:port
ts=2024-01-22T15:07:03.243Z caller=postgres_exporter.go:613 level=info msg="Semantic version changed" server=host:port from=0.0.0 to=14.10.0

(I changed host and port for issue purpose)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions