JMX
Synopsis
SELECT * FROM jmx.current."table_name";
Description
All JMX metrics are stored as tables in schema current
of catalog jmx
. table_name
must be put in quotation mark.
Users need to find the table corresponding to the jmx metrics first, and then run SELECT
queries to view these metrics.
Examples
View row data cache stats:
SELECT * FROM jmx.current."io.prestosql.orc:name=hive,type=rowdatacachestatslister";
View bloom filter cache stats:
SELECT * FROM jmx.current."io.prestosql.orc:name=hive,type=bloomfiltercachestatslister";