Postgres 17

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE tbl (id INT);
INSERT INTO tbl (id) SELECT * FROM generate_series(0, 100000);

CREATE TABLE

INSERT 0 100001

EXPLAIN ANALYZE
SELECT * FROM tbl WHERE id = 69420;

QUERY PLAN

Seq Scan on tbl  (cost=0.00..1855.06 rows=565 width=4) (actual time=6.090..8.755 rows=1 loops=1)

  Filter: (id = 69420)

  Rows Removed by Filter: 100000

Planning Time: 0.724 ms

Execution Time: 8.778 ms

EXPLAIN

EXPLAIN ANALYZE
SELECT * FROM tbl  WHERE id IN 
  ( SELECT id FROM tbl WHERE id = 69420);

QUERY PLAN

Nested Loop Semi Join  (cost=0.00..3727.05 rows=565 width=4) (actual time=9.149..11.166 rows=1 loops=1)

  ->  Seq Scan on tbl  (cost=0.00..1855.06 rows=565 width=4) (actual time=4.589..6.604 rows=1 loops=1)

        Filter: (id = 69420)

        Rows Removed by Filter: 100000

  ->  Materialize  (cost=0.00..1857.89 rows=565 width=4) (actual time=4.556..4.557 rows=1 loops=1)

        ->  Seq Scan on tbl tbl_1  (cost=0.00..1855.06 rows=565 width=4) (actual time=4.550..4.550 rows=1 loops=1)

              Filter: (id = 69420)

              Rows Removed by Filter: 69420

Planning Time: 0.990 ms

Execution Time: 11.195 ms

EXPLAIN