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.026 ms Execution Time: 0.019 ms (15 rows) QUERY PLAN ------------------------------------------------------------------------------------------------------------------------ Aggregate (cost=180.00..180.01 rows=1 width=4) (actual time=1.054..1.054 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.412 rows=10000.00 loops=1) Output: c1, c2, c3 Buffers: shared hit=55 Planning Time: 0.026 ms Execution Time: 1.061 ms (8 rows) QUERY PLAN ------------------------------------------------------------------------------------------------- Foreign Scan (cost=107.31..146.78 rows=1 width=4) (actual time=0.127..0.127 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.017 ms Execution Time: 0.187 ms (6 rows) QUERY PLAN ------------------------------------------------------------------------------------------------- Foreign Scan (cost=107.31..146.78 rows=1 width=4) (actual time=0.795..0.796 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.017 ms Execution Time: 0.859 ms (6 rows) QUERY PLAN ------------------------------------------------------------------------------------------------- Foreign Scan (cost=100.32..100.54 rows=1 width=4) (actual time=0.124..0.124 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.186 ms Execution Time: 0.157 ms (6 rows) QUERY PLAN ------------------------------------------------------------------------------------------------- Foreign Scan (cost=280.00..280.22 rows=1 width=4) (actual time=0.801..0.802 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.209 ms Execution Time: 0.836 ms (6 rows)