1  INSERT INTO metrics (type, name, unit)
 2  VALUES
 3      ('sensors.temperature_and_humidity.v1', 'temperature_celsius', 'celsius'),
 4      ('sensors.temperature_and_humidity.v1', 'relative_humidity_percent', 'percent'),
 5      ('sensors.wind_speed.v1', 'wind_speed_kilometers_per_hour', 'kilometers_per_hour'),
 6      ('sensors.wind_direction.v1', 'wind_direction_angle', 'degrees'),
 7      ('sensors.wind_direction.v1', 'wind_direction_slice', 'slice_index'),
 8      ('sensors.solar_radiation.v1', 'solar_radiation_watts_per_square_meter', 'watts_per_square_meter'),
 9      ('sensors.soil.v1', 'temperature_celsius', 'celsius'),
10      ('sensors.soil.v1', 'moisture_percent', 'percent'),
11      ('sensors.soil.v1', 'conductivity', 'conductivity'),
12      ('sensors.soil.v1', 'salinity', 'salinity'),
13      ('sensors.soil.v1', 'tds', 'tds'),
14      ('status.v1', 'memory_heap', 'bytes'),
15      ('status.v1', 'chip_cores', 'count'),
16      ('status.v1', 'chip_revision', 'count'),
17      ('status.v1', 'wifi_rssi', 'dbm'),
18      ('status.v1', 'uptime_seconds', 'seconds')
19  ON CONFLICT (type, name) DO NOTHING;