SHOW-QUERY-PROFILE
SHOW-QUERY-PROFILE
Name
SHOW QUERY 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
