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

Commita6586c0

Browse files
committed
Improve backend flowchart to show more detail.
1 parent34f89cb commita6586c0

File tree

3 files changed

+131
-121
lines changed

3 files changed

+131
-121
lines changed

‎src/tools/backend/flow.fig

Lines changed: 112 additions & 102 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
#FIG 3.2
1+
#FIG 3.2 Produced by xfig version 3.2.5
22
Portrait
33
Center
44
Inches
@@ -7,127 +7,137 @@ Letter
77
Single
88
-2
99
1200 2
10-
2 1 0 2 29 7 0 0 -1 0.000 0 0 -1 1 1 2
10+
0 32 #919191
11+
0 33 #c5ddc1
12+
2 4 0 1 -1 26 1 0 20 0.000 0 0 7 0 0 5
13+
3600 900 1200 900 1200 300 3600 300 3600 900
14+
2 4 0 1 -1 4 1 0 20 0.000 0 0 7 0 0 5
15+
3600 2100 1200 2100 1200 1500 3600 1500 3600 2100
16+
2 4 0 1 -1 0 1 0 20 0.000 0 0 7 0 0 5
17+
7500 1500 5100 1500 5100 900 7500 900 7500 1500
18+
2 4 0 1 -1 31 1 0 20 0.000 0 0 7 0 0 5
19+
3600 3300 1200 3300 1200 2700 3600 2700 3600 3300
20+
2 4 0 1 -1 8 1 0 20 0.000 0 0 7 0 0 5
21+
3600 6000 1200 6000 1200 5400 3600 5400 3600 6000
22+
2 4 0 1 -1 31 1 0 20 0.000 0 0 7 0 0 5
23+
7500 3300 5100 3300 5100 2700 7500 2700 7500 3300
24+
2 4 0 1 -1 8 1 0 20 0.000 0 0 7 0 0 5
25+
3600 8400 1200 8400 1200 7800 3600 7800 3600 8400
26+
2 4 0 1 -1 8 1 0 20 0.000 0 0 7 0 0 5
27+
3600 9600 1200 9600 1200 9000 3600 9000 3600 9600
28+
2 1 2 2 -1 7 0 0 -1 3.000 0 1 -1 1 1 2
29+
0 0 2.00 80.00 150.00
30+
0 0 2.00 80.00 150.00
31+
4500 1425 5135 1194
32+
2 1 2 2 -1 7 0 0 -1 4.000 0 1 -1 1 1 2
33+
0 0 2.00 80.00 150.00
34+
0 0 2.00 80.00 150.00
35+
4725 2025 5160 1467
36+
2 1 0 2 20 7 1 0 -1 0.000 0 0 -1 1 0 2
37+
0 0 2.00 150.00 180.00
38+
2400 2100 2400 2700
39+
2 1 0 2 31 7 1 0 -1 0.000 0 0 -1 1 0 2
1140
0 0 2.00 150.00 180.00
41+
2400 3300 2400 4275
42+
2 4 0 1 -1 8 1 0 20 0.000 0 0 7 0 0 5
43+
3600 7200 1200 7200 1200 6600 3600 6600 3600 7200
44+
2 4 0 1 -1 8 1 0 20 0.000 0 0 7 0 0 5
45+
3600 10800 1200 10800 1200 10200 3600 10200 3600 10800
46+
2 4 0 1 -1 8 1 0 20 0.000 0 0 7 0 0 5
47+
3600 4800 1200 4800 1200 4200 3600 4200 3600 4800
48+
2 1 1 2 32 7 1 0 -1 4.000 0 0 -1 1 0 2
1249
0 0 2.00 150.00 180.00
13-
7950 10200 7950 10800
14-
2 4 0 1 -1 29 1 0 20 0.000 0 0 7 0 0 5
15-
2775 11400 375 11400 375 10800 2775 10800 2775 11400
16-
2 1 0 2 29 7 0 0 -1 0.000 0 0 -1 1 1 2
50+
2400 8400 2400 9000
51+
2 1 1 2 32 7 1 0 -1 4.000 0 0 -1 1 0 2
1752
0 0 2.00 150.00 180.00
53+
2400 7200 2400 7800
54+
2 1 1 2 32 7 1 0 -1 4.000 0 0 -1 1 0 2
1855
0 0 2.00 150.00 180.00
19-
1575 10800 1575 10200
20-
2 4 0 1 -1 29 1 0 20 0.000 0 0 7 0 0 5
21-
9150 11400 6750 11400 6750 10800 9150 10800 9150 11400
22-
2 4 0 1 -1 29 1 0 20 0.000 0 0 7 0 0 5
23-
5925 11400 3525 11400 3525 10800 5925 10800 5925 11400
56+
2400 6000 2400 6600
57+
2 1 1 2 32 7 1 0 -1 4.000 0 0 -1 1 0 2
58+
0 0 2.00 150.00 180.00
59+
2400 4800 2400 5400
60+
2 1 1 2 32 7 1 0 -1 4.000 0 0 -1 1 0 2
61+
0 0 2.00 150.00 180.00
62+
3600 5700 5100 5700
63+
2 1 0 2 25 7 0 0 -1 0.000 0 0 -1 1 0 2
64+
0 0 2.00 150.00 180.50
65+
2400 900 2400 1500
66+
2 4 0 1 -1 8 1 0 20 0.000 0 0 7 0 0 5
67+
7500 6000 5100 6000 5100 5400 7500 5400 7500 6000
68+
2 4 0 1 33 33 3 0 20 0.000 0 0 40 0 0 5
69+
8700 11100 300 11100 300 3600 8700 3600 8700 11100
2470
2 1 0 2 29 7 0 0 -1 0.000 0 0 -1 1 1 2
2571
0 0 2.00 150.00 180.00
2672
0 0 2.00 150.00 180.00
27-
4725 10800 4725 10200
28-
2 4 0 1 -1 29 1 0 20 0.000 0 0 7 0 0 5
29-
4350 12600 1950 12600 1950 12000 4350 12000 4350 12600
73+
3150 13050 3150 13650
3074
2 1 0 2 29 7 0 0 -1 0.000 0 0 -1 1 1 2
3175
0 0 2.00 150.00 180.00
3276
0 0 2.00 150.00 180.00
33-
3150 11400 3150 12000
34-
2 1 0 2 8 7 1 0 -1 0.000 0 0 -1 1 0 2
77+
1500 12450 1500 11850
78+
2 4 0 1 -1 29 1 0 20 0.000 0 0 7 0 0 5
79+
2700 13050 300 13050 300 12450 2700 12450 2700 13050
80+
2 4 0 1 -1 29 1 0 20 0.000 0 0 7 0 0 5
81+
6000 13050 3600 13050 3600 12450 6000 12450 6000 13050
82+
2 4 0 1 -1 29 1 0 20 0.000 0 0 7 0 0 5
83+
7500 14250 5100 14250 5100 13650 7500 13650 7500 14250
84+
2 4 0 1 -1 29 1 0 20 0.000 0 0 7 0 0 5
85+
4200 14250 1800 14250 1800 13650 4200 13650 4200 14250
86+
2 1 0 2 29 7 0 0 -1 0.000 0 0 -1 1 1 2
3587
0 0 2.00 150.00 180.00
36-
2550 4875 2550 5475
37-
2 4 0 1 -1 4 1 0 20 0.000 0 0 7 0 0 5
38-
3750 2175 1350 2175 1350 1575 3750 1575 3750 2175
39-
2 4 0 1 -1 8 1 0 20 0.000 0 0 7 0 0 5
40-
3750 4875 1350 4875 1350 4275 3750 4275 3750 4875
41-
2 4 0 1 -1 8 1 0 20 0.000 0 0 7 0 0 5
42-
3750 7275 1350 7275 1350 6675 3750 6675 3750 7275
43-
2 1 0 2 8 7 1 0 -1 0.000 0 0 -1 1 0 2
4488
0 0 2.00 150.00 180.00
45-
2550 6075 2550 6675
46-
2 4 0 1 -1 8 1 0 20 0.000 0 0 7 0 0 5
47-
3750 8475 1350 8475 1350 7875 3750 7875 3750 8475
48-
2 1 0 2 8 7 1 0 -1 0.000 0 0 -1 1 0 2
89+
4800 12450 4800 11850
90+
2 1 0 2 29 7 0 0 -1 0.000 0 0 -1 1 1 2
4991
0 0 2.00 150.00 180.00
50-
2550 8475 2550 9075
51-
2 4 0 1 -1 8 1 0 20 0.000 0 0 7 0 0 5
52-
7650 6075 5250 6075 5250 5475 7650 5475 7650 6075
53-
2 4 0 1 -1 8 1 0 20 0.000 0 0 7 0 0 5
54-
3750 9675 1350 9675 1350 9075 3750 9075 3750 9675
55-
2 4 0 1 -1 31 1 0 20 0.000 0 0 7 0 0 5
56-
3750 3375 1350 3375 1350 2775 3750 2775 3750 3375
57-
2 4 0 1 -1 31 1 0 20 0.000 0 0 7 0 0 5
58-
7650 3375 5250 3375 5250 2775 7650 2775 7650 3375
59-
2 4 0 1 -1 17 2 0 20 0.000 0 0 40 0 0 5
60-
8700 9975 300 9975 300 3825 8700 3825 8700 9975
61-
2 4 0 1 -1 0 1 0 20 0.000 0 0 7 0 0 5
62-
7650 1575 5250 1575 5250 975 7650 975 7650 1575
63-
2 4 0 1 -1 23 1 0 20 0.000 0 0 8 0 0 5
64-
2850 13875 450 13875 450 13275 2850 13275 2850 13875
65-
2 1 0 2 25 7 0 0 -1 0.000 0 0 -1 1 0 2
66-
0 0 2.00 150.00 180.50
67-
2550 975 2550 1575
68-
2 4 0 1 -1 26 1 0 20 0.000 0 0 7 0 0 5
69-
3750 975 1350 975 1350 375 3750 375 3750 975
70-
2 1 0 2 20 7 1 0 -1 0.000 0 0 -1 1 0 2
7192
0 0 2.00 150.00 180.00
72-
2550 2175 2550 2775
93+
6300 13050 6300 13650
7394
2 4 0 1 -1 29 1 0 20 0.000 0 0 7 0 0 5
74-
7650 12600 5250 12600 5250 12000 7650 12000 7650 12600
95+
9300 13050 6600 13050 6600 12450 9300 12450 9300 13050
7596
2 1 0 2 29 7 0 0 -1 0.000 0 0 -1 1 1 2
7697
0 0 2.00 150.00 180.00
7798
0 0 2.00 150.00 180.00
78-
6375 11400 6375 12000
79-
2 10 28 7 1 0 -10.000 0 0 -1 1 0 2
99+
7950 11850 7950 12450
100+
2 11 25 7 1 0 -14.000 0 0 -1 1 0 2
80101
0 0 2.00 150.00 180.00
81-
3750 5775 5250 5775
82-
2 4 0 1 -1 8 1 0 20 0.000 0 0 7 0 0 5
83-
3750 6075 1350 6075 1350 5475 3750 5475 3750 6075
84-
2 1 0 2 8 7 1 0 -1 0.000 0 0 -1 1 0 2
102+
2400 6000 2400 6600
103+
2 1 1 2 32 7 1 0 -1 4.000 0 0 -1 1 0 2
85104
0 0 2.00 150.00 180.00
86-
2550 7275 2550 7875
87-
2 1 0 2 31 7 1 0 -1 0.000 0 0 -1 1 0 2
88-
0 0 2.00 150.00 180.00
89-
2550 3300 2550 4275
90-
2 1 2 2 -1 7 0 0 -1 3.000 0 1 -1 1 1 2
91-
0 0 2.00 80.00 150.00
92-
0 0 2.00 80.00 150.00
93-
4584 1524 5219 1293
94-
2 1 2 2 -1 7 0 0 -1 4.000 0 1 -1 1 1 2
95-
0 0 2.00 80.00 150.00
96-
0 0 2.00 80.00 150.00
97-
4800 1875 5235 1317
98-
3 0 0 2 8 7 1 0 -1 0.000 0 1 0 8
99-
0 0 2.00 150.00 150.00
100-
1350 9375 1050 9375 825 9000 825 4425 1050 4050 1500 3975
101-
2250 3975 2400 4275
102-
0.000 1.000 1.000 1.000 1.000 1.000 1.000 0.000
103-
3 0 0 2 8 7 1 0 -1 0.000 0 1 0 7
104-
0 0 2.00 150.00 150.00
105-
7650 5775 8250 5475 8250 4575 7725 3975 3525 3975 2850 3975
106-
2700 4275
107-
0.000 1.000 1.000 1.000 1.000 1.000 0.000
105+
2400 9600 2400 10200
108106
3 2 2 2 20 7 0 0 -1 6.000 1 1 0 5
109107
0 0 2.00 150.00 180.00
110-
2550 2175 3225 2475 5400 2550 6225 2625 6450 2775
108+
2415 2140 3090 2440 5265 2515 6090 2590 6315 2740
111109
0.000 -1.000 -1.000 -1.000 0.000
112-
4 1 -1 0 0 16 18 0.0000 4 210 900 1560 11190 Utilities\001
113-
4 1 -1 0 0 16 18 0.0000 4 270 2265 7965 11190 Storage Managers\001
114-
4 1 -1 0 0 16 18 0.0000 4 270 960 4725 11175 Catalog\001
115-
4 1 -1 0 0 16 18 0.0000 4 210 2070 3135 12405 Access Methods\001
116-
4 1 7 0 0 16 18 0.0000 4 210 1380 6450 6030 Commands\001
117-
4 1 7 0 0 16 18 0.0000 4 210 1725 2565 8445 Generate Plan\001
118-
4 1 -1 0 0 16 18 0.0000 4 270 1110 6435 3150 Postgres\001
119-
4 1 -1 0 0 16 18 0.0000 4 270 1110 2550 3165 Postgres\001
120-
4 1 7 0 0 16 18 0.0000 4 210 1200 2565 6945 Rewrite &\001
121-
4 1 7 0 0 16 18 0.0000 4 270 1410 2565 5865 Traffic Cop\001
122-
4 1 7 0 0 16 18 0.0000 4 210 780 2535 4650 Parser\001
123-
4 1 7 0 0 16 18 0.0000 4 210 1110 2535 9495 Executor\001
124-
4 1 7 0 0 16 18 0.0000 4 270 705 6450 5745 Utility\001
125-
4 1 8 1 0 28 18 0.0000 4 240 1125 2565 6435 complex\001
126-
4 1 -1 0 0 16 18 0.0000 4 210 1605 6450 12375 Nodes / Lists\001
127-
4 1 7 0 0 16 18 0.0000 4 270 705 6450 1350 Libpq\001
128-
4 1 7 0 0 16 18 0.0000 4 210 1890 2535 7230 Generate Paths\001
129-
4 1 7 0 0 16 18 0.0000 4 210 1875 2550 8175 Choose Path &\001
130-
4 1 -1 0 0 16 18 0.0000 4 270 1230 1650 13650 Bootstrap\001
131-
4 1 -1 0 0 16 18 0.0000 4 210 1380 2535 1965 Postmaster\001
132-
4 1 -1 0 0 16 18 0.0000 4 210 585 2520 765 Main\001
133-
4 1 8 1 0 28 18 0.0000 4 240 795 4455 5700 utility\001
110+
3 0 1 2 32 7 1 0 -1 4.500 0 1 0 7
111+
0 0 2.00 150.00 150.00
112+
7500 5700 8400 5400 8400 4500 7800 3900 3600 3900 3000 3900
113+
2700 4200
114+
0.000 1.000 1.000 1.000 1.000 1.000 0.000
115+
3 0 1 2 32 7 0 0 -1 4.000 0 1 0 8
116+
0 0 2.00 150.00 150.00
117+
1125 10500 900 10350 675 9975 675 4350 900 3975 1350 3900
118+
1800 3900 2100 4200
119+
0.000 1.000 1.000 1.000 1.000 1.000 1.000 0.000
120+
4 1 5 2 0 28 18 0.0000 4 285 870 4350 5625 utility\001
121+
4 1 -1 0 0 16 18 0.0000 4 210 1455 2400 1950 Postmaster\001
122+
4 1 -1 0 0 16 18 0.0000 4 270 1125 2400 3150 Postgres\001
123+
4 1 -1 0 0 16 18 0.0000 4 270 1125 6300 3150 Postgres\001
124+
4 1 7 0 0 16 18 0.0000 4 270 720 6300 1350 Libpq\001
125+
4 1 -1 0 0 16 18 0.0000 4 210 615 2400 750 Main\001
126+
4 1 7 0 0 16 18 0.0000 4 210 1815 2400 9450 Generate Plan\001
127+
4 1 7 0 0 16 18 0.0000 4 270 1440 2400 5850 Traffic Cop\001
128+
4 1 7 0 0 16 18 0.0000 4 210 1980 2400 8250 Generate Paths\001
129+
4 1 5 2 0 28 18 0.0000 4 225 615 2400 9900 Plan\001
130+
4 1 5 2 0 28 18 0.0000 4 285 1920 2400 8700 Optimal Path\001
131+
4 1 5 2 0 28 18 0.0000 4 285 900 2400 6300 Query\001
132+
4 1 7 0 0 16 18 0.0000 4 210 1680 2400 10650 Execute Plan\001
133+
4 0 5 0 0 16 12 0.0000 4 210 2640 5250 6300 e.g. CREATE TABLE, COPY\001
134+
4 1 5 0 0 16 12 0.0000 4 195 3540 2400 6525 SELECT, INSERT, UPDATE, DELETE\001
135+
4 1 7 0 0 16 18 0.0000 4 270 1800 2400 7050 Rewrite Query\001
136+
4 1 7 0 0 16 18 0.0000 4 210 2130 2400 4650 Parse Statement\001
137+
4 1 7 0 0 16 18 0.0000 4 270 720 6300 5700 Utility\001
138+
4 1 7 0 0 16 18 0.0000 4 210 1335 6300 6000 Command\001
139+
4 1 -1 0 0 16 18 0.0000 4 270 2355 7950 12900 Storage Managers\001
140+
4 1 -1 0 0 16 18 0.0000 4 270 1020 4800 12900 Catalog\001
141+
4 1 -1 0 0 16 18 0.0000 4 210 915 1500 12900 Utilities\001
142+
4 1 -1 0 0 16 18 0.0000 4 210 2085 3000 14100 Access Methods\001
143+
4 1 -1 0 0 16 18 0.0000 4 210 1635 6300 14100 Nodes / Lists\001

‎src/tools/backend/flow.gif

461 KB
Loading

‎src/tools/backend/index.html

Lines changed: 19 additions & 19 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
<!-- $PostgreSQL: pgsql/src/tools/backend/index.html,v 1.35 2006/03/11 04:38:41 momjian Exp $ -->
1+
<!-- $PostgreSQL: pgsql/src/tools/backend/index.html,v 1.36 2008/10/07 00:19:48 momjian Exp $ -->
22
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
33
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
44
<htmlxmlns="http://www.w3.org/1999/xhtml">
@@ -14,29 +14,29 @@ <h1>How PostgreSQL Processes a Query</h1>
1414
<h2>by Bruce Momjian</h2>
1515

1616
<center>
17-
<h3>Click on an item to see more detail or look at the full
17+
<h3><i>Click on an item</i> to see more detail or look at the full
1818
<ahref="backend_dirs.html">index.</a></h3>
1919

2020
<p><imgsrc="flow.gif"usemap="#flowmap"alt="flowchart"/>
2121

2222
<mapname="flowmap"id="flowmap">
23-
<areacoords="125,35,245,65"href="backend_dirs.html#main"alt="main"/>
24-
<areacoords="125,100,245,125"href="backend_dirs.html#postmaster"alt="postmaster"/>
25-
<areacoords="325,65,450,95"href="backend_dirs.html#libpq"alt="libpq"/>
26-
<areacoords="125,160,245,190"href="backend_dirs.html#tcop"alt="tcop"/>
27-
<areacoords="325,160,450,190"href="backend_dirs.html#tcop"alt="tcop"/>
28-
<areacoords="125,240,245,265"href="backend_dirs.html#parser"alt="parser"/>
29-
<areacoords="125,300,250,330"href="backend_dirs.html#tcop"alt="tcop"/>
30-
<areacoords="125,360,250,390"href="backend_dirs.html#optimizer"alt="optimizer"/>
31-
<areacoords="125,425,245,455"href="backend_dirs.html#optimizer_plan"alt="plan"/>
32-
<areacoords="125,490,245,515"href="backend_dirs.html#executor"alt="executor"/>
33-
<areacoords="325,300,450,330"href="backend_dirs.html#commands"alt="commands"/>
34-
<areacoords="75,575,195,605"href="backend_dirs.html#utils"alt="utils"/>
35-
<areacoords="235,575,360,605"href="backend_dirs.html#catalog"alt="catalog"/>
36-
<areacoords="405,575,525,605"href="backend_dirs.html#storage"alt="storage"/>
37-
<areacoords="155,635,275,665"href="backend_dirs.html#access"alt="access"/>
38-
<areacoords="325,635,450,665"href="backend_dirs.html#nodes"alt="nodes"/>
39-
<areacoords="75,705,200,730"href="backend_dirs.html#bootstrap"alt="bootstrap"/>
23+
<areacoords="45, 0, 175, 30"href="backend_dirs.html#main"alt="main"/>
24+
<areacoords="255, 35, 380, 65"href="backend_dirs.html#libpq"alt="libpq"/>
25+
<areacoords="45,65, 175,95"href="backend_dirs.html#postmaster"alt="postmaster"/>
26+
<areacoords="45, 130, 175, 160"href="backend_dirs.html#tcop"alt="tcop"/>
27+
<areacoords="250, 130, 380, 160"href="backend_dirs.html#tcop"alt="tcop"/>
28+
<areacoords="45, 205, 175, 240"href="backend_dirs.html#parser"alt="parser"/>
29+
<areacoords="45, 270, 175, 300"href="backend_dirs.html#tcop"alt="tcop"/>
30+
<areacoords="255, 270, 380, 300"href="backend_dirs.html#commands"alt="commands"/>
31+
<areacoords="45, 335, 175, 365"href="backend_dirs.html#rewrite"alt="rewrite"/>
32+
<areacoords="45, 400, 175, 430"href="backend_dirs.html#optimizer_path"alt="path"/>
33+
<areacoords="45, 460, 175, 490"href="backend_dirs.html#optimizer_plan"alt="plan"/>
34+
<areacoords="45, 525, 175, 555"href="backend_dirs.html#executor"alt="executor"/>
35+
<areacoords="0, 640, 130, 675"href="backend_dirs.html#utils"alt="utils"/>
36+
<areacoords="175, 640, 300, 675"href="backend_dirs.html#catalog"alt="catalog"/>
37+
<areacoords="330, 640, 475, 675"href="backend_dirs.html#storage"alt="storage"/>
38+
<areacoords="75, 700, 210, 735"href="backend_dirs.html#access"alt="access"/>
39+
<areacoords="255,705, 380, 735"href="backend_dirs.html#nodes"alt="nodes"/>
4040
</map>
4141
</center>
4242

0 commit comments

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