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	10.20.43.240	1048576	3094405	1612787712	2	72		6	13	18	811214127104	445606166528	3043733504	324146163712	2147479552	1375862784	2536002	1406052	3942054	1872	13051931
2	10.20.43.241	1048576	3094398	1611071488	2	72		6	13	22	811212410880	528219041792	3086884864	260933861376	2147479552	2089451520	2619974	1322080	3942054	1760	13051931
3	10.20.43.242	1048576	3094399	1611132928	2	72		6	11	18	811212472320	527806464000	3283681280	260932780032	2147479552	2120425472	2633335	1308719	3942054	1728	13051931
4	10.20.43.243	1048576	3094399	1611132928	2	72		6	11	18	811212472320	258251431936	3432087552	529823621120	2147479552	2112188416	2261459	1680595	3942054	1584	13051931

Rows: 1-4 | Columns: 21

Note

For more details, please look at QueryProfiler.