Skip to content

ui: statements page should disambiguate statements based on database #33316

@jordanlewis

Description

@jordanlewis

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:

image

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.

Metadata

Metadata

Assignees

Labels

A-sql-uiWhy is my query slow?A-webuiTriage 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)

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions