Skip to content

SQL Activity - UI/UX improvements #85229

@ericharmeling

Description

@ericharmeling

Here are some suggested UX improvements to the SQL Activity pages:

  • Add an “Application” column on the Statement Fingerprints and Transaction Fingerprints overview pages.
  • The “bar chart” for very low latency times and bytes read, etc are so thin that you can’t really even see them. We should consider removing the charts for values under a specific threshold.
  • When I hover over a column header to read a tooltip, if the tooltip has a link and I move to click the link, the tooltip goes away (unless I precisely move my pointer through the little triangle at the top of the tooltip). I otherwise have to first click the column header, re-sorting the table, to get the tooltip to stay so I can click the link.
  • (related to item above) We should standardize the tooltips we are using across the UI. The ones on the database page look a little nicer and cleaner and don't exhibit the buggy behavior described in the item above, so possibly use those as a template?
  • The SQL box component (used in the Statement Fingerprint details page and several other pages in the DB console) is often too large for the statements in contains. We should update the styling to fit the text.
  • Repeatedly clicking on the Filters dropdown starts selecting the label text of that button:
Screen.Recording.2022-07-28.at.11.22.59.AM.mov
  • Limit the size of statements being displayed. The cases where the statement is really big (the value being added is long, so it can't break line), is creating a really long horizontal scroll. This can be testes running the ledger workload

Screen Shot 2022-07-28 at 2 36 50 PM

  • Some of the columns on the Active Executions (statements and transactions) don't have a tooltip, but they have the tooltip dashed underline. Remove the underline for the columns that don't have tooltip

Jira issue: CRDB-18123

Metadata

Metadata

Assignees

No one assigned

    Labels

    C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions