Postgres 11

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 invoices(
   eventname varchar,
   quantity varchar,
   section varchar,
   rownumber varchar,
   secondrow varchar,
   lowseat int,
   highseat int,
   status varchar,
   created_at timestamp default now() not null,
   updated_at timestamp
);

INSERT INTO invoices VALUES
  ('2018 ACC Basketball Tournament - Session 4 (Miami vs North Carolina and Duke vs Notre Dame)'  , '2', '227', '15', null,  '9', '10', 'DEPLETED', '2019-02-06 00:46:13.286828', null)
, ('2018 ACC Basketball Tournament - Session 4 (Miami vs North Carolina and Duke vs Notre Dame)'  , '2', '227', '15', null,  '7',  '8', 'DEPLETED', '2019-02-06 00:46:13.286828', null)
, ('2018 ACC Basketball Tournament - Session 4 (Miami vs North Carolina and Duke vs Notre Dame)'  , '2', '227', '14', null, '23', '24', 'DEPLETED', '2019-02-06 00:46:13.286828', null)
, ('2018 ACC Basketball Tournament - Session 4 (Miami vs North Carolina and Duke vs Notre Dame)'  , '1', '227', '13', null, '21', '21', 'DEPLETED', '2019-02-06 00:46:13.286828', null)
, ('2018 ACC Basketball Tournament - Session 4 (Miami vs North Carolina and Duke vs Notre Dame)'  , '8', '227', '14', null, '15', '22', 'DEPLETED', '2019-02-06 00:46:13.286828', null)
, ('2018 ACC Basketball Tournament - Session 4 (Miami vs North Carolina and Duke vs Notre Dame)'  , '1', '227', '14', null,  '1',  '1', 'DEPLETED', '2019-02-06 00:46:13.286828', null)
, ('2018 ACC Basketball Tournament - Session 4 (Miami vs North Carolina and Duke vs Notre Dame)'  , '2', 'A57', 'GA', null,  '1',  '2', 'DEPLETED', '2019-02-06 00:46:13.286828', null)
, ('2018 ACC Basketball Tournament - Session 4 (Miami vs North Carolina and Duke vs Notre Dame)'  , '3', 'A57', 'GA', null,  '3',  '5', 'DEPLETED', '2019-02-06 00:46:13.286828', null)
, ('2018 ACC Basketball Tournament - Session 5 (Virginia vs. Clemson and Duke vs. North Carolina)', '3', '228', '14', null,  '1',  '3', 'DEPLETED', '2019-02-06 00:46:13.286828', null)
, ('Penn State Nittany Lions at Pittsburgh Panthers'                                              , '2', '227', 'K' , null, '25', '26', 'DEPLETED', '2019-02-06 00:46:13.286828', null)
;

10 rows affected

eventname	quantity	section	rownumber	secondrow	lowseat	highseat	status	created_at	updated_at	gap	rn	len	island
2018 ACC Basketball Tournament - Session 4 (Miami vs North Carolina and Duke vs Notre Dame)	1	227	14	null	1	1	DEPLETED	2019-02-06 00:46:13.286828	null	null	3	0	0
2018 ACC Basketball Tournament - Session 4 (Miami vs North Carolina and Duke vs Notre Dame)	2	227	15	null	7	8	DEPLETED	2019-02-06 00:46:13.286828	null	t	5	1	1
2018 ACC Basketball Tournament - Session 4 (Miami vs North Carolina and Duke vs Notre Dame)	2	227	15	null	9	10	DEPLETED	2019-02-06 00:46:13.286828	null	t	6	1	2
2018 ACC Basketball Tournament - Session 4 (Miami vs North Carolina and Duke vs Notre Dame)	1	227	13	null	21	21	DEPLETED	2019-02-06 00:46:13.286828	null	null	8	0	3
2018 ACC Basketball Tournament - Session 4 (Miami vs North Carolina and Duke vs Notre Dame)	2	227	14	null	23	24	DEPLETED	2019-02-06 00:46:13.286828	null	t	9	1	4
Penn State Nittany Lions at Pittsburgh Panthers	2	227	K	null	25	26	DEPLETED	2019-02-06 00:46:13.286828	null	t	10	1	5