Documentation > System Stored Procedures > @Statistics

@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

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