diff --git a/expected/pg_hint_plan.out b/expected/pg_hint_plan.out index 2757225..92ea7ed 100644 --- a/expected/pg_hint_plan.out +++ b/expected/pg_hint_plan.out @@ -9106,6 +9106,12 @@ error hint: Sort Key: t3.id -> Seq Scan on t3 (cost=xxx..xxx rows=100 width=xxx) +SELECT reset_stats_and_wait(); + reset_stats_and_wait +---------------------- + +(1 row) + \o results/pg_hint_plan.tmpout /*+ Rows(t1 t3 *10) */ EXPLAIN SELECT * FROM t1 JOIN t2 ON (t1.id = t2.id) JOIN t3 ON (t3.id = t2.id); @@ -9132,6 +9138,12 @@ set max_parallel_workers_per_gather to DEFAULT; -> Seq Scan on t3 (cost=xxx..xxx rows=100 width=xxx) \! rm results/pg_hint_plan.tmpout +SELECT pg_sleep(1); + pg_sleep +---------- + +(1 row) + -- Query with join RTE and outer-join relids /*+Leading(ft_1 ft_2 t1)*/ SELECT relname, seq_scan > 0 AS seq_scan, idx_scan > 0 AS idx_scan @@ -9145,7 +9157,7 @@ error hint: relname | seq_scan | idx_scan ---------+----------+---------- - t1 | f | f + t1 | f | t (1 row) -- hint error level diff --git a/sql/pg_hint_plan.sql b/sql/pg_hint_plan.sql index 67c54a8..6d9dbad 100644 --- a/sql/pg_hint_plan.sql +++ b/sql/pg_hint_plan.sql @@ -1152,6 +1152,7 @@ EXPLAIN SELECT * FROM t1 JOIN t2 ON (t1.id = t2.id) JOIN t3 ON (t3.id = t2.id); \o \! sql/maskout.sh results/pg_hint_plan.tmpout +SELECT reset_stats_and_wait(); \o results/pg_hint_plan.tmpout /*+ Rows(t1 t3 *10) */ EXPLAIN SELECT * FROM t1 JOIN t2 ON (t1.id = t2.id) JOIN t3 ON (t3.id = t2.id); @@ -1160,6 +1161,7 @@ set max_parallel_workers_per_gather to DEFAULT; \! sql/maskout.sh results/pg_hint_plan.tmpout \! rm results/pg_hint_plan.tmpout +SELECT pg_sleep(1); -- Query with join RTE and outer-join relids /*+Leading(ft_1 ft_2 t1)*/ SELECT relname, seq_scan > 0 AS seq_scan, idx_scan > 0 AS idx_scan