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
On this page

Show all

Viewing the Query Execution Plan and Cost Graphically

Updated on 2023-03-17 GMT+08:00

Visual Explain plan displays a graphical representation of the SQL query using information from the extended JSON format. This helps to refine query to enhance query and server performance. It helps to analyze the query path taken by the database and identifies heaviest, costliest and slowest node.

The graphical execution plan shows how the table(s) referenced by the SQL statement will be scanned (plain sequential scan and index scan).

The SQL statement execution cost is the estimate at how long it will take to run the statement (measured in cost units that are arbitrary, but conventionally mean disk page fetches).

Costliest: Highest Self Cost plan node.

Heaviest: Maximum number of rows output by a plan node is considered heaviest node.

Slowest: Highest execution time by a plan node.

Follow the steps to view the graphical representation of plan and cost for a required SQL query:

  1. Enter the query or use an existing query in the SQL Terminal and click on the SQL Terminal toolbar. Alternatively, press ALT+CTRL+X together.

    Visual Plan Analysis window is displayed.

    Refer to Viewing the Execution Plan and Costs for information on reconnect option in case connection is lost while retrieving the execution plan and cost.

    • 1 - General Detail tab: This tab displays the query.
    • 2 - Visual Explain Plan tab: This tab displays a graphical representation of all nodes like execution time, costliest, heaviest, and slowest node. Click each node to view the node details.
    • 3 - Properties - General tab: Provides the execution time of the query in ms.
    • 4 - Properties - All Nodes tab: Provides all node information.

      Column Name

      Description

      Node Name

      Name of the node

      Analysis

      Node analysis information

      RowsOutput

      Number of rows output by the plan node

      RowsOutput Deviation (%)

      Deviation % between estimated rows output and actual rows output by the plan node

      Execution Time (ms)

      Execution time taken by the plan node

      Contribution (%)

      Percentage of the execution time taken by plan node against the overall query execution time.

      Self Cost

      Total Cost of the plan node - Total Cost of all child nodes

      Total Cost

      Total cost of the plan node

    • 5 - Properties - Exec. Plan tab - Provides the execution information of all nodes.

      Column Name

      Description

      Node Name

      Name of the node

      Entity Name

      Name of the object

      Cost

      Execution time taken by the plan node

      Rows

      Number of rows output by the plan node

      Loops

      Number of loops of execution performed by each node.

      Width

      The estimated average width of rows output by the plan node in bytes

      Actual Rows

      Number of estimated rows output by the plan node

      Actual Time

      Actual execution time taken by the plan node

    • 6 - Plan Node - General tab - Provides the node information for each node.

      Row Name

      Description

      Output

      Provides the column information returned by the plan node

      Analysis

      Provides analysis of the plan node like costliest, slowest, and heaviest.

      RowsOutput Deviation (%)

      Deviation % between estimated rows output and actual rows output by the plan node

      Row Width (bytes)

      The estimated average width of rows output by the plan node in bytes

      Plan Output Rows

      Number of rows output by the plan node

      Actual Output Rows

      Number of estimated rows output by the plan node

      Actual Startup Time

      The actual execution time taken by the plan node to output the first record

      Actual Total Time

      Actual execution time taken by the plan node

      Actual Loops

      Number of iterations performed for the node

      Startup Cost

      The execution time taken by the plan node to output the first record

      Total Cost

      Execution time taken by the plan node

      Is Column Store

      This field represents the orientation of the table (column or row store)

      Shared Hit Blocks

      Number of shared blocks hit in buffer

      Shared Read Blocks

      Number of shared blocks read from buffer

      Shared Dirtied Blocks

      Number of shared blocks dirtied in buffer

      Shared Written Blocks

      Number of shared blocks written in buffer

      Local Hit Blocks

      Number of local blocks hit in buffer

      Local Read Blocks

      Number of local blocks read from buffer

      Local Dirtied Blocks

      Number of local blocks dirtied in buffer

      Local Written Blocks

      Number of local blocks written in buffer

      Temp Read Blocks

      Number of temporary blocks read in buffer

      Temp Written Blocks

      Number of temporary blocks written in buffer

      I/O Read Time (ms)

      Time taken for making any I/O read operation for the node

      I/O Write Time (ms)

      Time taken for making any I/O write operation for the node

      Node Type

      Represents the type of node

      Parent Relationship

      Represents the relationship with the parent node

      Inner Node Name

      Child node name

      Node/s

      No description needed for this field, this will be removed from properties

      Based on the plan node type additional information may display. Few examples:

      Plan Node

      Additional Information

      Partitioned CStore Scan

      Table Name, Table Alias, Schema Name

      Vector Sort

      Sort keys

      Vector Hash Aggregate

      Group By Key

      Vector Has Join

      Join Type, Hash Condition

      Vector Streaming

      Distribution key, Spawn On

    • 7 - Plan Node - DN Details tab - Provides detailed data node information for each node. DN Details are available only if data is being collected from data node.

      Refer to Viewing Table Data section for description on copy and search toolbar options.

We use cookies to improve our site and your experience. By continuing to browse our site you accept our cookie policy. Find out more

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback