Github user rahulsIOT commented on the issue:
https://github.com/apache/phoenix/pull/242
Metrics Snippet
**Statement Level -**
{"Statement-OverAllReadRequestMetrics":{"RESULT_SET_TIME_MS":22,"QUERY_FAILED_COUNTER":0,"QUERY_TIMEOUT_COUNTER":0,"WALL_CLOCK_TIME_MS":52,"CACHE_REFRESH_SPLITS_COUNTER":0,"NUM_PARALLEL_SCANS":1}}
{"Statement-RequestReadMetrics":{"QUERYSERVERBASICSIT1494892379503":{"TASK_QUEUE_WAIT_TIME":0,"SCAN_BYTES":208,"TASK_END_TO_END_TIME":10,"TASK_EXECUTED_COUNTER":1,"TASK_EXECUTION_TIME":10,"TASK_REJECTED_COUNTER":0}}}
**Global Metrics -**
{"global":[{"numberOfSamples":0,"description":"Batch sizes of
mutations","currentMetricState":"MUTATION_BATCH_SIZE: 0, Number of samples:
0","totalSum":0,"name":"MUTATION_BATCH_SIZE","value":0},{"numberOfSamples":0,"description":"Size
of mutations in bytes","currentMetricState":"MUTATION_BYTES: 0, Number of
samples:
0","totalSum":0,"name":"MUTATION_BYTES","value":0},{"numberOfSamples":0,"description":"Time
it took to commit mutations","currentMetricState":"MUTATION_COMMIT_TIME: 0,
Number of samples:
0","totalSum":0,"name":"MUTATION_COMMIT_TIME","value":0},{"numberOfSamples":7,"description":"Query
times","currentMetricState":"QUERY_TIME: 52, Number of samples:
7","totalSum":52,"name":"QUERY_TIME","value":52},{"numberOfSamples":11,"description":"Number
of scans that were executed in
parallel","currentMetricState":"NUM_PARALLEL_SCANS: 11, Number of samples:
11","totalSum":11,"name":"NUM_PARALLEL_SCANS","value":11},{"numberOfSamples":2,"description":"Number
of bytes read by scans","c
urrentMetricState":"SCAN_BYTES: 192, Number of samples:
2","totalSum":192,"name":"SCAN_BYTES","value":192},{"numberOfSamples":0,"description":"Size
of spool files created in bytes","currentMetricState":"SPOOL_FILE_SIZE: 0,
Number of samples:
0","totalSum":0,"name":"SPOOL_FILE_SIZE","value":0},{"numberOfSamples":0,"description":"Number
of bytes allocated by the memory
manager","currentMetricState":"MEMORY_CHUNK_BYTES: 0, Number of samples:
0","totalSum":0,"name":"MEMORY_CHUNK_BYTES","value":0},{"numberOfSamples":0,"description":"Number
of milliseconds threads needed to wait for memory to be allocated through
memory manager","currentMetricState":"MEMORY_WAIT_TIME: 0, Number of samples:
0","totalSum":0,"name":"MEMORY_WAIT_TIME","value":0},{"numberOfSamples":11,"description":"Time
in milliseconds tasks had to wait in the queue of the thread pool
executor","currentMetricState":"TASK_QUEUE_WAIT_TIME: 5, Number of samples:
11","totalSum":5,"name":"TASK_QUEUE_WAIT_TIME","value":5},{"numberO
fSamples":11,"description":"Time in milliseconds spent by tasks from creation
to completion","currentMetricState":"TASK_END_TO_END_TIME: 139, Number of
samples:
11","totalSum":139,"name":"TASK_END_TO_END_TIME","value":139},{"numberOfSamples":11,"description":"Time
in milliseconds tasks took to
execute","currentMetricState":"TASK_EXECUTION_TIME: 134, Number of samples:
11","totalSum":134,"name":"TASK_EXECUTION_TIME","value":134},{"numberOfSamples":99,"description":"Counter
for number of mutation sql
statements","currentMetricState":"MUTATION_SQL_COUNTER: 99, Number of samples:
99","totalSum":99,"name":"MUTATION_SQL_COUNTER","value":99},{"numberOfSamples":7,"description":"Counter
for number of sql queries","currentMetricState":"SELECT_SQL_COUNTER: 7, Number
of samples:
7","totalSum":7,"name":"SELECT_SQL_COUNTER","value":7},{"numberOfSamples":11,"description":"Counter
for number of tasks submitted to the thread pool
executor","currentMetricState":"TASK_EXECUTED_COUNTER: 11, Number of s
amples:
11","totalSum":11,"name":"TASK_EXECUTED_COUNTER","value":11},{"numberOfSamples":0,"description":"Counter
for number of tasks that were rejected by the thread pool
executor","currentMetricState":"TASK_REJECTED_COUNTER: 0, Number of samples:
0","totalSum":0,"name":"TASK_REJECTED_COUNTER","value":0},{"numberOfSamples":0,"description":"Number
of times query timed out","currentMetricState":"QUERY_TIMEOUT_COUNTER: 0,
Number of samples:
0","totalSum":0,"name":"QUERY_TIMEOUT_COUNTER","value":0},{"numberOfSamples":0,"description":"Number
of times query failed","currentMetricState":"QUERY_FAILED_COUNTER: 0, Number
of samples:
0","totalSum":0,"name":"QUERY_FAILED_COUNTER","value":0},{"numberOfSamples":0,"description":"Number
of spool files created","currentMetricState":"SPOOL_FILE_COUNTER: 0, Number of
samples:
0","totalSum":0,"name":"SPOOL_FILE_COUNTER","value":0},{"numberOfSamples":14,"description":"Number
of open phoenix connections","currentMetricState":"OPEN_PHOENIX_CONNECTIONS_CO
UNTER: 0, Number of samples:
14","totalSum":0,"name":"OPEN_PHOENIX_CONNECTIONS_COUNTER","value":0},{"numberOfSamples":1,"description":"Number
of ConnectionQueryServicesImpl
instantiated","currentMetricState":"QUERY_SERVICES_COUNTER: 1, Number of
samples:
1","totalSum":1,"name":"QUERY_SERVICES_COUNTER","value":1},{"numberOfSamples":1,"description":"Number
of HConnections created by phoenix
driver","currentMetricState":"HCONNECTIONS_COUNTER: 1, Number of samples:
1","totalSum":1,"name":"HCONNECTIONS_COUNTER","value":1}]}
Global Metrics is also exposed via JMX. ( screen shot attached)
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
