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 ]----+-----------------------------------------------------------------------