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