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?.
5 rows affected
id cat value updated_at
1 cat1 v1 2021-01-06 00:00:01+00
2 cat1 v2 2021-01-06 00:00:02+00
3 cat1 v3 2021-01-06 00:00:03+00
4 cat2 v1 2021-01-06 00:00:01+00
5 cat2 v2 2021-01-06 00:00:02+00
1 rows affected
1 rows affected
id cat value updated_at
7 cat1 v4 2022-01-01 16:59:00.540916+00
id cat value updated_at
7 cat1 v4 2022-01-01 16:59:00.540916+00
3 cat1 v3 2021-01-06 00:00:03+00
2 cat1 v2 2021-01-06 00:00:02+00
id cat value updated_at
7 cat1 v4 2022-01-01 16:59:00.540916+00
3 cat1 v3 2021-01-06 00:00:03+00
2 cat1 v2 2021-01-06 00:00:02+00
1 cat1 v1 2021-01-06 00:00:01+00
6 cat2 v3 2022-01-01 16:59:00.539187+00
5 cat2 v2 2021-01-06 00:00:02+00
4 cat2 v1 2021-01-06 00:00:01+00
1 rows affected
id cat value updated_at
7 cat1 v4 2022-01-01 16:59:00.540916+00
3 cat1 v3 2021-01-06 00:00:03+00
2 cat1 v2 2021-01-06 00:00:02+00
6 cat2 v3 2022-01-01 16:59:00.539187+00
5 cat2 v2 2021-01-06 00:00:02+00
4 cat2 v1 2021-01-06 00:00:01+00