QUERY PLAN ------------------------------------------------------------------------------------------------------------------------------------------------- Result (cost=0.32..0.33 rows=1 width=4) (actual time=0.012..0.012 rows=1.00 loops=1) Output: (InitPlan minmax_1).col1 Replaces: MinMaxAggregate Buffers: shared hit=3 InitPlan minmax_1 -> Limit (cost=0.29..0.32 rows=1 width=4) (actual time=0.011..0.011 rows=1.00 loops=1) Output: "T 3".c1 Buffers: shared hit=3 -> Index Only Scan using t3_pkey on "S 1"."T 3" (cost=0.29..328.29 rows=10000 width=4) (actual time=0.011..0.011 rows=1.00 loops=1) Output: "T 3".c1 Heap Fetches: 1 Index Searches: 1 Buffers: shared hit=3 Planning Time: 0.027 ms Execution Time: 0.019 ms (15 rows) QUERY PLAN ------------------------------------------------------------------------------------------------------------------------ Aggregate (cost=180.00..180.01 rows=1 width=4) (actual time=1.057..1.058 rows=1.00 loops=1) Output: min(c2) Buffers: shared hit=55 -> Seq Scan on "S 1"."T 3" (cost=0.00..155.00 rows=10000 width=4) (actual time=0.004..0.414 rows=10000.00 loops=1) Output: c1, c2, c3 Buffers: shared hit=55 Planning Time: 0.026 ms Execution Time: 1.065 ms (8 rows) QUERY PLAN -------------------------------------------------------------------------------------------------------------------------------- Result (cost=100.23..100.24 rows=1 width=4) (actual time=0.145..0.145 rows=1.00 loops=1) Output: (InitPlan minmax_1).col1 Replaces: MinMaxAggregate InitPlan minmax_1 -> Limit (cost=100.00..100.23 rows=1 width=4) (actual time=0.144..0.144 rows=1.00 loops=1) Output: ft4.c1 -> Foreign Scan on public.ft4 (cost=100.00..761.35 rows=2925 width=4) (actual time=0.144..0.144 rows=1.00 loops=1) Output: ft4.c1 Remote SQL: SELECT c1 FROM "S 1"."T 3" ORDER BY c1 ASC NULLS LAST Planning Time: 0.030 ms Execution Time: 0.207 ms (11 rows) QUERY PLAN -------------------------------------------------------------------------------------------------------------------------------- Result (cost=100.23..100.24 rows=1 width=4) (actual time=0.832..0.832 rows=1.00 loops=1) Output: (InitPlan minmax_1).col1 Replaces: MinMaxAggregate InitPlan minmax_1 -> Limit (cost=100.00..100.23 rows=1 width=4) (actual time=0.831..0.831 rows=1.00 loops=1) Output: ft4.c2 -> Foreign Scan on public.ft4 (cost=100.00..761.35 rows=2925 width=4) (actual time=0.831..0.831 rows=1.00 loops=1) Output: ft4.c2 Remote SQL: SELECT c2 FROM "S 1"."T 3" ORDER BY c2 ASC NULLS LAST Planning Time: 0.029 ms Execution Time: 0.900 ms (11 rows) QUERY PLAN ------------------------------------------------------------------------------------------------- Foreign Scan (cost=100.32..100.54 rows=1 width=4) (actual time=0.130..0.130 rows=1.00 loops=1) Output: (min(c1)) Relations: Aggregate on (public.ft4) Remote SQL: SELECT min(c1) FROM "S 1"."T 3" Planning Time: 0.315 ms Execution Time: 0.163 ms (6 rows) QUERY PLAN ------------------------------------------------------------------------------------------------- Foreign Scan (cost=280.00..280.22 rows=1 width=4) (actual time=0.803..0.803 rows=1.00 loops=1) Output: (min(c2)) Relations: Aggregate on (public.ft4) Remote SQL: SELECT min(c2) FROM "S 1"."T 3" Planning Time: 0.316 ms Execution Time: 0.837 ms (6 rows)