ethanryl

why my sql cannot push down

1

PostgreSQL 11 OS: Centos 7.6 postgres# explain (analyze,verbose) select count(year) from ontime; QUERY PLAN Aggregate (cost=0.00..0.01 rows=1 width=8) (actual time=31441.737..31441.737 rows=1 loops=1) Output: count(year) -> Foreign Scan on public.ontime (cost=0.00..0.00...