Skip to main content
Skip to main content

Show Table Data Action

Show Table Data Action

Request​

GET /api/show_table_data

Description​

Used to get the data size of all tables in all databases under all internal catalog, or the data size of the specified database or table. Unit byte.

Path parameters​

NULL

Query parameters​

  • db

    Optional. If specified, get the data size of the tables under the specified database.

  • table

    Optional. If specified, get the data size of the specified table.

  • single_replica

    Optional. If specified, get the data size of the single replica of the table.

Request body​

NULL

Response​

  1. The data size of all tables in the specified database.

    {
    "msg":"success",
    "code":0,
    "data":{
    "tpch":{
    "partsupp":9024548244,
    "revenue0":0,
    "customer":1906421482
    }
    },
    "count":0
    }
  2. The data size of the specified table of the specified db.

    {
    "msg":"success",
    "code":0,
    "data":{
    "tpch":{
    "partsupp":9024548244
    }
    },
    "count":0
    }
  3. The data size of the single replica of the specified table of the specified db.

    {
    "msg":"success",
    "code":0,
    "data":{
    "tpch":{
    "partsupp":3008182748
    }
    },
    "count":0
    }

Examples​

  1. The data size of all tables in the specified database.

    GET /api/show_table_data?db=tpch

    Response:
    {
    "msg":"success",
    "code":0,
    "data":{
    "tpch":{
    "partsupp":9024548244,
    "revenue0":0,
    "customer":1906421482
    }
    },
    "count":0
    }
  2. The data size of the specified table of the specified db.

    GET /api/show_table_data?db=tpch&table=partsupp

    Response:
    {
    "msg":"success",
    "code":0,
    "data":{
    "tpch":{
    "partsupp":9024548244
    }
    },
    "count":0
    }
  3. The data size of the single replica of the specified table of the specified db.

    GET /api/show_table_data?db=tpch&table=partsupp&single_replica=true

    Response:
    {
    "msg":"success",
    "code":0,
    "data":{
    "tpch":{
    "partsupp":3008182748
    }
    },
    "count":0
    }