@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 |