count
----------
1
9164296
13619293
(3 rows)
On Mon, Jan 14, 2013 at 3:45 PM, Stefan Negrea <snegrea(a)redhat.com> wrote:
SELECT COUNT(*) FROM rhq_agent UNION ALL
SELECT (
(SELECT COUNT(*) FROM rhq_measurement_data_num_1h) +
(SELECT COUNT(*) FROM rhq_measurement_data_num_6h) +
(SELECT COUNT(*) FROM rhq_measurement_data_num_1D) ) UNION ALL
SELECT (
(SELECT COUNT(*) FROM rhq_meas_data_num_r00) +
(SELECT COUNT(*) FROM rhq_meas_data_num_r02) +
(SELECT COUNT(*) FROM rhq_meas_data_num_r03) +
(SELECT COUNT(*) FROM rhq_meas_data_num_r04) +
(SELECT COUNT(*) FROM rhq_meas_data_num_r05) +
(SELECT COUNT(*) FROM rhq_meas_data_num_r06) +
(SELECT COUNT(*) FROM rhq_meas_data_num_r07) +
(SELECT COUNT(*) FROM rhq_meas_data_num_r08) +
(SELECT COUNT(*) FROM rhq_meas_data_num_r09) +
(SELECT COUNT(*) FROM rhq_meas_data_num_r10) +
(SELECT COUNT(*) FROM rhq_meas_data_num_r11) +
(SELECT COUNT(*) FROM rhq_meas_data_num_r12) +
(SELECT COUNT(*) FROM rhq_meas_data_num_r13) +
(SELECT COUNT(*) FROM rhq_meas_data_num_r14))