Query Cost Leaderboard
GET/api/v1/queries/cost-leaderboard
Top query-cost consumers from dfe.query_log_archive, heaviest first.
Groups by the attribution id (the hunt id for feature='hunts') and returns the query count + summed read rows/bytes + duration + peak memory. Reads the MV the CH wrapper's log_comment attribution feeds - returns [] until it has data.
Request
Responses
- 200
- 401
- 403
- 422
- default
Successful Response
No valid session: the credentials are missing, invalid or expired, or the account behind them is disabled or blocked
Refused: the session lacks the action this route checks, or its account must replace an issued password first. A SCIM route answers a refused action in the RFC 7644 error envelope
Validation Error
Problem details (RFC 9457)