Index_advisor is a tool to recommend indexes for workload. A workload consists of a set of SQL data manipulation statements, i.e., Select, Insert, Delete and Update. First, some candidate indexes are generated based on query syntax and database statistics. Then the optimal index set is determined by estimating the cost and benefit of it for the workload.
Document Link: https://opengauss.org/en/docs/3.0.0/docs/Developerguide/workload-level-index-recommendation.html
Origin Repository Link: gitee.com/opengauss/openGauss-server/tree/master/src/gausskernel/dbmind/tools/components/index_advisor/
python index_advisor_workload.py [p PORT] [d DATABASE] [f FILE] [--h HOST] [-U USERNAME]
[-W PASSWORD] [--schema SCHEMA] [--max_index_num MAX_INDEX_NUM] [--max_index_storage MAX_INDEX_STORAGE]
[--multi_iter_mode] [--multi_node] [--json] [--driver] [--show_detail]
extract_log is a tool for extracting business data from pg_log.
python extract_log.py [l LOG_DIRECTORY] [f OUTPUT_FILE] [-d DATABASE] [-U USERNAME] [--start_time]
[--sql_amount] [--statement] [--json]
python3.x
@inproceedings{autoindex2022,
author = {Xuanhe Zhou and Luyang Liu and Wenbo Li and Lianyuan Jin and Shifu Li and Tianqing Wang and Jianhua Feng},
title = {AutoIndex: An Incremental Index Management System for Dynamic Workloads},
booktitle = {ICDE},
year = {2022}}