. This can be explained with the help of the following example:      warehouse_db=# EXPLAIN SELECT COUNT(*) FROM item WHERE item_id = 000;                              QUERY PLAN                                    ------------------------------------------------------------------      Aggregate  (cost=0