Skip to content

Instantly share code, notes, and snippets.

@erikdarlingdata
Created May 27, 2019 21:36
Show Gist options
  • Save erikdarlingdata/57a31be1017e9c8b53d8ceaa9e08a39d to your computer and use it in GitHub Desktop.
Save erikdarlingdata/57a31be1017e9c8b53d8ceaa9e08a39d to your computer and use it in GitHub Desktop.
<?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="2" StatementOptmLevel="FULL" CardinalityEstimationModelVersion="140" StatementSubTreeCost="2946.25" StatementText="SELECT u.Id, MAX(p.Score)&#xD;&#xA;FROM dbo.Users AS u&#xD;&#xA;JOIN dbo.Posts AS p&#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="0x823F9B3EE203B8F6" QueryPlanHash="0x7E6B2694BB44B684" RetrievedFromCache="true" StatementSqlHandle="0x0900BDA7CA6D6D30D7730F547E0FB79131270000000000000000000000000000000000000000000000000000" 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="238344" CachedPlanSize="64" CompileTime="3" CompileCPU="3" CompileMemory="312">
<ThreadStat Branches="2" UsedThreads="8">
<ThreadReservation NodeId="0" ReservedThreads="8" />
</ThreadStat>
<MemoryGrantInfo SerialRequiredMemory="1040" SerialDesiredMemory="234856" RequiredMemory="4520" DesiredMemory="238344" RequestedMemory="238344" GrantWaitTime="0" GrantedMemory="238344" MaxUsedMemory="98128" MaxQueryMemory="9702144" />
<OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="655360" EstimatedPagesCached="327680" EstimatedAvailableDegreeOfParallelism="4" MaxCompileMemory="37928696" />
<OptimizerStatsUsage>
<StatisticsInfo Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Statistics="[_WA_Sys_00000010_0519C6AF]" ModificationCount="0" SamplingPercent="0.832736" LastUpdate="2019-05-27T17:02:24.35" />
<StatisticsInfo Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Statistics="[ix_36chambers]" ModificationCount="0" SamplingPercent="100" LastUpdate="2019-05-27T17:02:04.38" />
</OptimizerStatsUsage>
<WaitStats>
<Wait WaitType="SOS_SCHEDULER_YIELD" WaitTimeMs="5606" WaitCount="94345" />
<Wait WaitType="ASYNC_NETWORK_IO" WaitTimeMs="6447" WaitCount="3522" />
<Wait WaitType="MEMORY_ALLOCATION_EXT" WaitTimeMs="10382" WaitCount="21228793" />
<Wait WaitType="RESERVED_MEMORY_ALLOCATION_EXT" WaitTimeMs="12583" WaitCount="34195408" />
<Wait WaitType="CXPACKET" WaitTimeMs="121081" WaitCount="14871" />
</WaitStats>
<QueryTimeStats CpuTime="384246" ElapsedTime="103312" />
<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="2946.25">
<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="96519" ActualCPUms="153" />
</RunTimeInformation>
<Parallelism>
<RelOp AvgRowSize="15" EstimateCPU="30.2773" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2465710" LogicalOp="Aggregate" NodeId="1" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="2944.6">
<OutputList>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" />
<ColumnReference Column="Expr1002" />
</OutputList>
<MemoryFractions Input="0.999966" Output="1" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="360528" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="96399" ActualCPUms="1382" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="59472" OutputMemoryGrant="59480" UsedMemoryGrant="24448" />
<RunTimeCountersPerThread Thread="3" ActualRows="359704" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="96397" ActualCPUms="1249" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="59472" OutputMemoryGrant="59480" UsedMemoryGrant="24424" />
<RunTimeCountersPerThread Thread="2" ActualRows="359583" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="96397" ActualCPUms="1267" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="59472" OutputMemoryGrant="59480" UsedMemoryGrant="24456" />
<RunTimeCountersPerThread Thread="1" ActualRows="360486" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="96398" ActualCPUms="1274" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="59472" OutputMemoryGrant="59480" 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([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>
<HashKeysBuild>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" />
</HashKeysBuild>
<RelOp AvgRowSize="15" EstimateCPU="13.4751" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="17046600" LogicalOp="Repartition Streams" NodeId="2" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="2914.32">
<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="5412540" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="95244" ActualCPUms="227" />
<RunTimeCountersPerThread Thread="3" ActualRows="4733431" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="95339" ActualCPUms="191" />
<RunTimeCountersPerThread Thread="2" ActualRows="4852220" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="95337" ActualCPUms="207" />
<RunTimeCountersPerThread Thread="1" ActualRows="4893454" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="95334" ActualCPUms="210" />
<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="17.8137" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="17046600" LogicalOp="Inner Join" NodeId="3" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="2900.84">
<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="5088719" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="94315" ActualCPUms="93052" />
<RunTimeCountersPerThread Thread="3" ActualRows="5069363" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="94950" ActualCPUms="93664" />
<RunTimeCountersPerThread Thread="2" ActualRows="4962520" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="94067" ActualCPUms="92677" />
<RunTimeCountersPerThread Thread="1" ActualRows="4771043" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="94636" ActualCPUms="93160" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
</RunTimeInformation>
<NestedLoops Optimized="false">
<OuterReferences>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="LastEditorUserId" />
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="OwnerUserId" />
</OuterReferences>
<RelOp AvgRowSize="23" EstimateCPU="4.71414" EstimateIO="40.8335" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="17046600" EstimatedRowsRead="17142200" LogicalOp="Index Scan" NodeId="4" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="45.5476" TableCardinality="17142200">
<OutputList>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="LastEditorUserId" />
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="OwnerUserId" />
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="Score" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="4341921" ActualRowsRead="4352961" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1442" ActualCPUms="1442" ActualScans="1" ActualLogicalReads="14242" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="3" ActualRows="4303110" ActualRowsRead="4314192" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1484" ActualCPUms="1483" ActualScans="1" ActualLogicalReads="14112" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="2" ActualRows="4303464" ActualRowsRead="4321129" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1463" ActualCPUms="1463" ActualScans="1" ActualLogicalReads="14140" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="1" ActualRows="4143077" ActualRowsRead="4153887" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1425" ActualCPUms="1425" ActualScans="1" ActualLogicalReads="13591" 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" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="LastEditorUserId" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="OwnerUserId" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="Score" />
</DefinedValue>
</DefinedValues>
<Object Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Index="[ix_36chambers]" Alias="[p]" IndexKind="NonClustered" Storage="RowStore" />
<Predicate>
<ScalarOperator ScalarString="[StackOverflow2013].[dbo].[Posts].[PostTypeId] as [p].[PostTypeId]=(1) OR [StackOverflow2013].[dbo].[Posts].[PostTypeId] as [p].[PostTypeId]=(2)">
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="PostTypeId" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="PostTypeId" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(2)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="17046600" EstimateRewinds="3.27556" EstimatedExecutionMode="Row" EstimateRows="1" EstimatedRowsRead="1" LogicalOp="Inner Join" NodeId="5" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="2833.71" TableCardinality="2465710">
<OutputList>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="5088719" Batches="0" ActualEndOfScans="4341921" ActualExecutions="4341921" ActualExecutionMode="Row" ActualElapsedms="89661" ActualCPUms="88404" />
<RunTimeCountersPerThread Thread="3" ActualRows="5069363" Batches="0" ActualEndOfScans="4303110" ActualExecutions="4303110" ActualExecutionMode="Row" ActualElapsedms="90135" ActualCPUms="88858" />
<RunTimeCountersPerThread Thread="2" ActualRows="4962520" Batches="0" ActualEndOfScans="4303464" ActualExecutions="4303464" ActualExecutionMode="Row" ActualElapsedms="89390" ActualCPUms="88006" />
<RunTimeCountersPerThread Thread="1" ActualRows="4771043" Batches="0" ActualEndOfScans="4143077" ActualExecutions="4143077" ActualExecutionMode="Row" ActualElapsedms="90120" ActualCPUms="88648" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
</RunTimeInformation>
<NestedLoops Optimized="false">
<OuterReferences>
<ColumnReference Column="Expr1010" />
<ColumnReference Column="Expr1011" />
<ColumnReference Column="Expr1012" />
</OuterReferences>
<RelOp AvgRowSize="19" EstimateCPU="0" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2" LogicalOp="Merge Interval" NodeId="6" Parallel="true" PhysicalOp="Merge Interval" EstimatedTotalSubtreeCost="0">
<OutputList>
<ColumnReference Column="Expr1010" />
<ColumnReference Column="Expr1011" />
<ColumnReference Column="Expr1012" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="7823421" Batches="0" ActualEndOfScans="4341921" ActualExecutions="4341921" ActualExecutionMode="Row" ActualElapsedms="63623" ActualCPUms="62992" />
<RunTimeCountersPerThread Thread="3" ActualRows="7777687" Batches="0" ActualEndOfScans="4303110" ActualExecutions="4303110" ActualExecutionMode="Row" ActualElapsedms="63666" ActualCPUms="63035" />
<RunTimeCountersPerThread Thread="2" ActualRows="7704931" Batches="0" ActualEndOfScans="4303464" ActualExecutions="4303464" ActualExecutionMode="Row" ActualElapsedms="63372" ActualCPUms="62696" />
<RunTimeCountersPerThread Thread="1" ActualRows="7393969" Batches="0" ActualEndOfScans="4143077" ActualExecutions="4143077" ActualExecutionMode="Row" ActualElapsedms="64562" ActualCPUms="63854" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
</RunTimeInformation>
<MergeInterval>
<RelOp AvgRowSize="19" EstimateCPU="0" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2" LogicalOp="TopN Sort" NodeId="7" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="0">
<OutputList>
<ColumnReference Column="Expr1010" />
<ColumnReference Column="Expr1011" />
<ColumnReference Column="Expr1012" />
<ColumnReference Column="Expr1013" />
<ColumnReference Column="Expr1014" />
<ColumnReference Column="Expr1015" />
</OutputList>
<MemoryFractions Input="3.42149E-05" Output="3.42149E-05" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRebinds="1014854" ActualRewinds="3327067" ActualRows="8683842" Batches="0" ActualEndOfScans="4341921" ActualExecutions="4341921" ActualExecutionMode="Row" ActualElapsedms="60256" ActualCPUms="59626" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="16" OutputMemoryGrant="16" UsedMemoryGrant="16" />
<RunTimeCountersPerThread Thread="3" ActualRebinds="1025724" ActualRewinds="3277386" ActualRows="8606220" Batches="0" ActualEndOfScans="4303110" ActualExecutions="4303110" ActualExecutionMode="Row" ActualElapsedms="60269" ActualCPUms="59637" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="16" OutputMemoryGrant="16" UsedMemoryGrant="16" />
<RunTimeCountersPerThread Thread="2" ActualRebinds="971919" ActualRewinds="3331545" ActualRows="8606928" Batches="0" ActualEndOfScans="4303464" ActualExecutions="4303464" ActualExecutionMode="Row" ActualElapsedms="60009" ActualCPUms="59333" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="16" OutputMemoryGrant="16" UsedMemoryGrant="16" />
<RunTimeCountersPerThread Thread="1" ActualRebinds="961625" ActualRewinds="3181452" ActualRows="8286154" Batches="0" ActualEndOfScans="4143077" ActualExecutions="4143077" ActualExecutionMode="Row" ActualElapsedms="61282" ActualCPUms="60574" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="16" OutputMemoryGrant="16" UsedMemoryGrant="16" />
<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>
<TopSort Distinct="false" Rows="2">
<OrderBy>
<OrderByColumn Ascending="false">
<ColumnReference Column="Expr1013" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Column="Expr1014" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Column="Expr1010" />
</OrderByColumn>
<OrderByColumn Ascending="false">
<ColumnReference Column="Expr1015" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="19" EstimateCPU="0" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2" LogicalOp="Compute Scalar" NodeId="8" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0">
<OutputList>
<ColumnReference Column="Expr1010" />
<ColumnReference Column="Expr1011" />
<ColumnReference Column="Expr1012" />
<ColumnReference Column="Expr1013" />
<ColumnReference Column="Expr1014" />
<ColumnReference Column="Expr1015" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1013" />
<ScalarOperator ScalarString="((4)&amp;[Expr1012]) = (4) AND NULL = [Expr1010]">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="IS">
<ScalarOperator>
<Arithmetic Operation="BIT_AND">
<ScalarOperator>
<Const ConstValue="(4)" />
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1012" />
</Identifier>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(4)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="IS">
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1010" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1014" />
<ScalarOperator ScalarString="(4)&amp;[Expr1012]">
<Arithmetic Operation="BIT_AND">
<ScalarOperator>
<Const ConstValue="(4)" />
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1012" />
</Identifier>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1015" />
<ScalarOperator ScalarString="(16)&amp;[Expr1012]">
<Arithmetic Operation="BIT_AND">
<ScalarOperator>
<Const ConstValue="(16)" />
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1012" />
</Identifier>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="19" EstimateCPU="0" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2" LogicalOp="Concatenation" NodeId="9" Parallel="true" PhysicalOp="Concatenation" EstimatedTotalSubtreeCost="0">
<OutputList>
<ColumnReference Column="Expr1010" />
<ColumnReference Column="Expr1011" />
<ColumnReference Column="Expr1012" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="8683842" Batches="0" ActualEndOfScans="4341921" ActualExecutions="4341921" ActualExecutionMode="Row" ActualElapsedms="3527" ActualCPUms="3527" />
<RunTimeCountersPerThread Thread="3" ActualRows="8606220" Batches="0" ActualEndOfScans="4303110" ActualExecutions="4303110" ActualExecutionMode="Row" ActualElapsedms="3600" ActualCPUms="3600" />
<RunTimeCountersPerThread Thread="2" ActualRows="8606928" Batches="0" ActualEndOfScans="4303464" ActualExecutions="4303464" ActualExecutionMode="Row" ActualElapsedms="3541" ActualCPUms="3541" />
<RunTimeCountersPerThread Thread="1" ActualRows="8286154" Batches="0" ActualEndOfScans="4143077" ActualExecutions="4143077" ActualExecutionMode="Row" ActualElapsedms="3439" ActualCPUms="3439" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
</RunTimeInformation>
<Concat>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1010" />
<ColumnReference Column="Expr1005" />
<ColumnReference Column="Expr1008" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1011" />
<ColumnReference Column="Expr1006" />
<ColumnReference Column="Expr1009" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1012" />
<ColumnReference Column="Expr1004" />
<ColumnReference Column="Expr1007" />
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="19" EstimateCPU="0" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="10" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0">
<OutputList>
<ColumnReference Column="Expr1005" />
<ColumnReference Column="Expr1006" />
<ColumnReference Column="Expr1004" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1005" />
<ScalarOperator ScalarString="[StackOverflow2013].[dbo].[Posts].[OwnerUserId] as [p].[OwnerUserId]">
<Identifier>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="OwnerUserId" />
</Identifier>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1006" />
<ScalarOperator ScalarString="[StackOverflow2013].[dbo].[Posts].[OwnerUserId] as [p].[OwnerUserId]">
<Identifier>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="OwnerUserId" />
</Identifier>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1004" />
<ScalarOperator ScalarString="(62)">
<Const ConstValue="(62)" />
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="0" EstimateCPU="0" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Constant Scan" NodeId="11" Parallel="true" PhysicalOp="Constant Scan" EstimatedTotalSubtreeCost="0">
<OutputList />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="4341921" Batches="0" ActualEndOfScans="4341921" ActualExecutions="4341921" ActualExecutionMode="Row" ActualElapsedms="578" ActualCPUms="578" />
<RunTimeCountersPerThread Thread="3" ActualRows="4303110" Batches="0" ActualEndOfScans="4303110" ActualExecutions="4303110" ActualExecutionMode="Row" ActualElapsedms="570" ActualCPUms="570" />
<RunTimeCountersPerThread Thread="2" ActualRows="4303464" Batches="0" ActualEndOfScans="4303464" ActualExecutions="4303464" ActualExecutionMode="Row" ActualElapsedms="569" ActualCPUms="569" />
<RunTimeCountersPerThread Thread="1" ActualRows="4143077" Batches="0" ActualEndOfScans="4143077" ActualExecutions="4143077" ActualExecutionMode="Row" ActualElapsedms="550" ActualCPUms="550" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
</RunTimeInformation>
<ConstantScan />
</RelOp>
</ComputeScalar>
</RelOp>
<RelOp AvgRowSize="19" EstimateCPU="0" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="12" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0">
<OutputList>
<ColumnReference Column="Expr1008" />
<ColumnReference Column="Expr1009" />
<ColumnReference Column="Expr1007" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1008" />
<ScalarOperator ScalarString="[StackOverflow2013].[dbo].[Posts].[LastEditorUserId] as [p].[LastEditorUserId]">
<Identifier>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="LastEditorUserId" />
</Identifier>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1009" />
<ScalarOperator ScalarString="[StackOverflow2013].[dbo].[Posts].[LastEditorUserId] as [p].[LastEditorUserId]">
<Identifier>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="LastEditorUserId" />
</Identifier>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1007" />
<ScalarOperator ScalarString="(62)">
<Const ConstValue="(62)" />
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="0" EstimateCPU="0" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Constant Scan" NodeId="13" Parallel="true" PhysicalOp="Constant Scan" EstimatedTotalSubtreeCost="0">
<OutputList />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="4341921" Batches="0" ActualEndOfScans="4341921" ActualExecutions="4341921" ActualExecutionMode="Row" ActualElapsedms="433" ActualCPUms="433" />
<RunTimeCountersPerThread Thread="3" ActualRows="4303110" Batches="0" ActualEndOfScans="4303110" ActualExecutions="4303110" ActualExecutionMode="Row" ActualElapsedms="445" ActualCPUms="445" />
<RunTimeCountersPerThread Thread="2" ActualRows="4303464" Batches="0" ActualEndOfScans="4303464" ActualExecutions="4303464" ActualExecutionMode="Row" ActualElapsedms="428" ActualCPUms="428" />
<RunTimeCountersPerThread Thread="1" ActualRows="4143077" Batches="0" ActualEndOfScans="4143077" ActualExecutions="4143077" ActualExecutionMode="Row" ActualElapsedms="417" ActualCPUms="417" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
</RunTimeInformation>
<ConstantScan />
</RelOp>
</ComputeScalar>
</RelOp>
</Concat>
</RelOp>
</ComputeScalar>
</RelOp>
</TopSort>
</RelOp>
</MergeInterval>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="17046600" EstimateRewinds="3.27556" EstimatedExecutionMode="Row" EstimateRows="1" EstimatedRowsRead="1" LogicalOp="Clustered Index Seek" NodeId="14" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="2833.71" TableCardinality="2465710">
<OutputList>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="5088719" ActualRowsRead="5088719" Batches="0" ActualEndOfScans="7823421" ActualExecutions="7823421" ActualExecutionMode="Row" ActualElapsedms="23287" ActualCPUms="22671" ActualScans="7823421" ActualLogicalReads="23590213" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="3" ActualRows="5069363" ActualRowsRead="5069363" Batches="0" ActualEndOfScans="7777687" ActualExecutions="7777687" ActualExecutionMode="Row" ActualElapsedms="23721" ActualCPUms="23084" ActualScans="7777687" ActualLogicalReads="23455971" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="2" ActualRows="4962520" ActualRowsRead="4962520" Batches="0" ActualEndOfScans="7704931" ActualExecutions="7704931" ActualExecutionMode="Row" ActualElapsedms="23318" ActualCPUms="22619" ActualScans="7704931" ActualLogicalReads="23236512" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="1" ActualRows="4771043" ActualRowsRead="4771043" Batches="0" ActualEndOfScans="7393969" ActualExecutions="7393969" ActualExecutionMode="Row" ActualElapsedms="22873" ActualCPUms="22123" ActualScans="7393969" ActualLogicalReads="22297863" 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="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" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<StartRange ScanType="GT">
<RangeColumns>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[Expr1010]">
<Identifier>
<ColumnReference Column="Expr1010" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</StartRange>
<EndRange ScanType="LT">
<RangeColumns>
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[Expr1011]">
<Identifier>
<ColumnReference Column="Expr1011" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</EndRange>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
</NestedLoops>
</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