| ur_ingest_session_files_stats |
ingest_session_fs_path_id |
VARCHAR |
/console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes) |
[ur_ingest_session_files_stats (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes) |
/console/content/view/ur_ingest_session_files_stats.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_files_stats.sql?stats=yes) |
[ur_ingest_session_files_stats (view) Content](console/content/view/ur_ingest_session_files_stats.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_files_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_fs_path_entry.file_extn, '') AS file_extension,
ur_ingest_session_fs_path.ur_ingest_session_fs_path_id as ingest_session_fs_path_id,
ur_ingest_session_fs_path.root_path AS ingest_session_root_fs_path,
COUNT(ur_ingest_session_fs_path_entry.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_fs_path ON ur_ingest_session.ur_ingest_session_id = ur_ingest_session_fs_path.ingest_session_id
LEFT JOIN
ur_ingest_session_fs_path_entry ON ur_ingest_session_fs_path.ur_ingest_session_fs_path_id = ur_ingest_session_fs_path_entry.ingest_fs_path_id
LEFT JOIN
uniform_resource ON ur_ingest_session_fs_path_entry.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_fs_path_entry.file_extn,
ur_ingest_session_fs_path.root_path
)
SELECT
device_id,
ingest_session_id,
ingest_session_started_at,
ingest_session_finished_at,
file_extension,
ingest_session_fs_path_id,
ingest_session_root_fs_path,
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,
file_extension |
| ur_ingest_session_files_stats |
ingest_session_root_fs_path |
TEXT |
/console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes) |
[ur_ingest_session_files_stats (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes) |
/console/content/view/ur_ingest_session_files_stats.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_files_stats.sql?stats=yes) |
[ur_ingest_session_files_stats (view) Content](console/content/view/ur_ingest_session_files_stats.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_files_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_fs_path_entry.file_extn, '') AS file_extension,
ur_ingest_session_fs_path.ur_ingest_session_fs_path_id as ingest_session_fs_path_id,
ur_ingest_session_fs_path.root_path AS ingest_session_root_fs_path,
COUNT(ur_ingest_session_fs_path_entry.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_fs_path ON ur_ingest_session.ur_ingest_session_id = ur_ingest_session_fs_path.ingest_session_id
LEFT JOIN
ur_ingest_session_fs_path_entry ON ur_ingest_session_fs_path.ur_ingest_session_fs_path_id = ur_ingest_session_fs_path_entry.ingest_fs_path_id
LEFT JOIN
uniform_resource ON ur_ingest_session_fs_path_entry.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_fs_path_entry.file_extn,
ur_ingest_session_fs_path.root_path
)
SELECT
device_id,
ingest_session_id,
ingest_session_started_at,
ingest_session_finished_at,
file_extension,
ingest_session_fs_path_id,
ingest_session_root_fs_path,
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,
file_extension |
| ur_ingest_session_files_stats |
total_file_count |
|
/console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes) |
[ur_ingest_session_files_stats (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes) |
/console/content/view/ur_ingest_session_files_stats.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_files_stats.sql?stats=yes) |
[ur_ingest_session_files_stats (view) Content](console/content/view/ur_ingest_session_files_stats.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_files_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_fs_path_entry.file_extn, '') AS file_extension,
ur_ingest_session_fs_path.ur_ingest_session_fs_path_id as ingest_session_fs_path_id,
ur_ingest_session_fs_path.root_path AS ingest_session_root_fs_path,
COUNT(ur_ingest_session_fs_path_entry.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_fs_path ON ur_ingest_session.ur_ingest_session_id = ur_ingest_session_fs_path.ingest_session_id
LEFT JOIN
ur_ingest_session_fs_path_entry ON ur_ingest_session_fs_path.ur_ingest_session_fs_path_id = ur_ingest_session_fs_path_entry.ingest_fs_path_id
LEFT JOIN
uniform_resource ON ur_ingest_session_fs_path_entry.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_fs_path_entry.file_extn,
ur_ingest_session_fs_path.root_path
)
SELECT
device_id,
ingest_session_id,
ingest_session_started_at,
ingest_session_finished_at,
file_extension,
ingest_session_fs_path_id,
ingest_session_root_fs_path,
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,
file_extension |
| ur_ingest_session_files_stats |
file_count_with_content |
|
/console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes) |
[ur_ingest_session_files_stats (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes) |
/console/content/view/ur_ingest_session_files_stats.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_files_stats.sql?stats=yes) |
[ur_ingest_session_files_stats (view) Content](console/content/view/ur_ingest_session_files_stats.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_files_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_fs_path_entry.file_extn, '') AS file_extension,
ur_ingest_session_fs_path.ur_ingest_session_fs_path_id as ingest_session_fs_path_id,
ur_ingest_session_fs_path.root_path AS ingest_session_root_fs_path,
COUNT(ur_ingest_session_fs_path_entry.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_fs_path ON ur_ingest_session.ur_ingest_session_id = ur_ingest_session_fs_path.ingest_session_id
LEFT JOIN
ur_ingest_session_fs_path_entry ON ur_ingest_session_fs_path.ur_ingest_session_fs_path_id = ur_ingest_session_fs_path_entry.ingest_fs_path_id
LEFT JOIN
uniform_resource ON ur_ingest_session_fs_path_entry.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_fs_path_entry.file_extn,
ur_ingest_session_fs_path.root_path
)
SELECT
device_id,
ingest_session_id,
ingest_session_started_at,
ingest_session_finished_at,
file_extension,
ingest_session_fs_path_id,
ingest_session_root_fs_path,
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,
file_extension |
| ur_ingest_session_files_stats |
file_count_with_frontmatter |
|
/console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes) |
[ur_ingest_session_files_stats (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes) |
/console/content/view/ur_ingest_session_files_stats.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_files_stats.sql?stats=yes) |
[ur_ingest_session_files_stats (view) Content](console/content/view/ur_ingest_session_files_stats.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_files_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_fs_path_entry.file_extn, '') AS file_extension,
ur_ingest_session_fs_path.ur_ingest_session_fs_path_id as ingest_session_fs_path_id,
ur_ingest_session_fs_path.root_path AS ingest_session_root_fs_path,
COUNT(ur_ingest_session_fs_path_entry.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_fs_path ON ur_ingest_session.ur_ingest_session_id = ur_ingest_session_fs_path.ingest_session_id
LEFT JOIN
ur_ingest_session_fs_path_entry ON ur_ingest_session_fs_path.ur_ingest_session_fs_path_id = ur_ingest_session_fs_path_entry.ingest_fs_path_id
LEFT JOIN
uniform_resource ON ur_ingest_session_fs_path_entry.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_fs_path_entry.file_extn,
ur_ingest_session_fs_path.root_path
)
SELECT
device_id,
ingest_session_id,
ingest_session_started_at,
ingest_session_finished_at,
file_extension,
ingest_session_fs_path_id,
ingest_session_root_fs_path,
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,
file_extension |
| ur_ingest_session_files_stats |
min_file_size_bytes |
|
/console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes) |
[ur_ingest_session_files_stats (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes) |
/console/content/view/ur_ingest_session_files_stats.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_files_stats.sql?stats=yes) |
[ur_ingest_session_files_stats (view) Content](console/content/view/ur_ingest_session_files_stats.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_files_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_fs_path_entry.file_extn, '') AS file_extension,
ur_ingest_session_fs_path.ur_ingest_session_fs_path_id as ingest_session_fs_path_id,
ur_ingest_session_fs_path.root_path AS ingest_session_root_fs_path,
COUNT(ur_ingest_session_fs_path_entry.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_fs_path ON ur_ingest_session.ur_ingest_session_id = ur_ingest_session_fs_path.ingest_session_id
LEFT JOIN
ur_ingest_session_fs_path_entry ON ur_ingest_session_fs_path.ur_ingest_session_fs_path_id = ur_ingest_session_fs_path_entry.ingest_fs_path_id
LEFT JOIN
uniform_resource ON ur_ingest_session_fs_path_entry.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_fs_path_entry.file_extn,
ur_ingest_session_fs_path.root_path
)
SELECT
device_id,
ingest_session_id,
ingest_session_started_at,
ingest_session_finished_at,
file_extension,
ingest_session_fs_path_id,
ingest_session_root_fs_path,
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,
file_extension |
| ur_ingest_session_files_stats |
average_file_size_bytes |
INT |
/console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes) |
[ur_ingest_session_files_stats (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes) |
/console/content/view/ur_ingest_session_files_stats.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_files_stats.sql?stats=yes) |
[ur_ingest_session_files_stats (view) Content](console/content/view/ur_ingest_session_files_stats.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_files_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_fs_path_entry.file_extn, '') AS file_extension,
ur_ingest_session_fs_path.ur_ingest_session_fs_path_id as ingest_session_fs_path_id,
ur_ingest_session_fs_path.root_path AS ingest_session_root_fs_path,
COUNT(ur_ingest_session_fs_path_entry.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_fs_path ON ur_ingest_session.ur_ingest_session_id = ur_ingest_session_fs_path.ingest_session_id
LEFT JOIN
ur_ingest_session_fs_path_entry ON ur_ingest_session_fs_path.ur_ingest_session_fs_path_id = ur_ingest_session_fs_path_entry.ingest_fs_path_id
LEFT JOIN
uniform_resource ON ur_ingest_session_fs_path_entry.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_fs_path_entry.file_extn,
ur_ingest_session_fs_path.root_path
)
SELECT
device_id,
ingest_session_id,
ingest_session_started_at,
ingest_session_finished_at,
file_extension,
ingest_session_fs_path_id,
ingest_session_root_fs_path,
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,
file_extension |
| ur_ingest_session_files_stats |
max_file_size_bytes |
|
/console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes) |
[ur_ingest_session_files_stats (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes) |
/console/content/view/ur_ingest_session_files_stats.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_files_stats.sql?stats=yes) |
[ur_ingest_session_files_stats (view) Content](console/content/view/ur_ingest_session_files_stats.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_files_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_fs_path_entry.file_extn, '') AS file_extension,
ur_ingest_session_fs_path.ur_ingest_session_fs_path_id as ingest_session_fs_path_id,
ur_ingest_session_fs_path.root_path AS ingest_session_root_fs_path,
COUNT(ur_ingest_session_fs_path_entry.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_fs_path ON ur_ingest_session.ur_ingest_session_id = ur_ingest_session_fs_path.ingest_session_id
LEFT JOIN
ur_ingest_session_fs_path_entry ON ur_ingest_session_fs_path.ur_ingest_session_fs_path_id = ur_ingest_session_fs_path_entry.ingest_fs_path_id
LEFT JOIN
uniform_resource ON ur_ingest_session_fs_path_entry.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_fs_path_entry.file_extn,
ur_ingest_session_fs_path.root_path
)
SELECT
device_id,
ingest_session_id,
ingest_session_started_at,
ingest_session_finished_at,
file_extension,
ingest_session_fs_path_id,
ingest_session_root_fs_path,
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,
file_extension |
| ur_ingest_session_files_stats |
oldest_file_last_modified_datetime |
|
/console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes) |
[ur_ingest_session_files_stats (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes) |
/console/content/view/ur_ingest_session_files_stats.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_files_stats.sql?stats=yes) |
[ur_ingest_session_files_stats (view) Content](console/content/view/ur_ingest_session_files_stats.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_files_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_fs_path_entry.file_extn, '') AS file_extension,
ur_ingest_session_fs_path.ur_ingest_session_fs_path_id as ingest_session_fs_path_id,
ur_ingest_session_fs_path.root_path AS ingest_session_root_fs_path,
COUNT(ur_ingest_session_fs_path_entry.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_fs_path ON ur_ingest_session.ur_ingest_session_id = ur_ingest_session_fs_path.ingest_session_id
LEFT JOIN
ur_ingest_session_fs_path_entry ON ur_ingest_session_fs_path.ur_ingest_session_fs_path_id = ur_ingest_session_fs_path_entry.ingest_fs_path_id
LEFT JOIN
uniform_resource ON ur_ingest_session_fs_path_entry.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_fs_path_entry.file_extn,
ur_ingest_session_fs_path.root_path
)
SELECT
device_id,
ingest_session_id,
ingest_session_started_at,
ingest_session_finished_at,
file_extension,
ingest_session_fs_path_id,
ingest_session_root_fs_path,
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,
file_extension |
| ur_ingest_session_files_stats |
youngest_file_last_modified_datetime |
|
/console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes) |
[ur_ingest_session_files_stats (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes) |
/console/content/view/ur_ingest_session_files_stats.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_files_stats.sql?stats=yes) |
[ur_ingest_session_files_stats (view) Content](console/content/view/ur_ingest_session_files_stats.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_files_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_fs_path_entry.file_extn, '') AS file_extension,
ur_ingest_session_fs_path.ur_ingest_session_fs_path_id as ingest_session_fs_path_id,
ur_ingest_session_fs_path.root_path AS ingest_session_root_fs_path,
COUNT(ur_ingest_session_fs_path_entry.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_fs_path ON ur_ingest_session.ur_ingest_session_id = ur_ingest_session_fs_path.ingest_session_id
LEFT JOIN
ur_ingest_session_fs_path_entry ON ur_ingest_session_fs_path.ur_ingest_session_fs_path_id = ur_ingest_session_fs_path_entry.ingest_fs_path_id
LEFT JOIN
uniform_resource ON ur_ingest_session_fs_path_entry.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_fs_path_entry.file_extn,
ur_ingest_session_fs_path.root_path
)
SELECT
device_id,
ingest_session_id,
ingest_session_started_at,
ingest_session_finished_at,
file_extension,
ingest_session_fs_path_id,
ingest_session_root_fs_path,
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,
file_extension |
| ur_ingest_session_files_stats_latest |
device_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_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_started_at |
TIMESTAMPTZ |
/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_finished_at |
TIMESTAMPTZ |
/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_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 |