[
https://issues.apache.org/jira/browse/IGNITE-26485?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Maksim Zhuravkov updated IGNITE-26485:
--------------------------------------
Description:
To improve visibility and ease troubleshooting, it suggested to add system
views exposing content of a plan cache:
{code}
SQL_CACHED_QUERY_PLANS: // node view
PLAN_ID:String
NODE_ID:String
CATALOG_VERSION:Int
DEFAULT_SCHEMA:String
QUERY_TEXT:String
QUERY_TYPE:String
QUERY_PLAN:String
QUERY_PREPARE_TIME:Instant
{code}
was:
To improve visibility and ease troubleshooting, it suggested to add system
views exposing content of a plan cache:
{code}
SQL_CACHED_QUERY_PLANS: // node view
PLAN_ID:String
NODE_ID:String
CATALOG_VERSION:Int
DEFAULT_SCHEMA:String
QUERY_TEXT:String
QUERY_TYPE:String
QUERY_PLAN:String
QUERY_PREPARE_TIME:TIMESTAMP
{code}
> Sql. Introduce system view exposing cached query plans
> ------------------------------------------------------
>
> Key: IGNITE-26485
> URL: https://issues.apache.org/jira/browse/IGNITE-26485
> Project: Ignite
> Issue Type: Improvement
> Components: sql ai3
> Reporter: Konstantin Orlov
> Assignee: Maksim Zhuravkov
> Priority: Major
> Labels: ignite-3
> Fix For: 3.2
>
> Time Spent: 1h 10m
> Remaining Estimate: 0h
>
> To improve visibility and ease troubleshooting, it suggested to add system
> views exposing content of a plan cache:
> {code}
> SQL_CACHED_QUERY_PLANS: // node view
> PLAN_ID:String
> NODE_ID:String
> CATALOG_VERSION:Int
> DEFAULT_SCHEMA:String
> QUERY_TEXT:String
> QUERY_TYPE:String
> QUERY_PLAN:String
> QUERY_PREPARE_TIME:Instant
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
