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?.
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 |