cockroach icon indicating copy to clipboard operation
cockroach copied to clipboard

ui: obtain redacted statement diagnostics bundles from the DB console

Open michae2 opened this issue 1 year ago • 2 comments

In 23.1 we added the ability to collect redacted statement diagnostics bundles using EXPLAIN ANALYZE (DEBUG, REDACT) which was tracked by https://github.com/cockroachdb/cockroach/issues/68570 and https://github.com/cockroachdb/cockroach/issues/98817.

In order to make collection of these redacted bundles easier, we should add a redaction option to the DB console's existing UI for bundle collection.

We should probably also add a redaction option to crdb_internal.request_statement_bundle().

Jira issue: CRDB-35994

Epic CRDB-37557

michae2 avatar Feb 10 '24 01:02 michae2

In 23.1 we also added:

  • redacted query plans using EXPLAIN (REDACT)
  • redacted create statements using SHOW CREATE ... WITH REDACT

Maybe these should also be exposed through the DB console somehow?

michae2 avatar Feb 10 '24 01:02 michae2

#123859 made all the necessary changes to the backend (added new overloads to crdb_internal.request_statement_bundle builtin as well as extended the server API). The remaining work is left on the frontend side of things will be tackled by the Observability team (currently planned for second half of the year), so I'm removing this from the Queries board.

yuzefovich avatar May 15 '24 20:05 yuzefovich