verticapy.performance.vertica.qprof_interface.QueryProfilerInterface.get_rp_status¶

QueryProfilerInterface.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)	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_demo_node0001	45035996273705004	general	✅	24674538	24674538	0	0	23440810	24674538	[null]	0	13	[null]	✅	relativedelta(minutes=+5)	300	AUTO	0	MEDIUM	2	[null]	false	1803139		fffff	ANY
2	v_demo_node0001	45035996273705006	sysquery	✅	1048576	1048576	40348	0	24631332	25927718	[null]	1	13	[null]	❌	relativedelta(minutes=+5)	300	AUTO	110	HIGH	0	[null]	false	80659		fffff	ANY
3	v_demo_node0001	45035996273705008	tm	✅	3145728	3145728	0	0	26623626	28024870	[null]	0	7	7	❌	relativedelta(minutes=+5)	300	AUTO	105	MEDIUM	60	[null]	true	449389		fffff	ANY
4	v_demo_node0001	45035996273705010	refresh	✅	0	0	0	0	23635184	24879142	[null]	0	4	[null]	❌	relativedelta(minutes=+5)	300	AUTO	-10	MEDIUM	60	[null]	true	5860202		fffff	ANY
5	v_demo_node0001	45035996273705012	recovery	✅	0	0	0	0	23635184	24879142	[null]	0	22	11	❌	relativedelta(minutes=+5)	300	AUTO	107	MEDIUM	60	[null]	true	1065491		fffff	ANY
6	v_demo_node0001	45035996273705014	dbd	✅	0	0	0	0	23635184	24879142	[null]	0	4	[null]	❌	relativedelta()	0	AUTO	0	MEDIUM	0	[null]	true	5860202		fffff	ANY
7	v_demo_node0001	45035996273705092	jvm	✅	0	0	0	0	1992294	2097152	[null]	0	13	[null]	❌	relativedelta(minutes=+5)	300	AUTO	0	MEDIUM	2	[null]	false	153253		fffff	ANY
8	v_demo_node0001	45035996273705102	blobdata	✅	0	0	0	0	2761976	2907344	[null]	0	2	0	❌	relativedelta()	0	AUTO	0	HIGH	0	[null]	false	[null]		fffff	ANY
9	v_demo_node0001	45035996273705104	metadata	✅	204604	204604	0	0	23635184	24879142	[null]	0	1	0	❌	relativedelta()	0	AUTO	108	HIGH	0	[null]	false	[null]		fffff	ANY

Rows: 1-9 | Columns: 27

Note

For more details, please look at QueryProfiler.