SET TIMING ON

PROMPT Pedestals in partition 'DATA_P1'
select min(run_number), max(run_number), count(*) from smt_calib.pedestals partition (DATA_P1);
PROMPT Gains in partition 'DATA_P1'
select min(run_number), max(run_number), count(*) from smt_calib.gains partition (DATA_P1);

PROMPT Pedestals in partition 'DATA_P2'
select min(run_number), max(run_number), count(*) from smt_calib.pedestals partition (DATA_P2);
PROMPT Gains in partition 'DATA_P2'
select min(run_number), max(run_number), count(*) from smt_calib.gains partition (DATA_P2);

PROMPT Pedestals in partition 'DATA_P3'
select min(run_number), max(run_number), count(*) from smt_calib.pedestals partition (DATA_P3);
PROMPT Gains in partition 'DATA_P3'
select min(run_number), max(run_number), count(*) from smt_calib.gains partition (DATA_P3);

PROMPT Pedestals in partition 'DATA_P4'
select min(run_number), max(run_number), count(*) from smt_calib.pedestals partition (DATA_P4);
PROMPT Gains in partition 'DATA_P4'
select min(run_number), max(run_number), count(*) from smt_calib.gains partition (DATA_P4);

PROMPT Pedestals in partition 'DATA_P5'
select min(run_number), max(run_number), count(*) from smt_calib.pedestals partition (DATA_P5);
PROMPT Gains in partition 'DATA_P5'
select min(run_number), max(run_number), count(*) from smt_calib.gains partition (DATA_P5);

PROMPT Pedestals in partition 'DATA_P6'
select min(run_number), max(run_number), count(*) from smt_calib.pedestals partition (DATA_P6);
PROMPT Gains in partition 'DATA_P6'
select min(run_number), max(run_number), count(*) from smt_calib.gains partition (DATA_P6);

PROMPT Pedestals in partition 'DATA_P7'
select min(run_number), max(run_number), count(*) from smt_calib.pedestals partition (DATA_P7);
PROMPT Gains in partition 'DATA_P7'
select min(run_number), max(run_number), count(*) from smt_calib.gains partition (DATA_P7);

PROMPT Pedestals in partition 'DATA_PMAX'
select min(run_number), max(run_number), count(*) from smt_calib.pedestals partition (DATA_PMAX);
PROMPT Gains in partition 'DATA_PMAX'
select min(run_number), max(run_number), count(*) from smt_calib.gains partition (DATA_PMAX);

SET TIMING OFF
