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?.
1000 rows affected
QUERY PLAN
Index Scan using demo_a on demo (cost=0.28..8.29 rows=1 width=8)
  Index Cond: (a = 999)
QUERY PLAN
Index Scan using demo_b on demo (cost=0.28..8.29 rows=1 width=8)
  Index Cond: (b = 999)
QUERY PLAN
Index Scan using demo_b on demo (cost=0.28..8.29 rows=1 width=8)
  Index Cond: (b = 999)
  Filter: (a = 999)
QUERY PLAN
Index Scan using demo_b on demo (cost=0.28..8.29 rows=1 width=8)
  Index Cond: (b > 999)
  Filter: (a = 999)
QUERY PLAN
Index Scan using demo_b on demo (cost=0.28..8.29 rows=1 width=8)
  Index Cond: (b = 999)
  Filter: (a > 999)
QUERY PLAN
Index Scan using demo_b on demo (cost=0.28..8.29 rows=1 width=8)
  Index Cond: (b > 999)
  Filter: (a > 999)