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?.
CREATE TABLE
INSERT 0 5
CREATE FUNCTION
id js ade empty_input null_input
1 {"a": 42, "b": 43, "c": 44, "d": 97} {"a": 42, "d": 97} null null
2 {"a": 42, "b": 43, "c": 44, "d": 97, "e": {"a": [1, 2, 3]}} {"a": 42, "d": 97, "e": {"a": [1, 2, 3]}} null null
3 {"a": 42} {"a": 42} null null
4 {} null null null
5 null null null null
SELECT 5
CREATE FUNCTION
id js ade empty_input null_input
1 {"a": 42, "b": 43, "c": 44, "d": 97} { "a" : 42, "d" : 97 } null null
2 {"a": 42, "b": 43, "c": 44, "d": 97, "e": {"a": [1, 2, 3]}} { "a" : 42, "d" : 97, "e" : {"a": [1, 2, 3]} } null null
3 {"a": 42} { "a" : 42 } null null
4 {} null null null
5 null null null null
SELECT 5
CREATE FUNCTION
id js ade empty_input null_input
1 {"a": 42, "b": 43, "c": 44, "d": 97} { "a" : 42, "d" : 97 } null null
2 {"a": 42, "b": 43, "c": 44, "d": 97, "e": {"a": [1, 2, 3]}} { "a" : 42, "e" : {"a": [1, 2, 3]}, "d" : 97 } null null
3 {"a": 42} { "a" : 42 } null null
4 {} null null null
5 null null null null
SELECT 5