verticapy.performance.vertica.qprof_interface.QueryProfilerInterface.get_cluster_config#
- QueryProfilerInterface.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()
Abchost_nameVarchar(128)123open_files_limitInteger123threads_limitInteger123core_file_limit_max_size_bytesInteger123processor_countInteger123processor_core_countIntegerAbcVarchar(8192)123opened_file_countInteger123opened_socket_countInteger123opened_nonfile_nonsocket_countInteger123total_memory_bytesInteger123total_memory_free_bytesInteger123total_buffer_memory_bytesInteger123total_memory_cache_bytesInteger123total_swap_memory_bytesInteger123total_swap_memory_free_bytesInteger123disk_space_free_mbInteger123disk_space_used_mbInteger123disk_space_total_mbInteger123system_open_filesInteger123system_max_filesInteger1 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: 21Note
For more details, please look at
QueryProfiler
.