12367055022
77%

Ran 17 Dec 2024 06:09AM UTC

Jobs 1

Files 115

Run time 1min

Badge

Embed ▾

Committed 17 Dec 2024 05:36AM UTC coverage: 74.822%. Remained the same

Build # 12367055022

Build Type

push

github

Committed by

web-flow

Commit Message

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

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

46437 of 62063 relevant lines covered (74.82%)

163919.34 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
1	12367055022.1	17 Dec 2024 06:09AM UTC	115	74.82	GitHub Action Run

babelfish-for-postgresql / babelfish_extensions / 12367055022
77%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 12367055022

babelfish-for-postgresql / babelfish_extensions / 12367055022 77%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 12367055022

babelfish-for-postgresql / babelfish_extensions / 12367055022
77%

README BADGES
x