pathlist
application/octet-stream
{RELOPTINFO
:reloptkind 1
:relids (b 1 2 3)
:rows 414187
:width 186
:reltargetlist (
{VAR
:varno 1
:varattno 1
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 1
:varoattno 1
:location 7
}
{VAR
:varno 2
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 1
:location 7
}
{VAR
:varno 2
:varattno 2
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 2
:location 7
}
{VAR
:varno 2
:varattno 3
:vartype 23
:vartypmod -1
:varcollid 0
:varlevelsup 0
:varnoold 2
:varoattno 3
:location 7
}
{VAR
:varno 3
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 3
:varoattno 1
:location 7
}
{VAR
:varno 3
:varattno 2
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 3
:varoattno 2
:location 7
}
{VAR
:varno 3
:varattno 3
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 3
:varoattno 3
:location 7
}
{VAR
:varno 3
:varattno 4
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 3
:varoattno 4
:location 7
}
{VAR
:varno 3
:varattno 5
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 3
:varoattno 5
:location 7
}
)
:pathlist (
{HASHPATH
:pathtype 124
:parent_relids (b 1 2 3)
:startup_cost 24390.42
:total_cost 80187.02
:pathkeys <>
:jointype 0
:outerjoinpath
{HASHPATH
:pathtype 124
:parent_relids (b 2 3)
:startup_cost 18386.21
:total_cost 50153.53
:pathkeys <>
:jointype 0
:outerjoinpath
{PATH
:pathtype 109
:parent_relids (b 3)
:startup_cost 0.00
:total_cost 10068.20
:pathkeys <>
}
:innerjoinpath
{PATH
:pathtype 109
:parent_relids (b 2)
:startup_cost 0.00
:total_cost 8758.87
:pathkeys <>
}
:joinrestrictinfo (
{RESTRICTINFO
:clause
{OPEXPR
:opno 98
:opfuncid 67
:opresulttype 16
:opretset false
:opcollid 0
:inputcollid 100
:args (
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 1
:location 99
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
{RELABELTYPE
:arg
{VAR
:varno 3
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 3
:varoattno 1
:location 115
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
)
:location -1
}
:is_pushed_down true
:outerjoin_delayed false
:can_join true
:pseudoconstant false
:clause_relids (b 2 3)
:required_relids (b 2 3)
:nullable_relids (b)
:left_relids (b 2)
:right_relids (b 3)
:orclause <>
:norm_selec 0.0000
:outer_selec -1.0000
:mergeopfamilies (o 1994 2095)
:left_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 1
:location 99
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 2)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:right_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 3
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 3
:varoattno 1
:location 115
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 3)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:outer_is_left false
:hashjoinoperator 98
}
)
:path_hashclauses (
{RESTRICTINFO
:clause
{OPEXPR
:opno 98
:opfuncid 67
:opresulttype 16
:opretset false
:opcollid 0
:inputcollid 100
:args (
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 1
:location 99
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
{RELABELTYPE
:arg
{VAR
:varno 3
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 3
:varoattno 1
:location 115
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
)
:location -1
}
:is_pushed_down true
:outerjoin_delayed false
:can_join true
:pseudoconstant false
:clause_relids (b 2 3)
:required_relids (b 2 3)
:nullable_relids (b)
:left_relids (b 2)
:right_relids (b 3)
:orclause <>
:norm_selec 0.0000
:outer_selec -1.0000
:mergeopfamilies (o 1994 2095)
:left_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 1
:location 99
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 2)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:right_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 3
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 3
:varoattno 1
:location 115
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 3)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:outer_is_left false
:hashjoinoperator 98
}
)
:num_batches 64
}
:innerjoinpath
{PATH
:pathtype 109
:parent_relids (b 1)
:startup_cost 0.00
:total_cost 2878.43
:pathkeys <>
}
:joinrestrictinfo (
{RESTRICTINFO
:clause
{OPEXPR
:opno 98
:opfuncid 67
:opresulttype 16
:opretset false
:opcollid 0
:inputcollid 100
:args (
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 2
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 2
:location 82
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
{RELABELTYPE
:arg
{VAR
:varno 1
:varattno 1
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 1
:varoattno 1
:location 69
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
)
:location -1
}
:is_pushed_down true
:outerjoin_delayed false
:can_join true
:pseudoconstant false
:clause_relids (b 1 2)
:required_relids (b 1 2)
:nullable_relids (b)
:left_relids (b 2)
:right_relids (b 1)
:orclause <>
:norm_selec 0.0000
:outer_selec -1.0000
:mergeopfamilies (o 1994 2095)
:left_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 2
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 2
:location 82
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 2)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:right_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 1
:varattno 1
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 1
:varoattno 1
:location 69
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 1)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:outer_is_left false
:hashjoinoperator 98
}
)
:path_hashclauses (
{RESTRICTINFO
:clause
{OPEXPR
:opno 98
:opfuncid 67
:opresulttype 16
:opretset false
:opcollid 0
:inputcollid 100
:args (
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 2
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 2
:location 82
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
{RELABELTYPE
:arg
{VAR
:varno 1
:varattno 1
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 1
:varoattno 1
:location 69
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
)
:location -1
}
:is_pushed_down true
:outerjoin_delayed false
:can_join true
:pseudoconstant false
:clause_relids (b 1 2)
:required_relids (b 1 2)
:nullable_relids (b)
:left_relids (b 2)
:right_relids (b 1)
:orclause <>
:norm_selec 0.0000
:outer_selec -1.0000
:mergeopfamilies (o 1994 2095)
:left_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 2
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 2
:location 82
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 2)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:right_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 1
:varattno 1
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 1
:varoattno 1
:location 69
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 1)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:outer_is_left false
:hashjoinoperator 98
}
)
:num_batches 16
}
{NESTPATH
:pathtype 122
:parent_relids (b 1 2 3)
:startup_cost 6004.22
:total_cost 211604.22
:pathkeys <>
:jointype 0
:outerjoinpath
{HASHPATH
:pathtype 124
:parent_relids (b 1 2)
:startup_cost 6004.22
:total_cost 32320.36
:pathkeys <>
:jointype 0
:outerjoinpath
{PATH
:pathtype 109
:parent_relids (b 2)
:startup_cost 0.00
:total_cost 8758.87
:pathkeys <>
}
:innerjoinpath
{PATH
:pathtype 109
:parent_relids (b 1)
:startup_cost 0.00
:total_cost 2878.43
:pathkeys <>
}
:joinrestrictinfo (
{RESTRICTINFO
:clause
{OPEXPR
:opno 98
:opfuncid 67
:opresulttype 16
:opretset false
:opcollid 0
:inputcollid 100
:args (
{RELABELTYPE
:arg
{VAR
:varno 1
:varattno 1
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 1
:varoattno 1
:location 69
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 2
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 2
:location 82
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
)
:location -1
}
:is_pushed_down true
:outerjoin_delayed false
:can_join true
:pseudoconstant false
:clause_relids (b 1 2)
:required_relids (b 1 2)
:nullable_relids (b)
:left_relids (b 1)
:right_relids (b 2)
:orclause <>
:norm_selec 0.0000
:outer_selec -1.0000
:mergeopfamilies (o 1994 2095)
:left_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 1
:varattno 1
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 1
:varoattno 1
:location 69
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 1)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:right_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 2
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 2
:location 82
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 2)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:outer_is_left false
:hashjoinoperator 98
}
)
:path_hashclauses (
{RESTRICTINFO
:clause
{OPEXPR
:opno 98
:opfuncid 67
:opresulttype 16
:opretset false
:opcollid 0
:inputcollid 100
:args (
{RELABELTYPE
:arg
{VAR
:varno 1
:varattno 1
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 1
:varoattno 1
:location 69
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 2
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 2
:location 82
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
)
:location -1
}
:is_pushed_down true
:outerjoin_delayed false
:can_join true
:pseudoconstant false
:clause_relids (b 1 2)
:required_relids (b 1 2)
:nullable_relids (b)
:left_relids (b 1)
:right_relids (b 2)
:orclause <>
:norm_selec 0.0000
:outer_selec -1.0000
:mergeopfamilies (o 1994 2095)
:left_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 1
:varattno 1
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 1
:varoattno 1
:location 69
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 1)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:right_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 2
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 2
:location 82
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 2)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:outer_is_left false
:hashjoinoperator 98
}
)
:num_batches 16
}
:innerjoinpath
{INDEXPATH
:pathtype 110
:parent_relids (b 3)
:startup_cost 0.00
:total_cost 0.42
:pathkeys <>
:indexinfo
{INDEXOPTINFO
:indexoid 16451
:pages 2008
:tuples 456520
:ncolumns 1
:relam 403
:indexprs <>
:indpred <>
:predOK false
:unique true
:immediate true
:hypothetical false
}
:indexclauses (
{RESTRICTINFO
:clause
{OPEXPR
:opno 98
:opfuncid 67
:opresulttype 16
:opretset false
:opcollid 0
:inputcollid 100
:args (
{RELABELTYPE
:arg
{VAR
:varno 3
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 3
:varoattno 1
:location 115
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 1
:location 99
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
)
:location -1
}
:is_pushed_down true
:outerjoin_delayed false
:can_join true
:pseudoconstant false
:clause_relids (b 2 3)
:required_relids (b 2 3)
:nullable_relids (b)
:left_relids (b 3)
:right_relids (b 2)
:orclause <>
:norm_selec -1.0000
:outer_selec -1.0000
:mergeopfamilies (o 1994 2095)
:left_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 3
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 3
:varoattno 1
:location 115
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 3)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:right_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 1
:location 99
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 2)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:outer_is_left false
:hashjoinoperator 98
}
)
:indexquals (
{RESTRICTINFO
:clause
{OPEXPR
:opno 98
:opfuncid 67
:opresulttype 16
:opretset false
:opcollid 0
:inputcollid 100
:args (
{RELABELTYPE
:arg
{VAR
:varno 3
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 3
:varoattno 1
:location 115
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 1
:location 99
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
)
:location -1
}
:is_pushed_down true
:outerjoin_delayed false
:can_join true
:pseudoconstant false
:clause_relids (b 2 3)
:required_relids (b 2 3)
:nullable_relids (b)
:left_relids (b 3)
:right_relids (b 2)
:orclause <>
:norm_selec -1.0000
:outer_selec -1.0000
:mergeopfamilies (o 1994 2095)
:left_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 3
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 3
:varoattno 1
:location 115
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 3)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:right_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 1
:location 99
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 2)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:outer_is_left false
:hashjoinoperator 98
}
)
:indexorderbys <>
:isjoininner true
:indexscandir 0
:indextotalcost 0.36
:indexselectivity 0.0000
:rows 1
}
:joinrestrictinfo (
{RESTRICTINFO
:clause
{OPEXPR
:opno 98
:opfuncid 67
:opresulttype 16
:opretset false
:opcollid 0
:inputcollid 100
:args (
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 1
:location 99
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
{RELABELTYPE
:arg
{VAR
:varno 3
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 3
:varoattno 1
:location 115
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
)
:location -1
}
:is_pushed_down true
:outerjoin_delayed false
:can_join true
:pseudoconstant false
:clause_relids (b 2 3)
:required_relids (b 2 3)
:nullable_relids (b)
:left_relids (b 2)
:right_relids (b 3)
:orclause <>
:norm_selec 0.0000
:outer_selec -1.0000
:mergeopfamilies (o 1994 2095)
:left_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 1
:location 99
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 2)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:right_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 3
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 3
:varoattno 1
:location 115
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 3)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:outer_is_left false
:hashjoinoperator 98
}
)
}
{NESTPATH
:pathtype 122
:parent_relids (b 1 2 3)
:startup_cost 0.00
:total_cost 360816.20
:pathkeys <>
:jointype 0
:outerjoinpath
{NESTPATH
:pathtype 122
:parent_relids (b 1 2)
:startup_cost 0.00
:total_cost 181532.34
:pathkeys <>
:jointype 0
:outerjoinpath
{PATH
:pathtype 109
:parent_relids (b 2)
:startup_cost 0.00
:total_cost 8758.87
:pathkeys <>
}
:innerjoinpath
{INDEXPATH
:pathtype 110
:parent_relids (b 1)
:startup_cost 0.00
:total_cost 0.40
:pathkeys <>
:indexinfo
{INDEXOPTINFO
:indexoid 16436
:pages 2469
:tuples 137343
:ncolumns 1
:relam 403
:indexprs <>
:indpred <>
:predOK false
:unique true
:immediate true
:hypothetical false
}
:indexclauses (
{RESTRICTINFO
:clause
{OPEXPR
:opno 98
:opfuncid 67
:opresulttype 16
:opretset false
:opcollid 0
:inputcollid 100
:args (
{RELABELTYPE
:arg
{VAR
:varno 1
:varattno 1
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 1
:varoattno 1
:location 69
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 2
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 2
:location 82
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
)
:location -1
}
:is_pushed_down true
:outerjoin_delayed false
:can_join true
:pseudoconstant false
:clause_relids (b 1 2)
:required_relids (b 1 2)
:nullable_relids (b)
:left_relids (b 1)
:right_relids (b 2)
:orclause <>
:norm_selec 0.0000
:outer_selec -1.0000
:mergeopfamilies (o 1994 2095)
:left_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 1
:varattno 1
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 1
:varoattno 1
:location 69
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 1)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:right_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 2
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 2
:location 82
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 2)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:outer_is_left false
:hashjoinoperator 98
}
)
:indexquals (
{RESTRICTINFO
:clause
{OPEXPR
:opno 98
:opfuncid 67
:opresulttype 16
:opretset false
:opcollid 0
:inputcollid 100
:args (
{RELABELTYPE
:arg
{VAR
:varno 1
:varattno 1
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 1
:varoattno 1
:location 69
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 2
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 2
:location 82
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
)
:location -1
}
:is_pushed_down true
:outerjoin_delayed false
:can_join true
:pseudoconstant false
:clause_relids (b 1 2)
:required_relids (b 1 2)
:nullable_relids (b)
:left_relids (b 1)
:right_relids (b 2)
:orclause <>
:norm_selec 0.0000
:outer_selec -1.0000
:mergeopfamilies (o 1994 2095)
:left_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 1
:varattno 1
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 1
:varoattno 1
:location 69
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 1)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:right_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 2
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 2
:location 82
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 2)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:outer_is_left false
:hashjoinoperator 98
}
)
:indexorderbys <>
:isjoininner true
:indexscandir 0
:indextotalcost 0.38
:indexselectivity 0.0000
:rows 1
}
:joinrestrictinfo (
{RESTRICTINFO
:clause
{OPEXPR
:opno 98
:opfuncid 67
:opresulttype 16
:opretset false
:opcollid 0
:inputcollid 100
:args (
{RELABELTYPE
:arg
{VAR
:varno 1
:varattno 1
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 1
:varoattno 1
:location 69
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 2
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 2
:location 82
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
)
:location -1
}
:is_pushed_down true
:outerjoin_delayed false
:can_join true
:pseudoconstant false
:clause_relids (b 1 2)
:required_relids (b 1 2)
:nullable_relids (b)
:left_relids (b 1)
:right_relids (b 2)
:orclause <>
:norm_selec 0.0000
:outer_selec -1.0000
:mergeopfamilies (o 1994 2095)
:left_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 1
:varattno 1
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 1
:varoattno 1
:location 69
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 1)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:right_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 2
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 2
:location 82
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 2)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:outer_is_left false
:hashjoinoperator 98
}
)
}
:innerjoinpath
{INDEXPATH
:pathtype 110
:parent_relids (b 3)
:startup_cost 0.00
:total_cost 0.42
:pathkeys <>
:indexinfo
{INDEXOPTINFO
:indexoid 16451
:pages 2008
:tuples 456520
:ncolumns 1
:relam 403
:indexprs <>
:indpred <>
:predOK false
:unique true
:immediate true
:hypothetical false
}
:indexclauses (
{RESTRICTINFO
:clause
{OPEXPR
:opno 98
:opfuncid 67
:opresulttype 16
:opretset false
:opcollid 0
:inputcollid 100
:args (
{RELABELTYPE
:arg
{VAR
:varno 3
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 3
:varoattno 1
:location 115
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 1
:location 99
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
)
:location -1
}
:is_pushed_down true
:outerjoin_delayed false
:can_join true
:pseudoconstant false
:clause_relids (b 2 3)
:required_relids (b 2 3)
:nullable_relids (b)
:left_relids (b 3)
:right_relids (b 2)
:orclause <>
:norm_selec -1.0000
:outer_selec -1.0000
:mergeopfamilies (o 1994 2095)
:left_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 3
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 3
:varoattno 1
:location 115
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 3)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:right_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 1
:location 99
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 2)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:outer_is_left false
:hashjoinoperator 98
}
)
:indexquals (
{RESTRICTINFO
:clause
{OPEXPR
:opno 98
:opfuncid 67
:opresulttype 16
:opretset false
:opcollid 0
:inputcollid 100
:args (
{RELABELTYPE
:arg
{VAR
:varno 3
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 3
:varoattno 1
:location 115
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 1
:location 99
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
)
:location -1
}
:is_pushed_down true
:outerjoin_delayed false
:can_join true
:pseudoconstant false
:clause_relids (b 2 3)
:required_relids (b 2 3)
:nullable_relids (b)
:left_relids (b 3)
:right_relids (b 2)
:orclause <>
:norm_selec -1.0000
:outer_selec -1.0000
:mergeopfamilies (o 1994 2095)
:left_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 3
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 3
:varoattno 1
:location 115
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 3)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:right_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 1
:location 99
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 2)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:outer_is_left false
:hashjoinoperator 98
}
)
:indexorderbys <>
:isjoininner true
:indexscandir 0
:indextotalcost 0.36
:indexselectivity 0.0000
:rows 1
}
:joinrestrictinfo (
{RESTRICTINFO
:clause
{OPEXPR
:opno 98
:opfuncid 67
:opresulttype 16
:opretset false
:opcollid 0
:inputcollid 100
:args (
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 1
:location 99
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
{RELABELTYPE
:arg
{VAR
:varno 3
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 3
:varoattno 1
:location 115
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
)
:location -1
}
:is_pushed_down true
:outerjoin_delayed false
:can_join true
:pseudoconstant false
:clause_relids (b 2 3)
:required_relids (b 2 3)
:nullable_relids (b)
:left_relids (b 2)
:right_relids (b 3)
:orclause <>
:norm_selec 0.0000
:outer_selec -1.0000
:mergeopfamilies (o 1994 2095)
:left_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 1
:location 99
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 2)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:right_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 3
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 3
:varoattno 1
:location 115
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 3)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:outer_is_left false
:hashjoinoperator 98
}
)
}
)
:cheapest_startup_path
{NESTPATH
:pathtype 122
:parent_relids (b 1 2 3)
:startup_cost 0.00
:total_cost 360816.20
:pathkeys <>
:jointype 0
:outerjoinpath
{NESTPATH
:pathtype 122
:parent_relids (b 1 2)
:startup_cost 0.00
:total_cost 181532.34
:pathkeys <>
:jointype 0
:outerjoinpath
{PATH
:pathtype 109
:parent_relids (b 2)
:startup_cost 0.00
:total_cost 8758.87
:pathkeys <>
}
:innerjoinpath
{INDEXPATH
:pathtype 110
:parent_relids (b 1)
:startup_cost 0.00
:total_cost 0.40
:pathkeys <>
:indexinfo
{INDEXOPTINFO
:indexoid 16436
:pages 2469
:tuples 137343
:ncolumns 1
:relam 403
:indexprs <>
:indpred <>
:predOK false
:unique true
:immediate true
:hypothetical false
}
:indexclauses (
{RESTRICTINFO
:clause
{OPEXPR
:opno 98
:opfuncid 67
:opresulttype 16
:opretset false
:opcollid 0
:inputcollid 100
:args (
{RELABELTYPE
:arg
{VAR
:varno 1
:varattno 1
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 1
:varoattno 1
:location 69
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 2
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 2
:location 82
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
)
:location -1
}
:is_pushed_down true
:outerjoin_delayed false
:can_join true
:pseudoconstant false
:clause_relids (b 1 2)
:required_relids (b 1 2)
:nullable_relids (b)
:left_relids (b 1)
:right_relids (b 2)
:orclause <>
:norm_selec 0.0000
:outer_selec -1.0000
:mergeopfamilies (o 1994 2095)
:left_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 1
:varattno 1
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 1
:varoattno 1
:location 69
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 1)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:right_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 2
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 2
:location 82
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 2)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:outer_is_left false
:hashjoinoperator 98
}
)
:indexquals (
{RESTRICTINFO
:clause
{OPEXPR
:opno 98
:opfuncid 67
:opresulttype 16
:opretset false
:opcollid 0
:inputcollid 100
:args (
{RELABELTYPE
:arg
{VAR
:varno 1
:varattno 1
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 1
:varoattno 1
:location 69
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 2
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 2
:location 82
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
)
:location -1
}
:is_pushed_down true
:outerjoin_delayed false
:can_join true
:pseudoconstant false
:clause_relids (b 1 2)
:required_relids (b 1 2)
:nullable_relids (b)
:left_relids (b 1)
:right_relids (b 2)
:orclause <>
:norm_selec 0.0000
:outer_selec -1.0000
:mergeopfamilies (o 1994 2095)
:left_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 1
:varattno 1
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 1
:varoattno 1
:location 69
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 1)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:right_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 2
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 2
:location 82
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 2)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:outer_is_left false
:hashjoinoperator 98
}
)
:indexorderbys <>
:isjoininner true
:indexscandir 0
:indextotalcost 0.38
:indexselectivity 0.0000
:rows 1
}
:joinrestrictinfo (
{RESTRICTINFO
:clause
{OPEXPR
:opno 98
:opfuncid 67
:opresulttype 16
:opretset false
:opcollid 0
:inputcollid 100
:args (
{RELABELTYPE
:arg
{VAR
:varno 1
:varattno 1
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 1
:varoattno 1
:location 69
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 2
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 2
:location 82
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
)
:location -1
}
:is_pushed_down true
:outerjoin_delayed false
:can_join true
:pseudoconstant false
:clause_relids (b 1 2)
:required_relids (b 1 2)
:nullable_relids (b)
:left_relids (b 1)
:right_relids (b 2)
:orclause <>
:norm_selec 0.0000
:outer_selec -1.0000
:mergeopfamilies (o 1994 2095)
:left_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 1
:varattno 1
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 1
:varoattno 1
:location 69
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 1)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:right_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 2
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 2
:location 82
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 2)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:outer_is_left false
:hashjoinoperator 98
}
)
}
:innerjoinpath
{INDEXPATH
:pathtype 110
:parent_relids (b 3)
:startup_cost 0.00
:total_cost 0.42
:pathkeys <>
:indexinfo
{INDEXOPTINFO
:indexoid 16451
:pages 2008
:tuples 456520
:ncolumns 1
:relam 403
:indexprs <>
:indpred <>
:predOK false
:unique true
:immediate true
:hypothetical false
}
:indexclauses (
{RESTRICTINFO
:clause
{OPEXPR
:opno 98
:opfuncid 67
:opresulttype 16
:opretset false
:opcollid 0
:inputcollid 100
:args (
{RELABELTYPE
:arg
{VAR
:varno 3
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 3
:varoattno 1
:location 115
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 1
:location 99
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
)
:location -1
}
:is_pushed_down true
:outerjoin_delayed false
:can_join true
:pseudoconstant false
:clause_relids (b 2 3)
:required_relids (b 2 3)
:nullable_relids (b)
:left_relids (b 3)
:right_relids (b 2)
:orclause <>
:norm_selec -1.0000
:outer_selec -1.0000
:mergeopfamilies (o 1994 2095)
:left_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 3
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 3
:varoattno 1
:location 115
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 3)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:right_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 1
:location 99
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 2)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:outer_is_left false
:hashjoinoperator 98
}
)
:indexquals (
{RESTRICTINFO
:clause
{OPEXPR
:opno 98
:opfuncid 67
:opresulttype 16
:opretset false
:opcollid 0
:inputcollid 100
:args (
{RELABELTYPE
:arg
{VAR
:varno 3
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 3
:varoattno 1
:location 115
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 1
:location 99
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
)
:location -1
}
:is_pushed_down true
:outerjoin_delayed false
:can_join true
:pseudoconstant false
:clause_relids (b 2 3)
:required_relids (b 2 3)
:nullable_relids (b)
:left_relids (b 3)
:right_relids (b 2)
:orclause <>
:norm_selec -1.0000
:outer_selec -1.0000
:mergeopfamilies (o 1994 2095)
:left_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 3
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 3
:varoattno 1
:location 115
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 3)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:right_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 1
:location 99
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 2)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:outer_is_left false
:hashjoinoperator 98
}
)
:indexorderbys <>
:isjoininner true
:indexscandir 0
:indextotalcost 0.36
:indexselectivity 0.0000
:rows 1
}
:joinrestrictinfo (
{RESTRICTINFO
:clause
{OPEXPR
:opno 98
:opfuncid 67
:opresulttype 16
:opretset false
:opcollid 0
:inputcollid 100
:args (
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 1
:location 99
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
{RELABELTYPE
:arg
{VAR
:varno 3
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 3
:varoattno 1
:location 115
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
)
:location -1
}
:is_pushed_down true
:outerjoin_delayed false
:can_join true
:pseudoconstant false
:clause_relids (b 2 3)
:required_relids (b 2 3)
:nullable_relids (b)
:left_relids (b 2)
:right_relids (b 3)
:orclause <>
:norm_selec 0.0000
:outer_selec -1.0000
:mergeopfamilies (o 1994 2095)
:left_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 1
:location 99
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 2)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:right_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 3
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 3
:varoattno 1
:location 115
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 3)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:outer_is_left false
:hashjoinoperator 98
}
)
}
:cheapest_total_path
{HASHPATH
:pathtype 124
:parent_relids (b 1 2 3)
:startup_cost 24390.42
:total_cost 80187.02
:pathkeys <>
:jointype 0
:outerjoinpath
{HASHPATH
:pathtype 124
:parent_relids (b 2 3)
:startup_cost 18386.21
:total_cost 50153.53
:pathkeys <>
:jointype 0
:outerjoinpath
{PATH
:pathtype 109
:parent_relids (b 3)
:startup_cost 0.00
:total_cost 10068.20
:pathkeys <>
}
:innerjoinpath
{PATH
:pathtype 109
:parent_relids (b 2)
:startup_cost 0.00
:total_cost 8758.87
:pathkeys <>
}
:joinrestrictinfo (
{RESTRICTINFO
:clause
{OPEXPR
:opno 98
:opfuncid 67
:opresulttype 16
:opretset false
:opcollid 0
:inputcollid 100
:args (
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 1
:location 99
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
{RELABELTYPE
:arg
{VAR
:varno 3
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 3
:varoattno 1
:location 115
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
)
:location -1
}
:is_pushed_down true
:outerjoin_delayed false
:can_join true
:pseudoconstant false
:clause_relids (b 2 3)
:required_relids (b 2 3)
:nullable_relids (b)
:left_relids (b 2)
:right_relids (b 3)
:orclause <>
:norm_selec 0.0000
:outer_selec -1.0000
:mergeopfamilies (o 1994 2095)
:left_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 1
:location 99
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 2)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:right_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 3
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 3
:varoattno 1
:location 115
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 3)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:outer_is_left false
:hashjoinoperator 98
}
)
:path_hashclauses (
{RESTRICTINFO
:clause
{OPEXPR
:opno 98
:opfuncid 67
:opresulttype 16
:opretset false
:opcollid 0
:inputcollid 100
:args (
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 1
:location 99
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
{RELABELTYPE
:arg
{VAR
:varno 3
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 3
:varoattno 1
:location 115
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
)
:location -1
}
:is_pushed_down true
:outerjoin_delayed false
:can_join true
:pseudoconstant false
:clause_relids (b 2 3)
:required_relids (b 2 3)
:nullable_relids (b)
:left_relids (b 2)
:right_relids (b 3)
:orclause <>
:norm_selec 0.0000
:outer_selec -1.0000
:mergeopfamilies (o 1994 2095)
:left_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 1
:location 99
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 2)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:right_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 3
:varattno 1
:vartype 1043
:vartypmod 104
:varcollid 100
:varlevelsup 0
:varnoold 3
:varoattno 1
:location 115
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 3)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:outer_is_left false
:hashjoinoperator 98
}
)
:num_batches 64
}
:innerjoinpath
{PATH
:pathtype 109
:parent_relids (b 1)
:startup_cost 0.00
:total_cost 2878.43
:pathkeys <>
}
:joinrestrictinfo (
{RESTRICTINFO
:clause
{OPEXPR
:opno 98
:opfuncid 67
:opresulttype 16
:opretset false
:opcollid 0
:inputcollid 100
:args (
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 2
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 2
:location 82
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
{RELABELTYPE
:arg
{VAR
:varno 1
:varattno 1
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 1
:varoattno 1
:location 69
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
)
:location -1
}
:is_pushed_down true
:outerjoin_delayed false
:can_join true
:pseudoconstant false
:clause_relids (b 1 2)
:required_relids (b 1 2)
:nullable_relids (b)
:left_relids (b 2)
:right_relids (b 1)
:orclause <>
:norm_selec 0.0000
:outer_selec -1.0000
:mergeopfamilies (o 1994 2095)
:left_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 2
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 2
:location 82
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 2)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:right_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 1
:varattno 1
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 1
:varoattno 1
:location 69
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 1)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:outer_is_left false
:hashjoinoperator 98
}
)
:path_hashclauses (
{RESTRICTINFO
:clause
{OPEXPR
:opno 98
:opfuncid 67
:opresulttype 16
:opretset false
:opcollid 0
:inputcollid 100
:args (
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 2
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 2
:location 82
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
{RELABELTYPE
:arg
{VAR
:varno 1
:varattno 1
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 1
:varoattno 1
:location 69
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
)
:location -1
}
:is_pushed_down true
:outerjoin_delayed false
:can_join true
:pseudoconstant false
:clause_relids (b 1 2)
:required_relids (b 1 2)
:nullable_relids (b)
:left_relids (b 2)
:right_relids (b 1)
:orclause <>
:norm_selec 0.0000
:outer_selec -1.0000
:mergeopfamilies (o 1994 2095)
:left_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 2
:varattno 2
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 2
:varoattno 2
:location 82
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 2)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:right_em
{EQUIVALENCEMEMBER
:em_expr
{RELABELTYPE
:arg
{VAR
:varno 1
:varattno 1
:vartype 1043
:vartypmod 504
:varcollid 100
:varlevelsup 0
:varnoold 1
:varoattno 1
:location 69
}
:resulttype 25
:resulttypmod -1
:resultcollid 100
:relabelformat 2
:location -1
}
:em_relids (b 1)
:em_is_const false
:em_is_child false
:em_datatype 25
}
:outer_is_left false
:hashjoinoperator 98
}
)
:num_batches 16
}
:cheapest_unique_path <>
:relid 0
:reltablespace 0
:rtekind 2
:min_attr 0
:max_attr 0
:indexlist <>
:pages 0
:tuples 0
:subplan <>
:subrtable <>
:subrowmark <>
:baserestrictinfo <>
:joininfo <>
:has_eclass_joins false
:index_outer_relids (b)
:index_inner_paths <>
}