Hi,
is this possible to have information about sub plans in plan itself
now we see something like this without any correlation
PLAN
Select Expression
-> Singularity Check
-> Aggregate
-> Filter
-> Table "INSPEKTORAT" as "I I2" Access By ID
-> Bitmap
-> Index "INSPEKTORAT_PK" Unique Scan
Select Expression
-> Nested Loop Join (inner)
-> Materialize
-> Table "INSPEKTORAT" as "I INSP" Full Scan
-> Filter
-> Table "DYREKCJA" as "D" Access By ID
-> Bitmap
-> Index "DYREKCJA_PK" Unique Scan
Query
SELECT
I.*
FROM
(SELECT INSP.*, (SELECT COUNT(*) FROM INSPEKTORAT I2 WHERE I2.DYR_ID =
INSP.DYR_ID AND I2.INSP_ID = INSP.INSP_ID+1) AS ILE
FROM
INSPEKTORAT INSP) AS I
INNER JOIN DYREKCJA D ON I.DYR_ID = D.DYR_ID
will be good to see this in form
Select Expression
-> Nested Loop Join (inner)
-> Materialize
-> Table "INSPEKTORAT" as "I INSP" Full Scan
// maybe here some word like -> SUBPLAN
-> Select Expression
-> Singularity Check
-> Aggregate
-> Filter
-> Table "INSPEKTORAT" as "I I2" Access By ID
-> Bitmap
-> Index "INSPEKTORAT_PK" Unique Scan
-> Filter
-> Table "DYREKCJA" as "D" Access By ID
-> Bitmap
-> Index "DYREKCJA_PK" Unique Scan
PS. i saw somewhere info about including more stats in Explained Plan - when
can we expect this? :)
regards,
Karol Bieniaszewski
------------------------------------------------------------------------------
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
