20437915388
76%
BABEL_5_X_DEV: 77%

Ran 22 Dec 2025 05:07PM UTC

Jobs 1

Files 120

Run time 1min

Badge

Embed ▾

Committed 22 Dec 2025 04:32PM UTC coverage: 76.179% (+0.001%) from 76.178%

Build # 20437915388

Build Type

push

github

Committed by

web-flow

Commit Message

Redefining SP_DATATYPE_INFO and SP_DATATYPE_INFO_100 Procedures via View (#4309) (#4340)

Babelfish exhibits high CPU consumption during concurrent connection establishment. Investigation reveals this is due to ANTLR parsing overhead. PyODBC connections call sp_datatype_info_100 during connection setup, causing CPU spikes from intensive ANTLR parsing.

Hence we are defining sp_datatype_info and sp_datatype_info_100 to use pre-compiled views instead of directly calling the C helper function. Views are cached and avoid repeated ANTLR parsing, resulting in lower CPU utilization during connection establishment.

We observed performance improvement as below with this view approach:

No. of Concurrent Connections	Current CPU usage with PyODBC	CPU usage after this View Approach	CPU Reduction
100	9.83%	6.72%	3.11%
200	18.51%	11.91%	6.60%
400	31.75%	20.79%	10.96%
600	44.56%	27.22%	17.34%
800	56.35%	21.96%	34.39%

Issues Resolved
Cherry-pick from #4309
BABEL-6184

Authored-by: Rucha Kulkarni ruchask@amazon.com

Run Details

50427 of 66195 relevant lines covered (76.18%)

394512.53 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
1	20437915388.1	22 Dec 2025 05:07PM UTC	120	76.18	GitHub Action Run

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

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 20437915388

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

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 20437915388

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

README BADGES
x