30840585152
78%

Ran 03 Aug 2026 06:45PM UTC

Jobs 1

Files 128

Run time 1min

Badge

Embed ▾

Committed 03 Aug 2026 06:17PM UTC coverage: 77.583% (-0.06%) from 77.644%

Build # 30840585152

Build Type

push

github

Committed by

web-flow

Commit Message

Remove redundant atthasdef filter to fix cardinality misestimate (#4925)

The atthasdef predicate in the Default Constraints branch of
sys.all_objects and sys.default_constraints is redundant because the
pg_attrdef join already guarantees atthasdef is true for every joined
row. However, its presence causes the planner to apply the global
frequency of atthasdef being true (a small fraction on pg_attribute)
instead of the true 100 percent post-join selectivity. This produces
a roughly 400x cardinality underestimate which, compounded by the
has_column_privilege default selectivity, triggers catastrophic Merge
Join choices with hundreds of millions of rows filtered on PG 17.x
with 500+ namespaces.

Removing the filter lets the planner see the correct post-join
cardinality, choosing Nested Loop over Merge Join and eliminating
the pathological execution path (22 to 36x improvement on PG 17.x
with 576 namespaces).

Task: BABEL-6458

Author: Rucha Kulkarni <ruchask@amazon.com>

Coverage Stats

55985 of 72161 relevant lines covered (77.58%)

596474.91 hits per line

Coverage Regressions

Lines	Coverage	∆	File
16	17.86	-57.14%	contrib/babelfishpg_tsql/src/pltsql_node/pltsql_node_macros.h
14	85.63	-0.38%	contrib/babelfishpg_tsql/src/hooks.c
10	0.0	-13.16%	contrib/babelfishpg_tsql/src/pltsql_node/pltsql_equalfuncs.c
2	90.31	-0.06%	contrib/babelfishpg_tsql/src/pl_handler.c
2	50.29	-0.88%	contrib/babelfishpg_tsql/src/pltsql_node/pltsql_nodeio.c

Jobs

ID	Job ID	Ran	Files	Coverage
1	30840585152.1	03 Aug 2026 06:45PM UTC	128	77.58	GitHub Action Run

babelfish-for-postgresql / babelfish_extensions / 30840585152
78%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Coverage Regressions

Jobs

Source Files on build 30840585152

babelfish-for-postgresql / babelfish_extensions / 30840585152 78%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Coverage Regressions

Jobs

Source Files on build 30840585152

babelfish-for-postgresql / babelfish_extensions / 30840585152
78%

README BADGES
x