postgres_fdw example • From pg, execute EXPLAIN SELECT * FROM invoice WHERE invoice_id = 1; Append (cost=0.00..347.89 rows=39 width=31) -> Seq Scan on invoice Filter: (invoice_id = 1) -> Foreign postgres_fdw example • From pg, execute EXPLAIN SELECT * FROM invoice WHERE invoice_id = 1; Append (cost=0.00..347.89 rows=39 width=31) -> Seq Scan on invoice Filter: (invoice_id = 1) -> Foreign Foreign Scan on invoice_us EXPLAIN SELECT * FROM invoice WHERE invoice_id = 1 AND country = 'CH'; Append (cost=0.00..265.21 rows=2 width=22) -> Seq Scan on invoice Filter: ((invoice_id = 1) AND (country

Aggregation ......................................................................... 513 15.3.4. Parallel Append ............................................................................... 513 15.3.5. Parallel objects), table column 75 Data Definition Privilege Abbreviation Applicable Object Types INSERT a (“append”) TABLE, table column UPDATE w (“write”) LARGE OBJECT, SEQUENCE, TABLE, table column DELETE d TABLE ----------------------- ---------------- Aggregate (cost=188.76..188.77 rows=1 width=8) -> Append (cost=0.00..181.05 rows=3085 width=0) -> Seq Scan on measurement_y2006m02 (cost=0.00

........................................................................... 541 15.3.4. Parallel Append .................................................................................... 541 15.3.5. SELECT r (“read”) LARGE OBJECT, SEQUENCE, TABLE (and ta- ble-like objects), table column INSERT a (“append”) TABLE, table column 80 Data Definition Privilege Abbreviation Applicable Object Types UPDATE ----------------------- ---------------- Aggregate (cost=188.76..188.77 rows=1 width=8) -> Append (cost=0.00..181.05 rows=3085 width=0) -> Seq Scan on measurement_y2006m02 (cost=0.00

Aggregation ......................................................................... 527 15.3.4. Parallel Append ............................................................................... 527 15.3.5. Parallel SELECT r (“read”) LARGE OBJECT, SEQUENCE, TABLE (and ta- ble-like objects), table column INSERT a (“append”) TABLE, table column UPDATE w (“write”) LARGE OBJECT, SEQUENCE, TABLE, table column DELETE d TABLE ----------------------- ---------------- Aggregate (cost=188.76..188.77 rows=1 width=8) -> Append (cost=0.00..181.05 rows=3085 width=0) -> Seq Scan on measurement_y2006m02 (cost=0.00

........................................................................... 556 15.3.4. Parallel Append .................................................................................... 556 15.3.5. SELECT r (“read”) LARGE OBJECT, SEQUENCE, TABLE (and ta- ble-like objects), table column INSERT a (“append”) TABLE, table column UPDATE w (“write”) LARGE OBJECT, SEQUENCE, TABLE, table col- umn DELETE d ----------------------- ---------------- Aggregate (cost=188.76..188.77 rows=1 width=8) -> Append (cost=0.00..181.05 rows=3085 width=0) -> Seq Scan on measurement_y2006m02 (cost=0.00

Aggregation ......................................................................... 494 15.3.4. Parallel Append ............................................................................... 495 15.3.5. Parallel SELECT r (“read”) LARGE OBJECT, SEQUENCE, TABLE (and table-like objects), table column INSERT a (“append”) TABLE, table column 76 Data Definition Privilege Abbreviation Applicable Object Types UPDATE ---------------------------------------- Aggregate (cost=188.76..188.77 rows=1 width=8) -> Append (cost=0.00..181.05 rows=3085 width=0) -> Seq Scan on measurement_y2006m02 (cost=0.00

Aggregation ......................................................................... 521 15.3.4. Parallel Append ............................................................................... 521 15.3.5. Parallel SELECT r (“read”) LARGE OBJECT, SEQUENCE, TABLE (and ta- ble-like objects), table column INSERT a (“append”) TABLE, table column UPDATE w (“write”) LARGE OBJECT, SEQUENCE, TABLE, table column DELETE d TABLE ----------------------- ---------------- Aggregate (cost=188.76..188.77 rows=1 width=8) -> Append (cost=0.00..181.05 rows=3085 width=0) -> Seq Scan on measurement_y2006m02 (cost=0.00

Aggregation ......................................................................... 474 15.3.4. Parallel Append ............................................................................... 474 15.3.5. Parallel ---------------------------------------- Aggregate (cost=188.76..188.77 rows=1 width=8) -> Append (cost=0.00..181.05 rows=3085 width=0) -> Seq Scan on measurement_y2006m02 (cost=0.00 ------------------------------------------ Aggregate (cost=37.75..37.76 rows=1 width=8) -> Append (cost=0.00..36.21 rows=617 width=0) -> Seq Scan on measurement_y2008m01 (cost=0.00..33

........................................................................... 522 15.3.4. Parallel Append .................................................................................... 522 15.3.5. SELECT r (“read”) LARGE OBJECT, SEQUENCE, TABLE (and table-like objects), table column INSERT a (“append”) TABLE, table column UPDATE w (“write”) LARGE OBJECT, SEQUENCE, TABLE, table column DELETE d TABLE ---------------------------------------- Aggregate (cost=188.76..188.77 rows=1 width=8) -> Append (cost=0.00..181.05 rows=3085 width=0) -> Seq Scan on measurement_y2006m02 (cost=0.00

........................................................................... 548 15.3.4. Parallel Append .................................................................................... 548 15.3.5. SELECT r (“read”) LARGE OBJECT, SEQUENCE, TABLE (and ta- ble-like objects), table column INSERT a (“append”) TABLE, table column UPDATE w (“write”) LARGE OBJECT, SEQUENCE, TABLE, table col- umn DELETE d ----------------------- ---------------- Aggregate (cost=188.76..188.77 rows=1 width=8) -> Append (cost=0.00..181.05 rows=3085 width=0) -> Seq Scan on measurement_y2006m02 (cost=0.00