SHOW GC STATUS
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
Shows the status of the Garbage Collection (GC) object.
Syntax
SHOW GC STATUS;
Output
|
Column |
Description |
|---|---|
|
WorkerID |
ID of the thread (default number of threads is 2) |
|
Table |
Shows the tables GC is running on. |
|
Index |
Shows the index of the tables. |
|
Operation |
Operation status. |
|
Elapsed(ms) |
The amount of time the GC has taken to run. |
|
Progress% |
The percentage completed. |
Example
singlestore> SHOW GC STATUS;+-----------+-------+-------+-----------+--------------+------------+| Worker ID | Table | Index | Operation | Elapsed (ms) | Progress % |+-----------+-------+-------+-----------+--------------+------------+| 0 | NULL | NULL | NULL | NULL | NULL || 1 | NULL | NULL | NULL | NULL | NULL |+-----------+-------+-------+-----------+--------------+------------+2 rows in set (0.00 sec)
Last modified: February 8, 2024