Add human-readable query identifiers in crdb_internal.statement_statistics and DB Console Statements page

[florence-crl]

Is your feature request related to a problem? Please describe.
In the DB Console SQL Activity->Statements page, there is no unique query identifier in the initial page. When you click into a query, you can see an identifier in the URL, such as http://127.0.0.1:26258/#/statement/true/4705782015019656142?appNames=

In this case 4705782015019656142 is the identifier. When querying crdb_internal.statement_statistics at the main table level there is no identifier that corresponds to 4705782015019656142. The only way to search for a query is using the metadata ->> ‘query’ clause like this:

where metadata ->> 'query' like '%SELECT city, id FROM vehicles WHERE city = $1%'

Sometimes if the full query text as shown in the console is entered, the filter will not find the given query string. You have to use some LIKE condition to find the query string. There are columns fingerprint_id and transaction_fingerprint_id in crdb_internal.statement_statistics but they are BYTE values that are not human-readable.

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

cc: @kevin-v-ngo

Jira issue: CRDB-21417

[maryliag]

This is already possible today. We display the fingerprint id on the overview statement page for that purpose, it's one of the columns (hidden by default). You can select to show the column here:

then copy the value from the column:

then on cli you can look for that fingerprint adding the \x at the start of the value like this:
select * from crdb_internal.statement_statistics where fingerprint_id='\xe56448b12fbe7990';

or encoding the fingerprint column like this:
select * from crdb_internal.statement_statistics where encode(fingerprint_id, 'hex')='e56448b12fbe7990';

Does that work for you @florence-crl ?

[florence-crl]

Thanks @maryliag for the above info and screenshots!

It is not obvious that there are additional column options in that multi-select pop-up. Only because you gave the screenshot above, did I know to scroll down and look for the Statement Fingerprint ID

Initial view of pop-up where scroll bar is not visible. Is there a way to make the scroll bar visible?

After scrolling down to show the additional column options:

Also the docs on the Statements table does not mention the hidden columns, so I did not think of looking for it. I will open a docs issue.

[maryliag]

Unfortunately, the visibility of a scrollbar is not something we can't control on our side, is defined by browser/user. What I can do is increase that size or stop at a point that is mid one of the labels so it indicates that there is more to it.

For the docs, looks like something got missed, because there was an issue for the update on the docs, but shows as closed now, but I don't know what happened: cockroachdb/docs#14960
I can see you created an issue for the docs team, and added more context there, so I'll add the PR there for reference.

[florence-crl]

A user noticed that the Statement Details page has an ID in the URL. In the example URL below, the id is 17122190109225917933

http://127.0.0.1:26258/#/statement/true/17122190109225917933?appNames=

Why is this id different from the Fingerprint ID on the Statements main page?
Also, why is the Fingerprint ID not displayed on the Statement Details page?

[maryliag]

the URL uses the fingerprint id in int64 format and we didn’t show fingerprint on the ui anywhere, so the value didn’t really matter at that point. Now with more people using that value, might be worth changing the url format. That will require a little more work, so can you open a new issue with that request specifically.
I can add the fingerprint in hex format as part of this issue on the details page.