Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?xml version="1.0" encoding="utf-16"?>
- <ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.2" Build="11.0.2100.60" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
- <BatchSequence>
- <Batch>
- <Statements>
- <StmtSimple StatementCompId="1" StatementEstRows="235.54" StatementId="1" StatementOptmLevel="FULL" StatementSubTreeCost="35.6008" StatementText="select t.title, count(res.id) fails from testruns as tr
--join location loc on tr.location_id = loc.id
join testruntests trt on tr.id = trt.testruns_id
join tests t on trt.tests_id = t.id
join testresults res on trt.id = res.testruntests_id
where 
res.result = 'Fail'
and tr.location_id = (select id from location where location = 'Derby')
--and loc.location = 'Derby'
group by t.title
order by fails desc" StatementType="SELECT" QueryHash="0x476660E375FFB31F" QueryPlanHash="0xFF55538652B6F7EC" RetrievedFromCache="true">
- <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
- <QueryPlan DegreeOfParallelism="4" MemoryGrant="90088" CachedPlanSize="128" CompileTime="179" CompileCPU="179" CompileMemory="2232">
- <ThreadStat Branches="5" UsedThreads="16">
- <ThreadReservation NodeId="0" ReservedThreads="20" />
- </ThreadStat>
- <MissingIndexes>
- <MissingIndexGroup Impact="41.0104">
- <MissingIndex Database="[prat_stats]" Schema="[dbo]" Table="[testresults]">
- <ColumnGroup Usage="EQUALITY">
- <Column Name="[result]" ColumnId="3" />
- </ColumnGroup>
- <ColumnGroup Usage="INCLUDE">
- <Column Name="[testruntests_id]" ColumnId="2" />
- </ColumnGroup>
- </MissingIndex>
- </MissingIndexGroup>
- </MissingIndexes>
- <MemoryGrantInfo SerialRequiredMemory="3072" SerialDesiredMemory="77424" RequiredMemory="15720" DesiredMemory="90088" RequestedMemory="90088" GrantWaitTime="0" GrantedMemory="90088" MaxUsedMemory="18776" />
- <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="209703" EstimatedPagesCached="52425" EstimatedAvailableDegreeOfParallelism="2" />
- <RelOp AvgRowSize="46" EstimateCPU="0.00299543" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="235.54" LogicalOp="Sort" NodeId="0" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="35.6008">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[tests]" Alias="[t]" Column="title" />
- <ColumnReference Column="Expr1012" />
- </OutputList>
- <MemoryFractions Input="0.307692" Output="1" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="252" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Sort Distinct="false">
- <OrderBy>
- <OrderByColumn Ascending="false">
- <ColumnReference Column="Expr1012" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="46" EstimateCPU="2.3554E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="235.54" LogicalOp="Compute Scalar" NodeId="2" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="35.5866">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[tests]" Alias="[t]" Column="title" />
- <ColumnReference Column="Expr1012" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1012" />
- <ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[globalagg1018],0)">
- <Convert DataType="int" Style="0" Implicit="true">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="globalagg1018" />
- </Identifier>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="50" EstimateCPU="0.0290944" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="235.54" LogicalOp="Gather Streams" NodeId="3" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="35.5865">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[tests]" Alias="[t]" Column="title" />
- <ColumnReference Column="globalagg1018" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="252" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Parallelism>
- <RelOp AvgRowSize="50" EstimateCPU="0.000290185" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="235.54" LogicalOp="Aggregate" NodeId="4" Parallel="true" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="35.5575">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[tests]" Alias="[t]" Column="title" />
- <ColumnReference Column="globalagg1018" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="4" ActualRows="62" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="3" ActualRows="58" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="1" ActualRows="64" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="68" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <StreamAggregate>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="globalagg1018" />
- <ScalarOperator ScalarString="SUM([partialagg1017])">
- <Aggregate AggType="SUM" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="partialagg1017" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <GroupBy>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[tests]" Alias="[t]" Column="title" />
- </GroupBy>
- <RelOp AvgRowSize="50" EstimateCPU="0.00581761" EstimateIO="0.00563063" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="771" LogicalOp="Sort" NodeId="5" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="35.5572">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[tests]" Alias="[t]" Column="title" />
- <ColumnReference Column="partialagg1017" />
- </OutputList>
- <MemoryFractions Input="0.45" Output="0.692308" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="4" ActualRebinds="1" ActualRewinds="0" ActualRows="149" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="1" ActualRewinds="0" ActualRows="144" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="1" ActualRewinds="0" ActualRows="143" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="1" ActualRewinds="0" ActualRows="154" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Sort Distinct="false">
- <OrderBy>
- <OrderByColumn Ascending="true">
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[tests]" Alias="[t]" Column="title" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="50" EstimateCPU="0.0330422" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="771" LogicalOp="Repartition Streams" NodeId="6" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="35.5457">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[tests]" Alias="[t]" Column="title" />
- <ColumnReference Column="partialagg1017" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="4" ActualRows="149" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="3" ActualRows="144" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="143" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="1" ActualRows="154" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Parallelism PartitioningType="Hash">
- <PartitionColumns>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[tests]" Alias="[t]" Column="title" />
- </PartitionColumns>
- <RelOp AvgRowSize="50" EstimateCPU="0.00501099" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="771" LogicalOp="Inner Join" NodeId="7" Parallel="true" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="35.5127">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[tests]" Alias="[t]" Column="title" />
- <ColumnReference Column="partialagg1017" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="4" ActualRows="144" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="1" ActualRows="149" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="3" ActualRows="149" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="148" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Merge ManyToMany="false">
- <InnerSideJoinColumns>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[tests]" Alias="[t]" Column="id" />
- </InnerSideJoinColumns>
- <OuterSideJoinColumns>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="tests_id" />
- </OuterSideJoinColumns>
- <Residual>
- <ScalarOperator ScalarString="[prat_stats].[dbo].[testruntests].[tests_id] as [trt].[tests_id]=[prat_stats].[dbo].[tests].[id] as [t].[id]">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="tests_id" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[tests]" Alias="[t]" Column="id" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Residual>
- <RelOp AvgRowSize="19" EstimateCPU="0.0105207" EstimateIO="0.00563063" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1298" LogicalOp="Sort" NodeId="8" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="35.4563">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="tests_id" />
- <ColumnReference Column="partialagg1017" />
- </OutputList>
- <MemoryFractions Input="0.44" Output="0.55" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="4" ActualRebinds="1" ActualRewinds="0" ActualRows="144" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="1" ActualRewinds="0" ActualRows="149" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="1" ActualRewinds="0" ActualRows="149" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="1" ActualRewinds="0" ActualRows="148" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Sort Distinct="false">
- <OrderBy>
- <OrderByColumn Ascending="true">
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="tests_id" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="19" EstimateCPU="0.224863" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1298" LogicalOp="Aggregate" NodeId="9" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="35.4401">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="tests_id" />
- <ColumnReference Column="partialagg1017" />
- </OutputList>
- <MemoryFractions Input="0.0030127" Output="0.56" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="4" ActualRows="144" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="1" ActualRows="149" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="3" ActualRows="149" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="148" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Hash>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="partialagg1017" />
- <ScalarOperator ScalarString="COUNT(*)">
- <Aggregate AggType="COUNT*" Distinct="false" />
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <HashKeysBuild>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="tests_id" />
- </HashKeysBuild>
- <RelOp AvgRowSize="11" EstimateCPU="0.129598" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="84380.4" LogicalOp="Repartition Streams" NodeId="10" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="35.2153">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="tests_id" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="4" ActualRows="61166" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="1" ActualRows="63606" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="74775" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="3" ActualRows="49846" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Parallelism PartitioningType="Hash">
- <PartitionColumns>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="tests_id" />
- </PartitionColumns>
- <RelOp AvgRowSize="11" EstimateCPU="0.704092" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="84380.4" LogicalOp="Inner Join" NodeId="11" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="35.0857">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="tests_id" />
- </OutputList>
- <MemoryFractions Input="0.053529" Output="0.0533678" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="3" ActualRows="62703" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="4" ActualRows="64003" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="1" ActualRows="63047" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="59640" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Hash>
- <DefinedValues />
- <HashKeysBuild>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruns]" Alias="[tr]" Column="id" />
- </HashKeysBuild>
- <HashKeysProbe>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="testruns_id" />
- </HashKeysProbe>
- <RelOp AvgRowSize="11" EstimateCPU="0.0389812" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="8748" LogicalOp="Bitmap Create" NodeId="12" Parallel="true" PhysicalOp="Bitmap" EstimatedTotalSubtreeCost="0.113073">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruns]" Alias="[tr]" Column="id" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="3" ActualRows="3569" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="4" ActualRows="3570" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="1" ActualRows="3569" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="3568" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Bitmap>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Bitmap1020" />
- </DefinedValue>
- </DefinedValues>
- <HashKeys>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruns]" Alias="[tr]" Column="id" />
- </HashKeys>
- <RelOp AvgRowSize="11" EstimateCPU="0.0389812" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="8748" LogicalOp="Repartition Streams" NodeId="13" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.113073">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruns]" Alias="[tr]" Column="id" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="3" ActualRows="3569" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="4" ActualRows="3570" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="1" ActualRows="3569" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="3568" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Parallelism PartitioningType="Hash">
- <PartitionColumns>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruns]" Alias="[tr]" Column="id" />
- </PartitionColumns>
- <RelOp AvgRowSize="11" EstimateCPU="0.0182833" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="8748" LogicalOp="Inner Join" NodeId="14" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0740914">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruns]" Alias="[tr]" Column="id" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="1" ActualRows="14276" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Column="Expr1014" />
- </OuterReferences>
- <RelOp AvgRowSize="11" EstimateCPU="2.4E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Assert" NodeId="15" Parallel="true" PhysicalOp="Assert" EstimatedTotalSubtreeCost="0.0317922">
- <OutputList>
- <ColumnReference Column="Expr1014" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="1" ActualRows="1" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Assert StartupExpression="false">
- <RelOp AvgRowSize="19" EstimateCPU="0.0285029" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Distribute Streams" NodeId="16" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.0317919">
- <OutputList>
- <ColumnReference Column="Expr1013" />
- <ColumnReference Column="Expr1014" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="1" ActualRows="1" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Parallelism PartitioningType="RoundRobin">
- <RelOp AvgRowSize="19" EstimateCPU="2.3E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Aggregate" NodeId="17" Parallel="false" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="0.00328904">
- <OutputList>
- <ColumnReference Column="Expr1013" />
- <ColumnReference Column="Expr1014" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRows="1" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <StreamAggregate>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1013" />
- <ScalarOperator ScalarString="Count(*)">
- <Aggregate AggType="countstar" Distinct="false" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1014" />
- <ScalarOperator ScalarString="ANY([prat_stats].[dbo].[location].[id])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[location]" Column="id" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="11" EstimateCPU="1.44E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3" LogicalOp="Filter" NodeId="18" Parallel="false" PhysicalOp="Filter" EstimatedTotalSubtreeCost="0.00328674">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[location]" Column="id" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRows="1" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Filter StartupExpression="false">
- <RelOp AvgRowSize="83" EstimateCPU="0.0001603" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3" LogicalOp="Clustered Index Scan" NodeId="19" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0032853" TableCardinality="3">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[location]" Column="id" />
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[location]" Column="location" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRows="3" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <IndexScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[location]" Column="id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[location]" Column="location" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[prat_stats]" Schema="[dbo]" Table="[location]" Index="[PK__location__3213E83F15A2172E]" IndexKind="Clustered" />
- </IndexScan>
- </RelOp>
- <Predicate>
- <ScalarOperator ScalarString="[prat_stats].[dbo].[location].[location]='Derby'">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[location]" Column="location" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'Derby'" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Predicate>
- </Filter>
- </RelOp>
- </StreamAggregate>
- </RelOp>
- </Parallelism>
- </RelOp>
- <Predicate>
- <ScalarOperator ScalarString="CASE WHEN [Expr1013]>(1) THEN (0) ELSE NULL END">
- <IF>
- <Condition>
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1013" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Condition>
- <Then>
- <ScalarOperator>
- <Const ConstValue="(0)" />
- </ScalarOperator>
- </Then>
- <Else>
- <ScalarOperator>
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </Else>
- </IF>
- </ScalarOperator>
- </Predicate>
- </Assert>
- </RelOp>
- <RelOp AvgRowSize="11" EstimateCPU="0.0097798" EstimateIO="0.0142361" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="8748" LogicalOp="Index Seek" NodeId="25" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0240159" TableCardinality="26244">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruns]" Alias="[tr]" Column="id" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="1" ActualRows="14276" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruns]" Alias="[tr]" Column="id" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[prat_stats]" Schema="[dbo]" Table="[testruns]" Index="[idx_testruns_location]" Alias="[tr]" IndexKind="NonClustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruns]" Alias="[tr]" Column="location_id" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[Expr1014]">
- <Identifier>
- <ColumnReference Column="Expr1014" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </Parallelism>
- </RelOp>
- </Bitmap>
- </RelOp>
- <RelOp AvgRowSize="15" EstimateCPU="0.427862" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="253141" LogicalOp="Repartition Streams" NodeId="26" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="34.2685">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="testruns_id" />
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="tests_id" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="3" ActualRows="63880" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="4" ActualRows="65099" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="1" ActualRows="64334" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="60480" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Parallelism PartitioningType="Hash">
- <PartitionColumns>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="testruns_id" />
- </PartitionColumns>
- <Predicate>
- <ScalarOperator ScalarString="PROBE([Bitmap1020],[prat_stats].[dbo].[testruntests].[testruns_id] as [trt].[testruns_id])">
- <Intrinsic FunctionName="PROBE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Bitmap1020" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="testruns_id" />
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Predicate>
- <RelOp AvgRowSize="15" EstimateCPU="6.28743" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="253141" LogicalOp="Inner Join" NodeId="27" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="33.8407">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="testruns_id" />
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="tests_id" />
- </OutputList>
- <MemoryFractions Input="0.946471" Output="0.94362" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="2" ActualRows="64783" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="4" ActualRows="64650" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="3" ActualRows="64708" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="1" ActualRows="64631" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Hash>
- <DefinedValues />
- <HashKeysBuild>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testresults]" Alias="[res]" Column="testruntests_id" />
- </HashKeysBuild>
- <HashKeysProbe>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="id" />
- </HashKeysProbe>
- <RelOp AvgRowSize="11" EstimateCPU="0.331795" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="253141" LogicalOp="Bitmap Create" NodeId="28" Parallel="true" PhysicalOp="Bitmap" EstimatedTotalSubtreeCost="15.8157">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testresults]" Alias="[res]" Column="testruntests_id" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="2" ActualRows="64783" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="4" ActualRows="64650" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="3" ActualRows="64708" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="1" ActualRows="64631" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Bitmap>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Bitmap1019" />
- </DefinedValue>
- </DefinedValues>
- <HashKeys>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testresults]" Alias="[res]" Column="testruntests_id" />
- </HashKeys>
- <RelOp AvgRowSize="11" EstimateCPU="0.331795" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="253141" LogicalOp="Repartition Streams" NodeId="29" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="15.8157">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testresults]" Alias="[res]" Column="testruntests_id" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="2" ActualRows="64783" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="4" ActualRows="64650" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="3" ActualRows="64708" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="1" ActualRows="64631" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Parallelism PartitioningType="Hash">
- <PartitionColumns>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testresults]" Alias="[res]" Column="testruntests_id" />
- </PartitionColumns>
- <RelOp AvgRowSize="19" EstimateCPU="1.40895" EstimateIO="13.4602" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="253141" LogicalOp="Clustered Index Scan" NodeId="30" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="14.8691" TableCardinality="2561580">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testresults]" Alias="[res]" Column="testruntests_id" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="3" ActualRows="69920" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="4" ActualRows="63028" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="1" ActualRows="52888" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="72936" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <IndexScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testresults]" Alias="[res]" Column="testruntests_id" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[prat_stats]" Schema="[dbo]" Table="[testresults]" Index="[testresults_pk]" Alias="[res]" IndexKind="Clustered" />
- <Predicate>
- <ScalarOperator ScalarString="[prat_stats].[dbo].[testresults].[result] as [res].[result]='Fail'">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testresults]" Alias="[res]" Column="result" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'Fail'" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- </Parallelism>
- </RelOp>
- </Bitmap>
- </RelOp>
- <RelOp AvgRowSize="19" EstimateCPU="4.17094" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2116600" LogicalOp="Repartition Streams" NodeId="31" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="11.7375">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="id" />
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="testruns_id" />
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="tests_id" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="2" ActualRows="27366" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="4" ActualRows="27476" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="3" ActualRows="27086" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="1" ActualRows="27349" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Parallelism PartitioningType="Hash">
- <PartitionColumns>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="id" />
- </PartitionColumns>
- <RelOp AvgRowSize="19" EstimateCPU="1.16421" EstimateIO="6.40238" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2116600" LogicalOp="Clustered Index Scan" NodeId="32" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="7.56659" TableCardinality="2116600">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="id" />
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="testruns_id" />
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="tests_id" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRows="33778" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="4" ActualRows="24800" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="26009" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="3" ActualRows="24690" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <IndexScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="testruns_id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="tests_id" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Index="[testruntests_pk]" Alias="[trt]" IndexKind="Clustered" />
- <Predicate>
- <ScalarOperator ScalarString="PROBE([Bitmap1019],[prat_stats].[dbo].[testruntests].[id] as [trt].[id],N'[IN ROW]')">
- <Intrinsic FunctionName="PROBE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Bitmap1019" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="id" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'[IN ROW]'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- </Parallelism>
- </RelOp>
- </Hash>
- </RelOp>
- </Parallelism>
- </RelOp>
- </Hash>
- </RelOp>
- </Parallelism>
- </RelOp>
- </Hash>
- </RelOp>
- </Sort>
- </RelOp>
- <RelOp AvgRowSize="46" EstimateCPU="0.0343959" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="771" LogicalOp="Repartition Streams" NodeId="38" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.0513568">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[tests]" Alias="[t]" Column="id" />
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[tests]" Alias="[t]" Column="title" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="4" ActualRows="186" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="1" ActualRows="193" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="3" ActualRows="187" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="184" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Parallelism PartitioningType="Hash">
- <PartitionColumns>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[tests]" Alias="[t]" Column="id" />
- </PartitionColumns>
- <OrderBy>
- <OrderByColumn Ascending="true">
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[tests]" Alias="[t]" Column="id" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="46" EstimateCPU="0.00050255" EstimateIO="0.0164583" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="771" LogicalOp="Clustered Index Scan" NodeId="39" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0169609" TableCardinality="771">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[tests]" Alias="[t]" Column="id" />
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[tests]" Alias="[t]" Column="title" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="2" ActualRows="201" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="3" ActualRows="224" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="4" ActualRows="173" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="1" ActualRows="173" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[tests]" Alias="[t]" Column="id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[tests]" Alias="[t]" Column="title" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[prat_stats]" Schema="[dbo]" Table="[tests]" Index="[tests_pk]" Alias="[t]" IndexKind="Clustered" />
- </IndexScan>
- </RelOp>
- </Parallelism>
- </RelOp>
- </Merge>
- </RelOp>
- </Parallelism>
- </RelOp>
- </Sort>
- </RelOp>
- </StreamAggregate>
- </RelOp>
- </Parallelism>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- </Sort>
- </RelOp>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- </BatchSequence>
- </ShowPlanXML>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement