Vonng/pigsty

Use oracle compatible query in pg_exporter.yml

Vonng opened this issue · 1 comments

Since we have Oracle compatibility support via (IvorySQL & PolarDB O).

It is pretty important to make sure all pg_exporter queries are compatible with both PostgreSQL and Oracle.

Two tricky parts:

  • do not use column index in group by
  • do not use raw time type; use epoch.

resolved in v3.0.1