Skip to content

Instantly share code, notes, and snippets.

@erikdarlingdata

erikdarlingdata/gist:8e321ba10001589d88539eb9f4d54d21 Secret

Created May 28, 2019 15:46
Show Gist options
  • Save erikdarlingdata/8e321ba10001589d88539eb9f4d54d21 to your computer and use it in GitHub Desktop.
Save erikdarlingdata/8e321ba10001589d88539eb9f4d54d21 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
<?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.481" Build="14.0.3162.1" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementCompId="1" StatementEstRows="2465710" StatementId="1" StatementOptmLevel="FULL" CardinalityEstimationModelVersion="140" StatementSubTreeCost="30230" StatementText="SELECT u.Id, MAX(p.Score)&#xD;&#xA;FROM dbo.Users AS u&#xD;&#xA;JOIN dbo.Posts AS p&#xD;&#xA; WITH (FORCESEEK)&#xD;&#xA; ON u.Id = p.OwnerUserId&#xD;&#xA; OR u.Id = p.LastEditorUserId&#xD;&#xA;WHERE p.PostTypeId IN (1, 2)&#xD;&#xA;GROUP BY u.Id" StatementType="SELECT" QueryHash="0xE927D660C81586C1" QueryPlanHash="0x6C47C01B673AC545" RetrievedFromCache="true" StatementSqlHandle="0x0900735B5ECB6786DA964359F3B321A71D290000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="2" ParentObjectId="0" StatementParameterizationType="0" SecurityPolicyApplied="false">
<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="240360" CachedPlanSize="64" CompileTime="6" CompileCPU="6" CompileMemory="568">
<ThreadStat Branches="2" UsedThreads="8">
<ThreadReservation NodeId="0" ReservedThreads="8" />
</ThreadStat>
<MemoryGrantInfo SerialRequiredMemory="1536" SerialDesiredMemory="235376" RequiredMemory="6504" DesiredMemory="240360" RequestedMemory="240360" GrantWaitTime="0" GrantedMemory="240360" MaxUsedMemory="98200" MaxQueryMemory="9702144" />
<OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="655360" EstimatedPagesCached="327680" EstimatedAvailableDegreeOfParallelism="4" MaxCompileMemory="37758976" />
<OptimizerStatsUsage>
<StatisticsInfo Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Statistics="[PK_Posts_Id]" ModificationCount="6" SamplingPercent="0.85705" LastUpdate="2019-04-05T15:06:57.53" />
<StatisticsInfo Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Statistics="[ix_kiwi]" ModificationCount="0" SamplingPercent="100" LastUpdate="2019-05-28T11:43:27.3" />
<StatisticsInfo Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Statistics="[_WA_Sys_00000010_0519C6AF]" ModificationCount="0" SamplingPercent="0.860848" LastUpdate="2019-05-28T11:43:38.06" />
<StatisticsInfo Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Statistics="[ix_aussie]" ModificationCount="0" SamplingPercent="100" LastUpdate="2019-05-28T11:43:08.82" />
</OptimizerStatsUsage>
<WaitStats>
<Wait WaitType="IO_COMPLETION" WaitTimeMs="267" WaitCount="1499" />
<Wait WaitType="MEMORY_ALLOCATION_EXT" WaitTimeMs="476" WaitCount="835084" />
<Wait WaitType="RESERVED_MEMORY_ALLOCATION_EXT" WaitTimeMs="687" WaitCount="1728423" />
<Wait WaitType="SOS_SCHEDULER_YIELD" WaitTimeMs="831" WaitCount="15091" />
<Wait WaitType="ASYNC_NETWORK_IO" WaitTimeMs="6754" WaitCount="3509" />
<Wait WaitType="CXPACKET" WaitTimeMs="43078" WaitCount="15394" />
</WaitStats>
<QueryTimeStats CpuTime="63965" ElapsedTime="23256" />
<RelOp AvgRowSize="15" EstimateCPU="1.65125" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2465710" LogicalOp="Gather Streams" NodeId="0" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="30230">
<OutputList>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" />
<ColumnReference Column="Expr1002" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="1440301" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="16152" ActualCPUms="149" />
</RunTimeInformation>
<Parallelism>
<RelOp AvgRowSize="15" EstimateCPU="19.6726" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2465710" LogicalOp="Aggregate" NodeId="1" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="30228.4">
<OutputList>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" />
<ColumnReference Column="Expr1002" />
</OutputList>
<MemoryFractions Input="0.999863" Output="1" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="360528" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="16034" ActualCPUms="225" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="59472" OutputMemoryGrant="59488" UsedMemoryGrant="24448" />
<RunTimeCountersPerThread Thread="3" ActualRows="359704" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="16034" ActualCPUms="228" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="59472" OutputMemoryGrant="59488" UsedMemoryGrant="24424" />
<RunTimeCountersPerThread Thread="2" ActualRows="359583" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="16034" ActualCPUms="225" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="59472" OutputMemoryGrant="59488" UsedMemoryGrant="24456" />
<RunTimeCountersPerThread Thread="1" ActualRows="360486" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="16038" ActualCPUms="231" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="59472" OutputMemoryGrant="59488" UsedMemoryGrant="24424" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="0" OutputMemoryGrant="0" UsedMemoryGrant="0" />
</RunTimeInformation>
<Hash>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1002" />
<ScalarOperator ScalarString="MAX([partialagg1003])">
<Aggregate AggType="MAX" Distinct="false">
<ScalarOperator>
<Identifier>
<ColumnReference Column="partialagg1003" />
</Identifier>
</ScalarOperator>
</Aggregate>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<HashKeysBuild>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" />
</HashKeysBuild>
<RelOp AvgRowSize="15" EstimateCPU="6.74934" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="8520210" LogicalOp="Repartition Streams" NodeId="2" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="30208.7">
<OutputList>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" />
<ColumnReference Column="partialagg1003" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="360528" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="15827" ActualCPUms="18" />
<RunTimeCountersPerThread Thread="3" ActualRows="359704" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="15825" ActualCPUms="18" />
<RunTimeCountersPerThread Thread="2" ActualRows="359583" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="15827" ActualCPUms="18" />
<RunTimeCountersPerThread Thread="1" ActualRows="360486" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="15826" ActualCPUms="19" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" />
</PartitionColumns>
<RelOp AvgRowSize="15" EstimateCPU="3.62877" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="8520210" LogicalOp="Aggregate" NodeId="3" Parallel="true" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="30201.9">
<OutputList>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" />
<ColumnReference Column="partialagg1003" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="373714" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="15757" ActualCPUms="15477" />
<RunTimeCountersPerThread Thread="3" ActualRows="367564" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="15483" ActualCPUms="15229" />
<RunTimeCountersPerThread Thread="2" ActualRows="335232" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="15663" ActualCPUms="15379" />
<RunTimeCountersPerThread Thread="1" ActualRows="363791" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="15853" ActualCPUms="15613" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
</RunTimeInformation>
<StreamAggregate>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="partialagg1003" />
<ScalarOperator ScalarString="MAX([StackOverflow2013].[dbo].[Posts].[Score] as [p].[Score])">
<Aggregate AggType="MAX" Distinct="false">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="Score" />
</Identifier>
</ScalarOperator>
</Aggregate>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<GroupBy>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" />
</GroupBy>
<RelOp AvgRowSize="15" EstimateCPU="17.8608" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="17091600" LogicalOp="Inner Join" NodeId="4" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="30198.3">
<OutputList>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" />
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="Score" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="4875864" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="15062" ActualCPUms="14782" />
<RunTimeCountersPerThread Thread="3" ActualRows="4751914" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="14781" ActualCPUms="14527" />
<RunTimeCountersPerThread Thread="2" ActualRows="5422210" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="14924" ActualCPUms="14640" />
<RunTimeCountersPerThread Thread="1" ActualRows="4841657" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="15158" ActualCPUms="14918" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
</RunTimeInformation>
<NestedLoops Optimized="false" WithUnorderedPrefetch="true">
<OuterReferences>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" />
<ColumnReference Column="Expr1004" />
</OuterReferences>
<RelOp AvgRowSize="11" EstimateCPU="0.67811" EstimateIO="32.8661" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2465710" EstimatedRowsRead="2465710" LogicalOp="Clustered Index Scan" NodeId="6" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="33.5442" TableCardinality="2465710">
<OutputList>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="639502" ActualRowsRead="639502" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="170" ActualCPUms="170" ActualScans="1" ActualLogicalReads="11674" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="3" ActualRows="608283" ActualRowsRead="608283" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="167" ActualCPUms="166" ActualScans="1" ActualLogicalReads="11105" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="2" ActualRows="591160" ActualRowsRead="591160" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="158" ActualCPUms="158" ActualScans="1" ActualLogicalReads="10659" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="1" ActualRows="626768" ActualRowsRead="626768" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="171" ActualCPUms="170" ActualScans="1" ActualLogicalReads="11286" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
</RunTimeInformation>
<IndexScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" />
</DefinedValue>
</DefinedValues>
<Object Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Index="[PK_Users_Id]" Alias="[u]" IndexKind="Clustered" Storage="RowStore" />
</IndexScan>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="0.000479764" EstimateIO="0.0112613" EstimateRebinds="2465710" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="6.93172" LogicalOp="Distinct Sort" NodeId="7" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="30146.9">
<OutputList>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="Score" />
</OutputList>
<Warnings>
<SpillToTempDb SpillLevel="2" SpilledThreadCount="4" />
<SortSpillDetails GrantedMemoryKb="206440" UsedMemoryKb="205384" WritesToTempDb="681331" ReadsFromTempDb="681331" />
</Warnings>
<MemoryFractions Input="0.000136846" Output="0.000136846" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRebinds="639502" ActualRewinds="0" ActualRows="4875864" Batches="0" ActualEndOfScans="639502" ActualExecutions="639502" ActualExecutionMode="Row" ActualElapsedms="14038" ActualCPUms="13763" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="812" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="520" OutputMemoryGrant="136" UsedMemoryGrant="520" />
<RunTimeCountersPerThread Thread="3" ActualRebinds="608283" ActualRewinds="0" ActualRows="4751914" Batches="0" ActualEndOfScans="608283" ActualExecutions="608283" ActualExecutionMode="Row" ActualElapsedms="13766" ActualCPUms="13517" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="879" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="520" OutputMemoryGrant="136" UsedMemoryGrant="520" />
<RunTimeCountersPerThread Thread="2" ActualRebinds="591160" ActualRewinds="0" ActualRows="5422210" Batches="0" ActualEndOfScans="591160" ActualExecutions="591160" ActualExecutionMode="Row" ActualElapsedms="13897" ActualCPUms="13615" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="5448" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="520" OutputMemoryGrant="136" UsedMemoryGrant="520" />
<RunTimeCountersPerThread Thread="1" ActualRebinds="626768" ActualRewinds="0" ActualRows="4841657" Batches="0" ActualEndOfScans="626768" ActualExecutions="626768" ActualExecutionMode="Row" ActualElapsedms="14125" ActualCPUms="13889" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="1162" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="520" OutputMemoryGrant="136" UsedMemoryGrant="520" />
<RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="0" OutputMemoryGrant="0" UsedMemoryGrant="0" />
</RunTimeInformation>
<Sort Distinct="true">
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="Id" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="15" EstimateCPU="4.44651E-06" EstimateIO="0" EstimateRebinds="2465710" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="44.4651" LogicalOp="Concatenation" NodeId="8" Parallel="true" PhysicalOp="Concatenation" EstimatedTotalSubtreeCost="1196.95">
<OutputList>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="Id" />
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="Score" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="5733335" Batches="0" ActualEndOfScans="639502" ActualExecutions="639502" ActualExecutionMode="Row" ActualElapsedms="9121" ActualCPUms="8982" />
<RunTimeCountersPerThread Thread="3" ActualRows="5584459" Batches="0" ActualEndOfScans="608283" ActualExecutions="608283" ActualExecutionMode="Row" ActualElapsedms="8860" ActualCPUms="8719" />
<RunTimeCountersPerThread Thread="2" ActualRows="6215955" Batches="0" ActualEndOfScans="591160" ActualExecutions="591160" ActualExecutionMode="Row" ActualElapsedms="8752" ActualCPUms="8612" />
<RunTimeCountersPerThread Thread="1" ActualRows="5675557" Batches="0" ActualEndOfScans="626768" ActualExecutions="626768" ActualExecutionMode="Row" ActualElapsedms="9166" ActualCPUms="9019" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
</RunTimeInformation>
<Concat>
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="Id" />
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="Id" />
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="Id" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="Score" />
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="Score" />
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="Score" />
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="15" EstimateCPU="0.00017012" EstimateIO="0.003125" EstimateRebinds="2465710" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="11.9275" EstimatedRowsRead="11.9275" LogicalOp="Index Seek" NodeId="9" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="565.046" TableCardinality="17142200">
<OutputList>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="Id" />
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="Score" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="4355422" ActualRowsRead="4355422" Batches="0" ActualEndOfScans="639502" ActualExecutions="639502" ActualExecutionMode="Row" ActualElapsedms="4623" ActualCPUms="4542" ActualScans="1279004" ActualLogicalReads="3852964" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="3" ActualRows="4186841" ActualRowsRead="4186841" Batches="0" ActualEndOfScans="608283" ActualExecutions="608283" ActualExecutionMode="Row" ActualElapsedms="4486" ActualCPUms="4403" ActualScans="1216566" ActualLogicalReads="3664851" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="2" ActualRows="4097658" ActualRowsRead="4097658" Batches="0" ActualEndOfScans="591160" ActualExecutions="591160" ActualExecutionMode="Row" ActualElapsedms="4348" ActualCPUms="4262" ActualScans="1182320" ActualLogicalReads="3561971" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="1" ActualRows="4224617" ActualRowsRead="4224617" Batches="0" ActualEndOfScans="626768" ActualExecutions="626768" ActualExecutionMode="Row" ActualElapsedms="4637" ActualCPUms="4551" ActualScans="1253536" ActualLogicalReads="3775947" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
</RunTimeInformation>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="true" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="Id" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="Score" />
</DefinedValue>
</DefinedValues>
<Object Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Index="[ix_aussie]" Alias="[p]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="OwnerUserId" />
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="PostTypeId" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[StackOverflow2013].[dbo].[Users].[Id] as [u].[Id]">
<Identifier>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="(1)">
<Const ConstValue="(1)" />
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="OwnerUserId" />
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="PostTypeId" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[StackOverflow2013].[dbo].[Users].[Id] as [u].[Id]">
<Identifier>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="(2)">
<Const ConstValue="(2)" />
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
<RelOp AvgRowSize="15" EstimateCPU="0.000192791" EstimateIO="0.003125" EstimateRebinds="2465710" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="32.5376" EstimatedRowsRead="32.5376" LogicalOp="Index Seek" NodeId="10" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="620.943" TableCardinality="17142200">
<OutputList>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="Id" />
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="Score" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="1377913" ActualRowsRead="1377913" Batches="0" ActualEndOfScans="639502" ActualExecutions="639502" ActualExecutionMode="Row" ActualElapsedms="3875" ActualCPUms="3817" ActualScans="1279004" ActualLogicalReads="3844598" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="3" ActualRows="1397618" ActualRowsRead="1397618" Batches="0" ActualEndOfScans="608283" ActualExecutions="608283" ActualExecutionMode="Row" ActualElapsedms="3755" ActualCPUms="3698" ActualScans="1216566" ActualLogicalReads="3656768" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="2" ActualRows="2118297" ActualRowsRead="2118297" Batches="0" ActualEndOfScans="591160" ActualExecutions="591160" ActualExecutionMode="Row" ActualElapsedms="3752" ActualCPUms="3700" ActualScans="1182320" ActualLogicalReads="3556426" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="1" ActualRows="1450940" ActualRowsRead="1450940" Batches="0" ActualEndOfScans="626768" ActualExecutions="626768" ActualExecutionMode="Row" ActualElapsedms="3887" ActualCPUms="3825" ActualScans="1253536" ActualLogicalReads="3768702" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
</RunTimeInformation>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="true" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="Id" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="Score" />
</DefinedValue>
</DefinedValues>
<Object Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Index="[ix_kiwi]" Alias="[p]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="LastEditorUserId" />
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="PostTypeId" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[StackOverflow2013].[dbo].[Users].[Id] as [u].[Id]">
<Identifier>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="(1)">
<Const ConstValue="(1)" />
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="LastEditorUserId" />
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="PostTypeId" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[StackOverflow2013].[dbo].[Users].[Id] as [u].[Id]">
<Identifier>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="(2)">
<Const ConstValue="(2)" />
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</Concat>
</RelOp>
</Sort>
</RelOp>
</NestedLoops>
</RelOp>
</StreamAggregate>
</RelOp>
</Parallelism>
</RelOp>
</Hash>
</RelOp>
</Parallelism>
</RelOp>
</QueryPlan>
</StmtSimple>
</Statements>
</Batch>
</BatchSequence>
</ShowPlanXML>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment