api.monitoring_view2
Description
Monitoring Last whatever data from json web view
Table Definition
CREATE VIEW monitoring_view2 AS (
SELECT key,
value
FROM jsonb_each(( SELECT m.metrics
FROM api.metrics m
ORDER BY m."time" DESC
LIMIT 1)) jsonb_each(key, value)
)
Columns
| Name | Type | Default | Nullable |
|---|---|---|---|
| key | text | true | |
| value | jsonb | true |
Referenced Tables
| Name | Columns | Comment | Type |
|---|---|---|---|
| jsonb_each | 0 | ||
| api.metrics | 11 | Stores metrics from vessel | BASE TABLE |
Relations
erDiagram
"api.monitoring_view2" {
text key ""
jsonb value ""
}
Generated by tbls