Enable SQL Logging (Server-Side and Client-Side)

[franz1981]

As a performance engineer, I need visibility into the SQL operations performed by different frameworks at both the client and database server levels.

Purpose:

• Verify parity across frameworks in terms of:
  • Round-trip time (RTT)
  • Query types and patterns for tuned profiles
• Validate that frameworks execute queries in a 1:1 manner
• Reduce manual debugging effort currently required for this analysis

Current State:
We typically need to manually debug to understand the SQL behavior, which is time-consuming and inefficient.

Desired Outcome:
Enable comprehensive SQL logging that captures both:

• Client-side SQL operations (application framework level)
• Server-side SQL operations (DBMS level)

Note: This logging should be available during integration tests or shorter versions of load tests, not just full-scale performance tests.

cc @Sanne

[edeandrea]

This should already be available via the --jvm-args parameter? You can set whatever parameters you'd like. If the property is Quarkus build-time, there's --quarkus-build-config-args.

[franz1981]

Thanks @edeandrea : it seems fine for manual checking, but it is not for automatic checks (which we have not in place yet)

[franz1981]

FYI @edeandrea and @diegolovison franz1981@0a6a88c

[franz1981]

@edeandrea @holly-cummins i think that validating and documenting per each scenario the expected DBMS ops/RTT would improve transparency of our benchmark 🙏

eg
Tuned scenario
First request (cold cache):

• 1 query: SELECT all fruits (10 rows)
• 1 query: Batched SELECT of store_fruit_prices (using batch size of 16)
• 1 query: Batched SELECT of stores (using batch size of 16)

Total RTTs: ~3 (thanks to batch fetching)

Subsequent requests (warm cache):

• save the batched select of stores

Total RTTs: ~2 (cache hit scenario)

This seems good in particular for the tuned case as each framework try hard to have comparable behaviors; in ootb we are at the mercy of frameworks default (like many people would see...)