[ 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