You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudberry.apache.org by ma...@apache.org on 2025/02/07 09:28:15 UTC
(cloudberry) 01/34: Adding motion when join columns in NLJ belong to different Opfamiliy =====================================================================
This is an automated email from the ASF dual-hosted git repository.
maxyang pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/cloudberry.git
commit 86170a2dbd582239a96027f2b04a41bd0bc04c44
Author: DevChattopadhyay <cd...@vmware.com>
AuthorDate: Mon Mar 27 15:54:38 2023 +0530
Adding motion when join columns in NLJ belong to different Opfamiliy
=====================================================================
This PR implements a motion on the inner relation when a NLJ is performed and
the join condition contains distribution key of the outer relation.If the two
columns used in the join condition belongs to different opfamily then a motion
is added.
Setup:
======
```
create table foo (a char(5));
create table bar (p varchar(5));
insert into foo values ('1 '),('2 '),('3 ');
insert into bar values ('1 '),('2 '),('3 ');
set optimizer_enable_hashjoin to off;
```
Current Behaviour:
==================
```
explain select * from foo left join bar on foo.a=bar.p;
QUERY PLAN
-----------------------------------------------------------------------------------
Gather Motion 3:1 (slice1; segments: 3) (cost=0.00..1324032.37 rows=2 width=16)
-> Nested Loop Left Join (cost=0.00..1324032.37 rows=1 width=16)
Join Filter: (foo.a = (bar.p)::bpchar)
-> Seq Scan on foo (cost=0.00..431.00 rows=1 width=8)
-> Seq Scan on bar (cost=0.00..431.00 rows=1 width=8)
Optimizer: Pivotal Optimizer (GPORCA)
(6 rows)
select * from foo left join bar on foo.a=bar.p;
a | p
-------+-----
2 | 2
3 |
1 |
(3 rows)
```
After Fix:
==========
```
explain select * from foo left join bar on foo.a=bar.p;
QUERY PLAN
------------------------------------------------------------------------------------------------------
Gather Motion 3:1 (slice1; segments: 3) (cost=0.00..1324032.41 rows=2 width=16)
-> Nested Loop Left Join (cost=0.00..1324032.41 rows=1 width=16)
Join Filter: (foo.a = (bar.p)::bpchar)
-> Seq Scan on foo (cost=0.00..431.00 rows=1 width=8)
-> Materialize (cost=0.00..431.00 rows=1 width=8)
-> Redistribute Motion 3:3 (slice2; segments: 3) (cost=0.00..431.00 rows=1 width=8)
Hash Key: bar.p
-> Seq Scan on bar (cost=0.00..431.00 rows=1 width=8)
Optimizer: Pivotal Optimizer (GPORCA)
(9 rows)
select * from foo left join bar on foo.a=bar.p;
a | p
-------+------
2 | 2
3 | 3
1 | 1
(3 rows)
```
---
.../gporca/data/dxl/minidump/BitmapIndexScan.mdp | 12 +
.../dxl/minidump/Correlation-With-Casting-1.mdp | 7 +
.../data/dxl/minidump/DynamicBitmapIndexScan.mdp | 40 +-
.../IndexApply-IndexOnCoordinatorOnlyTable.mdp | 2366 ++++++++++++++++++++
.../data/dxl/minidump/Join-INDF-NoBroadcast.mdp | 8 +-
.../minidump/Join-INDF-Nulls-Not-Collocated.mdp | 10 +-
.../data/dxl/minidump/NLJ-DistCol-No-Broadcast.mdp | 8 +-
.../dxl/minidump/NLJ-EqAllCol-No-Broadcast.mdp | 165 +-
.../NLJ-EqDistCol-InEqNonDistCol-No-Broadcast.mdp | 8 +-
.../NLJ-InEqDistCol-EqNonDistCol-Redistribute.mdp | 10 +-
.../include/gpopt/mdcache/CMDAccessorUtils.h | 4 +
.../libgpopt/src/mdcache/CMDAccessorUtils.cpp | 27 +
.../libgpopt/src/operators/CPhysicalJoin.cpp | 43 +-
13 files changed, 2622 insertions(+), 86 deletions(-)
diff --git a/src/backend/gporca/data/dxl/minidump/BitmapIndexScan.mdp b/src/backend/gporca/data/dxl/minidump/BitmapIndexScan.mdp
index 500af06f9f..05ddfe397b 100644
--- a/src/backend/gporca/data/dxl/minidump/BitmapIndexScan.mdp
+++ b/src/backend/gporca/data/dxl/minidump/BitmapIndexScan.mdp
@@ -169,8 +169,14 @@ see sql/BitmapIndexScan.sql
<dxl:IndexInfo Mdid="0.24762.1.0" IsPartial="false"/>
</dxl:IndexInfoList>
<dxl:CheckConstraints/>
+ <dxl:DistrOpfamilies>
+ <dxl:DistrOpfamily Mdid="0.1998.1.0"/>
+ <dxl:DistrOpfamily Mdid="0.1998.1.0"/>
+ </dxl:DistrOpfamilies>
</dxl:Relation>
<dxl:Type Mdid="0.1700.1.0" Name="numeric" IsRedistributable="true" IsHashable="true" IsMergeJoinable="true" IsComposite="false" IsFixedLength="false" Length="-1" PassByValue="false">
+ <dxl:DistrOpfamily Mdid="0.1998.1.0"/>
+ <dxl:LegacyDistrOpfamily Mdid="0.7103.1.0"/>
<dxl:EqualityOp Mdid="0.1752.1.0"/>
<dxl:InequalityOp Mdid="0.1753.1.0"/>
<dxl:LessThanOp Mdid="0.1754.1.0"/>
@@ -250,6 +256,9 @@ see sql/BitmapIndexScan.sql
</dxl:Columns>
<dxl:IndexInfoList/>
<dxl:CheckConstraints/>
+ <dxl:DistrOpfamilies>
+ <dxl:DistrOpfamily Mdid="0.1998.1.0"/>
+ </dxl:DistrOpfamilies>
</dxl:Relation>
<dxl:GPDBScalarOp Mdid="0.1752.1.0" Name="=" ComparisonType="Eq" ReturnsNullOnNullInput="true">
<dxl:LeftType Mdid="0.1700.1.0"/>
@@ -345,6 +354,9 @@ see sql/BitmapIndexScan.sql
</dxl:Columns>
<dxl:IndexInfoList/>
<dxl:CheckConstraints/>
+ <dxl:DistrOpfamilies>
+ <dxl:DistrOpfamily Mdid="0.1998.1.0"/>
+ </dxl:DistrOpfamilies>
</dxl:Relation>
</dxl:Metadata>
<dxl:Query>
diff --git a/src/backend/gporca/data/dxl/minidump/Correlation-With-Casting-1.mdp b/src/backend/gporca/data/dxl/minidump/Correlation-With-Casting-1.mdp
index cc6f0582a3..a4042a58fe 100644
--- a/src/backend/gporca/data/dxl/minidump/Correlation-With-Casting-1.mdp
+++ b/src/backend/gporca/data/dxl/minidump/Correlation-With-Casting-1.mdp
@@ -51,6 +51,8 @@ AND u_folio = (SELECT max(u_folio) FROM q68t792_temp c WHERE a.u_vtgnr = c.u_vt
<dxl:CountAgg Mdid="0.2147.1.0"/>
</dxl:Type>
<dxl:Type Mdid="0.1043.1.0" Name="varchar" IsRedistributable="true" IsHashable="true" IsMergeJoinable="true" IsComposite="false" IsTextRelated="true" IsFixedLength="false" Length="-1" PassByValue="false">
+ <dxl:DistrOpfamily Mdid="0.1995.1.0"/>
+ <dxl:LegacyDistrOpfamily Mdid="0.7105.1.0"/>
<dxl:EqualityOp Mdid="0.98.1.0"/>
<dxl:InequalityOp Mdid="0.531.1.0"/>
<dxl:LessThanOp Mdid="0.664.1.0"/>
@@ -205,6 +207,11 @@ AND u_folio = (SELECT max(u_folio) FROM q68t792_temp c WHERE a.u_vtgnr = c.u_vt
</dxl:Columns>
<dxl:IndexInfoList/>
<dxl:CheckConstraints/>
+ <dxl:DistrOpfamilies>
+ <dxl:DistrOpfamily Mdid="0.1995.1.0"/>
+ <dxl:DistrOpfamily Mdid="0.1995.1.0"/>
+ <dxl:DistrOpfamily Mdid="0.1995.1.0"/>
+ </dxl:DistrOpfamilies>
</dxl:Relation>
<dxl:ColumnStatistics Mdid="1.32935853.1.1.7" Name="cmax" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000"/>
<dxl:ColumnStatistics Mdid="1.32935853.1.1.6" Name="xmax" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000"/>
diff --git a/src/backend/gporca/data/dxl/minidump/DynamicBitmapIndexScan.mdp b/src/backend/gporca/data/dxl/minidump/DynamicBitmapIndexScan.mdp
index 5e6bca33c7..0a35555e91 100644
--- a/src/backend/gporca/data/dxl/minidump/DynamicBitmapIndexScan.mdp
+++ b/src/backend/gporca/data/dxl/minidump/DynamicBitmapIndexScan.mdp
@@ -14,7 +14,7 @@ see sql/DynamicBitmapIndexScan.sql
<dxl:CostParam Name="NLJFactor" Value="1.000000" LowerBound="0.500000" UpperBound="1.500000"/>
</dxl:CostParams>
</dxl:CostModelConfig>
- <dxl:TraceFlags Value="102001,102002,102003,102024,103045,102120,102144,103001,103014,103015,103022,103027,103033,104004,104005,105000"/>
+ <dxl:TraceFlags Value="102001,102002,102003,102024,103045,102120,102144,103001,103014,103015,103022,103027,103033,103038,104004,104005,105000"/>
</dxl:OptimizerConfig>
<dxl:Metadata SystemIds="0.GPDB">
<dxl:RelationStatistics Mdid="2.17408.1.1" Name="foo" Rows="1.000000" EmptyRelation="false"/>
@@ -47,6 +47,9 @@ see sql/DynamicBitmapIndexScan.sql
</dxl:Columns>
<dxl:IndexInfoList/>
<dxl:CheckConstraints/>
+ <dxl:DistrOpfamilies>
+ <dxl:DistrOpfamily Mdid="0.1998.1.0"/>
+ </dxl:DistrOpfamilies>
</dxl:Relation>
<dxl:ColumnStatistics Mdid="1.16959.1.1.6" Name="gp_segment_id" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000" ColStatsMissing="true"/>
<dxl:GPDBScalarOp Mdid="0.525.1.0" Name=">=" ComparisonType="GEq" ReturnsNullOnNullInput="true">
@@ -245,8 +248,13 @@ see sql/DynamicBitmapIndexScan.sql
</dxl:Columns>
<dxl:IndexInfoList/>
<dxl:CheckConstraints/>
+ <dxl:DistrOpfamilies>
+ <dxl:DistrOpfamily Mdid="0.1998.1.0"/>
+ </dxl:DistrOpfamilies>
</dxl:Relation>
<dxl:Type Mdid="0.1700.1.0" Name="numeric" IsRedistributable="true" IsHashable="true" IsMergeJoinable="true" IsComposite="false" IsFixedLength="false" Length="-1" PassByValue="false">
+ <dxl:DistrOpfamily Mdid="0.1998.1.0"/>
+ <dxl:LegacyDistrOpfamily Mdid="0.7103.1.0"/>
<dxl:EqualityOp Mdid="0.1752.1.0"/>
<dxl:InequalityOp Mdid="0.1753.1.0"/>
<dxl:LessThanOp Mdid="0.1754.1.0"/>
@@ -314,6 +322,10 @@ see sql/DynamicBitmapIndexScan.sql
<dxl:IndexInfo Mdid="0.17270.1.0" IsPartial="false"/>
</dxl:IndexInfoList>
<dxl:CheckConstraints/>
+ <dxl:DistrOpfamilies>
+ <dxl:DistrOpfamily Mdid="0.1998.1.0"/>
+ <dxl:DistrOpfamily Mdid="0.1998.1.0"/>
+ </dxl:DistrOpfamilies>
<dxl:Partitions>
<dxl:Partition Mdid="6.16959001.1.1"/>
<dxl:Partition Mdid="6.16959002.1.1"/>
@@ -350,6 +362,10 @@ see sql/DynamicBitmapIndexScan.sql
<dxl:IndexInfo Mdid="0.17270001.1.0" IsPartial="false"/>
</dxl:IndexInfoList>
<dxl:CheckConstraints/>
+ <dxl:DistrOpfamilies>
+ <dxl:DistrOpfamily Mdid="0.1998.1.0"/>
+ <dxl:DistrOpfamily Mdid="0.1998.1.0"/>
+ </dxl:DistrOpfamilies>
<dxl:PartConstraint>
<dxl:And>
<dxl:IsNotNull>
@@ -394,6 +410,10 @@ see sql/DynamicBitmapIndexScan.sql
<dxl:IndexInfo Mdid="0.17270002.1.0" IsPartial="false"/>
</dxl:IndexInfoList>
<dxl:CheckConstraints/>
+ <dxl:DistrOpfamilies>
+ <dxl:DistrOpfamily Mdid="0.1998.1.0"/>
+ <dxl:DistrOpfamily Mdid="0.1998.1.0"/>
+ </dxl:DistrOpfamilies>
<dxl:PartConstraint>
<dxl:And>
<dxl:IsNotNull>
@@ -438,6 +458,10 @@ see sql/DynamicBitmapIndexScan.sql
<dxl:IndexInfo Mdid="0.17270003.1.0" IsPartial="false"/>
</dxl:IndexInfoList>
<dxl:CheckConstraints/>
+ <dxl:DistrOpfamilies>
+ <dxl:DistrOpfamily Mdid="0.1998.1.0"/>
+ <dxl:DistrOpfamily Mdid="0.1998.1.0"/>
+ </dxl:DistrOpfamilies>
<dxl:PartConstraint>
<dxl:And>
<dxl:IsNotNull>
@@ -482,6 +506,10 @@ see sql/DynamicBitmapIndexScan.sql
<dxl:IndexInfo Mdid="0.17270004.1.0" IsPartial="false"/>
</dxl:IndexInfoList>
<dxl:CheckConstraints/>
+ <dxl:DistrOpfamilies>
+ <dxl:DistrOpfamily Mdid="0.1998.1.0"/>
+ <dxl:DistrOpfamily Mdid="0.1998.1.0"/>
+ </dxl:DistrOpfamilies>
<dxl:PartConstraint>
<dxl:And>
<dxl:IsNotNull>
@@ -526,6 +554,10 @@ see sql/DynamicBitmapIndexScan.sql
<dxl:IndexInfo Mdid="0.17270005.1.0" IsPartial="false"/>
</dxl:IndexInfoList>
<dxl:CheckConstraints/>
+ <dxl:DistrOpfamilies>
+ <dxl:DistrOpfamily Mdid="0.1998.1.0"/>
+ <dxl:DistrOpfamily Mdid="0.1998.1.0"/>
+ </dxl:DistrOpfamilies>
<dxl:PartConstraint>
<dxl:And>
<dxl:IsNotNull>
@@ -685,7 +717,7 @@ see sql/DynamicBitmapIndexScan.sql
</dxl:Comparison>
</dxl:LogicalJoin>
</dxl:Query>
- <dxl:Plan Id="0" SpaceSize="63">
+ <dxl:Plan Id="0" SpaceSize="66">
<dxl:GatherMotion InputSegments="0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63" OutputSegments="-1">
<dxl:Properties>
<dxl:Cost StartupCost="0" TotalCost="6763.875569" Rows="1.000000" Width="9"/>
@@ -725,10 +757,10 @@ see sql/DynamicBitmapIndexScan.sql
<dxl:Filter/>
<dxl:SortingColumnList/>
<dxl:HashExprList>
- <dxl:HashExpr>
+ <dxl:HashExpr Opfamily="0.1998.1.0">
<dxl:Ident ColId="24" ColName="fid" TypeMdid="0.1700.1.0"/>
</dxl:HashExpr>
- <dxl:HashExpr>
+ <dxl:HashExpr Opfamily="0.1998.1.0">
<dxl:Ident ColId="7" ColName="flex_value_id" TypeMdid="0.1700.1.0"/>
</dxl:HashExpr>
</dxl:HashExprList>
diff --git a/src/backend/gporca/data/dxl/minidump/IndexApply-IndexOnCoordinatorOnlyTable.mdp b/src/backend/gporca/data/dxl/minidump/IndexApply-IndexOnCoordinatorOnlyTable.mdp
new file mode 100644
index 0000000000..53e666a80b
--- /dev/null
+++ b/src/backend/gporca/data/dxl/minidump/IndexApply-IndexOnCoordinatorOnlyTable.mdp
@@ -0,0 +1,2366 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<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.000000" DampingFactorGroupBy="0.750000" MaxStatsBuckets="100"/>
+ <dxl:CTEConfig CTEInliningCutoff="0"/>
+ <dxl:WindowOids RowNumber="7000" Rank="7001"/>
+ <dxl:TraceFlags Value="102001,102002,102003,103045,102144,103001,103027,103033,103038,103040"/>
+ </dxl:OptimizerConfig>
+ <dxl:Metadata SystemIds="0.GPDB">
+ <dxl:Type Mdid="0.28.1.0" Name="xid" IsRedistributable="false" IsHashable="true" IsMergeJoinable="false" 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:Type Mdid="0.18.1.0" Name="char" IsRedistributable="true" IsHashable="true" IsMergeJoinable="true" IsComposite="false" IsFixedLength="true" Length="1" PassByValue="true">
+ <dxl:EqualityOp Mdid="0.92.1.0"/>
+ <dxl:InequalityOp Mdid="0.630.1.0"/>
+ <dxl:LessThanOp Mdid="0.631.1.0"/>
+ <dxl:LessThanEqualsOp Mdid="0.632.1.0"/>
+ <dxl:GreaterThanOp Mdid="0.633.1.0"/>
+ <dxl:GreaterThanEqualsOp Mdid="0.634.1.0"/>
+ <dxl:ComparisonOp Mdid="0.358.1.0"/>
+ <dxl:ArrayType Mdid="0.1002.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.26.1.0" Name="oid" IsRedistributable="true" IsHashable="true" IsMergeJoinable="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.16.1.0" Name="bool" IsRedistributable="true" IsHashable="true" IsMergeJoinable="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:ColumnStatistics Mdid="1.3373352.1.1.5" Name="xmax" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000"/>
+ <dxl:ColumnStatistics Mdid="1.3373352.1.1.4" Name="cmin" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000"/>
+ <dxl:ColumnStatistics Mdid="1.1259.1.1.35" Name="cmax" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000"/>
+ <dxl:ColumnStatistics Mdid="1.1259.1.1.34" Name="xmax" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000"/>
+ <dxl:ColumnStatistics Mdid="1.1259.1.1.27" Name="relfrozenxid" Width="4.000000" NullFreq="0.000000" NdvRemain="337.000000" FreqRemain="1.000000"/>
+ <dxl:ColumnStatistics Mdid="1.1259.1.1.26" Name="relhassubclass" Width="1.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000">
+ <dxl:StatsBucket Frequency="1.000000" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.16.1.0" Value="false"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.16.1.0" Value="false"/>
+ </dxl:StatsBucket>
+ </dxl:ColumnStatistics>
+ <dxl:ColumnStatistics Mdid="1.1259.1.1.19" Name="reltriggers" Width="2.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000">
+ <dxl:StatsBucket Frequency="0.987143" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.21.1.0" Value="0"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.21.1.0" Value="0"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.011858" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.21.1.0" Value="1"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.21.1.0" Value="1"/>
+ </dxl:StatsBucket>
+ </dxl:ColumnStatistics>
+ <dxl:ColumnStatistics Mdid="1.1259.1.1.18" Name="relchecks" Width="2.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000">
+ <dxl:StatsBucket Frequency="1.000000" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.21.1.0" Value="0"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.21.1.0" Value="0"/>
+ </dxl:StatsBucket>
+ </dxl:ColumnStatistics>
+ <dxl:ColumnStatistics Mdid="1.1259.1.1.11" Name="relaosegrelid" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000">
+ <dxl:StatsBucket Frequency="1.000000" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="0"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="0"/>
+ </dxl:StatsBucket>
+ </dxl:ColumnStatistics>
+ <dxl:ColumnStatistics Mdid="1.1259.1.1.10" Name="reltoastidxid" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000">
+ <dxl:StatsBucket Frequency="0.936749" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="0"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="0"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="2831"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="2831"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="2833"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="2833"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="2835"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="2835"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="2837"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="2837"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="2839"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="2839"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="2841"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="2841"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="2843"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="2843"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="2845"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="2845"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="2847"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="2847"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="2901"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="2901"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="2903"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="2903"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="3223"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="3223"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="3234"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="3234"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="9906"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="9906"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10778"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="10778"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10783"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="10783"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10788"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="10788"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10793"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="10793"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10798"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="10798"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10803"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="10803"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10808"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="10808"/>
+ </dxl:StatsBucket>
+ </dxl:ColumnStatistics>
+ <dxl:ColumnStatistics Mdid="1.1259.1.1.3" Name="relowner" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000">
+ <dxl:StatsBucket Frequency="1.000000" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="10"/>
+ </dxl:StatsBucket>
+ </dxl:ColumnStatistics>
+ <dxl:ColumnStatistics Mdid="1.1259.1.1.2" Name="reltype" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000">
+ <dxl:StatsBucket Frequency="0.406528" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="0"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="0"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.000840" DistinctValues="0.273370">
+ <dxl:LowerBound Closed="false" TypeMdid="0.26.1.0" Value="0"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="75"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002967" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="75"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="75"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.031801" DistinctValues="10.351630">
+ <dxl:LowerBound Closed="false" TypeMdid="0.26.1.0" Value="75"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="2915"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.000074" DistinctValues="0.019613">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="2915"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="2923"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002967" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="2923"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="2923"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002967" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="2924"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="2924"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.003034" DistinctValues="0.801698">
+ <dxl:LowerBound Closed="false" TypeMdid="0.26.1.0" Value="2924"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="3251"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002967" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="3251"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="3251"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.029496" DistinctValues="7.793881">
+ <dxl:LowerBound Closed="false" TypeMdid="0.26.1.0" Value="3251"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="6430"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002967" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="6430"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="6430"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.000037" DistinctValues="0.009807">
+ <dxl:LowerBound Closed="false" TypeMdid="0.26.1.0" Value="6430"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="6434"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.027978" DistinctValues="9.964286">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="6434"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="6446"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002967" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="6446"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="6446"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.004663" DistinctValues="1.660714">
+ <dxl:LowerBound Closed="false" TypeMdid="0.26.1.0" Value="6446"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="6448"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.000046" DistinctValues="0.014956">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="6448"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="6453"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002967" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="6453"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="6453"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.004981" DistinctValues="1.621270">
+ <dxl:LowerBound Closed="false" TypeMdid="0.26.1.0" Value="6453"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="6995"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002967" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="6995"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="6995"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.027614" DistinctValues="8.988774">
+ <dxl:LowerBound Closed="false" TypeMdid="0.26.1.0" Value="6995"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="10000"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.022598" DistinctValues="7.355769">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10000"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="10009"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002967" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10009"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="10009"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.005022" DistinctValues="1.634615">
+ <dxl:LowerBound Closed="false" TypeMdid="0.26.1.0" Value="10009"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="10011"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002967" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10011"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="10011"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.005022" DistinctValues="1.634615">
+ <dxl:LowerBound Closed="false" TypeMdid="0.26.1.0" Value="10011"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="10013"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.000242" DistinctValues="0.071296">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10013"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="10015"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002967" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10015"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="10015"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.000363" DistinctValues="0.106944">
+ <dxl:LowerBound Closed="false" TypeMdid="0.26.1.0" Value="10015"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="10018"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002967" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10018"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="10018"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.031674" DistinctValues="9.339815">
+ <dxl:LowerBound Closed="false" TypeMdid="0.26.1.0" Value="10018"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="10280"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002967" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10280"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="10280"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.000363" DistinctValues="0.106944">
+ <dxl:LowerBound Closed="false" TypeMdid="0.26.1.0" Value="10280"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="10283"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.020087" DistinctValues="6.538462">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10283"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="10291"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002967" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10291"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="10291"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.005022" DistinctValues="1.634615">
+ <dxl:LowerBound Closed="false" TypeMdid="0.26.1.0" Value="10291"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="10293"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002967" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10293"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="10293"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.007533" DistinctValues="2.451923">
+ <dxl:LowerBound Closed="false" TypeMdid="0.26.1.0" Value="10293"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="10296"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.032641" DistinctValues="12.625000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10296"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="10328"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.014330" DistinctValues="4.664634">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10328"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="10346"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002967" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10346"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="10346"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.013534" DistinctValues="4.405488">
+ <dxl:LowerBound Closed="false" TypeMdid="0.26.1.0" Value="10346"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="10363"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002967" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10363"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="10363"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.004777" DistinctValues="1.554878">
+ <dxl:LowerBound Closed="false" TypeMdid="0.26.1.0" Value="10363"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="10369"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.032641" DistinctValues="12.625000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10369"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="10408"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002683" DistinctValues="0.873288">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10408"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="10432"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002967" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10432"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="10432"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.028952" DistinctValues="9.424229">
+ <dxl:LowerBound Closed="false" TypeMdid="0.26.1.0" Value="10432"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="10691"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002967" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10691"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="10691"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.001006" DistinctValues="0.327483">
+ <dxl:LowerBound Closed="false" TypeMdid="0.26.1.0" Value="10691"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="10700"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.032641" DistinctValues="12.625000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10700"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="10739"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.032641" DistinctValues="12.625000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10739"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="10777"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.027695" DistinctValues="9.863636">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10777"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="10805"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002967" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10805"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="10805"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.004946" DistinctValues="1.761364">
+ <dxl:LowerBound Closed="false" TypeMdid="0.26.1.0" Value="10805"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="10810"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.010043" DistinctValues="3.269231">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10810"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="10822"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002967" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10822"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="10822"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.010043" DistinctValues="3.269231">
+ <dxl:LowerBound Closed="false" TypeMdid="0.26.1.0" Value="10822"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="10834"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002967" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10834"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="10834"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.012554" DistinctValues="4.086538">
+ <dxl:LowerBound Closed="false" TypeMdid="0.26.1.0" Value="10834"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="10849"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.017804" DistinctValues="5.795455">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10849"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="10867"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002967" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10867"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="10867"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.014837" DistinctValues="4.829545">
+ <dxl:LowerBound Closed="false" TypeMdid="0.26.1.0" Value="10867"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="10882"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002967" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10882"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="10882"/>
+ </dxl:StatsBucket>
+ </dxl:ColumnStatistics>
+ <dxl:Type Mdid="0.700.1.0" Name="float4" IsRedistributable="true" IsHashable="true" IsMergeJoinable="true" IsComposite="false" IsFixedLength="true" Length="4" PassByValue="true">
+ <dxl:EqualityOp Mdid="0.620.1.0"/>
+ <dxl:InequalityOp Mdid="0.621.1.0"/>
+ <dxl:LessThanOp Mdid="0.622.1.0"/>
+ <dxl:LessThanEqualsOp Mdid="0.624.1.0"/>
+ <dxl:GreaterThanOp Mdid="0.623.1.0"/>
+ <dxl:GreaterThanEqualsOp Mdid="0.625.1.0"/>
+ <dxl:ComparisonOp Mdid="0.354.1.0"/>
+ <dxl:ArrayType Mdid="0.1021.1.0"/>
+ <dxl:MinAgg Mdid="0.2135.1.0"/>
+ <dxl:MaxAgg Mdid="0.2119.1.0"/>
+ <dxl:AvgAgg Mdid="0.2104.1.0"/>
+ <dxl:SumAgg Mdid="0.2110.1.0"/>
+ <dxl:CountAgg Mdid="0.2147.1.0"/>
+ </dxl:Type>
+ <dxl:Type Mdid="0.1034.1.0" Name="_aclitem" IsRedistributable="true" IsHashable="false" IsMergeJoinable="false" IsComposite="false" IsFixedLength="false" Length="-1" PassByValue="false">
+ <dxl:EqualityOp Mdid="0.1070.1.0"/>
+ <dxl:InequalityOp Mdid="0.1071.1.0"/>
+ <dxl:LessThanOp Mdid="0.1072.1.0"/>
+ <dxl:LessThanEqualsOp Mdid="0.1074.1.0"/>
+ <dxl:GreaterThanOp Mdid="0.1073.1.0"/>
+ <dxl:GreaterThanEqualsOp Mdid="0.1075.1.0"/>
+ <dxl:ComparisonOp Mdid="0.382.1.0"/>
+ <dxl:ArrayType Mdid="0.0.0.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:Index Mdid="0.2662.1.0" Name="pg_class_oid_index" IsClustered="false" KeyColumns="31" IncludedColumns="0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37">
+ <dxl:Opfamilies>
+ <dxl:Opfamily Mdid="0.1989.1.0"/>
+ </dxl:Opfamilies>
+ </dxl:Index>
+ <dxl:Type Mdid="0.29.1.0" Name="cid" IsRedistributable="false" IsHashable="true" IsMergeJoinable="false" 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.27.1.0" Name="tid" IsRedistributable="true" IsHashable="false" IsMergeJoinable="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.21.1.0" Name="int2" IsRedistributable="true" IsHashable="true" IsMergeJoinable="true" IsComposite="false" IsFixedLength="true" Length="2" PassByValue="true">
+ <dxl:EqualityOp Mdid="0.94.1.0"/>
+ <dxl:InequalityOp Mdid="0.519.1.0"/>
+ <dxl:LessThanOp Mdid="0.95.1.0"/>
+ <dxl:LessThanEqualsOp Mdid="0.522.1.0"/>
+ <dxl:GreaterThanOp Mdid="0.520.1.0"/>
+ <dxl:GreaterThanEqualsOp Mdid="0.524.1.0"/>
+ <dxl:ComparisonOp Mdid="0.350.1.0"/>
+ <dxl:ArrayType Mdid="0.1005.1.0"/>
+ <dxl:MinAgg Mdid="0.2133.1.0"/>
+ <dxl:MaxAgg Mdid="0.2117.1.0"/>
+ <dxl:AvgAgg Mdid="0.2102.1.0"/>
+ <dxl:SumAgg Mdid="0.2109.1.0"/>
+ <dxl:CountAgg Mdid="0.2147.1.0"/>
+ </dxl:Type>
+ <dxl:Type Mdid="0.23.1.0" Name="int4" IsRedistributable="true" IsHashable="true" IsMergeJoinable="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.19.1.0" Name="name" IsRedistributable="true" IsHashable="true" IsMergeJoinable="true" IsComposite="false" IsFixedLength="true" Length="64" PassByValue="false">
+ <dxl:EqualityOp Mdid="0.93.1.0"/>
+ <dxl:InequalityOp Mdid="0.643.1.0"/>
+ <dxl:LessThanOp Mdid="0.660.1.0"/>
+ <dxl:LessThanEqualsOp Mdid="0.661.1.0"/>
+ <dxl:GreaterThanOp Mdid="0.662.1.0"/>
+ <dxl:GreaterThanEqualsOp Mdid="0.663.1.0"/>
+ <dxl:ComparisonOp Mdid="0.359.1.0"/>
+ <dxl:ArrayType Mdid="0.1003.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.3373352.1.1.7" Name="tableoid" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000"/>
+ <dxl:ColumnStatistics Mdid="1.3373352.1.1.6" Name="cmax" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000"/>
+ <dxl:ColumnStatistics Mdid="1.1259.1.1.33" Name="cmin" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000"/>
+ <dxl:ColumnStatistics Mdid="1.1259.1.1.32" Name="xmin" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000"/>
+ <dxl:ColumnStatistics Mdid="1.1259.1.1.25" Name="relhasrules" Width="1.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000">
+ <dxl:StatsBucket Frequency="0.714419" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.16.1.0" Value="false"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.16.1.0" Value="false"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.284582" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.16.1.0" Value="true"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.16.1.0" Value="true"/>
+ </dxl:StatsBucket>
+ </dxl:ColumnStatistics>
+ <dxl:ColumnStatistics Mdid="1.1259.1.1.24" Name="relhaspkey" Width="1.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000">
+ <dxl:StatsBucket Frequency="0.978250" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.16.1.0" Value="false"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.16.1.0" Value="false"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.020751" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.16.1.0" Value="true"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.16.1.0" Value="true"/>
+ </dxl:StatsBucket>
+ </dxl:ColumnStatistics>
+ <dxl:ColumnStatistics Mdid="1.1259.1.1.17" Name="relnatts" Width="2.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000">
+ <dxl:StatsBucket Frequency="0.222552" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.21.1.0" Value="1"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.21.1.0" Value="1"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.166172" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.21.1.0" Value="2"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.21.1.0" Value="2"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.166172" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.21.1.0" Value="3"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.21.1.0" Value="3"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.053412" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.21.1.0" Value="4"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.21.1.0" Value="4"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.062315" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.21.1.0" Value="5"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.21.1.0" Value="5"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.035608" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.21.1.0" Value="6"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.21.1.0" Value="6"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.089021" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.21.1.0" Value="7"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.21.1.0" Value="7"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.041543" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.21.1.0" Value="8"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.21.1.0" Value="8"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.023739" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.21.1.0" Value="9"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.21.1.0" Value="9"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.017804" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.21.1.0" Value="10"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.21.1.0" Value="10"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.026706" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.21.1.0" Value="11"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.21.1.0" Value="11"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.005935" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.21.1.0" Value="12"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.21.1.0" Value="12"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.005935" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.21.1.0" Value="13"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.21.1.0" Value="13"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.014837" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.21.1.0" Value="14"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.21.1.0" Value="14"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.008902" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.21.1.0" Value="15"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.21.1.0" Value="15"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.005935" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.21.1.0" Value="16"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.21.1.0" Value="16"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.011869" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.21.1.0" Value="17"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.21.1.0" Value="17"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002967" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.21.1.0" Value="18"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.21.1.0" Value="18"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002967" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.21.1.0" Value="19"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.21.1.0" Value="19"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.000016" DistinctValues="0.016393">
+ <dxl:LowerBound Closed="true" TypeMdid="0.21.1.0" Value="20"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.21.1.0" Value="21"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.005935" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.21.1.0" Value="21"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.21.1.0" Value="21"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.000032" DistinctValues="0.032787">
+ <dxl:LowerBound Closed="false" TypeMdid="0.21.1.0" Value="21"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.21.1.0" Value="23"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002967" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.21.1.0" Value="23"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.21.1.0" Value="23"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.000065" DistinctValues="0.065574">
+ <dxl:LowerBound Closed="false" TypeMdid="0.21.1.0" Value="23"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.21.1.0" Value="27"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002967" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.21.1.0" Value="27"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.21.1.0" Value="27"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.000049" DistinctValues="0.049180">
+ <dxl:LowerBound Closed="false" TypeMdid="0.21.1.0" Value="27"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.21.1.0" Value="30"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002967" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.21.1.0" Value="30"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.21.1.0" Value="30"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.005935" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.21.1.0" Value="31"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.21.1.0" Value="31"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.000827" DistinctValues="0.836066">
+ <dxl:LowerBound Closed="false" TypeMdid="0.21.1.0" Value="31"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.21.1.0" Value="82"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002967" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.21.1.0" Value="82"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.21.1.0" Value="82"/>
+ </dxl:StatsBucket>
+ </dxl:ColumnStatistics>
+ <dxl:ColumnStatistics Mdid="1.1259.1.1.16" Name="relstorage" Width="1.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000"/>
+ <dxl:ColumnStatistics Mdid="1.1259.1.1.9" Name="reltoastrelid" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000">
+ <dxl:StatsBucket Frequency="0.936749" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="0"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="0"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="2830"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="2830"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="2832"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="2832"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="2834"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="2834"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="2836"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="2836"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="2838"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="2838"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="2840"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="2840"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="2842"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="2842"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="2844"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="2844"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="2846"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="2846"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="2900"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="2900"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="2902"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="2902"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="3222"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="3222"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="3233"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="3233"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="9905"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="9905"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10776"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="10776"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10781"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="10781"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10786"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="10786"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10791"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="10791"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10796"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="10796"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10801"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="10801"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002964" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10806"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="10806"/>
+ </dxl:StatsBucket>
+ </dxl:ColumnStatistics>
+ <dxl:ColumnStatistics Mdid="1.1259.1.1.8" Name="reltuples" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000"/>
+ <dxl:ColumnStatistics Mdid="1.1259.1.1.1" Name="relnamespace" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000">
+ <dxl:StatsBucket Frequency="0.711455" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="11"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="11"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.124505" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="99"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="99"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.163042" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10672"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="10672"/>
+ </dxl:StatsBucket>
+ </dxl:ColumnStatistics>
+ <dxl:ColumnStatistics Mdid="1.1259.1.1.0" Name="relname" Width="64.000000" NullFreq="0.000000" NdvRemain="337.000000" FreqRemain="1.000000"/>
+ <dxl:GPDBScalarOp Mdid="0.607.1.0" Name="=" ComparisonType="Eq">
+ <dxl:LeftType Mdid="0.26.1.0"/>
+ <dxl:RightType Mdid="0.26.1.0"/>
+ <dxl:ResultType Mdid="0.16.1.0"/>
+ <dxl:OpFunc Mdid="0.184.1.0"/>
+ <dxl:Commutator Mdid="0.607.1.0"/>
+ <dxl:InverseOp Mdid="0.608.1.0"/>
+ <dxl:Opfamilies>
+ <dxl:Opfamily Mdid="0.1989.1.0"/>
+ <dxl:Opfamily Mdid="0.1990.1.0"/>
+ <dxl:Opfamily Mdid="0.3033.1.0"/>
+ </dxl:Opfamilies>
+ </dxl:GPDBScalarOp>
+ <dxl:Type Mdid="0.1009.1.0" Name="_text" IsRedistributable="true" IsHashable="false" IsMergeJoinable="false" IsComposite="false" IsFixedLength="false" Length="-1" PassByValue="false">
+ <dxl:EqualityOp Mdid="0.1070.1.0"/>
+ <dxl:InequalityOp Mdid="0.1071.1.0"/>
+ <dxl:LessThanOp Mdid="0.1072.1.0"/>
+ <dxl:LessThanEqualsOp Mdid="0.1074.1.0"/>
+ <dxl:GreaterThanOp Mdid="0.1073.1.0"/>
+ <dxl:GreaterThanEqualsOp Mdid="0.1075.1.0"/>
+ <dxl:ComparisonOp Mdid="0.382.1.0"/>
+ <dxl:ArrayType Mdid="0.0.0.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:Relation Mdid="6.1259.1.0" Name="pg_class" IsTemporary="false" StorageType="Heap" DistributionPolicy="CoordinatorOnly" Keys="37,30">
+ <dxl:Columns>
+ <dxl:Column Name="relname" Attno="1" Mdid="0.19.1.0" Nullable="false" ColWidth="64">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relnamespace" Attno="2" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="reltype" Attno="3" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relowner" Attno="4" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relam" Attno="5" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relfilenode" Attno="6" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="reltablespace" Attno="7" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relpages" Attno="8" Mdid="0.23.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="reltuples" Attno="9" Mdid="0.700.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="reltoastrelid" Attno="10" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="reltoastidxid" Attno="11" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relaosegrelid" Attno="12" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relaosegidxid" Attno="13" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relhasindex" Attno="14" Mdid="0.16.1.0" Nullable="false" ColWidth="1">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relisshared" Attno="15" Mdid="0.16.1.0" Nullable="false" ColWidth="1">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relkind" Attno="16" Mdid="0.18.1.0" Nullable="false" ColWidth="1">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relstorage" Attno="17" Mdid="0.18.1.0" Nullable="false" ColWidth="1">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relnatts" Attno="18" Mdid="0.21.1.0" Nullable="false" ColWidth="2">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relchecks" Attno="19" Mdid="0.21.1.0" Nullable="false" ColWidth="2">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="reltriggers" Attno="20" Mdid="0.21.1.0" Nullable="false" ColWidth="2">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relukeys" Attno="21" Mdid="0.21.1.0" Nullable="false" ColWidth="2">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relfkeys" Attno="22" Mdid="0.21.1.0" Nullable="false" ColWidth="2">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relrefs" Attno="23" Mdid="0.21.1.0" Nullable="false" ColWidth="2">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relhasoids" Attno="24" Mdid="0.16.1.0" Nullable="false" ColWidth="1">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relhaspkey" Attno="25" Mdid="0.16.1.0" Nullable="false" ColWidth="1">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relhasrules" Attno="26" Mdid="0.16.1.0" Nullable="false" ColWidth="1">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relhassubclass" Attno="27" Mdid="0.16.1.0" Nullable="false" ColWidth="1">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relfrozenxid" Attno="28" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relacl" Attno="29" Mdid="0.1034.1.0" Nullable="true" ColWidth="36">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="reloptions" Attno="30" Mdid="0.1009.1.0" Nullable="true" ColWidth="0">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="ctid" Attno="-1" Mdid="0.27.1.0" Nullable="false" ColWidth="6">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="oid" Attno="-2" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="xmin" Attno="-3" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="cmin" Attno="-4" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="xmax" Attno="-5" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="cmax" Attno="-6" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="tableoid" Attno="-7" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="gp_segment_id" Attno="-8" Mdid="0.23.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ </dxl:Columns>
+ <dxl:IndexInfoList>
+ <dxl:IndexInfo Mdid="0.2662.1.0" IsPartial="false"/>
+ <dxl:IndexInfo Mdid="0.2663.1.0" IsPartial="false"/>
+ </dxl:IndexInfoList>
+ <dxl:CheckConstraints/>
+ </dxl:Relation>
+ <dxl:Index Mdid="0.2663.1.0" Name="pg_class_relname_nsp_index" IsClustered="false" KeyColumns="0,1" IncludedColumns="0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37">
+ <dxl:Opfamilies>
+ <dxl:Opfamily Mdid="0.1086.1.0"/>
+ <dxl:Opfamily Mdid="0.1089.1.0"/>
+ </dxl:Opfamilies>
+ </dxl:Index>
+ <dxl:ColumnStatistics Mdid="1.3373352.1.1.8" Name="gp_segment_id" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000"/>
+ <dxl:ColumnStatistics Mdid="1.3373352.1.1.1" Name="j" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000">
+ <dxl:StatsBucket Frequency="0.000555" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="0"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.23.1.0" Value="0"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.000555" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="1"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.23.1.0" Value="1"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038321" DistinctValues="344.269231">
+ <dxl:LowerBound Closed="false" TypeMdid="0.23.1.0" Value="1"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="1351"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.034169" DistinctValues="307.865064">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="1351"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="1672"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.000111" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="1672"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.23.1.0" Value="1672"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.004151" DistinctValues="37.404167">
+ <dxl:LowerBound Closed="false" TypeMdid="0.23.1.0" Value="1672"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="1711"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038321" DistinctValues="346.269231">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="1711"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="2071"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.028102" DistinctValues="253.197436">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="2071"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="2335"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.000111" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="2335"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.23.1.0" Value="2335"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.010219" DistinctValues="92.071795">
+ <dxl:LowerBound Closed="false" TypeMdid="0.23.1.0" Value="2335"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="2431"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.020331" DistinctValues="183.184509">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="2431"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="2622"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.000111" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="2622"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.23.1.0" Value="2622"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.017989" DistinctValues="162.084722">
+ <dxl:LowerBound Closed="false" TypeMdid="0.23.1.0" Value="2622"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="2791"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.024483" DistinctValues="220.588675">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="2791"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="3021"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.000111" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="3021"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.23.1.0" Value="3021"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.013838" DistinctValues="124.680556">
+ <dxl:LowerBound Closed="false" TypeMdid="0.23.1.0" Value="3021"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="3151"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.008409" DistinctValues="75.547970">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="3151"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="3230"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.000111" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="3230"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.23.1.0" Value="3230"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.029060" DistinctValues="261.070833">
+ <dxl:LowerBound Closed="false" TypeMdid="0.23.1.0" Value="3230"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="3503"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.000111" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="3503"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.23.1.0" Value="3503"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.000852" DistinctValues="7.650427">
+ <dxl:LowerBound Closed="false" TypeMdid="0.23.1.0" Value="3503"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="3511"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.010538" DistinctValues="94.674038">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="3511"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="3610"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.000111" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="3610"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.23.1.0" Value="3610"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.021928" DistinctValues="196.998504">
+ <dxl:LowerBound Closed="false" TypeMdid="0.23.1.0" Value="3610"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="3816"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.000111" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="3816"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.23.1.0" Value="3816"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.005855" DistinctValues="52.596688">
+ <dxl:LowerBound Closed="false" TypeMdid="0.23.1.0" Value="3816"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="3871"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.009793" DistinctValues="87.979915">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="3871"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="3963"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.000111" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="3963"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.23.1.0" Value="3963"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.011709" DistinctValues="105.193376">
+ <dxl:LowerBound Closed="false" TypeMdid="0.23.1.0" Value="3963"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="4073"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.000111" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="4073"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.23.1.0" Value="4073"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.016819" DistinctValues="151.095940">
+ <dxl:LowerBound Closed="false" TypeMdid="0.23.1.0" Value="4073"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="4231"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.015115" DistinctValues="136.189530">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="4231"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="4373"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.000111" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="4373"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.23.1.0" Value="4373"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.023205" DistinctValues="209.079701">
+ <dxl:LowerBound Closed="false" TypeMdid="0.23.1.0" Value="4373"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="4591"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.017138" DistinctValues="154.412073">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="4591"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="4752"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.000111" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="4752"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.23.1.0" Value="4752"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.021183" DistinctValues="190.857158">
+ <dxl:LowerBound Closed="false" TypeMdid="0.23.1.0" Value="4752"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="4951"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.020331" DistinctValues="183.184509">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="4951"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="5142"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.000111" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="5142"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.23.1.0" Value="5142"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.017989" DistinctValues="162.084722">
+ <dxl:LowerBound Closed="false" TypeMdid="0.23.1.0" Value="5142"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="5311"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.006067" DistinctValues="54.509295">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="5311"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="5368"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.000111" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="5368"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.23.1.0" Value="5368"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.005429" DistinctValues="48.771474">
+ <dxl:LowerBound Closed="false" TypeMdid="0.23.1.0" Value="5368"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="5419"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.000111" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="5419"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.23.1.0" Value="5419"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.026824" DistinctValues="240.988462">
+ <dxl:LowerBound Closed="false" TypeMdid="0.23.1.0" Value="5419"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="5671"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038321" DistinctValues="346.269231">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="5671"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="6031"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038321" DistinctValues="346.269231">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="6031"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="6391"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.013412" DistinctValues="120.144231">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="6391"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="6517"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.000111" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="6517"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.23.1.0" Value="6517"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.006813" DistinctValues="61.025641">
+ <dxl:LowerBound Closed="false" TypeMdid="0.23.1.0" Value="6517"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="6581"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.000111" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="6581"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.23.1.0" Value="6581"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.015861" DistinctValues="142.075321">
+ <dxl:LowerBound Closed="false" TypeMdid="0.23.1.0" Value="6581"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="6730"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.000111" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="6730"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.23.1.0" Value="6730"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002235" DistinctValues="20.024038">
+ <dxl:LowerBound Closed="false" TypeMdid="0.23.1.0" Value="6730"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="6751"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038321" DistinctValues="346.269231">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="6751"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="7111"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.033105" DistinctValues="297.410363">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="7111"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="7422"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.000111" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="7422"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.23.1.0" Value="7422"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.001597" DistinctValues="14.344551">
+ <dxl:LowerBound Closed="false" TypeMdid="0.23.1.0" Value="7422"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="7437"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.000111" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="7437"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.23.1.0" Value="7437"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.003619" DistinctValues="32.514316">
+ <dxl:LowerBound Closed="false" TypeMdid="0.23.1.0" Value="7437"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="7471"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.027144" DistinctValues="244.565705">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="7471"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="7726"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.000111" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="7726"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.23.1.0" Value="7726"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.011177" DistinctValues="100.703526">
+ <dxl:LowerBound Closed="false" TypeMdid="0.23.1.0" Value="7726"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="7831"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038321" DistinctValues="346.269231">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="7831"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="8191"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.027144" DistinctValues="244.565705">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="8191"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="8446"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.000111" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="8446"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.23.1.0" Value="8446"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.011177" DistinctValues="100.703526">
+ <dxl:LowerBound Closed="false" TypeMdid="0.23.1.0" Value="8446"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="8551"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038321" DistinctValues="346.269231">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="8551"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="8911"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038321" DistinctValues="346.269231">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="8911"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="9271"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.014370" DistinctValues="129.475962">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="9271"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="9406"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.000111" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="9406"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.23.1.0" Value="9406"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.023950" DistinctValues="215.793269">
+ <dxl:LowerBound Closed="false" TypeMdid="0.23.1.0" Value="9406"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="9631"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038321" DistinctValues="346.269231">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="9631"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="9991"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038321" DistinctValues="346.269231">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="9991"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.23.1.0" Value="10001"/>
+ </dxl:StatsBucket>
+ </dxl:ColumnStatistics>
+ <dxl:ColumnStatistics Mdid="1.3373352.1.1.0" Name="i" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000">
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="346.576923">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="1"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="1350"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="346.576923">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="1350"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="1710"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="346.576923">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="1710"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="2070"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="346.576923">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="2070"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="2430"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="346.576923">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="2430"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="2790"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="346.576923">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="2790"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="3150"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="346.576923">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="3150"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="3510"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="346.576923">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="3510"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="3870"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="346.576923">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="3870"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="4230"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="346.576923">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="4230"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="4590"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="346.576923">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="4590"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="4950"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="346.576923">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="4950"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="5310"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="346.576923">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="5310"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="5670"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="346.576923">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="5670"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="6030"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="346.576923">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="6030"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="6390"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="346.576923">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="6390"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="6750"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="346.576923">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="6750"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="7110"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="346.576923">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="7110"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="7470"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="346.576923">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="7470"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="7830"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="346.576923">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="7830"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="8190"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="346.576923">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="8190"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="8550"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="346.576923">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="8550"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="8910"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="346.576923">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="8910"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="9270"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="346.576923">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="9270"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="9630"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="346.576923">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="9630"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.23.1.0" Value="9990"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="346.576923">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="9990"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.23.1.0" Value="10000"/>
+ </dxl:StatsBucket>
+ </dxl:ColumnStatistics>
+ <dxl:ColumnStatistics Mdid="1.1259.1.1.30" Name="ctid" Width="6.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000"/>
+ <dxl:ColumnStatistics Mdid="1.1259.1.1.23" Name="relhasoids" Width="1.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000">
+ <dxl:StatsBucket Frequency="0.916914" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.16.1.0" Value="false"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.16.1.0" Value="false"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.083086" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.16.1.0" Value="true"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.16.1.0" Value="true"/>
+ </dxl:StatsBucket>
+ </dxl:ColumnStatistics>
+ <dxl:ColumnStatistics Mdid="1.1259.1.1.22" Name="relrefs" Width="2.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000">
+ <dxl:StatsBucket Frequency="1.000000" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.21.1.0" Value="0"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.21.1.0" Value="0"/>
+ </dxl:StatsBucket>
+ </dxl:ColumnStatistics>
+ <dxl:ColumnStatistics Mdid="1.1259.1.1.15" Name="relkind" Width="1.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000"/>
+ <dxl:ColumnStatistics Mdid="1.1259.1.1.14" Name="relisshared" Width="1.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000">
+ <dxl:StatsBucket Frequency="0.780415" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.16.1.0" Value="false"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.16.1.0" Value="false"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.219585" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.16.1.0" Value="true"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.16.1.0" Value="true"/>
+ </dxl:StatsBucket>
+ </dxl:ColumnStatistics>
+ <dxl:ColumnStatistics Mdid="1.1259.1.1.7" Name="relpages" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000">
+ <dxl:StatsBucket Frequency="0.899110" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="0"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.23.1.0" Value="0"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.047478" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="1"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.23.1.0" Value="1"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.029674" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="2"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.23.1.0" Value="2"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.008902" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="4"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.23.1.0" Value="4"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002967" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="5"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.23.1.0" Value="5"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002967" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="10"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.23.1.0" Value="10"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002967" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="11"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.23.1.0" Value="11"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002967" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="13"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.23.1.0" Value="13"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.002967" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.23.1.0" Value="17"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.23.1.0" Value="17"/>
+ </dxl:StatsBucket>
+ </dxl:ColumnStatistics>
+ <dxl:ColumnStatistics Mdid="1.1259.1.1.6" Name="reltablespace" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000">
+ <dxl:StatsBucket Frequency="0.780415" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="0"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="0"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.219585" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="1664"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="1664"/>
+ </dxl:StatsBucket>
+ </dxl:ColumnStatistics>
+ <dxl:ColumnStatistics Mdid="1.1259.1.1.31" Name="oid" Width="8.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000"/>
+ <dxl:ColumnStatistics Mdid="1.3373352.1.1.3" Name="xmin" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000"/>
+ <dxl:ColumnStatistics Mdid="1.3373352.1.1.2" Name="ctid" Width="6.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000"/>
+ <dxl:ColumnStatistics Mdid="1.1259.1.1.37" Name="gp_segment_id" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000"/>
+ <dxl:ColumnStatistics Mdid="1.1259.1.1.36" Name="tableoid" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000"/>
+ <dxl:ColumnStatistics Mdid="1.1259.1.1.29" Name="reloptions" Width="0.000000" NullFreq="1.000000" NdvRemain="337.000000" FreqRemain="1.000000"/>
+ <dxl:ColumnStatistics Mdid="1.1259.1.1.28" Name="relacl" Width="36.000000" NullFreq="0.483680" NdvRemain="337.000000" FreqRemain="1.000000"/>
+ <dxl:ColumnStatistics Mdid="1.1259.1.1.21" Name="relfkeys" Width="2.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000">
+ <dxl:StatsBucket Frequency="1.000000" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.21.1.0" Value="0"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.21.1.0" Value="0"/>
+ </dxl:StatsBucket>
+ </dxl:ColumnStatistics>
+ <dxl:ColumnStatistics Mdid="1.1259.1.1.20" Name="relukeys" Width="2.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000">
+ <dxl:StatsBucket Frequency="1.000000" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.21.1.0" Value="0"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.21.1.0" Value="0"/>
+ </dxl:StatsBucket>
+ </dxl:ColumnStatistics>
+ <dxl:ColumnStatistics Mdid="1.1259.1.1.13" Name="relhasindex" Width="1.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000">
+ <dxl:StatsBucket Frequency="0.747774" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.16.1.0" Value="false"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.16.1.0" Value="false"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.252226" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.16.1.0" Value="true"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.16.1.0" Value="true"/>
+ </dxl:StatsBucket>
+ </dxl:ColumnStatistics>
+ <dxl:ColumnStatistics Mdid="1.1259.1.1.12" Name="relaosegidxid" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000">
+ <dxl:StatsBucket Frequency="1.000000" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="0"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="0"/>
+ </dxl:StatsBucket>
+ </dxl:ColumnStatistics>
+ <dxl:ColumnStatistics Mdid="1.1259.1.1.5" Name="relfilenode" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000">
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="12.961538">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="1136"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="1261"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="12.961538">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="1261"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="2609"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="12.961538">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="2609"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="2651"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="12.961538">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="2651"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="2664"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="12.961538">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="2664"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="2677"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="12.961538">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="2677"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="2690"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="12.961538">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="2690"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="2703"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="12.961538">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="2703"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="2841"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="12.961538">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="2841"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="2898"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="12.961538">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="2898"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="3207"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="12.961538">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="3207"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="3309"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="12.961538">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="3309"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="5011"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="12.961538">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="5011"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="5036"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="12.961538">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="5036"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="6029"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="12.961538">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="6029"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="6063"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="12.961538">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="6063"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="6110"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="12.961538">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="6110"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="10309"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="12.961538">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10309"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="10350"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="12.961538">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10350"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="10389"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="12.961538">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10389"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="10428"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="12.961538">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10428"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="10720"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="12.961538">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10720"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="10759"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="12.961538">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10759"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="10788"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="12.961538">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10788"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="10809"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="12.961538">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10809"/>
+ <dxl:UpperBound Closed="false" TypeMdid="0.26.1.0" Value="10848"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.038462" DistinctValues="12.961538">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="10848"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="10881"/>
+ </dxl:StatsBucket>
+ </dxl:ColumnStatistics>
+ <dxl:ColumnStatistics Mdid="1.1259.1.1.4" Name="relam" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000">
+ <dxl:StatsBucket Frequency="0.592879" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="0"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="0"/>
+ </dxl:StatsBucket>
+ <dxl:StatsBucket Frequency="0.406122" DistinctValues="1.000000">
+ <dxl:LowerBound Closed="true" TypeMdid="0.26.1.0" Value="403"/>
+ <dxl:UpperBound Closed="true" TypeMdid="0.26.1.0" Value="403"/>
+ </dxl:StatsBucket>
+ </dxl:ColumnStatistics>
+ <dxl:RelationStatistics Mdid="2.1259.1.1" Name="pg_class" Rows="337.000000" EmptyRelation="false"/>
+ <dxl:Relation Mdid="6.1259.1.1" Name="pg_class" IsTemporary="false" StorageType="Heap" DistributionPolicy="CoordinatorOnly" Keys="37,30">
+ <dxl:Columns>
+ <dxl:Column Name="relname" Attno="1" Mdid="0.19.1.0" Nullable="false" ColWidth="64">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relnamespace" Attno="2" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="reltype" Attno="3" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relowner" Attno="4" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relam" Attno="5" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relfilenode" Attno="6" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="reltablespace" Attno="7" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relpages" Attno="8" Mdid="0.23.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="reltuples" Attno="9" Mdid="0.700.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="reltoastrelid" Attno="10" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="reltoastidxid" Attno="11" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relaosegrelid" Attno="12" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relaosegidxid" Attno="13" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relhasindex" Attno="14" Mdid="0.16.1.0" Nullable="false" ColWidth="1">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relisshared" Attno="15" Mdid="0.16.1.0" Nullable="false" ColWidth="1">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relkind" Attno="16" Mdid="0.18.1.0" Nullable="false" ColWidth="1">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relstorage" Attno="17" Mdid="0.18.1.0" Nullable="false" ColWidth="1">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relnatts" Attno="18" Mdid="0.21.1.0" Nullable="false" ColWidth="2">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relchecks" Attno="19" Mdid="0.21.1.0" Nullable="false" ColWidth="2">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="reltriggers" Attno="20" Mdid="0.21.1.0" Nullable="false" ColWidth="2">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relukeys" Attno="21" Mdid="0.21.1.0" Nullable="false" ColWidth="2">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relfkeys" Attno="22" Mdid="0.21.1.0" Nullable="false" ColWidth="2">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relrefs" Attno="23" Mdid="0.21.1.0" Nullable="false" ColWidth="2">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relhasoids" Attno="24" Mdid="0.16.1.0" Nullable="false" ColWidth="1">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relhaspkey" Attno="25" Mdid="0.16.1.0" Nullable="false" ColWidth="1">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relhasrules" Attno="26" Mdid="0.16.1.0" Nullable="false" ColWidth="1">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relhassubclass" Attno="27" Mdid="0.16.1.0" Nullable="false" ColWidth="1">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relfrozenxid" Attno="28" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="relacl" Attno="29" Mdid="0.1034.1.0" Nullable="true" ColWidth="36">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="reloptions" Attno="30" Mdid="0.1009.1.0" Nullable="true" ColWidth="0">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="ctid" Attno="-1" Mdid="0.27.1.0" Nullable="false" ColWidth="6">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="oid" Attno="-2" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="xmin" Attno="-3" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="cmin" Attno="-4" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="xmax" Attno="-5" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="cmax" Attno="-6" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="tableoid" Attno="-7" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="gp_segment_id" Attno="-8" Mdid="0.23.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ </dxl:Columns>
+ <dxl:IndexInfoList>
+ <dxl:IndexInfo Mdid="0.2662.1.0" IsPartial="false"/>
+ <dxl:IndexInfo Mdid="0.2663.1.0" IsPartial="false"/>
+ </dxl:IndexInfoList>
+ <dxl:CheckConstraints/>
+ </dxl:Relation>
+ <dxl:RelationStatistics Mdid="2.3373352.1.1" Name="x" Rows="9011.000000" EmptyRelation="false"/>
+ <dxl:Relation Mdid="6.3373352.1.1" Name="x" IsTemporary="false" StorageType="Heap" DistributionPolicy="Hash" DistributionColumns="0" Keys="8,2">
+ <dxl:Columns>
+ <dxl:Column Name="i" Attno="1" Mdid="0.23.1.0" Nullable="true" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="j" Attno="2" Mdid="0.23.1.0" Nullable="true" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="ctid" Attno="-1" Mdid="0.27.1.0" Nullable="false" ColWidth="6">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="xmin" Attno="-3" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="cmin" Attno="-4" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="xmax" Attno="-5" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="cmax" Attno="-6" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="tableoid" Attno="-7" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="gp_segment_id" Attno="-8" Mdid="0.23.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ </dxl:Columns>
+ <dxl:IndexInfoList/>
+ <dxl:CheckConstraints/>
+ <dxl:DistrOpfamilies>
+ <dxl:DistrOpfamily Mdid="0.1977.1.0"/>
+ </dxl:DistrOpfamilies>
+ </dxl:Relation>
+ <dxl:MDCast Mdid="3.23.1.0;26.1.0" Name="oid" BinaryCoercible="true" SourceTypeId="0.23.1.0" DestinationTypeId="0.26.1.0" CastFuncId="0.0.0.0"/>
+ </dxl:Metadata>
+ <dxl:Query>
+ <dxl:OutputColumns>
+ <dxl:Ident ColId="1" ColName="relname" TypeMdid="0.19.1.0"/>
+ <dxl:Ident ColId="2" ColName="relnamespace" TypeMdid="0.26.1.0"/>
+ <dxl:Ident ColId="3" ColName="reltype" TypeMdid="0.26.1.0"/>
+ <dxl:Ident ColId="4" ColName="relowner" TypeMdid="0.26.1.0"/>
+ <dxl:Ident ColId="5" ColName="relam" TypeMdid="0.26.1.0"/>
+ <dxl:Ident ColId="6" ColName="relfilenode" TypeMdid="0.26.1.0"/>
+ <dxl:Ident ColId="7" ColName="reltablespace" TypeMdid="0.26.1.0"/>
+ <dxl:Ident ColId="8" ColName="relpages" TypeMdid="0.23.1.0"/>
+ <dxl:Ident ColId="9" ColName="reltuples" TypeMdid="0.700.1.0"/>
+ <dxl:Ident ColId="10" ColName="reltoastrelid" TypeMdid="0.26.1.0"/>
+ <dxl:Ident ColId="11" ColName="reltoastidxid" TypeMdid="0.26.1.0"/>
+ <dxl:Ident ColId="12" ColName="relaosegrelid" TypeMdid="0.26.1.0"/>
+ <dxl:Ident ColId="13" ColName="relaosegidxid" TypeMdid="0.26.1.0"/>
+ <dxl:Ident ColId="14" ColName="relhasindex" TypeMdid="0.16.1.0"/>
+ <dxl:Ident ColId="15" ColName="relisshared" TypeMdid="0.16.1.0"/>
+ <dxl:Ident ColId="16" ColName="relkind" TypeMdid="0.18.1.0"/>
+ <dxl:Ident ColId="17" ColName="relstorage" TypeMdid="0.18.1.0"/>
+ <dxl:Ident ColId="18" ColName="relnatts" TypeMdid="0.21.1.0"/>
+ <dxl:Ident ColId="19" ColName="relchecks" TypeMdid="0.21.1.0"/>
+ <dxl:Ident ColId="20" ColName="reltriggers" TypeMdid="0.21.1.0"/>
+ <dxl:Ident ColId="21" ColName="relukeys" TypeMdid="0.21.1.0"/>
+ <dxl:Ident ColId="22" ColName="relfkeys" TypeMdid="0.21.1.0"/>
+ <dxl:Ident ColId="23" ColName="relrefs" TypeMdid="0.21.1.0"/>
+ <dxl:Ident ColId="24" ColName="relhasoids" TypeMdid="0.16.1.0"/>
+ <dxl:Ident ColId="25" ColName="relhaspkey" TypeMdid="0.16.1.0"/>
+ <dxl:Ident ColId="26" ColName="relhasrules" TypeMdid="0.16.1.0"/>
+ <dxl:Ident ColId="27" ColName="relhassubclass" TypeMdid="0.16.1.0"/>
+ <dxl:Ident ColId="28" ColName="relfrozenxid" TypeMdid="0.28.1.0"/>
+ <dxl:Ident ColId="29" ColName="relacl" TypeMdid="0.1034.1.0"/>
+ <dxl:Ident ColId="30" ColName="reloptions" TypeMdid="0.1009.1.0"/>
+ <dxl:Ident ColId="39" ColName="i" TypeMdid="0.23.1.0"/>
+ <dxl:Ident ColId="40" ColName="j" TypeMdid="0.23.1.0"/>
+ </dxl:OutputColumns>
+ <dxl:CTEList/>
+ <dxl:LogicalJoin JoinType="Inner">
+ <dxl:LogicalGet>
+ <dxl:TableDescriptor Mdid="6.1259.1.1" TableName="pg_class">
+ <dxl:Columns>
+ <dxl:Column ColId="1" Attno="1" ColName="relname" TypeMdid="0.19.1.0"/>
+ <dxl:Column ColId="2" Attno="2" ColName="relnamespace" TypeMdid="0.26.1.0"/>
+ <dxl:Column ColId="3" Attno="3" ColName="reltype" TypeMdid="0.26.1.0"/>
+ <dxl:Column ColId="4" Attno="4" ColName="relowner" TypeMdid="0.26.1.0"/>
+ <dxl:Column ColId="5" Attno="5" ColName="relam" TypeMdid="0.26.1.0"/>
+ <dxl:Column ColId="6" Attno="6" ColName="relfilenode" TypeMdid="0.26.1.0"/>
+ <dxl:Column ColId="7" Attno="7" ColName="reltablespace" TypeMdid="0.26.1.0"/>
+ <dxl:Column ColId="8" Attno="8" ColName="relpages" TypeMdid="0.23.1.0"/>
+ <dxl:Column ColId="9" Attno="9" ColName="reltuples" TypeMdid="0.700.1.0"/>
+ <dxl:Column ColId="10" Attno="10" ColName="reltoastrelid" TypeMdid="0.26.1.0"/>
+ <dxl:Column ColId="11" Attno="11" ColName="reltoastidxid" TypeMdid="0.26.1.0"/>
+ <dxl:Column ColId="12" Attno="12" ColName="relaosegrelid" TypeMdid="0.26.1.0"/>
+ <dxl:Column ColId="13" Attno="13" ColName="relaosegidxid" TypeMdid="0.26.1.0"/>
+ <dxl:Column ColId="14" Attno="14" ColName="relhasindex" TypeMdid="0.16.1.0"/>
+ <dxl:Column ColId="15" Attno="15" ColName="relisshared" TypeMdid="0.16.1.0"/>
+ <dxl:Column ColId="16" Attno="16" ColName="relkind" TypeMdid="0.18.1.0"/>
+ <dxl:Column ColId="17" Attno="17" ColName="relstorage" TypeMdid="0.18.1.0"/>
+ <dxl:Column ColId="18" Attno="18" ColName="relnatts" TypeMdid="0.21.1.0"/>
+ <dxl:Column ColId="19" Attno="19" ColName="relchecks" TypeMdid="0.21.1.0"/>
+ <dxl:Column ColId="20" Attno="20" ColName="reltriggers" TypeMdid="0.21.1.0"/>
+ <dxl:Column ColId="21" Attno="21" ColName="relukeys" TypeMdid="0.21.1.0"/>
+ <dxl:Column ColId="22" Attno="22" ColName="relfkeys" TypeMdid="0.21.1.0"/>
+ <dxl:Column ColId="23" Attno="23" ColName="relrefs" TypeMdid="0.21.1.0"/>
+ <dxl:Column ColId="24" Attno="24" ColName="relhasoids" TypeMdid="0.16.1.0"/>
+ <dxl:Column ColId="25" Attno="25" ColName="relhaspkey" TypeMdid="0.16.1.0"/>
+ <dxl:Column ColId="26" Attno="26" ColName="relhasrules" TypeMdid="0.16.1.0"/>
+ <dxl:Column ColId="27" Attno="27" ColName="relhassubclass" TypeMdid="0.16.1.0"/>
+ <dxl:Column ColId="28" Attno="28" ColName="relfrozenxid" TypeMdid="0.28.1.0"/>
+ <dxl:Column ColId="29" Attno="29" ColName="relacl" TypeMdid="0.1034.1.0"/>
+ <dxl:Column ColId="30" Attno="30" ColName="reloptions" TypeMdid="0.1009.1.0"/>
+ <dxl:Column ColId="31" Attno="-1" ColName="ctid" TypeMdid="0.27.1.0"/>
+ <dxl:Column ColId="32" Attno="-2" ColName="oid" TypeMdid="0.26.1.0"/>
+ <dxl:Column ColId="33" Attno="-3" ColName="xmin" TypeMdid="0.28.1.0"/>
+ <dxl:Column ColId="34" Attno="-4" ColName="cmin" TypeMdid="0.29.1.0"/>
+ <dxl:Column ColId="35" Attno="-5" ColName="xmax" TypeMdid="0.28.1.0"/>
+ <dxl:Column ColId="36" Attno="-6" ColName="cmax" TypeMdid="0.29.1.0"/>
+ <dxl:Column ColId="37" Attno="-7" ColName="tableoid" TypeMdid="0.26.1.0"/>
+ <dxl:Column ColId="38" Attno="-8" ColName="gp_segment_id" TypeMdid="0.23.1.0"/>
+ </dxl:Columns>
+ </dxl:TableDescriptor>
+ </dxl:LogicalGet>
+ <dxl:LogicalGet>
+ <dxl:TableDescriptor Mdid="6.3373352.1.1" TableName="x">
+ <dxl:Columns>
+ <dxl:Column ColId="39" Attno="1" ColName="i" TypeMdid="0.23.1.0"/>
+ <dxl:Column ColId="40" Attno="2" ColName="j" TypeMdid="0.23.1.0"/>
+ <dxl:Column ColId="41" Attno="-1" ColName="ctid" TypeMdid="0.27.1.0"/>
+ <dxl:Column ColId="42" Attno="-3" ColName="xmin" TypeMdid="0.28.1.0"/>
+ <dxl:Column ColId="43" Attno="-4" ColName="cmin" TypeMdid="0.29.1.0"/>
+ <dxl:Column ColId="44" Attno="-5" ColName="xmax" TypeMdid="0.28.1.0"/>
+ <dxl:Column ColId="45" Attno="-6" ColName="cmax" TypeMdid="0.29.1.0"/>
+ <dxl:Column ColId="46" Attno="-7" ColName="tableoid" TypeMdid="0.26.1.0"/>
+ <dxl:Column ColId="47" Attno="-8" ColName="gp_segment_id" TypeMdid="0.23.1.0"/>
+ </dxl:Columns>
+ </dxl:TableDescriptor>
+ </dxl:LogicalGet>
+ <dxl:Comparison ComparisonOperator="=" OperatorMdid="0.607.1.0">
+ <dxl:Ident ColId="32" ColName="oid" TypeMdid="0.26.1.0"/>
+ <dxl:Cast TypeMdid="0.26.1.0" FuncId="0.0.0.0">
+ <dxl:Ident ColId="39" ColName="i" TypeMdid="0.23.1.0"/>
+ </dxl:Cast>
+ </dxl:Comparison>
+ </dxl:LogicalJoin>
+ </dxl:Query>
+ <dxl:Plan Id="0" SpaceSize="9">
+ <dxl:GatherMotion InputSegments="0,1" OutputSegments="-1">
+ <dxl:Properties>
+ <dxl:Cost StartupCost="0" TotalCost="1413.359893" Rows="9011.000000" Width="180"/>
+ </dxl:Properties>
+ <dxl:ProjList>
+ <dxl:ProjElem ColId="0" Alias="relname">
+ <dxl:Ident ColId="0" ColName="relname" TypeMdid="0.19.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="1" Alias="relnamespace">
+ <dxl:Ident ColId="1" ColName="relnamespace" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="2" Alias="reltype">
+ <dxl:Ident ColId="2" ColName="reltype" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="3" Alias="relowner">
+ <dxl:Ident ColId="3" ColName="relowner" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="4" Alias="relam">
+ <dxl:Ident ColId="4" ColName="relam" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="5" Alias="relfilenode">
+ <dxl:Ident ColId="5" ColName="relfilenode" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="6" Alias="reltablespace">
+ <dxl:Ident ColId="6" ColName="reltablespace" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="7" Alias="relpages">
+ <dxl:Ident ColId="7" ColName="relpages" TypeMdid="0.23.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="8" Alias="reltuples">
+ <dxl:Ident ColId="8" ColName="reltuples" TypeMdid="0.700.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="9" Alias="reltoastrelid">
+ <dxl:Ident ColId="9" ColName="reltoastrelid" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="10" Alias="reltoastidxid">
+ <dxl:Ident ColId="10" ColName="reltoastidxid" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="11" Alias="relaosegrelid">
+ <dxl:Ident ColId="11" ColName="relaosegrelid" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="12" Alias="relaosegidxid">
+ <dxl:Ident ColId="12" ColName="relaosegidxid" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="13" Alias="relhasindex">
+ <dxl:Ident ColId="13" ColName="relhasindex" TypeMdid="0.16.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="14" Alias="relisshared">
+ <dxl:Ident ColId="14" ColName="relisshared" TypeMdid="0.16.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="15" Alias="relkind">
+ <dxl:Ident ColId="15" ColName="relkind" TypeMdid="0.18.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="16" Alias="relstorage">
+ <dxl:Ident ColId="16" ColName="relstorage" TypeMdid="0.18.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="17" Alias="relnatts">
+ <dxl:Ident ColId="17" ColName="relnatts" TypeMdid="0.21.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="18" Alias="relchecks">
+ <dxl:Ident ColId="18" ColName="relchecks" TypeMdid="0.21.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="19" Alias="reltriggers">
+ <dxl:Ident ColId="19" ColName="reltriggers" TypeMdid="0.21.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="20" Alias="relukeys">
+ <dxl:Ident ColId="20" ColName="relukeys" TypeMdid="0.21.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="21" Alias="relfkeys">
+ <dxl:Ident ColId="21" ColName="relfkeys" TypeMdid="0.21.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="22" Alias="relrefs">
+ <dxl:Ident ColId="22" ColName="relrefs" TypeMdid="0.21.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="23" Alias="relhasoids">
+ <dxl:Ident ColId="23" ColName="relhasoids" TypeMdid="0.16.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="24" Alias="relhaspkey">
+ <dxl:Ident ColId="24" ColName="relhaspkey" TypeMdid="0.16.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="25" Alias="relhasrules">
+ <dxl:Ident ColId="25" ColName="relhasrules" TypeMdid="0.16.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="26" Alias="relhassubclass">
+ <dxl:Ident ColId="26" ColName="relhassubclass" TypeMdid="0.16.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="27" Alias="relfrozenxid">
+ <dxl:Ident ColId="27" ColName="relfrozenxid" TypeMdid="0.28.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="28" Alias="relacl">
+ <dxl:Ident ColId="28" ColName="relacl" TypeMdid="0.1034.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="29" Alias="reloptions">
+ <dxl:Ident ColId="29" ColName="reloptions" TypeMdid="0.1009.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="38" Alias="i">
+ <dxl:Ident ColId="38" ColName="i" TypeMdid="0.23.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="39" Alias="j">
+ <dxl:Ident ColId="39" ColName="j" TypeMdid="0.23.1.0"/>
+ </dxl:ProjElem>
+ </dxl:ProjList>
+ <dxl:Filter/>
+ <dxl:SortingColumnList/>
+ <dxl:NestedLoopJoin JoinType="Inner" IndexNestedLoopJoin="false" OuterRefAsParam="false">
+ <dxl:Properties>
+ <dxl:Cost StartupCost="0" TotalCost="1406.077203" Rows="9011.000000" Width="180"/>
+ </dxl:Properties>
+ <dxl:ProjList>
+ <dxl:ProjElem ColId="0" Alias="relname">
+ <dxl:Ident ColId="0" ColName="relname" TypeMdid="0.19.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="1" Alias="relnamespace">
+ <dxl:Ident ColId="1" ColName="relnamespace" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="2" Alias="reltype">
+ <dxl:Ident ColId="2" ColName="reltype" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="3" Alias="relowner">
+ <dxl:Ident ColId="3" ColName="relowner" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="4" Alias="relam">
+ <dxl:Ident ColId="4" ColName="relam" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="5" Alias="relfilenode">
+ <dxl:Ident ColId="5" ColName="relfilenode" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="6" Alias="reltablespace">
+ <dxl:Ident ColId="6" ColName="reltablespace" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="7" Alias="relpages">
+ <dxl:Ident ColId="7" ColName="relpages" TypeMdid="0.23.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="8" Alias="reltuples">
+ <dxl:Ident ColId="8" ColName="reltuples" TypeMdid="0.700.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="9" Alias="reltoastrelid">
+ <dxl:Ident ColId="9" ColName="reltoastrelid" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="10" Alias="reltoastidxid">
+ <dxl:Ident ColId="10" ColName="reltoastidxid" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="11" Alias="relaosegrelid">
+ <dxl:Ident ColId="11" ColName="relaosegrelid" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="12" Alias="relaosegidxid">
+ <dxl:Ident ColId="12" ColName="relaosegidxid" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="13" Alias="relhasindex">
+ <dxl:Ident ColId="13" ColName="relhasindex" TypeMdid="0.16.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="14" Alias="relisshared">
+ <dxl:Ident ColId="14" ColName="relisshared" TypeMdid="0.16.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="15" Alias="relkind">
+ <dxl:Ident ColId="15" ColName="relkind" TypeMdid="0.18.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="16" Alias="relstorage">
+ <dxl:Ident ColId="16" ColName="relstorage" TypeMdid="0.18.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="17" Alias="relnatts">
+ <dxl:Ident ColId="17" ColName="relnatts" TypeMdid="0.21.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="18" Alias="relchecks">
+ <dxl:Ident ColId="18" ColName="relchecks" TypeMdid="0.21.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="19" Alias="reltriggers">
+ <dxl:Ident ColId="19" ColName="reltriggers" TypeMdid="0.21.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="20" Alias="relukeys">
+ <dxl:Ident ColId="20" ColName="relukeys" TypeMdid="0.21.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="21" Alias="relfkeys">
+ <dxl:Ident ColId="21" ColName="relfkeys" TypeMdid="0.21.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="22" Alias="relrefs">
+ <dxl:Ident ColId="22" ColName="relrefs" TypeMdid="0.21.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="23" Alias="relhasoids">
+ <dxl:Ident ColId="23" ColName="relhasoids" TypeMdid="0.16.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="24" Alias="relhaspkey">
+ <dxl:Ident ColId="24" ColName="relhaspkey" TypeMdid="0.16.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="25" Alias="relhasrules">
+ <dxl:Ident ColId="25" ColName="relhasrules" TypeMdid="0.16.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="26" Alias="relhassubclass">
+ <dxl:Ident ColId="26" ColName="relhassubclass" TypeMdid="0.16.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="27" Alias="relfrozenxid">
+ <dxl:Ident ColId="27" ColName="relfrozenxid" TypeMdid="0.28.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="28" Alias="relacl">
+ <dxl:Ident ColId="28" ColName="relacl" TypeMdid="0.1034.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="29" Alias="reloptions">
+ <dxl:Ident ColId="29" ColName="reloptions" TypeMdid="0.1009.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="38" Alias="i">
+ <dxl:Ident ColId="38" ColName="i" TypeMdid="0.23.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="39" Alias="j">
+ <dxl:Ident ColId="39" ColName="j" TypeMdid="0.23.1.0"/>
+ </dxl:ProjElem>
+ </dxl:ProjList>
+ <dxl:Filter/>
+ <dxl:JoinFilter>
+ <dxl:Comparison ComparisonOperator="=" OperatorMdid="0.607.1.0">
+ <dxl:Ident ColId="31" ColName="oid" TypeMdid="0.26.1.0"/>
+ <dxl:Cast TypeMdid="0.26.1.0" FuncId="0.0.0.0">
+ <dxl:Ident ColId="38" ColName="i" TypeMdid="0.23.1.0"/>
+ </dxl:Cast>
+ </dxl:Comparison>
+ </dxl:JoinFilter>
+ <dxl:BroadcastMotion InputSegments="-1" OutputSegments="0,1">
+ <dxl:Properties>
+ <dxl:Cost StartupCost="0" TotalCost="434.326561" Rows="674.000000" Width="180"/>
+ </dxl:Properties>
+ <dxl:ProjList>
+ <dxl:ProjElem ColId="0" Alias="relname">
+ <dxl:Ident ColId="0" ColName="relname" TypeMdid="0.19.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="1" Alias="relnamespace">
+ <dxl:Ident ColId="1" ColName="relnamespace" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="2" Alias="reltype">
+ <dxl:Ident ColId="2" ColName="reltype" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="3" Alias="relowner">
+ <dxl:Ident ColId="3" ColName="relowner" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="4" Alias="relam">
+ <dxl:Ident ColId="4" ColName="relam" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="5" Alias="relfilenode">
+ <dxl:Ident ColId="5" ColName="relfilenode" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="6" Alias="reltablespace">
+ <dxl:Ident ColId="6" ColName="reltablespace" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="7" Alias="relpages">
+ <dxl:Ident ColId="7" ColName="relpages" TypeMdid="0.23.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="8" Alias="reltuples">
+ <dxl:Ident ColId="8" ColName="reltuples" TypeMdid="0.700.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="9" Alias="reltoastrelid">
+ <dxl:Ident ColId="9" ColName="reltoastrelid" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="10" Alias="reltoastidxid">
+ <dxl:Ident ColId="10" ColName="reltoastidxid" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="11" Alias="relaosegrelid">
+ <dxl:Ident ColId="11" ColName="relaosegrelid" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="12" Alias="relaosegidxid">
+ <dxl:Ident ColId="12" ColName="relaosegidxid" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="13" Alias="relhasindex">
+ <dxl:Ident ColId="13" ColName="relhasindex" TypeMdid="0.16.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="14" Alias="relisshared">
+ <dxl:Ident ColId="14" ColName="relisshared" TypeMdid="0.16.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="15" Alias="relkind">
+ <dxl:Ident ColId="15" ColName="relkind" TypeMdid="0.18.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="16" Alias="relstorage">
+ <dxl:Ident ColId="16" ColName="relstorage" TypeMdid="0.18.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="17" Alias="relnatts">
+ <dxl:Ident ColId="17" ColName="relnatts" TypeMdid="0.21.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="18" Alias="relchecks">
+ <dxl:Ident ColId="18" ColName="relchecks" TypeMdid="0.21.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="19" Alias="reltriggers">
+ <dxl:Ident ColId="19" ColName="reltriggers" TypeMdid="0.21.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="20" Alias="relukeys">
+ <dxl:Ident ColId="20" ColName="relukeys" TypeMdid="0.21.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="21" Alias="relfkeys">
+ <dxl:Ident ColId="21" ColName="relfkeys" TypeMdid="0.21.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="22" Alias="relrefs">
+ <dxl:Ident ColId="22" ColName="relrefs" TypeMdid="0.21.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="23" Alias="relhasoids">
+ <dxl:Ident ColId="23" ColName="relhasoids" TypeMdid="0.16.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="24" Alias="relhaspkey">
+ <dxl:Ident ColId="24" ColName="relhaspkey" TypeMdid="0.16.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="25" Alias="relhasrules">
+ <dxl:Ident ColId="25" ColName="relhasrules" TypeMdid="0.16.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="26" Alias="relhassubclass">
+ <dxl:Ident ColId="26" ColName="relhassubclass" TypeMdid="0.16.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="27" Alias="relfrozenxid">
+ <dxl:Ident ColId="27" ColName="relfrozenxid" TypeMdid="0.28.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="28" Alias="relacl">
+ <dxl:Ident ColId="28" ColName="relacl" TypeMdid="0.1034.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="29" Alias="reloptions">
+ <dxl:Ident ColId="29" ColName="reloptions" TypeMdid="0.1009.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="31" Alias="oid">
+ <dxl:Ident ColId="31" ColName="oid" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ </dxl:ProjList>
+ <dxl:Filter/>
+ <dxl:SortingColumnList/>
+ <dxl:TableScan>
+ <dxl:Properties>
+ <dxl:Cost StartupCost="0" TotalCost="431.038182" Rows="337.000000" Width="180"/>
+ </dxl:Properties>
+ <dxl:ProjList>
+ <dxl:ProjElem ColId="0" Alias="relname">
+ <dxl:Ident ColId="0" ColName="relname" TypeMdid="0.19.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="1" Alias="relnamespace">
+ <dxl:Ident ColId="1" ColName="relnamespace" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="2" Alias="reltype">
+ <dxl:Ident ColId="2" ColName="reltype" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="3" Alias="relowner">
+ <dxl:Ident ColId="3" ColName="relowner" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="4" Alias="relam">
+ <dxl:Ident ColId="4" ColName="relam" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="5" Alias="relfilenode">
+ <dxl:Ident ColId="5" ColName="relfilenode" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="6" Alias="reltablespace">
+ <dxl:Ident ColId="6" ColName="reltablespace" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="7" Alias="relpages">
+ <dxl:Ident ColId="7" ColName="relpages" TypeMdid="0.23.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="8" Alias="reltuples">
+ <dxl:Ident ColId="8" ColName="reltuples" TypeMdid="0.700.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="9" Alias="reltoastrelid">
+ <dxl:Ident ColId="9" ColName="reltoastrelid" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="10" Alias="reltoastidxid">
+ <dxl:Ident ColId="10" ColName="reltoastidxid" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="11" Alias="relaosegrelid">
+ <dxl:Ident ColId="11" ColName="relaosegrelid" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="12" Alias="relaosegidxid">
+ <dxl:Ident ColId="12" ColName="relaosegidxid" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="13" Alias="relhasindex">
+ <dxl:Ident ColId="13" ColName="relhasindex" TypeMdid="0.16.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="14" Alias="relisshared">
+ <dxl:Ident ColId="14" ColName="relisshared" TypeMdid="0.16.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="15" Alias="relkind">
+ <dxl:Ident ColId="15" ColName="relkind" TypeMdid="0.18.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="16" Alias="relstorage">
+ <dxl:Ident ColId="16" ColName="relstorage" TypeMdid="0.18.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="17" Alias="relnatts">
+ <dxl:Ident ColId="17" ColName="relnatts" TypeMdid="0.21.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="18" Alias="relchecks">
+ <dxl:Ident ColId="18" ColName="relchecks" TypeMdid="0.21.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="19" Alias="reltriggers">
+ <dxl:Ident ColId="19" ColName="reltriggers" TypeMdid="0.21.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="20" Alias="relukeys">
+ <dxl:Ident ColId="20" ColName="relukeys" TypeMdid="0.21.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="21" Alias="relfkeys">
+ <dxl:Ident ColId="21" ColName="relfkeys" TypeMdid="0.21.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="22" Alias="relrefs">
+ <dxl:Ident ColId="22" ColName="relrefs" TypeMdid="0.21.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="23" Alias="relhasoids">
+ <dxl:Ident ColId="23" ColName="relhasoids" TypeMdid="0.16.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="24" Alias="relhaspkey">
+ <dxl:Ident ColId="24" ColName="relhaspkey" TypeMdid="0.16.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="25" Alias="relhasrules">
+ <dxl:Ident ColId="25" ColName="relhasrules" TypeMdid="0.16.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="26" Alias="relhassubclass">
+ <dxl:Ident ColId="26" ColName="relhassubclass" TypeMdid="0.16.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="27" Alias="relfrozenxid">
+ <dxl:Ident ColId="27" ColName="relfrozenxid" TypeMdid="0.28.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="28" Alias="relacl">
+ <dxl:Ident ColId="28" ColName="relacl" TypeMdid="0.1034.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="29" Alias="reloptions">
+ <dxl:Ident ColId="29" ColName="reloptions" TypeMdid="0.1009.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="31" Alias="oid">
+ <dxl:Ident ColId="31" ColName="oid" TypeMdid="0.26.1.0"/>
+ </dxl:ProjElem>
+ </dxl:ProjList>
+ <dxl:Filter/>
+ <dxl:TableDescriptor Mdid="6.1259.1.1" TableName="pg_class">
+ <dxl:Columns>
+ <dxl:Column ColId="0" Attno="1" ColName="relname" TypeMdid="0.19.1.0"/>
+ <dxl:Column ColId="1" Attno="2" ColName="relnamespace" TypeMdid="0.26.1.0"/>
+ <dxl:Column ColId="2" Attno="3" ColName="reltype" TypeMdid="0.26.1.0"/>
+ <dxl:Column ColId="3" Attno="4" ColName="relowner" TypeMdid="0.26.1.0"/>
+ <dxl:Column ColId="4" Attno="5" ColName="relam" TypeMdid="0.26.1.0"/>
+ <dxl:Column ColId="5" Attno="6" ColName="relfilenode" TypeMdid="0.26.1.0"/>
+ <dxl:Column ColId="6" Attno="7" ColName="reltablespace" TypeMdid="0.26.1.0"/>
+ <dxl:Column ColId="7" Attno="8" ColName="relpages" TypeMdid="0.23.1.0"/>
+ <dxl:Column ColId="8" Attno="9" ColName="reltuples" TypeMdid="0.700.1.0"/>
+ <dxl:Column ColId="9" Attno="10" ColName="reltoastrelid" TypeMdid="0.26.1.0"/>
+ <dxl:Column ColId="10" Attno="11" ColName="reltoastidxid" TypeMdid="0.26.1.0"/>
+ <dxl:Column ColId="11" Attno="12" ColName="relaosegrelid" TypeMdid="0.26.1.0"/>
+ <dxl:Column ColId="12" Attno="13" ColName="relaosegidxid" TypeMdid="0.26.1.0"/>
+ <dxl:Column ColId="13" Attno="14" ColName="relhasindex" TypeMdid="0.16.1.0"/>
+ <dxl:Column ColId="14" Attno="15" ColName="relisshared" TypeMdid="0.16.1.0"/>
+ <dxl:Column ColId="15" Attno="16" ColName="relkind" TypeMdid="0.18.1.0"/>
+ <dxl:Column ColId="16" Attno="17" ColName="relstorage" TypeMdid="0.18.1.0"/>
+ <dxl:Column ColId="17" Attno="18" ColName="relnatts" TypeMdid="0.21.1.0"/>
+ <dxl:Column ColId="18" Attno="19" ColName="relchecks" TypeMdid="0.21.1.0"/>
+ <dxl:Column ColId="19" Attno="20" ColName="reltriggers" TypeMdid="0.21.1.0"/>
+ <dxl:Column ColId="20" Attno="21" ColName="relukeys" TypeMdid="0.21.1.0"/>
+ <dxl:Column ColId="21" Attno="22" ColName="relfkeys" TypeMdid="0.21.1.0"/>
+ <dxl:Column ColId="22" Attno="23" ColName="relrefs" TypeMdid="0.21.1.0"/>
+ <dxl:Column ColId="23" Attno="24" ColName="relhasoids" TypeMdid="0.16.1.0"/>
+ <dxl:Column ColId="24" Attno="25" ColName="relhaspkey" TypeMdid="0.16.1.0"/>
+ <dxl:Column ColId="25" Attno="26" ColName="relhasrules" TypeMdid="0.16.1.0"/>
+ <dxl:Column ColId="26" Attno="27" ColName="relhassubclass" TypeMdid="0.16.1.0"/>
+ <dxl:Column ColId="27" Attno="28" ColName="relfrozenxid" TypeMdid="0.28.1.0"/>
+ <dxl:Column ColId="28" Attno="29" ColName="relacl" TypeMdid="0.1034.1.0"/>
+ <dxl:Column ColId="29" Attno="30" ColName="reloptions" TypeMdid="0.1009.1.0"/>
+ <dxl:Column ColId="30" Attno="-1" ColName="ctid" TypeMdid="0.27.1.0"/>
+ <dxl:Column ColId="31" Attno="-2" ColName="oid" TypeMdid="0.26.1.0"/>
+ <dxl:Column ColId="32" Attno="-3" ColName="xmin" TypeMdid="0.28.1.0"/>
+ <dxl:Column ColId="33" Attno="-4" ColName="cmin" TypeMdid="0.29.1.0"/>
+ <dxl:Column ColId="34" Attno="-5" ColName="xmax" TypeMdid="0.28.1.0"/>
+ <dxl:Column ColId="35" Attno="-6" ColName="cmax" TypeMdid="0.29.1.0"/>
+ <dxl:Column ColId="36" Attno="-7" ColName="tableoid" TypeMdid="0.26.1.0"/>
+ <dxl:Column ColId="37" Attno="-8" ColName="gp_segment_id" TypeMdid="0.23.1.0"/>
+ </dxl:Columns>
+ </dxl:TableDescriptor>
+ </dxl:TableScan>
+ </dxl:BroadcastMotion>
+ <dxl:TableScan>
+ <dxl:Properties>
+ <dxl:Cost StartupCost="0" TotalCost="431.094165" Rows="9011.000000" Width="8"/>
+ </dxl:Properties>
+ <dxl:ProjList>
+ <dxl:ProjElem ColId="38" Alias="i">
+ <dxl:Ident ColId="38" ColName="i" TypeMdid="0.23.1.0"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="39" Alias="j">
+ <dxl:Ident ColId="39" ColName="j" TypeMdid="0.23.1.0"/>
+ </dxl:ProjElem>
+ </dxl:ProjList>
+ <dxl:Filter/>
+ <dxl:TableDescriptor Mdid="6.3373352.1.1" TableName="x">
+ <dxl:Columns>
+ <dxl:Column ColId="38" Attno="1" ColName="i" TypeMdid="0.23.1.0"/>
+ <dxl:Column ColId="39" Attno="2" ColName="j" TypeMdid="0.23.1.0"/>
+ <dxl:Column ColId="40" Attno="-1" ColName="ctid" TypeMdid="0.27.1.0"/>
+ <dxl:Column ColId="41" Attno="-3" ColName="xmin" TypeMdid="0.28.1.0"/>
+ <dxl:Column ColId="42" Attno="-4" ColName="cmin" TypeMdid="0.29.1.0"/>
+ <dxl:Column ColId="43" Attno="-5" ColName="xmax" TypeMdid="0.28.1.0"/>
+ <dxl:Column ColId="44" Attno="-6" ColName="cmax" TypeMdid="0.29.1.0"/>
+ <dxl:Column ColId="45" Attno="-7" ColName="tableoid" TypeMdid="0.26.1.0"/>
+ <dxl:Column ColId="46" Attno="-8" ColName="gp_segment_id" TypeMdid="0.23.1.0"/>
+ </dxl:Columns>
+ </dxl:TableDescriptor>
+ </dxl:TableScan>
+ </dxl:NestedLoopJoin>
+ </dxl:GatherMotion>
+ </dxl:Plan>
+ </dxl:Thread>
+</dxl:DXLMessage>
diff --git a/src/backend/gporca/data/dxl/minidump/Join-INDF-NoBroadcast.mdp b/src/backend/gporca/data/dxl/minidump/Join-INDF-NoBroadcast.mdp
index c6ca977338..6b9e2c082e 100644
--- a/src/backend/gporca/data/dxl/minidump/Join-INDF-NoBroadcast.mdp
+++ b/src/backend/gporca/data/dxl/minidump/Join-INDF-NoBroadcast.mdp
@@ -21,7 +21,7 @@ select * from foo, bar where foo.a is not distinct from bar.a;
</dxl:CostParams>
</dxl:CostModelConfig>
<dxl:Hint JoinArityForAssociativityCommutativity="18" ArrayExpansionThreshold="100" JoinOrderDynamicProgThreshold="10" BroadcastThreshold="10000000" EnforceConstraintsOnDML="false"/>
- <dxl:TraceFlags Value="102001,102002,102003,103045,102046,102048,102053,102054,102074,102120,102144,103001,103014,103015,103022,103027,103033,104003,104004,104005,105000"/>
+ <dxl:TraceFlags Value="102001,102002,102003,103045,102046,102048,102053,102054,102074,102120,102144,103001,103014,103015,103022,103027,103033,103038,103040,104003,104004,104005,105000"/>
</dxl:OptimizerConfig>
<dxl:Metadata SystemIds="0.GPDB">
<dxl:RelationStatistics Mdid="2.32768.1.0" Name="t1" Rows="0.000000" EmptyRelation="true"/>
@@ -57,6 +57,9 @@ select * from foo, bar where foo.a is not distinct from bar.a;
</dxl:Columns>
<dxl:IndexInfoList/>
<dxl:CheckConstraints/>
+ <dxl:DistrOpfamilies>
+ <dxl:DistrOpfamily Mdid="0.1977.1.0"/>
+ </dxl:DistrOpfamilies>
</dxl:Relation>
<dxl:RelationStatistics Mdid="2.32771.1.0" Name="t2" Rows="0.000000" EmptyRelation="true"/>
<dxl:Relation Mdid="6.32771.1.0" Name="t2" IsTemporary="false" StorageType="Heap" DistributionPolicy="Hash" DistributionColumns="0" Keys="8,2">
@@ -91,6 +94,9 @@ select * from foo, bar where foo.a is not distinct from bar.a;
</dxl:Columns>
<dxl:IndexInfoList/>
<dxl:CheckConstraints/>
+ <dxl:DistrOpfamilies>
+ <dxl:DistrOpfamily Mdid="0.1977.1.0"/>
+ </dxl:DistrOpfamilies>
</dxl:Relation>
<dxl:Type Mdid="0.16.1.0" Name="bool" IsRedistributable="true" IsHashable="true" IsMergeJoinable="true" IsComposite="false" IsFixedLength="true" Length="1" PassByValue="true">
<dxl:EqualityOp Mdid="0.91.1.0"/>
diff --git a/src/backend/gporca/data/dxl/minidump/Join-INDF-Nulls-Not-Collocated.mdp b/src/backend/gporca/data/dxl/minidump/Join-INDF-Nulls-Not-Collocated.mdp
index 91fd16c282..d6873da331 100644
--- a/src/backend/gporca/data/dxl/minidump/Join-INDF-Nulls-Not-Collocated.mdp
+++ b/src/backend/gporca/data/dxl/minidump/Join-INDF-Nulls-Not-Collocated.mdp
@@ -21,7 +21,7 @@ select * from foo, (select NULL a from bar) other where foo.a is not distinct fr
</dxl:CostParams>
</dxl:CostModelConfig>
<dxl:Hint JoinArityForAssociativityCommutativity="18" ArrayExpansionThreshold="100" JoinOrderDynamicProgThreshold="10" BroadcastThreshold="10000000" EnforceConstraintsOnDML="false"/>
- <dxl:TraceFlags Value="101013,102001,102002,102003,103045,102046,102048,102053,102054,102074,102120,102144,103001,103014,103015,103022,103027,103033,104003,104004,104005,105000,106000"/>
+ <dxl:TraceFlags Value="101013,102001,102002,102003,103045,102046,102048,102053,102054,102074,102120,102144,103001,103014,103015,103022,103027,103033,103038,103040,104003,104004,104005,105000,106000"/>
</dxl:OptimizerConfig>
<dxl:Metadata SystemIds="0.GPDB">
<dxl:Type Mdid="0.16.1.0" Name="bool" IsRedistributable="true" IsHashable="true" IsMergeJoinable="true" IsComposite="false" IsFixedLength="true" Length="1" PassByValue="true">
@@ -149,6 +149,9 @@ select * from foo, (select NULL a from bar) other where foo.a is not distinct fr
</dxl:Columns>
<dxl:IndexInfoList/>
<dxl:CheckConstraints/>
+ <dxl:DistrOpfamilies>
+ <dxl:DistrOpfamily Mdid="0.1977.1.0"/>
+ </dxl:DistrOpfamilies>
</dxl:Relation>
<dxl:RelationStatistics Mdid="2.25525.1.0" Name="bar" Rows="1.000000" EmptyRelation="false"/>
<dxl:Relation Mdid="6.25525.1.0" Name="bar" IsTemporary="false" StorageType="Heap" DistributionPolicy="Hash" DistributionColumns="0" Keys="8,2">
@@ -183,6 +186,9 @@ select * from foo, (select NULL a from bar) other where foo.a is not distinct fr
</dxl:Columns>
<dxl:IndexInfoList/>
<dxl:CheckConstraints/>
+ <dxl:DistrOpfamilies>
+ <dxl:DistrOpfamily Mdid="0.1977.1.0"/>
+ </dxl:DistrOpfamilies>
</dxl:Relation>
<dxl:GPDBScalarOp Mdid="0.96.1.0" Name="=" ComparisonType="Eq" ReturnsNullOnNullInput="true">
<dxl:LeftType Mdid="0.23.1.0"/>
@@ -342,7 +348,7 @@ select * from foo, (select NULL a from bar) other where foo.a is not distinct fr
<dxl:Filter/>
<dxl:SortingColumnList/>
<dxl:HashExprList>
- <dxl:HashExpr>
+ <dxl:HashExpr Opfamily="0.1977.1.0">
<dxl:Ident ColId="18" ColName="a" TypeMdid="0.23.1.0"/>
</dxl:HashExpr>
</dxl:HashExprList>
diff --git a/src/backend/gporca/data/dxl/minidump/NLJ-DistCol-No-Broadcast.mdp b/src/backend/gporca/data/dxl/minidump/NLJ-DistCol-No-Broadcast.mdp
index 515b6cbc8d..67d7bbebc8 100644
--- a/src/backend/gporca/data/dxl/minidump/NLJ-DistCol-No-Broadcast.mdp
+++ b/src/backend/gporca/data/dxl/minidump/NLJ-DistCol-No-Broadcast.mdp
@@ -29,7 +29,7 @@ explain select * from a1,b1 where a1.a = b1.a;
</dxl:CostParams>
</dxl:CostModelConfig>
<dxl:Hint JoinArityForAssociativityCommutativity="18" ArrayExpansionThreshold="25" JoinOrderDynamicProgThreshold="10" BroadcastThreshold="10000000" EnforceConstraintsOnDML="false"/>
- <dxl:TraceFlags Value="102001,102002,102003,103045,102046,102048,102053,102054,102120,102144,103001,103014,103015,103022,103033,104003,104004,104005,105000"/>
+ <dxl:TraceFlags Value="102001,102002,102003,103045,102046,102048,102053,102054,102120,102144,103001,103014,103015,103022,103033,103038,103040,104003,104004,104005,105000"/>
</dxl:OptimizerConfig>
<dxl:Metadata SystemIds="0.GPDB">
<dxl:Type Mdid="0.16.1.0" Name="bool" IsRedistributable="true" IsHashable="true" IsMergeJoinable="true" IsComposite="false" IsFixedLength="true" Length="1" PassByValue="true">
@@ -155,6 +155,9 @@ explain select * from a1,b1 where a1.a = b1.a;
</dxl:Columns>
<dxl:IndexInfoList/>
<dxl:CheckConstraints/>
+ <dxl:DistrOpfamilies>
+ <dxl:DistrOpfamily Mdid="0.1977.1.0"/>
+ </dxl:DistrOpfamilies>
</dxl:Relation>
<dxl:RelationStatistics Mdid="2.49824.1.0" Name="a1" Rows="0.000000" EmptyRelation="true"/>
<dxl:Relation Mdid="6.49824.1.0" Name="a1" IsTemporary="false" StorageType="Heap" DistributionPolicy="Hash" DistributionColumns="0" Keys="8,2">
@@ -189,6 +192,9 @@ explain select * from a1,b1 where a1.a = b1.a;
</dxl:Columns>
<dxl:IndexInfoList/>
<dxl:CheckConstraints/>
+ <dxl:DistrOpfamilies>
+ <dxl:DistrOpfamily Mdid="0.1977.1.0"/>
+ </dxl:DistrOpfamilies>
</dxl:Relation>
<dxl:ColumnStatistics Mdid="1.49827.1.0.0" Name="a" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000" ColStatsMissing="true"/>
<dxl:ColumnStatistics Mdid="1.49824.1.0.0" Name="a" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000" ColStatsMissing="true"/>
diff --git a/src/backend/gporca/data/dxl/minidump/NLJ-EqAllCol-No-Broadcast.mdp b/src/backend/gporca/data/dxl/minidump/NLJ-EqAllCol-No-Broadcast.mdp
index b0cd1352c2..a3b6bd6c54 100644
--- a/src/backend/gporca/data/dxl/minidump/NLJ-EqAllCol-No-Broadcast.mdp
+++ b/src/backend/gporca/data/dxl/minidump/NLJ-EqAllCol-No-Broadcast.mdp
@@ -8,32 +8,34 @@ set optimizer_enable_hashjoin=off;
explain select * from a1,b1 where a1.a = b1.a and a1.a = b1.b;
QUERY PLAN
- Gather Motion 3:1 (slice1; segments: 3) (cost=0.00..1324032.54 rows=1 width=16)
- -> Nested Loop (cost=0.00..1324032.54 rows=1 width=16)
- Join Filter: a1.a = b1.a AND a1.a = b1.b
- -> Table Scan on a1 (cost=0.00..431.00 rows=1 width=8)
- -> Table Scan on b1 (cost=0.00..431.00 rows=1 width=8)
- Filter: b1.a = b1.b
- Optimizer: PQO version 2.55.1
+ Gather Motion 3:1 (slice1; segments: 3) (cost=0.00..1324032.42 rows=1 width=16)
+ -> Nested Loop (cost=0.00..1324032.42 rows=1 width=16)
+ Join Filter: (a1.a = b1.a)
+ -> Seq Scan on b1 (cost=0.00..431.00 rows=1 width=8)
+ Filter: (a = b)
+ -> Seq Scan on a1 (cost=0.00..431.00 rows=1 width=8)
+ Optimizer: Pivotal Optimizer (GPORCA)
(7 rows)
-->
<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" MaxStatsBuckets="100"/>
+ <dxl:StatisticsConfig DampingFactorFilter="0.750000" DampingFactorJoin="0.000000" DampingFactorGroupBy="0.750000" MaxStatsBuckets="100"/>
<dxl:CTEConfig CTEInliningCutoff="0"/>
<dxl:WindowOids RowNumber="3100" Rank="3101"/>
<dxl:CostModelConfig CostModelType="1" SegmentsForCosting="3">
<dxl:CostParams>
- <dxl:CostParam Name="NLJFactor" Value="1.000000" LowerBound="0.500000" UpperBound="1.500000"/>
+ <dxl:CostParam Name="NLJFactor" Value="1024.000000" LowerBound="1023.500000" UpperBound="1024.500000"/>
</dxl:CostParams>
</dxl:CostModelConfig>
- <dxl:Hint JoinArityForAssociativityCommutativity="18" ArrayExpansionThreshold="25" JoinOrderDynamicProgThreshold="10" BroadcastThreshold="10000000" EnforceConstraintsOnDML="false"/>
- <dxl:TraceFlags Value="102001,102002,102003,103045,102046,102048,102053,102054,102120,102144,103001,103014,103015,103022,103033,104003,104004,104005,105000"/>
+ <dxl:Hint JoinArityForAssociativityCommutativity="18" ArrayExpansionThreshold="20" JoinOrderDynamicProgThreshold="10" BroadcastThreshold="100000" EnforceConstraintsOnDML="false" PushGroupByBelowSetopThreshold="10" XformBindThreshold="0" SkewFactor="0"/>
+ <dxl:TraceFlags Value="101013,102001,102002,102003,102043,102046,102048,102053,102054,102074,102120,102144,102157,102158,103001,103014,103022,103026,103027,103029,103033,103038,103040,103045,104002,104003,104004,104005,106000"/>
</dxl:OptimizerConfig>
<dxl:Metadata SystemIds="0.GPDB">
- <dxl:Type Mdid="0.16.1.0" Name="bool" IsRedistributable="true" IsHashable="true" IsMergeJoinable="true" IsComposite="false" IsFixedLength="true" Length="1" PassByValue="true">
+ <dxl:Type Mdid="0.16.1.0" Name="bool" IsRedistributable="true" IsHashable="true" IsMergeJoinable="true" IsComposite="false" IsTextRelated="false" IsFixedLength="true" Length="1" PassByValue="true">
+ <dxl:DistrOpfamily Mdid="0.2222.1.0"/>
+ <dxl:LegacyDistrOpfamily Mdid="0.7124.1.0"/>
<dxl:EqualityOp Mdid="0.91.1.0"/>
<dxl:InequalityOp Mdid="0.85.1.0"/>
<dxl:LessThanOp Mdid="0.58.1.0"/>
@@ -48,7 +50,9 @@ explain select * from a1,b1 where a1.a = b1.a and a1.a = b1.b;
<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" IsMergeJoinable="true" IsComposite="false" IsFixedLength="true" Length="4" PassByValue="true">
+ <dxl:Type Mdid="0.23.1.0" Name="int4" IsRedistributable="true" IsHashable="true" IsMergeJoinable="true" IsComposite="false" IsTextRelated="false" IsFixedLength="true" Length="4" PassByValue="true">
+ <dxl:DistrOpfamily Mdid="0.1977.1.0"/>
+ <dxl:LegacyDistrOpfamily Mdid="0.7100.1.0"/>
<dxl:EqualityOp Mdid="0.96.1.0"/>
<dxl:InequalityOp Mdid="0.518.1.0"/>
<dxl:LessThanOp Mdid="0.97.1.0"/>
@@ -63,7 +67,9 @@ explain select * from a1,b1 where a1.a = b1.a and a1.a = b1.b;
<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" IsMergeJoinable="true" IsComposite="false" IsFixedLength="true" Length="4" PassByValue="true">
+ <dxl:Type Mdid="0.26.1.0" Name="oid" IsRedistributable="true" IsHashable="true" IsMergeJoinable="true" IsComposite="false" IsTextRelated="false" IsFixedLength="true" Length="4" PassByValue="true">
+ <dxl:DistrOpfamily Mdid="0.1990.1.0"/>
+ <dxl:LegacyDistrOpfamily Mdid="0.7109.1.0"/>
<dxl:EqualityOp Mdid="0.607.1.0"/>
<dxl:InequalityOp Mdid="0.608.1.0"/>
<dxl:LessThanOp Mdid="0.609.1.0"/>
@@ -72,13 +78,15 @@ explain select * from a1,b1 where a1.a = b1.a and a1.a = b1.b;
<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:MinAgg Mdid="0.2134.1.0"/>
+ <dxl:MaxAgg Mdid="0.2118.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" IsMergeJoinable="false" IsComposite="false" IsFixedLength="true" Length="6" PassByValue="false">
+ <dxl:Type Mdid="0.27.1.0" Name="tid" IsRedistributable="true" IsHashable="true" IsMergeJoinable="true" IsComposite="false" IsTextRelated="false" IsFixedLength="true" Length="6" PassByValue="false">
+ <dxl:DistrOpfamily Mdid="0.2227.1.0"/>
+ <dxl:LegacyDistrOpfamily Mdid="0.7110.1.0"/>
<dxl:EqualityOp Mdid="0.387.1.0"/>
<dxl:InequalityOp Mdid="0.402.1.0"/>
<dxl:LessThanOp Mdid="0.2799.1.0"/>
@@ -93,7 +101,8 @@ explain select * from a1,b1 where a1.a = b1.a and a1.a = b1.b;
<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" IsMergeJoinable="false" IsComposite="false" IsFixedLength="true" Length="4" PassByValue="true">
+ <dxl:Type Mdid="0.29.1.0" Name="cid" IsRedistributable="true" IsHashable="true" IsMergeJoinable="false" IsComposite="false" IsTextRelated="false" IsFixedLength="true" Length="4" PassByValue="true">
+ <dxl:DistrOpfamily Mdid="0.2226.1.0"/>
<dxl:EqualityOp Mdid="0.385.1.0"/>
<dxl:InequalityOp Mdid="0.0.0.0"/>
<dxl:LessThanOp Mdid="0.0.0.0"/>
@@ -108,9 +117,10 @@ explain select * from a1,b1 where a1.a = b1.a and a1.a = b1.b;
<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" IsMergeJoinable="false" IsComposite="false" IsFixedLength="true" Length="4" PassByValue="true">
+ <dxl:Type Mdid="0.28.1.0" Name="xid" IsRedistributable="true" IsHashable="true" IsMergeJoinable="false" IsComposite="false" IsTextRelated="false" IsFixedLength="true" Length="4" PassByValue="true">
+ <dxl:DistrOpfamily Mdid="0.2225.1.0"/>
<dxl:EqualityOp Mdid="0.352.1.0"/>
- <dxl:InequalityOp Mdid="0.0.0.0"/>
+ <dxl:InequalityOp Mdid="0.3315.1.0"/>
<dxl:LessThanOp Mdid="0.0.0.0"/>
<dxl:LessThanEqualsOp Mdid="0.0.0.0"/>
<dxl:GreaterThanOp Mdid="0.0.0.0"/>
@@ -123,8 +133,9 @@ explain select * from a1,b1 where a1.a = b1.a and a1.a = b1.b;
<dxl:SumAgg Mdid="0.0.0.0"/>
<dxl:CountAgg Mdid="0.2147.1.0"/>
</dxl:Type>
- <dxl:RelationStatistics Mdid="2.49827.1.0" Name="b1" Rows="0.000000" EmptyRelation="true"/>
- <dxl:Relation Mdid="6.49827.1.0" Name="b1" IsTemporary="false" StorageType="Heap" DistributionPolicy="Hash" DistributionColumns="0" Keys="8,2">
+ <dxl:ColumnStatistics Mdid="1.32768.1.0.0" Name="a" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000" ColStatsMissing="true"/>
+ <dxl:RelationStatistics Mdid="2.32768.1.0" Name="a1" Rows="0.000000" RelPages="0" RelAllVisible="0" EmptyRelation="true"/>
+ <dxl:Relation Mdid="6.32768.1.0" Name="a1" IsTemporary="false" StorageType="Heap" DistributionPolicy="Hash" DistributionColumns="0" Keys="8,2">
<dxl:Columns>
<dxl:Column Name="a" Attno="1" Mdid="0.23.1.0" Nullable="true" ColWidth="4">
<dxl:DefaultValue/>
@@ -135,30 +146,33 @@ explain select * from a1,b1 where a1.a = b1.a and a1.a = b1.b;
<dxl:Column Name="ctid" Attno="-1" Mdid="0.27.1.0" Nullable="false" ColWidth="6">
<dxl:DefaultValue/>
</dxl:Column>
- <dxl:Column Name="xmin" Attno="-3" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
+ <dxl:Column Name="xmin" Attno="-2" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
<dxl:DefaultValue/>
</dxl:Column>
- <dxl:Column Name="cmin" Attno="-4" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
+ <dxl:Column Name="cmin" Attno="-3" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
<dxl:DefaultValue/>
</dxl:Column>
- <dxl:Column Name="xmax" Attno="-5" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
+ <dxl:Column Name="xmax" Attno="-4" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
<dxl:DefaultValue/>
</dxl:Column>
- <dxl:Column Name="cmax" Attno="-6" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
+ <dxl:Column Name="cmax" Attno="-5" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
<dxl:DefaultValue/>
</dxl:Column>
- <dxl:Column Name="tableoid" Attno="-7" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
+ <dxl:Column Name="tableoid" Attno="-6" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
<dxl:DefaultValue/>
</dxl:Column>
- <dxl:Column Name="gp_segment_id" Attno="-8" Mdid="0.23.1.0" Nullable="false" ColWidth="4">
+ <dxl:Column Name="gp_segment_id" Attno="-7" Mdid="0.23.1.0" Nullable="false" ColWidth="4">
<dxl:DefaultValue/>
</dxl:Column>
</dxl:Columns>
<dxl:IndexInfoList/>
<dxl:CheckConstraints/>
+ <dxl:DistrOpfamilies>
+ <dxl:DistrOpfamily Mdid="0.1977.1.0"/>
+ </dxl:DistrOpfamilies>
</dxl:Relation>
- <dxl:RelationStatistics Mdid="2.49824.1.0" Name="a1" Rows="0.000000" EmptyRelation="true"/>
- <dxl:Relation Mdid="6.49824.1.0" Name="a1" IsTemporary="false" StorageType="Heap" DistributionPolicy="Hash" DistributionColumns="0" Keys="8,2">
+ <dxl:RelationStatistics Mdid="2.32771.1.0" Name="b1" Rows="0.000000" RelPages="0" RelAllVisible="0" EmptyRelation="true"/>
+ <dxl:Relation Mdid="6.32771.1.0" Name="b1" IsTemporary="false" StorageType="Heap" DistributionPolicy="Hash" DistributionColumns="0" Keys="8,2">
<dxl:Columns>
<dxl:Column Name="a" Attno="1" Mdid="0.23.1.0" Nullable="true" ColWidth="4">
<dxl:DefaultValue/>
@@ -169,42 +183,51 @@ explain select * from a1,b1 where a1.a = b1.a and a1.a = b1.b;
<dxl:Column Name="ctid" Attno="-1" Mdid="0.27.1.0" Nullable="false" ColWidth="6">
<dxl:DefaultValue/>
</dxl:Column>
- <dxl:Column Name="xmin" Attno="-3" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
+ <dxl:Column Name="xmin" Attno="-2" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
<dxl:DefaultValue/>
</dxl:Column>
- <dxl:Column Name="cmin" Attno="-4" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
+ <dxl:Column Name="cmin" Attno="-3" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
<dxl:DefaultValue/>
</dxl:Column>
- <dxl:Column Name="xmax" Attno="-5" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
+ <dxl:Column Name="xmax" Attno="-4" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
<dxl:DefaultValue/>
</dxl:Column>
- <dxl:Column Name="cmax" Attno="-6" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
+ <dxl:Column Name="cmax" Attno="-5" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
<dxl:DefaultValue/>
</dxl:Column>
- <dxl:Column Name="tableoid" Attno="-7" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
+ <dxl:Column Name="tableoid" Attno="-6" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
<dxl:DefaultValue/>
</dxl:Column>
- <dxl:Column Name="gp_segment_id" Attno="-8" Mdid="0.23.1.0" Nullable="false" ColWidth="4">
+ <dxl:Column Name="gp_segment_id" Attno="-7" Mdid="0.23.1.0" Nullable="false" ColWidth="4">
<dxl:DefaultValue/>
</dxl:Column>
</dxl:Columns>
<dxl:IndexInfoList/>
<dxl:CheckConstraints/>
+ <dxl:DistrOpfamilies>
+ <dxl:DistrOpfamily Mdid="0.1977.1.0"/>
+ </dxl:DistrOpfamilies>
</dxl:Relation>
- <dxl:ColumnStatistics Mdid="1.49827.1.0.1" Name="b" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000" ColStatsMissing="true"/>
- <dxl:ColumnStatistics Mdid="1.49827.1.0.0" Name="a" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000" ColStatsMissing="true"/>
- <dxl:ColumnStatistics Mdid="1.49824.1.0.0" Name="a" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000" ColStatsMissing="true"/>
- <dxl:GPDBScalarOp Mdid="0.96.1.0" Name="=" ComparisonType="Eq" ReturnsNullOnNullInput="true">
+ <dxl:ColumnStatistics Mdid="1.32771.1.0.1" Name="b" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000" ColStatsMissing="true"/>
+ <dxl:ColumnStatistics Mdid="1.32771.1.0.0" Name="a" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000" ColStatsMissing="true"/>
+ <dxl:RelationExtendedStatistics Mdid="10.32768.1.0" Name="a1"/>
+ <dxl:RelationExtendedStatistics Mdid="10.32771.1.0" Name="b1"/>
+ <dxl:MDCast Mdid="3.23.1.0;23.1.0" Name="int4" BinaryCoercible="true" SourceTypeId="0.23.1.0" DestinationTypeId="0.23.1.0" CastFuncId="0.0.0.0" CoercePathType="0"/>
+ <dxl:GPDBScalarOp Mdid="0.96.1.0" Name="=" ComparisonType="Eq" ReturnsNullOnNullInput="true" IsNDVPreserving="false">
<dxl:LeftType Mdid="0.23.1.0"/>
<dxl:RightType Mdid="0.23.1.0"/>
<dxl:ResultType Mdid="0.16.1.0"/>
<dxl:OpFunc Mdid="0.65.1.0"/>
<dxl:Commutator Mdid="0.96.1.0"/>
<dxl:InverseOp Mdid="0.518.1.0"/>
+ <dxl:HashOpfamily Mdid="0.1977.1.0"/>
+ <dxl:LegacyHashOpfamily Mdid="0.7100.1.0"/>
<dxl:Opfamilies>
<dxl:Opfamily Mdid="0.1976.1.0"/>
<dxl:Opfamily Mdid="0.1977.1.0"/>
- <dxl:Opfamily Mdid="0.7027.1.0"/>
+ <dxl:Opfamily Mdid="0.4054.1.0"/>
+ <dxl:Opfamily Mdid="0.7100.1.0"/>
+ <dxl:Opfamily Mdid="0.10009.1.0"/>
</dxl:Opfamilies>
</dxl:GPDBScalarOp>
</dxl:Metadata>
@@ -218,32 +241,32 @@ explain select * from a1,b1 where a1.a = b1.a and a1.a = b1.b;
<dxl:CTEList/>
<dxl:LogicalJoin JoinType="Inner">
<dxl:LogicalGet>
- <dxl:TableDescriptor Mdid="6.49824.1.0" TableName="a1">
+ <dxl:TableDescriptor Mdid="6.32768.1.0" TableName="a1" LockMode="1">
<dxl:Columns>
<dxl:Column ColId="1" Attno="1" ColName="a" TypeMdid="0.23.1.0" ColWidth="4"/>
<dxl:Column ColId="2" Attno="2" ColName="b" TypeMdid="0.23.1.0" ColWidth="4"/>
<dxl:Column ColId="3" Attno="-1" ColName="ctid" TypeMdid="0.27.1.0" ColWidth="6"/>
- <dxl:Column ColId="4" Attno="-3" ColName="xmin" TypeMdid="0.28.1.0" ColWidth="4"/>
- <dxl:Column ColId="5" Attno="-4" ColName="cmin" TypeMdid="0.29.1.0" ColWidth="4"/>
- <dxl:Column ColId="6" Attno="-5" ColName="xmax" TypeMdid="0.28.1.0" ColWidth="4"/>
- <dxl:Column ColId="7" Attno="-6" ColName="cmax" TypeMdid="0.29.1.0" ColWidth="4"/>
- <dxl:Column ColId="8" Attno="-7" ColName="tableoid" TypeMdid="0.26.1.0" ColWidth="4"/>
- <dxl:Column ColId="9" Attno="-8" ColName="gp_segment_id" TypeMdid="0.23.1.0" ColWidth="4"/>
+ <dxl:Column ColId="4" Attno="-2" ColName="xmin" TypeMdid="0.28.1.0" ColWidth="4"/>
+ <dxl:Column ColId="5" Attno="-3" ColName="cmin" TypeMdid="0.29.1.0" ColWidth="4"/>
+ <dxl:Column ColId="6" Attno="-4" ColName="xmax" TypeMdid="0.28.1.0" ColWidth="4"/>
+ <dxl:Column ColId="7" Attno="-5" ColName="cmax" TypeMdid="0.29.1.0" ColWidth="4"/>
+ <dxl:Column ColId="8" Attno="-6" ColName="tableoid" TypeMdid="0.26.1.0" ColWidth="4"/>
+ <dxl:Column ColId="9" Attno="-7" ColName="gp_segment_id" TypeMdid="0.23.1.0" ColWidth="4"/>
</dxl:Columns>
</dxl:TableDescriptor>
</dxl:LogicalGet>
<dxl:LogicalGet>
- <dxl:TableDescriptor Mdid="6.49827.1.0" TableName="b1">
+ <dxl:TableDescriptor Mdid="6.32771.1.0" TableName="b1" LockMode="1">
<dxl:Columns>
<dxl:Column ColId="10" Attno="1" ColName="a" TypeMdid="0.23.1.0" ColWidth="4"/>
<dxl:Column ColId="11" Attno="2" ColName="b" TypeMdid="0.23.1.0" ColWidth="4"/>
<dxl:Column ColId="12" Attno="-1" ColName="ctid" TypeMdid="0.27.1.0" ColWidth="6"/>
- <dxl:Column ColId="13" Attno="-3" ColName="xmin" TypeMdid="0.28.1.0" ColWidth="4"/>
- <dxl:Column ColId="14" Attno="-4" ColName="cmin" TypeMdid="0.29.1.0" ColWidth="4"/>
- <dxl:Column ColId="15" Attno="-5" ColName="xmax" TypeMdid="0.28.1.0" ColWidth="4"/>
- <dxl:Column ColId="16" Attno="-6" ColName="cmax" TypeMdid="0.29.1.0" ColWidth="4"/>
- <dxl:Column ColId="17" Attno="-7" ColName="tableoid" TypeMdid="0.26.1.0" ColWidth="4"/>
- <dxl:Column ColId="18" Attno="-8" ColName="gp_segment_id" TypeMdid="0.23.1.0" ColWidth="4"/>
+ <dxl:Column ColId="13" Attno="-2" ColName="xmin" TypeMdid="0.28.1.0" ColWidth="4"/>
+ <dxl:Column ColId="14" Attno="-3" ColName="cmin" TypeMdid="0.29.1.0" ColWidth="4"/>
+ <dxl:Column ColId="15" Attno="-4" ColName="xmax" TypeMdid="0.28.1.0" ColWidth="4"/>
+ <dxl:Column ColId="16" Attno="-5" ColName="cmax" TypeMdid="0.29.1.0" ColWidth="4"/>
+ <dxl:Column ColId="17" Attno="-6" ColName="tableoid" TypeMdid="0.26.1.0" ColWidth="4"/>
+ <dxl:Column ColId="18" Attno="-7" ColName="gp_segment_id" TypeMdid="0.23.1.0" ColWidth="4"/>
</dxl:Columns>
</dxl:TableDescriptor>
</dxl:LogicalGet>
@@ -262,7 +285,7 @@ explain select * from a1,b1 where a1.a = b1.a and a1.a = b1.b;
<dxl:Plan Id="0" SpaceSize="6">
<dxl:GatherMotion InputSegments="0,1,2" OutputSegments="-1">
<dxl:Properties>
- <dxl:Cost StartupCost="0" TotalCost="1293.000469" Rows="1.000000" Width="16"/>
+ <dxl:Cost StartupCost="0" TotalCost="1324032.419755" Rows="1.000000" Width="16"/>
</dxl:Properties>
<dxl:ProjList>
<dxl:ProjElem ColId="0" Alias="a">
@@ -282,7 +305,7 @@ explain select * from a1,b1 where a1.a = b1.a and a1.a = b1.b;
<dxl:SortingColumnList/>
<dxl:NestedLoopJoin JoinType="Inner" IndexNestedLoopJoin="false" OuterRefAsParam="false">
<dxl:Properties>
- <dxl:Cost StartupCost="0" TotalCost="1293.000410" Rows="1.000000" Width="16"/>
+ <dxl:Cost StartupCost="0" TotalCost="1324032.419695" Rows="1.000000" Width="16"/>
</dxl:Properties>
<dxl:ProjList>
<dxl:ProjElem ColId="0" Alias="a">
@@ -323,17 +346,17 @@ explain select * from a1,b1 where a1.a = b1.a and a1.a = b1.b;
<dxl:Ident ColId="10" ColName="b" TypeMdid="0.23.1.0"/>
</dxl:Comparison>
</dxl:Filter>
- <dxl:TableDescriptor Mdid="6.49827.1.0" TableName="b1">
+ <dxl:TableDescriptor Mdid="6.32771.1.0" TableName="b1" LockMode="1">
<dxl:Columns>
<dxl:Column ColId="9" Attno="1" ColName="a" TypeMdid="0.23.1.0" ColWidth="4"/>
<dxl:Column ColId="10" Attno="2" ColName="b" TypeMdid="0.23.1.0" ColWidth="4"/>
<dxl:Column ColId="11" Attno="-1" ColName="ctid" TypeMdid="0.27.1.0" ColWidth="6"/>
- <dxl:Column ColId="12" Attno="-3" ColName="xmin" TypeMdid="0.28.1.0" ColWidth="4"/>
- <dxl:Column ColId="13" Attno="-4" ColName="cmin" TypeMdid="0.29.1.0" ColWidth="4"/>
- <dxl:Column ColId="14" Attno="-5" ColName="xmax" TypeMdid="0.28.1.0" ColWidth="4"/>
- <dxl:Column ColId="15" Attno="-6" ColName="cmax" TypeMdid="0.29.1.0" ColWidth="4"/>
- <dxl:Column ColId="16" Attno="-7" ColName="tableoid" TypeMdid="0.26.1.0" ColWidth="4"/>
- <dxl:Column ColId="17" Attno="-8" ColName="gp_segment_id" TypeMdid="0.23.1.0" ColWidth="4"/>
+ <dxl:Column ColId="12" Attno="-2" ColName="xmin" TypeMdid="0.28.1.0" ColWidth="4"/>
+ <dxl:Column ColId="13" Attno="-3" ColName="cmin" TypeMdid="0.29.1.0" ColWidth="4"/>
+ <dxl:Column ColId="14" Attno="-4" ColName="xmax" TypeMdid="0.28.1.0" ColWidth="4"/>
+ <dxl:Column ColId="15" Attno="-5" ColName="cmax" TypeMdid="0.29.1.0" ColWidth="4"/>
+ <dxl:Column ColId="16" Attno="-6" ColName="tableoid" TypeMdid="0.26.1.0" ColWidth="4"/>
+ <dxl:Column ColId="17" Attno="-7" ColName="gp_segment_id" TypeMdid="0.23.1.0" ColWidth="4"/>
</dxl:Columns>
</dxl:TableDescriptor>
</dxl:TableScan>
@@ -350,17 +373,17 @@ explain select * from a1,b1 where a1.a = b1.a and a1.a = b1.b;
</dxl:ProjElem>
</dxl:ProjList>
<dxl:Filter/>
- <dxl:TableDescriptor Mdid="6.49824.1.0" TableName="a1">
+ <dxl:TableDescriptor Mdid="6.32768.1.0" TableName="a1" LockMode="1">
<dxl:Columns>
<dxl:Column ColId="0" Attno="1" ColName="a" TypeMdid="0.23.1.0" ColWidth="4"/>
<dxl:Column ColId="1" Attno="2" ColName="b" TypeMdid="0.23.1.0" ColWidth="4"/>
<dxl:Column ColId="2" Attno="-1" ColName="ctid" TypeMdid="0.27.1.0" ColWidth="6"/>
- <dxl:Column ColId="3" Attno="-3" ColName="xmin" TypeMdid="0.28.1.0" ColWidth="4"/>
- <dxl:Column ColId="4" Attno="-4" ColName="cmin" TypeMdid="0.29.1.0" ColWidth="4"/>
- <dxl:Column ColId="5" Attno="-5" ColName="xmax" TypeMdid="0.28.1.0" ColWidth="4"/>
- <dxl:Column ColId="6" Attno="-6" ColName="cmax" TypeMdid="0.29.1.0" ColWidth="4"/>
- <dxl:Column ColId="7" Attno="-7" ColName="tableoid" TypeMdid="0.26.1.0" ColWidth="4"/>
- <dxl:Column ColId="8" Attno="-8" ColName="gp_segment_id" TypeMdid="0.23.1.0" ColWidth="4"/>
+ <dxl:Column ColId="3" Attno="-2" ColName="xmin" TypeMdid="0.28.1.0" ColWidth="4"/>
+ <dxl:Column ColId="4" Attno="-3" ColName="cmin" TypeMdid="0.29.1.0" ColWidth="4"/>
+ <dxl:Column ColId="5" Attno="-4" ColName="xmax" TypeMdid="0.28.1.0" ColWidth="4"/>
+ <dxl:Column ColId="6" Attno="-5" ColName="cmax" TypeMdid="0.29.1.0" ColWidth="4"/>
+ <dxl:Column ColId="7" Attno="-6" ColName="tableoid" TypeMdid="0.26.1.0" ColWidth="4"/>
+ <dxl:Column ColId="8" Attno="-7" ColName="gp_segment_id" TypeMdid="0.23.1.0" ColWidth="4"/>
</dxl:Columns>
</dxl:TableDescriptor>
</dxl:TableScan>
diff --git a/src/backend/gporca/data/dxl/minidump/NLJ-EqDistCol-InEqNonDistCol-No-Broadcast.mdp b/src/backend/gporca/data/dxl/minidump/NLJ-EqDistCol-InEqNonDistCol-No-Broadcast.mdp
index 5d337795cd..594e57c164 100644
--- a/src/backend/gporca/data/dxl/minidump/NLJ-EqDistCol-InEqNonDistCol-No-Broadcast.mdp
+++ b/src/backend/gporca/data/dxl/minidump/NLJ-EqDistCol-InEqNonDistCol-No-Broadcast.mdp
@@ -29,7 +29,7 @@ explain select * from a1,b1 where a1.a = b1.a and a1.a != b1.b;
</dxl:CostParams>
</dxl:CostModelConfig>
<dxl:Hint JoinArityForAssociativityCommutativity="18" ArrayExpansionThreshold="25" JoinOrderDynamicProgThreshold="10" BroadcastThreshold="10000000" EnforceConstraintsOnDML="false"/>
- <dxl:TraceFlags Value="103045,102046,102048,102053,102054,102120,103001,103014,103015,103022,104003,104004,104005,105000"/>
+ <dxl:TraceFlags Value="103045,102046,102048,102053,102054,102120,103001,103014,103015,103022,103038,103040,104003,104004,104005,105000"/>
</dxl:OptimizerConfig>
<dxl:Metadata SystemIds="0.GPDB">
<dxl:GPDBScalarOp Mdid="0.518.1.0" Name="<>" ComparisonType="NEq" ReturnsNullOnNullInput="true">
@@ -163,6 +163,9 @@ explain select * from a1,b1 where a1.a = b1.a and a1.a != b1.b;
</dxl:Columns>
<dxl:IndexInfoList/>
<dxl:CheckConstraints/>
+ <dxl:DistrOpfamilies>
+ <dxl:DistrOpfamily Mdid="0.1977.1.0"/>
+ </dxl:DistrOpfamilies>
</dxl:Relation>
<dxl:RelationStatistics Mdid="2.49824.1.0" Name="a1" Rows="0.000000" EmptyRelation="true"/>
<dxl:Relation Mdid="6.49824.1.0" Name="a1" IsTemporary="false" StorageType="Heap" DistributionPolicy="Hash" DistributionColumns="0" Keys="8,2">
@@ -197,6 +200,9 @@ explain select * from a1,b1 where a1.a = b1.a and a1.a != b1.b;
</dxl:Columns>
<dxl:IndexInfoList/>
<dxl:CheckConstraints/>
+ <dxl:DistrOpfamilies>
+ <dxl:DistrOpfamily Mdid="0.1977.1.0"/>
+ </dxl:DistrOpfamilies>
</dxl:Relation>
<dxl:ColumnStatistics Mdid="1.49827.1.0.1" Name="b" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000" ColStatsMissing="true"/>
<dxl:ColumnStatistics Mdid="1.49827.1.0.0" Name="a" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000" ColStatsMissing="true"/>
diff --git a/src/backend/gporca/data/dxl/minidump/NLJ-InEqDistCol-EqNonDistCol-Redistribute.mdp b/src/backend/gporca/data/dxl/minidump/NLJ-InEqDistCol-EqNonDistCol-Redistribute.mdp
index 655d58b571..650b254a56 100644
--- a/src/backend/gporca/data/dxl/minidump/NLJ-InEqDistCol-EqNonDistCol-Redistribute.mdp
+++ b/src/backend/gporca/data/dxl/minidump/NLJ-InEqDistCol-EqNonDistCol-Redistribute.mdp
@@ -32,7 +32,7 @@ explain select * from a1,b1 where a1.a != b1.a and a1.a = b1.b;
</dxl:CostParams>
</dxl:CostModelConfig>
<dxl:Hint JoinArityForAssociativityCommutativity="18" ArrayExpansionThreshold="25" JoinOrderDynamicProgThreshold="10" BroadcastThreshold="10000000" EnforceConstraintsOnDML="false"/>
- <dxl:TraceFlags Value="102001,102002,102003,103045,102046,102048,102053,102054,102120,102144,103001,103014,103015,103022,103033,104003,104004,104005,105000"/>
+ <dxl:TraceFlags Value="102001,102002,102003,103045,102046,102048,102053,102054,102120,102144,103001,103014,103015,103022,103033,103038,103040,104003,104004,104005,105000"/>
</dxl:OptimizerConfig>
<dxl:Metadata SystemIds="0.GPDB">
<dxl:GPDBScalarOp Mdid="0.518.1.0" Name="<>" ComparisonType="NEq" ReturnsNullOnNullInput="true">
@@ -166,6 +166,9 @@ explain select * from a1,b1 where a1.a != b1.a and a1.a = b1.b;
</dxl:Columns>
<dxl:IndexInfoList/>
<dxl:CheckConstraints/>
+ <dxl:DistrOpfamilies>
+ <dxl:DistrOpfamily Mdid="0.1977.1.0"/>
+ </dxl:DistrOpfamilies>
</dxl:Relation>
<dxl:RelationStatistics Mdid="2.49824.1.0" Name="a1" Rows="0.000000" EmptyRelation="true"/>
<dxl:Relation Mdid="6.49824.1.0" Name="a1" IsTemporary="false" StorageType="Heap" DistributionPolicy="Hash" DistributionColumns="0" Keys="8,2">
@@ -200,6 +203,9 @@ explain select * from a1,b1 where a1.a != b1.a and a1.a = b1.b;
</dxl:Columns>
<dxl:IndexInfoList/>
<dxl:CheckConstraints/>
+ <dxl:DistrOpfamilies>
+ <dxl:DistrOpfamily Mdid="0.1977.1.0"/>
+ </dxl:DistrOpfamilies>
</dxl:Relation>
<dxl:ColumnStatistics Mdid="1.49827.1.0.1" Name="b" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000" ColStatsMissing="true"/>
<dxl:ColumnStatistics Mdid="1.49827.1.0.0" Name="a" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000" ColStatsMissing="true"/>
@@ -376,7 +382,7 @@ explain select * from a1,b1 where a1.a != b1.a and a1.a = b1.b;
<dxl:Filter/>
<dxl:SortingColumnList/>
<dxl:HashExprList>
- <dxl:HashExpr>
+ <dxl:HashExpr Opfamily="0.1977.1.0">
<dxl:Ident ColId="10" ColName="b" TypeMdid="0.23.1.0"/>
</dxl:HashExpr>
</dxl:HashExprList>
diff --git a/src/backend/gporca/libgpopt/include/gpopt/mdcache/CMDAccessorUtils.h b/src/backend/gporca/libgpopt/include/gpopt/mdcache/CMDAccessorUtils.h
index aaf523f8d6..357c2372c1 100644
--- a/src/backend/gporca/libgpopt/include/gpopt/mdcache/CMDAccessorUtils.h
+++ b/src/backend/gporca/libgpopt/include/gpopt/mdcache/CMDAccessorUtils.h
@@ -44,6 +44,10 @@ public:
static BOOL FCastExists(CMDAccessor *md_accessor, IMDId *mdid_src,
IMDId *mdid_dest);
+ // check if srctype is binary-coercible to targettype.
+ static BOOL FBinaryCoercible(CMDAccessor *md_accessor, IMDId *mdid_src,
+ IMDId *mdid_dest);
+
// does a scalar comparison object between given types exist
static BOOL FCmpExists(CMDAccessor *md_accessor, IMDId *left_mdid,
IMDId *right_mdid, IMDType::ECmpType cmp_type);
diff --git a/src/backend/gporca/libgpopt/src/mdcache/CMDAccessorUtils.cpp b/src/backend/gporca/libgpopt/src/mdcache/CMDAccessorUtils.cpp
index 0e0a22be1e..324df1c6c9 100644
--- a/src/backend/gporca/libgpopt/src/mdcache/CMDAccessorUtils.cpp
+++ b/src/backend/gporca/libgpopt/src/mdcache/CMDAccessorUtils.cpp
@@ -23,6 +23,7 @@
#include "naucrates/exception.h"
#include "naucrates/md/CMDIdGPDB.h"
#include "naucrates/md/IMDAggregate.h"
+#include "naucrates/md/IMDCast.h"
#include "naucrates/md/IMDFunction.h"
#include "naucrates/md/IMDScCmp.h"
#include "naucrates/md/IMDScalarOp.h"
@@ -361,6 +362,32 @@ CMDAccessorUtils::FCastExists(CMDAccessor *md_accessor, IMDId *mdid_src,
}
+//---------------------------------------------------------------------------
+// @function:
+// CMDAccessorUtils::FBinaryCoercible
+//
+// @doc:
+// Check if srctype is binary-coercible to targettype.
+// A cast object existing between srctype and
+// targettype is a necessary condition
+//
+//---------------------------------------------------------------------------
+BOOL
+CMDAccessorUtils::FBinaryCoercible(CMDAccessor *md_accessor, IMDId *mdid_src,
+ IMDId *mdid_dest)
+{
+ if (FCastExists(md_accessor, mdid_src, mdid_dest))
+ {
+ const IMDCast *pmdcast = md_accessor->Pmdcast(mdid_src, mdid_dest);
+ if (pmdcast->IsBinaryCoercible())
+ {
+ return true;
+ }
+ }
+ return false;
+}
+
+
//---------------------------------------------------------------------------
// @function:
// CUtils::FScalarOpReturnsNullOnNullInput
diff --git a/src/backend/gporca/libgpopt/src/operators/CPhysicalJoin.cpp b/src/backend/gporca/libgpopt/src/operators/CPhysicalJoin.cpp
index c08e4da775..a4575a9c06 100644
--- a/src/backend/gporca/libgpopt/src/operators/CPhysicalJoin.cpp
+++ b/src/backend/gporca/libgpopt/src/operators/CPhysicalJoin.cpp
@@ -17,6 +17,7 @@
#include "gpopt/base/COptCtxt.h"
#include "gpopt/base/CUtils.h"
#include "gpopt/exception.h"
+#include "gpopt/mdcache/CMDAccessorUtils.h"
#include "gpopt/operators/CExpressionHandle.h"
#include "gpopt/operators/CPhysicalInnerIndexNLJoin.h"
#include "gpopt/operators/CPhysicalLeftOuterIndexNLJoin.h"
@@ -346,10 +347,39 @@ CPhysicalJoin::PedInnerHashedFromOuterHashed(
CUtils::FScalarIdent(pexprMatching));
if (fSuccess)
{
+ BOOL isBinaryCoercible = true;
+
IMDId *pmdidTypeInner =
CScalar::PopConvert(pexprMatching->Pop())->MdidType();
+
+ IMDId *pmdidTypeOuter =
+ CScalar::PopConvert(pexpr->Pop())->MdidType();
+
CMDAccessor *md_accessor = COptCtxt::PoctxtFromTLS()->Pmda();
- if (md_accessor->RetrieveType(pmdidTypeInner)->IsHashable())
+
+ IMDId *mdid_opfamily_inner =
+ md_accessor->RetrieveType(pmdidTypeInner)
+ ->GetDistrOpfamilyMdid();
+
+ IMDId *mdid_opfamily_outer =
+ md_accessor->RetrieveType(pmdidTypeOuter)
+ ->GetDistrOpfamilyMdid();
+
+ // If the inner relation column datatype is binary coercible to outer
+ // relation column datatype,then hashing of the inner column datatype
+ // is possible by a hash function present in the opfamily of the outer
+ // relation column.This approach is mentioned in "cdb_hashproc_in_opfamily" method.
+ // If its binary coercible then inner relation will be redistributed else
+ // broadcast of the inner relation will happen.
+ if (!mdid_opfamily_outer->Equals(mdid_opfamily_inner) &&
+ !CMDAccessorUtils::FBinaryCoercible(
+ md_accessor, pmdidTypeInner, pmdidTypeOuter))
+ {
+ isBinaryCoercible = false;
+ }
+
+ if (isBinaryCoercible &&
+ md_accessor->RetrieveType(pmdidTypeInner)->IsHashable())
{
pexprMatching->AddRef();
pdrgpexprMatching->Append(pexprMatching);
@@ -365,11 +395,16 @@ CPhysicalJoin::PedInnerHashedFromOuterHashed(
if (fSuccess)
{
GPOS_ASSERT(pdrgpexprMatching->Size() == pdrgpexprHashed->Size());
-
+ IMdIdArray *opfamilies = pdshashed->Opfamilies();
+ if (nullptr != opfamilies)
+ {
+ opfamilies->AddRef();
+ }
// create a matching hashed distribution request
BOOL fNullsColocated = pdshashed->FNullsColocated();
- CDistributionSpecHashed *pdshashedEquiv = GPOS_NEW(mp)
- CDistributionSpecHashed(pdrgpexprMatching, fNullsColocated);
+ CDistributionSpecHashed *pdshashedEquiv =
+ GPOS_NEW(mp) CDistributionSpecHashed(
+ pdrgpexprMatching, fNullsColocated, opfamilies);
pdshashedEquiv->ComputeEquivHashExprs(mp, exprhdl);
return GPOS_NEW(mp) CEnfdDistribution(pdshashedEquiv, dmatch);
}
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cloudberry.apache.org
For additional commands, e-mail: commits-help@cloudberry.apache.org