- Notifications
You must be signed in to change notification settings - Fork5
Commitd4382c4
committed
Extend EXPLAIN to allow generic options to be specified.
The original syntax made it difficult to add options without making theminto reserved words. This change parenthesizes the options to avoid thatproblem, and makes provision for an explicit (and perhaps non-Boolean)value for each option. The original syntax is still supported, but onlyfor the two original options ANALYZE and VERBOSE.As a test case, add a COSTS option that can suppress the planner costestimates. This may be useful for including EXPLAIN output in the regressiontests, which are otherwise unable to cope with cross-platform variations incost estimates.Robert Haas1 parenta07e5ac commitd4382c4
File tree
12 files changed
+282
-156
lines changed- contrib/auto_explain
- doc/src/sgml/ref
- src
- backend
- commands
- nodes
- parser
- tcop
- include
- commands
- nodes
12 files changed
+282
-156
lines changedLines changed: 11 additions & 10 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
6 | 6 |
| |
7 | 7 |
| |
8 | 8 |
| |
9 |
| - | |
| 9 | + | |
10 | 10 |
| |
11 | 11 |
| |
12 | 12 |
| |
| |||
196 | 196 |
| |
197 | 197 |
| |
198 | 198 |
| |
199 |
| - | |
| 199 | + | |
200 | 200 |
| |
201 |
| - | |
202 |
| - | |
203 |
| - | |
204 |
| - | |
| 201 | + | |
| 202 | + | |
| 203 | + | |
| 204 | + | |
| 205 | + | |
205 | 206 |
| |
206 | 207 |
| |
207 |
| - | |
208 |
| - | |
| 208 | + | |
| 209 | + | |
209 | 210 |
| |
210 | 211 |
| |
211 | 212 |
| |
| |||
215 | 216 |
| |
216 | 217 |
| |
217 | 218 |
| |
218 |
| - | |
| 219 | + | |
219 | 220 |
| |
220 |
| - | |
| 221 | + | |
221 | 222 |
| |
222 | 223 |
| |
223 | 224 |
| |
|
Lines changed: 53 additions & 11 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
1 | 1 |
| |
2 |
| - | |
| 2 | + | |
3 | 3 |
| |
4 | 4 |
| |
5 | 5 |
| |
| |||
31 | 31 |
| |
32 | 32 |
| |
33 | 33 |
| |
| 34 | + | |
34 | 35 |
| |
35 | 36 |
| |
36 | 37 |
| |
| |||
89 | 90 |
| |
90 | 91 |
| |
91 | 92 |
| |
| 93 | + | |
| 94 | + | |
| 95 | + | |
| 96 | + | |
| 97 | + | |
| 98 | + | |
| 99 | + | |
| 100 | + | |
92 | 101 |
| |
93 | 102 |
| |
94 | 103 |
| |
| |||
99 | 108 |
| |
100 | 109 |
| |
101 | 110 |
| |
102 |
| - | |
| 111 | + | |
| 112 | + | |
103 | 113 |
| |
104 | 114 |
| |
105 | 115 |
| |
| |||
108 | 118 |
| |
109 | 119 |
| |
110 | 120 |
| |
111 |
| - | |
| 121 | + | |
| 122 | + | |
| 123 | + | |
| 124 | + | |
| 125 | + | |
| 126 | + | |
| 127 | + | |
| 128 | + | |
| 129 | + | |
| 130 | + | |
| 131 | + | |
| 132 | + | |
| 133 | + | |
| 134 | + | |
| 135 | + | |
| 136 | + | |
| 137 | + | |
| 138 | + | |
| 139 | + | |
| 140 | + | |
| 141 | + | |
| 142 | + | |
| 143 | + | |
| 144 | + | |
| 145 | + | |
| 146 | + | |
| 147 | + | |
112 | 148 |
| |
113 | 149 |
| |
114 | 150 |
| |
| |||
149 | 185 |
| |
150 | 186 |
| |
151 | 187 |
| |
152 |
| - | |
153 |
| - | |
154 |
| - | |
155 |
| - | |
156 |
| - | |
157 |
| - | |
158 |
| - | |
159 |
| - | |
160 | 188 |
| |
161 | 189 |
| |
162 | 190 |
| |
| |||
201 | 229 |
| |
202 | 230 |
| |
203 | 231 |
| |
| 232 | + | |
| 233 | + | |
| 234 | + | |
| 235 | + | |
| 236 | + | |
| 237 | + | |
| 238 | + | |
| 239 | + | |
| 240 | + | |
| 241 | + | |
| 242 | + | |
| 243 | + | |
| 244 | + | |
| 245 | + | |
204 | 246 |
| |
205 | 247 |
| |
206 | 248 |
| |
|
Lines changed: 10 additions & 3 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
9 | 9 |
| |
10 | 10 |
| |
11 | 11 |
| |
12 |
| - | |
| 12 | + | |
13 | 13 |
| |
14 | 14 |
| |
15 | 15 |
| |
| |||
133 | 133 |
| |
134 | 134 |
| |
135 | 135 |
| |
136 |
| - | |
| 136 | + | |
137 | 137 |
| |
138 | 138 |
| |
139 | 139 |
| |
| |||
153 | 153 |
| |
154 | 154 |
| |
155 | 155 |
| |
| 156 | + | |
| 157 | + | |
| 158 | + | |
| 159 | + | |
156 | 160 |
| |
157 | 161 |
| |
158 | 162 |
| |
159 | 163 |
| |
160 |
| - | |
| 164 | + | |
| 165 | + | |
| 166 | + | |
| 167 | + | |
161 | 168 |
| |
162 | 169 |
| |
163 | 170 |
| |
|
0 commit comments
Comments
(0)