VeloDB Cloud
SQL Manual
Statments
Show-Statements
SHOW-TRASH

SHOW-TRASH

Name

SHOW TRASH

Description

This statement is used to view the garbage data footprint in the backend.

Syntax:

SHOW TRASH [ON BackendHost:BackendHeartBeatPort];

Note:

  1. The Backend format is the node's BackendHost:BackendHeartBeatPort
  2. TrashUsedCapacity indicates the space occupied by the garbage data of the node.

Example

  1. View the space occupied by garbage data of all be nodes.

     SHOW TRASH;
  2. View the space occupied by garbage data of '192.168.0.1:9050' (specific disk information will be displayed).

    SHOW TRASH ON "192.168.0.1:9050";

Keywords

SHOW, TRASH

Best Practice