Files
faunosteo/.claude/audits/2026-10-28-v1-2-1-number-walk.out
bchanot 532c61e087 docs(docs): V1-2.1 measured equine size, e2e:sheet-assets citers, logs
The M5 row gives the measured content::text size; §15 and §16.4 point the
e2e:sheet-assets rerun to the owner; the walk log carries its script and
the HTTP timing lines are committed.
2026-10-28 21:15:08 +01:00

83 lines
2.1 KiB
Plaintext

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