EXPLAIN ANALYZE SELECT max(y) FROM test WHERE x = 66;
Total runtime: 0.124 ms
EXPLAIN ANALYZE SELECT max(y) FROM test WHERE x = 66 GROUP BY x;
Total runtime: 29.157 ms
EXPLAIN ANALYZE SELECT max(y) FROM test WHERE x IN (SELECT generate_series (1,1) as x);
Total runtime: 1908.248 ms
ЭСКУЭЛЬ ДЕКЛАРАТИВНЫЕ ЗАПРОСЫ ОПТИМИЗАЦИИ АНАЛИТИЧЕСКИЕ БАЗЫ ДАННЫХ КОКОКОКОКО