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

Commit3d14c17

Browse files
committed
Doc: tweak examples to silence line-too-long PDF build warnings.
In one or two places it seemed reasonable to modify the example so asto shorten its output slightly; but for the most part I just added a&zwsp; after 67 characters, which is the most we can fit on a lineof monospace text in A4 format.Discussion:https://postgr.es/m/6916.1589146280@sss.pgh.pa.us
1 parent5cbfce5 commit3d14c17

File tree

12 files changed

+68
-68
lines changed

12 files changed

+68
-68
lines changed

‎doc/src/sgml/bloom.sgml

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -131,7 +131,7 @@ CREATE INDEX
131131
<programlisting>
132132
=# EXPLAIN ANALYZE SELECT * FROM tbloom WHERE i2 = 898732 AND i5 = 123451;
133133
QUERY PLAN
134-
------------------------------------------------------------------------------------------------------------
134+
-------------------------------------------------------------------&zwsp;-----------------------------------------
135135
Seq Scan on tbloom (cost=0.00..213694.08 rows=1 width=24) (actual time=1445.438..1445.438 rows=0 loops=1)
136136
Filter: ((i2 = 898732) AND (i5 = 123451))
137137
Rows Removed by Filter: 10000000
@@ -147,7 +147,7 @@ CREATE INDEX
147147
<programlisting>
148148
=# EXPLAIN ANALYZE SELECT * FROM tbloom WHERE i2 = 898732 AND i5 = 123451;
149149
QUERY PLAN
150-
--------------------------------------------------------------------------------------------------------------------------------
150+
-------------------------------------------------------------------&zwsp;-------------------------------------------------------------
151151
Index Only Scan using btreeidx on tbloom (cost=0.56..298311.96 rows=1 width=24) (actual time=445.709..445.709 rows=0 loops=1)
152152
Index Cond: ((i2 = 898732) AND (i5 = 123451))
153153
Heap Fetches: 0
@@ -162,7 +162,7 @@ CREATE INDEX
162162
<programlisting>
163163
=# EXPLAIN ANALYZE SELECT * FROM tbloom WHERE i2 = 898732 AND i5 = 123451;
164164
QUERY PLAN
165-
---------------------------------------------------------------------------------------------------------------------------
165+
-------------------------------------------------------------------&zwsp;--------------------------------------------------------
166166
Bitmap Heap Scan on tbloom (cost=178435.39..178439.41 rows=1 width=24) (actual time=76.698..76.698 rows=0 loops=1)
167167
Recheck Cond: ((i2 = 898732) AND (i5 = 123451))
168168
Rows Removed by Index Recheck: 2439
@@ -189,7 +189,7 @@ CREATE INDEX
189189
<programlisting>
190190
=# EXPLAIN ANALYZE SELECT * FROM tbloom WHERE i2 = 898732 AND i5 = 123451;
191191
QUERY PLAN
192-
------------------------------------------------------------------------------------------------------------------------------
192+
-------------------------------------------------------------------&zwsp;-----------------------------------------------------------
193193
Bitmap Heap Scan on tbloom (cost=9.29..13.30 rows=1 width=24) (actual time=0.148..0.148 rows=0 loops=1)
194194
Recheck Cond: ((i5 = 123451) AND (i2 = 898732))
195195
-&gt; BitmapAnd (cost=9.29..9.29 rows=1 width=0) (actual time=0.145..0.145 rows=0 loops=1)

‎doc/src/sgml/datatype.sgml

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -4036,7 +4036,7 @@ SELECT $$the lexeme 'Joe''s' contains a quote$$::tsvector;
40364036
<programlisting>
40374037
SELECT 'a:1 fat:2 cat:3 sat:4 on:5 a:6 mat:7 and:8 ate:9 a:10 fat:11 rat:12'::tsvector;
40384038
tsvector
4039-
-------------------------------------------------------------------------------
4039+
-------------------------------------------------------------------&zwsp;------------
40404040
'a':1,6,10 'and':8 'ate':9 'cat':3 'fat':2,11 'mat':7 'on':5 'rat':12 'sat':4
40414041
</programlisting>
40424042

‎doc/src/sgml/ddl.sgml

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -4537,7 +4537,7 @@ SELECT count(*) FROM measurement WHERE logdate &gt;= DATE '2008-01-01';
45374537
SET enable_partition_pruning = off;
45384538
EXPLAIN SELECT count(*) FROM measurement WHERE logdate &gt;= DATE '2008-01-01';
45394539
QUERY PLAN
4540-
-----------------------------------------------------------------------------------
4540+
-------------------------------------------------------------------&zwsp;----------------
45414541
Aggregate (cost=188.76..188.77 rows=1 width=8)
45424542
-&gt; Append (cost=0.00..181.05 rows=3085 width=0)
45434543
-&gt; Seq Scan on measurement_y2006m02 (cost=0.00..33.12 rows=617 width=0)
@@ -4562,7 +4562,7 @@ EXPLAIN SELECT count(*) FROM measurement WHERE logdate &gt;= DATE '2008-01-01';
45624562
SET enable_partition_pruning = on;
45634563
EXPLAIN SELECT count(*) FROM measurement WHERE logdate &gt;= DATE '2008-01-01';
45644564
QUERY PLAN
4565-
-----------------------------------------------------------------------------------
4565+
-------------------------------------------------------------------&zwsp;----------------
45664566
Aggregate (cost=37.75..37.76 rows=1 width=8)
45674567
-&gt; Seq Scan on measurement_y2008m01 (cost=0.00..33.12 rows=617 width=0)
45684568
Filter: (logdate &gt;= '2008-01-01'::date)

‎doc/src/sgml/jit.sgml

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -147,7 +147,7 @@
147147
<screen>
148148
=# EXPLAIN ANALYZE SELECT SUM(relpages) FROM pg_class;
149149
QUERY PLAN
150-
-------------------------------------------------------------------------------------------------------------
150+
-------------------------------------------------------------------&zwsp;------------------------------------------
151151
Aggregate (cost=16.27..16.29 rows=1 width=8) (actual time=0.303..0.303 rows=1 loops=1)
152152
-> Seq Scan on pg_class (cost=0.00..15.42 rows=342 width=4) (actual time=0.017..0.111 rows=356 loops=1)
153153
Planning Time: 0.116 ms
@@ -163,7 +163,7 @@
163163
SET
164164
=# EXPLAIN ANALYZE SELECT SUM(relpages) FROM pg_class;
165165
QUERY PLAN
166-
-------------------------------------------------------------------------------------------------------------
166+
-------------------------------------------------------------------&zwsp;------------------------------------------
167167
Aggregate (cost=16.27..16.29 rows=1 width=8) (actual time=6.049..6.049 rows=1 loops=1)
168168
-> Seq Scan on pg_class (cost=0.00..15.42 rows=342 width=4) (actual time=0.019..0.052 rows=356 loops=1)
169169
Planning Time: 0.133 ms

‎doc/src/sgml/pageinspect.sgml

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -788,14 +788,14 @@ test=# SELECT * FROM hash_bitmap_info('con_hash_index', 2052);
788788
<listitem>
789789
<para>
790790
<function>hash_metapage_info</function> returns information stored
791-
in meta page of a <acronym>HASH</acronym> index. For example:
791+
inthemeta page of a <acronym>HASH</acronym> index. For example:
792792
<screen>
793793
test=# SELECT magic, version, ntuples, ffactor, bsize, bmsize, bmshift,
794794
test-# maxbucket, highmask, lowmask, ovflpoint, firstfree, nmaps, procid,
795795
test-# regexp_replace(spares::text, '(,0)*}', '}') as spares,
796796
test-# regexp_replace(mapp::text, '(,0)*}', '}') as mapp
797797
test-# FROM hash_metapage_info(get_raw_page('con_hash_index', 0));
798-
-[ RECORD 1 ]-------------------------------------------------------------------------------
798+
-[ RECORD 1 ]-------------------------------------------------&zwsp;------------------------------
799799
magic | 105121344
800800
version | 4
801801
ntuples | 500500
@@ -810,7 +810,7 @@ ovflpoint | 28
810810
firstfree | 1204
811811
nmaps | 1
812812
procid | 450
813-
spares | {0,0,0,0,0,0,1,1,1,1,1,1,1,1,3,4,4,4,45,55,58,59,508,567,628,704,1193,1202,1204}
813+
spares | {0,0,0,0,0,0,1,1,1,1,1,1,1,1,3,4,4,4,45,55,58,59,&zwsp;508,567,628,704,1193,1202,1204}
814814
mapp | {65}
815815
</screen>
816816
</para>

‎doc/src/sgml/parallel.sgml

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -34,7 +34,7 @@
3434
<screen>
3535
EXPLAIN SELECT * FROM pgbench_accounts WHERE filler LIKE '%x%';
3636
QUERY PLAN
37-
-------------------------------------------------------------------------------------
37+
-------------------------------------------------------------------&zwsp;------------------
3838
Gather (cost=1000.00..217018.43 rows=1 width=97)
3939
Workers Planned: 2
4040
-> Parallel Seq Scan on pgbench_accounts (cost=0.00..216018.33 rows=1 width=97)

‎doc/src/sgml/perform.sgml

Lines changed: 21 additions & 21 deletions
Original file line numberDiff line numberDiff line change
@@ -229,7 +229,7 @@ EXPLAIN SELECT * FROM tenk1 WHERE unique1 &lt; 7000;
229229
EXPLAIN SELECT * FROM tenk1 WHERE unique1 &lt; 100;
230230

231231
QUERY PLAN
232-
------------------------------------------------------------------------------
232+
-------------------------------------------------------------------&zwsp;-----------
233233
Bitmap Heap Scan on tenk1 (cost=5.07..229.20 rows=101 width=244)
234234
Recheck Cond: (unique1 &lt; 100)
235235
-&gt; Bitmap Index Scan on tenk1_unique1 (cost=0.00..5.04 rows=101 width=0)
@@ -256,7 +256,7 @@ EXPLAIN SELECT * FROM tenk1 WHERE unique1 &lt; 100;
256256
EXPLAIN SELECT * FROM tenk1 WHERE unique1 &lt; 100 AND stringu1 = 'xxx';
257257

258258
QUERY PLAN
259-
------------------------------------------------------------------------------
259+
-------------------------------------------------------------------&zwsp;-----------
260260
Bitmap Heap Scan on tenk1 (cost=5.04..229.43 rows=1 width=244)
261261
Recheck Cond: (unique1 &lt; 100)
262262
Filter: (stringu1 = 'xxx'::name)
@@ -280,7 +280,7 @@ EXPLAIN SELECT * FROM tenk1 WHERE unique1 &lt; 100 AND stringu1 = 'xxx';
280280
EXPLAIN SELECT * FROM tenk1 WHERE unique1 = 42;
281281

282282
QUERY PLAN
283-
-----------------------------------------------------------------------------
283+
-------------------------------------------------------------------&zwsp;----------
284284
Index Scan using tenk1_unique1 on tenk1 (cost=0.29..8.30 rows=1 width=244)
285285
Index Cond: (unique1 = 42)
286286
</screen>
@@ -318,7 +318,7 @@ EXPLAIN SELECT * FROM tenk1 ORDER BY unique1;
318318
<screen>
319319
EXPLAIN SELECT * FROM tenk1 ORDER BY four, ten LIMIT 100;
320320
QUERY PLAN
321-
------------------------------------------------------------------------------------------------------
321+
-------------------------------------------------------------------&zwsp;-----------------------------------
322322
Limit (cost=521.06..538.05 rows=100 width=244)
323323
-> Incremental Sort (cost=521.06..2220.95 rows=10000 width=244)
324324
Sort Key: four, ten
@@ -343,7 +343,7 @@ EXPLAIN SELECT * FROM tenk1 ORDER BY four, ten LIMIT 100;
343343
EXPLAIN SELECT * FROM tenk1 WHERE unique1 &lt; 100 AND unique2 &gt; 9000;
344344

345345
QUERY PLAN
346-
-------------------------------------------------------------------------------------
346+
-------------------------------------------------------------------&zwsp;------------------
347347
Bitmap Heap Scan on tenk1 (cost=25.08..60.21 rows=10 width=244)
348348
Recheck Cond: ((unique1 &lt; 100) AND (unique2 &gt; 9000))
349349
-&gt; BitmapAnd (cost=25.08..25.08 rows=10 width=0)
@@ -366,7 +366,7 @@ EXPLAIN SELECT * FROM tenk1 WHERE unique1 &lt; 100 AND unique2 &gt; 9000;
366366
EXPLAIN SELECT * FROM tenk1 WHERE unique1 &lt; 100 AND unique2 &gt; 9000 LIMIT 2;
367367

368368
QUERY PLAN
369-
-------------------------------------------------------------------------------------
369+
-------------------------------------------------------------------&zwsp;------------------
370370
Limit (cost=0.29..14.48 rows=2 width=244)
371371
-&gt; Index Scan using tenk1_unique2 on tenk1 (cost=0.29..71.27 rows=10 width=244)
372372
Index Cond: (unique2 &gt; 9000)
@@ -396,7 +396,7 @@ FROM tenk1 t1, tenk2 t2
396396
WHERE t1.unique1 &lt; 10 AND t1.unique2 = t2.unique2;
397397

398398
QUERY PLAN
399-
--------------------------------------------------------------------------------------
399+
-------------------------------------------------------------------&zwsp;-------------------
400400
Nested Loop (cost=4.65..118.62 rows=10 width=488)
401401
-&gt; Bitmap Heap Scan on tenk1 t1 (cost=4.36..39.47 rows=10 width=244)
402402
Recheck Cond: (unique1 &lt; 10)
@@ -445,7 +445,7 @@ FROM tenk1 t1, tenk2 t2
445445
WHERE t1.unique1 &lt; 10 AND t2.unique2 &lt; 10 AND t1.hundred &lt; t2.hundred;
446446

447447
QUERY PLAN
448-
---------------------------------------------------------------------------------------------
448+
-------------------------------------------------------------------&zwsp;--------------------------
449449
Nested Loop (cost=4.65..49.46 rows=33 width=488)
450450
Join Filter: (t1.hundred &lt; t2.hundred)
451451
-&gt; Bitmap Heap Scan on tenk1 t1 (cost=4.36..39.47 rows=10 width=244)
@@ -493,7 +493,7 @@ FROM tenk1 t1, tenk2 t2
493493
WHERE t1.unique1 &lt; 100 AND t1.unique2 = t2.unique2;
494494

495495
QUERY PLAN
496-
------------------------------------------------------------------------------------------
496+
-------------------------------------------------------------------&zwsp;-----------------------
497497
Hash Join (cost=230.47..713.98 rows=101 width=488)
498498
Hash Cond: (t2.unique2 = t1.unique2)
499499
-&gt; Seq Scan on tenk2 t2 (cost=0.00..445.00 rows=10000 width=244)
@@ -524,7 +524,7 @@ FROM tenk1 t1, onek t2
524524
WHERE t1.unique1 &lt; 100 AND t1.unique2 = t2.unique2;
525525

526526
QUERY PLAN
527-
------------------------------------------------------------------------------------------
527+
-------------------------------------------------------------------&zwsp;-----------------------
528528
Merge Join (cost=198.11..268.19 rows=10 width=488)
529529
Merge Cond: (t1.unique2 = t2.unique2)
530530
-&gt; Index Scan using tenk1_unique2 on tenk1 t1 (cost=0.29..656.28 rows=101 width=244)
@@ -562,7 +562,7 @@ FROM tenk1 t1, onek t2
562562
WHERE t1.unique1 &lt; 100 AND t1.unique2 = t2.unique2;
563563

564564
QUERY PLAN
565-
------------------------------------------------------------------------------------------
565+
-------------------------------------------------------------------&zwsp;-----------------------
566566
Merge Join (cost=0.56..292.65 rows=10 width=488)
567567
Merge Cond: (t1.unique2 = t2.unique2)
568568
-&gt; Index Scan using tenk1_unique2 on tenk1 t1 (cost=0.29..656.28 rows=101 width=244)
@@ -596,7 +596,7 @@ FROM tenk1 t1, tenk2 t2
596596
WHERE t1.unique1 &lt; 10 AND t1.unique2 = t2.unique2;
597597

598598
QUERY PLAN
599-
---------------------------------------------------------------------------------------------------------------------------------
599+
-------------------------------------------------------------------&zwsp;--------------------------------------------------------------
600600
Nested Loop (cost=4.65..118.62 rows=10 width=488) (actual time=0.128..0.377 rows=10 loops=1)
601601
-&gt; Bitmap Heap Scan on tenk1 t1 (cost=4.36..39.47 rows=10 width=244) (actual time=0.057..0.121 rows=10 loops=1)
602602
Recheck Cond: (unique1 &lt; 10)
@@ -640,7 +640,7 @@ FROM tenk1 t1, tenk2 t2
640640
WHERE t1.unique1 &lt; 100 AND t1.unique2 = t2.unique2 ORDER BY t1.fivethous;
641641

642642
QUERY PLAN
643-
--------------------------------------------------------------------------------------------------------------------------------------------
643+
-------------------------------------------------------------------&zwsp;-------------------------------------------------------------------&zwsp;------
644644
Sort (cost=717.34..717.59 rows=101 width=488) (actual time=7.761..7.774 rows=100 loops=1)
645645
Sort Key: t1.fivethous
646646
Sort Method: quicksort Memory: 77kB
@@ -673,7 +673,7 @@ WHERE t1.unique1 &lt; 100 AND t1.unique2 = t2.unique2 ORDER BY t1.fivethous;
673673
EXPLAIN ANALYZE SELECT * FROM tenk1 WHERE ten &lt; 7;
674674

675675
QUERY PLAN
676-
---------------------------------------------------------------------------------------------------------
676+
-------------------------------------------------------------------&zwsp;--------------------------------------
677677
Seq Scan on tenk1 (cost=0.00..483.00 rows=7000 width=244) (actual time=0.016..5.107 rows=7000 loops=1)
678678
Filter: (ten &lt; 7)
679679
Rows Removed by Filter: 3000
@@ -696,7 +696,7 @@ EXPLAIN ANALYZE SELECT * FROM tenk1 WHERE ten &lt; 7;
696696
EXPLAIN ANALYZE SELECT * FROM polygon_tbl WHERE f1 @&gt; polygon '(0.5,2.0)';
697697

698698
QUERY PLAN
699-
------------------------------------------------------------------------------------------------------
699+
-------------------------------------------------------------------&zwsp;-----------------------------------
700700
Seq Scan on polygon_tbl (cost=0.00..1.05 rows=1 width=32) (actual time=0.044..0.044 rows=0 loops=1)
701701
Filter: (f1 @&gt; '((0.5,2))'::polygon)
702702
Rows Removed by Filter: 4
@@ -715,7 +715,7 @@ SET enable_seqscan TO off;
715715
EXPLAIN ANALYZE SELECT * FROM polygon_tbl WHERE f1 @&gt; polygon '(0.5,2.0)';
716716

717717
QUERY PLAN
718-
--------------------------------------------------------------------------------------------------------------------------
718+
-------------------------------------------------------------------&zwsp;-------------------------------------------------------
719719
Index Scan using gpolygonind on polygon_tbl (cost=0.13..8.15 rows=1 width=32) (actual time=0.062..0.062 rows=0 loops=1)
720720
Index Cond: (f1 @&gt; '((0.5,2))'::polygon)
721721
Rows Removed by Index Recheck: 1
@@ -738,7 +738,7 @@ EXPLAIN ANALYZE SELECT * FROM polygon_tbl WHERE f1 @&gt; polygon '(0.5,2.0)';
738738
EXPLAIN (ANALYZE, BUFFERS) SELECT * FROM tenk1 WHERE unique1 &lt; 100 AND unique2 &gt; 9000;
739739

740740
QUERY PLAN
741-
---------------------------------------------------------------------------------------------------------------------------------
741+
-------------------------------------------------------------------&zwsp;--------------------------------------------------------------
742742
Bitmap Heap Scan on tenk1 (cost=25.08..60.21 rows=10 width=244) (actual time=0.323..0.342 rows=10 loops=1)
743743
Recheck Cond: ((unique1 &lt; 100) AND (unique2 &gt; 9000))
744744
Buffers: shared hit=15
@@ -772,7 +772,7 @@ BEGIN;
772772
EXPLAIN ANALYZE UPDATE tenk1 SET hundred = hundred + 1 WHERE unique1 &lt; 100;
773773

774774
QUERY PLAN
775-
--------------------------------------------------------------------------------------------------------------------------------
775+
-------------------------------------------------------------------&zwsp;-------------------------------------------------------------
776776
Update on tenk1 (cost=5.07..229.46 rows=101 width=250) (actual time=14.628..14.628 rows=0 loops=1)
777777
-&gt; Bitmap Heap Scan on tenk1 (cost=5.07..229.46 rows=101 width=250) (actual time=0.101..0.439 rows=100 loops=1)
778778
Recheck Cond: (unique1 &lt; 100)
@@ -808,7 +808,7 @@ ROLLBACK;
808808
<screen>
809809
EXPLAIN UPDATE parent SET f2 = f2 + 1 WHERE f1 = 101;
810810
QUERY PLAN
811-
-----------------------------------------------------------------------------------
811+
-------------------------------------------------------------------&zwsp;----------------
812812
Update on parent (cost=0.00..24.53 rows=4 width=14)
813813
Update on parent
814814
Update on child1
@@ -896,7 +896,7 @@ EXPLAIN UPDATE parent SET f2 = f2 + 1 WHERE f1 = 101;
896896
EXPLAIN ANALYZE SELECT * FROM tenk1 WHERE unique1 &lt; 100 AND unique2 &gt; 9000 LIMIT 2;
897897

898898
QUERY PLAN
899-
-------------------------------------------------------------------------------------------------------------------------------
899+
-------------------------------------------------------------------&zwsp;------------------------------------------------------------
900900
Limit (cost=0.29..14.71 rows=2 width=244) (actual time=0.177..0.249 rows=2 loops=1)
901901
-&gt; Index Scan using tenk1_unique2 on tenk1 (cost=0.29..72.42 rows=10 width=244) (actual time=0.174..0.244 rows=2 loops=1)
902902
Index Cond: (unique2 &gt; 9000)
@@ -1311,7 +1311,7 @@ ANALYZE zipcodes;
13111311
SELECT stxkeys AS k, stxdndistinct AS nd
13121312
FROM pg_statistic_ext join pg_statistic_ext_data on (oid = stxoid)
13131313
WHERE stxname = 'stts2';
1314-
-[ RECORD 1 ]--------------------------------------------------------
1314+
-[ RECORD 1 ]------------------------------------------------------&zwsp;--
13151315
k | 1 2 5
13161316
nd | {"1, 2": 33178, "1, 5": 33178, "2, 5": 27435, "1, 2, 5": 33178}
13171317
(1 row)

0 commit comments

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