[
https://issues.apache.org/jira/browse/CASSANDRA-15241?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17039943#comment-17039943
]
Benedict Elliott Smith commented on CASSANDRA-15241:
----------------------------------------------------
I've pushed some tiny nits
[here|https://github.com/belliottsmith/cassandra/tree/15241-nits]
I'd also quite like to either switch to reporting _both_ queued time and
running time, or just a consistent one of the two. I don't mind hacking that
in, as it's a very simple change. Since we're mostly using {{approxTime}} the
extra overhead is close to zero for NTR tasks to grab this as well; in fact we
could probably reduce it by simply using {{approxTime}} for both, instead of
{{nanoTime}} for start as we do today (plenty sufficient for timeouts).
Alternatively we could just start reporting time, including queued time, for
{{LocalReadRunnable}} and {{LocalMutationRunnable}} for free today, since the
info is already there.
Any of the above works for me, but I would really like us to be consistent if
that's ok by you? Otherwise we'll always be code diving to figure out if a
quoted number includes queued or not.
> 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]
