23634879219
77%
BABEL_5_X_DEV: 77%

Ran 27 Mar 2026 07:33AM UTC

Jobs 1

Files 121

Run time 1min

Badge

Embed ▾

Committed 27 Mar 2026 06:51AM UTC coverage: 77.07%. Remained the same

Build # 23634879219

Build Type

push

github

Committed by

web-flow

Commit Message

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

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

53045 of 68827 relevant lines covered (77.07%)

621803.12 hits per line

Jobs

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

babelfish-for-postgresql / babelfish_extensions / 23634879219
77%
BABEL_5_X_DEV: 77%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 23634879219

babelfish-for-postgresql / babelfish_extensions / 23634879219 77% BABEL_5_X_DEV: 77%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 23634879219

babelfish-for-postgresql / babelfish_extensions / 23634879219
77%
BABEL_5_X_DEV: 77%

README BADGES
x