pigsty icon indicating copy to clipboard operation
pigsty copied to clipboard

Use oracle compatible query in pg_exporter.yml

Open Vonng opened this issue 1 year ago • 0 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.

Vonng avatar Aug 29 '24 21:08 Vonng