Quality Control Tool
Home
Quality Control Tool status
Operational health Attention
Application
Online
This request completed.
Database
Connected
5 local pool target(s)
Scheduler credentials
Unattended ready
Scheduled exports survive browser logout.
Superset
Online
http://test.monitor-pauling.ts.net:8088
Stats cache
5 stale, 0 pending
2 current, 0 refreshing, 5 stale, 0 pending
Maintenance
Recent error
telemetry: tuple index out of range
WorkflowStatusLatest runLatest successful runDetail
AD Log Complete 2026-09-11 01:01:51.015255+03 2026-09-11 01:01:51.015255+03
Action Log Complete 2026-09-10 22:00:08.096132+03 2026-09-10 22:00:08.096132+03
Broken Media Complete 2026-09-10 22:02:15.309619+03 2026-09-10 22:02:15.309619+03
Media Problems Complete 2026-09-10 22:11:33.25181+03 2026-09-10 22:11:33.25181+03
LLM Metadata Complete 2026-09-10 15:14:00.66671+03 2026-09-10 15:14:00.66671+03
Action Log schedule Current 2026-09-10 22:00:00 EEST 2026-09-10 22:00:00 EEST Next slot: 2026-09-11 06:00:00 EEST
Broken Media schedule Current 2026-09-10 22:00:00 EEST 2026-09-10 22:00:00 EEST Next slot: 2026-09-11 06:00:00 EEST
Media Problems schedule Current 2026-09-10 22:00:00 EEST 2026-09-10 22:00:00 EEST Next slot: 2026-09-11 06:00:00 EEST

The tool is now a PostgreSQL-backed QC workspace with local imports, review queues, productivity analytics, LLM metadata analysis, and guest Superset dashboard previews.

Current focus: reliable CCR data imports, reviewer-friendly QC pages, shareable read-only BI dashboards, and faster operational checks without opening the Superset authoring workspace.

Dashboard preview LLM metadata AD catalog QC

StoragePostgreSQL warehouse and schemas for imports, annotations, action log, broken media, media problems, productivity cache, and LLM metadata; local settings in data/config.json
CCR credentialsNot entered
Import sourceCCR CSV export/import
Default AD pool48
BI dashboards6 guest-preview dashboards, including TV signal Media problems charts
SupersetOnline
Latest updates
  • Superset now exposes five guest, view-only dashboards from the Home page.
  • TV signal quality now includes a combined deduped media/broken-channel issue chart plus Media problems duration, event, type, top media, top user, and UTC-hour charts.
  • User productivity dashboards now include weighted productivity scores, daily-average volume, total-volume operator tables, and HH:MM:SS time-spent views.
  • Website comparisons in LLM metadata now normalize case, protocol, www., and common path differences.
Current state
  • Core QC app listens on 127.0.0.1:8081. Application authentication is not required for loopback-only access.
  • Superset listens on 0.0.0.0:8088 and can be browsed remotely when the host/network allows it.
  • AD log, action log, broken media, media problems, LLM metadata, and annotation workflows are backed by PostgreSQL.
  • Media problems duration defaults, per-type overrides, and excluded types are stored in data/config.json.
  • Stats > BI charts remains the configuration area for Superset settings and database connection hints.
What to use now
  • Use Dashboard preview for read-only BI browsing without login.
  • Use User productivity for cached weighted productivity, speed, daily-volume, and total-volume views.
  • Use LLM metadata for current-vs-LLM comparison analysis and normalized URL differences.
  • Use Broken channels for signal-loss summaries plus configurable Media problems statistics.
Primary workflows
WorkflowCurrent capabilityWhere to go
ImportsDownload or upload CCR AD log exports, Users actions logs, Media issues exports, and Media problems exports; scheduled imports are available.AD log, Action log, Broken media
Quality reviewGenerate tasks, inspect clips, record reviewer decisions, and track completion.AD catalog QC, AD log QC
User productivityCached action-log report with weighted productivity ranking, processing speed, daily processed volume, total processed volume, and Superset dashboard views.User productivity, BI preview
LLM metadataAnalyze current-vs-llm_ metadata, normalize website/domain comparisons, and export review CSVs.LLM metadata
Signal healthMonitor broken-channel signal loss and Media problems statistics with estimated durations, included/excluded problem types, affected media, top users, and dashboard-level BI trends.Broken channels, Stats