Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

[PGPRO-4997] Integrated two vanilla commits for EXPLAIN correction (v…#258

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to ourterms of service andprivacy statement. We’ll occasionally send you account related emails.

Already on GitHub?Sign in to your account

Merged
kovdb75 merged 1 commit intomasterfromPGPRO-4997
Dec 14, 2022
Merged
Show file tree
Hide file tree
Changes fromall commits
Commits
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
2,398 changes: 2,398 additions & 0 deletionsexpected/pathman_array_qual_2.out
View file
Open in desktop

Large diffs are not rendered by default.

364 changes: 182 additions & 182 deletionsexpected/pathman_basic_2.out
View file
Open in desktop

Large diffs are not rendered by default.

48 changes: 24 additions & 24 deletionsexpected/pathman_calamity_2.out
View file
Open in desktop
Original file line numberDiff line numberDiff line change
Expand Up@@ -603,25 +603,25 @@ NOTICE: merging column "val" with inherited definition
SELECT add_to_pathman_config('calamity.part_test', 'val');
ERROR: constraint "pathman_wrong_partition_check" of partition "wrong_partition" does not exist
EXPLAIN (COSTS OFF) SELECT * FROM calamity.part_ok; /* check that pathman is enabled */
QUERY PLAN
-----------------------------
QUERY PLAN
---------------------------------------
Append
-> Seq Scan on part_ok_0
-> Seq Scan on part_ok_1
-> Seq Scan on part_ok_2
-> Seq Scan on part_ok_3
-> Seq Scan on part_ok_0 part_ok_1
-> Seq Scan on part_ok_1 part_ok_2
-> Seq Scan on part_ok_2 part_ok_3
-> Seq Scan on part_ok_3 part_ok_4
(5 rows)

SELECT add_to_pathman_config('calamity.part_test', 'val', '10');
ERROR: constraint "pathman_wrong_partition_check" of partition "wrong_partition" does not exist
EXPLAIN (COSTS OFF) SELECT * FROM calamity.part_ok; /* check that pathman is enabled */
QUERY PLAN
-----------------------------
QUERY PLAN
---------------------------------------
Append
-> Seq Scan on part_ok_0
-> Seq Scan on part_ok_1
-> Seq Scan on part_ok_2
-> Seq Scan on part_ok_3
-> Seq Scan on part_ok_0 part_ok_1
-> Seq Scan on part_ok_1 part_ok_2
-> Seq Scan on part_ok_2 part_ok_3
-> Seq Scan on part_ok_3 part_ok_4
(5 rows)

ALTER TABLE calamity.wrong_partition
Expand All@@ -630,13 +630,13 @@ CHECK (val = 1 OR val = 2); /* wrong constraint */
SELECT add_to_pathman_config('calamity.part_test', 'val', '10');
ERROR: wrong constraint format for RANGE partition "wrong_partition"
EXPLAIN (COSTS OFF) SELECT * FROM calamity.part_ok; /* check that pathman is enabled */
QUERY PLAN
-----------------------------
QUERY PLAN
---------------------------------------
Append
-> Seq Scan on part_ok_0
-> Seq Scan on part_ok_1
-> Seq Scan on part_ok_2
-> Seq Scan on part_ok_3
-> Seq Scan on part_ok_0 part_ok_1
-> Seq Scan on part_ok_1 part_ok_2
-> Seq Scan on part_ok_2 part_ok_3
-> Seq Scan on part_ok_3 part_ok_4
(5 rows)

ALTER TABLE calamity.wrong_partition DROP CONSTRAINT pathman_wrong_partition_check;
Expand All@@ -646,13 +646,13 @@ CHECK (val >= 10 AND val = 2); /* wrong constraint */
SELECT add_to_pathman_config('calamity.part_test', 'val', '10');
ERROR: wrong constraint format for RANGE partition "wrong_partition"
EXPLAIN (COSTS OFF) SELECT * FROM calamity.part_ok; /* check that pathman is enabled */
QUERY PLAN
-----------------------------
QUERY PLAN
---------------------------------------
Append
-> Seq Scan on part_ok_0
-> Seq Scan on part_ok_1
-> Seq Scan on part_ok_2
-> Seq Scan on part_ok_3
-> Seq Scan on part_ok_0 part_ok_1
-> Seq Scan on part_ok_1 part_ok_2
-> Seq Scan on part_ok_2 part_ok_3
-> Seq Scan on part_ok_3 part_ok_4
(5 rows)

ALTER TABLE calamity.wrong_partition DROP CONSTRAINT pathman_wrong_partition_check;
Expand Down
48 changes: 24 additions & 24 deletionsexpected/pathman_calamity_3.out
View file
Open in desktop
Original file line numberDiff line numberDiff line change
Expand Up@@ -607,25 +607,25 @@ NOTICE: merging column "val" with inherited definition
SELECT add_to_pathman_config('calamity.part_test', 'val');
ERROR: constraint "pathman_wrong_partition_check" of partition "wrong_partition" does not exist
EXPLAIN (COSTS OFF) SELECT * FROM calamity.part_ok; /* check that pathman is enabled */
QUERY PLAN
-----------------------------
QUERY PLAN
---------------------------------------
Append
-> Seq Scan on part_ok_0
-> Seq Scan on part_ok_1
-> Seq Scan on part_ok_2
-> Seq Scan on part_ok_3
-> Seq Scan on part_ok_0 part_ok_1
-> Seq Scan on part_ok_1 part_ok_2
-> Seq Scan on part_ok_2 part_ok_3
-> Seq Scan on part_ok_3 part_ok_4
(5 rows)

SELECT add_to_pathman_config('calamity.part_test', 'val', '10');
ERROR: constraint "pathman_wrong_partition_check" of partition "wrong_partition" does not exist
EXPLAIN (COSTS OFF) SELECT * FROM calamity.part_ok; /* check that pathman is enabled */
QUERY PLAN
-----------------------------
QUERY PLAN
---------------------------------------
Append
-> Seq Scan on part_ok_0
-> Seq Scan on part_ok_1
-> Seq Scan on part_ok_2
-> Seq Scan on part_ok_3
-> Seq Scan on part_ok_0 part_ok_1
-> Seq Scan on part_ok_1 part_ok_2
-> Seq Scan on part_ok_2 part_ok_3
-> Seq Scan on part_ok_3 part_ok_4
(5 rows)

ALTER TABLE calamity.wrong_partition
Expand All@@ -634,13 +634,13 @@ CHECK (val = 1 OR val = 2); /* wrong constraint */
SELECT add_to_pathman_config('calamity.part_test', 'val', '10');
ERROR: wrong constraint format for RANGE partition "wrong_partition"
EXPLAIN (COSTS OFF) SELECT * FROM calamity.part_ok; /* check that pathman is enabled */
QUERY PLAN
-----------------------------
QUERY PLAN
---------------------------------------
Append
-> Seq Scan on part_ok_0
-> Seq Scan on part_ok_1
-> Seq Scan on part_ok_2
-> Seq Scan on part_ok_3
-> Seq Scan on part_ok_0 part_ok_1
-> Seq Scan on part_ok_1 part_ok_2
-> Seq Scan on part_ok_2 part_ok_3
-> Seq Scan on part_ok_3 part_ok_4
(5 rows)

ALTER TABLE calamity.wrong_partition DROP CONSTRAINT pathman_wrong_partition_check;
Expand All@@ -650,13 +650,13 @@ CHECK (val >= 10 AND val = 2); /* wrong constraint */
SELECT add_to_pathman_config('calamity.part_test', 'val', '10');
ERROR: wrong constraint format for RANGE partition "wrong_partition"
EXPLAIN (COSTS OFF) SELECT * FROM calamity.part_ok; /* check that pathman is enabled */
QUERY PLAN
-----------------------------
QUERY PLAN
---------------------------------------
Append
-> Seq Scan on part_ok_0
-> Seq Scan on part_ok_1
-> Seq Scan on part_ok_2
-> Seq Scan on part_ok_3
-> Seq Scan on part_ok_0 part_ok_1
-> Seq Scan on part_ok_1 part_ok_2
-> Seq Scan on part_ok_2 part_ok_3
-> Seq Scan on part_ok_3 part_ok_4
(5 rows)

ALTER TABLE calamity.wrong_partition DROP CONSTRAINT pathman_wrong_partition_check;
Expand Down
10 changes: 5 additions & 5 deletionsexpected/pathman_cte_2.out
View file
Open in desktop
Original file line numberDiff line numberDiff line change
Expand Up@@ -29,8 +29,8 @@ SELECT * FROM ttt;
QUERY PLAN
--------------------------------------------------------------------------------
Append
-> Seq Scan on range_rel_2
-> Seq Scan on range_rel_3
-> Seq Scan on range_rel_2 range_rel_1
-> Seq Scan on range_rel_3 range_rel_2
Filter: (dt < 'Sun Mar 15 00:00:00 2015'::timestamp without time zone)
(4 rows)

Expand All@@ -52,9 +52,9 @@ SELECT create_hash_partitions('test_cte.hash_rel', 'value', 3);
EXPLAIN (COSTS OFF)
WITH ttt AS (SELECT * FROM test_cte.hash_rel WHERE value = 2)
SELECT * FROM ttt;
QUERY PLAN
------------------------
Seq Scan on hash_rel_1
QUERY PLAN
---------------------------------
Seq Scan on hash_rel_1 hash_rel
Filter: (value = 2)
(2 rows)

Expand Down
Loading
[8]ページ先頭
©2009-2025 Movatter.jp