Feedback

×

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

verticapy.performance.vertica.qprof.QueryProfiler.get_rp_status

QueryProfiler.get_rp_status() → vDataFrame

Returns the RP status.

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

The Cluster Report can also be conveniently extracted:

qprof.get_rp_status()

	Abc node_name Varchar(128)	123 pool_oid Integer	Abc pool_name Varchar(128)	010 is_internal Boolean	123 memory_size_kb Integer	123 memory_size_actual_kb Integer	123 memory_inuse_kb Integer	123 general_memory_borrowed_kb Integer	123 queueing_threshold_kb Integer	123 max_memory_size_kb Integer	123 max_query_memory_size_kb Integer	123 running_query_count Integer	123 planned_concurrency Integer	123 max_concurrency Integer	010 is_standalone Boolean	📅 queue_timeout Interval day to second	123 queue_timeout_in_seconds Integer	Abc execution_parallelism Varchar(128)	Abc thread_policy Varchar(128)	123 priority Integer	Abc runtime_priority Varchar(128)	123 runtime_priority_threshold Integer	123 runtimecap_in_seconds Integer	Abc single_initiator Varchar(128)	123 query_budget_kb Integer	Abc cpu_affinity_set Varchar(256)	Abc cpu_affinity_mask Varchar(1024)	Abc cpu_affinity_mode Varchar(128)
1	v_mldb_node0001	45035996273705010	general	✅	710505254	710505254	0	0	674980032	710505254	[null]	0	72	[null]	✅	relativedelta(minutes=+5)	300	AUTO	SYSTEM	0	MEDIUM	2	[null]	false	9374723		ffffffffffffffffff	ANY
2	v_mldb_node0001	45035996273705012	sysquery	✅	1048576	1048576	78049	0	676211520	711801600	[null]	1	72	[null]	❌	relativedelta(minutes=+5)	300	AUTO	SYSTEM	110	HIGH	0	[null]	false	14563		ffffffffffffffffff	ANY
3	v_mldb_node0001	45035996273705014	tm	✅	38797312	38797312	0	0	712072832	749550336	[null]	0	7	7	❌	relativedelta(minutes=+5)	300	AUTO	SYSTEM	105	MEDIUM	60	[null]	true	5542473		ffffffffffffffffff	ANY
4	v_mldb_node0001	45035996273705016	refresh	✅	0	0	0	0	675215360	710753024	[null]	0	4	[null]	❌	relativedelta(minutes=+5)	300	AUTO	SYSTEM	-10	MEDIUM	60	[null]	true	168745008		ffffffffffffffffff	ANY
5	v_mldb_node0001	45035996273705018	recovery	✅	0	0	0	0	675215360	710753024	[null]	0	74	37	❌	relativedelta(minutes=+5)	300	AUTO	SYSTEM	107	MEDIUM	60	[null]	true	9121352		ffffffffffffffffff	ANY
6	v_mldb_node0001	45035996273705020	dbd	✅	0	0	0	0	675215360	710753024	[null]	0	4	[null]	❌	relativedelta()	0	AUTO	SYSTEM	0	MEDIUM	0	[null]	true	168745008		ffffffffffffffffff	ANY
7	v_mldb_node0001	45035996273705098	jvm	✅	0	0	0	0	1992294	2097152	[null]	0	72	[null]	❌	relativedelta(minutes=+5)	300	AUTO	SYSTEM	0	MEDIUM	2	[null]	false	27670		ffffffffffffffffff	ANY
8	v_mldb_node0001	45035996273705108	blobdata	✅	0	0	0	0	71306896	75059891	[null]	0	2	0	❌	relativedelta()	0	AUTO	SYSTEM	0	HIGH	0	[null]	false	[null]		ffffffffffffffffff	ANY
9	v_mldb_node0001	45035996273705110	metadata	✅	247770	247770	0	0	675215360	710753024	[null]	0	1	0	❌	relativedelta()	0	AUTO	SYSTEM	108	HIGH	0	[null]	false	[null]		ffffffffffffffffff	ANY
10	v_mldb_node0002	45035996273705010	general	✅	710100181	710100181	0	0	674595136	710100181	[null]	0	72	[null]	✅	relativedelta(minutes=+5)	300	AUTO	SYSTEM	0	MEDIUM	2	[null]	false	9369377		ffffffffffffffffff	ANY
11	v_mldb_node0002	45035996273705012	sysquery	✅	1048576	1048576	56973	0	676209984	711800000	[null]	1	72	[null]	❌	relativedelta(minutes=+5)	300	AUTO	SYSTEM	110	HIGH	0	[null]	false	14563		ffffffffffffffffff	ANY
12	v_mldb_node0002	45035996273705014	tm	✅	38797312	38797312	0	0	712071296	749548736	[null]	0	7	7	❌	relativedelta(minutes=+5)	300	AUTO	SYSTEM	105	MEDIUM	60	[null]	true	5542473		ffffffffffffffffff	ANY
13	v_mldb_node0002	45035996273705016	refresh	✅	0	0	0	0	675213824	710751424	[null]	0	4	[null]	❌	relativedelta(minutes=+5)	300	AUTO	SYSTEM	-10	MEDIUM	60	[null]	true	168648784		ffffffffffffffffff	ANY
14	v_mldb_node0002	45035996273705018	recovery	✅	0	0	0	0	675213824	710751424	[null]	0	74	37	❌	relativedelta(minutes=+5)	300	AUTO	SYSTEM	107	MEDIUM	60	[null]	true	9116150		ffffffffffffffffff	ANY
15	v_mldb_node0002	45035996273705020	dbd	✅	0	0	0	0	675213824	710751424	[null]	0	4	[null]	❌	relativedelta()	0	AUTO	SYSTEM	0	MEDIUM	0	[null]	true	168648784		ffffffffffffffffff	ANY
16	v_mldb_node0002	45035996273705098	jvm	✅	0	0	0	0	1992294	2097152	[null]	0	72	[null]	❌	relativedelta(minutes=+5)	300	AUTO	SYSTEM	0	MEDIUM	2	[null]	false	27670		ffffffffffffffffff	ANY
17	v_mldb_node0002	45035996273705108	blobdata	✅	0	0	0	0	71306744	75059731	[null]	0	2	0	❌	relativedelta()	0	AUTO	SYSTEM	0	HIGH	0	[null]	false	[null]		ffffffffffffffffff	ANY
18	v_mldb_node0002	45035996273705110	metadata	✅	651243	651243	0	0	675213824	710751424	[null]	0	1	0	❌	relativedelta()	0	AUTO	SYSTEM	108	HIGH	0	[null]	false	[null]		ffffffffffffffffff	ANY
19	v_mldb_node0004	45035996273705010	general	✅	710101108	710101108	0	0	674596032	710101108	[null]	0	72	[null]	✅	relativedelta(minutes=+5)	300	AUTO	SYSTEM	0	MEDIUM	2	[null]	false	9369389		ffffffffffffffffff	ANY
20	v_mldb_node0004	45035996273705012	sysquery	✅	1048576	1048576	56973	0	676210048	711800064	[null]	1	72	[null]	❌	relativedelta(minutes=+5)	300	AUTO	SYSTEM	110	HIGH	0	[null]	false	14563		ffffffffffffffffff	ANY
21	v_mldb_node0004	45035996273705014	tm	✅	38797312	38797312	0	0	712071360	749548800	[null]	0	7	7	❌	relativedelta(minutes=+5)	300	AUTO	SYSTEM	105	MEDIUM	60	[null]	true	5542473		ffffffffffffffffff	ANY
22	v_mldb_node0004	45035996273705016	refresh	✅	0	0	0	0	675213888	710751488	[null]	0	4	[null]	❌	relativedelta(minutes=+5)	300	AUTO	SYSTEM	-10	MEDIUM	60	[null]	true	168649008		ffffffffffffffffff	ANY
23	v_mldb_node0004	45035996273705018	recovery	✅	0	0	0	0	675213888	710751488	[null]	0	74	37	❌	relativedelta(minutes=+5)	300	AUTO	SYSTEM	107	MEDIUM	60	[null]	true	9116163		ffffffffffffffffff	ANY
24	v_mldb_node0004	45035996273705020	dbd	✅	0	0	0	0	675213888	710751488	[null]	0	4	[null]	❌	relativedelta()	0	AUTO	SYSTEM	0	MEDIUM	0	[null]	true	168649008		ffffffffffffffffff	ANY
25	v_mldb_node0004	45035996273705098	jvm	✅	0	0	0	0	1992294	2097152	[null]	0	72	[null]	❌	relativedelta(minutes=+5)	300	AUTO	SYSTEM	0	MEDIUM	2	[null]	false	27670		ffffffffffffffffff	ANY
26	v_mldb_node0004	45035996273705108	blobdata	✅	0	0	0	0	71306752	75059737	[null]	0	2	0	❌	relativedelta()	0	AUTO	SYSTEM	0	HIGH	0	[null]	false	[null]		ffffffffffffffffff	ANY
27	v_mldb_node0004	45035996273705110	metadata	✅	650380	650380	0	0	675213888	710751488	[null]	0	1	0	❌	relativedelta()	0	AUTO	SYSTEM	108	HIGH	0	[null]	false	[null]		ffffffffffffffffff	ANY
28	v_mldb_node0003	45035996273705010	general	✅	710100044	710100044	0	0	674595008	710100044	[null]	0	72	[null]	✅	relativedelta(minutes=+5)	300	AUTO	SYSTEM	0	MEDIUM	2	[null]	false	9369375		ffffffffffffffffff	ANY
29	v_mldb_node0003	45035996273705012	sysquery	✅	1048576	1048576	56973	0	676210048	711800064	[null]	1	72	[null]	❌	relativedelta(minutes=+5)	300	AUTO	SYSTEM	110	HIGH	0	[null]	false	14563		ffffffffffffffffff	ANY
30	v_mldb_node0003	45035996273705014	tm	✅	38797312	38797312	0	0	712071360	749548800	[null]	0	7	7	❌	relativedelta(minutes=+5)	300	AUTO	SYSTEM	105	MEDIUM	60	[null]	true	5542473		ffffffffffffffffff	ANY
31	v_mldb_node0003	45035996273705016	refresh	✅	0	0	0	0	675213888	710751488	[null]	0	4	[null]	❌	relativedelta(minutes=+5)	300	AUTO	SYSTEM	-10	MEDIUM	60	[null]	true	168648752		ffffffffffffffffff	ANY
32	v_mldb_node0003	45035996273705018	recovery	✅	0	0	0	0	675213888	710751488	[null]	0	74	37	❌	relativedelta(minutes=+5)	300	AUTO	SYSTEM	107	MEDIUM	60	[null]	true	9116149		ffffffffffffffffff	ANY
33	v_mldb_node0003	45035996273705020	dbd	✅	0	0	0	0	675213888	710751488	[null]	0	4	[null]	❌	relativedelta()	0	AUTO	SYSTEM	0	MEDIUM	0	[null]	true	168648752		ffffffffffffffffff	ANY
34	v_mldb_node0003	45035996273705098	jvm	✅	0	0	0	0	1992294	2097152	[null]	0	72	[null]	❌	relativedelta(minutes=+5)	300	AUTO	SYSTEM	0	MEDIUM	2	[null]	false	27670		ffffffffffffffffff	ANY
35	v_mldb_node0003	45035996273705108	blobdata	✅	0	0	0	0	71306752	75059737	[null]	0	2	0	❌	relativedelta()	0	AUTO	SYSTEM	0	HIGH	0	[null]	false	[null]		ffffffffffffffffff	ANY
36	v_mldb_node0003	45035996273705110	metadata	✅	651444	651444	0	0	675213888	710751488	[null]	0	1	0	❌	relativedelta()	0	AUTO	SYSTEM	108	HIGH	0	[null]	false	[null]		ffffffffffffffffff	ANY

Rows: 1-36 | Columns: 28

Note

For more details, please look at QueryProfiler.