[ 
https://issues.apache.org/jira/browse/CASSANDRA-15241?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17564379#comment-17564379
 ] 

Caleb Rackliffe commented on CASSANDRA-15241:
---------------------------------------------

Rebased and kicked off the tests again after making a couple little fixes 
suggested by [~frankgh]. Unless there's any feedback on a better way to do 
[this|https://github.com/apache/cassandra/pull/1704#discussion_r907888112] in 
[TaskFactory|https://github.com/apache/cassandra/pull/1704/files#diff-ea83625365659286d1b6ac9288fe5515a46d5cfc52102293a59130b01ddd9a9aR131],
 I think this is ready to go.

> Virtual table to expose current running queries
> -----------------------------------------------
>
>                 Key: CASSANDRA-15241
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-15241
>             Project: Cassandra
>          Issue Type: New Feature
>          Components: Feature/Virtual Tables
>            Reporter: Chris Lohfink
>            Assignee: Caleb Rackliffe
>            Priority: Normal
>             Fix For: 4.x
>
>          Time Spent: 2h 40m
>  Remaining Estimate: 0h
>
> Expose current running queries and their duration.
> {code}cqlsh> select * from system_views.queries;
>  thread_id                    | duration_micros | task
> ------------------------------+-----------------+---------------------------------------------------------------------------------
>  Native-Transport-Requests-17 |            6325 |                      QUERY 
> select * from system_views.queries; [pageSize = 100]
>   Native-Transport-Requests-4 |           14681 | EXECUTE 
> f4115f91190d4acf09e452637f1f2444 with 0 values at consistency LOCAL_ONE
>   Native-Transport-Requests-6 |           14678 | EXECUTE 
> f4115f91190d4acf09e452637f1f2444 with 0 values at consistency LOCAL_ONE
>                  ReadStage-10 |           16535 |                             
>                SELECT * FROM basic.wide1 LIMIT 5000
>                  ReadStage-13 |           16535 |                             
>                SELECT * FROM basic.wide1 LIMIT 5000
>                  ReadStage-14 |           16535 |                             
>                SELECT * FROM basic.wide1 LIMIT 5000
>                  ReadStage-19 |           11861 |                             
>                SELECT * FROM basic.wide1 LIMIT 5000
>                  ReadStage-20 |           11861 |                             
>                SELECT * FROM basic.wide1 LIMIT 5000
>                  ReadStage-22 |            7279 |                             
>                SELECT * FROM basic.wide1 LIMIT 5000
>                  ReadStage-23 |            4716 |                             
>                SELECT * FROM basic.wide1 LIMIT 5000
>                   ReadStage-5 |           16535 |                             
>                SELECT * FROM basic.wide1 LIMIT 5000
>                   ReadStage-7 |           16535 |                             
>                SELECT * FROM basic.wide1 LIMIT 5000
>                   ReadStage-8 |           16535 |                             
>                SELECT * FROM basic.wide1 LIMIT 5000{code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to