If you want to query execution plans with higher readability, we recommend that you upgrade your Hologres instance to V1.3.4x or later. EXPLAIN Syntax You can execute the following EXPLAIN statement to query the execution plan that is estimated by the QO: EXPLAIN <sql>; Example In this ...
PLAN_TABLE cannot be joined with GDS foreign tables. For a query that cannot be pushed down, only such information as REMOTE_QUERY and CTE can be collected from PLAN_TABLE after EXPLAIN PLAN is executed. For details, see Example 2. PLAN: saves plan information into PLAN_TABLE. If informati...