# stop_profile

> Stop connection lock profiling and output the connections' states.

> ### For an overview see page eXtremeSQL Functions

> ### Prototype

>         stop_profile(rate_usec);

> ### Arguments

> void | No arguments

> ### Description

> > This function stops connection lock profiling and displays the values of the counters collected by the profiler which consists of the following columns:

> > - `percent`: percentage of hits for the given lock
> > - `hits`: hit counter for the lock (the number of times the profiler thread detected a connection waiting on this lock)
> > - `event`: wait event (aka the identifier of the lock)

> ### Example

> See page Connection Lock Profiling for an example of usage.