Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id_ | varchar | 64 | null |
|
|
||||||
| name_ | varchar | 64 | null |
|
|
||||||
| reporter_ | varchar | 255 | √ | null |
|
|
|||||
| value_ | int8 | 19 | √ | null |
|
|
|||||
| timestamp_ | timestamp | 29,6 | √ | null |
|
|
|||||
| milliseconds_ | int8 | 19 | √ | 0 |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| act_ru_meter_log_pkey | Primary key | Asc | id_ |
| act_idx_meter_log | Performance | Asc/Asc | name_ + timestamp_ |
| act_idx_meter_log_ms | Performance | Asc | milliseconds_ |
| act_idx_meter_log_name_ms | Performance | Asc/Asc | name_ + milliseconds_ |
| act_idx_meter_log_report | Performance | Asc/Asc/Asc | name_ + reporter_ + milliseconds_ |
| act_idx_meter_log_time | Performance | Asc | timestamp_ |