OUTPUT_EVENT_HISTORY
Contains information about each stage that Database Designer performs to design and optimize your database design.
Column Name | Column Type | Description |
---|---|---|
TIME_STAMP
|
TIMESTAMP | Date and time of the specified stage. |
DESIGN_ID
|
INTEGER |
Unique id that Database Designer assigned to the design. |
DESIGN_NAME
|
VARCHAR |
Unique name that the user assigned to the design. |
STAGE_TYPE
|
VARCHAR |
Design stage that Database Designer was working on at the time indicated by the
|
ITERATION_NUMBER
|
INTEGER |
Iteration number for the |
TOTAL_QUERY_COUNT
|
INTEGER |
Total number of design queries in the design. |
REMAINING_QUERY_COUNT
|
INTEGER |
Number of design queries remaining for Database Designer to process. |
MAX_STEP_NUMBER
|
INTEGER | Number of steps in the current stage. |
CURRENT_STEP_NUMBER
|
INTEGER |
Step in the current stage being processed at the time indicated by the |
CURRENT_STEP_DESCRIPTION
|
VARCHAR |
Name of the step that Database Designer is performing at that time indicated in the
|
TABLE_ID
|
INTEGER | Unique id that Database Designer assigned to the design table. |
Example
The following example shows the steps that Database Designer performs while optimizing the VMart example database:
=> SELECT DESIGNER_CREATE_DESIGN('VMART_DESIGN'); => SELECT DESIGNER_ADD_DESIGN_TABLES('VMART_DESIGN','public.*'); => SELECT DESIGNER_ADD_DESIGN_QUERIES('VMART_DESIGN','/tmp/examples/vmart_queries.sql',); ... => \x Expanded display is on. => SELECT * FROM OUTPUT_EVENT_HISTORY; -[ RECORD 1 ] -----------+---------------------------- time_stamp | 2013-06-05 11:44:41.588 design_id | 45035996273705090 design_name | VMART_DESIGN stage_type | Design in progress iteration_number | total_query_count | remaining_query_count | max_step_number | current_step_number | current_step_description | Design with deployment started table id | -[ RECORD 2 ] -----------+---------------------------- time_stamp | 2013-06-05 11:44:41.611 design_id | 45035996273705090 design_name | VMART_DESIGN stage_type | Design in progress iteration_number | total_query_count | remaining_query_count | max_step_number | current_step_number | current_step_description | Design in progress: Analyze statistics phase table id | -[ RECORD 3 ] -----------+---------------------------- time_stamp | 2013-06-05 11:44:42.011 design_id | 45035996273705090 design_name | VMART_DESIGN stage_type | Analyzing statistics iteration_number | total_query_count | remaining_query_count | max_step_number | 15 current_step_number | 1 current_step_description | public.customer_dimension table id | ... -[ RECORD 20 ] ----------+---------------------------- time_stamp | 2013-06-05 11:44:49.324 design_id | 45035996273705090 design_name | VMART_DESIGN stage_type | Optimizing query performance iteration_number | 1 total_query_count | 9 remaining_query_count | 9 max_step_number | 7 current_step_number | 1 current_step_description | Extracting interesting columns table id | ... -[ RECORD 62 ] ----------+---------------------------- time_stamp | 2013-06-05 11:51:23.790 design_id | 45035996273705090 design_name | VMART_DESIGN stage_type | Deployment in progress iteration_number | total_query_count | remaining_query_count | max_step_number | current_step_number | current_step_description | Deployment completed successfully table id |