Metrics Collection - Help

Andreas Veithen andreas.veithen at gmail.com
Tue Jan 15 08:31:18 UTC 2013


  count
----------
        1
  9164296
 13619293
(3 rows)

On Mon, Jan 14, 2013 at 3:45 PM, Stefan Negrea <snegrea at 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))


More information about the rhq-devel mailing list