Profiling with DTRACE (MacOS / FreeBSD)

Prerequisites:

• DTrace
• rustfilt

1. Start SurrealDB

Build Surreal with the bench profile (preserving symbols).

cargo run --profile bench --features=storage-mem -- start --user root --pass root memory

2. Start profiling

Run the profiler.

./profiling/profile.sh

3. Do some operation

You may want to use Surrealist, or a bench to generate some load.

Eg. from benchmarking/crud-bench:

cargo run -r -- -d surrealdb -s 1000 -t 2

3. Stop profiling

Press Ctrl+D to stop SurrealDB and display the profiling results.

4. Check the results

The results are stored in the target/profiling directory.

profile.out

The raw output of dtrace

profile.txt

The output of dtrace with demangled function names.

Each line corresponds to a function and includes the following columns:

1. Function name
2. Average CPU time (excluding child execution)
3. Total CPU time (sum of average CPU time for all calls)
4. Average time (including child execution)
5. Total time (sum of average time for all calls)
6. Count: the number of times the function was called

profile_avg_cpu_time.txt

Function sorted by descending average CPU time.

Each line is a function, with the following columns:

1. Average CPU time
2. Count
3. Function name

profile_total_cpu_time.txt

Function sorted by descending total CPU time.

Each line includes the following columns:

1. Total CPU time
2. Count
3. Function name