Hi Dmitry,
i look into source code and now i know why this is not so simple to change
code to provide subplans
but when i go throught source code i see something like this
const char* JStatement::getPlan(CheckStatusWrapper* userStatus, FB_BOOLEAN
detailed)
{
const char* ret = NULL;
try
{
EngineContextHolder tdbb(userStatus, this, FB_FUNCTION);
check_database(tdbb);
try
{
ret = metadata.getPlan(detailed);
}
catch (const Exception& ex)
{
transliterateException(tdbb, ex, userStatus,
"JStatement::getPlan");
return ret;
}
trace_warning(tdbb, userStatus, "JStatement::getPlan");
}
catch (const Exception& ex)
{
ex.stuffException(userStatus);
return ret;
}
successful_completion(userStatus);
return ret;
}
do you think that this will be better to write this not as FB_BOOLEAN
detailed
only as enumeration for future support without changing api
like FB_PLAN_FORMAT (TEXT_PLAIN, TEXT_DETAILED, XML ...)
regards,
Karol Bieniaszewski
-----Oryginalna wiadomość-----
From: Dmitry Yemanov
Sent: Thursday, September 17, 2015 2:23 PM
To: For discussion among Firebird Developers
Subject: Re: [Firebird-devel] Explained plan - sub plan
17.09.2015 14:42, liviuslivius wrote:
>
> is this possible to have information about sub plans in plan itself
This is theoretically possible for subqueries inside FROM and WHERE
clauses, but not for subqueries inside the select list (except derived
tables and CTEs). But it's not just about the plan output, it requires
engine code changes. Definitely not for v3.
> PS. i saw somewhere info about including more stats in Explained Plan -
> when can we expect this? :)
The intention was for v3 but that's unlikely. We still don't have the
core statistics propagated at the every level of the plan.
Dmitry
------------------------------------------------------------------------------
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991&iu=/4140
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
------------------------------------------------------------------------------
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991&iu=/4140
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
