我的书签
添加书签
移除书签该语句是用来查看QUERY操作的树状Profile信息，该功能需要用户打开 Profile 设置，0.15 之前版本执行下面的设置：
0.15 及之后的版本执行下面的设置：
show query profile "/";
这个命令会列出当前保存的所有query操作的 Profile 。
获取指定query id树状profile信息,返回profile 简易树形图。指定fragment_id和instance_id则返回对应的详细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 │└────────────────────┘┌┘│┌─────────────┐│Fragment: 1 │└─────────────┘│││[SegmentIterator]││Fragment: 1 │└─────────────────┘1 row in set (0.00 sec)
列出指定 Fragment 的 Instance 概况
-
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] ││ - 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)
