pigsty
pigsty copied to clipboard
Use oracle compatible query in pg_exporter.yml
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.