bw_query_statistics
Read SAP BW query runtime statistics (RSDDSTAT) without SAP GUI: execution counts, users, runtimes, runtime outliers, or step_uid navigation-step layer breakdown.
Instructions
Read the BW query statistics (RSDDSTAT) of any frontend, as RSRT statistics and ST03 show them, without SAP GUI. With query_name or provider: the executions in a time window (default the last 24 hours) — count, the last execution and its user, executions per user, min / median / p90 / max runtime (over the latest 5,000 when there are more), plus the breakdown of the slowest ones. With step_uid: one navigation step in full — BW runtime by layer, top events, records read and transferred, the effective "Operations in SAP HANA" setting and the data manager time per provider. Statistics must be switched on for the object (transaction RSDDSTAT). To measure one call of this server, use bw_query_data with_statistics instead.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| to | No | End of the window (default now). | |
| from | No | Start of the window, ISO date or timestamp (UTC unless an offset is given). | |
| hours | No | Window length when from is not given (default 24). | |
| slowest | No | How many of the slowest executions to break down (default 3, at most 10, 0 for none). | |
| provider | No | InfoProvider queried directly, as bw_query_data with is_provider does (e.g. "PROVIDER_NAME"). | |
| step_uid | No | One navigation step, as shown in an earlier answer. | |
| query_name | No | Query whose executions to read (e.g. "QUERY_NAME"). |