results/*

Copyright (c) 2016-2018, Postgres Professional

Permission to use, copy, modify, and distribute this software and its documentation for any purpose, without fee, and without a written agreement is hereby granted, provided that the above copyright notice and this paragraph and the following two paragraphs appear in all copies.

IN NO EVENT SHALL POSTGRES PROFESSIONAL BE LIABLE TO ANY PARTY FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS DOCUMENTATION, EVEN IF POSTGRES PROFESSIONAL HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

POSTGRES PROFESSIONAL SPECIFICALLY DISCLAIMS ANY WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE SOFTWARE PROVIDED HEREUNDER IS ON AN "AS IS" BASIS, AND POSTGRES PROFESSIONAL HAS NO OBLIGATIONS TO PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.

EXTENSION = aqo

EXTVERSION = 1.1

PGFILEDESC = "AQO - adaptive query optimization"

MODULES = aqo

DATA = aqo--1.0.sql

OBJS = aqo.o auto_tuning.o cardinality_estimation.o cardinality_hooks.o\

hash.o machine_learning.o path_utils.o postprocessing.o preprocessing.o\

selectivity_cache.o storage.o utils.o$(WIN32RES)

REGRESS = aqo_disabled aqo_controlled aqo_intelligent aqo_forced

REGRESS = aqo_disabled aqo_controlled aqo_intelligent aqo_forced aqo_learn

EXTRA_REGRESS_OPTS=--temp-config=$(top_srcdir)/$(subdir)/conf.add

DATA = aqo--1.0.sql aqo--1.0--1.1.sql

DATA_built = aqo--$(EXTVERSION).sql

MODULE_big = aqo

include$(top_builddir)/src/Makefile.global

include$(top_srcdir)/contrib/contrib-global.mk

$(DATA_built):$(DATA)

cat$+>$@

ALTERTABLE aqo_query_texts ALTER COLUMN query_text TYPEtext;

DROPINDEX aqo_query_texts_query_hash_idx CASCADE;

DROPINDEX aqo_queries_query_hash_idx CASCADE;

DROPINDEX aqo_query_stat_idx CASCADE;

DROPINDEX aqo_fss_access_idx CASCADE;

CREATEUNIQUE INDEXaqo_fss_access_idxON aqo_data (fspace_hash, fsspace_hash);

CREATE OR REPLACEFUNCTIONaqo_migrate_to_1_1_get_pk(rel regclass) RETURNS regclassAS $$

DECLARE

idx regclass;

SELECTi.indexrelidFROMpg_catalog.pg_index iJOIN

pg_catalog.pg_attribute aONa.attrelid=i.indrelidAND

a.attnum= ANY(i.indkey)

WHEREi.indrelid= relAND

i.indisprimary

INTO idx;

RETURN idx;

END

$$ LANGUAGE plpgsql;

DO $$

EXECUTE format('ALTER TABLE %s RENAME to %s',

aqo_migrate_to_1_1_get_pk('aqo_queries'),

'aqo_queries_query_hash_idx');

EXECUTE format('ALTER TABLE %s RENAME to %s',

aqo_migrate_to_1_1_get_pk('aqo_query_texts'),

'aqo_query_texts_query_hash_idx');

EXECUTE format('ALTER TABLE %s RENAME to %s',

aqo_migrate_to_1_1_get_pk('aqo_query_stat'),

'aqo_query_stat_idx');

END

$$;

DROPFUNCTION aqo_migrate_to_1_1_get_pk(regclass);

PG_MODULE_MAGIC;

void_PG_init(void);

void_PG_init(void);

intaqo_mode;

{"intelligent",AQO_MODE_INTELLIGENT, false},

{"forced",AQO_MODE_FORCED, false},

{"controlled",AQO_MODE_CONTROLLED, false},

{"learn",AQO_MODE_LEARN, false},

{"disabled",AQO_MODE_DISABLED, false},

{NULL,0, false}

};

instr_timequery_starttime;

doublequery_planning_time;

post_parse_analyze_hook_typeprev_post_parse_analyze_hook;

planner_hook_typeprev_planner_hook;

ExecutorStart_hook_typeprev_ExecutorStart_hook;

ExecutorEnd_hook_typeprev_ExecutorEnd_hook;

set_baserel_rows_estimate_hook_typeprev_set_baserel_rows_estimate_hook;

get_parameterized_baserel_size_hook_typeprev_get_parameterized_baserel_size_hook;

set_joinrel_size_estimates_hook_typeprev_set_joinrel_size_estimates_hook;

get_parameterized_joinrel_size_hook_typeprev_get_parameterized_joinrel_size_hook;

copy_generic_path_info_hook_typeprev_copy_generic_path_info_hook;

ExplainOnePlan_hook_typeprev_ExplainOnePlan_hook;

post_parse_analyze_hook_typeprev_post_parse_analyze_hook;

planner_hook_typeprev_planner_hook;

ExecutorStart_hook_typeprev_ExecutorStart_hook;

ExecutorEnd_hook_typeprev_ExecutorEnd_hook;

set_baserel_rows_estimate_hook_typeprev_set_baserel_rows_estimate_hook;

get_parameterized_baserel_size_hook_typeprev_get_parameterized_baserel_size_hook;

set_joinrel_size_estimates_hook_typeprev_set_joinrel_size_estimates_hook;

get_parameterized_joinrel_size_hook_typeprev_get_parameterized_joinrel_size_hook;

copy_generic_path_info_hook_typeprev_copy_generic_path_info_hook;

ExplainOnePlan_hook_typeprev_ExplainOnePlan_hook;

NULL,

NULL);

prev_planner_hook=planner_hook;

planner_hook=&aqo_planner;

prev_post_parse_analyze_hook=post_parse_analyze_hook;

post_parse_analyze_hook=&get_query_text;

prev_ExecutorStart_hook=ExecutorStart_hook;

ExecutorStart_hook=&aqo_ExecutorStart;

prev_ExecutorEnd_hook=ExecutorEnd_hook;

ExecutorEnd_hook=&learn_query_stat;

prev_set_baserel_rows_estimate_hook=set_baserel_rows_estimate_hook;

set_baserel_rows_estimate_hook=&aqo_set_baserel_rows_estimate;

get_parameterized_baserel_size_hook;

&aqo_get_parameterized_baserel_size;

prev_set_joinrel_size_estimates_hook=set_joinrel_size_estimates_hook;

set_joinrel_size_estimates_hook=&aqo_set_joinrel_size_estimates;

get_parameterized_joinrel_size_hook;

&aqo_get_parameterized_joinrel_size;

prev_copy_generic_path_info_hook=copy_generic_path_info_hook;

copy_generic_path_info_hook=&aqo_copy_generic_path_info;

prev_ExplainOnePlan_hook=ExplainOnePlan_hook;

ExplainOnePlan_hook=print_into_explain;

init_deactivated_queries_storage();

}

prev_planner_hook=planner_hook;

planner_hook=aqo_planner;

prev_post_parse_analyze_hook=post_parse_analyze_hook;

post_parse_analyze_hook=get_query_text;

prev_ExecutorStart_hook=ExecutorStart_hook;

ExecutorStart_hook=aqo_ExecutorStart;

prev_ExecutorEnd_hook=ExecutorEnd_hook;

ExecutorEnd_hook=learn_query_stat;

prev_set_baserel_rows_estimate_hook=set_baserel_rows_estimate_hook;

set_baserel_rows_estimate_hook=aqo_set_baserel_rows_estimate;

prev_get_parameterized_baserel_size_hook=get_parameterized_baserel_size_hook;

get_parameterized_baserel_size_hook=aqo_get_parameterized_baserel_size;

prev_set_joinrel_size_estimates_hook=set_joinrel_size_estimates_hook;

set_joinrel_size_estimates_hook=aqo_set_joinrel_size_estimates;

prev_get_parameterized_joinrel_size_hook=get_parameterized_joinrel_size_hook;

get_parameterized_joinrel_size_hook=aqo_get_parameterized_joinrel_size;

prev_copy_generic_path_info_hook=copy_generic_path_info_hook;

copy_generic_path_info_hook=aqo_copy_generic_path_info;

prev_ExplainOnePlan_hook=ExplainOnePlan_hook;

ExplainOnePlan_hook=print_into_explain;

_PG_fini(void)

{

planner_hook=prev_planner_hook;

post_parse_analyze_hook=prev_post_parse_analyze_hook;

ExecutorStart_hook=prev_ExecutorStart_hook;

ExecutorEnd_hook=prev_ExecutorEnd_hook;

set_baserel_rows_estimate_hook=prev_set_baserel_rows_estimate_hook;

prev_get_parameterized_baserel_size_hook;

set_joinrel_size_estimates_hook=prev_set_joinrel_size_estimates_hook;

prev_get_parameterized_joinrel_size_hook;

copy_generic_path_info_hook=prev_copy_generic_path_info_hook;

ExplainOnePlan_hook=prev_ExplainOnePlan_hook;

fini_deactivated_queries_storage();

init_deactivated_queries_storage();

}

PG_FUNCTION_INFO_V1(invalidate_deactivated_queries_cache);

# AQO extension

comment = 'machine learning for cardinality estimation in optimizer'

default_version = '1.0'

default_version = '1.1'

module_pathname = '$libdir/aqo'

relocatable = false

#error "Cannot build aqo with PostgreSQL version lower than 9.6.0"

{

AQO_MODE_INTELLIGENT,

AQO_MODE_FORCED,

AQO_MODE_CONTROLLED,

AQO_MODE_LEARN,

AQO_MODE_DISABLED,

}AQO_MODE;

intplanning_time_without_aqo_size;

intcardinality_error_with_aqo_size;

intcardinality_error_without_aqo_size;

long longexecutions_with_aqo;

long longexecutions_without_aqo;

int64executions_with_aqo;

int64executions_without_aqo;

}QueryStat;