@Statistics
Retrieve various internal statistics that H-Store maintains while executing transactions.
Note that some statistics cannot be retrieved unless certain HStoreConf parameters are enabled (since collecting them incurs additional overhead when processing transactions).
-
TABLE: Information about the amount of memory being used by each table.
-
INDEX: Information about the amount of memory being used by each indexes.
-
IOSTATS: Statistics on the amount of network traffic at each node.
-
MEMORY: Aggregated information about each node’s memory usage.
-
TXNCOUNTER: Transaction counter information (requires site.txn_counters).
-
TXNPROFILER: Transaction profiler information (requires site.txn_profiling).
-
EXECPROFILER: Partition executor profiler information (requires site.exec_profiling).
-
QUEUEPROFILER: Transaction queue manager profiler information (requires site.queue_profiling).
-
MARKOVPROFILER: Markov estimation profiler information (requires site.markov_profiling).
-
SPECEXECPROFILER: Speculative execution profiler information (requires site.specexec_profiling).
-
PLANNERPROFILER: Batch planner profiler information (requires site.planner_profiling).
-
ANTICACHE: Anti-cache manager information (requires site.anticache_profiling).
-
ANTICACHEEVICTIONS: Anti-cache eviction history (requires site.anticache_profiling).
-
ANTICACHEACCESS: Anti-cache evicted access history (requires site.anticache_profiling).
Input Parameters
Name |
Type |
Description |
STATS_TYPE |
String |
The identifier of the type of statistics to retrieve. |
INTERVAL |
int |
What interval to retrive data for. 0 = the latest |
Return Values
Depends on the statistics type.
Java Example
Client client = ClientFactory.createClient();
client = client.createConnection(hostname, port);
String statsType = "TABLE";
int interval = 0;
ClientResponse cresponse = client.callProcedure("@Statistics", statsType, interval); |
Command-Line Example
hstore> EXEC @Statistics TABLE 0 |