Metrics Collection - Help

Stefan Negrea snegrea at redhat.com
Mon Jan 14 14:45:56 UTC 2013


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



More information about the rhq-devel mailing list