EXISTS` expression in the following statement:      warehouse_db=# EXPLAIN SELECT * FROM record.warehouse_tbl WHERE EXISTS (SELECT 0 FROM record.history where warehouse_tbl.warehouse_id = history.warehouse_id);                                QUERY PLAN                                  ------------------------------------------------------------------      Nested Loop 