verticapy.performance.vertica.qprof_interface.QueryProfilerInterface.get_qexecution_report#
- QueryProfilerInterface.get_qexecution_report() vDataFrame #
Returns the Query execution report.
Returns#
- vDataFrame
report.
Examples#
First, let’s import the
QueryProfiler
object.from verticapy.performance.vertica import QueryProfiler
Then we can create a query:
qprof = QueryProfiler( "select transaction_id, statement_id, request, request_duration" " from query_requests where start_timestamp > now() - interval'1 hour'" " order by request_duration desc limit 10;" )
To get the complete execution report use:
qprof.get_qexecution_report()
Abcnode_nameVarchar(128)Abcoperator_nameVarchar(128)123path_idInteger123exec_time_msNumeric(38)123est_rowsInteger123proc_rowsInteger123prod_rowsInteger123rle_prod_rowsInteger123cstall_usInteger123pstall_usInteger123clock_time_usInteger123mem_res_mbNumeric(38)123mem_all_mbNumeric(38)1 v_demo_node0001 TopK 1 73.041 9999 [null] 10 10 [null] [null] 55110 0.8 [null] 2 v_demo_node0001 Scan 4 10.289 9999 77198 71057 71057 [null] [null] 10746 0.0 [null] 3 v_demo_node0001 Join 3 827.288 9999 [null] 71057 71057 [null] [null] 986868 [null] [null] 4 v_demo_node0001 ExprEval 2 335.353 9999 [null] 71057 71057 [null] [null] 336539 2.2 [null] 5 v_demo_node0001 Scan 5 133.939 9997 763106 763106 763106 [null] [null] 143072 0.0 [null] 6 v_demo_node0001 TopK 0 0.02 10 [null] 10 10 [null] [null] 21 0.1 [null] 7 v_demo_node0001 ExprEval 0 0.028 10 [null] 10 10 [null] [null] 29 0.1 [null] 8 v_demo_node0001 ExprEval 1 116.203 [null] [null] 71057 71057 [null] [null] 116398 0.1 [null] 9 v_demo_node0001 StorageUnion 5 413.575 [null] [null] 763106 763106 [null] [null] [null] 4.7 [null] 10 v_demo_node0001 NewEENode -1 0.093 [null] [null] 10 10 [null] [null] 93 0.4 [null] 11 v_demo_node0001 StorageUnion 3 1075.972 [null] [null] 71057 71057 [null] [null] [null] 8.4 [null] 12 v_demo_node0001 Root -1 0.059 [null] [null] 10 [null] [null] [null] 59 [null] [null] Rows: 1-12 | Columns: 13Note
For more details, please look at
QueryProfiler
.