How to check select , update , insert & delete operation on Particular database in CRDB

Hi Dears,

How to check select , update, insert & delete operation on Particular database.

Please guide me how to check which database consuming more operation !!

Thanks
Raj

It sounds like you may wanting the information on the Statements page to see what kinds of queries are running in your cluster. You posted an image from the Hardware Dashboard, so if you want a time series view of your queries, perhaps you mind find the SQL Queries chart on the SQL Dashboard more helpful.

Thanks & sorry for the wrong image.

This image showing cluster level , How to check select, update, insert & delete operation on a Particular database ,

V19.2

Thanks
Raj

This isn’t currently possible right now, but is something we are discussing supporting. Thanks for the question. It is helpful to the team to hear these kinds of feature requests.

1 Like

Hi @nathastilwell ,

Thanks for the reply.

Any other way to find this select, update, insert & delete operation on a particular database,

Because a particular node consuming more than 60-70% of CPU.

Thanks,
Raj

From reading the issue I linked above, the current thinking is that it is more useful to filter the transactions by application_name rather than by database. See this comment for more explanation.

1 Like