Metrics Collection - Help

Thomas Segismont tsegismo at redhat.com
Mon Jan 14 14:55:34 UTC 2013


Le 14/01/2013 15:45, Stefan Negrea a écrit :
> Hello Everybody,
>
> I just worked on estimating the amount of numeric metrics data collected by RHQ. I would appreciate a little feedback on the work I've done. This will help me get a better idea on the ratios of agent:raw metrics and agent:aggregate metric collected on real environments.
>
> For all RHQ users with a Postgres backend, could you please run the query below on your RHQ database and reply with the result? The result is a set of three numbers: the number of agents, total number of aggregate metrics, and total number of raw metrics.
>
>
> All the feedback is greatly appreciated, even if you are developer, plugin writer, casual tester or you just installed RHQ for a simple test.
>
>
> The query:
>
> 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))
>
>
> Here is what I got when I ran the query on my local box:
> 1
> 7285
> 18617
>
>
> Thank you,
> Stefan Negrea
>
> Software Engineer
>
> _______________________________________________
> rhq-users mailing list
> rhq-users at lists.fedorahosted.org
> https://lists.fedorahosted.org/mailman/listinfo/rhq-users
>


For me it's:
      1
   4276
   7962

Cheers


More information about the rhq-devel mailing list