|
1 | 1 | ALTER TABLE agent_stats RENAME TO workspace_agent_stats;
|
2 | 2 |
|
3 | 3 | ALTER TABLE workspace_agent_stats ADD COLUMN connections_by_proto jsonb NOT NULL DEFAULT '{}'::jsonb;
|
4 |
| -ALTER TABLE workspace_agent_stats ADD COLUMN connection_count integer DEFAULT 0 NOT NULL; |
5 |
| -ALTER TABLE workspace_agent_stats ADD COLUMN rx_packets integer DEFAULT 0 NOT NULL; |
6 |
| -ALTER TABLE workspace_agent_stats ADD COLUMN rx_bytes integer DEFAULT 0 NOT NULL; |
7 |
| -ALTER TABLE workspace_agent_stats ADD COLUMN tx_packets integer DEFAULT 0 NOT NULL; |
8 |
| -ALTER TABLE workspace_agent_stats ADD COLUMN tx_bytes integer DEFAULT 0 NOT NULL; |
| 4 | +ALTER TABLE workspace_agent_stats ADD COLUMN connection_count bigint DEFAULT 0 NOT NULL; |
| 5 | +ALTER TABLE workspace_agent_stats ADD COLUMN rx_packets bigint DEFAULT 0 NOT NULL; |
| 6 | +ALTER TABLE workspace_agent_stats ADD COLUMN rx_bytes bigint DEFAULT 0 NOT NULL; |
| 7 | +ALTER TABLE workspace_agent_stats ADD COLUMN tx_packets bigint DEFAULT 0 NOT NULL; |
| 8 | +ALTER TABLE workspace_agent_stats ADD COLUMN tx_bytes bigint DEFAULT 0 NOT NULL; |
9 | 9 |
|
10 | 10 | UPDATE workspace_agent_stats SET
|
11 | 11 | connections_by_proto = coalesce((payload ->> 'conns_by_proto')::jsonb, '{}'::jsonb),
|
12 |
| - connection_count = coalesce((payload ->> 'num_conns')::integer, 0), |
13 |
| - rx_packets = coalesce((payload ->> 'rx_packets')::integer, 0), |
14 |
| - rx_bytes = coalesce((payload ->> 'rx_bytes')::integer, 0), |
15 |
| - tx_packets = coalesce((payload ->> 'tx_packets')::integer, 0), |
16 |
| - tx_bytes = coalesce((payload ->> 'tx_bytes')::integer, 0); |
| 12 | + connection_count = coalesce((payload ->> 'num_conns')::bigint, 0), |
| 13 | + rx_packets = coalesce((payload ->> 'rx_packets')::bigint, 0), |
| 14 | + rx_bytes = coalesce((payload ->> 'rx_bytes')::bigint, 0), |
| 15 | + tx_packets = coalesce((payload ->> 'tx_packets')::bigint, 0), |
| 16 | + tx_bytes = coalesce((payload ->> 'tx_bytes')::bigint, 0); |
17 | 17 |
|
18 | 18 | ALTER TABLE workspace_agent_stats DROP COLUMN payload;
|
0 commit comments