diff options
| -rw-r--r-- | src/test/regress/expected/select.out | 23 | ||||
| -rw-r--r-- | src/test/regress/sql/select.sql | 3 |
2 files changed, 20 insertions, 6 deletions
diff --git a/src/test/regress/expected/select.out b/src/test/regress/expected/select.out index ef9e1c5129..6fcac88bf9 100644 --- a/src/test/regress/expected/select.out +++ b/src/test/regress/expected/select.out @@ -759,15 +759,26 @@ select * from onek2 where unique2 = 11 and stringu1 = 'ATAAAA'; 494 | 11 | 0 | 2 | 4 | 14 | 4 | 94 | 94 | 494 | 494 | 8 | 9 | ATAAAA | LAAAAA | VVVVxx (1 row) +-- get the plan for the following query +explain (costs off, timing off, summary off) +select * from onek2 where unique2 = 11 and stringu1 = 'ATAAAA'; + QUERY PLAN +----------------------------------------------- + Remote Fast Query Execution + Node/s: datanode_1, datanode_2 + -> Index Scan using onek2_u2_prtl on onek2 + Index Cond: (unique2 = 11) + Filter: (stringu1 = 'ATAAAA'::name) +(5 rows) + -- actually run the query with an analyze to use the partial index explain (costs off, analyze on, timing off, summary off) select * from onek2 where unique2 = 11 and stringu1 = 'ATAAAA'; - QUERY PLAN ------------------------------------------------------------------ - Index Scan using onek2_u2_prtl on onek2 (actual rows=1 loops=1) - Index Cond: (unique2 = 11) - Filter: (stringu1 = 'ATAAAA'::name) -(3 rows) + QUERY PLAN +----------------------------------------------------- + Remote Fast Query Execution (actual rows=1 loops=1) + Node/s: datanode_1, datanode_2 +(2 rows) explain (costs off) select unique2 from onek2 where unique2 = 11 and stringu1 = 'ATAAAA'; diff --git a/src/test/regress/sql/select.sql b/src/test/regress/sql/select.sql index a2f29e49d5..c9c84fdfea 100644 --- a/src/test/regress/sql/select.sql +++ b/src/test/regress/sql/select.sql @@ -201,6 +201,9 @@ SELECT * FROM foo ORDER BY f1 DESC NULLS LAST; explain (costs off) select * from onek2 where unique2 = 11 and stringu1 = 'ATAAAA'; select * from onek2 where unique2 = 11 and stringu1 = 'ATAAAA'; +-- get the plan for the following query +explain (costs off, timing off, summary off) +select * from onek2 where unique2 = 11 and stringu1 = 'ATAAAA'; -- actually run the query with an analyze to use the partial index explain (costs off, analyze on, timing off, summary off) select * from onek2 where unique2 = 11 and stringu1 = 'ATAAAA'; |