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_us 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)	123 bytes_spilled Integer
1	v_demo_node0001	TopK	1	95.076	9999	[null]	10	10	[null]	[null]	71803	0.8	[null]	[null]
2	v_demo_node0001	Join	3	889.985	9999	[null]	95368	95368	[null]	[null]	1055960	[null]	[null]	[null]
3	v_demo_node0001	ExprEval	2	413.115	9999	[null]	95368	95368	[null]	[null]	458930	2.2	[null]	[null]
4	v_demo_node0001	Scan	4	11.628	9999	109494	95368	95368	[null]	[null]	12046	0.0	[null]	[null]
5	v_demo_node0001	Scan	5	131.469	9997	752791	752791	752791	[null]	[null]	140804	0.0	[null]	[null]
6	v_demo_node0001	ExprEval	0	0.018	10	[null]	10	10	[null]	[null]	17	0.1	[null]	[null]
7	v_demo_node0001	TopK	0	0.017	10	[null]	10	10	[null]	[null]	18	0.1	[null]	[null]
8	v_demo_node0001	StorageUnion	3	1359.63	[null]	[null]	95368	95368	[null]	[null]	[null]	8.4	[null]	[null]
9	v_demo_node0001	NewEENode	-1	0.082	[null]	[null]	10	10	[null]	[null]	83	0.4	[null]	[null]
10	v_demo_node0001	Root	-1	0.059	[null]	[null]	10	[null]	[null]	[null]	60	[null]	[null]	[null]
11	v_demo_node0001	ExprEval	1	148.686	[null]	[null]	95368	95368	[null]	[null]	149094	0.1	[null]	[null]
12	v_demo_node0001	StorageUnion	5	415.8	[null]	[null]	752791	752791	[null]	[null]	[null]	4.7	[null]	[null]

Rows: 1-12 | Columns: 14

Note

For more details, please look at QueryProfiler.