I have a 70GIG Bucket. The bucket has the following index.
create PRIMARY INDEX
default USING GSI;
Users can now query the bucket in the Query Workbench.
One user is running The following query:
select * from
default where userID = 2693101;
The query is has been running for the past 30 minutes. The User needs this query to be faster.
I will create the appropriate index and we should be good to go.
I will have multiple case like the above in our testing environment.
I might have multiple users writing all different sorts of queries. Different queries might need all different sorts of indexes.
How can I track which queries are running right now?
How do I track queries that been running for more than 15 minutes, so that I can sit down with the developer and help him out?