You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Chris Lohfink (JIRA)" <ji...@apache.org> on 2019/07/21 18:47:00 UTC

[jira] [Created] (CASSANDRA-15241) Virtual table to expose current running queries

Chris Lohfink created CASSANDRA-15241:
-----------------------------------------

             Summary: 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


Expose current running queries and their duration.


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





--
This message was sent by Atlassian JIRA
(v7.6.14#76016)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org