11098641587
74%
BABEL_5_X_DEV: 77%

Ran 30 Sep 2024 03:43AM UTC

Jobs 1

Files 114

Run time 1min

Badge

Embed ▾

Committed 30 Sep 2024 03:06AM UTC coverage: 73.685%. Remained the same

Build # 11098641587

Build Type

push

github

Committed by

web-flow

Commit Message

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

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

42819 of 58111 relevant lines covered (73.68%)

143593.88 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
1	11098641587.1	30 Sep 2024 03:43AM UTC	114	73.68	GitHub Action Run

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

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 11098641587

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

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 11098641587

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

README BADGES
x