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 3
id num_nulls
1 2
2 0
3 1
SELECT 3
id num_nulls
1 2
2 0
3 1
SELECT 3
CREATE FUNCTION
attrelid attname atttypid attstattarget attlen attnum attndims attcacheoff atttypmod attbyval attalign attstorage attcompression attnotnull atthasdef atthasmissing attidentity attgenerated attisdropped attislocal attinhcount attcollation attacl attoptions attfdwoptions attmissingval
1255 oid 26 -1 4 1 0 -1 -1 t i p t f f f t 0 0 null null null null
1255 proname 19 -1 64 2 0 -1 -1 f c p t f f f t 0 950 null null null null
1255 pronamespace 26 -1 4 3 0 -1 -1 t i p t f f f t 0 0 null null null null
SELECT 3
f_num_nulls
4
4
4
SELECT 3
column1 column2 column3 column4 column5 num_nulls
null hi 2 null null 2
null hi 2 null null 2
hi 2 3 test 0
null hi 2 3 null 1
SELECT 4
column1 column2 column3 column4 column5 j num_nulls1 num_nulls2 num_nulls3
null hi 2 null null {"column1":null,"column2":"hi","column3":2,"column4":null,"column5":"null"} 2 2 2
null hi 2 null null {"column1":null,"column2":"hi","column3":2,"column4":null,"column5":"null"} 2 2 2
hi 2 3 test {"column1":"","column2":"hi","column3":2,"column4":3,"column5":"test"} 0 0 0
null hi 2 3 null {"column1":null,"column2":"hi","column3":2,"column4":3,"column5":"null"} 1 1 1
SELECT 4