# SHOW GC STATUS

Shows the status of the Garbage Collection (GC) (The process where unneeded versioned nodes for multi-version concurrency control (MVCC) are eliminated. These versioned nodes may be part of skip list indexes or hash indexes for in-memory rowstore tables or columnstore segments stored in memory.) object.

## Syntax

```sql
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

```sql
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)

```

***

Modified at: February 8, 2024

Source: [/db/v9.1/reference/sql-reference/show-commands/show-gc-status/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/show-commands/show-gc-status/)

(An index of the documentation is available at /llms.txt)