You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Stefan Miklosovic (Jira)" <ji...@apache.org> on 2020/04/25 19:00:02 UTC

[jira] [Updated] (CASSANDRA-15759) Add progress column in percents for system_views.sstable_tasks

     [ 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.
{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
>
> 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}



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

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