supabase / supautils

88%

LAST BUILD ON BRANCH master

branch: master

CHANGE BRANCH

x

Reset

Sync Branches

• master
• 140-bk
• 18beta1
• add-hint
• bench
• bs/clang-format
• bs/release-deb
• cache-lookup
• cassert
• chore/bump-xpg
• chore/ci
• chore/ci-again
• chore/ci-bundling
• chore/clang-format-macos-compat
• chore/macos-ci-pg-versions
• chore/readme-update-commands
• chore/upload-tar-xz
• compat16
• cov
• docs/supautils-prefix
• etienne/block-copy-program
• event_trigger_function_owner_check
• evtrig-test
• evtrigs-cont
• fix-docs
• fix-pgxs
• fix/handle-exceptions-during-su-switch
• fix/redefine-disable-program
• fix/run-custom-scripts-on-non-privileged-extensions
• immutable-check-constraint
• log-detail
• log-skipped
• macos
• make_superuser_boolean
• module-magic-ext
• nickb/fix_supautils_hook
• nxpg-v2
• pgmq
• ref-alterowner
• ref-extensions
• ref1
• revert-disable-copy
• style-fix-macos
• superevtrigs
• test/custom-scripts-non-privileged-ext
• upgrade-github-actions-node24
• upgrade-github-actions-node24-general

Build # 22863736634

Build Type

push

github

Committed by steve-chavez

Commit Message

test: loadtest for supautils utility statements

Adds a `supautils-loadtest` command, which when run it gives the
following results.

```
Results without supautils:

pgbench (17.0)
transaction type: ./bench/utility.sql
...
tps = 55.967835 (without initial connection time)

Results with supautils and superuser:

pgbench (17.0)
transaction type: ./bench/utility.sql
...
tps = 55.389345 (without initial connection time)

Results with supautils and privileged_role:

pgbench (17.0)
transaction type: ./bench/utility.sql
...
tps = 56.070317 (without initial connection time)
```

It uses pgbench and the newly added bench/utility.sql, which exercises
the utility statements for which the supautils hook runs.

This also runs on CI, so regressions can be detected.

Run Details

1010 of 1142 relevant lines covered (88.44%)

32.19 hits per line