11072071451
76%
BABEL_5_X_DEV: 77%

Ran 27 Sep 2024 02:36PM UTC

Jobs 1

Files 115

Run time 1min

Badge

Embed ▾

Committed 27 Sep 2024 02:02PM UTC coverage: 74.448%. Remained the same

Build # 11072071451

Build Type

push

github

Committed by

web-flow

Commit Message

Performance improvements when query includes sys.indexes.is_primary_key predicate  (#2917)

Previously for a query we were observing a performance degradation when it included a join between sys.indexes, sys.index_columns, sys.columns, sys.tables, and sys.schemas views with sys.indexes.is_primary_key = 1 predicate in where clause. We identified that there was the issue with a case statement due to which there was an incorrect row estimation so we have implemented a direct cast by defining new IMPLICIT cast without function from boolean to sys.bit.
Another issue was the use of redundant has_schema_privilege in sys views and functions, as we explicitly grant usage to public beforehand, so we have removed the redundant has_schema_privilege check.

Issues Resolved: BABEL-5215

Signed-off-by: Tanya Gupta <tanyagp@amazon.com>

Run Details

44933 of 60355 relevant lines covered (74.45%)

162291.84 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
1	11072071451.1	27 Sep 2024 02:36PM UTC	115	74.45	GitHub Action Run

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

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 11072071451

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

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 11072071451

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

README BADGES
x