| ur_ingest_session_files_stats_latest |
file_extension |
|
/console/info-schema/view.sql?name=ur_ingest_session_files_stats_latest&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_files_stats_latest&stats=yes) |
[ur_ingest_session_files_stats_latest (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_files_stats_latest&stats=yes) |
/console/content/view/ur_ingest_session_files_stats_latest.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_files_stats_latest.sql?stats=yes) |
[ur_ingest_session_files_stats_latest (view) Content](console/content/view/ur_ingest_session_files_stats_latest.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_files_stats_latest" AS
SELECT iss.*
FROM ur_ingest_session_files_stats AS iss
JOIN ( SELECT ur_ingest_session.ur_ingest_session_id AS latest_session_id
FROM ur_ingest_session
ORDER BY ur_ingest_session.ingest_finished_at DESC
LIMIT 1) AS latest
ON iss.ingest_session_id = latest.latest_session_id |
| ur_ingest_session_files_stats_latest |
ingest_session_fs_path_id |
VARCHAR |
/console/info-schema/view.sql?name=ur_ingest_session_files_stats_latest&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_files_stats_latest&stats=yes) |
[ur_ingest_session_files_stats_latest (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_files_stats_latest&stats=yes) |
/console/content/view/ur_ingest_session_files_stats_latest.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_files_stats_latest.sql?stats=yes) |
[ur_ingest_session_files_stats_latest (view) Content](console/content/view/ur_ingest_session_files_stats_latest.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_files_stats_latest" AS
SELECT iss.*
FROM ur_ingest_session_files_stats AS iss
JOIN ( SELECT ur_ingest_session.ur_ingest_session_id AS latest_session_id
FROM ur_ingest_session
ORDER BY ur_ingest_session.ingest_finished_at DESC
LIMIT 1) AS latest
ON iss.ingest_session_id = latest.latest_session_id |
| ur_ingest_session_files_stats_latest |
ingest_session_root_fs_path |
TEXT |
/console/info-schema/view.sql?name=ur_ingest_session_files_stats_latest&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_files_stats_latest&stats=yes) |
[ur_ingest_session_files_stats_latest (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_files_stats_latest&stats=yes) |
/console/content/view/ur_ingest_session_files_stats_latest.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_files_stats_latest.sql?stats=yes) |
[ur_ingest_session_files_stats_latest (view) Content](console/content/view/ur_ingest_session_files_stats_latest.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_files_stats_latest" AS
SELECT iss.*
FROM ur_ingest_session_files_stats AS iss
JOIN ( SELECT ur_ingest_session.ur_ingest_session_id AS latest_session_id
FROM ur_ingest_session
ORDER BY ur_ingest_session.ingest_finished_at DESC
LIMIT 1) AS latest
ON iss.ingest_session_id = latest.latest_session_id |
| ur_ingest_session_files_stats_latest |
total_file_count |
|
/console/info-schema/view.sql?name=ur_ingest_session_files_stats_latest&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_files_stats_latest&stats=yes) |
[ur_ingest_session_files_stats_latest (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_files_stats_latest&stats=yes) |
/console/content/view/ur_ingest_session_files_stats_latest.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_files_stats_latest.sql?stats=yes) |
[ur_ingest_session_files_stats_latest (view) Content](console/content/view/ur_ingest_session_files_stats_latest.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_files_stats_latest" AS
SELECT iss.*
FROM ur_ingest_session_files_stats AS iss
JOIN ( SELECT ur_ingest_session.ur_ingest_session_id AS latest_session_id
FROM ur_ingest_session
ORDER BY ur_ingest_session.ingest_finished_at DESC
LIMIT 1) AS latest
ON iss.ingest_session_id = latest.latest_session_id |
| ur_ingest_session_files_stats_latest |
file_count_with_content |
|
/console/info-schema/view.sql?name=ur_ingest_session_files_stats_latest&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_files_stats_latest&stats=yes) |
[ur_ingest_session_files_stats_latest (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_files_stats_latest&stats=yes) |
/console/content/view/ur_ingest_session_files_stats_latest.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_files_stats_latest.sql?stats=yes) |
[ur_ingest_session_files_stats_latest (view) Content](console/content/view/ur_ingest_session_files_stats_latest.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_files_stats_latest" AS
SELECT iss.*
FROM ur_ingest_session_files_stats AS iss
JOIN ( SELECT ur_ingest_session.ur_ingest_session_id AS latest_session_id
FROM ur_ingest_session
ORDER BY ur_ingest_session.ingest_finished_at DESC
LIMIT 1) AS latest
ON iss.ingest_session_id = latest.latest_session_id |
| ur_ingest_session_files_stats_latest |
file_count_with_frontmatter |
|
/console/info-schema/view.sql?name=ur_ingest_session_files_stats_latest&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_files_stats_latest&stats=yes) |
[ur_ingest_session_files_stats_latest (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_files_stats_latest&stats=yes) |
/console/content/view/ur_ingest_session_files_stats_latest.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_files_stats_latest.sql?stats=yes) |
[ur_ingest_session_files_stats_latest (view) Content](console/content/view/ur_ingest_session_files_stats_latest.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_files_stats_latest" AS
SELECT iss.*
FROM ur_ingest_session_files_stats AS iss
JOIN ( SELECT ur_ingest_session.ur_ingest_session_id AS latest_session_id
FROM ur_ingest_session
ORDER BY ur_ingest_session.ingest_finished_at DESC
LIMIT 1) AS latest
ON iss.ingest_session_id = latest.latest_session_id |
| ur_ingest_session_files_stats_latest |
min_file_size_bytes |
|
/console/info-schema/view.sql?name=ur_ingest_session_files_stats_latest&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_files_stats_latest&stats=yes) |
[ur_ingest_session_files_stats_latest (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_files_stats_latest&stats=yes) |
/console/content/view/ur_ingest_session_files_stats_latest.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_files_stats_latest.sql?stats=yes) |
[ur_ingest_session_files_stats_latest (view) Content](console/content/view/ur_ingest_session_files_stats_latest.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_files_stats_latest" AS
SELECT iss.*
FROM ur_ingest_session_files_stats AS iss
JOIN ( SELECT ur_ingest_session.ur_ingest_session_id AS latest_session_id
FROM ur_ingest_session
ORDER BY ur_ingest_session.ingest_finished_at DESC
LIMIT 1) AS latest
ON iss.ingest_session_id = latest.latest_session_id |
| ur_ingest_session_files_stats_latest |
average_file_size_bytes |
INT |
/console/info-schema/view.sql?name=ur_ingest_session_files_stats_latest&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_files_stats_latest&stats=yes) |
[ur_ingest_session_files_stats_latest (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_files_stats_latest&stats=yes) |
/console/content/view/ur_ingest_session_files_stats_latest.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_files_stats_latest.sql?stats=yes) |
[ur_ingest_session_files_stats_latest (view) Content](console/content/view/ur_ingest_session_files_stats_latest.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_files_stats_latest" AS
SELECT iss.*
FROM ur_ingest_session_files_stats AS iss
JOIN ( SELECT ur_ingest_session.ur_ingest_session_id AS latest_session_id
FROM ur_ingest_session
ORDER BY ur_ingest_session.ingest_finished_at DESC
LIMIT 1) AS latest
ON iss.ingest_session_id = latest.latest_session_id |
| ur_ingest_session_files_stats_latest |
max_file_size_bytes |
|
/console/info-schema/view.sql?name=ur_ingest_session_files_stats_latest&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_files_stats_latest&stats=yes) |
[ur_ingest_session_files_stats_latest (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_files_stats_latest&stats=yes) |
/console/content/view/ur_ingest_session_files_stats_latest.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_files_stats_latest.sql?stats=yes) |
[ur_ingest_session_files_stats_latest (view) Content](console/content/view/ur_ingest_session_files_stats_latest.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_files_stats_latest" AS
SELECT iss.*
FROM ur_ingest_session_files_stats AS iss
JOIN ( SELECT ur_ingest_session.ur_ingest_session_id AS latest_session_id
FROM ur_ingest_session
ORDER BY ur_ingest_session.ingest_finished_at DESC
LIMIT 1) AS latest
ON iss.ingest_session_id = latest.latest_session_id |
| ur_ingest_session_files_stats_latest |
oldest_file_last_modified_datetime |
|
/console/info-schema/view.sql?name=ur_ingest_session_files_stats_latest&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_files_stats_latest&stats=yes) |
[ur_ingest_session_files_stats_latest (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_files_stats_latest&stats=yes) |
/console/content/view/ur_ingest_session_files_stats_latest.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_files_stats_latest.sql?stats=yes) |
[ur_ingest_session_files_stats_latest (view) Content](console/content/view/ur_ingest_session_files_stats_latest.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_files_stats_latest" AS
SELECT iss.*
FROM ur_ingest_session_files_stats AS iss
JOIN ( SELECT ur_ingest_session.ur_ingest_session_id AS latest_session_id
FROM ur_ingest_session
ORDER BY ur_ingest_session.ingest_finished_at DESC
LIMIT 1) AS latest
ON iss.ingest_session_id = latest.latest_session_id |
| ur_ingest_session_files_stats_latest |
youngest_file_last_modified_datetime |
|
/console/info-schema/view.sql?name=ur_ingest_session_files_stats_latest&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_files_stats_latest&stats=yes) |
[ur_ingest_session_files_stats_latest (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_files_stats_latest&stats=yes) |
/console/content/view/ur_ingest_session_files_stats_latest.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_files_stats_latest.sql?stats=yes) |
[ur_ingest_session_files_stats_latest (view) Content](console/content/view/ur_ingest_session_files_stats_latest.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_files_stats_latest" AS
SELECT iss.*
FROM ur_ingest_session_files_stats AS iss
JOIN ( SELECT ur_ingest_session.ur_ingest_session_id AS latest_session_id
FROM ur_ingest_session
ORDER BY ur_ingest_session.ingest_finished_at DESC
LIMIT 1) AS latest
ON iss.ingest_session_id = latest.latest_session_id |
| ur_ingest_session_tasks_stats |
device_id |
VARCHAR |
/console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes) |
[ur_ingest_session_tasks_stats (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes) |
/console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes) |
[ur_ingest_session_tasks_stats (view) Content](console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_tasks_stats" AS
WITH Summary AS (
SELECT
device.device_id AS device_id,
ur_ingest_session.ur_ingest_session_id AS ingest_session_id,
ur_ingest_session.ingest_started_at AS ingest_session_started_at,
ur_ingest_session.ingest_finished_at AS ingest_session_finished_at,
COALESCE(ur_ingest_session_task.ur_status, 'Ok') AS ur_status,
COALESCE(uniform_resource.nature, 'UNKNOWN') AS nature,
COUNT(ur_ingest_session_task.uniform_resource_id) AS total_file_count,
SUM(CASE WHEN uniform_resource.content IS NOT NULL THEN 1 ELSE 0 END) AS file_count_with_content,
SUM(CASE WHEN uniform_resource.frontmatter IS NOT NULL THEN 1 ELSE 0 END) AS file_count_with_frontmatter,
MIN(uniform_resource.size_bytes) AS min_file_size_bytes,
AVG(uniform_resource.size_bytes) AS average_file_size_bytes,
MAX(uniform_resource.size_bytes) AS max_file_size_bytes,
MIN(uniform_resource.last_modified_at) AS oldest_file_last_modified_datetime,
MAX(uniform_resource.last_modified_at) AS youngest_file_last_modified_datetime
FROM
ur_ingest_session
JOIN
device ON ur_ingest_session.device_id = device.device_id
LEFT JOIN
ur_ingest_session_task ON ur_ingest_session.ur_ingest_session_id = ur_ingest_session_task.ingest_session_id
LEFT JOIN
uniform_resource ON ur_ingest_session_task.uniform_resource_id = uniform_resource.uniform_resource_id
GROUP BY
device.device_id,
ur_ingest_session.ur_ingest_session_id,
ur_ingest_session.ingest_started_at,
ur_ingest_session.ingest_finished_at,
ur_ingest_session_task.captured_executable
)
SELECT
device_id,
ingest_session_id,
ingest_session_started_at,
ingest_session_finished_at,
ur_status,
nature,
total_file_count,
file_count_with_content,
file_count_with_frontmatter,
min_file_size_bytes,
CAST(ROUND(average_file_size_bytes) AS INTEGER) AS average_file_size_bytes,
max_file_size_bytes,
oldest_file_last_modified_datetime,
youngest_file_last_modified_datetime
FROM
Summary
ORDER BY
device_id,
ingest_session_finished_at,
ur_status |
| ur_ingest_session_tasks_stats |
ingest_session_id |
VARCHAR |
/console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes) |
[ur_ingest_session_tasks_stats (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes) |
/console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes) |
[ur_ingest_session_tasks_stats (view) Content](console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_tasks_stats" AS
WITH Summary AS (
SELECT
device.device_id AS device_id,
ur_ingest_session.ur_ingest_session_id AS ingest_session_id,
ur_ingest_session.ingest_started_at AS ingest_session_started_at,
ur_ingest_session.ingest_finished_at AS ingest_session_finished_at,
COALESCE(ur_ingest_session_task.ur_status, 'Ok') AS ur_status,
COALESCE(uniform_resource.nature, 'UNKNOWN') AS nature,
COUNT(ur_ingest_session_task.uniform_resource_id) AS total_file_count,
SUM(CASE WHEN uniform_resource.content IS NOT NULL THEN 1 ELSE 0 END) AS file_count_with_content,
SUM(CASE WHEN uniform_resource.frontmatter IS NOT NULL THEN 1 ELSE 0 END) AS file_count_with_frontmatter,
MIN(uniform_resource.size_bytes) AS min_file_size_bytes,
AVG(uniform_resource.size_bytes) AS average_file_size_bytes,
MAX(uniform_resource.size_bytes) AS max_file_size_bytes,
MIN(uniform_resource.last_modified_at) AS oldest_file_last_modified_datetime,
MAX(uniform_resource.last_modified_at) AS youngest_file_last_modified_datetime
FROM
ur_ingest_session
JOIN
device ON ur_ingest_session.device_id = device.device_id
LEFT JOIN
ur_ingest_session_task ON ur_ingest_session.ur_ingest_session_id = ur_ingest_session_task.ingest_session_id
LEFT JOIN
uniform_resource ON ur_ingest_session_task.uniform_resource_id = uniform_resource.uniform_resource_id
GROUP BY
device.device_id,
ur_ingest_session.ur_ingest_session_id,
ur_ingest_session.ingest_started_at,
ur_ingest_session.ingest_finished_at,
ur_ingest_session_task.captured_executable
)
SELECT
device_id,
ingest_session_id,
ingest_session_started_at,
ingest_session_finished_at,
ur_status,
nature,
total_file_count,
file_count_with_content,
file_count_with_frontmatter,
min_file_size_bytes,
CAST(ROUND(average_file_size_bytes) AS INTEGER) AS average_file_size_bytes,
max_file_size_bytes,
oldest_file_last_modified_datetime,
youngest_file_last_modified_datetime
FROM
Summary
ORDER BY
device_id,
ingest_session_finished_at,
ur_status |
| ur_ingest_session_tasks_stats |
ingest_session_started_at |
TIMESTAMPTZ |
/console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes) |
[ur_ingest_session_tasks_stats (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes) |
/console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes) |
[ur_ingest_session_tasks_stats (view) Content](console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_tasks_stats" AS
WITH Summary AS (
SELECT
device.device_id AS device_id,
ur_ingest_session.ur_ingest_session_id AS ingest_session_id,
ur_ingest_session.ingest_started_at AS ingest_session_started_at,
ur_ingest_session.ingest_finished_at AS ingest_session_finished_at,
COALESCE(ur_ingest_session_task.ur_status, 'Ok') AS ur_status,
COALESCE(uniform_resource.nature, 'UNKNOWN') AS nature,
COUNT(ur_ingest_session_task.uniform_resource_id) AS total_file_count,
SUM(CASE WHEN uniform_resource.content IS NOT NULL THEN 1 ELSE 0 END) AS file_count_with_content,
SUM(CASE WHEN uniform_resource.frontmatter IS NOT NULL THEN 1 ELSE 0 END) AS file_count_with_frontmatter,
MIN(uniform_resource.size_bytes) AS min_file_size_bytes,
AVG(uniform_resource.size_bytes) AS average_file_size_bytes,
MAX(uniform_resource.size_bytes) AS max_file_size_bytes,
MIN(uniform_resource.last_modified_at) AS oldest_file_last_modified_datetime,
MAX(uniform_resource.last_modified_at) AS youngest_file_last_modified_datetime
FROM
ur_ingest_session
JOIN
device ON ur_ingest_session.device_id = device.device_id
LEFT JOIN
ur_ingest_session_task ON ur_ingest_session.ur_ingest_session_id = ur_ingest_session_task.ingest_session_id
LEFT JOIN
uniform_resource ON ur_ingest_session_task.uniform_resource_id = uniform_resource.uniform_resource_id
GROUP BY
device.device_id,
ur_ingest_session.ur_ingest_session_id,
ur_ingest_session.ingest_started_at,
ur_ingest_session.ingest_finished_at,
ur_ingest_session_task.captured_executable
)
SELECT
device_id,
ingest_session_id,
ingest_session_started_at,
ingest_session_finished_at,
ur_status,
nature,
total_file_count,
file_count_with_content,
file_count_with_frontmatter,
min_file_size_bytes,
CAST(ROUND(average_file_size_bytes) AS INTEGER) AS average_file_size_bytes,
max_file_size_bytes,
oldest_file_last_modified_datetime,
youngest_file_last_modified_datetime
FROM
Summary
ORDER BY
device_id,
ingest_session_finished_at,
ur_status |
| ur_ingest_session_tasks_stats |
ingest_session_finished_at |
TIMESTAMPTZ |
/console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes) |
[ur_ingest_session_tasks_stats (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes) |
/console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes) |
[ur_ingest_session_tasks_stats (view) Content](console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_tasks_stats" AS
WITH Summary AS (
SELECT
device.device_id AS device_id,
ur_ingest_session.ur_ingest_session_id AS ingest_session_id,
ur_ingest_session.ingest_started_at AS ingest_session_started_at,
ur_ingest_session.ingest_finished_at AS ingest_session_finished_at,
COALESCE(ur_ingest_session_task.ur_status, 'Ok') AS ur_status,
COALESCE(uniform_resource.nature, 'UNKNOWN') AS nature,
COUNT(ur_ingest_session_task.uniform_resource_id) AS total_file_count,
SUM(CASE WHEN uniform_resource.content IS NOT NULL THEN 1 ELSE 0 END) AS file_count_with_content,
SUM(CASE WHEN uniform_resource.frontmatter IS NOT NULL THEN 1 ELSE 0 END) AS file_count_with_frontmatter,
MIN(uniform_resource.size_bytes) AS min_file_size_bytes,
AVG(uniform_resource.size_bytes) AS average_file_size_bytes,
MAX(uniform_resource.size_bytes) AS max_file_size_bytes,
MIN(uniform_resource.last_modified_at) AS oldest_file_last_modified_datetime,
MAX(uniform_resource.last_modified_at) AS youngest_file_last_modified_datetime
FROM
ur_ingest_session
JOIN
device ON ur_ingest_session.device_id = device.device_id
LEFT JOIN
ur_ingest_session_task ON ur_ingest_session.ur_ingest_session_id = ur_ingest_session_task.ingest_session_id
LEFT JOIN
uniform_resource ON ur_ingest_session_task.uniform_resource_id = uniform_resource.uniform_resource_id
GROUP BY
device.device_id,
ur_ingest_session.ur_ingest_session_id,
ur_ingest_session.ingest_started_at,
ur_ingest_session.ingest_finished_at,
ur_ingest_session_task.captured_executable
)
SELECT
device_id,
ingest_session_id,
ingest_session_started_at,
ingest_session_finished_at,
ur_status,
nature,
total_file_count,
file_count_with_content,
file_count_with_frontmatter,
min_file_size_bytes,
CAST(ROUND(average_file_size_bytes) AS INTEGER) AS average_file_size_bytes,
max_file_size_bytes,
oldest_file_last_modified_datetime,
youngest_file_last_modified_datetime
FROM
Summary
ORDER BY
device_id,
ingest_session_finished_at,
ur_status |
| ur_ingest_session_tasks_stats |
ur_status |
|
/console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes) |
[ur_ingest_session_tasks_stats (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes) |
/console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes) |
[ur_ingest_session_tasks_stats (view) Content](console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_tasks_stats" AS
WITH Summary AS (
SELECT
device.device_id AS device_id,
ur_ingest_session.ur_ingest_session_id AS ingest_session_id,
ur_ingest_session.ingest_started_at AS ingest_session_started_at,
ur_ingest_session.ingest_finished_at AS ingest_session_finished_at,
COALESCE(ur_ingest_session_task.ur_status, 'Ok') AS ur_status,
COALESCE(uniform_resource.nature, 'UNKNOWN') AS nature,
COUNT(ur_ingest_session_task.uniform_resource_id) AS total_file_count,
SUM(CASE WHEN uniform_resource.content IS NOT NULL THEN 1 ELSE 0 END) AS file_count_with_content,
SUM(CASE WHEN uniform_resource.frontmatter IS NOT NULL THEN 1 ELSE 0 END) AS file_count_with_frontmatter,
MIN(uniform_resource.size_bytes) AS min_file_size_bytes,
AVG(uniform_resource.size_bytes) AS average_file_size_bytes,
MAX(uniform_resource.size_bytes) AS max_file_size_bytes,
MIN(uniform_resource.last_modified_at) AS oldest_file_last_modified_datetime,
MAX(uniform_resource.last_modified_at) AS youngest_file_last_modified_datetime
FROM
ur_ingest_session
JOIN
device ON ur_ingest_session.device_id = device.device_id
LEFT JOIN
ur_ingest_session_task ON ur_ingest_session.ur_ingest_session_id = ur_ingest_session_task.ingest_session_id
LEFT JOIN
uniform_resource ON ur_ingest_session_task.uniform_resource_id = uniform_resource.uniform_resource_id
GROUP BY
device.device_id,
ur_ingest_session.ur_ingest_session_id,
ur_ingest_session.ingest_started_at,
ur_ingest_session.ingest_finished_at,
ur_ingest_session_task.captured_executable
)
SELECT
device_id,
ingest_session_id,
ingest_session_started_at,
ingest_session_finished_at,
ur_status,
nature,
total_file_count,
file_count_with_content,
file_count_with_frontmatter,
min_file_size_bytes,
CAST(ROUND(average_file_size_bytes) AS INTEGER) AS average_file_size_bytes,
max_file_size_bytes,
oldest_file_last_modified_datetime,
youngest_file_last_modified_datetime
FROM
Summary
ORDER BY
device_id,
ingest_session_finished_at,
ur_status |
| ur_ingest_session_tasks_stats |
nature |
|
/console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes) |
[ur_ingest_session_tasks_stats (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes) |
/console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes) |
[ur_ingest_session_tasks_stats (view) Content](console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_tasks_stats" AS
WITH Summary AS (
SELECT
device.device_id AS device_id,
ur_ingest_session.ur_ingest_session_id AS ingest_session_id,
ur_ingest_session.ingest_started_at AS ingest_session_started_at,
ur_ingest_session.ingest_finished_at AS ingest_session_finished_at,
COALESCE(ur_ingest_session_task.ur_status, 'Ok') AS ur_status,
COALESCE(uniform_resource.nature, 'UNKNOWN') AS nature,
COUNT(ur_ingest_session_task.uniform_resource_id) AS total_file_count,
SUM(CASE WHEN uniform_resource.content IS NOT NULL THEN 1 ELSE 0 END) AS file_count_with_content,
SUM(CASE WHEN uniform_resource.frontmatter IS NOT NULL THEN 1 ELSE 0 END) AS file_count_with_frontmatter,
MIN(uniform_resource.size_bytes) AS min_file_size_bytes,
AVG(uniform_resource.size_bytes) AS average_file_size_bytes,
MAX(uniform_resource.size_bytes) AS max_file_size_bytes,
MIN(uniform_resource.last_modified_at) AS oldest_file_last_modified_datetime,
MAX(uniform_resource.last_modified_at) AS youngest_file_last_modified_datetime
FROM
ur_ingest_session
JOIN
device ON ur_ingest_session.device_id = device.device_id
LEFT JOIN
ur_ingest_session_task ON ur_ingest_session.ur_ingest_session_id = ur_ingest_session_task.ingest_session_id
LEFT JOIN
uniform_resource ON ur_ingest_session_task.uniform_resource_id = uniform_resource.uniform_resource_id
GROUP BY
device.device_id,
ur_ingest_session.ur_ingest_session_id,
ur_ingest_session.ingest_started_at,
ur_ingest_session.ingest_finished_at,
ur_ingest_session_task.captured_executable
)
SELECT
device_id,
ingest_session_id,
ingest_session_started_at,
ingest_session_finished_at,
ur_status,
nature,
total_file_count,
file_count_with_content,
file_count_with_frontmatter,
min_file_size_bytes,
CAST(ROUND(average_file_size_bytes) AS INTEGER) AS average_file_size_bytes,
max_file_size_bytes,
oldest_file_last_modified_datetime,
youngest_file_last_modified_datetime
FROM
Summary
ORDER BY
device_id,
ingest_session_finished_at,
ur_status |
| ur_ingest_session_tasks_stats |
total_file_count |
|
/console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes) |
[ur_ingest_session_tasks_stats (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes) |
/console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes) |
[ur_ingest_session_tasks_stats (view) Content](console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_tasks_stats" AS
WITH Summary AS (
SELECT
device.device_id AS device_id,
ur_ingest_session.ur_ingest_session_id AS ingest_session_id,
ur_ingest_session.ingest_started_at AS ingest_session_started_at,
ur_ingest_session.ingest_finished_at AS ingest_session_finished_at,
COALESCE(ur_ingest_session_task.ur_status, 'Ok') AS ur_status,
COALESCE(uniform_resource.nature, 'UNKNOWN') AS nature,
COUNT(ur_ingest_session_task.uniform_resource_id) AS total_file_count,
SUM(CASE WHEN uniform_resource.content IS NOT NULL THEN 1 ELSE 0 END) AS file_count_with_content,
SUM(CASE WHEN uniform_resource.frontmatter IS NOT NULL THEN 1 ELSE 0 END) AS file_count_with_frontmatter,
MIN(uniform_resource.size_bytes) AS min_file_size_bytes,
AVG(uniform_resource.size_bytes) AS average_file_size_bytes,
MAX(uniform_resource.size_bytes) AS max_file_size_bytes,
MIN(uniform_resource.last_modified_at) AS oldest_file_last_modified_datetime,
MAX(uniform_resource.last_modified_at) AS youngest_file_last_modified_datetime
FROM
ur_ingest_session
JOIN
device ON ur_ingest_session.device_id = device.device_id
LEFT JOIN
ur_ingest_session_task ON ur_ingest_session.ur_ingest_session_id = ur_ingest_session_task.ingest_session_id
LEFT JOIN
uniform_resource ON ur_ingest_session_task.uniform_resource_id = uniform_resource.uniform_resource_id
GROUP BY
device.device_id,
ur_ingest_session.ur_ingest_session_id,
ur_ingest_session.ingest_started_at,
ur_ingest_session.ingest_finished_at,
ur_ingest_session_task.captured_executable
)
SELECT
device_id,
ingest_session_id,
ingest_session_started_at,
ingest_session_finished_at,
ur_status,
nature,
total_file_count,
file_count_with_content,
file_count_with_frontmatter,
min_file_size_bytes,
CAST(ROUND(average_file_size_bytes) AS INTEGER) AS average_file_size_bytes,
max_file_size_bytes,
oldest_file_last_modified_datetime,
youngest_file_last_modified_datetime
FROM
Summary
ORDER BY
device_id,
ingest_session_finished_at,
ur_status |
| ur_ingest_session_tasks_stats |
file_count_with_content |
|
/console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes) |
[ur_ingest_session_tasks_stats (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes) |
/console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes) |
[ur_ingest_session_tasks_stats (view) Content](console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_tasks_stats" AS
WITH Summary AS (
SELECT
device.device_id AS device_id,
ur_ingest_session.ur_ingest_session_id AS ingest_session_id,
ur_ingest_session.ingest_started_at AS ingest_session_started_at,
ur_ingest_session.ingest_finished_at AS ingest_session_finished_at,
COALESCE(ur_ingest_session_task.ur_status, 'Ok') AS ur_status,
COALESCE(uniform_resource.nature, 'UNKNOWN') AS nature,
COUNT(ur_ingest_session_task.uniform_resource_id) AS total_file_count,
SUM(CASE WHEN uniform_resource.content IS NOT NULL THEN 1 ELSE 0 END) AS file_count_with_content,
SUM(CASE WHEN uniform_resource.frontmatter IS NOT NULL THEN 1 ELSE 0 END) AS file_count_with_frontmatter,
MIN(uniform_resource.size_bytes) AS min_file_size_bytes,
AVG(uniform_resource.size_bytes) AS average_file_size_bytes,
MAX(uniform_resource.size_bytes) AS max_file_size_bytes,
MIN(uniform_resource.last_modified_at) AS oldest_file_last_modified_datetime,
MAX(uniform_resource.last_modified_at) AS youngest_file_last_modified_datetime
FROM
ur_ingest_session
JOIN
device ON ur_ingest_session.device_id = device.device_id
LEFT JOIN
ur_ingest_session_task ON ur_ingest_session.ur_ingest_session_id = ur_ingest_session_task.ingest_session_id
LEFT JOIN
uniform_resource ON ur_ingest_session_task.uniform_resource_id = uniform_resource.uniform_resource_id
GROUP BY
device.device_id,
ur_ingest_session.ur_ingest_session_id,
ur_ingest_session.ingest_started_at,
ur_ingest_session.ingest_finished_at,
ur_ingest_session_task.captured_executable
)
SELECT
device_id,
ingest_session_id,
ingest_session_started_at,
ingest_session_finished_at,
ur_status,
nature,
total_file_count,
file_count_with_content,
file_count_with_frontmatter,
min_file_size_bytes,
CAST(ROUND(average_file_size_bytes) AS INTEGER) AS average_file_size_bytes,
max_file_size_bytes,
oldest_file_last_modified_datetime,
youngest_file_last_modified_datetime
FROM
Summary
ORDER BY
device_id,
ingest_session_finished_at,
ur_status |
| ur_ingest_session_tasks_stats |
file_count_with_frontmatter |
|
/console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes) |
[ur_ingest_session_tasks_stats (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes) |
/console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes) |
[ur_ingest_session_tasks_stats (view) Content](console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_tasks_stats" AS
WITH Summary AS (
SELECT
device.device_id AS device_id,
ur_ingest_session.ur_ingest_session_id AS ingest_session_id,
ur_ingest_session.ingest_started_at AS ingest_session_started_at,
ur_ingest_session.ingest_finished_at AS ingest_session_finished_at,
COALESCE(ur_ingest_session_task.ur_status, 'Ok') AS ur_status,
COALESCE(uniform_resource.nature, 'UNKNOWN') AS nature,
COUNT(ur_ingest_session_task.uniform_resource_id) AS total_file_count,
SUM(CASE WHEN uniform_resource.content IS NOT NULL THEN 1 ELSE 0 END) AS file_count_with_content,
SUM(CASE WHEN uniform_resource.frontmatter IS NOT NULL THEN 1 ELSE 0 END) AS file_count_with_frontmatter,
MIN(uniform_resource.size_bytes) AS min_file_size_bytes,
AVG(uniform_resource.size_bytes) AS average_file_size_bytes,
MAX(uniform_resource.size_bytes) AS max_file_size_bytes,
MIN(uniform_resource.last_modified_at) AS oldest_file_last_modified_datetime,
MAX(uniform_resource.last_modified_at) AS youngest_file_last_modified_datetime
FROM
ur_ingest_session
JOIN
device ON ur_ingest_session.device_id = device.device_id
LEFT JOIN
ur_ingest_session_task ON ur_ingest_session.ur_ingest_session_id = ur_ingest_session_task.ingest_session_id
LEFT JOIN
uniform_resource ON ur_ingest_session_task.uniform_resource_id = uniform_resource.uniform_resource_id
GROUP BY
device.device_id,
ur_ingest_session.ur_ingest_session_id,
ur_ingest_session.ingest_started_at,
ur_ingest_session.ingest_finished_at,
ur_ingest_session_task.captured_executable
)
SELECT
device_id,
ingest_session_id,
ingest_session_started_at,
ingest_session_finished_at,
ur_status,
nature,
total_file_count,
file_count_with_content,
file_count_with_frontmatter,
min_file_size_bytes,
CAST(ROUND(average_file_size_bytes) AS INTEGER) AS average_file_size_bytes,
max_file_size_bytes,
oldest_file_last_modified_datetime,
youngest_file_last_modified_datetime
FROM
Summary
ORDER BY
device_id,
ingest_session_finished_at,
ur_status |
| ur_ingest_session_tasks_stats |
min_file_size_bytes |
|
/console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes) |
[ur_ingest_session_tasks_stats (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes) |
/console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes) |
[ur_ingest_session_tasks_stats (view) Content](console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_tasks_stats" AS
WITH Summary AS (
SELECT
device.device_id AS device_id,
ur_ingest_session.ur_ingest_session_id AS ingest_session_id,
ur_ingest_session.ingest_started_at AS ingest_session_started_at,
ur_ingest_session.ingest_finished_at AS ingest_session_finished_at,
COALESCE(ur_ingest_session_task.ur_status, 'Ok') AS ur_status,
COALESCE(uniform_resource.nature, 'UNKNOWN') AS nature,
COUNT(ur_ingest_session_task.uniform_resource_id) AS total_file_count,
SUM(CASE WHEN uniform_resource.content IS NOT NULL THEN 1 ELSE 0 END) AS file_count_with_content,
SUM(CASE WHEN uniform_resource.frontmatter IS NOT NULL THEN 1 ELSE 0 END) AS file_count_with_frontmatter,
MIN(uniform_resource.size_bytes) AS min_file_size_bytes,
AVG(uniform_resource.size_bytes) AS average_file_size_bytes,
MAX(uniform_resource.size_bytes) AS max_file_size_bytes,
MIN(uniform_resource.last_modified_at) AS oldest_file_last_modified_datetime,
MAX(uniform_resource.last_modified_at) AS youngest_file_last_modified_datetime
FROM
ur_ingest_session
JOIN
device ON ur_ingest_session.device_id = device.device_id
LEFT JOIN
ur_ingest_session_task ON ur_ingest_session.ur_ingest_session_id = ur_ingest_session_task.ingest_session_id
LEFT JOIN
uniform_resource ON ur_ingest_session_task.uniform_resource_id = uniform_resource.uniform_resource_id
GROUP BY
device.device_id,
ur_ingest_session.ur_ingest_session_id,
ur_ingest_session.ingest_started_at,
ur_ingest_session.ingest_finished_at,
ur_ingest_session_task.captured_executable
)
SELECT
device_id,
ingest_session_id,
ingest_session_started_at,
ingest_session_finished_at,
ur_status,
nature,
total_file_count,
file_count_with_content,
file_count_with_frontmatter,
min_file_size_bytes,
CAST(ROUND(average_file_size_bytes) AS INTEGER) AS average_file_size_bytes,
max_file_size_bytes,
oldest_file_last_modified_datetime,
youngest_file_last_modified_datetime
FROM
Summary
ORDER BY
device_id,
ingest_session_finished_at,
ur_status |
| ur_ingest_session_tasks_stats |
average_file_size_bytes |
INT |
/console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes) |
[ur_ingest_session_tasks_stats (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes) |
/console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes) |
[ur_ingest_session_tasks_stats (view) Content](console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_tasks_stats" AS
WITH Summary AS (
SELECT
device.device_id AS device_id,
ur_ingest_session.ur_ingest_session_id AS ingest_session_id,
ur_ingest_session.ingest_started_at AS ingest_session_started_at,
ur_ingest_session.ingest_finished_at AS ingest_session_finished_at,
COALESCE(ur_ingest_session_task.ur_status, 'Ok') AS ur_status,
COALESCE(uniform_resource.nature, 'UNKNOWN') AS nature,
COUNT(ur_ingest_session_task.uniform_resource_id) AS total_file_count,
SUM(CASE WHEN uniform_resource.content IS NOT NULL THEN 1 ELSE 0 END) AS file_count_with_content,
SUM(CASE WHEN uniform_resource.frontmatter IS NOT NULL THEN 1 ELSE 0 END) AS file_count_with_frontmatter,
MIN(uniform_resource.size_bytes) AS min_file_size_bytes,
AVG(uniform_resource.size_bytes) AS average_file_size_bytes,
MAX(uniform_resource.size_bytes) AS max_file_size_bytes,
MIN(uniform_resource.last_modified_at) AS oldest_file_last_modified_datetime,
MAX(uniform_resource.last_modified_at) AS youngest_file_last_modified_datetime
FROM
ur_ingest_session
JOIN
device ON ur_ingest_session.device_id = device.device_id
LEFT JOIN
ur_ingest_session_task ON ur_ingest_session.ur_ingest_session_id = ur_ingest_session_task.ingest_session_id
LEFT JOIN
uniform_resource ON ur_ingest_session_task.uniform_resource_id = uniform_resource.uniform_resource_id
GROUP BY
device.device_id,
ur_ingest_session.ur_ingest_session_id,
ur_ingest_session.ingest_started_at,
ur_ingest_session.ingest_finished_at,
ur_ingest_session_task.captured_executable
)
SELECT
device_id,
ingest_session_id,
ingest_session_started_at,
ingest_session_finished_at,
ur_status,
nature,
total_file_count,
file_count_with_content,
file_count_with_frontmatter,
min_file_size_bytes,
CAST(ROUND(average_file_size_bytes) AS INTEGER) AS average_file_size_bytes,
max_file_size_bytes,
oldest_file_last_modified_datetime,
youngest_file_last_modified_datetime
FROM
Summary
ORDER BY
device_id,
ingest_session_finished_at,
ur_status |
| ur_ingest_session_tasks_stats |
max_file_size_bytes |
|
/console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes) |
[ur_ingest_session_tasks_stats (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes) |
/console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes) |
[ur_ingest_session_tasks_stats (view) Content](console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_tasks_stats" AS
WITH Summary AS (
SELECT
device.device_id AS device_id,
ur_ingest_session.ur_ingest_session_id AS ingest_session_id,
ur_ingest_session.ingest_started_at AS ingest_session_started_at,
ur_ingest_session.ingest_finished_at AS ingest_session_finished_at,
COALESCE(ur_ingest_session_task.ur_status, 'Ok') AS ur_status,
COALESCE(uniform_resource.nature, 'UNKNOWN') AS nature,
COUNT(ur_ingest_session_task.uniform_resource_id) AS total_file_count,
SUM(CASE WHEN uniform_resource.content IS NOT NULL THEN 1 ELSE 0 END) AS file_count_with_content,
SUM(CASE WHEN uniform_resource.frontmatter IS NOT NULL THEN 1 ELSE 0 END) AS file_count_with_frontmatter,
MIN(uniform_resource.size_bytes) AS min_file_size_bytes,
AVG(uniform_resource.size_bytes) AS average_file_size_bytes,
MAX(uniform_resource.size_bytes) AS max_file_size_bytes,
MIN(uniform_resource.last_modified_at) AS oldest_file_last_modified_datetime,
MAX(uniform_resource.last_modified_at) AS youngest_file_last_modified_datetime
FROM
ur_ingest_session
JOIN
device ON ur_ingest_session.device_id = device.device_id
LEFT JOIN
ur_ingest_session_task ON ur_ingest_session.ur_ingest_session_id = ur_ingest_session_task.ingest_session_id
LEFT JOIN
uniform_resource ON ur_ingest_session_task.uniform_resource_id = uniform_resource.uniform_resource_id
GROUP BY
device.device_id,
ur_ingest_session.ur_ingest_session_id,
ur_ingest_session.ingest_started_at,
ur_ingest_session.ingest_finished_at,
ur_ingest_session_task.captured_executable
)
SELECT
device_id,
ingest_session_id,
ingest_session_started_at,
ingest_session_finished_at,
ur_status,
nature,
total_file_count,
file_count_with_content,
file_count_with_frontmatter,
min_file_size_bytes,
CAST(ROUND(average_file_size_bytes) AS INTEGER) AS average_file_size_bytes,
max_file_size_bytes,
oldest_file_last_modified_datetime,
youngest_file_last_modified_datetime
FROM
Summary
ORDER BY
device_id,
ingest_session_finished_at,
ur_status |
| ur_ingest_session_tasks_stats |
oldest_file_last_modified_datetime |
|
/console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes) |
[ur_ingest_session_tasks_stats (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes) |
/console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes) |
[ur_ingest_session_tasks_stats (view) Content](console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_tasks_stats" AS
WITH Summary AS (
SELECT
device.device_id AS device_id,
ur_ingest_session.ur_ingest_session_id AS ingest_session_id,
ur_ingest_session.ingest_started_at AS ingest_session_started_at,
ur_ingest_session.ingest_finished_at AS ingest_session_finished_at,
COALESCE(ur_ingest_session_task.ur_status, 'Ok') AS ur_status,
COALESCE(uniform_resource.nature, 'UNKNOWN') AS nature,
COUNT(ur_ingest_session_task.uniform_resource_id) AS total_file_count,
SUM(CASE WHEN uniform_resource.content IS NOT NULL THEN 1 ELSE 0 END) AS file_count_with_content,
SUM(CASE WHEN uniform_resource.frontmatter IS NOT NULL THEN 1 ELSE 0 END) AS file_count_with_frontmatter,
MIN(uniform_resource.size_bytes) AS min_file_size_bytes,
AVG(uniform_resource.size_bytes) AS average_file_size_bytes,
MAX(uniform_resource.size_bytes) AS max_file_size_bytes,
MIN(uniform_resource.last_modified_at) AS oldest_file_last_modified_datetime,
MAX(uniform_resource.last_modified_at) AS youngest_file_last_modified_datetime
FROM
ur_ingest_session
JOIN
device ON ur_ingest_session.device_id = device.device_id
LEFT JOIN
ur_ingest_session_task ON ur_ingest_session.ur_ingest_session_id = ur_ingest_session_task.ingest_session_id
LEFT JOIN
uniform_resource ON ur_ingest_session_task.uniform_resource_id = uniform_resource.uniform_resource_id
GROUP BY
device.device_id,
ur_ingest_session.ur_ingest_session_id,
ur_ingest_session.ingest_started_at,
ur_ingest_session.ingest_finished_at,
ur_ingest_session_task.captured_executable
)
SELECT
device_id,
ingest_session_id,
ingest_session_started_at,
ingest_session_finished_at,
ur_status,
nature,
total_file_count,
file_count_with_content,
file_count_with_frontmatter,
min_file_size_bytes,
CAST(ROUND(average_file_size_bytes) AS INTEGER) AS average_file_size_bytes,
max_file_size_bytes,
oldest_file_last_modified_datetime,
youngest_file_last_modified_datetime
FROM
Summary
ORDER BY
device_id,
ingest_session_finished_at,
ur_status |
| ur_ingest_session_tasks_stats |
youngest_file_last_modified_datetime |
|
/console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes) |
[ur_ingest_session_tasks_stats (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes) |
/console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes) |
[ur_ingest_session_tasks_stats (view) Content](console/content/view/ur_ingest_session_tasks_stats.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_tasks_stats" AS
WITH Summary AS (
SELECT
device.device_id AS device_id,
ur_ingest_session.ur_ingest_session_id AS ingest_session_id,
ur_ingest_session.ingest_started_at AS ingest_session_started_at,
ur_ingest_session.ingest_finished_at AS ingest_session_finished_at,
COALESCE(ur_ingest_session_task.ur_status, 'Ok') AS ur_status,
COALESCE(uniform_resource.nature, 'UNKNOWN') AS nature,
COUNT(ur_ingest_session_task.uniform_resource_id) AS total_file_count,
SUM(CASE WHEN uniform_resource.content IS NOT NULL THEN 1 ELSE 0 END) AS file_count_with_content,
SUM(CASE WHEN uniform_resource.frontmatter IS NOT NULL THEN 1 ELSE 0 END) AS file_count_with_frontmatter,
MIN(uniform_resource.size_bytes) AS min_file_size_bytes,
AVG(uniform_resource.size_bytes) AS average_file_size_bytes,
MAX(uniform_resource.size_bytes) AS max_file_size_bytes,
MIN(uniform_resource.last_modified_at) AS oldest_file_last_modified_datetime,
MAX(uniform_resource.last_modified_at) AS youngest_file_last_modified_datetime
FROM
ur_ingest_session
JOIN
device ON ur_ingest_session.device_id = device.device_id
LEFT JOIN
ur_ingest_session_task ON ur_ingest_session.ur_ingest_session_id = ur_ingest_session_task.ingest_session_id
LEFT JOIN
uniform_resource ON ur_ingest_session_task.uniform_resource_id = uniform_resource.uniform_resource_id
GROUP BY
device.device_id,
ur_ingest_session.ur_ingest_session_id,
ur_ingest_session.ingest_started_at,
ur_ingest_session.ingest_finished_at,
ur_ingest_session_task.captured_executable
)
SELECT
device_id,
ingest_session_id,
ingest_session_started_at,
ingest_session_finished_at,
ur_status,
nature,
total_file_count,
file_count_with_content,
file_count_with_frontmatter,
min_file_size_bytes,
CAST(ROUND(average_file_size_bytes) AS INTEGER) AS average_file_size_bytes,
max_file_size_bytes,
oldest_file_last_modified_datetime,
youngest_file_last_modified_datetime
FROM
Summary
ORDER BY
device_id,
ingest_session_finished_at,
ur_status |
| ur_ingest_session_tasks_stats_latest |
device_id |
VARCHAR |
/console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes) |
[ur_ingest_session_tasks_stats_latest (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes) |
/console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes) |
[ur_ingest_session_tasks_stats_latest (view) Content](console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_tasks_stats_latest" AS
SELECT iss.*
FROM ur_ingest_session_tasks_stats AS iss
JOIN ( SELECT ur_ingest_session.ur_ingest_session_id AS latest_session_id
FROM ur_ingest_session
ORDER BY ur_ingest_session.ingest_finished_at DESC
LIMIT 1) AS latest
ON iss.ingest_session_id = latest.latest_session_id |
| ur_ingest_session_tasks_stats_latest |
ingest_session_id |
VARCHAR |
/console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes) |
[ur_ingest_session_tasks_stats_latest (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes) |
/console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes) |
[ur_ingest_session_tasks_stats_latest (view) Content](console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_tasks_stats_latest" AS
SELECT iss.*
FROM ur_ingest_session_tasks_stats AS iss
JOIN ( SELECT ur_ingest_session.ur_ingest_session_id AS latest_session_id
FROM ur_ingest_session
ORDER BY ur_ingest_session.ingest_finished_at DESC
LIMIT 1) AS latest
ON iss.ingest_session_id = latest.latest_session_id |
| ur_ingest_session_tasks_stats_latest |
ingest_session_started_at |
TIMESTAMPTZ |
/console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes) |
[ur_ingest_session_tasks_stats_latest (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes) |
/console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes) |
[ur_ingest_session_tasks_stats_latest (view) Content](console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_tasks_stats_latest" AS
SELECT iss.*
FROM ur_ingest_session_tasks_stats AS iss
JOIN ( SELECT ur_ingest_session.ur_ingest_session_id AS latest_session_id
FROM ur_ingest_session
ORDER BY ur_ingest_session.ingest_finished_at DESC
LIMIT 1) AS latest
ON iss.ingest_session_id = latest.latest_session_id |
| ur_ingest_session_tasks_stats_latest |
ingest_session_finished_at |
TIMESTAMPTZ |
/console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes) |
[ur_ingest_session_tasks_stats_latest (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes) |
/console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes) |
[ur_ingest_session_tasks_stats_latest (view) Content](console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_tasks_stats_latest" AS
SELECT iss.*
FROM ur_ingest_session_tasks_stats AS iss
JOIN ( SELECT ur_ingest_session.ur_ingest_session_id AS latest_session_id
FROM ur_ingest_session
ORDER BY ur_ingest_session.ingest_finished_at DESC
LIMIT 1) AS latest
ON iss.ingest_session_id = latest.latest_session_id |
| ur_ingest_session_tasks_stats_latest |
ur_status |
|
/console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes) |
[ur_ingest_session_tasks_stats_latest (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes) |
/console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes) |
[ur_ingest_session_tasks_stats_latest (view) Content](console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_tasks_stats_latest" AS
SELECT iss.*
FROM ur_ingest_session_tasks_stats AS iss
JOIN ( SELECT ur_ingest_session.ur_ingest_session_id AS latest_session_id
FROM ur_ingest_session
ORDER BY ur_ingest_session.ingest_finished_at DESC
LIMIT 1) AS latest
ON iss.ingest_session_id = latest.latest_session_id |
| ur_ingest_session_tasks_stats_latest |
nature |
|
/console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes) |
[ur_ingest_session_tasks_stats_latest (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes) |
/console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes) |
[ur_ingest_session_tasks_stats_latest (view) Content](console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_tasks_stats_latest" AS
SELECT iss.*
FROM ur_ingest_session_tasks_stats AS iss
JOIN ( SELECT ur_ingest_session.ur_ingest_session_id AS latest_session_id
FROM ur_ingest_session
ORDER BY ur_ingest_session.ingest_finished_at DESC
LIMIT 1) AS latest
ON iss.ingest_session_id = latest.latest_session_id |
| ur_ingest_session_tasks_stats_latest |
total_file_count |
|
/console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes) |
[ur_ingest_session_tasks_stats_latest (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes) |
/console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes) |
[ur_ingest_session_tasks_stats_latest (view) Content](console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_tasks_stats_latest" AS
SELECT iss.*
FROM ur_ingest_session_tasks_stats AS iss
JOIN ( SELECT ur_ingest_session.ur_ingest_session_id AS latest_session_id
FROM ur_ingest_session
ORDER BY ur_ingest_session.ingest_finished_at DESC
LIMIT 1) AS latest
ON iss.ingest_session_id = latest.latest_session_id |
| ur_ingest_session_tasks_stats_latest |
file_count_with_content |
|
/console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes) |
[ur_ingest_session_tasks_stats_latest (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes) |
/console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes) |
[ur_ingest_session_tasks_stats_latest (view) Content](console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_tasks_stats_latest" AS
SELECT iss.*
FROM ur_ingest_session_tasks_stats AS iss
JOIN ( SELECT ur_ingest_session.ur_ingest_session_id AS latest_session_id
FROM ur_ingest_session
ORDER BY ur_ingest_session.ingest_finished_at DESC
LIMIT 1) AS latest
ON iss.ingest_session_id = latest.latest_session_id |
| ur_ingest_session_tasks_stats_latest |
file_count_with_frontmatter |
|
/console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes) |
[ur_ingest_session_tasks_stats_latest (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes) |
/console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes) |
[ur_ingest_session_tasks_stats_latest (view) Content](console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_tasks_stats_latest" AS
SELECT iss.*
FROM ur_ingest_session_tasks_stats AS iss
JOIN ( SELECT ur_ingest_session.ur_ingest_session_id AS latest_session_id
FROM ur_ingest_session
ORDER BY ur_ingest_session.ingest_finished_at DESC
LIMIT 1) AS latest
ON iss.ingest_session_id = latest.latest_session_id |
| ur_ingest_session_tasks_stats_latest |
min_file_size_bytes |
|
/console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes) |
[ur_ingest_session_tasks_stats_latest (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes) |
/console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes) |
[ur_ingest_session_tasks_stats_latest (view) Content](console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_tasks_stats_latest" AS
SELECT iss.*
FROM ur_ingest_session_tasks_stats AS iss
JOIN ( SELECT ur_ingest_session.ur_ingest_session_id AS latest_session_id
FROM ur_ingest_session
ORDER BY ur_ingest_session.ingest_finished_at DESC
LIMIT 1) AS latest
ON iss.ingest_session_id = latest.latest_session_id |
| ur_ingest_session_tasks_stats_latest |
average_file_size_bytes |
INT |
/console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes) |
[ur_ingest_session_tasks_stats_latest (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes) |
/console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes) |
[ur_ingest_session_tasks_stats_latest (view) Content](console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_tasks_stats_latest" AS
SELECT iss.*
FROM ur_ingest_session_tasks_stats AS iss
JOIN ( SELECT ur_ingest_session.ur_ingest_session_id AS latest_session_id
FROM ur_ingest_session
ORDER BY ur_ingest_session.ingest_finished_at DESC
LIMIT 1) AS latest
ON iss.ingest_session_id = latest.latest_session_id |
| ur_ingest_session_tasks_stats_latest |
max_file_size_bytes |
|
/console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes) |
[ur_ingest_session_tasks_stats_latest (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes) |
/console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes) |
[ur_ingest_session_tasks_stats_latest (view) Content](console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_tasks_stats_latest" AS
SELECT iss.*
FROM ur_ingest_session_tasks_stats AS iss
JOIN ( SELECT ur_ingest_session.ur_ingest_session_id AS latest_session_id
FROM ur_ingest_session
ORDER BY ur_ingest_session.ingest_finished_at DESC
LIMIT 1) AS latest
ON iss.ingest_session_id = latest.latest_session_id |
| ur_ingest_session_tasks_stats_latest |
oldest_file_last_modified_datetime |
|
/console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes) |
[ur_ingest_session_tasks_stats_latest (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes) |
/console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes) |
[ur_ingest_session_tasks_stats_latest (view) Content](console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_tasks_stats_latest" AS
SELECT iss.*
FROM ur_ingest_session_tasks_stats AS iss
JOIN ( SELECT ur_ingest_session.ur_ingest_session_id AS latest_session_id
FROM ur_ingest_session
ORDER BY ur_ingest_session.ingest_finished_at DESC
LIMIT 1) AS latest
ON iss.ingest_session_id = latest.latest_session_id |
| ur_ingest_session_tasks_stats_latest |
youngest_file_last_modified_datetime |
|
/console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes) |
[ur_ingest_session_tasks_stats_latest (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes) |
/console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes) |
[ur_ingest_session_tasks_stats_latest (view) Content](console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_tasks_stats_latest" AS
SELECT iss.*
FROM ur_ingest_session_tasks_stats AS iss
JOIN ( SELECT ur_ingest_session.ur_ingest_session_id AS latest_session_id
FROM ur_ingest_session
ORDER BY ur_ingest_session.ingest_finished_at DESC
LIMIT 1) AS latest
ON iss.ingest_session_id = latest.latest_session_id |
| ur_ingest_session_file_issue |
device_id |
VARCHAR |
/console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes) |
[ur_ingest_session_file_issue (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes) |
/console/content/view/ur_ingest_session_file_issue.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_file_issue.sql?stats=yes) |
[ur_ingest_session_file_issue (view) Content](console/content/view/ur_ingest_session_file_issue.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_file_issue" AS
SELECT us.device_id,
us.ur_ingest_session_id,
usp.ur_ingest_session_fs_path_id,
usp.root_path,
ufs.ur_ingest_session_fs_path_entry_id,
ufs.file_path_abs,
ufs.ur_status,
ufs.ur_diagnostics
FROM ur_ingest_session_fs_path_entry ufs
JOIN ur_ingest_session_fs_path usp ON ufs.ingest_fs_path_id = usp.ur_ingest_session_fs_path_id
JOIN ur_ingest_session us ON usp.ingest_session_id = us.ur_ingest_session_id
WHERE ufs.ur_status IS NOT NULL
GROUP BY us.device_id,
us.ur_ingest_session_id,
usp.ur_ingest_session_fs_path_id,
usp.root_path,
ufs.ur_ingest_session_fs_path_entry_id,
ufs.file_path_abs,
ufs.ur_status,
ufs.ur_diagnostics |
| ur_ingest_session_file_issue |
ur_ingest_session_id |
VARCHAR |
/console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes) |
[ur_ingest_session_file_issue (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes) |
/console/content/view/ur_ingest_session_file_issue.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_file_issue.sql?stats=yes) |
[ur_ingest_session_file_issue (view) Content](console/content/view/ur_ingest_session_file_issue.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_file_issue" AS
SELECT us.device_id,
us.ur_ingest_session_id,
usp.ur_ingest_session_fs_path_id,
usp.root_path,
ufs.ur_ingest_session_fs_path_entry_id,
ufs.file_path_abs,
ufs.ur_status,
ufs.ur_diagnostics
FROM ur_ingest_session_fs_path_entry ufs
JOIN ur_ingest_session_fs_path usp ON ufs.ingest_fs_path_id = usp.ur_ingest_session_fs_path_id
JOIN ur_ingest_session us ON usp.ingest_session_id = us.ur_ingest_session_id
WHERE ufs.ur_status IS NOT NULL
GROUP BY us.device_id,
us.ur_ingest_session_id,
usp.ur_ingest_session_fs_path_id,
usp.root_path,
ufs.ur_ingest_session_fs_path_entry_id,
ufs.file_path_abs,
ufs.ur_status,
ufs.ur_diagnostics |
| ur_ingest_session_file_issue |
ur_ingest_session_fs_path_id |
VARCHAR |
/console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes) |
[ur_ingest_session_file_issue (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes) |
/console/content/view/ur_ingest_session_file_issue.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_file_issue.sql?stats=yes) |
[ur_ingest_session_file_issue (view) Content](console/content/view/ur_ingest_session_file_issue.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_file_issue" AS
SELECT us.device_id,
us.ur_ingest_session_id,
usp.ur_ingest_session_fs_path_id,
usp.root_path,
ufs.ur_ingest_session_fs_path_entry_id,
ufs.file_path_abs,
ufs.ur_status,
ufs.ur_diagnostics
FROM ur_ingest_session_fs_path_entry ufs
JOIN ur_ingest_session_fs_path usp ON ufs.ingest_fs_path_id = usp.ur_ingest_session_fs_path_id
JOIN ur_ingest_session us ON usp.ingest_session_id = us.ur_ingest_session_id
WHERE ufs.ur_status IS NOT NULL
GROUP BY us.device_id,
us.ur_ingest_session_id,
usp.ur_ingest_session_fs_path_id,
usp.root_path,
ufs.ur_ingest_session_fs_path_entry_id,
ufs.file_path_abs,
ufs.ur_status,
ufs.ur_diagnostics |
| ur_ingest_session_file_issue |
root_path |
TEXT |
/console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes) |
[ur_ingest_session_file_issue (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes) |
/console/content/view/ur_ingest_session_file_issue.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_file_issue.sql?stats=yes) |
[ur_ingest_session_file_issue (view) Content](console/content/view/ur_ingest_session_file_issue.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_file_issue" AS
SELECT us.device_id,
us.ur_ingest_session_id,
usp.ur_ingest_session_fs_path_id,
usp.root_path,
ufs.ur_ingest_session_fs_path_entry_id,
ufs.file_path_abs,
ufs.ur_status,
ufs.ur_diagnostics
FROM ur_ingest_session_fs_path_entry ufs
JOIN ur_ingest_session_fs_path usp ON ufs.ingest_fs_path_id = usp.ur_ingest_session_fs_path_id
JOIN ur_ingest_session us ON usp.ingest_session_id = us.ur_ingest_session_id
WHERE ufs.ur_status IS NOT NULL
GROUP BY us.device_id,
us.ur_ingest_session_id,
usp.ur_ingest_session_fs_path_id,
usp.root_path,
ufs.ur_ingest_session_fs_path_entry_id,
ufs.file_path_abs,
ufs.ur_status,
ufs.ur_diagnostics |
| ur_ingest_session_file_issue |
ur_ingest_session_fs_path_entry_id |
VARCHAR |
/console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes) |
[ur_ingest_session_file_issue (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes) |
/console/content/view/ur_ingest_session_file_issue.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_file_issue.sql?stats=yes) |
[ur_ingest_session_file_issue (view) Content](console/content/view/ur_ingest_session_file_issue.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_file_issue" AS
SELECT us.device_id,
us.ur_ingest_session_id,
usp.ur_ingest_session_fs_path_id,
usp.root_path,
ufs.ur_ingest_session_fs_path_entry_id,
ufs.file_path_abs,
ufs.ur_status,
ufs.ur_diagnostics
FROM ur_ingest_session_fs_path_entry ufs
JOIN ur_ingest_session_fs_path usp ON ufs.ingest_fs_path_id = usp.ur_ingest_session_fs_path_id
JOIN ur_ingest_session us ON usp.ingest_session_id = us.ur_ingest_session_id
WHERE ufs.ur_status IS NOT NULL
GROUP BY us.device_id,
us.ur_ingest_session_id,
usp.ur_ingest_session_fs_path_id,
usp.root_path,
ufs.ur_ingest_session_fs_path_entry_id,
ufs.file_path_abs,
ufs.ur_status,
ufs.ur_diagnostics |
| ur_ingest_session_file_issue |
file_path_abs |
TEXT |
/console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes) |
[ur_ingest_session_file_issue (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes) |
/console/content/view/ur_ingest_session_file_issue.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_file_issue.sql?stats=yes) |
[ur_ingest_session_file_issue (view) Content](console/content/view/ur_ingest_session_file_issue.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_file_issue" AS
SELECT us.device_id,
us.ur_ingest_session_id,
usp.ur_ingest_session_fs_path_id,
usp.root_path,
ufs.ur_ingest_session_fs_path_entry_id,
ufs.file_path_abs,
ufs.ur_status,
ufs.ur_diagnostics
FROM ur_ingest_session_fs_path_entry ufs
JOIN ur_ingest_session_fs_path usp ON ufs.ingest_fs_path_id = usp.ur_ingest_session_fs_path_id
JOIN ur_ingest_session us ON usp.ingest_session_id = us.ur_ingest_session_id
WHERE ufs.ur_status IS NOT NULL
GROUP BY us.device_id,
us.ur_ingest_session_id,
usp.ur_ingest_session_fs_path_id,
usp.root_path,
ufs.ur_ingest_session_fs_path_entry_id,
ufs.file_path_abs,
ufs.ur_status,
ufs.ur_diagnostics |
| ur_ingest_session_file_issue |
ur_status |
TEXT |
/console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes) |
[ur_ingest_session_file_issue (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes) |
/console/content/view/ur_ingest_session_file_issue.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_file_issue.sql?stats=yes) |
[ur_ingest_session_file_issue (view) Content](console/content/view/ur_ingest_session_file_issue.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_file_issue" AS
SELECT us.device_id,
us.ur_ingest_session_id,
usp.ur_ingest_session_fs_path_id,
usp.root_path,
ufs.ur_ingest_session_fs_path_entry_id,
ufs.file_path_abs,
ufs.ur_status,
ufs.ur_diagnostics
FROM ur_ingest_session_fs_path_entry ufs
JOIN ur_ingest_session_fs_path usp ON ufs.ingest_fs_path_id = usp.ur_ingest_session_fs_path_id
JOIN ur_ingest_session us ON usp.ingest_session_id = us.ur_ingest_session_id
WHERE ufs.ur_status IS NOT NULL
GROUP BY us.device_id,
us.ur_ingest_session_id,
usp.ur_ingest_session_fs_path_id,
usp.root_path,
ufs.ur_ingest_session_fs_path_entry_id,
ufs.file_path_abs,
ufs.ur_status,
ufs.ur_diagnostics |
| ur_ingest_session_file_issue |
ur_diagnostics |
TEXT |
/console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes) |
[ur_ingest_session_file_issue (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes) |
/console/content/view/ur_ingest_session_file_issue.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_file_issue.sql?stats=yes) |
[ur_ingest_session_file_issue (view) Content](console/content/view/ur_ingest_session_file_issue.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_file_issue" AS
SELECT us.device_id,
us.ur_ingest_session_id,
usp.ur_ingest_session_fs_path_id,
usp.root_path,
ufs.ur_ingest_session_fs_path_entry_id,
ufs.file_path_abs,
ufs.ur_status,
ufs.ur_diagnostics
FROM ur_ingest_session_fs_path_entry ufs
JOIN ur_ingest_session_fs_path usp ON ufs.ingest_fs_path_id = usp.ur_ingest_session_fs_path_id
JOIN ur_ingest_session us ON usp.ingest_session_id = us.ur_ingest_session_id
WHERE ufs.ur_status IS NOT NULL
GROUP BY us.device_id,
us.ur_ingest_session_id,
usp.ur_ingest_session_fs_path_id,
usp.root_path,
ufs.ur_ingest_session_fs_path_entry_id,
ufs.file_path_abs,
ufs.ur_status,
ufs.ur_diagnostics |
| console_information_schema_table |
table_name |
TEXT |
/console/info-schema/view.sql?name=console_information_schema_table&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
[console_information_schema_table (view) Schema](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
/console/content/view/console_information_schema_table.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table.sql?stats=yes) |
[console_information_schema_table (view) Content](console/content/view/console_information_schema_table.sql?stats=yes) |
CREATE VIEW console_information_schema_table AS
SELECT
tbl.name AS table_name,
col.name AS column_name,
col.type AS data_type,
CASE WHEN col.pk = 1 THEN 'Yes' ELSE 'No' END AS is_primary_key,
CASE WHEN col."notnull" = 1 THEN 'Yes' ELSE 'No' END AS is_not_null,
col.dflt_value AS default_value,
'console/info-schema/table.sql?name=' || tbl.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || tbl.name || ' (table) Schema](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_full_md,
'console/content/table/' || tbl.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || tbl.name || ' (table) Content](console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
tbl.sql as sql_ddl
FROM sqlite_master tbl
JOIN pragma_table_info(tbl.name) col
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |
| console_information_schema_table |
column_name |
BLOB |
/console/info-schema/view.sql?name=console_information_schema_table&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
[console_information_schema_table (view) Schema](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
/console/content/view/console_information_schema_table.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table.sql?stats=yes) |
[console_information_schema_table (view) Content](console/content/view/console_information_schema_table.sql?stats=yes) |
CREATE VIEW console_information_schema_table AS
SELECT
tbl.name AS table_name,
col.name AS column_name,
col.type AS data_type,
CASE WHEN col.pk = 1 THEN 'Yes' ELSE 'No' END AS is_primary_key,
CASE WHEN col."notnull" = 1 THEN 'Yes' ELSE 'No' END AS is_not_null,
col.dflt_value AS default_value,
'console/info-schema/table.sql?name=' || tbl.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || tbl.name || ' (table) Schema](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_full_md,
'console/content/table/' || tbl.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || tbl.name || ' (table) Content](console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
tbl.sql as sql_ddl
FROM sqlite_master tbl
JOIN pragma_table_info(tbl.name) col
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |
| console_information_schema_table |
data_type |
BLOB |
/console/info-schema/view.sql?name=console_information_schema_table&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
[console_information_schema_table (view) Schema](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
/console/content/view/console_information_schema_table.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table.sql?stats=yes) |
[console_information_schema_table (view) Content](console/content/view/console_information_schema_table.sql?stats=yes) |
CREATE VIEW console_information_schema_table AS
SELECT
tbl.name AS table_name,
col.name AS column_name,
col.type AS data_type,
CASE WHEN col.pk = 1 THEN 'Yes' ELSE 'No' END AS is_primary_key,
CASE WHEN col."notnull" = 1 THEN 'Yes' ELSE 'No' END AS is_not_null,
col.dflt_value AS default_value,
'console/info-schema/table.sql?name=' || tbl.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || tbl.name || ' (table) Schema](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_full_md,
'console/content/table/' || tbl.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || tbl.name || ' (table) Content](console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
tbl.sql as sql_ddl
FROM sqlite_master tbl
JOIN pragma_table_info(tbl.name) col
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |