Querying Data Collector Tables
Data Collector tables (prefixed by dc_
) reside in the V_INTERNAL
schema and are provided for informational purposes only. They are provided as-is and are subject to removal or change without notice. If you use Data Collector tables in scripts or monitoring tools, you might need to change your scripts and tools after a Vertica upgrade. Vertica recommends that you use the Workload Analyzer instead of accessing Data Collector tables directly.
Here's one useful example you can use to check on the state of your database. Upon startup, the Vertica database creates, under its catalog directory, a DataCollector directory. This directory holds the disk-based data collection logs. The main data is kept in files named <component>.<timestamp>.log
.
When you start your database an entry is created in the dc_startups
table. The following is the result of querying this table.
=> SELECT * FROM dc_startups; -[ RECORD 1 ]----+----------------------------------------------------------- time | 2011-05-26 17:35:40.588589-04 node_name | v_vmartdb_node0001 version | Vertica Analytic Database v5.0.4-20110526 command_line | /opt/vertica/bin/vertica -C vmartdb -D /home/vmartdb/ | catalog/vmartdb/v_vmartdb_node0001_catalog -h | 10.10.50.123 -p 5608 codename | 5.0 build_tag | vertica(v5.0.4-20110526) built by root@build2 from trunk@69652 on 'Thu | May 26 3:37:18 2011' $BuildId$ build_type | 64-bit Optimized Build compiler_version | 4.1.1 20070105 (Red Hat 5.1.1-52) server_locale | UTF-8 database_path | /home/vmartdb/catalog/vmartdb/v_vmartdb_node0001_catalog alt_host_name | 10.10.50.123 alt_node_name | start_epoch | -[ RECORD 2 ]----+----------------------------------------------------------- time | 2011-05-26 17:35:40.218999-04 node_name | v_vmartdb_node0004 version | Vertica Analytic Database v5.0.4-20110526 command_line | /opt/vertica/bin/vertica -C vmartdb -D /home/vmartdb/ | catalog/vmartdb/v_vmartdb_node0004_catalog -h | 10.10.50.126 -p 5608 codename | 5.0 build_tag | vertica(v5.0.4-20110526) built by root@build2 from trunk@69652 on 'Thu | May 26 3:37:18 2011' $BuildId$ build_type | 64-bit Optimized Build compiler_version | 4.1.1 20070105 (Red Hat 5.1.1-52) server_locale | UTF-8 database_path | /home/vmartdb/catalog/vmartdb/v_vmartdb_node0004_catalog alt_host_name | 10.10.50.126 alt_node_name | start_epoch | -[ RECORD 3 ]----+----------------------------------------------------------- time | 2011-05-26 17:35:40.931353-04 node_name | v_vmartdb_node0003 version | Vertica Analytic Database v5.0.4-20110526 command_line | /opt/vertica/bin/vertica -C vmartdb -D /home/vmartdb/ | catalog/vmartdb /v_vmartdb_node0003_catalog -h | 10.10.50.125 -p 5608 codename | 5.0 build_tag | vertica(v5.0.4-20110526) built by root@build2 from trunk@69652 on 'Thu | May 26 3:37:18 2011' $BuildId$ build_type | 64-bit Optimized Build compiler_version | 4.1.1 20070105 (Red Hat 5.1.1-52) server_locale | UTF-8 database_path | /home/vmartdb/catalog/vmartdb/v_vmartdb_node0003_catalog alt_host_name | 10.10.50.125 alt_node_name | start_epoch | -[ RECORD 4 ]----+-----------------------------------------------------------------------