Documentation > System Stored Procedures > @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