verticapy.performance.vertica.qprof_interface.QueryProfilerInterface.clock_exec_time_test¶

QueryProfilerInterface.clock_exec_time_test()¶

This test can be used to check if the execution time is near to the clock time.

If the clock time is much greater than the execution time, it means that the thread has been in a wait state for some time, waiting for something.

Note

The tables’ columns are the following:

node_name, operator_name, path_id, clock_time_us, exec_time_us, ratio

A ratio greater than 20% can be seen as critical.

Returns¶

list of list