[ 
https://issues.apache.org/jira/browse/CASSANDRA-15759?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Stefan Miklosovic updated CASSANDRA-15759:
------------------------------------------
    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]

 
{code:java}
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
{code}

  was:
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.
{code:java}
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
{code}


> Add progress column in percents for system_views.sstable_tasks
> --------------------------------------------------------------
>
>                 Key: CASSANDRA-15759
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-15759
>             Project: Cassandra
>          Issue Type: Improvement
>          Components: Feature/Virtual Tables
>            Reporter: Stefan Miklosovic
>            Priority: Normal
>          Time Spent: 10m
>  Remaining Estimate: 0h
>
> 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]
>  
> {code:java}
> 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
> {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

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

Reply via email to