SHOW-QUERY-PROFILE
Name
SHOW QUERY PROFILE
:::caution 自 2.1.1 起，此语法被弃用。你仍然可以从 http://<fe_ip>:<fe_http_port>/QueryProfile 上下载 profile 文件。 :::
Description
该语句是用来查看QUERY操作的树状Profile信息，该功能需要用户打开 Profile 设置，0.15 之前版本执行下面的设置：
SET is_report_success=true;0.15 及之后的版本执行下面的设置：
SET [GLOBAL] enable_profile=true;语法：
show query profile "/";这个命令会列出当前保存的所有query操作的 Profile 。
show query profile "/queryId"\G;
show query profile "/queryId/fragment_id/instance_id";获取指定query id树状profile信息,返回profile 简易树形图。指定fragment_id和instance_id则返回对应的详细profile树形图。
Example
-
列出所有的 query Profile
mysql> show query profile "/"; +-----------------------------------+------+-------------------------+--------------------+-----------+---------------------+---------------------+-----------+------------+ | QueryId | User | DefaultDb | SQL | QueryType | StartTime | EndTime | TotalTime | QueryState | +-----------------------------------+------+-------------------------+--------------------+-----------+---------------------+---------------------+-----------+------------+ | 327167e0db4749a9-adce3b3d770b2bb1 | root | default_cluster:test_db | select * from test | Query | 2022-08-09 10:50:09 | 2022-08-09 10:50:09 | 19ms | EOF | +-----------------------------------+------+-------------------------+--------------------+-----------+---------------------+---------------------+-----------+------------+ 1 row in set (0.00 sec) -
列出指定QueryId的 query Profile
mysql> show query profile "/327167e0db4749a9-adce3b3d770b2bb1"\G *************************** 1. row *************************** Fragments: ┌────────────────────────┐ │[-1: VDataBufferSender] │ │Fragment: 0 │ │MaxActiveTime: 783.263us│ └────────────────────────┘ ┌┘ │ ┌───────────────────┐ │[1: VEXCHANGE_NODE]│ │Fragment: 0 │ └───────────────────┘ └┐ │ ┌────────────────────────┐ │[1: VDataStreamSender] │ │Fragment: 1 │ │MaxActiveTime: 847.612us│ └────────────────────────┘ │ │ ┌────────────────────┐ │[0: VOLAP_SCAN_NODE]│ │Fragment: 1 │ └────────────────────┘ ┌┘ │ ┌─────────────┐ │[OlapScanner]│ │Fragment: 1 │ └─────────────┘ │ │ ┌─────────────────┐ │[SegmentIterator]│ │Fragment: 1 │ └─────────────────┘ 1 row in set (0.00 sec) -
列出指定 Fragment 的 Instance 概况
mysql> show query profile "/327167e0db4749a9-adce3b3d770b2bb1/1/"\G *************************** 1. row *************************** Instances: 327167e0db4749a9-adce3b3d770b2bb2 Host: 172.26.0.1:9111 ActiveTime: 847.612us 1 row in set (0.01 sec) -
继续查看某一个具体的 Instance 上各个算子的详细 Profile
mysql> show query profile "/327167e0db4749a9-adce3b3d770b2bb1/1/327167e0db4749a9-adce3b3d770b2bb2"\G *************************** 1. row *************************** Instance: ┌───────────────────────────────────────┐ │[1: VDataStreamSender] │ │(Active: 36.944us, non-child: 0.20) │ │ - Counters: │ │ - BytesSent: 0.00 │ │ - IgnoreRows: 0 │ │ - LocalBytesSent: 20.00 B │ │ - OverallThroughput: 0.0 /sec │ │ - PeakMemoryUsage: 0.00 │ │ - SerializeBatchTime: 0ns │ │ - UncompressedRowBatchSize: 0.00 │ └───────────────────────────────────────┘ │ │ ┌───────────────────────────────────────┐ │[0: VOLAP_SCAN_NODE] │ │(Active: 563.241us, non-child: 3.00) │ │ - Counters: │ │ - BatchQueueWaitTime: 444.714us │ │ - BytesRead: 37.00 B │ │ - NumDiskAccess: 1 │ │ - NumScanners: 2 │ │ - PeakMemoryUsage: 320.00 KB │ │ - RowsRead: 4 │ │ - RowsReturned: 4 │ │ - RowsReturnedRate: 7.101K /sec │ │ - ScannerBatchWaitTime: 206.40us │ │ - ScannerSchedCount : 2 │ │ - ScannerWorkerWaitTime: 34.640us│ │ - TabletCount : 2 │ │ - TotalReadThroughput: 0.0 /sec │ └───────────────────────────────────────┘ │ │ ┌─────────────────────────────────┐ │[OlapScanner] │ │(Active: 0ns, non-child: 0.00) │ │ - Counters: │ │ - BlockConvertTime: 0ns │ │ - BlockFetchTime: 183.741us│ │ - ReaderInitTime: 180.741us│ │ - RowsDelFiltered: 0 │ │ - RowsPushedCondFiltered: 0│ │ - ScanCpuTime: 388.576us │ │ - ScanTime: 0ns │ │ - ShowHintsTime_V1: 0ns │ └─────────────────────────────────┘ │ │ ┌─────────────────────────────────────┐ │[SegmentIterator] │ │(Active: 0ns, non-child: 0.00) │ │ - Counters: │ │ - BitmapIndexFilterTimer: 124ns│ │ - BlockLoadTime: 179.202us │ │ - BlockSeekCount: 5 │ │ - BlockSeekTime: 18.792us │ │ - BlocksLoad: 4 │ │ - CachedPagesNum: 2 │ │ - CompressedBytesRead: 0.00 │ │ - DecompressorTimer: 0ns │ │ - IOTimer: 0ns │ │ - IndexLoadTime_V1: 0ns │ │ - NumSegmentFiltered: 0 │ │ - NumSegmentTotal: 2 │ │ - RawRowsRead: 4 │ │ - RowsBitmapIndexFiltered: 0 │ │ - RowsBloomFilterFiltered: 0 │ │ - RowsConditionsFiltered: 0 │ │ - RowsKeyRangeFiltered: 0 │ │ - RowsStatsFiltered: 0 │ │ - RowsVectorPredFiltered: 0 │ │ - TotalPagesNum: 2 │ │ - UncompressedBytesRead: 0.00 │ │ - VectorPredEvalTime: 0ns │ └─────────────────────────────────────┘ 1 row in set (0.01 sec)
Keywords
SHOW, QUERY, PROFILE