Metrics Collection - Help

Larry O'Leary loleary at redhat.com
Mon Jan 14 15:51:04 UTC 2013


On Mon, 2013-01-14 at 09:45 -0500, Stefan Negrea 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
> 

2
355698
275706

-- 
Larry O'Leary
https://plus.google.com/u/0/112645929986009801513



More information about the rhq-devel mailing list