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?.
5 rows affected
| date | user | plan_name |
|---|---|---|
| 2019-10-01 | a | basic |
| 2019-10-02 | a | basic |
| 2019-10-03 | a | basic |
| 2019-10-04 | a | basic |
| 2019-10-05 | a | basic |
| 2019-10-06 | a | basic |
| 2019-10-07 | a | basic |
| 2019-10-08 | a | basic |
| 2019-10-09 | a | basic |
| 2019-10-10 | a | basic |
| 2019-10-11 | a | basic |
| 2019-10-12 | a | basic |
| 2019-10-13 | a | basic |
| 2019-10-14 | a | basic |
| 2019-10-15 | a | basic |
| 2019-10-16 | a | standard |
| 2019-10-17 | a | standard |
| 2019-10-18 | a | standard |
| 2019-10-19 | a | standard |
| 2019-10-20 | a | standard |
| 2019-10-01 | b | null |
| 2019-10-02 | b | null |
| 2019-10-03 | b | null |
| 2019-10-04 | b | null |
| 2019-10-05 | b | null |
| 2019-10-06 | b | null |
| 2019-10-07 | b | null |
| 2019-10-08 | b | null |
| 2019-10-09 | b | null |
| 2019-10-10 | b | null |
| 2019-10-11 | b | null |
| 2019-10-12 | b | null |
| 2019-10-13 | b | null |
| 2019-10-14 | b | null |
| 2019-10-15 | b | standard |
| 2019-10-16 | b | standard |
| 2019-10-17 | b | standard |
| 2019-10-18 | b | standard |
| 2019-10-19 | b | standard |
| 2019-10-20 | b | free |
| 2019-10-01 | c | null |
| 2019-10-02 | c | null |
| 2019-10-03 | c | null |
| 2019-10-04 | c | null |
| 2019-10-05 | c | null |
| 2019-10-06 | c | null |
| 2019-10-07 | c | null |
| 2019-10-08 | c | null |
| 2019-10-09 | c | null |
| 2019-10-10 | c | null |
| 2019-10-11 | c | null |
| 2019-10-12 | c | null |
| 2019-10-13 | c | null |
| 2019-10-14 | c | null |
| 2019-10-15 | c | null |
| 2019-10-16 | c | free |
| 2019-10-17 | c | free |
| 2019-10-18 | c | free |
| 2019-10-19 | c | free |
| 2019-10-20 | c | free |