/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
contrib/pg_plan_advice/sql/prepared.sql
36 строк
1 KB
Robert Haas
pg_plan_advice: Fix multiple copy-and-paste-errors in test case.
19 мар 2026, 01:24
19 мар 2026, 01:24
b335fe5
Код
Авторство
О чём код?
LOAD 'pg_plan_advice'; SET max_parallel_workers_per_gather = 0; CREATE TABLE ptab (id integer, val text) WITH (autovacuum_enabled = false); SET pg_plan_advice.always_store_advice_details = false; -- Not prepared, so advice should be generated. EXPLAIN (COSTS OFF, PLAN_ADVICE) SELECT * FROM ptab; -- Prepared, so advice should not be generated. PREPARE pt1 AS SELECT * FROM ptab; EXPLAIN (COSTS OFF, PLAN_ADVICE) EXECUTE pt1; SET pg_plan_advice.always_store_advice_details = true; -- Prepared, but always_store_advice_details = true, so should show advice. PREPARE pt2 AS SELECT * FROM ptab; EXPLAIN (COSTS OFF, PLAN_ADVICE) EXECUTE pt2; -- Not prepared, so feedback should be generated. SET pg_plan_advice.always_store_advice_details = false; SET pg_plan_advice.advice = 'SEQ_SCAN(ptab)'; EXPLAIN (COSTS OFF) SELECT * FROM ptab; -- Prepared, so feedback should not be generated. PREPARE pt3 AS SELECT * FROM ptab; EXPLAIN (COSTS OFF) EXECUTE pt3; SET pg_plan_advice.always_store_advice_details = true; -- Prepared, but always_store_advice_details = true, so should show feedback. PREPARE pt4 AS SELECT * FROM ptab; EXPLAIN (COSTS OFF, PLAN_ADVICE) EXECUTE pt4;