OUTPUT_EVENT_HISTORY

Contains information about each stage that Database Designer performs to design and optimize your database design.

Column Name Data 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 TIME_STAMP field. Possible values include:

  • Design in progress
  • Analyzing data statistics
  • Optimizing query performance
  • Optimizing storage footprint
  • All done
  • Deployment in progress
ITERATION_NUMBER INTEGER Iteration number for the Optimizing query performance stage.
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 TIME_STAMP field.
CURRENT_STEP_DESCRIPTION VARCHAR

Name of the step that Database Designer is performing at that time indicated in the TIME_STAMP field. Possible values include:

  • Design with deployment started
  • Design in progress: Analyze statistics phase
  • design_table_name
  • projection_name
  • Design in progress: Query optimization phase
  • Extracting interesting columns
  • Enumerating sort orders
  • Setting up projection candidates
  • Assessing projection candidates
  • Choosing best projections
  • Calculating estimated benefit of best projections
  • Complete
  • Design in progress: Storage optimization phase
  • Design completed successfully
  • Setting up deployment metadata
  • Identifying projections to be dropped
  • Running deployment
  • Deployment completed successfully
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                 |