index scan扫描

最近更新时间: 2025-02-18 16:02:00

  • 复制
    复制成功
postgres=# explain select * from t1 where f1=1;  
                                QUERY PLAN                                 
---------------------------------------------------------------------------
 Remote Fast Query Execution  (cost=0.00..0.00 rows=0 width=0)
   Node/s: dn001
   ->  Index Scan using tf_f1_idx on t1  (cost=0.42..4.44 rows=1 width=37)
         Index Cond: (f1 = 1)
(4 rows)