23634975786
77%

Ran 27 Mar 2026 07:33AM UTC

Jobs 1

Files 121

Run time 1min

Badge

Embed ▾

Committed 27 Mar 2026 06:54AM UTC coverage: 77.056% (-0.001%) from 77.057%

Build # 23634975786

Build Type

push

github

Committed by

web-flow

Commit Message

Materialize table_types_internal as CTE in sys.all_objects to prevent view inlining (#4683)

The sys.all_objects view joins against sys.table_types_internal to exclude table types from the user table
branches. Because table_types_internal is a plain view, the planner inlines its definition (a 4-way join across
pg_type, pg_namespace, pg_class, pg_depend) and re-executes it per row inside a nested loop, causing
significant performance degradation.

This change wraps table_types_internal in a materialized CTE inside sys.all_objects so it is computed once and
reused.

Task: BABEL-6404
Signed-off-by: Rucha Kulkarni <ruchask@amazon.com>

Run Details

52989 of 68767 relevant lines covered (77.06%)

405732.84 hits per line

Uncovered Existing Lines

Lines	Coverage	∆	File
1	79.23	-0.2%	contrib/babelfishpg_tds/src/backend/tds/tdsutils.c

Jobs

ID	Job ID	Ran	Files	Coverage
1	23634975786.1	27 Mar 2026 07:33AM UTC	121	77.06	GitHub Action Run

babelfish-for-postgresql / babelfish_extensions / 23634975786
77%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Uncovered Existing Lines

Jobs

Source Files on build 23634975786

babelfish-for-postgresql / babelfish_extensions / 23634975786 77%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Uncovered Existing Lines

Jobs

Source Files on build 23634975786

babelfish-for-postgresql / babelfish_extensions / 23634975786
77%

README BADGES
x