Skip to content

cacheStats ​

Command: cacheStats
Category: System Tools
Status: Production Ready

Description ​

This page exists for the /cache-contents route. Use cacheStats to view SQL plan cache and result cache statistics.

Syntax ​

bash
hana-cli cacheStats [options]

Command Diagram ​

Aliases ​

  • No aliases

Parameters ​

Options ​

OptionAliasTypeDefaultDescription
--cacheType-tstringallCache type to query. Choices: plan, result, all
--limit-lnumber50Maximum rows returned per cache query

For complete option output, use:

bash
hana-cli cacheStats --help

Examples ​

Basic Usage ​

bash
hana-cli cacheStats --cacheType all

View SQL plan cache and result cache statistics

See the Commands Reference for other commands in this category.

See Also ​