Index

A

AbstractPredicate (class in postbound.qal) accept_visitor() (postbound.qal.AbstractPredicate method) (postbound.qal.ArrayAccessExpression method) (postbound.qal.ArrayExpression method) (postbound.qal.BaseClause method) (postbound.qal.BetweenPredicate method) (postbound.qal.BinaryPredicate method) (postbound.qal.CaseExpression method) (postbound.qal.CastExpression method) (postbound.qal.ColumnExpression method) (postbound.qal.CommonTableExpression method) (postbound.qal.CompoundPredicate method) (postbound.qal.ExceptClause method) (postbound.qal.Explain method) (postbound.qal.From method) (postbound.qal.FunctionExpression method) (postbound.qal.GroupBy method) (postbound.qal.Having method) (postbound.qal.Hint method) (postbound.qal.InPredicate method) (postbound.qal.IntersectClause method) (postbound.qal.Limit method) (postbound.qal.MathExpression method) (postbound.qal.OrderBy method) (postbound.qal.QuantifierExpression method) (postbound.qal.Select method) (postbound.qal.SetQuery method) (postbound.qal.SimpleFilter method) (postbound.qal.SimpleJoin method) (postbound.qal.SqlExpression method) (postbound.qal.StarExpression method) (postbound.qal.StaticValueExpression method) (postbound.qal.SubqueryExpression method) (postbound.qal.UnaryPredicate method) (postbound.qal.UnionClause method) (postbound.qal.Where method) (postbound.qal.WindowExpression method) (postbound.relalg.AntiJoin method) (postbound.relalg.CrossProduct method) (postbound.relalg.Difference method) (postbound.relalg.DuplicateElimination method) (postbound.relalg.Grouping method) (postbound.relalg.Intersection method) (postbound.relalg.Map method) (postbound.relalg.Projection method) (postbound.relalg.Relation method) (postbound.relalg.RelNode method) (postbound.relalg.Rename method) (postbound.relalg.Selection method) (postbound.relalg.SemiJoin method) (postbound.relalg.Sort method) (postbound.relalg.SubqueryScan method) (postbound.relalg.ThetaJoin method) (postbound.relalg.Union method) (postbound.SqlQuery method) actual_cardinality (postbound.QueryPlan property) actual_plan_cost() (in module postbound.opt) add() (postbound.duckdb.HintParts method) (postbound.PhysicalOperatorAssignment method) (postbound.postgres.PostgresConfiguration method) add_cardinality() (postbound.PlanParameterization method) add_clause() (in module postbound.transform) add_ec_predicates() (in module postbound.transform) add_optimization_step() (postbound.IncrementalOptimizationPipeline method) add_task() (postbound.util.DependencyGraph method) (postbound.util.misc.DependencyGraph method)

additional_estimates (postbound.PlanEstimates property) additional_measures (postbound.PlanMeasures property) AddPathHook (in module postbound.opt.dynprog) aggregates (postbound.relalg.Grouping property) alias (postbound.qal.ValuesTableSource property) (postbound.TableReference property) alias() (postbound.qal.FunctionTableSource method) aliases() (postbound.qal.CommonTableExpression method) all() (postbound.qal.QuantifierExpression static method) all_join_orders_for() (postbound.opt.enumeration.ExhaustiveJoinOrderEnumerator method) all_joins() (postbound.opt.JoinGraph method) all_node_types() (postbound.postgres.PostgresExplainNode static method) all_operator_assignments_for() (postbound.opt.enumeration.ExhaustiveOperatorEnumerator method) all_plans_for() (postbound.opt.enumeration.ExhaustivePlanEnumerator method) all_simple() (postbound.qal.QueryPredicates method) analyze (postbound.qal.Explain property) analyze_plan() (postbound.db.OptimizerInterface method) (postbound.duckdb.DuckDBOptimizer method) (postbound.mysql.MysqlOptimizer method) (postbound.postgres.PostgresOptimizer method) and_() (postbound.qal.QueryPredicates method) annotate_cards() (in module postbound.vis) annotate_estimates() (in module postbound.vis) annotate_filter_cards() (in module postbound.vis) annotation (postbound.JoinTree property) AntiJoin (class in postbound.relalg) any() (postbound.qal.QuantifierExpression static method) any_database() (postbound.db.DatabasePool method) append() (postbound.util.collections.Queue method) (postbound.util.collections.SizedQueue method) apply_configuration() (postbound.postgres.PostgresInterface method) argmax() (in module postbound.util) (in module postbound.util.dicts) argmin() (in module postbound.util) (in module postbound.util.dicts) arguments (postbound.qal.FunctionExpression property) array (postbound.qal.ArrayAccessExpression property) array_type (postbound.qal.CastExpression property) ArrayAccessExpression (class in postbound.qal) ArrayExpression (class in postbound.qal) as_complete_algorithm() (in module postbound) as_count_star_query() (in module postbound.transform) as_dict() (postbound.postgres.PostgresConfiguration method) as_explain() (in module postbound.transform) as_explain_analyze() (in module postbound.transform) as_expression() (in module postbound.qal) as_graph() (postbound.db.DatabaseSchema method) as_predicate() (in module postbound.qal) as_qep() (postbound.postgres.PostgresExplainNode method) (postbound.postgres.PostgresExplainPlan method) as_star_query() (in module postbound.transform) as_unbound() (postbound.ColumnReference method) ascending (postbound.qal.OrderByExpression property) (postbound.SortKey property) assert_bound() (postbound.ColumnReference static method) ast() (postbound.qal.SetQuery method) (postbound.QueryPlan method) (postbound.SqlQuery method) AtomicInt (class in postbound.util.num) auto_bind_columns (in module postbound.parser) available_deep_pk_join_paths_for() (postbound.opt.JoinGraph method) available_join_paths() (postbound.opt.JoinGraph method) available_join_paths_for() (postbound.opt.JoinGraph method) available_n_m_join_paths() (postbound.opt.JoinGraph method) available_pk_fk_joins_for() (postbound.opt.JoinGraph method)

B

backend (postbound.postgres.PostgresHintService property) backend_pid() (postbound.postgres.PostgresInterface method) base_predicates() (postbound.qal.AbstractPredicate method) (postbound.qal.BasePredicate method) (postbound.qal.CompoundPredicate method) (postbound.qal.SimpleFilter method) (postbound.qal.SimpleJoin method) base_table (postbound.JoinTree property) (postbound.PlanParams property) (postbound.QueryPlan property) base_table() (postbound.qal.ExplicitFromClause method) (postbound.qal.JoinTableSource method) BaseClause (class in postbound.qal) BasePredicate (class in postbound.qal) BaseProjection (class in postbound.qal) BaseTable (postbound.relalg.EvaluationPhase attribute) belongs_to() (postbound.ColumnReference method)

below() (postbound.db.MostCommonValues method) BetweenPredicate (class in postbound.qal) BinaryPredicate (class in postbound.qal) bind_to() (postbound.ColumnReference method) bound_tables() (postbound.qal.SetQuery method) (postbound.SqlQuery method) BoundedInt (class in postbound.util.num) bounds (postbound.db.Histogram property) bucket_interpolation (postbound.db.Histogram property) buffer_state() (postbound.postgres.PostgresStatisticsInterface method) build() (postbound.IntegratedOptimizationPipeline method) (postbound.MultiStageOptimizationPipeline method) (postbound.TextBookOptimizationPipeline method) build_join_order_optimizer() (postbound.OptimizationSettings method) build_physical_operator_selection() (postbound.OptimizationSettings method) build_plan_parameterization() (postbound.OptimizationSettings method) build_query() (in module postbound.qal)

C

cache_enabled (postbound.Database property) cache_hits (postbound.PlanMeasures property) cache_misses (postbound.PlanMeasures property) calculate_estimate() (postbound.CardinalityEstimator method) (postbound.opt.CardinalityDistortion method) (postbound.opt.native.NativeCardinalityEstimator method) (postbound.opt.PreciseCardinalities method) (postbound.opt.PreComputedCardinalities method) can_pk_fk_join() (postbound.opt.IndexInfo method) can_wrap() (postbound.qal.SimpleFilter static method) (postbound.qal.SimpleJoin static method) canonical() (postbound.QueryPlan method) cardinalities (postbound.PlanParameterization attribute), [1] Cardinality (class in postbound) cardinality (postbound.opt.dynprog.RelOptInfo attribute) (postbound.PlanEstimates property) (postbound.PlanMeasures property) cardinality_estimate (postbound.postgres.PostgresExplainNode attribute) cardinality_estimate() (postbound.db.OptimizerInterface method) (postbound.duckdb.DuckDBOptimizer method) (postbound.mysql.MysqlOptimizer method) (postbound.postgres.PostgresOptimizer method) CardinalityDistortion (class in postbound.opt) CardinalityEstimator (class in postbound) CaseExpression (class in postbound.qal) cases (postbound.qal.CaseExpression property) casted_expression (postbound.qal.CastExpression property) CastExpression (class in postbound.qal) catalan_number() (in module postbound.util.stats) change_type (postbound.opt.PlanChangeEntry attribute) changes (postbound.opt.PlanChangeset attribute) cheapest_partial_path (postbound.opt.dynprog.RelOptInfo attribute) cheapest_path (postbound.opt.dynprog.RelOptInfo attribute) check_supported_database_system() (postbound.validation.CustomCheck method) (postbound.validation.OptimizationPreCheck method) (postbound.validation.SupportedHintCheck method) check_supported_query() (postbound.validation.CompoundCheck method) (postbound.validation.CrossProductPreCheck method) (postbound.validation.CustomCheck method) (postbound.validation.DependentSubqueryPreCheck method) (postbound.validation.EmptyPreCheck method) (postbound.validation.EquiJoinPreCheck method) (postbound.validation.ImplicitQueryPreCheck method) (postbound.validation.InnerJoinPreCheck method) (postbound.validation.OptimizationPreCheck method) (postbound.validation.SetOperationsPreCheck method) (postbound.validation.SubqueryPreCheck method) (postbound.validation.VirtualTablesPreCheck method) children (postbound.JoinTree property) (postbound.LogicalJoinTree property) (postbound.postgres.PostgresExplainNode attribute) (postbound.qal.CompoundPredicate property) (postbound.QueryPlan property) children() (postbound.relalg.AntiJoin method) (postbound.relalg.CrossProduct method) (postbound.relalg.Difference method) (postbound.relalg.DuplicateElimination method) (postbound.relalg.Grouping method) (postbound.relalg.Intersection method) (postbound.relalg.Map method) (postbound.relalg.Projection method) (postbound.relalg.Relation method) (postbound.relalg.RelNode method) (postbound.relalg.Rename method) (postbound.relalg.Selection method) (postbound.relalg.SemiJoin method) (postbound.relalg.Sort method) (postbound.relalg.SubqueryScan method) (postbound.relalg.ThetaJoin method) (postbound.relalg.Union method) ClauseDescription (in module postbound.transform) clauses() (postbound.qal.SetQuery method) (postbound.SqlQuery method) ClauseType (class in postbound.transform) ClauseVisitor (class in postbound.qal) cleanup() (postbound.CardinalityEstimator method) (postbound.CostModel method) clear() (postbound.db.DatabasePool method) clone() (postbound.opt.JoinGraph method) (postbound.PhysicalOperatorAssignment method) (postbound.PlanEstimates method) (postbound.PlanMeasures method) (postbound.PlanParams method) (postbound.relalg.RelNode method) (postbound.Subplan method) close() (postbound.Database method) (postbound.duckdb.DuckDBInterface method) (postbound.mysql.MysqlInterface method) (postbound.postgres.ParallelQueryExecutor method) (postbound.postgres.PostgresInterface method) (postbound.postgres.TimeoutQueryExecutor method) collect_subqueries_in_expression() (in module postbound.qal) cols (postbound.qal.ValuesTableSource property) (postbound.qal.ValuesWithQuery property) column (postbound.opt.IndexInfo property) (postbound.qal.BetweenPredicate property) (postbound.qal.ColumnExpression property) (postbound.qal.InPredicate property) (postbound.qal.OrderByExpression property) (postbound.qal.SimpleFilter property) (postbound.qal.UnaryPredicate property) (postbound.SortKey property) column() (postbound.qal.BaseProjection static method) ColumnExpression (class in postbound.qal) ColumnReference (class in postbound) columns (postbound.relalg.Projection property) columns() (postbound.db.DatabaseSchema method) (postbound.PlanParams method) (postbound.qal.AbstractPredicate method) (postbound.qal.ArrayExpression method) (postbound.qal.BaseClause method) (postbound.qal.BetweenPredicate method) (postbound.qal.BinaryPredicate method) (postbound.qal.CaseExpression method) (postbound.qal.CastExpression method) (postbound.qal.ColumnExpression method) (postbound.qal.CommonTableExpression method) (postbound.qal.CompoundPredicate method) (postbound.qal.DirectTableSource method) (postbound.qal.ExceptClause method) (postbound.qal.Explain method) (postbound.qal.From method) (postbound.qal.FunctionExpression method) (postbound.qal.FunctionTableSource method) (postbound.qal.GroupBy method) (postbound.qal.Having method) (postbound.qal.Hint method) (postbound.qal.InPredicate method) (postbound.qal.IntersectClause method) (postbound.qal.JoinTableSource method) (postbound.qal.Limit method) (postbound.qal.MathExpression method) (postbound.qal.OrderBy method) (postbound.qal.QuantifierExpression method) (postbound.qal.Select method) (postbound.qal.SetQuery method) (postbound.qal.SimpleFilter method) (postbound.qal.SimpleJoin method) (postbound.qal.SqlExpression method) (postbound.qal.StarExpression method) (postbound.qal.StaticValueExpression method) (postbound.qal.SubqueryExpression method) (postbound.qal.SubqueryTableSource method) (postbound.qal.TableSource method) (postbound.qal.UnaryPredicate method) (postbound.qal.UnionClause method) (postbound.qal.ValuesTableSource method) (postbound.qal.Where method) (postbound.qal.WindowExpression method) (postbound.QueryPlan method) (postbound.SqlQuery method)

columns_of() (postbound.parser.SchemaCache method) (postbound.qal.AbstractPredicate method) (postbound.SqlQuery method) CommonTableExpression (class in postbound.qal) compare_query_plans() (in module postbound.opt) CompleteOptimizationAlgorithm (class in postbound) components (postbound.util.misc.Version property) (postbound.util.Version property) CompoundCheck (class in postbound.validation) CompoundOperator (class in postbound.qal) CompoundPredicate (class in postbound.qal) condition (postbound.qal.Having property) configure_operator() (postbound.postgres.PostgresOptimizer method) connect() (in module postbound.duckdb) (in module postbound.postgres) Connection (class in postbound.db) connection() (postbound.postgres.PostgresInterface method) ContainerType (in module postbound.util.collections) contains_cross_product() (postbound.qal.SetQuery method) (postbound.SqlQuery method) contains_cross_products() (postbound.opt.JoinGraph method) contains_free_n_m_joins() (postbound.opt.JoinGraph method) contains_free_tables() (postbound.opt.JoinGraph method) contains_table() (postbound.qal.AbstractPredicate method) context (postbound.opt.PlanChangeEntry attribute) cooldown_tables() (postbound.postgres.PostgresInterface method) Cost (in module postbound) cost (postbound.PlanEstimates property) (postbound.postgres.PostgresExplainNode attribute) cost_estimate() (postbound.db.OptimizerInterface method) (postbound.duckdb.DuckDBOptimizer method) (postbound.mysql.MysqlOptimizer method) (postbound.postgres.PostgresOptimizer method) CostEstimationWarning CostModel (class in postbound) count_consumed_tables() (postbound.opt.JoinGraph method) count_star() (postbound.qal.BaseProjection static method) (postbound.qal.Select static method) cout() (postbound.QueryPlan method) create() (postbound.ColumnReference static method) (postbound.qal.CompoundPredicate static method) create_and() (postbound.qal.CompoundPredicate static method) create_binary() (postbound.qal.MathExpression static method) create_count() (postbound.qal.FunctionExpression static method) create_for() (postbound.qal.CommonTableExpression static method) (postbound.qal.From static method) (postbound.qal.GroupBy static method) (postbound.qal.ImplicitFromClause static method) (postbound.qal.OrderBy static method) (postbound.qal.OrderByExpression static method) (postbound.qal.Select static method) create_max() (postbound.qal.FunctionExpression static method) create_min() (postbound.qal.FunctionExpression static method) create_not() (postbound.qal.CompoundPredicate static method) create_or() (postbound.qal.CompoundPredicate static method) create_sum() (postbound.qal.FunctionExpression static method) create_virtual() (postbound.TableReference static method) CrossProduct (class in postbound.relalg) CrossProductPreCheck (class in postbound.validation) cte_clause (postbound.qal.SetQuery property) (postbound.SqlQuery property) current_configuration() (postbound.postgres.PostgresInterface method) current_database() (in module postbound.db) (postbound.db.DatabasePool method) current_timestamp() (in module postbound.util.misc) Cursor (class in postbound.db) cursor() (postbound.Database method) (postbound.duckdb.DuckDBInterface method) (postbound.mysql.MysqlInterface method) (postbound.postgres.PostgresInterface method) CustomCheck (class in postbound.validation) CustomHashDict (class in postbound.util.dicts)

D

data_dir() (postbound.postgres.PostgresInterface method) Database (class in postbound) database_fit_completed() (postbound.OptimizationStage method) database_name() (postbound.Database method) (postbound.duckdb.DuckDBInterface method) (postbound.mysql.MysqlInterface method) (postbound.postgres.PostgresInterface method) database_system_name() (postbound.Database method) database_system_version() (postbound.Database method) (postbound.duckdb.DuckDBInterface method) (postbound.mysql.MysqlInterface method) (postbound.postgres.PostgresInterface method) DatabasePool (class in postbound.db) DatabaseSchema (class in postbound.db) DatabaseServerError DatabaseStatistics (class in postbound.db) DatabaseUserError datatype() (postbound.db.DatabaseSchema method) (postbound.mysql.MysqlSchemaInterface method) (postbound.postgres.PostgresSchemaInterface method) default() (postbound.util.jsonize.JsonizeEncoder method) DependencyGraph (class in postbound.util) (class in postbound.util.misc) DependentSubqueryPreCheck (class in postbound.validation) deprecated() (in module postbound.util.typing) describe() (postbound.Database method) (postbound.duckdb.DuckDBInterface method) (postbound.IncrementalOptimizationPipeline method) (postbound.IntegratedOptimizationPipeline method) (postbound.MultiStageOptimizationPipeline method) (postbound.mysql.MysqlInterface method) (postbound.opt.CardinalityDistortion method) (postbound.opt.dynprog.DynamicProgrammingEnumerator method) (postbound.opt.dynprog.PostgresDynProg method) (postbound.opt.native.NativeCardinalityEstimator method) (postbound.opt.native.NativeCostModel method) (postbound.opt.native.NativeJoinOrderOptimizer method) (postbound.opt.native.NativeOptimizer method) (postbound.opt.native.NativePhysicalOperatorSelection method) (postbound.opt.native.NativePlanParameterization method) (postbound.opt.noopt.EmptyJoinOrderOptimizer method) (postbound.opt.noopt.EmptyParameterization method) (postbound.opt.noopt.EmptyPhysicalOperatorSelection method) (postbound.opt.PreciseCardinalities method) (postbound.opt.PreComputedCardinalities method) (postbound.opt.randomized.RandomJoinOrderOptimizer method) (postbound.opt.randomized.RandomOperatorOptimizer method) (postbound.opt.randomized.RandomPlanOptimizer method) (postbound.OptimizationPipeline method) (postbound.OptimizationStage method) (postbound.postgres.PostgresHintService method) (postbound.postgres.PostgresInterface method) (postbound.TextBookOptimizationPipeline method) (postbound.validation.CompoundCheck method) (postbound.validation.CrossProductPreCheck method) (postbound.validation.DependentSubqueryPreCheck method) (postbound.validation.EmptyPreCheck method) (postbound.validation.EquiJoinPreCheck method) (postbound.validation.ImplicitQueryPreCheck method) (postbound.validation.InnerJoinPreCheck method) (postbound.validation.OptimizationPreCheck method) (postbound.validation.SetOperationsPreCheck method) (postbound.validation.SubqueryPreCheck method) (postbound.validation.SupportedHintCheck method) (postbound.validation.VirtualTablesPreCheck method)

determine_join_equivalence_classes() (in module postbound.qal) determine_output_shape() (postbound.parser.QueryNamespace method) dfs_walk() (postbound.relalg.RelNode method) Difference (class in postbound.relalg) difference() (in module postbound.util.dicts) DirectionalJoinOperatorAssignment (class in postbound) DirectTableSource (class in postbound.qal) distinct (postbound.qal.FunctionExpression property) (postbound.qal.GroupBy property) distinct_specifier() (postbound.qal.Select method) distinct_values() (postbound.db.DatabaseStatistics method) DPWarning drain_queue() (postbound.postgres.ParallelQueryExecutor method) drop_alias() (postbound.TableReference method) drop_clause() (in module postbound.transform) drop_hints() (in module postbound.transform) drop_table_alias() (postbound.ColumnReference method) drop_workers() (postbound.PlanParameterization method) DuckDBHintService (class in postbound.duckdb) DuckDBInterface (class in postbound.duckdb) DuckDBOptimizer (class in postbound.duckdb) DuckDBSchema (class in postbound.duckdb) DuckDBStatistics (class in postbound.duckdb) DuplicateElimination (class in postbound.relalg) DynamicDefaultDict (class in postbound.util.dicts) DynamicProgrammingEnumerator (class in postbound.opt.dynprog)

E

echo() (postbound.util.proc.ProcResult method) elements (postbound.qal.ArrayExpression property) else_expression (postbound.qal.CaseExpression property) empty() (postbound.db.DatabasePool method) (postbound.duckdb.HintParts static method) (postbound.JoinTree static method) (postbound.LogicalJoinTree static method) empty_predicate() (postbound.qal.QueryPredicates static method) EmptyJoinOrderOptimizer (class in postbound.opt.noopt) EmptyParameterization (class in postbound.opt.noopt) EmptyPhysicalOperatorSelection (class in postbound.opt.noopt) EmptyPreCheck (class in postbound.validation) enlist() (in module postbound.util) (in module postbound.util.collections) enqueue() (postbound.util.collections.Queue method) ensure_all_passed() (postbound.validation.PreCheckResult method) entries() (postbound.Workload method) equal() (postbound.qal.BinaryPredicate static method) EquiJoinPreCheck (class in postbound.validation) equivalence_class (postbound.SortKey property) ErrorHandling (in module postbound.bench) estimate_cardinalities() (postbound.CardinalityEstimator method) estimate_cost() (postbound.CostModel method) (postbound.opt.native.NativeCostModel method) estimated_cardinality (postbound.QueryPlan property) estimated_cards() (in module postbound.vis) estimated_cost (postbound.QueryPlan property) estimates (postbound.QueryPlan property) EvaluationPhase (class in postbound.relalg) ExceptClause (class in postbound.qal) ExecStatus (in module postbound.bench) execute_query() (postbound.Database method) (postbound.duckdb.DuckDBInterface method) (postbound.mysql.MysqlInterface method) (postbound.postgres.PostgresInterface method) (postbound.postgres.TimeoutQueryExecutor method) execute_with_timeout() (postbound.db.TimeoutSupport method) execute_workload() (in module postbound.bench)

execution_error() (postbound.bench.ExecutionResult static method) execution_mode (postbound.PlanParameterization attribute), [1] execution_time (postbound.bench.ExecutionResult attribute) (postbound.PlanMeasures property) (postbound.postgres.PostgresExplainNode attribute) (postbound.postgres.PostgresExplainPlan attribute) (postbound.QueryPlan property) ExecutionMode (in module postbound) ExecutionResult (class in postbound.bench) ExecutionTarget (in module postbound.bench) ExhaustiveJoinOrderEnumerator (class in postbound.opt.enumeration) ExhaustiveOperatorEnumerator (class in postbound.opt.enumeration) ExhaustivePlanEnumerator (class in postbound.opt.enumeration) exists() (postbound.qal.UnaryPredicate static method) expand() (postbound.util.nx.GraphWalk method) expand_to_query() (in module postbound.transform) Explain (class in postbound.qal) explain (postbound.qal.SetQuery property) (postbound.SqlQuery property) explain() (postbound.Database method) (postbound.db.OptimizerInterface method) (postbound.QueryPlan method) explain_analyze() (postbound.db.OptimizerInterface method) (postbound.qal.Explain static method) explicit_to_implicit() (in module postbound.transform) ExplicitFromClause (class in postbound.qal) ExplicitSqlQuery (class in postbound.qal) explode() (in module postbound.util.dicts) explode_query_plan() (in module postbound.opt) export_marker_table() (postbound.postgres.WorkloadShifter method) expression (postbound.qal.BaseProjection property) (postbound.qal.QuantifierExpression property) (postbound.qal.SubqueryTableSource property) ExpressionCollector (class in postbound.qal) expressions (postbound.qal.OrderBy property) extend() (postbound.util.collections.Queue method) (postbound.util.collections.SizedQueue method) extract_query_fragment() (in module postbound.transform) extract_subquery() (in module postbound.transform)

F

failure_reason (postbound.validation.PreCheckResult attribute) fetch_base_table() (postbound.QueryPlan method) fetch_direction (postbound.qal.Limit property) fetch_workload() (in module postbound.workloads) filter_by() (postbound.Workload method) filter_condition (postbound.postgres.PostgresExplainNode attribute) (postbound.qal.WindowExpression property) filter_conditions() (postbound.postgres.PostgresExplainNode method) filter_predicate (postbound.PlanParams property) (postbound.QueryPlan property) filter_where (postbound.qal.FunctionExpression property) filters() (postbound.qal.QueryPredicates method) (postbound.SqlQuery method) filters_for() (postbound.qal.QueryPredicates method) (postbound.SqlQuery method) final_node() (postbound.util.nx.GraphWalk method) find_all_nodes() (postbound.QueryPlan method) find_first_node() (postbound.QueryPlan method) first() (postbound.Workload method) first_arg (postbound.qal.MathExpression property) first_argument (postbound.qal.BinaryPredicate property) fit_database() (postbound.OptimizationStage method) fit_samples() (postbound.OptimizationStage method) fit_workload() (postbound.OptimizationStage method) fk_col (postbound.db.ForeignKeyRef attribute) flatten() (in module postbound.util) (in module postbound.util.collections) flatten_and_predicate() (in module postbound.transform) flip_direction() (postbound.opt.JoinPath method) for_equivalence_class() (postbound.SortKey static method) force_directed_layout() (in module postbound.vis)

foreach() (in module postbound.util.collections) foreign_keys_on() (postbound.db.DatabaseSchema method) (postbound.duckdb.DuckDBSchema method) (postbound.mysql.MysqlSchemaInterface method) (postbound.postgres.PostgresSchemaInterface method) ForeignKeyRef (class in postbound.db) format_query() (postbound.db.HintService method) (postbound.duckdb.DuckDBHintService method) (postbound.mysql.MysqlHintService method) (postbound.postgres.PostgresHintService method) format_quick() (in module postbound.qal) free (postbound.opt.TableInfo attribute) free_tables() (postbound.opt.JoinGraph method) freq_per_bucket (postbound.db.Histogram property) frequencies (postbound.db.MostCommonValues property) frequency_above() (postbound.db.Histogram method) frequency_below() (postbound.db.Histogram method) frequency_of() (postbound.db.MostCommonValues method) From (class in postbound.qal) from_clause (postbound.qal.ExplicitSqlQuery property) (postbound.qal.ImplicitSqlQuery property) (postbound.qal.SetQuery property) (postbound.SqlQuery property) from_table (postbound.qal.StarExpression property) frozendict (class in postbound.util) (class in postbound.util.dicts) full_name (postbound.TableReference property) function (postbound.qal.FunctionExpression property) (postbound.qal.FunctionTableSource property) FunctionExpression (class in postbound.qal) FunctionTableSource (class in postbound.qal)

G

generate_execution_plan() (postbound.opt.dynprog.DynamicProgrammingEnumerator method) (postbound.opt.dynprog.PostgresDynProg method) (postbound.PlanEnumerator method) generate_for() (postbound.opt.IndexInfo static method) generate_hints() (postbound.db.HintService method) (postbound.duckdb.DuckDBHintService method) (postbound.mysql.MysqlHintService method) (postbound.postgres.PostgresHintService method) generate_intermediates() (postbound.CardinalityEstimator method) generate_marker_table() (postbound.postgres.WorkloadShifter method) generate_multi() (in module postbound.util.dicts) generate_plan_parameters() (postbound.CardinalityEstimator method) (postbound.opt.native.NativePlanParameterization method) (postbound.opt.noopt.EmptyParameterization method) (postbound.ParameterGeneration method) generate_predicates_for_equivalence_classes() (in module postbound.qal) generate_workload() (in module postbound.workloads)

get() (postbound.Cardinality method) (postbound.PhysicalOperatorAssignment method) (postbound.PlanEstimates method) (postbound.PlanMeasures method) (postbound.PlanParams method) (postbound.QueryPlan method) get_any() (in module postbound.util.collections) get_globally_enabled_operators() (postbound.PhysicalOperatorAssignment method) get_instance() (postbound.db.DatabasePool static method) global_settings (postbound.PhysicalOperatorAssignment attribute) global_settings_only() (postbound.PhysicalOperatorAssignment method) GraphWalk (class in postbound.util.nx) group_columns (postbound.qal.GroupBy property) (postbound.relalg.Grouping property) GroupBy (class in postbound.qal) groupby_clause (postbound.qal.SetQuery property) (postbound.SqlQuery property) Grouping (class in postbound.relalg)

H

has_extension() (postbound.postgres.PostgresInterface method) has_index() (postbound.db.DatabaseSchema method) has_secondary_index() (postbound.db.DatabaseSchema method) (postbound.duckdb.DuckDBSchema method) (postbound.mysql.MysqlSchemaInterface method) (postbound.postgres.PostgresSchemaInterface method) hash_condition (postbound.postgres.PostgresExplainNode attribute) hash_dict() (in module postbound.util) (in module postbound.util.dicts) HashableDict (class in postbound.util.dicts) Having (class in postbound.qal) having_clause (postbound.qal.SetQuery property) (postbound.SqlQuery property) head() (postbound.util.collections.Queue method) (postbound.util.collections.SizedQueue method) (postbound.Workload method)

Hint (class in postbound.qal) hinting() (postbound.Database method) (postbound.duckdb.DuckDBInterface method) (postbound.mysql.MysqlInterface method) (postbound.postgres.PostgresInterface method) HintParts (class in postbound.duckdb) hints (postbound.duckdb.HintParts attribute) (postbound.qal.SetQuery property) (postbound.SqlQuery property) HintService (class in postbound.db) HintType (class in postbound) HintWarning Histogram (class in postbound.db)

I

identifier() (postbound.qal.DirectTableSource method) (postbound.TableReference method) ImplicitFromClause (class in postbound.qal) ImplicitQueryPreCheck (class in postbound.validation) ImplicitSqlQuery (class in postbound.qal) import_marker_table() (postbound.postgres.WorkloadShifter method) IncrementalOptimizationPipeline (class in postbound) IncrementalOptimizationStep (class in postbound) index (postbound.PlanParams property) (postbound.qal.ArrayAccessExpression property) index_condition (postbound.postgres.PostgresExplainNode attribute) index_info (postbound.opt.TableInfo attribute) index_name (postbound.postgres.PostgresExplainNode attribute) index_slice (postbound.qal.ArrayAccessExpression property) index_type (postbound.opt.IndexInfo property) indexed_column() (postbound.postgres.PostgresSchemaInterface method) indexes_on() (postbound.db.DatabaseSchema method) (postbound.duckdb.DuckDBSchema method) (postbound.mysql.MysqlSchemaInterface method) (postbound.postgres.PostgresSchemaInterface method) IndexInfo (class in postbound.opt) infer_settings() (postbound.opt.dynprog.PostgresDynProg method) infinite() (postbound.Cardinality static method) initial() (postbound.opt.JoinGraph method) initial_plan_generator (postbound.IncrementalOptimizationPipeline property) initialize() (postbound.CardinalityEstimator method) (postbound.CostModel method) (postbound.opt.native.NativeCardinalityEstimator method) (postbound.opt.native.NativeCostModel method) initialize_with() (postbound.parser.SchemaCache method) inner (postbound.DirectionalJoinOperatorAssignment property) inner_child (postbound.JoinTree property) (postbound.LogicalJoinTree property) (postbound.QueryPlan property) inner_outer_children() (postbound.postgres.PostgresExplainNode method) InnerJoinPreCheck (class in postbound.validation) InPredicate (class in postbound.qal) input_node (postbound.QueryPlan property) (postbound.relalg.AntiJoin property) (postbound.relalg.Grouping property) (postbound.relalg.Map property) (postbound.relalg.Projection property) (postbound.relalg.Rename property) (postbound.relalg.Selection property) (postbound.relalg.SemiJoin property) (postbound.relalg.Sort property) (postbound.relalg.SubqueryScan property) input_queries() (postbound.qal.IntersectClause method) (postbound.qal.UnionClause method) inspect() (postbound.JoinOperatorAssignment method) (postbound.JoinTree method) (postbound.opt.PlanChangeEntry method) (postbound.opt.PlanChangeset method) (postbound.postgres.PostgresExplainNode method) (postbound.postgres.PostgresExplainPlan method) (postbound.QueryPlan method) (postbound.relalg.RelNode method) (postbound.ScanOperatorAssignment method) integrate_workers_from() (postbound.PhysicalOperatorAssignment method) IntegratedOptimizationPipeline (class in postbound) intermediate (postbound.JoinOperatorAssignment property) (postbound.opt.dynprog.RelOptInfo attribute) intermediate_operators (postbound.PhysicalOperatorAssignment attribute) IntermediateOperator (class in postbound) IntersectClause (class in postbound.qal) Intersection (class in postbound.relalg) intersection() (in module postbound.util.dicts) interval (postbound.qal.BetweenPredicate property) interval_end (postbound.qal.BetweenPredicate property) interval_start (postbound.qal.BetweenPredicate property) invalidate() (postbound.opt.IndexInfo method) InvariantViolationError invert() (in module postbound.util.dicts) invert_multi() (in module postbound.util.dicts) is_aggregate() (postbound.qal.FunctionExpression method) is_analyze() (postbound.postgres.PostgresExplainNode method) (postbound.postgres.PostgresExplainPlan method) (postbound.QueryPlan method) is_auxiliary() (postbound.QueryPlan method) is_available_join() (postbound.opt.JoinGraph method) is_base() (postbound.qal.AbstractPredicate method) is_base_join() (postbound.JoinTree method) (postbound.QueryPlan method) is_bound() (postbound.ColumnReference method) is_bushy() (postbound.JoinTree method) (postbound.QueryPlan method) is_compatible_with() (postbound.SortKey method) is_compound() (postbound.qal.AbstractPredicate method) (postbound.qal.BasePredicate method) (postbound.qal.CompoundPredicate method) (postbound.qal.SimpleFilter method) (postbound.qal.SimpleJoin method) is_dependent() (postbound.qal.SetQuery method) (postbound.relalg.AntiJoin method) (postbound.relalg.SemiJoin method) (postbound.SqlQuery method) is_directional() (postbound.DirectionalJoinOperatorAssignment method) (postbound.JoinOperatorAssignment method) is_distinct() (postbound.qal.Select method) is_empty() (postbound.JoinTree method) (postbound.qal.QueryPredicates method) is_exists() (postbound.qal.UnaryPredicate method) is_explain() (postbound.qal.SetQuery method) (postbound.SqlQuery method) is_explicit() (postbound.qal.ExplicitSqlQuery method) (postbound.qal.ImplicitSqlQuery method) (postbound.qal.MixedSqlQuery method) (postbound.qal.SetQuery method) (postbound.SqlQuery method) is_filter() (postbound.qal.AbstractPredicate method) is_free_table() (postbound.opt.JoinGraph method) is_implicit() (postbound.qal.ExplicitSqlQuery method) (postbound.qal.ImplicitSqlQuery method) (postbound.qal.MixedSqlQuery method) (postbound.qal.SetQuery method) (postbound.SqlQuery method) is_indexed() (postbound.opt.IndexInfo method) is_invalid (postbound.opt.IndexInfo property) is_join() (postbound.JoinTree method) (postbound.postgres.PostgresExplainNode method) (postbound.qal.AbstractPredicate method) (postbound.qal.BetweenPredicate method) (postbound.qal.BinaryPredicate method) (postbound.qal.CompoundPredicate method) (postbound.qal.InPredicate method) (postbound.qal.SimpleFilter method) (postbound.qal.SimpleJoin method) (postbound.qal.UnaryPredicate method) (postbound.QueryPlan method) is_left_deep() (postbound.QueryPlan method) is_linear() (postbound.JoinTree method) (postbound.QueryPlan method) is_n_m_join() (postbound.opt.JoinGraph method) is_negation() (postbound.qal.CompoundPredicate method)

is_null() (postbound.qal.StaticValueExpression method) is_nullable() (postbound.db.DatabaseSchema method) (postbound.mysql.MysqlSchemaInterface method) (postbound.postgres.PostgresSchemaInterface method) is_ordered() (postbound.qal.SetQuery method) (postbound.QueryPlan method) (postbound.SqlQuery method) is_pk_fk_join() (postbound.opt.JoinGraph method) is_primary() (postbound.opt.IndexInfo method) is_primary_key() (postbound.db.DatabaseSchema method) (postbound.mysql.MysqlSchemaInterface method) (postbound.postgres.PostgresSchemaInterface method) is_right_deep() (postbound.QueryPlan method) is_running() (in module postbound.postgres) is_scalar() (postbound.qal.SetQuery method) (postbound.SqlQuery method) is_scan() (postbound.JoinTree method) (postbound.postgres.PostgresExplainNode method) (postbound.QueryPlan method) is_scan_branch() (postbound.QueryPlan method) is_secondary() (postbound.opt.IndexInfo method) is_set_query() (postbound.qal.SetQuery method) (postbound.SqlQuery method) is_star() (postbound.qal.BaseProjection method) (postbound.qal.Select method) is_subquery_predicate() (postbound.qal.InPredicate method) is_unary() (postbound.qal.MathExpression method) is_union_all() (postbound.qal.UnionClause method) is_unknown() (postbound.Cardinality method) is_valid() (postbound.Cardinality method) (postbound.util.misc.Version static method) (postbound.util.Version static method) is_view() (postbound.db.DatabaseSchema method) is_zigzag() (postbound.QueryPlan method) isinf() (postbound.Cardinality method) isnan() (postbound.Cardinality method) items (postbound.qal.From property) items() (postbound.PlanEstimates method) (postbound.PlanMeasures method) (postbound.PlanParams method) iterchildren() (postbound.qal.AbstractPredicate method) (postbound.qal.ArrayExpression method) (postbound.qal.CaseExpression method) (postbound.qal.CastExpression method) (postbound.qal.ColumnExpression method) (postbound.qal.CompoundPredicate method) (postbound.qal.FunctionExpression method) (postbound.qal.MathExpression method) (postbound.qal.QuantifierExpression method) (postbound.qal.SqlExpression method) (postbound.qal.StarExpression method) (postbound.qal.StaticValueExpression method) (postbound.qal.SubqueryExpression method) (postbound.qal.WindowExpression method) itercolumns() (postbound.qal.AbstractPredicate method) (postbound.qal.ArrayExpression method) (postbound.qal.BaseClause method) (postbound.qal.BetweenPredicate method) (postbound.qal.BinaryPredicate method) (postbound.qal.CaseExpression method) (postbound.qal.CastExpression method) (postbound.qal.ColumnExpression method) (postbound.qal.CommonTableExpression method) (postbound.qal.CompoundPredicate method) (postbound.qal.DirectTableSource method) (postbound.qal.ExceptClause method) (postbound.qal.Explain method) (postbound.qal.From method) (postbound.qal.FunctionExpression method) (postbound.qal.FunctionTableSource method) (postbound.qal.GroupBy method) (postbound.qal.Having method) (postbound.qal.Hint method) (postbound.qal.InPredicate method) (postbound.qal.IntersectClause method) (postbound.qal.JoinTableSource method) (postbound.qal.Limit method) (postbound.qal.MathExpression method) (postbound.qal.OrderBy method) (postbound.qal.QuantifierExpression method) (postbound.qal.Select method) (postbound.qal.SetQuery method) (postbound.qal.SimpleFilter method) (postbound.qal.SimpleJoin method) (postbound.qal.SqlExpression method) (postbound.qal.StarExpression method) (postbound.qal.StaticValueExpression method) (postbound.qal.SubqueryExpression method) (postbound.qal.SubqueryTableSource method) (postbound.qal.TableSource method) (postbound.qal.UnaryPredicate method) (postbound.qal.UnionClause method) (postbound.qal.ValuesTableSource method) (postbound.qal.Where method) (postbound.qal.WindowExpression method) (postbound.SqlQuery method) iterexpressions() (postbound.qal.AbstractPredicate method) (postbound.qal.BaseClause method) (postbound.qal.BetweenPredicate method) (postbound.qal.BinaryPredicate method) (postbound.qal.CommonTableExpression method) (postbound.qal.CompoundPredicate method) (postbound.qal.DirectTableSource method) (postbound.qal.ExceptClause method) (postbound.qal.Explain method) (postbound.qal.From method) (postbound.qal.FunctionTableSource method) (postbound.qal.GroupBy method) (postbound.qal.Having method) (postbound.qal.Hint method) (postbound.qal.InPredicate method) (postbound.qal.IntersectClause method) (postbound.qal.JoinTableSource method) (postbound.qal.Limit method) (postbound.qal.OrderBy method) (postbound.qal.Select method) (postbound.qal.SetQuery method) (postbound.qal.SimpleFilter method) (postbound.qal.SimpleJoin method) (postbound.qal.SubqueryTableSource method) (postbound.qal.TableSource method) (postbound.qal.UnaryPredicate method) (postbound.qal.UnionClause method) (postbound.qal.ValuesTableSource method) (postbound.qal.Where method) (postbound.SqlQuery method) iterjoins() (postbound.JoinTree method) (postbound.LogicalJoinTree method) iternodes() (postbound.JoinTree method) (postbound.LogicalJoinTree method) (postbound.QueryPlan method) iterpredicates() (postbound.qal.ExplicitFromClause method) itertables() (postbound.JoinTree method) (postbound.qal.ImplicitFromClause method)

J

jaccard() (in module postbound.util) (in module postbound.util.stats) job() (in module postbound.workloads) job_complex() (in module postbound.workloads) job_light() (in module postbound.workloads) join (postbound.JoinOperatorAssignment property) Join (postbound.relalg.EvaluationPhase attribute) join() (postbound.JoinTree static method) (postbound.LogicalJoinTree static method) join_components() (postbound.opt.JoinGraph method) join_condition (postbound.opt.JoinPath attribute) (postbound.qal.JoinTableSource property) join_depth() (in module postbound.opt) join_equivalence_classes() (postbound.db.DatabaseSchema method) join_equivalence_keys() (postbound.db.DatabaseSchema method) join_filter (postbound.postgres.PostgresExplainNode attribute) join_graph() (postbound.qal.QueryPredicates method) (postbound.SqlQuery method) join_operators (postbound.PhysicalOperatorAssignment attribute) join_order_enumerator (postbound.MultiStageOptimizationPipeline property) join_partners() (postbound.qal.AbstractPredicate method) (postbound.qal.BetweenPredicate method) (postbound.qal.BinaryPredicate method) (postbound.qal.CompoundPredicate method) (postbound.qal.InPredicate method) (postbound.qal.SimpleFilter method) (postbound.qal.SimpleJoin method) (postbound.qal.UnaryPredicate method) join_partners_from() (postbound.opt.JoinGraph method) join_partners_of() (postbound.qal.AbstractPredicate method) join_predicates_between() (postbound.opt.JoinGraph method) join_type (postbound.qal.JoinTableSource property)

join_with() (postbound.JoinTree method) (postbound.LogicalJoinTree method) joined_table (postbound.qal.JoinTableSource property) joined_tables() (postbound.opt.JoinGraph method) JoinGraph (class in postbound.opt) JoinOperator (class in postbound) JoinOperatorAssignment (class in postbound) JoinOrderOptimization (class in postbound) JoinPath (class in postbound.opt) JoinRelLevel (in module postbound.opt.dynprog) joins() (postbound.qal.QueryPredicates method) (postbound.qal.SimpleJoin method) (postbound.SqlQuery method) joins_between() (postbound.qal.QueryPredicates method) (postbound.SqlQuery method) joins_columns() (postbound.qal.AbstractPredicate method) joins_for() (postbound.qal.QueryPredicates method) (postbound.SqlQuery method) joins_table() (postbound.qal.AbstractPredicate method) joins_tables() (postbound.opt.JoinGraph method) (postbound.qal.AbstractPredicate method) (postbound.qal.QueryPredicates method) (postbound.SqlQuery method) JoinTableSource (class in postbound.qal) JoinTree (class in postbound) jointree_from_plan() (in module postbound) jointree_similarity_bottomup() (in module postbound.opt) jointree_similarity_topdown() (in module postbound.opt) JoinTreeAnnotation (in module postbound) JoinType (class in postbound.qal) Jsonizable (class in postbound.util.jsonize) JsonizeEncoder (class in postbound.util.jsonize)

K

k (postbound.db.MostCommonValues property)

key() (in module postbound.util.dicts)

L

label_of() (postbound.Workload method) labels() (postbound.Workload method) LabelType (class in postbound.workloads) last() (postbound.Workload method) last_query_runtime() (postbound.db.StopwatchSupport method) lateral (postbound.qal.SubqueryTableSource property) Lazy (in module postbound.util.typing) LazyVal (in module postbound.util.typing) leaf() (postbound.relalg.RelNode method) learn_from_feedback() (postbound.OptimizationPipeline method) (postbound.OptimizationStage method) left (postbound.qal.JoinTableSource property) left_input (postbound.relalg.CrossProduct property) (postbound.relalg.Difference property) (postbound.relalg.Intersection property) (postbound.relalg.ThetaJoin property) (postbound.relalg.Union property) left_query (postbound.qal.ExceptClause property) (postbound.qal.IntersectClause property) (postbound.qal.SetQuery property) (postbound.qal.UnionClause property) left_state (postbound.opt.PlanChangeEntry attribute) Level (in module postbound.opt.dynprog) lhs (postbound.qal.SimpleJoin property) Limit (class in postbound.qal) limit (postbound.qal.Limit property) limit_clause (postbound.qal.SetQuery property) (postbound.SqlQuery property)

linearized_levenshtein_distance() (in module postbound.opt) load() (postbound.postgres.PostgresConfiguration static method) load_column_json() (in module postbound.parser) load_expression_json() (in module postbound.parser) load_predicate_json() (in module postbound.parser) load_query() (in module postbound.parser) load_settings() (postbound.MultiStageOptimizationPipeline method) load_table_json() (in module postbound.parser) local_columns() (postbound.qal.Select method) logfile() (postbound.postgres.PostgresInterface method) Logger (in module postbound.util.logging) LogicalJoinTree (class in postbound) LogicalOperator (class in postbound.qal) LogicError lookup() (postbound.JoinTree method) (postbound.LogicalJoinTree method) (postbound.QueryPlan method) lookup_column() (postbound.db.DatabaseSchema method) (postbound.mysql.MysqlSchemaInterface method) (postbound.parser.QueryNamespace method) (postbound.parser.SchemaCache method) (postbound.postgres.PostgresSchemaInterface method) lookup_key (postbound.PlanParams property) (postbound.QueryPlan property) loops (postbound.postgres.PostgresExplainNode attribute) lower (postbound.db.Histogram property) lower_index (postbound.qal.ArrayAccessExpression property)

M

major (postbound.util.misc.Version property) (postbound.util.Version property) make_hashable() (in module postbound.util.collections) make_logger() (in module postbound.util) (in module postbound.util.logging) make_virtual() (postbound.TableReference method) Map (class in postbound.relalg) map() (postbound.Workload method) mapping (postbound.relalg.Map property) (postbound.relalg.Rename property) mark_joined() (postbound.opt.JoinGraph method) materialized (postbound.qal.WithQuery property) MathExpression (class in postbound.qal) MathOperator (class in postbound.qal) max_freq (postbound.db.MostCommonValues property) measures (postbound.QueryPlan property) merge() (in module postbound.util.dicts) (postbound.validation.PreCheckResult static method) merge_checks() (in module postbound.validation) merge_tables() (in module postbound.transform) merge_with() (postbound.duckdb.HintParts method) (postbound.PhysicalOperatorAssignment method) (postbound.PlanParameterization method) (postbound.SortKey method) min_freq (postbound.db.MostCommonValues property) min_max() (postbound.db.DatabaseStatistics method) minor (postbound.util.misc.Version property) (postbound.util.Version property) MixedSqlQuery (class in postbound.qal) module postbound postbound.bench postbound.db postbound.duckdb postbound.experiments postbound.mysql postbound.opt postbound.opt.dynprog postbound.opt.enumeration postbound.opt.native postbound.opt.noopt postbound.opt.randomized postbound.parser postbound.postgres postbound.qal postbound.relalg postbound.transform postbound.util postbound.util.collections postbound.util.dicts postbound.util.jsonize postbound.util.logging postbound.util.misc postbound.util.num postbound.util.nx postbound.util.proc postbound.util.stats postbound.util.system postbound.util.typing postbound.validation postbound.vis postbound.workloads

module_local() (in module postbound.util.typing) most_common_values() (postbound.db.DatabaseStatistics method) MostCommonValues (class in postbound.db) move_into_subquery() (in module postbound.transform) MultiStageOptimizationPipeline (class in postbound) mutate() (postbound.relalg.AntiJoin method) (postbound.relalg.CrossProduct method) (postbound.relalg.Difference method) (postbound.relalg.DuplicateElimination method) (postbound.relalg.Grouping method) (postbound.relalg.Intersection method) (postbound.relalg.Map method) (postbound.relalg.Projection method) (postbound.relalg.Relation method) (postbound.relalg.RelNode method) (postbound.relalg.Rename method) (postbound.relalg.Selection method) (postbound.relalg.SemiJoin method) (postbound.relalg.Sort method) (postbound.relalg.SubqueryScan method) (postbound.relalg.ThetaJoin method) (postbound.relalg.Union method) MysqlConnectionArguments (class in postbound.mysql) MysqlHintService (class in postbound.mysql) MysqlInterface (class in postbound.mysql) MysqlOptimizer (class in postbound.mysql) MysqlOptimizerHints (in module postbound.mysql) MysqlSchemaInterface (class in postbound.mysql) MysqlStatisticsInterface (class in postbound.mysql) MysqlSwitchableOptimizations (in module postbound.mysql)

N

n_buckets (postbound.db.Histogram property) n_buffered() (postbound.postgres.PostgresStatisticsInterface method) n_databases() (postbound.db.DatabasePool method) n_rows (postbound.db.Histogram property) name (postbound.ColumnReference property) (postbound.Workload property) NativeCardinalityEstimator (class in postbound.opt.native) NativeCostModel (class in postbound.opt.native) NativeJoinOrderOptimizer (class in postbound.opt.native) NativeOptimizer (class in postbound.opt.native) NativePhysicalOperatorSelection (class in postbound.opt.native) NativePlanParameterization (class in postbound.opt.native) necessary_hints() (postbound.opt.randomized.RandomOperatorGenerator method) NewLabelType (class in postbound.workloads) no_index() (postbound.opt.IndexInfo static method) node_type (postbound.postgres.PostgresExplainNode attribute) (postbound.QueryPlan property) (postbound.relalg.RelNode property)

nodes() (postbound.util.nx.GraphWalk method) nodes_hash() (postbound.util.nx.GraphWalk method) NodeType (class in postbound.util.nx) (in module postbound.postgres) NoFilterPredicateError NoJoinPredicateError null() (postbound.qal.StaticValueExpression static method) nulls_first (postbound.qal.OrderByExpression property) num_distinct() (postbound.db.DatabaseStatistics method) nx_bfs_tree() (in module postbound.util.nx) nx_frontier_walks() (in module postbound.util.nx) nx_graph() (postbound.opt.JoinGraph method) nx_random_walk() (in module postbound.util.nx) nx_sinks() (in module postbound.util.nx) nx_sources() (in module postbound.util.nx)

O

obtain_new_local_connection() (postbound.postgres.PostgresInterface method) of() (postbound.Cardinality static method) (postbound.qal.ColumnExpression static method) (postbound.SortKey static method) offset (postbound.qal.Limit property) open_files() (in module postbound.util) (in module postbound.util.system) open_nested() (postbound.parser.QueryNamespace method) operation (postbound.qal.BasePredicate property) (postbound.qal.BinaryPredicate property) (postbound.qal.CompoundPredicate property) (postbound.qal.SimpleFilter property) operator (postbound.JoinOperatorAssignment property) (postbound.qal.MathExpression property) (postbound.QueryPlan property) (postbound.ScanOperatorAssignment attribute) (postbound.ScanOperatorAssignment property) operator_time (postbound.QueryPlan property) operators_from_plan() (in module postbound) optimization_algorithm (postbound.IntegratedOptimizationPipeline property) optimization_time (postbound.bench.ExecutionResult attribute) OptimizationPipeline (class in postbound) OptimizationPreCheck (class in postbound.validation) OptimizationSettings (class in postbound) OptimizationStage (class in postbound) optimize_join_order() (postbound.JoinOrderOptimization method) (postbound.opt.native.NativeJoinOrderOptimizer method) (postbound.opt.noopt.EmptyJoinOrderOptimizer method) (postbound.opt.randomized.RandomJoinOrderOptimizer method)

optimize_query() (postbound.CompleteOptimizationAlgorithm method) (postbound.IncrementalOptimizationStep method) (postbound.MultiStageOptimizationPipeline method) (postbound.opt.native.NativeOptimizer method) (postbound.opt.randomized.RandomPlanOptimizer method) (postbound.OptimizationPipeline method) optimizer() (postbound.Database method) (postbound.duckdb.DuckDBInterface method) (postbound.mysql.MysqlInterface method) (postbound.postgres.PostgresInterface method) OptimizerInterface (class in postbound.db) OrderBy (class in postbound.qal) orderby_clause (postbound.qal.SetQuery property) (postbound.SqlQuery property) OrderByExpression (class in postbound.qal) ordered() (postbound.Workload method) ordering (postbound.qal.WindowExpression property) outer (postbound.DirectionalJoinOperatorAssignment property) outer_child (postbound.JoinTree property) (postbound.LogicalJoinTree property) (postbound.QueryPlan property) outermost_scan() (postbound.QueryPlan method) output_columns() (postbound.qal.SetQuery method) (postbound.qal.SubqueryTableSource method) (postbound.qal.ValuesTableSource method) (postbound.qal.ValuesWithQuery method) (postbound.qal.WithQuery method) (postbound.SqlQuery method) output_names() (postbound.qal.Select method)

P

pairs() (in module postbound.util.collections) parallel_workers (postbound.JoinOperatorAssignment property) (postbound.PlanParameterization attribute), [1] (postbound.PlanParams property) (postbound.postgres.PostgresExplainNode attribute) (postbound.QueryPlan property) (postbound.ScanOperatorAssignment attribute) (postbound.ScanOperatorAssignment property) parallelize() (postbound.QueryPlan method) ParallelQueryExecutor (class in postbound.postgres) parameter (postbound.postgres.PostgresSetting property) ParameterGeneration (class in postbound) parameters() (postbound.mysql.MysqlConnectionArguments method) (postbound.postgres.PostgresConfiguration method) parameters_from_plan() (in module postbound) params (postbound.QueryPlan property) parent_node (postbound.relalg.RelNode property) parent_relationship (postbound.postgres.PostgresExplainNode attribute) parse_duckdb_plan() (in module postbound.duckdb) parse_plan() (postbound.db.OptimizerInterface method) (postbound.duckdb.DuckDBOptimizer method) (postbound.mysql.MysqlOptimizer method) (postbound.postgres.PostgresOptimizer method) parse_query() (in module postbound) (in module postbound.parser) parse_relalg() (in module postbound.relalg) parse_table() (postbound.postgres.PostgresExplainNode method) ParserError ParserWarning partial_paths (postbound.opt.dynprog.RelOptInfo attribute) partitioning (postbound.qal.WindowExpression property) partner_of() (postbound.qal.SimpleJoin method) passed (postbound.validation.PreCheckResult attribute) passed() (postbound.bench.ExecutionResult static method) patch (postbound.util.misc.Version property) (postbound.util.Version property) path (postbound.util.nx.GraphWalk attribute) pathlist (postbound.opt.dynprog.RelOptInfo attribute) peak() (postbound.util.collections.Queue method) PGHintPlanOptimizerHints (in module postbound.postgres) PGLabOptimizerHints (in module postbound.postgres) physical_operator_selection (postbound.MultiStageOptimizationPipeline property) PhysicalOperator (in module postbound) PhysicalOperatorAssignment (class in postbound) PhysicalOperatorSelection (class in postbound) pick_random() (postbound.Workload method) plan() (postbound.qal.Explain static method) plan_depth() (postbound.JoinTree method) (postbound.QueryPlan method) plan_parameterization (postbound.MultiStageOptimizationPipeline property) plan_summary() (postbound.QueryPlan method) plan_width (postbound.postgres.PostgresExplainNode attribute) PlanChangeEntry (class in postbound.opt) PlanChangeset (class in postbound.opt) PlanEnumerator (class in postbound) PlanEstimates (class in postbound) PlanMeasures (class in postbound) planning_time (postbound.postgres.PostgresExplainPlan attribute) PlanParameterization (class in postbound) PlanParams (class in postbound) plot_analyze_plan() (in module postbound.vis) plot_join_graph() (in module postbound.vis) plot_join_tree() (in module postbound.vis) plot_query_plan() (in module postbound.vis) plot_relalg() (in module postbound.vis) plot_tree() (in module postbound.vis) pop() (postbound.util.collections.Queue method) (postbound.util.collections.SizedQueue method) possible_plans_bound() (in module postbound.opt) PostAggregation (postbound.relalg.EvaluationPhase attribute) postbound module postbound.bench module postbound.db module postbound.duckdb module postbound.experiments module postbound.mysql module postbound.opt module postbound.opt.dynprog module postbound.opt.enumeration module postbound.opt.native module postbound.opt.noopt module postbound.opt.randomized module postbound.parser module postbound.postgres module postbound.qal module postbound.relalg module postbound.transform module

postbound.util module postbound.util.collections module postbound.util.dicts module postbound.util.jsonize module postbound.util.logging module postbound.util.misc module postbound.util.num module postbound.util.nx module postbound.util.proc module postbound.util.stats module postbound.util.system module postbound.util.typing module postbound.validation module postbound.vis module postbound.workloads module PostgresConfigInterface (class in postbound.postgres) PostgresConfiguration (class in postbound.postgres) PostgresDynProg (class in postbound.opt.dynprog) PostgresExplainClause (class in postbound.postgres) PostgresExplainIntermediateNodes (in module postbound.postgres) PostgresExplainJoinNodes (in module postbound.postgres) PostgresExplainNode (class in postbound.postgres) PostgresExplainPlan (class in postbound.postgres) PostgresExplainScanNodes (in module postbound.postgres) PostgresHintingBackend (in module postbound.postgres) PostgresHintService (class in postbound.postgres) PostgresInterface (class in postbound.postgres) PostgresJoinHints (in module postbound.postgres) PostgresLimitClause (class in postbound.postgres) PostgresOptimizer (class in postbound.postgres) PostgresOptimizerSettings (in module postbound.postgres) PostgresPlanHints (in module postbound.postgres) PostgresScanHints (in module postbound.postgres) PostgresSchemaInterface (class in postbound.postgres) PostgresSetting (class in postbound.postgres) PostgresStatisticsInterface (class in postbound.postgres) PostJoin (postbound.relalg.EvaluationPhase attribute) powerset() (in module postbound.util) (in module postbound.util.collections) pre_check (postbound.MultiStageOptimizationPipeline property) pre_check() (postbound.CostModel method) (postbound.opt.dynprog.DynamicProgrammingEnumerator method) (postbound.opt.dynprog.PostgresDynProg method) (postbound.opt.randomized.RandomJoinOrderOptimizer method) (postbound.opt.randomized.RandomOperatorOptimizer method) (postbound.opt.randomized.RandomPlanOptimizer method) (postbound.OptimizationStage method) PreCheckResult (class in postbound.validation) PreciseCardinalities (class in postbound.opt) PreComputedCardinalities (class in postbound.opt) PredefLogger (in module postbound.bench) predicate (postbound.qal.Where property) (postbound.relalg.AntiJoin property) (postbound.relalg.Selection property) (postbound.relalg.SemiJoin property) (postbound.relalg.ThetaJoin property) predicates() (postbound.qal.DirectTableSource method) (postbound.qal.FunctionTableSource method) (postbound.qal.JoinTableSource method) (postbound.qal.SetQuery method) (postbound.qal.SubqueryTableSource method) (postbound.qal.TableSource method) (postbound.qal.ValuesTableSource method) (postbound.SqlQuery method) PredicateType (class in postbound.transform) PredicateVisitor (class in postbound.qal) preparatory_statements (postbound.qal.Hint property) prepare_export() (in module postbound.bench) prepare_query() (postbound.bench.QueryPreparation method) prewarm_tables() (postbound.db.PrewarmingSupport method) (postbound.postgres.PostgresInterface method) PrewarmingSupport (class in postbound.db) primary_index() (postbound.opt.IndexInfo static method) primary_key_column() (postbound.db.DatabaseSchema method) print_if() (in module postbound.util.logging) print_stderr() (in module postbound.util.logging) ProcResult (class in postbound.util.proc) Projection (class in postbound.relalg) provided_expressions() (postbound.relalg.Grouping method) (postbound.relalg.Map method) (postbound.relalg.Relation method) (postbound.relalg.RelNode method) (postbound.relalg.Rename method) (postbound.relalg.SubqueryScan method) provides() (postbound.Database method) provides_column() (postbound.parser.QueryNamespace method) push() (postbound.util.collections.Queue method)

Q

qerror() (postbound.QueryPlan method) qualified_name() (postbound.TableReference method) quantifier (postbound.qal.QuantifierExpression property) QuantifierExpression (class in postbound.qal) QuantifierOperator (class in postbound.qal) queries (postbound.qal.CommonTableExpression property) queries() (postbound.Workload method) query (postbound.bench.ExecutionResult attribute) (postbound.qal.SubqueryExpression property) (postbound.qal.SubqueryTableSource property) (postbound.qal.WithQuery property) query_execution_plan() (postbound.IncrementalOptimizationPipeline method) (postbound.IntegratedOptimizationPipeline method) (postbound.MultiStageOptimizationPipeline method) (postbound.OptimizationPipeline method) (postbound.TextBookOptimizationPipeline method)

query_hints (postbound.qal.Hint property) query_plan (postbound.postgres.PostgresExplainPlan attribute) query_plan() (postbound.db.OptimizerInterface method) (postbound.duckdb.DuckDBOptimizer method) (postbound.mysql.MysqlOptimizer method) (postbound.postgres.PostgresOptimizer method) query_pre_check() (postbound.OptimizationSettings method) query_result (postbound.bench.ExecutionResult attribute) QueryCacheWarning QueryNamespace (class in postbound.parser) QueryPlan (class in postbound) QueryPredicates (class in postbound.qal) QueryPreparation (class in postbound.bench) QueryType (class in postbound.transform) Queue (class in postbound.util.collections) queue_query() (postbound.postgres.ParallelQueryExecutor method)

R

raise_if_error() (postbound.util.proc.ProcResult method) random_join_orders_for() (postbound.opt.randomized.RandomJoinOrderGenerator method) random_operator_assignments_for() (postbound.opt.randomized.RandomOperatorGenerator method) random_plans_for() (postbound.opt.randomized.RandomPlanGenerator method) RandomJoinOrderGenerator (class in postbound.opt.randomized) RandomJoinOrderOptimizer (class in postbound.opt.randomized) RandomOperatorGenerator (class in postbound.opt.randomized) RandomOperatorOptimizer (class in postbound.opt.randomized) RandomPlanGenerator (class in postbound.opt.randomized) RandomPlanOptimizer (class in postbound.opt.randomized) read() (postbound.Workload static method) read_batch_workload() (in module postbound.workloads) read_csv_workload() (in module postbound.workloads) read_df() (in module postbound.util) read_jointree_json() (in module postbound.opt) read_operator_assignment_json() (in module postbound.opt) read_operator_json() (in module postbound.opt) read_plan_params_json() (in module postbound.opt) read_query_plan_json() (in module postbound.opt) read_workload() (in module postbound.workloads) recheck_condition (postbound.postgres.PostgresExplainNode attribute) recursive (postbound.qal.CommonTableExpression property) reduce_multi() (in module postbound.util.dicts) referenced_col (postbound.db.ForeignKeyRef attribute) referenced_tables() (postbound.qal.CommonTableExpression method) register_database() (postbound.db.DatabasePool method) register_table() (postbound.parser.QueryNamespace method) relabel() (postbound.Workload method) Relation (class in postbound.relalg) relation_alias (postbound.postgres.PostgresExplainNode attribute) relation_name (postbound.postgres.PostgresExplainNode attribute) RelNode (class in postbound.relalg) RelNodeVisitor (class in postbound.relalg) RelOptInfo (class in postbound.opt.dynprog) remove() (postbound.postgres.PostgresConfiguration method) remove_marked() (postbound.postgres.WorkloadShifter method) remove_ordered() (postbound.postgres.WorkloadShifter method) remove_predicate() (in module postbound.transform) remove_random() (postbound.postgres.WorkloadShifter method) Rename (class in postbound.relalg) rename_columns_in_clause() (in module postbound.transform) rename_columns_in_expression() (in module postbound.transform) rename_columns_in_predicate() (in module postbound.transform) rename_columns_in_query() (in module postbound.transform)

rename_table() (in module postbound.transform) replace_clause() (in module postbound.transform) replace_expressions() (in module postbound.transform) replace_predicate() (in module postbound.transform) represents_number() (in module postbound.util.num) required_tables() (postbound.qal.AbstractPredicate method) requires_data_training() (postbound.OptimizationPipeline method) (postbound.OptimizationStage class method) requires_online_training() (postbound.OptimizationPipeline method) requires_sample_training() (postbound.OptimizationPipeline method) (postbound.OptimizationStage class method) requires_workload_training() (postbound.OptimizationPipeline method) (postbound.OptimizationStage class method) reset_cache() (postbound.Database method) reset_connection() (postbound.Database method) (postbound.duckdb.DuckDBInterface method) (postbound.mysql.MysqlInterface method) (postbound.postgres.PostgresInterface method) resolve_table() (postbound.parser.QueryNamespace method) result_set() (postbound.postgres.ParallelQueryExecutor method) ResultRow (in module postbound.db) retrieve_database() (postbound.db.DatabasePool method) rhs (postbound.qal.SimpleJoin property) right (postbound.qal.JoinTableSource property) right_input (postbound.relalg.CrossProduct property) (postbound.relalg.Difference property) (postbound.relalg.Intersection property) (postbound.relalg.ThetaJoin property) (postbound.relalg.Union property) right_query (postbound.qal.ExceptClause property) (postbound.qal.IntersectClause property) (postbound.qal.SetQuery property) (postbound.qal.UnionClause property) right_state (postbound.opt.PlanChangeEntry attribute) rollback_tx() (postbound.postgres.PostgresInterface method) root (postbound.postgres.PostgresExplainPlan property) (postbound.qal.ExplicitFromClause property) (postbound.qal.QueryPredicates property) (postbound.Subplan attribute) root() (postbound.relalg.RelNode method) rows (postbound.qal.ValuesTableSource property) (postbound.qal.ValuesWithQuery property) run_cmd() (in module postbound.util) (in module postbound.util.proc)

S

sample_fit_completed() (postbound.OptimizationPipeline method) (postbound.OptimizationStage method) sample_spec() (postbound.OptimizationStage method) scale_cardinality() (postbound.QueryPlan method) scan() (postbound.JoinTree static method) (postbound.LogicalJoinTree static method) scan_operators (postbound.PhysicalOperatorAssignment attribute) ScanOperator (class in postbound) ScanOperatorAssignment (class in postbound) schema (postbound.TableReference property) schema() (postbound.Database method) (postbound.duckdb.DuckDBInterface method) (postbound.mysql.MysqlInterface method) (postbound.postgres.PostgresInterface method) SchemaCache (class in postbound.parser) second_arg (postbound.qal.MathExpression property) second_argument (postbound.qal.BinaryPredicate property) secondary_index() (postbound.opt.IndexInfo static method) Select (class in postbound.qal) select_clause (postbound.qal.SetQuery property) (postbound.SqlQuery property) select_physical_operators() (postbound.opt.native.NativePhysicalOperatorSelection method) (postbound.opt.noopt.EmptyPhysicalOperatorSelection method) (postbound.opt.randomized.RandomOperatorOptimizer method) (postbound.PhysicalOperatorSelection method) Selection (class in postbound.relalg) SelectQueryType (class in postbound.transform) SemiJoin (class in postbound.relalg) server_mode() (postbound.mysql.MysqlInterface method) set() (postbound.PhysicalOperatorAssignment method) set_clause (postbound.qal.SetQuery property) set_intermediate_operator() (postbound.PhysicalOperatorAssignment method) set_join_operator() (postbound.PhysicalOperatorAssignment method) set_operation (postbound.qal.SetQuery property) set_operator_enabled_globally() (postbound.PhysicalOperatorAssignment method) set_scan_operator() (postbound.PhysicalOperatorAssignment method) set_system_settings() (postbound.PlanParameterization method) set_union() (in module postbound.util) (in module postbound.util.collections) set_workers() (postbound.PlanParameterization method) SetOperationsPreCheck (class in postbound.validation) SetOperator (class in postbound.qal) SetQuery (class in postbound.qal) settings (postbound.duckdb.HintParts attribute) (postbound.postgres.PostgresConfiguration property) setup_annotations() (in module postbound.vis) setup_cardinality_estimator() (postbound.TextBookOptimizationPipeline method) setup_cost_model() (postbound.TextBookOptimizationPipeline method) setup_join_order_optimization() (postbound.MultiStageOptimizationPipeline method) setup_optimization_algorithm() (postbound.IntegratedOptimizationPipeline method) setup_physical_operator_selection() (postbound.MultiStageOptimizationPipeline method) setup_plan_enumerator() (postbound.TextBookOptimizationPipeline method) setup_plan_parameterization() (postbound.MultiStageOptimizationPipeline method) setup_query_support_check() (postbound.MultiStageOptimizationPipeline method) shared_blocks_buffered (postbound.postgres.PostgresExplainNode attribute) shared_blocks_read (postbound.postgres.PostgresExplainNode attribute) shuffle() (postbound.Workload method) sideways_pass (postbound.relalg.RelNode property) simple_expression (postbound.qal.CaseExpression property) SimpleFilter (class in postbound.qal) SimpleJoin (class in postbound.qal) simplify() (in module postbound.util) (in module postbound.util.collections) (postbound.qal.QueryPredicates method) simplify_result_set() (in module postbound.db) SizedQueue (class in postbound.util.collections)

sliding_window() (in module postbound.util) (in module postbound.util.collections) Sort (class in postbound.relalg) sort_keys (postbound.PlanParams property) (postbound.postgres.PostgresExplainNode attribute) (postbound.QueryPlan property) sort_results() (in module postbound.bench) SortDirection (in module postbound.relalg) Sorting (in module postbound.opt.dynprog) sorting (postbound.relalg.Sort property) SortKey (class in postbound) source (postbound.qal.JoinTableSource property) spans_table() (postbound.opt.JoinPath method) SqlExpression (class in postbound.qal) SqlExpressionVisitor (class in postbound.qal) SqlQuery (class in postbound) ssb() (in module postbound.workloads) stack() (in module postbound.workloads) stages() (postbound.IncrementalOptimizationPipeline method) (postbound.IntegratedOptimizationPipeline method) (postbound.MultiStageOptimizationPipeline method) (postbound.OptimizationPipeline method) (postbound.TextBookOptimizationPipeline method) standard_add_path() (postbound.opt.dynprog.PostgresDynProg method) standard_logger() (in module postbound.util) (in module postbound.util.logging) star() (postbound.qal.BaseProjection static method) (postbound.qal.Select static method) star_expressions() (postbound.qal.Select method) star_query_cardinality() (in module postbound.opt) StarExpression (class in postbound.qal) start() (in module postbound.postgres) start_node (postbound.util.nx.GraphWalk attribute) start_table (postbound.opt.JoinPath attribute) StateError StaticValueExpression (class in postbound.qal) statistics() (postbound.Database method) (postbound.duckdb.DuckDBInterface method) (postbound.mysql.MysqlInterface method) (postbound.postgres.PostgresInterface method) stats() (in module postbound.workloads) status (postbound.bench.ExecutionResult attribute) stop() (in module postbound.postgres) StopwatchSupport (class in postbound.db) stringify() (in module postbound.util.dicts) (postbound.qal.SetQuery method) (postbound.SqlQuery method) Subplan (class in postbound) subplan (postbound.QueryPlan property) subqueries() (postbound.qal.SetQuery method) (postbound.SqlQuery method) subquery (postbound.qal.WithQuery property) (postbound.relalg.SubqueryScan property) subquery() (postbound.qal.InPredicate static method) subquery_input (postbound.relalg.Relation property) subquery_node (postbound.relalg.AntiJoin property) (postbound.relalg.SemiJoin property) SubqueryExpression (class in postbound.qal) SubqueryPreCheck (class in postbound.validation) SubqueryScan (class in postbound.relalg) SubqueryTableSource (class in postbound.qal) SupportedHintCheck (class in postbound.validation) supports_hint() (postbound.db.HintService method) (postbound.duckdb.DuckDBHintService method) (postbound.mysql.MysqlHintService method) (postbound.postgres.PostgresHintService method) system_settings (postbound.PlanParameterization attribute), [1]

T

table (postbound.ColumnReference property) (postbound.qal.DirectTableSource property) (postbound.qal.ValuesTableSource property) (postbound.relalg.Relation property) (postbound.ScanOperatorAssignment attribute) (postbound.ScanOperatorAssignment property) TableInfo (class in postbound.opt) TableReference (class in postbound) tables() (postbound.db.DatabaseSchema method) (postbound.duckdb.DuckDBSchema method) (postbound.JoinTree method) (postbound.opt.JoinPath method) (postbound.PlanParams method) (postbound.postgres.PostgresSchemaInterface method) (postbound.qal.AbstractPredicate method) (postbound.qal.ArrayExpression method) (postbound.qal.BaseClause method) (postbound.qal.CaseExpression method) (postbound.qal.CastExpression method) (postbound.qal.ColumnExpression method) (postbound.qal.CommonTableExpression method) (postbound.qal.DirectTableSource method) (postbound.qal.ExceptClause method) (postbound.qal.From method) (postbound.qal.FunctionExpression method) (postbound.qal.FunctionTableSource method) (postbound.qal.IntersectClause method) (postbound.qal.JoinTableSource method) (postbound.qal.MathExpression method) (postbound.qal.QuantifierExpression method) (postbound.qal.Select method) (postbound.qal.SetQuery method) (postbound.qal.SqlExpression method) (postbound.qal.StarExpression method) (postbound.qal.StaticValueExpression method) (postbound.qal.SubqueryExpression method) (postbound.qal.SubqueryTableSource method) (postbound.qal.TableSource method) (postbound.qal.UnionClause method) (postbound.qal.ValuesTableSource method) (postbound.qal.Where method) (postbound.qal.WindowExpression method) (postbound.QueryPlan method) (postbound.relalg.Relation method) (postbound.relalg.RelNode method) (postbound.relalg.SubqueryScan method) (postbound.SqlQuery method) (postbound.Subplan method)

TableSource (class in postbound.qal) target_database() (postbound.IncrementalOptimizationPipeline method) (postbound.IntegratedOptimizationPipeline method) (postbound.MultiStageOptimizationPipeline method) (postbound.OptimizationPipeline method) (postbound.TextBookOptimizationPipeline method) target_db (postbound.IncrementalOptimizationPipeline property) (postbound.IntegratedOptimizationPipeline property) (postbound.MultiStageOptimizationPipeline property) target_format (postbound.qal.Explain property) target_name (postbound.qal.BaseProjection property) (postbound.qal.FunctionTableSource property) (postbound.qal.SubqueryTableSource property) (postbound.qal.WithQuery property) (postbound.Subplan attribute) target_table (postbound.opt.JoinPath attribute) (postbound.qal.FunctionTableSource property) (postbound.qal.SubqueryTableSource property) (postbound.qal.WithQuery property) target_type (postbound.qal.CastExpression property) targets (postbound.qal.Select property) temp_blocks_read (postbound.postgres.PostgresExplainNode attribute) temp_blocks_written (postbound.postgres.PostgresExplainNode attribute) TextBookOptimizationPipeline (class in postbound) ThetaJoin (class in postbound.relalg) time_query() (postbound.db.StopwatchSupport method) TimeoutQueryExecutor (class in postbound.postgres) TimeoutSupport (class in postbound.db) timestamp() (in module postbound.util) (in module postbound.util.logging) to_json() (in module postbound.util) (in module postbound.util.jsonize) to_json_dump() (in module postbound.util) (in module postbound.util.jsonize) to_query_plan() (in module postbound.opt) top() (postbound.db.MostCommonValues method) total_rows() (postbound.db.DatabaseStatistics method) train_on_database() (postbound.OptimizationPipeline method) train_on_samples() (postbound.OptimizationPipeline method) train_on_workload() (postbound.OptimizationPipeline method) transform() (postbound.Workload method) trigrams() (in module postbound.util.stats) true_cardinality (postbound.postgres.PostgresExplainNode attribute) type_params (postbound.qal.CastExpression property)

U

UnaryPredicate (class in postbound.qal) unbound_tables() (postbound.qal.SetQuery method) (postbound.SqlQuery method) Union (class in postbound.relalg) union_all (postbound.qal.UnionClause property) UnionClause (class in postbound.qal) unknown() (postbound.Cardinality static method) UnsupportedDatabaseFeatureError UnsupportedQueryError UnsupportedSystemError unwrap() (postbound.qal.SimpleFilter method) (postbound.qal.SimpleJoin method) update() (in module postbound.util.dicts) (postbound.postgres.PostgresConfiguration method) (postbound.postgres.PostgresSetting method)

update_annotation() (postbound.JoinTree method) (postbound.LogicalJoinTree method) update_plan() (in module postbound.opt) update_statistics() (postbound.postgres.PostgresStatisticsInterface method) upper (postbound.db.Histogram property) upper_index (postbound.qal.ArrayAccessExpression property) use() (postbound.IncrementalOptimizationPipeline method) (postbound.IntegratedOptimizationPipeline method) (postbound.MultiStageOptimizationPipeline method) (postbound.TextBookOptimizationPipeline method) uses_online_feedback() (postbound.OptimizationStage class method)

V

value (postbound.Cardinality property) (postbound.postgres.PostgresSetting property) (postbound.qal.SimpleFilter property) (postbound.qal.StaticValueExpression property) value() (in module postbound.util.dicts) values (postbound.db.MostCommonValues property) (postbound.qal.InPredicate property)

ValuesTableSource (class in postbound.qal) ValuesWithQuery (class in postbound.qal) Version (class in postbound.util) (class in postbound.util.misc) virtual (postbound.TableReference property) VirtualTablesPreCheck (class in postbound.validation) VisitorResult (class in postbound.relalg)

W

Where (class in postbound.qal) where_clause (postbound.qal.SetQuery property) (postbound.SqlQuery property) window_function (postbound.qal.WindowExpression property) WindowExpression (class in postbound.qal) with_actual_card() (postbound.QueryPlan method) with_alias() (postbound.TableReference method) with_all_passed() (postbound.validation.PreCheckResult static method) with_estimates() (postbound.QueryPlan method) with_failure() (postbound.validation.PreCheckResult method) with_labels() (postbound.Workload method) with_prefix() (postbound.Workload method)

WithQuery (class in postbound.qal) Workload (class in postbound) workload_fit_completed() (postbound.OptimizationStage method) WorkloadShifter (class in postbound.postgres) wrap() (postbound.qal.SimpleFilter static method) (postbound.qal.SimpleJoin static method) (postbound.util.misc.Version static method) (postbound.util.Version static method) wrap_all() (postbound.qal.SimpleFilter static method) (postbound.qal.SimpleJoin static method) wrap_workload() (in module postbound.workloads) write_df() (in module postbound.util)