search

rapidloop / pgmetrics

Collect and display information and stats from a running PostgreSQL server
https://pgmetrics.io
Apache License 2.0
960 stars 65 forks source link

Problem exporting pg_stat_progress_vacuum table #16

Closed bodinsamuel closed 6 years ago

bodinsamuel commented 6 years ago 
./pgmetrics_1.4.0_linux_amd64/pgmetrics --host=127.0.0.1 --port=5432

pgmetrics: pg_stat_progress_vacuum query failed: sql: Scan error on column index 1: converting driver.Value type <nil> ("<nil>") to a int: invalid syntax
postgres=> SELECT * from pg_stat_progress_vacuum;
  pid  | datid | datname  | relid | phase | heap_blks_total | heap_blks_scanned | heap_blks_vacuumed | index_vacuum_count | max_dead_tuples | num_dead_tuples 
-------+-------+----------+-------+-------+-----------------+-------------------+--------------------+--------------------+-----------------+-----------------
 14048 | 12996 | postgres |       |       |                 |                   |                    |                    |                 |                
 14058 | 12996 | postgres |       |       |                 |                   |                    |                    |                 |                
 14069 | 12996 | postgres |       |       |                 |                   |                    |                    |                 |

stack

mdevan commented 6 years ago

This was fixed in release v1.4.1 (commit d987bc9).