1f9fa8b -- script: -- -- Number walk timings on the sandbox (rolled back). shipped = private.check_document_structure as committed; -- -- per_row = the same sum over jsonb_path_query row by row (the 3eba6d8 form). -- \timing on -- begin; -- create function pg_temp.per_row(p jsonb) returns bigint language plpgsql as $f$ -- declare v jsonb; t bigint := 0; -- begin -- for v in select jsonb_path_query(p, 'strict $.** ? (@.type() == "number")') loop t := t + octet_length(v::text); end loop; -- return t; -- end $f$; -- create temp table d as select n, (select content from public.anatomical_sheet_versions order by version_number limit 1) -- || jsonb_build_object('pad', (select jsonb_agg(0) from generate_series(1, n))) as doc from unnest(array[50000,100000,200000,400000,600000]) n; -- \echo per_row 50000 -- select pg_temp.per_row(doc) from d where n = 50000; -- \echo per_row 100000 -- select pg_temp.per_row(doc) from d where n = 100000; -- \echo per_row 200000 -- select pg_temp.per_row(doc) from d where n = 200000; -- \echo shipped 100000 -- select private.check_document_structure(doc) from d where n = 100000; -- \echo shipped 200000 -- select private.check_document_structure(doc) from d where n = 200000; -- \echo shipped 400000 -- select private.check_document_structure(doc) from d where n = 400000; -- \echo shipped 600000 -- select private.check_document_structure(doc) from d where n = 600000; -- rollback; Time: 0.086 ms Time: 1.163 ms Time: 603.977 ms per_row 50000 per_row --------- 50692 (1 row) Time: 137.844 ms per_row 100000 per_row --------- 100692 (1 row) Time: 506.026 ms per_row 200000 per_row --------- 200692 (1 row) Time: 2172.483 ms (00:02.172) shipped 100000 check_document_structure -------------------------- (1 row) Time: 68.834 ms shipped 200000 check_document_structure -------------------------- (1 row) Time: 134.571 ms shipped 400000 check_document_structure -------------------------- (1 row) Time: 267.344 ms shipped 600000 check_document_structure -------------------------- (1 row) Time: 421.337 ms Time: 0.498 ms