9 lines
511 B
SQL
9 lines
511 B
SQL
-- Convert metric snapshot columns from integer to real for float values from agents
|
|
|
|
ALTER TABLE metric_snapshots ALTER COLUMN cpu_usage_percent TYPE real;
|
|
ALTER TABLE metric_snapshots ALTER COLUMN memory_usage_percent TYPE real;
|
|
ALTER TABLE metric_snapshots ALTER COLUMN disk_usage_percent TYPE real;
|
|
ALTER TABLE metric_snapshots ALTER COLUMN load_average_1m TYPE real;
|
|
ALTER TABLE metric_snapshots ALTER COLUMN load_average_5m TYPE real;
|
|
ALTER TABLE metric_snapshots ALTER COLUMN load_average_15m TYPE real;
|