12367047768
74%
BABEL_5_X_DEV: 77%

Ran 17 Dec 2024 06:09AM UTC

Jobs 1

Files 114

Run time 1min

Badge

Embed ▾

Committed 17 Dec 2024 05:35AM UTC coverage: 73.783% (+0.003%) from 73.78%

Build # 12367047768

Build Type

push

github

Committed by

web-flow

Commit Message

Performance improvement for queries having join between TABLE_CONSTRAINTS and KEY_COLUMN_USAGE views (#3257)

This commit addresses poor performance issues in queries that join the TABLE_CONSTRAINTS and KEY_COLUMN_USAGE views. The problem was caused by inaccurate row estimates resulting from a CASE expression in the TABLE_CONSTRAINTS view, leading to suboptimal query plans.

Task: BABEL-5427

Cherry-picked from db85d7e.

Signed-off-by: Sumit Jaiswal <sumiji@amazon.com>

Run Details

43105 of 58421 relevant lines covered (73.78%)

147508.9 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
1	12367047768.1	17 Dec 2024 06:09AM UTC	114	73.78	GitHub Action Run

babelfish-for-postgresql / babelfish_extensions / 12367047768
74%
BABEL_5_X_DEV: 77%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 12367047768

babelfish-for-postgresql / babelfish_extensions / 12367047768 74% BABEL_5_X_DEV: 77%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 12367047768

babelfish-for-postgresql / babelfish_extensions / 12367047768
74%
BABEL_5_X_DEV: 77%

README BADGES
x