MEASURE_LOCATION_PERFORMANCE

Measures disk performance for the location specified.

Syntax

MEASURE_LOCATION_PERFORMANCE ( 'path' , 'node' ) 

Parameters

path

Specifies where the storage location to measure is mounted.

node

Is the Vertica node where the location to be measured is available.

Privileges

Superuser

Notes

Example

The following example measures the performance of a storage location on v_vmartdb_node0004:

=> SELECT MEASURE_LOCATION_PERFORMANCE('/secondVerticaStorageLocation/' , 'v_vmartdb_node0004');
WARNING:  measure_location_performance can take a long time. Please check logs for progress
           measure_location_performance           
--------------------------------------------------
 Throughput : 122 MB/sec. Latency : 140 seeks/sec