OUTPUT_EVENT_HISTORY

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

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.

Examples

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                 |