[
https://issues.apache.org/jira/browse/CASSANDRA-15241?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16934957#comment-16934957
]
Chris Lohfink commented on CASSANDRA-15241:
-------------------------------------------
Examples:
{code}
Native-Transport-Requests-17 | 6325 | QUERY SELECT * FROM
system_views.queries; WITH pageSize = 100 AT CONSISTENCY ONE
Native-Transport-Requests-4 | 14681 | EXECUTE INSERT INTO tbl (key,
val) VALUES (?, ?) WITH [0x00, 'str'] AT CONSISTENCY ONE
Native-Transport-Requests-6 | 14678 | LOGGED BATCH of [INSERT INTO
tbl2 (key, val) VALUES (0x00 0x00), INSERT INTO tbl2 (key, val) VALUES (?, ?)
WITH [0x00 0x00]] AT CONSISTENCY ONE
ReadStage-10 | 16535 |
SELECT * FROM keyspace.table LIMIT 5000
MutationStage-7 | 1 |
Mutation(keyspace='basic2', key='01',
modifications=[\n [basic2.wide1] key=01
partition_deletion=deletedAt=-9223372036854775808, localDeletion=2147483647
columns=[[] | [data]]\n Row[info=[ts=1569043995960100] ]: id=01 | [data=01
ts=1569043995960100]\n])
{code}
> 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: Chris Lohfink
> Priority: Normal
>
> 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.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
