verticapy.performance.vertica.qprof_interface.QueryProfilerInterface.get_activity_time¶

QueryProfilerInterface.get_activity_time() → vDataFrame¶

Returns the a report including: Elapsed, exec_time and I/O by node, activity & path_id.

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 report use:

qprof.get_activity_time()

	Abc node_name Varchar(128)	123 path_id Integer	Abc activity Varchar(1024)	Abc abl_id Varchar(62)	123 elaps_us Integer	123 exec_us Integer	Abc Varchar(1024)	123 input_rows Integer	123 input_mb Numeric(38)	123 proc_rows Integer	123 proc_mb Numeric(38)
1	v_mldb_node0002	1	Unused	1008,7,3	3	15		[null]	[null]	[null]	[null]
2	v_mldb_node0002	1	TopK HEAP	1009,6,2	1	34		[null]	[null]	[null]	[null]
3	v_mldb_node0002	1	Emit TopK	1010,6,2	[null]	[null]		[null]	[null]	[null]	[null]
4	v_mldb_node0002	1	Send Data	1011,5,1	[null]	[null]		[null]	[null]	[null]	[null]
5	v_mldb_node0002	2	Evaluate Expressions	1006,9,5	18	12		[null]	[null]	[null]	[null]
6	v_mldb_node0002	3	Build Join Inner	1004,10,6	23	[null]		[null]	[null]	[null]	[null]
7	v_mldb_node0002	3	Join (hash)	1005,10,6	24	95		[null]	[null]	[null]	[null]
8	v_mldb_node0002	3	Combine Storage Chunks	1007,8,4	[null]	58		0	[null]	[null]	[null]
9	v_mldb_node0002	3	reserveVTLoaderResources	1015,8,4	[null]	[null]		[null]	[null]	[null]	[null]
10	v_mldb_node0002	4	Scan Projection	1003,11,7	25	14		[null]	[null]	0	[null]
11	v_mldb_node0002	5	Scan Projection	1001,13,9	16	9		[null]	[null]	0	[null]
12	v_mldb_node0002	5	Combine Storage Chunks	1002,12,8	[null]	67		0	[null]	[null]	[null]
13	v_mldb_node0002	5	reserveVTLoaderResources	1016,12,8	[null]	[null]		[null]	[null]	[null]	[null]
14	v_mldb_node0004	1	Unused	1008,7,3	3	12		[null]	[null]	[null]	[null]
15	v_mldb_node0004	1	TopK HEAP	1009,6,2	1	30		[null]	[null]	[null]	[null]
16	v_mldb_node0004	1	Emit TopK	1010,6,2	[null]	[null]		[null]	[null]	[null]	[null]
17	v_mldb_node0004	1	Send Data	1011,5,1	[null]	[null]		[null]	[null]	[null]	[null]
18	v_mldb_node0004	2	Evaluate Expressions	1006,9,5	21	12		[null]	[null]	[null]	[null]
19	v_mldb_node0004	3	Build Join Inner	1004,10,6	30	[null]		[null]	[null]	[null]	[null]
20	v_mldb_node0004	3	Join (hash)	1005,10,6	27	127		[null]	[null]	[null]	[null]
21	v_mldb_node0004	3	Combine Storage Chunks	1007,8,4	[null]	55		0	[null]	[null]	[null]
22	v_mldb_node0004	3	reserveVTLoaderResources	1015,8,4	[null]	[null]		[null]	[null]	[null]	[null]
23	v_mldb_node0004	4	Scan Projection	1003,11,7	27	14		[null]	[null]	0	[null]
24	v_mldb_node0004	5	Scan Projection	1001,13,9	17	10		[null]	[null]	0	[null]
25	v_mldb_node0004	5	Combine Storage Chunks	1002,12,8	[null]	64		0	[null]	[null]	[null]
26	v_mldb_node0004	5	reserveVTLoaderResources	1016,12,8	[null]	[null]		[null]	[null]	[null]	[null]
27	v_mldb_node0001	-1	Send Data to Client	1000,0,0	496	95		[null]	[null]	[null]	[null]
28	v_mldb_node0001	0	Unused	1013,3,3	477	40		[null]	[null]	[null]	[null]
29	v_mldb_node0001	0	TopK	1014,2,2	475	56		[null]	[null]	[null]	[null]
30	v_mldb_node0001	1	Unused	1008,7,7	1075785	112161		[null]	[null]	[null]	[null]
31	v_mldb_node0001	1	TopK HEAP	1009,6,6	1075782	68538		[null]	[null]	[null]	[null]
32	v_mldb_node0001	1	Emit TopK	1010,6,6	596	[null]		[null]	[null]	[null]	[null]
33	v_mldb_node0001	1	Send Data	1011,5,5	[null]	[null]		[null]	[null]	[null]	[null]
34	v_mldb_node0001	1	Receive Data	1012,4,4	[null]	[null]		[null]	[null]	[null]	[null]
35	v_mldb_node0001	2	Evaluate Expressions	1006,9,9	1075849	220365		[null]	[null]	[null]	[null]
36	v_mldb_node0001	3	Build Join Inner	1004,10,10	1865488	[null]		[null]	[null]	[null]	[null]
37	v_mldb_node0001	3	Join (hash)	1005,10,10	1075989	1024494		[null]	[null]	[null]	[null]
38	v_mldb_node0001	3	Combine Storage Chunks	1007,8,8	1075789	307978		0	[null]	[null]	[null]
39	v_mldb_node0001	3	reserveVTLoaderResources	1015,8,8	[null]	[null]		[null]	[null]	[null]	[null]
40	v_mldb_node0001	4	Scan Projection	1003,11,11	1076032	5941		[null]	[null]	35014	[null]
41	v_mldb_node0001	5	Scan Projection	1001,13,13	637519	183262		[null]	[null]	694456	[null]
42	v_mldb_node0001	5	Combine Storage Chunks	1002,12,12	637452	377946		0	[null]	[null]	[null]
43	v_mldb_node0001	5	reserveVTLoaderResources	1016,12,12	[null]	[null]		[null]	[null]	[null]	[null]
44	v_mldb_node0003	1	Unused	1008,7,3	6	31		[null]	[null]	[null]	[null]
45	v_mldb_node0003	1	TopK HEAP	1009,6,2	3	76		[null]	[null]	[null]	[null]
46	v_mldb_node0003	1	Emit TopK	1010,6,2	[null]	[null]		[null]	[null]	[null]	[null]
47	v_mldb_node0003	1	Send Data	1011,5,1	[null]	[null]		[null]	[null]	[null]	[null]
48	v_mldb_node0003	2	Evaluate Expressions	1006,9,5	45	31		[null]	[null]	[null]	[null]
49	v_mldb_node0003	3	Build Join Inner	1004,10,6	53	[null]		[null]	[null]	[null]	[null]
50	v_mldb_node0003	3	Join (hash)	1005,10,6	59	236		[null]	[null]	[null]	[null]
51	v_mldb_node0003	3	Combine Storage Chunks	1007,8,4	[null]	140		0	[null]	[null]	[null]
52	v_mldb_node0003	3	reserveVTLoaderResources	1015,8,4	[null]	[null]		[null]	[null]	[null]	[null]
53	v_mldb_node0003	4	Scan Projection	1003,11,7	62	31		[null]	[null]	0	[null]
54	v_mldb_node0003	5	Scan Projection	1001,13,9	40	23		[null]	[null]	0	[null]
55	v_mldb_node0003	5	Combine Storage Chunks	1002,12,8	[null]	154		0	[null]	[null]	[null]
56	v_mldb_node0003	5	reserveVTLoaderResources	1016,12,8	[null]	[null]		[null]	[null]	[null]	[null]

Rows: 1-56 | Columns: 11

Note

For more details, please look at QueryProfiler.