add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
3 rows affected
QUERY PLAN
Seq Scan on links (cost=0.00..52.80 rows=1 width=48)
  Filter: (((id1 = 1) AND (id2 = 2) AND (id3 = 3) AND (id4 = 4)) OR ((id1 = 1) AND (id2 = 2) AND (id3 = 5) AND (id4 = 4)) OR ((id1 = 8) AND (id2 = 4) AND (id3 = 3) AND (id4 = 2)))
QUERY PLAN
Seq Scan on links (cost=0.00..34.08 rows=1 width=48)
  Filter: ((id1 = 1) AND (id2 = 2) AND (id4 = 4) AND ((id3 = 3) OR (id3 = 5)))