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.
83 lines
2.1 KiB
Plaintext
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
|