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	255424	0	1	20		6	7	10	33485697024	14690299904	717975552	7771045888	8589934592	8589934592	956339	74679	1031018	2960	9223372036854775807

Rows: 1-1 | Columns: 21

Note

For more details, please look at QueryProfiler.