api.monitoring_view3
Description
Monitoring Timeseries whatever data from json web view
Table Definition
CREATE VIEW monitoring_view3 AS (
SELECT m."time",
jsonb_each_text.key,
jsonb_each_text.value
FROM api.metrics m,
LATERAL jsonb_each_text(m.metrics) jsonb_each_text(key, value)
ORDER BY m."time" DESC
)
Columns
| Name | Type | Default | Nullable |
|---|---|---|---|
| key | text | true | |
| time | timestamp with time zone | true | |
| value | text | true |
Referenced Tables
| Name | Columns | Comment | Type |
|---|---|---|---|
| api.metrics | 11 | Stores metrics from vessel | BASE TABLE |
Relations
erDiagram
"api.monitoring_view3" {
text key ""
timestamp_with_time_zone time ""
text value ""
}
Generated by tbls