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

Commitb592bd4

Browse files
committed
pathman: tests
1 parent29da3f5 commitb592bd4

File tree

2 files changed

+14
-18
lines changed

2 files changed

+14
-18
lines changed

‎contrib/pg_pathman/expected/pg_pathman.out

Lines changed: 14 additions & 16 deletions
Original file line numberDiff line numberDiff line change
@@ -428,37 +428,35 @@ EXPLAIN (COSTS OFF) SELECT * FROM test.range_rel_1 UNION ALL SELECT * FROM test.
428428
/*
429429
* Join
430430
*/
431-
SET enable_indexscan = OFF;
432431
EXPLAIN (COSTS OFF)
433432
SELECT * FROM test.range_rel j1
434433
JOIN test.range_rel j2 on j2.id = j1.id
435434
JOIN test.num_range_rel j3 on j3.id = j1.id
436435
WHERE j1.dt < '2015-03-01' AND j2.dt >= '2015-02-01' ORDER BY j2.dt;
437-
QUERY PLAN
438-
---------------------------------------------------------------------------------
436+
QUERY PLAN
437+
---------------------------------------------------------------------------------------
439438
Sort
440439
Sort Key: j2.dt
441-
->Nested Loop
442-
Join Filter: (j1.id = j2.id)
443-
->Nested Loop
444-
Join Filter: (j1.id =j3.id)
440+
->Hash Join
441+
Hash Cond: (j1.id = j2.id)
442+
->Hash Join
443+
Hash Cond: (j3.id =j1.id)
445444
-> Append
446-
->Seq Scan on num_range_rel_1 j3
447-
->Seq Scan on num_range_rel_2 j3_1
448-
->Seq Scan on num_range_rel_3 j3_2
449-
->Seq Scan on num_range_rel_4 j3_3
450-
->Materialize
445+
->Index Scan using num_range_rel_1_pkey on num_range_rel_1 j3
446+
->Index Scan using num_range_rel_2_pkey on num_range_rel_2 j3_1
447+
->Index Scan using num_range_rel_3_pkey on num_range_rel_3 j3_2
448+
->Index Scan using num_range_rel_4_pkey on num_range_rel_4 j3_3
449+
->Hash
451450
-> Append
452-
->Seq Scan on range_rel_1 j1
453-
->Seq Scan on range_rel_2 j1_1
454-
->Materialize
451+
->Index Scan using range_rel_1_pkey on range_rel_1 j1
452+
->Index Scan using range_rel_2_pkey on range_rel_2 j1_1
453+
->Hash
455454
-> Append
456455
-> Index Scan using range_rel_2_dt_idx on range_rel_2 j2
457456
-> Index Scan using range_rel_3_dt_idx on range_rel_3 j2_1
458457
-> Index Scan using range_rel_4_dt_idx on range_rel_4 j2_2
459458
(20 rows)
460459

461-
SET enable_indexscan = ON;
462460
/*
463461
* Test CTE query
464462
*/

‎contrib/pg_pathman/sql/pg_pathman.sql

Lines changed: 0 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -107,13 +107,11 @@ EXPLAIN (COSTS OFF) SELECT * FROM test.range_rel_1 UNION ALL SELECT * FROM test.
107107
/*
108108
* Join
109109
*/
110-
SET enable_indexscan= OFF;
111110
EXPLAIN (COSTS OFF)
112111
SELECT*FROMtest.range_rel j1
113112
JOINtest.range_rel j2onj2.id=j1.id
114113
JOINtest.num_range_rel j3onj3.id=j1.id
115114
WHEREj1.dt<'2015-03-01'ANDj2.dt>='2015-02-01'ORDER BYj2.dt;
116-
SET enable_indexscan=ON;
117115

118116
/*
119117
* Test CTE query

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp