Created
June 30, 2016 00:33
-
-
Save d/4b818610c62f522635eb772109af11b5 to your computer and use it in GitHub Desktop.
jesse_parallel.mdp
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<!-- | |
CREATE TEMP TABLE foo (i int); | |
CREATE TEMP TABLE bar (j int); | |
SELECT * FROM foo UNION ALL SELECT * FROM bar; | |
--> | |
<dxl:DXLMessage xmlns:dxl="http://greenplum.com/dxl/2010/12/"> | |
<dxl:Thread Id="0"> | |
<dxl:OptimizerConfig> | |
<dxl:EnumeratorConfig Id="0" PlanSamples="0" CostThreshold="0"/> | |
<dxl:StatisticsConfig DampingFactorFilter="0.750000" DampingFactorJoin="0.010000" DampingFactorGroupBy="0.750000"/> | |
<dxl:CTEConfig CTEInliningCutoff="0"/> | |
<dxl:CostModelConfig CostModelType="1" SegmentsForCosting="3"/> | |
<dxl:Hint MinNumOfPartsToRequireSortOnInsert="2147483647" JoinArityForAssociativityCommutativity="2147483647" ArrayExpansionThreshold="25"/> | |
<dxl:TraceFlags Value="102120,103001,103014,103015,103022,103025,104004,104005,105000"/> | |
</dxl:OptimizerConfig> | |
<dxl:Metadata SystemIds="0.GPDB"> | |
<dxl:ColumnStatistics Mdid="1.2583743.1.1.5" Name="cmax" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000" ColStatsMissing="true"/> | |
<dxl:ColumnStatistics Mdid="1.2583743.1.1.4" Name="xmax" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000" ColStatsMissing="true"/> | |
<dxl:Type Mdid="0.16.1.0" Name="bool" IsRedistributable="true" IsHashable="true" IsComposite="false" IsFixedLength="true" Length="1" PassByValue="true"> | |
<dxl:EqualityOp Mdid="0.91.1.0"/> | |
<dxl:InequalityOp Mdid="0.85.1.0"/> | |
<dxl:LessThanOp Mdid="0.58.1.0"/> | |
<dxl:LessThanEqualsOp Mdid="0.1694.1.0"/> | |
<dxl:GreaterThanOp Mdid="0.59.1.0"/> | |
<dxl:GreaterThanEqualsOp Mdid="0.1695.1.0"/> | |
<dxl:ComparisonOp Mdid="0.1693.1.0"/> | |
<dxl:ArrayType Mdid="0.1000.1.0"/> | |
<dxl:MinAgg Mdid="0.0.0.0"/> | |
<dxl:MaxAgg Mdid="0.0.0.0"/> | |
<dxl:AvgAgg Mdid="0.0.0.0"/> | |
<dxl:SumAgg Mdid="0.0.0.0"/> | |
<dxl:CountAgg Mdid="0.2147.1.0"/> | |
</dxl:Type> | |
<dxl:Type Mdid="0.23.1.0" Name="int4" IsRedistributable="true" IsHashable="true" IsComposite="false" IsFixedLength="true" Length="4" PassByValue="true"> | |
<dxl:EqualityOp Mdid="0.96.1.0"/> | |
<dxl:InequalityOp Mdid="0.518.1.0"/> | |
<dxl:LessThanOp Mdid="0.97.1.0"/> | |
<dxl:LessThanEqualsOp Mdid="0.523.1.0"/> | |
<dxl:GreaterThanOp Mdid="0.521.1.0"/> | |
<dxl:GreaterThanEqualsOp Mdid="0.525.1.0"/> | |
<dxl:ComparisonOp Mdid="0.351.1.0"/> | |
<dxl:ArrayType Mdid="0.1007.1.0"/> | |
<dxl:MinAgg Mdid="0.2132.1.0"/> | |
<dxl:MaxAgg Mdid="0.2116.1.0"/> | |
<dxl:AvgAgg Mdid="0.2101.1.0"/> | |
<dxl:SumAgg Mdid="0.2108.1.0"/> | |
<dxl:CountAgg Mdid="0.2147.1.0"/> | |
</dxl:Type> | |
<dxl:Type Mdid="0.26.1.0" Name="oid" IsRedistributable="true" IsHashable="true" IsComposite="false" IsFixedLength="true" Length="4" PassByValue="true"> | |
<dxl:EqualityOp Mdid="0.607.1.0"/> | |
<dxl:InequalityOp Mdid="0.608.1.0"/> | |
<dxl:LessThanOp Mdid="0.609.1.0"/> | |
<dxl:LessThanEqualsOp Mdid="0.611.1.0"/> | |
<dxl:GreaterThanOp Mdid="0.610.1.0"/> | |
<dxl:GreaterThanEqualsOp Mdid="0.612.1.0"/> | |
<dxl:ComparisonOp Mdid="0.356.1.0"/> | |
<dxl:ArrayType Mdid="0.1028.1.0"/> | |
<dxl:MinAgg Mdid="0.2118.1.0"/> | |
<dxl:MaxAgg Mdid="0.2134.1.0"/> | |
<dxl:AvgAgg Mdid="0.0.0.0"/> | |
<dxl:SumAgg Mdid="0.0.0.0"/> | |
<dxl:CountAgg Mdid="0.2147.1.0"/> | |
</dxl:Type> | |
<dxl:Type Mdid="0.27.1.0" Name="tid" IsRedistributable="true" IsHashable="false" IsComposite="false" IsFixedLength="true" Length="6" PassByValue="false"> | |
<dxl:EqualityOp Mdid="0.387.1.0"/> | |
<dxl:InequalityOp Mdid="0.402.1.0"/> | |
<dxl:LessThanOp Mdid="0.2799.1.0"/> | |
<dxl:LessThanEqualsOp Mdid="0.2801.1.0"/> | |
<dxl:GreaterThanOp Mdid="0.2800.1.0"/> | |
<dxl:GreaterThanEqualsOp Mdid="0.2802.1.0"/> | |
<dxl:ComparisonOp Mdid="0.2794.1.0"/> | |
<dxl:ArrayType Mdid="0.1010.1.0"/> | |
<dxl:MinAgg Mdid="0.2798.1.0"/> | |
<dxl:MaxAgg Mdid="0.2797.1.0"/> | |
<dxl:AvgAgg Mdid="0.0.0.0"/> | |
<dxl:SumAgg Mdid="0.0.0.0"/> | |
<dxl:CountAgg Mdid="0.2147.1.0"/> | |
</dxl:Type> | |
<dxl:Type Mdid="0.29.1.0" Name="cid" IsRedistributable="false" IsHashable="true" IsComposite="false" IsFixedLength="true" Length="4" PassByValue="true"> | |
<dxl:EqualityOp Mdid="0.385.1.0"/> | |
<dxl:InequalityOp Mdid="0.0.0.0"/> | |
<dxl:LessThanOp Mdid="0.0.0.0"/> | |
<dxl:LessThanEqualsOp Mdid="0.0.0.0"/> | |
<dxl:GreaterThanOp Mdid="0.0.0.0"/> | |
<dxl:GreaterThanEqualsOp Mdid="0.0.0.0"/> | |
<dxl:ComparisonOp Mdid="0.0.0.0"/> | |
<dxl:ArrayType Mdid="0.1012.1.0"/> | |
<dxl:MinAgg Mdid="0.0.0.0"/> | |
<dxl:MaxAgg Mdid="0.0.0.0"/> | |
<dxl:AvgAgg Mdid="0.0.0.0"/> | |
<dxl:SumAgg Mdid="0.0.0.0"/> | |
<dxl:CountAgg Mdid="0.2147.1.0"/> | |
</dxl:Type> | |
<dxl:Type Mdid="0.28.1.0" Name="xid" IsRedistributable="false" IsHashable="true" IsComposite="false" IsFixedLength="true" Length="4" PassByValue="true"> | |
<dxl:EqualityOp Mdid="0.352.1.0"/> | |
<dxl:InequalityOp Mdid="0.0.0.0"/> | |
<dxl:LessThanOp Mdid="0.0.0.0"/> | |
<dxl:LessThanEqualsOp Mdid="0.0.0.0"/> | |
<dxl:GreaterThanOp Mdid="0.0.0.0"/> | |
<dxl:GreaterThanEqualsOp Mdid="0.0.0.0"/> | |
<dxl:ComparisonOp Mdid="0.0.0.0"/> | |
<dxl:ArrayType Mdid="0.1011.1.0"/> | |
<dxl:MinAgg Mdid="0.0.0.0"/> | |
<dxl:MaxAgg Mdid="0.0.0.0"/> | |
<dxl:AvgAgg Mdid="0.0.0.0"/> | |
<dxl:SumAgg Mdid="0.0.0.0"/> | |
<dxl:CountAgg Mdid="0.2147.1.0"/> | |
</dxl:Type> | |
<dxl:ColumnStatistics Mdid="1.2583716.1.1.1" Name="ctid" Width="6.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000" ColStatsMissing="true"/> | |
<dxl:ColumnStatistics Mdid="1.2583716.1.1.0" Name="i" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000" ColStatsMissing="true"/> | |
<dxl:RelationStatistics Mdid="2.2583716.1.1" Name="foo" Rows="0.000000" EmptyRelation="true"/> | |
<dxl:Relation Mdid="0.2583716.1.1" Name="foo" IsTemporary="true" HasOids="false" StorageType="Heap" DistributionPolicy="Hash" DistributionColumns="0" Keys="7,1" NumberLeafPartitions="0"> | |
<dxl:Columns> | |
<dxl:Column Name="i" Attno="1" Mdid="0.23.1.0" Nullable="true"> | |
<dxl:DefaultValue/> | |
</dxl:Column> | |
<dxl:Column Name="ctid" Attno="-1" Mdid="0.27.1.0" Nullable="false"> | |
<dxl:DefaultValue/> | |
</dxl:Column> | |
<dxl:Column Name="xmin" Attno="-3" Mdid="0.28.1.0" Nullable="false"> | |
<dxl:DefaultValue/> | |
</dxl:Column> | |
<dxl:Column Name="cmin" Attno="-4" Mdid="0.29.1.0" Nullable="false"> | |
<dxl:DefaultValue/> | |
</dxl:Column> | |
<dxl:Column Name="xmax" Attno="-5" Mdid="0.28.1.0" Nullable="false"> | |
<dxl:DefaultValue/> | |
</dxl:Column> | |
<dxl:Column Name="cmax" Attno="-6" Mdid="0.29.1.0" Nullable="false"> | |
<dxl:DefaultValue/> | |
</dxl:Column> | |
<dxl:Column Name="tableoid" Attno="-7" Mdid="0.26.1.0" Nullable="false"> | |
<dxl:DefaultValue/> | |
</dxl:Column> | |
<dxl:Column Name="gp_segment_id" Attno="-8" Mdid="0.23.1.0" Nullable="false"> | |
<dxl:DefaultValue/> | |
</dxl:Column> | |
</dxl:Columns> | |
<dxl:Indexes/> | |
<dxl:Triggers/> | |
<dxl:CheckConstraints/> | |
</dxl:Relation> | |
<dxl:ColumnStatistics Mdid="1.2583743.1.1.7" Name="gp_segment_id" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000" ColStatsMissing="true"/> | |
<dxl:ColumnStatistics Mdid="1.2583743.1.1.6" Name="tableoid" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000" ColStatsMissing="true"/> | |
<dxl:RelationStatistics Mdid="2.2583743.1.1" Name="bar" Rows="0.000000" EmptyRelation="true"/> | |
<dxl:Relation Mdid="0.2583743.1.1" Name="bar" IsTemporary="true" HasOids="false" StorageType="Heap" DistributionPolicy="Hash" DistributionColumns="0" Keys="7,1" NumberLeafPartitions="0"> | |
<dxl:Columns> | |
<dxl:Column Name="j" Attno="1" Mdid="0.23.1.0" Nullable="true"> | |
<dxl:DefaultValue/> | |
</dxl:Column> | |
<dxl:Column Name="ctid" Attno="-1" Mdid="0.27.1.0" Nullable="false"> | |
<dxl:DefaultValue/> | |
</dxl:Column> | |
<dxl:Column Name="xmin" Attno="-3" Mdid="0.28.1.0" Nullable="false"> | |
<dxl:DefaultValue/> | |
</dxl:Column> | |
<dxl:Column Name="cmin" Attno="-4" Mdid="0.29.1.0" Nullable="false"> | |
<dxl:DefaultValue/> | |
</dxl:Column> | |
<dxl:Column Name="xmax" Attno="-5" Mdid="0.28.1.0" Nullable="false"> | |
<dxl:DefaultValue/> | |
</dxl:Column> | |
<dxl:Column Name="cmax" Attno="-6" Mdid="0.29.1.0" Nullable="false"> | |
<dxl:DefaultValue/> | |
</dxl:Column> | |
<dxl:Column Name="tableoid" Attno="-7" Mdid="0.26.1.0" Nullable="false"> | |
<dxl:DefaultValue/> | |
</dxl:Column> | |
<dxl:Column Name="gp_segment_id" Attno="-8" Mdid="0.23.1.0" Nullable="false"> | |
<dxl:DefaultValue/> | |
</dxl:Column> | |
</dxl:Columns> | |
<dxl:Indexes/> | |
<dxl:Triggers/> | |
<dxl:CheckConstraints/> | |
</dxl:Relation> | |
<dxl:ColumnStatistics Mdid="1.2583716.1.1.3" Name="cmin" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000" ColStatsMissing="true"/> | |
<dxl:ColumnStatistics Mdid="1.2583716.1.1.2" Name="xmin" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000" ColStatsMissing="true"/> | |
<dxl:ColumnStatistics Mdid="1.2583743.1.1.1" Name="ctid" Width="6.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000" ColStatsMissing="true"/> | |
<dxl:ColumnStatistics Mdid="1.2583743.1.1.0" Name="j" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000" ColStatsMissing="true"/> | |
<dxl:ColumnStatistics Mdid="1.2583716.1.1.5" Name="cmax" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000" ColStatsMissing="true"/> | |
<dxl:ColumnStatistics Mdid="1.2583716.1.1.4" Name="xmax" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000" ColStatsMissing="true"/> | |
<dxl:ColumnStatistics Mdid="1.2583743.1.1.3" Name="cmin" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000" ColStatsMissing="true"/> | |
<dxl:ColumnStatistics Mdid="1.2583743.1.1.2" Name="xmin" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000" ColStatsMissing="true"/> | |
<dxl:ColumnStatistics Mdid="1.2583716.1.1.7" Name="gp_segment_id" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000" ColStatsMissing="true"/> | |
<dxl:ColumnStatistics Mdid="1.2583716.1.1.6" Name="tableoid" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000" ColStatsMissing="true"/> | |
</dxl:Metadata> | |
<dxl:Query> | |
<dxl:OutputColumns> | |
<dxl:Ident ColId="1" ColName="i" TypeMdid="0.23.1.0"/> | |
</dxl:OutputColumns> | |
<dxl:CTEList/> | |
<dxl:UnionAll InputColumns="1;9" CastAcrossInputs="false"> | |
<dxl:Columns> | |
<dxl:Column ColId="1" Attno="1" ColName="i" TypeMdid="0.23.1.0"/> | |
</dxl:Columns> | |
<dxl:LogicalGet> | |
<dxl:TableDescriptor Mdid="0.2583716.1.1" TableName="foo"> | |
<dxl:Columns> | |
<dxl:Column ColId="1" Attno="1" ColName="i" TypeMdid="0.23.1.0"/> | |
<dxl:Column ColId="2" Attno="-1" ColName="ctid" TypeMdid="0.27.1.0"/> | |
<dxl:Column ColId="3" Attno="-3" ColName="xmin" TypeMdid="0.28.1.0"/> | |
<dxl:Column ColId="4" Attno="-4" ColName="cmin" TypeMdid="0.29.1.0"/> | |
<dxl:Column ColId="5" Attno="-5" ColName="xmax" TypeMdid="0.28.1.0"/> | |
<dxl:Column ColId="6" Attno="-6" ColName="cmax" TypeMdid="0.29.1.0"/> | |
<dxl:Column ColId="7" Attno="-7" ColName="tableoid" TypeMdid="0.26.1.0"/> | |
<dxl:Column ColId="8" Attno="-8" ColName="gp_segment_id" TypeMdid="0.23.1.0"/> | |
</dxl:Columns> | |
</dxl:TableDescriptor> | |
</dxl:LogicalGet> | |
<dxl:LogicalGet> | |
<dxl:TableDescriptor Mdid="0.2583743.1.1" TableName="bar"> | |
<dxl:Columns> | |
<dxl:Column ColId="9" Attno="1" ColName="j" TypeMdid="0.23.1.0"/> | |
<dxl:Column ColId="10" Attno="-1" ColName="ctid" TypeMdid="0.27.1.0"/> | |
<dxl:Column ColId="11" Attno="-3" ColName="xmin" TypeMdid="0.28.1.0"/> | |
<dxl:Column ColId="12" Attno="-4" ColName="cmin" TypeMdid="0.29.1.0"/> | |
<dxl:Column ColId="13" Attno="-5" ColName="xmax" TypeMdid="0.28.1.0"/> | |
<dxl:Column ColId="14" Attno="-6" ColName="cmax" TypeMdid="0.29.1.0"/> | |
<dxl:Column ColId="15" Attno="-7" ColName="tableoid" TypeMdid="0.26.1.0"/> | |
<dxl:Column ColId="16" Attno="-8" ColName="gp_segment_id" TypeMdid="0.23.1.0"/> | |
</dxl:Columns> | |
</dxl:TableDescriptor> | |
</dxl:LogicalGet> | |
</dxl:UnionAll> | |
</dxl:Query> | |
<dxl:Plan Id="0" SpaceSize="0"> | |
<dxl:GatherMotion InputSegments="0,1,2" OutputSegments="-1"> | |
<dxl:Properties> | |
<dxl:Cost StartupCost="0" TotalCost="862.000069" Rows="1.000000" Width="4"/> | |
</dxl:Properties> | |
<dxl:ProjList> | |
<dxl:ProjElem ColId="0" Alias="i"> | |
<dxl:Ident ColId="0" ColName="i" TypeMdid="0.23.1.0"/> | |
</dxl:ProjElem> | |
</dxl:ProjList> | |
<dxl:Filter/> | |
<dxl:SortingColumnList/> | |
<dxl:Append IsTarget="false" IsZapped="false"> | |
<dxl:Properties> | |
<dxl:Cost StartupCost="0" TotalCost="862.000054" Rows="1.000000" Width="4"/> | |
</dxl:Properties> | |
<dxl:ProjList> | |
<dxl:ProjElem ColId="0" Alias="i"> | |
<dxl:Ident ColId="0" ColName="i" TypeMdid="0.23.1.0"/> | |
</dxl:ProjElem> | |
</dxl:ProjList> | |
<dxl:Filter/> | |
<dxl:TableScan> | |
<dxl:Properties> | |
<dxl:Cost StartupCost="0" TotalCost="431.000019" Rows="1.000000" Width="4"/> | |
</dxl:Properties> | |
<dxl:ProjList> | |
<dxl:ProjElem ColId="0" Alias="i"> | |
<dxl:Ident ColId="0" ColName="i" TypeMdid="0.23.1.0"/> | |
</dxl:ProjElem> | |
</dxl:ProjList> | |
<dxl:Filter/> | |
<dxl:TableDescriptor Mdid="0.2583716.1.1" TableName="foo"> | |
<dxl:Columns> | |
<dxl:Column ColId="0" Attno="1" ColName="i" TypeMdid="0.23.1.0"/> | |
<dxl:Column ColId="1" Attno="-1" ColName="ctid" TypeMdid="0.27.1.0"/> | |
<dxl:Column ColId="2" Attno="-3" ColName="xmin" TypeMdid="0.28.1.0"/> | |
<dxl:Column ColId="3" Attno="-4" ColName="cmin" TypeMdid="0.29.1.0"/> | |
<dxl:Column ColId="4" Attno="-5" ColName="xmax" TypeMdid="0.28.1.0"/> | |
<dxl:Column ColId="5" Attno="-6" ColName="cmax" TypeMdid="0.29.1.0"/> | |
<dxl:Column ColId="6" Attno="-7" ColName="tableoid" TypeMdid="0.26.1.0"/> | |
<dxl:Column ColId="7" Attno="-8" ColName="gp_segment_id" TypeMdid="0.23.1.0"/> | |
</dxl:Columns> | |
</dxl:TableDescriptor> | |
</dxl:TableScan> | |
<dxl:TableScan> | |
<dxl:Properties> | |
<dxl:Cost StartupCost="0" TotalCost="431.000019" Rows="1.000000" Width="4"/> | |
</dxl:Properties> | |
<dxl:ProjList> | |
<dxl:ProjElem ColId="8" Alias="j"> | |
<dxl:Ident ColId="8" ColName="j" TypeMdid="0.23.1.0"/> | |
</dxl:ProjElem> | |
</dxl:ProjList> | |
<dxl:Filter/> | |
<dxl:TableDescriptor Mdid="0.2583743.1.1" TableName="bar"> | |
<dxl:Columns> | |
<dxl:Column ColId="8" Attno="1" ColName="j" TypeMdid="0.23.1.0"/> | |
<dxl:Column ColId="9" Attno="-1" ColName="ctid" TypeMdid="0.27.1.0"/> | |
<dxl:Column ColId="10" Attno="-3" ColName="xmin" TypeMdid="0.28.1.0"/> | |
<dxl:Column ColId="11" Attno="-4" ColName="cmin" TypeMdid="0.29.1.0"/> | |
<dxl:Column ColId="12" Attno="-5" ColName="xmax" TypeMdid="0.28.1.0"/> | |
<dxl:Column ColId="13" Attno="-6" ColName="cmax" TypeMdid="0.29.1.0"/> | |
<dxl:Column ColId="14" Attno="-7" ColName="tableoid" TypeMdid="0.26.1.0"/> | |
<dxl:Column ColId="15" Attno="-8" ColName="gp_segment_id" TypeMdid="0.23.1.0"/> | |
</dxl:Columns> | |
</dxl:TableDescriptor> | |
</dxl:TableScan> | |
</dxl:Append> | |
</dxl:GatherMotion> | |
</dxl:Plan> | |
</dxl:Thread> | |
</dxl:DXLMessage> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment