24097003023
76%
BABEL_5_X_DEV: 77%

Ran 07 Apr 2026 06:48PM UTC

Jobs 1

Files 120

Run time 1min

Badge

Embed ▾

Committed 07 Apr 2026 06:11PM UTC coverage: 76.325% (+0.003%) from 76.322%

Build # 24097003023

Build Type

push

github

Committed by

web-flow

Commit Message

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

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
Cherry-picked from #4683

Authored-by: Rucha Kulkarni ruchask@amazon.com

Coverage Stats

50792 of 66547 relevant lines covered (76.33%)

397753.67 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
1	24097003023.1	07 Apr 2026 06:48PM UTC	120	76.33	GitHub Action Run

babelfish-for-postgresql / babelfish_extensions / 24097003023
76%
BABEL_5_X_DEV: 77%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 24097003023

babelfish-for-postgresql / babelfish_extensions / 24097003023 76% BABEL_5_X_DEV: 77%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 24097003023

babelfish-for-postgresql / babelfish_extensions / 24097003023
76%
BABEL_5_X_DEV: 77%

README BADGES
x