[CASSANDRA-15759] Add progress column in percents for system_views.sstable_tasks

• Type: Improvement
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 4.0-beta1, 4.0
• Component/s: Feature/Virtual Tables
• Change Category: Operability
• Complexity: Normal
• Platform: All

Source Control Link

38f5f9caccabee2601ca5e95884d83857d22bf33

Test and Documentation Plan

    

• Assignee: Stefan Miklosovic
• Reporter: Stefan Miklosovic

Authors

Stefan Miklosovic

Reviewers

Aleksey Yeschenko

• Created: 25/Apr/20 18:58
• Updated: 27/Sep/21 13:40
• Resolved: 28/May/20 14:31

Description

It would be very handy to have a percentage column in system_views.sstable_tasks which would say how far a respective task is.

Indeed, there are currently "progress" and "total" columns but honestly, for every day usage, it is rather strange to expect that humans will divide these numbers in head if they want to roughly know what the overall progress is. One just does not have a rough estimation of the task progress when he is presented with two quite big numbers and to estimate the progress from the. 

In the following output, the field "progress_in_percents" is introduced.

 

PR is here https://github.com/apache/cassandra/pull/566

 

admin@cqlsh> select * from system_views.sstable_tasks ;

@ Row 1
-----------------------+--------------------------------------
 keyspace_name         | mykeyspace
 table_name            | mytable
 task_id               | 0db5d9b1-8726-11ea-8a6c-b92f3be367bb
 kind                  | secondary index build
 progress              | 19456965
 progress_in_percents  | 8.17
 total                 | 238208674
 unit                  | bytes

@ Row 2
----------------------+--------------------------------------
 keyspace_name        | mykeyspace
 table_name           | mytable.mytable_surname_idx
 task_id              | 1817ee71-8726-11ea-8a6c-b92f3be367bb
 kind                 | compaction
 progress             | 284396233
 progress_in_percents | 75.92
 total                | 374598446
 unit                 | bytes

Issue Links

• is related to: CASSANDRA-15406 Show the progress of data streaming and index build
• is related to: CASSANDRA-16976 Make nodetool compactionstats and sstable_tasks consistent