select query,nodeid,parentid,substring(plannode from 1 for 30), substring(info from 1 for 20) from stl_explain where query=10 order by 1,2; query| nodeid |parentid| substring | substring ---+---+---+---+--- 10 | 1 | 0 |XN Aggregate (cost=6717.61..6 | 10 | 2 | 1 |...
ResMed chief looks to Intel to explain Apple and Nintendo tie-upsJessica Gardner
If you run this query and its query ID is 10, you can use the STL_EXPLAIN table to see the same kind of information that the EXPLAIN command returns: selectquery,nodeid,parentid,substring(plannodefrom1for30),substring(infofrom1for20)fromstl_explainwherequery=10orderby1,2; query|nodeid|...
selectquery,nodeid,parentid,substring(plannodefrom1for30),substring(infofrom1for20)fromstl_explainwherequery=10orderby1,2; query|nodeid|parentid|substring|substring---+---+---+---+---10|1|0|XN Aggregate (cost=6717.61..6|10|2|1|->XNMergeJoinDS_DIST_NO|MergeCond:("outer"10|3...
STL_EXPLAINPDFRSS Displays the EXPLAIN plan for a query that has been submitted for execution. STL_EXPLAIN is visible to all users. Superusers can see all rows; regular users can see only their own data. For more information, see Visibility of data in system tables and views....
이 쿼리를 실행하고, 쿼리 ID가 10이라면 STL_EXPLAIN 테이블을 사용하여 EXPLAIN 명령이 반환하는 것과 동일한 유형의 정보를 볼 수 있습니다.select query,nodeid,parentid,substring(plannode from 1 for 30), ...