#FIG 3.2 Produced by xfig version 3.2.5 Portrait Center Inches Letter 88.00 Single -2 1200 2 0 32 #919191 0 33 #c5ddc1 2 4 0 1 -1 26 1 0 20 0.000 0 0 7 0 0 5 3600 900 1200 900 1200 300 3600 300 3600 900 2 4 0 1 -1 4 1 0 20 0.000 0 0 7 0 0 5 3600 2100 1200 2100 1200 1500 3600 1500 3600 2100 2 4 0 1 -1 0 1 0 20 0.000 0 0 7 0 0 5 7500 1500 5100 1500 5100 900 7500 900 7500 1500 2 4 0 1 -1 31 1 0 20 0.000 0 0 7 0 0 5 3600 3300 1200 3300 1200 2700 3600 2700 3600 3300 2 4 0 1 -1 8 1 0 20 0.000 0 0 7 0 0 5 3600 6000 1200 6000 1200 5400 3600 5400 3600 6000 2 4 0 1 -1 31 1 0 20 0.000 0 0 7 0 0 5 7500 3300 5100 3300 5100 2700 7500 2700 7500 3300 2 4 0 1 -1 8 1 0 20 0.000 0 0 7 0 0 5 3600 8400 1200 8400 1200 7800 3600 7800 3600 8400 2 4 0 1 -1 8 1 0 20 0.000 0 0 7 0 0 5 3600 9600 1200 9600 1200 9000 3600 9000 3600 9600 2 1 2 2 -1 7 0 0 -1 3.000 0 1 -1 1 1 2 0 0 2.00 80.00 150.00 0 0 2.00 80.00 150.00 4500 1425 5135 1194 2 1 2 2 -1 7 0 0 -1 4.000 0 1 -1 1 1 2 0 0 2.00 80.00 150.00 0 0 2.00 80.00 150.00 4725 2025 5160 1467 2 1 0 2 20 7 1 0 -1 0.000 0 0 -1 1 0 2 0 0 2.00 150.00 180.00 2400 2100 2400 2700 2 1 0 2 31 7 1 0 -1 0.000 0 0 -1 1 0 2 0 0 2.00 150.00 180.00 2400 3300 2400 4275 2 4 0 1 -1 8 1 0 20 0.000 0 0 7 0 0 5 3600 7200 1200 7200 1200 6600 3600 6600 3600 7200 2 4 0 1 -1 8 1 0 20 0.000 0 0 7 0 0 5 3600 10800 1200 10800 1200 10200 3600 10200 3600 10800 2 4 0 1 -1 8 1 0 20 0.000 0 0 7 0 0 5 3600 4800 1200 4800 1200 4200 3600 4200 3600 4800 2 1 1 2 32 7 1 0 -1 4.000 0 0 -1 1 0 2 0 0 2.00 150.00 180.00 2400 8400 2400 9000 2 1 1 2 32 7 1 0 -1 4.000 0 0 -1 1 0 2 0 0 2.00 150.00 180.00 2400 7200 2400 7800 2 1 1 2 32 7 1 0 -1 4.000 0 0 -1 1 0 2 0 0 2.00 150.00 180.00 2400 6000 2400 6600 2 1 1 2 32 7 1 0 -1 4.000 0 0 -1 1 0 2 0 0 2.00 150.00 180.00 2400 4800 2400 5400 2 1 1 2 32 7 1 0 -1 4.000 0 0 -1 1 0 2 0 0 2.00 150.00 180.00 3600 5700 5100 5700 2 1 0 2 25 7 0 0 -1 0.000 0 0 -1 1 0 2 0 0 2.00 150.00 180.50 2400 900 2400 1500 2 4 0 1 -1 8 1 0 20 0.000 0 0 7 0 0 5 7500 6000 5100 6000 5100 5400 7500 5400 7500 6000 2 4 0 1 33 33 3 0 20 0.000 0 0 40 0 0 5 8700 11100 300 11100 300 3600 8700 3600 8700 11100 2 1 0 2 29 7 0 0 -1 0.000 0 0 -1 1 1 2 0 0 2.00 150.00 180.00 0 0 2.00 150.00 180.00 3150 13050 3150 13650 2 1 0 2 29 7 0 0 -1 0.000 0 0 -1 1 1 2 0 0 2.00 150.00 180.00 0 0 2.00 150.00 180.00 1500 12450 1500 11850 2 4 0 1 -1 29 1 0 20 0.000 0 0 7 0 0 5 2700 13050 300 13050 300 12450 2700 12450 2700 13050 2 4 0 1 -1 29 1 0 20 0.000 0 0 7 0 0 5 6000 13050 3600 13050 3600 12450 6000 12450 6000 13050 2 4 0 1 -1 29 1 0 20 0.000 0 0 7 0 0 5 7500 14250 5100 14250 5100 13650 7500 13650 7500 14250 2 4 0 1 -1 29 1 0 20 0.000 0 0 7 0 0 5 4200 14250 1800 14250 1800 13650 4200 13650 4200 14250 2 1 0 2 29 7 0 0 -1 0.000 0 0 -1 1 1 2 0 0 2.00 150.00 180.00 0 0 2.00 150.00 180.00 4800 12450 4800 11850 2 1 0 2 29 7 0 0 -1 0.000 0 0 -1 1 1 2 0 0 2.00 150.00 180.00 0 0 2.00 150.00 180.00 6300 13050 6300 13650 2 4 0 1 -1 29 1 0 20 0.000 0 0 7 0 0 5 9300 13050 6600 13050 6600 12450 9300 12450 9300 13050 2 1 0 2 29 7 0 0 -1 0.000 0 0 -1 1 1 2 0 0 2.00 150.00 180.00 0 0 2.00 150.00 180.00 7950 11850 7950 12450 2 1 1 2 5 7 1 0 -1 4.000 0 0 -1 1 0 2 0 0 2.00 150.00 180.00 2400 6000 2400 6600 2 1 1 2 32 7 1 0 -1 4.000 0 0 -1 1 0 2 0 0 2.00 150.00 180.00 2400 9600 2400 10200 3 2 2 2 20 7 0 0 -1 6.000 1 1 0 5 0 0 2.00 150.00 180.00 2415 2140 3090 2440 5265 2515 6090 2590 6315 2740 0.000 -1.000 -1.000 -1.000 0.000 3 0 1 2 32 7 1 0 -1 4.500 0 1 0 7 0 0 2.00 150.00 150.00 7500 5700 8400 5400 8400 4500 7800 3900 3600 3900 3000 3900 2700 4200 0.000 1.000 1.000 1.000 1.000 1.000 0.000 3 0 1 2 32 7 0 0 -1 4.000 0 1 0 8 0 0 2.00 150.00 150.00 1125 10500 900 10350 675 9975 675 4350 900 3975 1350 3900 1800 3900 2100 4200 0.000 1.000 1.000 1.000 1.000 1.000 1.000 0.000 4 1 5 2 0 28 18 0.0000 4 285 870 4350 5625 utility\001 4 1 -1 0 0 16 18 0.0000 4 210 1455 2400 1950 Postmaster\001 4 1 -1 0 0 16 18 0.0000 4 270 1125 2400 3150 Postgres\001 4 1 -1 0 0 16 18 0.0000 4 270 1125 6300 3150 Postgres\001 4 1 7 0 0 16 18 0.0000 4 270 720 6300 1350 Libpq\001 4 1 -1 0 0 16 18 0.0000 4 210 615 2400 750 Main\001 4 1 7 0 0 16 18 0.0000 4 210 1815 2400 9450 Generate Plan\001 4 1 7 0 0 16 18 0.0000 4 270 1440 2400 5850 Traffic Cop\001 4 1 7 0 0 16 18 0.0000 4 210 1980 2400 8250 Generate Paths\001 4 1 5 2 0 28 18 0.0000 4 225 615 2400 9900 Plan\001 4 1 5 2 0 28 18 0.0000 4 285 1920 2400 8700 Optimal Path\001 4 1 5 2 0 28 18 0.0000 4 285 900 2400 6300 Query\001 4 1 7 0 0 16 18 0.0000 4 210 1680 2400 10650 Execute Plan\001 4 0 5 0 0 16 12 0.0000 4 210 2640 5250 6300 e.g. CREATE TABLE, COPY\001 4 1 5 0 0 16 12 0.0000 4 195 3540 2400 6525 SELECT, INSERT, UPDATE, DELETE\001 4 1 7 0 0 16 18 0.0000 4 270 1800 2400 7050 Rewrite Query\001 4 1 7 0 0 16 18 0.0000 4 210 2130 2400 4650 Parse Statement\001 4 1 7 0 0 16 18 0.0000 4 270 720 6300 5700 Utility\001 4 1 7 0 0 16 18 0.0000 4 210 1335 6300 6000 Command\001 4 1 -1 0 0 16 18 0.0000 4 270 2355 7950 12900 Storage Managers\001 4 1 -1 0 0 16 18 0.0000 4 270 1020 4800 12900 Catalog\001 4 1 -1 0 0 16 18 0.0000 4 210 915 1500 12900 Utilities\001 4 1 -1 0 0 16 18 0.0000 4 210 2085 3000 14100 Access Methods\001 4 1 -1 0 0 16 18 0.0000 4 210 1635 6300 14100 Nodes / Lists\001