Esta página ainda não está disponível no idioma selecionado. Estamos trabalhando para adicionar mais opções de idiomas. Agradecemos sua compreensão.

GaussDB(DWS)
GaussDB(DWS)

    All results for "" in this service

    Compute
    Elastic Cloud Server
    Huawei Cloud Flexus
    Bare Metal Server
    Auto Scaling
    Image Management Service
    Dedicated Host
    FunctionGraph
    Cloud Phone Host
    Huawei Cloud EulerOS
    Management & Governance
    Cloud Eye
    Identity and Access Management
    Cloud Trace Service
    Resource Formation Service
    Tag Management Service
    Log Tank Service
    Config
    OneAccess
    Resource Access Manager
    Simple Message Notification
    Application Performance Management
    Application Operations Management
    Organizations
    Optimization Advisor
    IAM Identity Center
    Cloud Operations Center
    Resource Governance Center
    Cloud Ecosystem
    KooGallery
    Partner Center
    Analytics
    MapReduce Service
    Data Lake Insight
    CloudTable Service
    Cloud Search Service
    Data Lake Visualization
    Data Ingestion Service
    GaussDB(DWS)
    DataArts Studio
    Data Lake Factory
    DataArts Lake Formation
    Others
    Product Pricing Details
    System Permissions
    Console Quick Start
    Common FAQs
    Instructions for Associating with a HUAWEI CLOUD Partner
    Message Center
    Blockchain
    Blockchain Service
    Web3 Node Engine Service
    Storage
    Object Storage Service
    Elastic Volume Service
    Cloud Backup and Recovery
    Storage Disaster Recovery Service
    Scalable File Service Turbo
    Scalable File Service
    Volume Backup Service
    Cloud Server Backup Service
    Data Express Service
    Dedicated Distributed Storage Service
    Databases
    Relational Database Service
    Document Database Service
    Data Admin Service
    Data Replication Service
    GeminiDB
    GaussDB
    Distributed Database Middleware
    Database and Application Migration UGO
    TaurusDB
    Dedicated Cloud
    Dedicated Computing Cluster
    AI
    Face Recognition Service
    Graph Engine Service
    Content Moderation
    Image Recognition
    Optical Character Recognition
    ModelArts
    ImageSearch
    Conversational Bot Service
    Speech Interaction Service
    Huawei HiLens
    Video Intelligent Analysis Service
    Content Delivery & Edge Computing
    Content Delivery Network
    Intelligent EdgeFabric
    CloudPond
    Intelligent EdgeCloud
    Developer Services
    ServiceStage
    CodeArts
    CodeArts PerfTest
    CodeArts Req
    CodeArts Pipeline
    CodeArts Build
    CodeArts Deploy
    CodeArts Artifact
    CodeArts TestPlan
    CodeArts Check
    CodeArts Repo
    Cloud Application Engine
    Networking
    Virtual Private Cloud
    Elastic IP
    Elastic Load Balance
    NAT Gateway
    Direct Connect
    Virtual Private Network
    VPC Endpoint
    Cloud Connect
    Enterprise Router
    Enterprise Switch
    Global Accelerator
    Migration
    Server Migration Service
    Object Storage Migration Service
    Cloud Data Migration
    Migration Center
    User Support
    My Account
    Billing Center
    Cost Center
    Resource Center
    Enterprise Management
    Service Tickets
    HUAWEI CLOUD (International) FAQs
    ICP Filing
    Support Plans
    My Credentials
    Customer Operation Capabilities
    Partner Support Plans
    Professional Services
    IoT
    IoT Device Access
    Security & Compliance
    Security Technologies and Applications
    Web Application Firewall
    Host Security Service
    Cloud Firewall
    SecMaster
    Anti-DDoS Service
    Data Encryption Workshop
    Database Security Service
    Cloud Bastion Host
    Data Security Center
    Cloud Certificate Manager
    Edge Security
    Managed Threat Detection
    Media Services
    Media Processing Center
    Video On Demand
    Live
    SparkRTC
    MetaStudio
    Containers
    Cloud Container Engine
    SoftWare Repository for Container
    Application Service Mesh
    Ubiquitous Cloud Native Service
    Cloud Container Instance
    Middleware
    Distributed Cache Service
    API Gateway
    Distributed Message Service for Kafka
    Distributed Message Service for RabbitMQ
    Distributed Message Service for RocketMQ
    Cloud Service Engine
    Multi-Site High Availability Service
    EventGrid
    Business Applications
    Workspace
    ROMA Connect
    Message & SMS
    Domain Name Service
    Edge Data Center Management
    Meeting
    Developer Tools
    SDK Developer Guide
    API Request Signing Guide
    Terraform
    Koo Command Line Interface
    Solutions
    SAP Cloud
    High Performance Computing
    MacroVerse aPaaS
    KooMessage
    KooPhone
    KooDrive
    Compute
    Elastic Cloud Server
    Huawei Cloud Flexus
    Bare Metal Server
    Auto Scaling
    Image Management Service
    Dedicated Host
    FunctionGraph
    Cloud Phone Host
    Huawei Cloud EulerOS
    Networking
    Virtual Private Cloud
    Elastic IP
    Elastic Load Balance
    NAT Gateway
    Direct Connect
    Virtual Private Network
    VPC Endpoint
    Cloud Connect
    Enterprise Router
    Enterprise Switch
    Global Accelerator
    Management & Governance
    Cloud Eye
    Identity and Access Management
    Cloud Trace Service
    Resource Formation Service
    Tag Management Service
    Log Tank Service
    Config
    OneAccess
    Resource Access Manager
    Simple Message Notification
    Application Performance Management
    Application Operations Management
    Organizations
    Optimization Advisor
    IAM Identity Center
    Cloud Operations Center
    Resource Governance Center
    Migration
    Server Migration Service
    Object Storage Migration Service
    Cloud Data Migration
    Migration Center
    Cloud Ecosystem
    KooGallery
    Partner Center
    User Support
    My Account
    Billing Center
    Cost Center
    Resource Center
    Enterprise Management
    Service Tickets
    HUAWEI CLOUD (International) FAQs
    ICP Filing
    Support Plans
    My Credentials
    Customer Operation Capabilities
    Partner Support Plans
    Professional Services
    Analytics
    MapReduce Service
    Data Lake Insight
    CloudTable Service
    Cloud Search Service
    Data Lake Visualization
    Data Ingestion Service
    GaussDB(DWS)
    DataArts Studio
    Data Lake Factory
    DataArts Lake Formation
    IoT
    IoT Device Access
    Others
    Product Pricing Details
    System Permissions
    Console Quick Start
    Common FAQs
    Instructions for Associating with a HUAWEI CLOUD Partner
    Message Center
    Security & Compliance
    Security Technologies and Applications
    Web Application Firewall
    Host Security Service
    Cloud Firewall
    SecMaster
    Anti-DDoS Service
    Data Encryption Workshop
    Database Security Service
    Cloud Bastion Host
    Data Security Center
    Cloud Certificate Manager
    Edge Security
    Managed Threat Detection
    Blockchain
    Blockchain Service
    Web3 Node Engine Service
    Media Services
    Media Processing Center
    Video On Demand
    Live
    SparkRTC
    MetaStudio
    Storage
    Object Storage Service
    Elastic Volume Service
    Cloud Backup and Recovery
    Storage Disaster Recovery Service
    Scalable File Service Turbo
    Scalable File Service
    Volume Backup Service
    Cloud Server Backup Service
    Data Express Service
    Dedicated Distributed Storage Service
    Containers
    Cloud Container Engine
    SoftWare Repository for Container
    Application Service Mesh
    Ubiquitous Cloud Native Service
    Cloud Container Instance
    Databases
    Relational Database Service
    Document Database Service
    Data Admin Service
    Data Replication Service
    GeminiDB
    GaussDB
    Distributed Database Middleware
    Database and Application Migration UGO
    TaurusDB
    Middleware
    Distributed Cache Service
    API Gateway
    Distributed Message Service for Kafka
    Distributed Message Service for RabbitMQ
    Distributed Message Service for RocketMQ
    Cloud Service Engine
    Multi-Site High Availability Service
    EventGrid
    Dedicated Cloud
    Dedicated Computing Cluster
    Business Applications
    Workspace
    ROMA Connect
    Message & SMS
    Domain Name Service
    Edge Data Center Management
    Meeting
    AI
    Face Recognition Service
    Graph Engine Service
    Content Moderation
    Image Recognition
    Optical Character Recognition
    ModelArts
    ImageSearch
    Conversational Bot Service
    Speech Interaction Service
    Huawei HiLens
    Video Intelligent Analysis Service
    Developer Tools
    SDK Developer Guide
    API Request Signing Guide
    Terraform
    Koo Command Line Interface
    Content Delivery & Edge Computing
    Content Delivery Network
    Intelligent EdgeFabric
    CloudPond
    Intelligent EdgeCloud
    Solutions
    SAP Cloud
    High Performance Computing
    Developer Services
    ServiceStage
    CodeArts
    CodeArts PerfTest
    CodeArts Req
    CodeArts Pipeline
    CodeArts Build
    CodeArts Deploy
    CodeArts Artifact
    CodeArts TestPlan
    CodeArts Check
    CodeArts Repo
    Cloud Application Engine
    MacroVerse aPaaS
    KooMessage
    KooPhone
    KooDrive

      All results for "" in this service

      On this page

      Show all

      Help Center/ GaussDB(DWS)/ Developer Guide/ Standard data warehouse (9.1.0.x)/ GaussDB(DWS) System Catalogs and Views/ System Views/ PGXC_AIO_RESOURCE_POOL_STATS

      PGXC_AIO_RESOURCE_POOL_STATS

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

      PGXC_AIO_RESOURCE_POOL_STATS queries the status of the asynchronous I/O resource pool usage for all nodes in the cluster. This includes the node name, the name of the asynchronous I/O resource type, the number of asynchronous I/O resources in use, and the number of idle asynchronous I/O resources. This view is supported only by 9.1.0.100 and later cluster versions.

      Table 1 PGXC_AIO_RESOURCE_POOL_STATS columns

      Column

      Type

      Description

      node_name

      Text

      Node name.

      resource_name

      Text

      Asynchronous I/O resource type. The options are:

      • ASYNC_CONTEXT_TYPE: Asynchronous context resource in the FPT (Future-Promise-Then) framework, at the thread level.
      • DISK_CACHE_CACHE_BLOCK_TYPE: Instance of disk cache granularity block.
      • DISK_CACHE_PATH_MANAGER_TYPE: Cache path manager in the disk cache, at the thread level.
      • FUTURE_STATE_TYPE: Shared state FutureState of Future and Promise in the FPT framework.
      • FUTURE_TYPE: Future in the FPT framework, which provides a non-blocking way to get the result of an asynchronous task.
      • OBS_GET_IO_SCHEDULER_PERIODIC_STATS_SYSTEM_MESSAGE_TYPE: System message of type pgxc_obs_io_scheduler_periodic_stats in the asynchronous scheduling module statistics view.
      • OBS_IO_REQUEST_TYPE: I/O request in the asynchronous scheduling module.
      • OBS_IO_STATS_SYSTEM_MESSAGE_TYPE: System message of the pgxc_obs_io_scheduler_stats view in the asynchronous scheduling statistics module.
      • OBS_MANAGE_PRIORITY_SYSTEM_MESSAGE_TYPE: System message used to adjust priority in the asynchronous scheduling module.
      • OBS_SYSTEM_MESSAGE_TYPE: System message in the asynchronous scheduling module.
      • OBS_VFILE_TYPE: Virtual file in OBS, OBS read/write handle.
      • READ_SEGMENT_TYPE: Entity that merges multiple OBS read requests.
      • SHARED_OBS_HANDLE_TYPE: OBS Handler resource used to connect to the OBS service.
      • SHARED_VAR_AUTO_GUARD_TYPE: Thread-level resource that manages OBS Handler and cached OBS file streams.

      busy_num

      bigint

      Number of asynchronous I/O resources in use.

      idle_num

      bigint

      Number of idle asynchronous I/O resources.

      Example

       1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
      		 
      postgres=# select * from PGXC_AIO_RESOURCE_POOL_STATS;
  node_name   |                      resource_name                      | busy_num | idle_num
--------------+---------------------------------------------------------+----------+----------
 cn_5001      | ASYNC_CONTEXT_TYPE                                      |        0 |        1
 cn_5001      | DISK_CACHE_CACHE_BLOCK_TYPE                             |        0 |        0
 cn_5001      | DISK_CACHE_PATH_MANAGER_TYPE                            |       24 |        0
 cn_5001      | FUTURE_STATE_TYPE                                       |        0 |        2
 cn_5001      | FUTURE_TYPE                                             |        0 |        1
 cn_5001      | OBS_GET_IO_SCHEDULER_PERIODIC_STATS_SYSTEM_MESSAGE_TYPE |        0 |        0
 cn_5001      | OBS_IO_REQUEST_TYPE                                     |        0 |        1
 cn_5001      | OBS_IO_STATS_SYSTEM_MESSAGE_TYPE                        |        0 |        0
 cn_5001      | OBS_MANAGE_PRIORITY_SYSTEM_MESSAGE_TYPE                 |        0 |        0
 cn_5001      | OBS_SYSTEM_MESSAGE_TYPE                                 |        0 |        0
 cn_5001      | OBS_VFILE_TYPE                                          |        0 |        0
 cn_5001      | READ_SEGMENT_TYPE                                       |        0 |        0
 cn_5001      | SHARED_OBS_HANDLE_TYPE                                  |        0 |        0
 cn_5001      | SHARED_VAR_AUTO_GUARD_TYPE                              |        0 |        0
 dn_6001_6002 | ASYNC_CONTEXT_TYPE                                      |        0 |        1
 dn_6001_6002 | DISK_CACHE_CACHE_BLOCK_TYPE                             |      719 |        0
 dn_6001_6002 | DISK_CACHE_PATH_MANAGER_TYPE                            |       25 |        1
 dn_6001_6002 | FUTURE_STATE_TYPE                                       |      719 |        2
 dn_6001_6002 | FUTURE_TYPE                                             |        0 |       39
 dn_6001_6002 | OBS_GET_IO_SCHEDULER_PERIODIC_STATS_SYSTEM_MESSAGE_TYPE |        0 |        0
 dn_6001_6002 | OBS_IO_REQUEST_TYPE                                     |        0 |        3
 dn_6001_6002 | OBS_IO_STATS_SYSTEM_MESSAGE_TYPE                        |        0 |        0
 dn_6001_6002 | OBS_MANAGE_PRIORITY_SYSTEM_MESSAGE_TYPE                 |        0 |        0
 dn_6001_6002 | OBS_SYSTEM_MESSAGE_TYPE                                 |        0 |        0
 dn_6001_6002 | OBS_VFILE_TYPE                                          |        0 |       16
 dn_6001_6002 | READ_SEGMENT_TYPE                                       |        0 |        2
 dn_6001_6002 | SHARED_OBS_HANDLE_TYPE                                  |        0 |        1
 dn_6001_6002 | SHARED_VAR_AUTO_GUARD_TYPE                              |        0 |        1
 dn_6003_6004 | ASYNC_CONTEXT_TYPE                                      |        0 |        1
 dn_6003_6004 | DISK_CACHE_CACHE_BLOCK_TYPE                             |      715 |        0
 dn_6003_6004 | DISK_CACHE_PATH_MANAGER_TYPE                            |       25 |        1
 dn_6003_6004 | FUTURE_STATE_TYPE                                       |      715 |        2
 dn_6003_6004 | FUTURE_TYPE                                             |        0 |       39
 dn_6003_6004 | OBS_GET_IO_SCHEDULER_PERIODIC_STATS_SYSTEM_MESSAGE_TYPE |        0 |        0
 dn_6003_6004 | OBS_IO_REQUEST_TYPE                                     |        0 |        3
 dn_6003_6004 | OBS_IO_STATS_SYSTEM_MESSAGE_TYPE                        |        0 |        0
 dn_6003_6004 | OBS_MANAGE_PRIORITY_SYSTEM_MESSAGE_TYPE                 |        0 |        0
 dn_6003_6004 | OBS_SYSTEM_MESSAGE_TYPE                                 |        0 |        0
 dn_6003_6004 | OBS_VFILE_TYPE                                          |        0 |       16
 dn_6003_6004 | READ_SEGMENT_TYPE                                       |        0 |        2
 dn_6003_6004 | SHARED_OBS_HANDLE_TYPE                                  |        0 |        1
 dn_6003_6004 | SHARED_VAR_AUTO_GUARD_TYPE                              |        0 |        1
(42 rows)
      Parent topic: System Views

      Usamos cookies para aprimorar nosso site e sua experiência. Ao continuar a navegar em nosso site, você aceita nossa política de cookies. Saiba mais

      Feedback

      Feedback

      Feedback

      0/500

      Selected Content

      Submit selected content with the feedback