verticapy.performance.vertica.qprof.QueryProfiler.get_qexecution_report#

QueryProfiler.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()

	Abc node_name Varchar(128)	Abc operator_name Varchar(128)	123 path_id Integer	123 exec_time_ms Numeric(38)	123 est_rows Integer	123 proc_rows Integer	123 prod_rows Integer	123 rle_prod_rows Integer	123 cstall_us Integer	123 pstall_us Integer	123 clock_time_us Integer	123 mem_res_mb Numeric(38)	123 mem_all_mb Numeric(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: 13

Note

For more details, please look at QueryProfiler.