📄 staleplans.out
字号:
Number of pages visited=87 Number of rows qualified=1034 Number of rows visited=1034 Scan type=heap start position: null stop position: null qualifiers:Column[0][0] Id: 0Operator: =Ordered nulls: falseUnknown return value: falseNegate comparison result: falseij> -- Change the row count significantlyinsert into t2 select c1, c2, c3 from t2 where c1 < 128;1034 rows inserted/updated/deletedij> -- Make sure row count from inserts is flushed outselect count(c1) from flusher;1 -----------64 ij> -- Execute 11 times, the plan should changeexecute s2;1 -----------2068 ij> execute s2;1 -----------2068 ij> execute s2;1 -----------2068 ij> execute s2;1 -----------2068 ij> execute s2;1 -----------2068 ij> execute s2;1 -----------2068 ij> execute s2;1 -----------2068 ij> execute s2;1 -----------2068 ij> execute s2;1 -----------2068 ij> execute s2;1 -----------2068 ij> execute s2;1 -----------2068 ij> -- Expect this to do table scanvalues SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS();1 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------Statement Name: nullStatement Text: select count(c1 + c2) from t2 where c1 = 1Parse Time: 0Bind Time: 0Optimize Time: 0Generate Time: 0Compile Time: 0Execute Time: 0Begin Compilation Timestamp : nullEnd Compilation Timestamp : nullBegin Execution Timestamp : nullEnd Execution Timestamp : nullStatement Execution Plan Text: Project-Restrict ResultSet (4):Number of opens = 1Rows seen = 1Rows filtered = 0restriction = falseprojection = true constructor time (milliseconds) = 0 open time (milliseconds) = 0 next time (milliseconds) = 0 close time (milliseconds) = 0 restriction time (milliseconds) = 0 projection time (milliseconds) = 0Source result set: Scalar Aggregate ResultSet: Number of opens = 1 Rows input = 2068 constructor time (milliseconds) = 0 open time (milliseconds) = 0 next time (milliseconds) = 0 close time (milliseconds) = 0 Index Key Optimization = false Source result set: Project-Restrict ResultSet (3): Number of opens = 1 Rows seen = 2068 Rows filtered = 0 restriction = false projection = true constructor time (milliseconds) = 0 open time (milliseconds) = 0 next time (milliseconds) = 0 close time (milliseconds) = 0 restriction time (milliseconds) = 0 projection time (milliseconds) = 0 Source result set: Table Scan ResultSet for T2 at read committed isolation level using instantaneous share row locking chosen by the optimizer Number of opens = 1 Rows seen = 2068 Rows filtered = 0 Fetch Size = 16 constructor time (milliseconds) = 0 open time (milliseconds) = 0 next time (milliseconds) = 0 close time (milliseconds) = 0 next time in milliseconds/row = 0 scan information: Bit set of columns fetched={0, 1} Number of columns fetched=2 Number of pages visited=173 Number of rows qualified=2068 Number of rows visited=2068 Scan type=heap start position: null stop position: null qualifiers:Column[0][0] Id: 0Operator: =Ordered nulls: falseUnknown return value: falseNegate comparison result: falseij> -- Change the distribution back to where an index makes sense.update t2 set c1 = c2;2068 rows inserted/updated/deletedij> -- Change the row count significantlyinsert into t2 select c1, c2, c3 from t2;2068 rows inserted/updated/deletedij> -- Make sure row count from inserts is flushed outselect count(c1) from flusher;1 -----------64 ij> -- Execute 11 times, the plan should changeexecute s2;1 -----------4 ij> execute s2;1 -----------4 ij> execute s2;1 -----------4 ij> execute s2;1 -----------4 ij> execute s2;1 -----------4 ij> execute s2;1 -----------4 ij> execute s2;1 -----------4 ij> execute s2;1 -----------4 ij> execute s2;1 -----------4 ij> execute s2;1 -----------4 ij> execute s2;1 -----------4 ij> -- Expect this to do index to baserow.values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS();1 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------Statement Name: nullStatement Text: select count(c1 + c2) from t2 where c1 = 1Parse Time: 0Bind Time: 0Optimize Time: 0Generate Time: 0Compile Time: 0Execute Time: 0Begin Compilation Timestamp : nullEnd Compilation Timestamp : nullBegin Execution Timestamp : nullEnd Execution Timestamp : nullStatement Execution Plan Text: Project-Restrict ResultSet (5):Number of opens = 1Rows seen = 1Rows filtered = 0restriction = falseprojection = true constructor time (milliseconds) = 0 open time (milliseconds) = 0 next time (milliseconds) = 0 close time (milliseconds) = 0 restriction time (milliseconds) = 0 projection time (milliseconds) = 0Source result set: Scalar Aggregate ResultSet: Number of opens = 1 Rows input = 4 constructor time (milliseconds) = 0 open time (milliseconds) = 0 next time (milliseconds) = 0 close time (milliseconds) = 0 Index Key Optimization = false Source result set: Project-Restrict ResultSet (4): Number of opens = 1 Rows seen = 4 Rows filtered = 0 restriction = false projection = true constructor time (milliseconds) = 0 open time (milliseconds) = 0 next time (milliseconds) = 0 close time (milliseconds) = 0 restriction time (milliseconds) = 0 projection time (milliseconds) = 0 Source result set: Index Row to Base Row ResultSet for T2: Number of opens = 1 Rows seen = 4 Columns accessed from heap = {0, 1} constructor time (milliseconds) = 0 open time (milliseconds) = 0 next time (milliseconds) = 0 close time (milliseconds) = 0 Index Scan ResultSet for T2 using index T2X at read committed isolation level using instantaneous share row locking chosen by the optimizer Number of opens = 1 Rows seen = 4 Rows filtered = 0 Fetch Size = 16 constructor time (milliseconds) = 0 open time (milliseconds) = 0 next time (milliseconds) = 0 close time (milliseconds) = 0 next time in milliseconds/row = 0 scan information: Bit set of columns fetched=All Number of columns fetched=2 Number of deleted rows visited=2066 Number of pages visited=23 Number of rows qualified=4 Number of rows visited=2071 Scan type=btree Tree height=2 start position: >= on first 1 column(s). Ordered null semantics on the following columns: stop position: > on first 1 column(s). Ordered null semantics on the following columns: qualifiers:Noneij> rollback;ij> ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -