12346366672
76%
BABEL_5_X_DEV: 77%

Ran 16 Dec 2024 05:47AM UTC

Jobs 1

Files 115

Run time 1min

Badge

Embed ▾

Committed 16 Dec 2024 05:13AM UTC coverage: 74.832%. Remained the same

Build # 12346366672

Build Type

push

github

Committed by

web-flow

Commit Message

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

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.

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

Issues Resolved
Task: BABEL-5427

Run Details

46511 of 62154 relevant lines covered (74.83%)

164474.22 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
1	12346366672.1	16 Dec 2024 05:47AM UTC	115	74.83	GitHub Action Run

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

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 12346366672

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

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 12346366672

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

README BADGES
x