Skip to content

Instantly share code, notes, and snippets.

@rusanu

rusanu/72604.plan

Created July 30, 2014 06:32
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rusanu/bd478cf99d472937375e to your computer and use it in GitHub Desktop.
Save rusanu/bd478cf99d472937375e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
72604.plan
<?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.3128.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementCompId="1" StatementEstRows="1000000" StatementId="1" StatementOptmLevel="FULL" StatementSubTreeCost="62.1708" StatementText="insert [dbo].[foo] select * from [dbo].[foo]" StatementType="INSERT" QueryHash="0x5C849102FA5C1003" QueryPlanHash="0xEF52C9161E6E3B36" RetrievedFromCache="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="90248" CachedPlanSize="16" CompileTime="369" CompileCPU="366" CompileMemory="136">
<ThreadStat Branches="1" UsedThreads="4">
<ThreadReservation NodeId="0" ReservedThreads="4" />
</ThreadStat>
<MemoryGrantInfo SerialRequiredMemory="2048" SerialDesiredMemory="84024" RequiredMemory="8264" DesiredMemory="90248" RequestedMemory="90248" GrantWaitTime="0" GrantedMemory="90248" MaxUsedMemory="65136" />
<OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="205078" EstimatedPagesCached="51269" EstimatedAvailableDegreeOfParallelism="2" />
<RelOp AvgRowSize="9" EstimateCPU="0.65475" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1000000" LogicalOp="Gather Streams" NodeId="0" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="62.1708">
<OutputList />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Parallelism>
<RelOp AvgRowSize="9" EstimateCPU="0.5" EstimateIO="11.1364" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1000000" LogicalOp="Insert" NodeId="1" Parallel="true" PhysicalOp="Index Insert" EstimatedTotalSubtreeCost="61.516">
<OutputList />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<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="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<CreateIndex>
<Object Database="[test]" Schema="[dbo]" Table="[foo]" Index="[ndxval]" IndexKind="NonClustered" />
<RelOp AvgRowSize="27" EstimateCPU="45.743" EstimateIO="0.00563063" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1000000" LogicalOp="Sort" NodeId="2" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="49.8796">
<OutputList>
<ColumnReference Column="RowRefSrc1008" />
</OutputList>
<MemoryFractions Input="1" Output="1" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRebinds="1" ActualRewinds="0" ActualRows="261744" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="1" ActualRebinds="1" ActualRewinds="0" ActualRows="247940" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="3" ActualRebinds="1" ActualRewinds="0" ActualRows="248154" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="2" ActualRebinds="1" ActualRewinds="0" ActualRows="242162" 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="[test]" Schema="[dbo]" Table="[foo]" Column="val" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[test]" Schema="[dbo]" Table="[foo]" Column="id" />
</OrderByColumn>
</OrderBy>
<PartitionId>
<ColumnReference Database="[test]" Schema="[dbo]" Table="[foo]" Column="val" />
</PartitionId>
<RelOp AvgRowSize="27" EstimateCPU="0.550079" EstimateIO="3.5809" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1000000" LogicalOp="Clustered Index Scan" NodeId="3" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="4.13098" TableCardinality="1000000">
<OutputList>
<ColumnReference Database="[test]" Schema="[dbo]" Table="[foo]" Column="id" />
<ColumnReference Database="[test]" Schema="[dbo]" Table="[foo]" Column="val" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="237015" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="4" ActualRows="261217" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="3" ActualRows="250470" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
<RunTimeCountersPerThread Thread="2" ActualRows="251298" 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="[test]" Schema="[dbo]" Table="[foo]" Column="id" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[test]" Schema="[dbo]" Table="[foo]" Column="val" />
</DefinedValue>
</DefinedValues>
<Object Database="[test]" Schema="[dbo]" Table="[foo]" Index="[PK__foo__3213E83F8E96140E]" IndexKind="Clustered" />
</IndexScan>
</RelOp>
</Sort>
</RelOp>
</CreateIndex>
</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