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()
Abcnode_nameVarchar(128)123pool_oidIntegerAbcpool_nameVarchar(128)010is_internalBoolean123memory_size_kbInteger123memory_size_actual_kbInteger123memory_inuse_kbInteger123general_memory_borrowed_kbInteger123queueing_threshold_kbInteger123max_memory_size_kbInteger123max_query_memory_size_kbInteger123running_query_countInteger123planned_concurrencyInteger123max_concurrencyInteger010is_standaloneBoolean📅queue_timeoutInterval day to second123queue_timeout_in_secondsIntegerAbcexecution_parallelismVarchar(128)123priorityIntegerAbcruntime_priorityVarchar(128)123runtime_priority_thresholdInteger123runtimecap_in_secondsIntegerAbcsingle_initiatorVarchar(128)123query_budget_kbIntegerAbccpu_affinity_setVarchar(256)Abccpu_affinity_maskVarchar(1024)Abccpu_affinity_modeVarchar(128)1 v_demo_node0001 45035996273705004 general ✅ 24731401 24731401 0 0 23494830 24731401 [null] 0 13 [null] ✅ relativedelta(minutes=+5) 300 AUTO 0 MEDIUM 2 [null] false 1807294 fffff ANY 2 v_demo_node0001 45035996273705006 sysquery ✅ 1048576 1048576 40348 0 24631420 25927810 [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 26623714 28024962 [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 23635272 24879234 [null] 0 4 [null] ❌ relativedelta(minutes=+5) 300 AUTO -10 MEDIUM 60 [null] true 5873707 fffff ANY 5 v_demo_node0001 45035996273705012 recovery ✅ 0 0 0 0 23635272 24879234 [null] 0 22 11 ❌ relativedelta(minutes=+5) 300 AUTO 107 MEDIUM 60 [null] true 1067946 fffff ANY 6 v_demo_node0001 45035996273705014 dbd ✅ 0 0 0 0 23635272 24879234 [null] 0 4 [null] ❌ relativedelta() 0 AUTO 0 MEDIUM 0 [null] true 5873707 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 2761985 2907353 [null] 0 2 0 ❌ relativedelta() 0 AUTO 0 HIGH 0 [null] false [null] fffff ANY 9 v_demo_node0001 45035996273705104 metadata ✅ 147833 147833 0 0 23635272 24879234 [null] 0 1 0 ❌ relativedelta() 0 AUTO 108 HIGH 0 [null] false [null] fffff ANY Rows: 1-9 | Columns: 27Note
For more details, please look at
QueryProfiler
.