Deze pagina is nog niet beschikbaar in uw eigen taal. We werken er hard aan om meer taalversies toe te voegen. Bedankt voor uw steun.

GaussDB(DWS)
GaussDB(DWS)

    All results for "" in this service

    Compute
    Elastic Cloud Server
    Bare Metal Server
    Auto Scaling
    Image Management Service
    FunctionGraph
    Management & Governance
    Identity and Access Management
    Cloud Eye
    Resource Formation Service
    Simple Message Notification
    Cloud Trace Service
    Application Operations Management
    Tag Management Service
    Log Tank Service
    Config
    Cloud Ecosystem
    KooGallery
    Partner Center
    User Support
    My Account
    Billing Center
    Cost Center
    My Credentials
    Enterprise Management
    Support Plans
    Partner Support Plans
    Professional Services
    Service Tickets
    Customer Operation Capabilities
    Resource Center
    Security & Compliance
    Web Application Firewall
    Data Encryption Workshop
    Database Security Service
    Data Security Center
    Anti-DDoS
    Host Security Service
    Cloud Firewall
    Cloud Bastion Host
    Cloud Certificate Manager
    SecMaster
    Storage
    Object Storage Service
    Elastic Volume Service
    Cloud Backup and Recovery
    Scalable File Service Turbo
    Scalable File Service
    Databases
    Relational Database Service
    Document Database Service
    Data Replication Service
    Distributed Database Middleware
    GeminiDB
    Data Admin Service
    TaurusDB
    Analytics
    MapReduce Service
    Data Lake Insight
    Cloud Search Service
    GaussDB(DWS)
    DataArts Studio
    Others
    System Permissions
    Common FAQs
    Instructions for Associating with a HUAWEI CLOUD Partner
    Message Center
    Developer Services
    CodeArts
    CodeArts Req
    CodeArts Pipeline
    CodeArts Check
    CodeArts Build
    CodeArts Deploy
    CodeArts TestPlan
    CodeArts Artifact
    CodeArts Repo
    Networking
    Virtual Private Cloud
    Elastic IP
    Elastic Load Balance
    NAT Gateway
    Direct Connect
    Virtual Private Network
    VPC Endpoint
    Global Accelerator
    Enterprise Router
    Cloud Connect
    Migration
    Cloud Data Migration
    Server Migration Service
    Object Storage Migration Service
    AI
    ModelArts
    Graph Engine Service
    Business Applications
    Domain Name Service
    Workspace
    Media Services
    Live
    Containers
    Cloud Container Engine
    SoftWare Repository for Container
    Application Service Mesh
    Middleware
    Distributed Cache Service
    API Gateway
    Distributed Message Service for Kafka
    Distributed Message Service for RocketMQ
    Distributed Message Service for RabbitMQ
    EventGrid
    Developer Tools
    API Request Signing Guide
    Koo Command Line Interface
    Terraform
    Content Delivery & Edge Computing
    Content Delivery Network
    Compute
    Elastic Cloud Server
    Bare Metal Server
    Auto Scaling
    Image Management Service
    FunctionGraph
    Networking
    Virtual Private Cloud
    Elastic IP
    Elastic Load Balance
    NAT Gateway
    Direct Connect
    Virtual Private Network
    VPC Endpoint
    Global Accelerator
    Enterprise Router
    Cloud Connect
    Management & Governance
    Identity and Access Management
    Cloud Eye
    Resource Formation Service
    Simple Message Notification
    Cloud Trace Service
    Application Operations Management
    Tag Management Service
    Log Tank Service
    Config
    Migration
    Cloud Data Migration
    Server Migration Service
    Object Storage Migration Service
    Cloud Ecosystem
    KooGallery
    Partner Center
    AI
    ModelArts
    Graph Engine Service
    User Support
    My Account
    Billing Center
    Cost Center
    My Credentials
    Enterprise Management
    Support Plans
    Partner Support Plans
    Professional Services
    Service Tickets
    Customer Operation Capabilities
    Resource Center
    Business Applications
    Domain Name Service
    Workspace
    Security & Compliance
    Web Application Firewall
    Data Encryption Workshop
    Database Security Service
    Data Security Center
    Anti-DDoS
    Host Security Service
    Cloud Firewall
    Cloud Bastion Host
    Cloud Certificate Manager
    SecMaster
    Media Services
    Live
    Storage
    Object Storage Service
    Elastic Volume Service
    Cloud Backup and Recovery
    Scalable File Service Turbo
    Scalable File Service
    Containers
    Cloud Container Engine
    SoftWare Repository for Container
    Application Service Mesh
    Databases
    Relational Database Service
    Document Database Service
    Data Replication Service
    Distributed Database Middleware
    GeminiDB
    Data Admin Service
    TaurusDB
    Middleware
    Distributed Cache Service
    API Gateway
    Distributed Message Service for Kafka
    Distributed Message Service for RocketMQ
    Distributed Message Service for RabbitMQ
    EventGrid
    Analytics
    MapReduce Service
    Data Lake Insight
    Cloud Search Service
    GaussDB(DWS)
    DataArts Studio
    Developer Tools
    API Request Signing Guide
    Koo Command Line Interface
    Terraform
    Others
    System Permissions
    Common FAQs
    Instructions for Associating with a HUAWEI CLOUD Partner
    Message Center
    Content Delivery & Edge Computing
    Content Delivery Network
    Developer Services
    CodeArts
    CodeArts Req
    CodeArts Pipeline
    CodeArts Check
    CodeArts Build
    CodeArts Deploy
    CodeArts TestPlan
    CodeArts Artifact
    CodeArts Repo

      All results for "" in this service

      On this page

      Show all

      Help Center/ GaussDB(DWS)/ Standard Data Warehouse (8.1.3.x)/ GaussDB(DWS) System Catalogs and Views/ System Views/ GLOBAL_TABLE_STAT

      GLOBAL_TABLE_STAT

      Updated on 2024-12-19 GMT+08:00
      View PDF

      GLOBAL_TABLE_STAT displays statistics about all tables (excluding foreign tables) in the current database. The values of live_tuples and dead_tuples are real-time values, and the values of other statistical columns are accumulated values since the instance was started.

      Table 1 GLOBAL_TABLE_STAT columns

      Name

      Type

      Description

      schemaname

      name

      Namespace of a table

      relname

      name

      Table name

      distribute_mode

      char

      Distribution mode of a table. The meaning of this column is the same as that of the pclocatortype column in the pgxc_class system catalog.

      seq_scan

      bigint

      Number of sequential scans. It is counted only for row-store tables. For a partitioned table, the sum of the number of scans of each partition is displayed.

      seq_tuple_read

      bigint

      Number of rows scanned in sequence. It is counted only for row-store tables.

      index_scan

      bigint

      Number of index scans. It is counted only for row-store tables.

      index_tuple_read

      bigint

      Number of rows scanned by the index. It is counted only for row-store tables.

      tuple_inserted

      bigint

      Number of rows inserted. For a replication table, the maximum value of each node is displayed. For a distribution table, the sum of all nodes is displayed.

      tuple_updated

      bigint

      Number of rows updated. For a replication table, the maximum value of each node is displayed. For a distribution table, the sum of all nodes is displayed.

      tuple_deleted

      bigint

      Number of rows deleted. For a replication table, the maximum value of each node is displayed. For a distribution table, the sum of all nodes is displayed.

      tuple_hot_updated

      bigint

      Number of rows with HOT updates. For a replication table, the maximum value of each node is displayed. For a distribution table, the sum of all nodes is displayed.

      live_tuples

      bigint

      Number of live tuples. The maximum value of each node is displayed. For a distribution table, the sum of all nodes is displayed.

      This indicator applies only to row-store tables.

      dead_tuples

      bigint

      Number of dead tuples. The maximum value of each node is displayed. For a distribution table, the sum of all nodes is displayed.

      This indicator applies only to row-store tables.
      Parent topic: System Views
      Feedback

      Feedback

      Feedback

      0/500

      Selected Content

      Submit selected content with the feedback