Feedback

×

• Feedback
• Was this page helpful?*
  • Yes
  • No
• Do you have any additional feedback?
  • Yes
  • No
• Additional Feedback

verticapy.performance.vertica.qprof.QueryProfiler.get_table

QueryProfiler.get_table(table_name: str | None = None) → list | vDataFrame

Returns the associated Vertica Table. This function allows easy data exploration of all the performance meta-tables.

Parameters

table_name: str, optional

Vertica DC Table to return. If empty, the list of all the tables is returned to simplify the selection.

Examples:

• execution_engine_profiles

• dc_explain_plans

• dc_query_executions

• dc_requests_issued

• dc_scan_events

• dc_slow_events

• host_resources

• query_plan_profiles

• query_profiles

• resource_pool_status

Returns

vDataFrame

Vertica DC Table.

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;"
)

We can easily look at any Vertica Performance Tables easily:

qprof.get_table('dc_requests_issued')

	📅 time Timestamptz(35)	Abc node_name Varchar(128)	Abc session_id Varchar(128)	123 user_id Integer	Abc user_name Varchar(128)	123 transaction_id Integer	123 statement_id Integer	123 request_id Integer	Abc request_type Varchar(128)	Abc label Varchar(128)	Abc Varchar(64000)	Abc Varchar(64000)	123 query_start_epoch Integer	Abc Varchar(64000)	010 is_retry Boolean	123 digest Integer
1	2024-08-08 16:42:51.347633+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844076	27	68734	QUERY	verticapy_json			153759		❌	-2739771977645684132
2	2024-08-08 16:42:51.373739+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844076	28	68735	QUERY				153759		❌	1173375758661070897
3	2024-08-08 16:42:51.397080+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844076	29	68736	QUERY	get_data_types			153759		❌	-6803372202362044141
4	2024-08-08 16:42:51.437976+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844076	30	68737	QUERY	verticapy_json			153759		❌	-2739771977645684132
5	2024-08-08 16:42:51.459713+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844076	31	68738	QUERY	_version			153759		❌	8903476768692993780
6	2024-08-08 16:42:51.482054+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844076	32	68739	QUERY	vDataframe.train_test_split			153759		❌	-6060496486953227029
7	2024-08-08 16:42:51.510432+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844076	33	68740	QUERY	verticapy_json			153759		❌	-2739771977645684132
8	2024-08-08 16:42:51.533256+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844076	34	68741	QUERY				153759		❌	6814844219549955390
9	2024-08-08 16:42:51.557521+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844076	35	68742	QUERY	verticapy_json			153759		❌	-2739771977645684132
10	2024-08-08 16:42:51.579922+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844076	36	68743	QUERY				153759		❌	6266927469521968618
11	2024-08-08 16:42:51.607922+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844076	37	68744	QUERY	_version			153759		❌	8903476768692993780
12	2024-08-08 16:42:51.631732+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844076	38	68745	QUERY	verticapy_json			153759		❌	-2739771977645684132
13	2024-08-08 16:42:51.650471+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844076	39	68746	QUERY				153759		❌	7011138784295650856
14	2024-08-08 16:42:51.669162+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844076	40	68747	QUERY	_version			153759		❌	8903476768692993780
15	2024-08-08 16:42:51.691807+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844076	41	68748	QUERY	learn.tools._is_already_stored			153759		❌	5835180282835082858
16	2024-08-08 16:42:51.734866+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844076	42	68749	QUERY				153759		❌	7011138784295650856
17	2024-08-08 16:42:51.754923+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844076	43	68750	QUERY				153759		❌	7011138784295650856
18	2024-08-08 16:42:51.777708+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844120	1	68751	DDL				153759		❌	[null]
19	2024-08-08 16:42:51.781022+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844120	-1	68752	UTILITY	learn.VerticaModel.fit			153759		❌	[null]
20	2024-08-08 16:42:51.785874+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844123	1	68753	QUERY				153759		❌	-5861902804668782526
21	2024-08-08 16:42:51.826198+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844125	1	68754	QUERY				153759		❌	8988585509947565202
22	2024-08-08 16:42:51.855476+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	0	-1	68755	UTILITY				153759		❌	[null]
23	2024-08-08 16:42:51.871969+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844129	1	68756	QUERY				153760		❌	-4278133178688953219
24	2024-08-08 16:42:51.904913+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844131	1	68757	QUERY				153760		❌	-4021881530365329931
25	2024-08-08 16:42:51.924520+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	0	-1	68758	UTILITY				153760		❌	[null]
26	2024-08-08 16:42:51.964319+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844136	1	68759	QUERY				153761		❌	-5861036256698212095
27	2024-08-08 16:42:51.994613+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844138	1	68760	DDL				153761		❌	[null]
28	2024-08-08 16:42:51.997126+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844139	1	68761	QUERY	_version			153761		❌	8903476768692993780
29	2024-08-08 16:42:52.018692+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844139	2	68762	QUERY				153761		❌	4841572230508595135
30	2024-08-08 16:42:52.041354+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844139	3	68763	QUERY	_version			153761		❌	8903476768692993780
31	2024-08-08 16:42:52.064245+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844139	4	68764	QUERY	learn.VerticaModel.__repr__			153761		❌	-8887346284077529213
32	2024-08-08 16:42:52.091399+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844139	5	68765	QUERY	_version			153761		❌	8903476768692993780
33	2024-08-08 16:42:52.114547+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844139	6	68766	QUERY				153761		❌	8041259019814449157
34	2024-08-08 16:42:52.146857+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844139	7	68767	QUERY	_version			153761		❌	8903476768692993780
35	2024-08-08 16:42:52.172339+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844139	8	68768	QUERY				153761		❌	4841572230508595135
36	2024-08-08 16:42:52.288546+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844139	9	68769	QUERY	verticapy_json			153761		❌	-2739771977645684132
37	2024-08-08 16:42:52.311794+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844139	10	68770	QUERY	verticapy_json			153761		❌	-2739771977645684132
38	2024-08-08 16:42:52.336719+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844139	11	68771	QUERY				153761		❌	1173375758661070897
39	2024-08-08 16:42:52.360927+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844139	12	68772	QUERY	get_data_types			153761		❌	-6803372202362044141
40	2024-08-08 16:42:52.393517+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844139	13	68773	QUERY	verticapy_json			153761		❌	-2739771977645684132
41	2024-08-08 16:42:52.416613+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844139	14	68774	QUERY	_version			153761		❌	8903476768692993780
42	2024-08-08 16:42:52.440423+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844139	15	68775	QUERY	vDataframe.train_test_split			153761		❌	-6060496486953227029
43	2024-08-08 16:42:52.464766+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844139	16	68776	QUERY	verticapy_json			153761		❌	-2739771977645684132
44	2024-08-08 16:42:52.487590+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844139	17	68777	QUERY				153761		❌	6814844219549955390
45	2024-08-08 16:42:52.508775+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844139	18	68778	QUERY	verticapy_json			153761		❌	-2739771977645684132
46	2024-08-08 16:42:52.530915+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844139	19	68779	QUERY				153761		❌	6266927469521968618
47	2024-08-08 16:42:52.559617+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844139	20	68780	QUERY	_version			153761		❌	8903476768692993780
48	2024-08-08 16:42:52.582031+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844139	21	68781	QUERY	verticapy_json			153761		❌	-2739771977645684132
49	2024-08-08 16:42:52.602737+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844139	22	68782	QUERY				153761		❌	7011138784295650856
50	2024-08-08 16:42:52.628084+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844139	23	68783	QUERY	learn.tools._is_already_stored			153761		❌	5835180282835082858
51	2024-08-08 16:42:52.675301+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844139	24	68784	QUERY				153761		❌	7011138784295650856
52	2024-08-08 16:42:52.697800+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844139	25	68785	QUERY				153761		❌	7011138784295650856
53	2024-08-08 16:42:52.720967+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844165	1	68786	DDL				153761		❌	[null]
54	2024-08-08 16:42:52.725299+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844165	-1	68787	UTILITY	learn.VerticaModel.fit			153761		❌	[null]
55	2024-08-08 16:42:52.730882+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844168	1	68788	QUERY				153761		❌	-8430327111529963382
56	2024-08-08 16:42:52.762960+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	0	-1	68789	UTILITY				153761		❌	[null]
57	2024-08-08 16:42:52.783698+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844172	1	68790	QUERY				153762		❌	101314740696625926
58	2024-08-08 16:42:52.825274+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844174	1	68791	QUERY				153762		❌	6493630772050899526
59	2024-08-08 16:42:52.854059+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	0	-1	68792	UTILITY				153762		❌	[null]
60	2024-08-08 16:42:52.870820+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844178	1	68793	QUERY				153763		❌	-1032109414052218166
61	2024-08-08 16:42:52.926383+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	0	-1	68794	UTILITY				153763		❌	[null]
62	2024-08-08 16:42:52.942136+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844182	1	68795	QUERY				153764		❌	2595799903314186095
63	2024-08-08 16:42:52.961319+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	0	-1	68796	UTILITY				153764		❌	[null]
64	2024-08-08 16:42:52.975021+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844186	1	68797	QUERY				153765		❌	-1630482069323377711
65	2024-08-08 16:42:52.995428+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	0	-1	68798	UTILITY				153765		❌	[null]
66	2024-08-08 16:42:53.188897+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844190	1	68799	QUERY				153766		❌	-5861036256698212095
67	2024-08-08 16:42:53.224381+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844192	1	68800	QUERY				153766		❌	-5861036256698212095
68	2024-08-08 16:42:53.260141+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844194	1	68801	DDL				153766		❌	[null]
69	2024-08-08 16:42:53.263005+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844195	1	68802	QUERY	learn.VerticaModel.fit			153766		❌	-7938121625303578740
70	2024-08-08 16:42:53.293309+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844195	2	68803	QUERY	_version			153766		❌	8903476768692993780
71	2024-08-08 16:42:53.317776+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844195	3	68804	QUERY				153766		❌	806487162735703196
72	2024-08-08 16:42:53.336041+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844195	4	68805	QUERY	_version			153766		❌	8903476768692993780
73	2024-08-08 16:42:53.362156+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844195	5	68806	QUERY				153766		❌	806487162735703196
74	2024-08-08 16:42:53.394421+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844195	6	68807	QUERY	_version			153766		❌	8903476768692993780
75	2024-08-08 16:42:53.420513+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844195	7	68808	QUERY				153766		❌	806487162735703196
76	2024-08-08 16:42:53.454063+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844195	8	68809	QUERY	_version			153766		❌	8903476768692993780
77	2024-08-08 16:42:53.481144+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844195	9	68810	QUERY				153766		❌	806487162735703196
78	2024-08-08 16:42:53.514634+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844195	10	68811	QUERY	_version			153766		❌	8903476768692993780
79	2024-08-08 16:42:53.536197+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844195	11	68812	QUERY				153766		❌	806487162735703196
80	2024-08-08 16:42:53.563473+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844195	12	68813	QUERY	_version			153766		❌	8903476768692993780
81	2024-08-08 16:42:53.584998+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844195	13	68814	QUERY				153766		❌	806487162735703196
82	2024-08-08 16:42:53.611726+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844195	14	68815	QUERY	_version			153766		❌	8903476768692993780
83	2024-08-08 16:42:53.634334+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844195	15	68816	QUERY				153766		❌	806487162735703196
84	2024-08-08 16:42:53.660155+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844195	16	68817	QUERY	_version			153766		❌	8903476768692993780
85	2024-08-08 16:42:53.682203+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844195	17	68818	QUERY				153766		❌	806487162735703196
86	2024-08-08 16:42:53.709312+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844195	18	68819	QUERY	_version			153766		❌	8903476768692993780
87	2024-08-08 16:42:53.730732+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844195	19	68820	QUERY				153766		❌	806487162735703196
88	2024-08-08 16:42:53.757355+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844195	20	68821	QUERY	_version			153766		❌	8903476768692993780
89	2024-08-08 16:42:53.781431+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844195	21	68822	QUERY				153766		❌	806487162735703196
90	2024-08-08 16:42:53.813594+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844195	22	68823	QUERY	_version			153766		❌	8903476768692993780
91	2024-08-08 16:42:53.837248+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844195	23	68824	QUERY	learn.VerticaModel.__repr__			153766		❌	-8887346284077529213
92	2024-08-08 16:42:53.904002+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844195	24	68825	QUERY	verticapy_json			153766		❌	-2739771977645684132
93	2024-08-08 16:42:53.926976+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844195	25	68826	QUERY	verticapy_json			153766		❌	-2739771977645684132
94	2024-08-08 16:42:53.948661+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844195	26	68827	QUERY				153766		❌	1173375758661070897
95	2024-08-08 16:42:53.972131+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844195	27	68828	QUERY	get_data_types			153766		❌	-6803372202362044141
96	2024-08-08 16:42:54.006605+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844195	28	68829	QUERY	verticapy_json			153766		❌	-2739771977645684132
97	2024-08-08 16:42:54.027828+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844195	29	68830	QUERY	_version			153766		❌	8903476768692993780
98	2024-08-08 16:42:54.048318+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844195	30	68831	QUERY	vDataframe.train_test_split			153766		❌	-6060496486953227029
99	2024-08-08 16:42:54.072171+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844195	31	68832	QUERY	verticapy_json			153766		❌	-2739771977645684132
100	2024-08-08 16:42:54.092802+00:00	v_demo_node0001	v_demo_node0001-145:0x13172	45035996273704962	dbadmin	45035996275844195	32	68833	QUERY				153766		❌	6814844219549955390

Rows: 1-100 | Columns: 16

Note

For more details, please look at QueryProfiler.