verticapy.performance.vertica.qprof_interface.QueryProfilerInterface.exec_time_test¶
- QueryProfilerInterface.exec_time_test()¶
Checks if the parser of the SQL is taking too much time. PreparePlan, CompilePlan should be under the second and ExecutePlan should take most of the time.
Note
If Vertica is taking too much time to parse the query, something wrong: one example could be that the logging parameter causing to spend a lot of time to parse the data. It can be due to a system parameter.
Returns¶
- tuple
(exec time, total time, ratio).