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?.
CREATE TABLE
first_name id total type
Joe 1234 13 onsite
Joe 1234 9 remote
Jane 4321 99 remote
Jane 4321 1 onsite
INSERT 0 4
first_name id onsite remote
Jane 4321 1 99
Joe 1234 13 9
SELECT 2
CREATE EXTENSION
first_name id onsite remote
Jane 4321 1 99
Joe 1234 13 9
SELECT 2