-
Notifications
You must be signed in to change notification settings - Fork 4.1k
ui: statements page should disambiguate statements based on database #33316
Copy link
Copy link
Closed
cockroachdb/ui
#294Labels
A-sql-uiWhy is my query slow?Why is my query slow?A-webuiTriage label for DB Console (fka admin UI) issues. Add this if nothing else is clear.Triage label for DB Console (fka admin UI) issues. Add this if nothing else is clear.C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)
Description
Currently, statements on the statement page do not seem to be bucketed by database. This makes it impossible to distinguish whether a statement on a table is from one database or another.
Repro:
root@127.0.0.1:56758/defaultdb> create table a (a int primary key);
CREATE TABLE
Time: 6.559ms
root@127.0.0.1:56758/defaultdb> insert into a values(1);
INSERT 1
Time: 5.411ms
root@127.0.0.1:56758/defaultdb> create database foo;
CREATE DATABASE
Time: 4.107ms
root@127.0.0.1:56758/defaultdb> use foo;
SET
Time: 402µs
root@127.0.0.1:56758/foo> create table a (a int primary key);
CREATE TABLE
Time: 5.812ms
root@127.0.0.1:56758/foo> insert into a values(1);
INSERT 1
Time: 6.249ms
Actual result:
Expected: the two INSERT statements should not be in the same bucket, since they're on different tables, despite the tables having the same name.
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
A-sql-uiWhy is my query slow?Why is my query slow?A-webuiTriage label for DB Console (fka admin UI) issues. Add this if nothing else is clear.Triage label for DB Console (fka admin UI) issues. Add this if nothing else is clear.C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)
