2 SET pg_hint_plan.enable_hint TO on;
3 SET pg_hint_plan.debug_print TO on;
4 SET client_min_messages TO LOG;
5 SET search_path TO public;
8 ---- No. A-8-1 hint state output
11 PREPARE p1 AS SELECT * FROM s1.t1 WHERE t1.c1 = 1;
12 EXPLAIN (COSTS false) CREATE TABLE test AS EXECUTE p1;
15 PREPARE p1 AS SELECT * FROM s1.t1 WHERE t1.c1 < $1;
16 EXPLAIN (COSTS false) CREATE TABLE test AS EXECUTE p1 (1);
22 PREPARE p1 AS SELECT * FROM s1.t1 WHERE t1.c1 = 1;
24 EXPLAIN (COSTS false) CREATE TABLE test AS EXECUTE p1;
25 UPDATE pg_catalog.pg_class SET relpages = relpages WHERE relname = 't1';
27 EXPLAIN (COSTS false) CREATE TABLE test AS EXECUTE p1;
31 PREPARE p1 AS SELECT * FROM s1.t1 WHERE t1.c1 < $1;
33 EXPLAIN (COSTS false) CREATE TABLE test AS EXECUTE p1 (1000);
35 EXPLAIN (COSTS false) CREATE TABLE test AS EXECUTE p1 (1000);
37 EXPLAIN (COSTS false) CREATE TABLE test AS EXECUTE p1 (1000);
39 EXPLAIN (COSTS false) CREATE TABLE test AS EXECUTE p1 (1000);
41 EXPLAIN (COSTS false) CREATE TABLE test AS EXECUTE p1 (1000);
43 EXPLAIN (COSTS false) CREATE TABLE test AS EXECUTE p1 (1000);
44 UPDATE pg_catalog.pg_class SET relpages = relpages WHERE relname = 't1';
46 EXPLAIN (COSTS false) CREATE TABLE test AS EXECUTE p1 (1000);
52 PREPARE p1 AS SELECT * FROM s1.t1 WHERE t1.c1 = 1;
53 EXPLAIN (COSTS false) CREATE TABLE test AS EXECUTE p1;
54 UPDATE pg_catalog.pg_class SET relpages = relpages WHERE relname = 't1';
55 EXPLAIN (COSTS false) CREATE TABLE test AS EXECUTE p1;
59 PREPARE p1 AS SELECT * FROM s1.t1 WHERE t1.c1 < $1;
60 EXPLAIN (COSTS false) CREATE TABLE test AS EXECUTE p1 (1000);
61 EXPLAIN (COSTS false) CREATE TABLE test AS EXECUTE p1 (1000);
62 EXPLAIN (COSTS false) CREATE TABLE test AS EXECUTE p1 (1000);
63 EXPLAIN (COSTS false) CREATE TABLE test AS EXECUTE p1 (1000);
64 EXPLAIN (COSTS false) CREATE TABLE test AS EXECUTE p1 (1000);
65 EXPLAIN (COSTS false) CREATE TABLE test AS EXECUTE p1 (1000);
66 UPDATE pg_catalog.pg_class SET relpages = relpages WHERE relname = 't1';
67 EXPLAIN (COSTS false) CREATE TABLE test AS EXECUTE p1 (1000);
72 PREPARE p1 AS SELECT * FROM s1.t1 WHERE t1.c1 = 1;
74 EXPLAIN (COSTS false) CREATE TABLE test AS EXECUTE p1;
75 UPDATE pg_catalog.pg_class SET relpages = relpages WHERE relname = 't1';
77 EXPLAIN (COSTS false) CREATE TABLE test AS EXECUTE p1;
80 PREPARE p1 AS SELECT * FROM s1.t1 WHERE t1.c1 < $1;
82 EXPLAIN (COSTS false) CREATE TABLE test AS EXECUTE p1 (1000);
84 EXPLAIN (COSTS false) CREATE TABLE test AS EXECUTE p1 (1000);
86 EXPLAIN (COSTS false) CREATE TABLE test AS EXECUTE p1 (1000);
88 EXPLAIN (COSTS false) CREATE TABLE test AS EXECUTE p1 (1000);
90 EXPLAIN (COSTS false) CREATE TABLE test AS EXECUTE p1 (1000);
92 EXPLAIN (COSTS false) CREATE TABLE test AS EXECUTE p1 (1000);
93 UPDATE pg_catalog.pg_class SET relpages = relpages WHERE relname = 't1';
95 EXPLAIN (COSTS false) CREATE TABLE test AS EXECUTE p1 (1000);