Metrics Collection - Help

mike thompson mithomps at redhat.com
Mon Jan 14 16:35:45 UTC 2013


Hi Stefan,

My numbers are: 
1
14242
15081

-- Mike

On Jan 14, 2013, at 6:45 AM, Stefan Negrea <snegrea at redhat.com> wrote:

> 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-devel mailing list
> rhq-devel at lists.fedorahosted.org
> https://lists.fedorahosted.org/mailman/listinfo/rhq-devel



More information about the rhq-devel mailing list