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
order_action | ts | grp |
---|---|---|
buy | 2013-10-03 13:03:02 | 4 |
buy | 2013-10-08 13:03:02 | 4 |
sell | 2013-10-10 15:58:02 | 4 |
buy | 2013-11-01 09:30:02 | 3 |
buy | 2013-11-01 14:03:02 | 3 |
sell | 2013-11-07 10:34:02 | 3 |
buy | 2013-12-03 15:46:02 | 2 |
sell | 2013-12-09 16:00:03 | 2 |
buy | 2013-12-11 13:02:02 | 1 |
sell | 2013-12-18 15:59:03 | 1 |
order_action | ts | grp |
---|---|---|
buy | 2013-10-03 13:03:02 | 0 |
buy | 2013-10-08 13:03:02 | 0 |
sell | 2013-10-10 15:58:02 | 0 |
buy | 2013-11-01 09:30:02 | 1 |
buy | 2013-11-01 14:03:02 | 1 |
sell | 2013-11-07 10:34:02 | 1 |
buy | 2013-12-03 15:46:02 | 2 |
sell | 2013-12-09 16:00:03 | 2 |
buy | 2013-12-11 13:02:02 | 3 |
sell | 2013-12-18 15:59:03 | 3 |
order_action | ts | grp |
---|---|---|
buy | 2013-10-03 13:03:02 | 4 |
buy | 2013-10-08 13:03:02 | 4 |
sell | 2013-10-10 15:58:02 | 4 |
buy | 2013-11-01 09:30:02 | 3 |
buy | 2013-11-01 14:03:02 | 3 |
sell | 2013-11-07 10:34:02 | 3 |
buy | 2013-12-03 15:46:02 | 2 |
sell | 2013-12-09 16:00:03 | 2 |
buy | 2013-12-11 13:02:02 | 1 |
sell | 2013-12-18 15:59:03 | 1 |
order_action | ts | grp |
---|---|---|
buy | 2013-10-03 13:03:02 | 0 |
buy | 2013-10-08 13:03:02 | 0 |
sell | 2013-10-10 15:58:02 | 0 |
buy | 2013-11-01 09:30:02 | 1 |
buy | 2013-11-01 14:03:02 | 1 |
sell | 2013-11-07 10:34:02 | 1 |
buy | 2013-12-03 15:46:02 | 2 |
sell | 2013-12-09 16:00:03 | 2 |
buy | 2013-12-11 13:02:02 | 3 |
sell | 2013-12-18 15:59:03 | 3 |