index only scan扫描
最近更新时间: 2025-02-18 16:02:00
postgres=# explain select f1 from t1 where f1=1;
QUERY PLAN
-------------------------------------------------------------------------------
Remote Fast Query Execution (cost=0.00..0.00 rows=0 width=0)
Node/s: dn001
-> Index Only Scan using tf_f1_idx on t1 (cost=0.42..4.44 rows=1 width=4)
Index Cond: (f1 = 1)
(4 rows)