[ ESO ]

Workflow information system for QC

 

WISQ
Other ...
QC1 db access

QC1 Database: DFO workflow statistics

The QC1 database contains statistical information about the DFO workflows. This interface offers access to these tables.

For each table, there is a browser and a plotter:

  • The browser opens the door to the full content of a specific table and includes download capabilities.
  • The plotter offers graphical representation of two selected parameters, with filtering and statistical features.

The DFO tables feed the WISQ reporting system. Links are provided under "WISQ". These are plots maintained by the trendPlotter tool.


Select a table for browsing or plotting:

item table interface WISQ description
DFO workflows monthly_stat browse | plot | hide WISQ plot

parameters for QC daily workflow (monthly averages);
this table is fed by the dfos tool extractStat and contains monthly averages for all instrument modes, sums per instrument, and a sum over all instruments (ALL_INS_SUM).

daily_stat browse | plot | hide  

parameters for QC daily workflow (daily numbers);
this table is fed by the dfos tool extractStat; it is used only to store daily numbers and calculate the monthly averages.

monthly_AB_certif browse | plot | hide   same as monthly_stat, for the certified (CALIB) and associated (SCIENCE) ABs
monthly_idpstat browse | plot | hide

parameters for the phoenix IDP workflow (monthly averages). This table is fed by the tool ingestProducts in the phoenix environment. It contains monthly averages for the IDPs generated by QC.

daily_idpstat browse | plot | hide  

parameters for phoenix IDP workflow (daily numbers). This table is used to store daily numbers and calculate the monthly averages.

monthly_idpdown browse | plot | hide WISQ plot parameters for IDP download statistics, used on WISQ monitor
monthly_idpingest browse | plot | hide WISQ plot aggregated IDP ingestion statistics (N_SCI_PRO@monthly_idpstat), used on WISQ monitor
exec_time browse | plot | hide WISQ plot execution times for key tools like calChecker, autoDaily
calsel_breakpoints browse | plot | hide   breakpoints for calSelector
 
historical:
pack_monthly_stat
browse | plot WISQ_plot parameters for QC packing workflow (monthly averages); this table has historical content only, until 2011-10-01
historical:
pack_stat
browse | plot   parameters for QC packing workflow (daily numbers); it was used to store daily numbers and calculate the monthly averages from there; this table has historical content only, until 2011-10-01
PSO dataflow_monthly_stat browse | plot | hide WISQ plot parameters for monthly data production (VLT/VLTI; VISTA) on Paranal
dataflow_stat browse | plot | hide WISQ plot parameters for daily data production (VLT/VLTI; VISTA) on Paranal
 
comment management raw_comments browse | plot | hide   comments about raw files (displayed in data reports)
prod_comments browse | plot | hide   comments about product files (displayed in AB monitor and PI packages)
daily_comments browse | plot | hide   comments about daily processing (fed by histoMonitor, displayed there and in data reports); no duplicate hiding necessary
 
scoring qc1_score browse | plot | hide   technical table to manage score parameters