verticapy.performance.vertica.qprof.QueryProfiler.get_cluster_config¶

QueryProfiler.get_cluster_config() → vDataFrame¶

Returns the Cluster configuration.

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 cluster configuration details, we can conveniently call the function:

qprof.get_cluster_config()

	Abc host_name Varchar(128)	123 open_files_limit Integer	123 threads_limit Integer	123 core_file_limit_max_size_bytes Integer	123 processor_count Integer	123 processor_core_count Integer	Abc Varchar(8192)	123 opened_file_count Integer	123 opened_socket_count Integer	123 opened_nonfile_nonsocket_count Integer	123 total_memory_bytes Integer	123 total_memory_free_bytes Integer	123 total_buffer_memory_bytes Integer	123 total_memory_cache_bytes Integer	123 total_swap_memory_bytes Integer	123 total_swap_memory_free_bytes Integer	123 disk_space_free_mb Integer	123 disk_space_used_mb Integer	123 disk_space_total_mb Integer	123 system_open_files Integer	123 system_max_files Integer
1	127.0.0.1	1048576	255422	0	1	20		6	10	10	33485598720	13736443904	315035648	5809098752	8589934592	8589934592	953822	77195	1031018	3880	9223372036854775807

Rows: 1-1 | Columns: 21

Note

For more details, please look at QueryProfiler.