api.explore_view
Description
explore_view web view
Table Definition
CREATE VIEW explore_view AS (
WITH raw_metrics AS (
SELECT m."time",
m.metrics
FROM api.metrics m
ORDER BY m."time" DESC
LIMIT 1
)
SELECT raw_metrics."time",
jsonb_each_text.key,
jsonb_each_text.value
FROM raw_metrics,
LATERAL jsonb_each_text(raw_metrics.metrics) jsonb_each_text(key, value)
ORDER BY jsonb_each_text.key
)
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.explore_view" {
text key ""
timestamp_with_time_zone time ""
text value ""
}
Generated by tbls