Skip to content
bench

[postgres] Sort Ascending #1043

Sign in to view logs

[postgres] Sort Ascending

[postgres] Sort Ascending #1043

Triggered via pull request December 2, 2024 21:44
@hinthornwhinthornw
opened #2594
wfh/sort_ascending
Status Success
Total duration 48m 0s
Artifacts –

bench.yml

on: pull_request
benchmark
47m 47s
benchmark
Fit to window
Zoom out
Zoom in

Annotations

1 warning and 2 notices
benchmark
ubuntu-latest pipelines will use ubuntu-24.04 soon. For more details, see https://github.com/actions/runner-images/issues/10636
Benchmark results: libs/checkpoint-postgres/langgraph/store/postgres/base.py#L1
......................................... fanout_to_subgraph_10x: Mean +- std dev: 61.0 ms +- 1.5 ms ......................................... fanout_to_subgraph_10x_sync: Mean +- std dev: 51.2 ms +- 0.6 ms ......................................... fanout_to_subgraph_10x_checkpoint: Mean +- std dev: 91.3 ms +- 8.0 ms ......................................... fanout_to_subgraph_10x_checkpoint_sync: Mean +- std dev: 93.0 ms +- 1.7 ms ......................................... fanout_to_subgraph_100x: Mean +- std dev: 640 ms +- 38 ms ......................................... fanout_to_subgraph_100x_sync: Mean +- std dev: 510 ms +- 8 ms ......................................... fanout_to_subgraph_100x_checkpoint: Mean +- std dev: 1.04 sec +- 0.04 sec ......................................... fanout_to_subgraph_100x_checkpoint_sync: Mean +- std dev: 933 ms +- 21 ms ......................................... react_agent_10x: Mean +- std dev: 30.6 ms +- 0.9 ms ......................................... react_agent_10x_sync: Mean +- std dev: 22.2 ms +- 0.2 ms ......................................... react_agent_10x_checkpoint: Mean +- std dev: 46.4 ms +- 0.9 ms ......................................... react_agent_10x_checkpoint_sync: Mean +- std dev: 36.6 ms +- 0.8 ms ......................................... react_agent_100x: Mean +- std dev: 342 ms +- 7 ms ......................................... react_agent_100x_sync: Mean +- std dev: 273 ms +- 4 ms ......................................... react_agent_100x_checkpoint: Mean +- std dev: 951 ms +- 25 ms ......................................... react_agent_100x_checkpoint_sync: Mean +- std dev: 832 ms +- 12 ms ......................................... wide_state_25x300: Mean +- std dev: 24.0 ms +- 0.5 ms ......................................... wide_state_25x300_sync: Mean +- std dev: 15.4 ms +- 0.3 ms ......................................... wide_state_25x300_checkpoint: Mean +- std dev: 279 ms +- 6 ms ......................................... wide_state_25x300_checkpoint_sync: Mean +- std dev: 267 ms +- 6 ms ......................................... wide_state_15x600: Mean +- std dev: 27.9 ms +- 0.4 ms ......................................... wide_state_15x600_sync: Mean +- std dev: 17.8 ms +- 0.4 ms ......................................... wide_state_15x600_checkpoint: Mean +- std dev: 480 ms +- 10 ms ......................................... wide_state_15x600_checkpoint_sync: Mean +- std dev: 464 ms +- 10 ms ......................................... wide_state_9x1200: Mean +- std dev: 28.0 ms +- 0.5 ms ......................................... wide_state_9x1200_sync: Mean +- std dev: 17.7 ms +- 0.3 ms ......................................... wide_state_9x1200_checkpoint: Mean +- std dev: 317 ms +- 8 ms ......................................... wide_state_9x1200_checkpoint_sync: Mean +- std dev: 299 ms +- 3 ms
Comparison against main: libs/checkpoint-postgres/langgraph/store/postgres/base.py#L1
+-----------------------------------------+---------+------------------------+ | Benchmark | main | changes | +=========================================+=========+========================+ | fanout_to_subgraph_10x | 62.0 ms | 61.0 ms: 1.02x faster | +-----------------------------------------+---------+------------------------+ | fanout_to_subgraph_10x_sync | 52.0 ms | 51.2 ms: 1.02x faster | +-----------------------------------------+---------+------------------------+ | wide_state_9x1200_checkpoint_sync | 297 ms | 299 ms: 1.01x slower | +-----------------------------------------+---------+------------------------+ | wide_state_25x300_checkpoint | 277 ms | 279 ms: 1.01x slower | +-----------------------------------------+---------+------------------------+ | wide_state_15x600_sync | 17.7 ms | 17.8 ms: 1.01x slower | +-----------------------------------------+---------+------------------------+ | wide_state_9x1200 | 27.8 ms | 28.0 ms: 1.01x slower | +-----------------------------------------+---------+------------------------+ | react_agent_100x | 340 ms | 342 ms: 1.01x slower | +-----------------------------------------+---------+------------------------+ | wide_state_25x300 | 23.9 ms | 24.0 ms: 1.01x slower | +-----------------------------------------+---------+------------------------+ | wide_state_15x600_checkpoint | 476 ms | 480 ms: 1.01x slower | +-----------------------------------------+---------+------------------------+ | react_agent_100x_checkpoint_sync | 823 ms | 832 ms: 1.01x slower | +-----------------------------------------+---------+------------------------+ | react_agent_100x_sync | 270 ms | 273 ms: 1.01x slower | +-----------------------------------------+---------+------------------------+ | wide_state_9x1200_checkpoint | 312 ms | 317 ms: 1.01x slower | +-----------------------------------------+---------+------------------------+ | fanout_to_subgraph_100x_checkpoint_sync | 914 ms | 933 ms: 1.02x slower | +-----------------------------------------+---------+------------------------+ | fanout_to_subgraph_100x_sync | 499 ms | 510 ms: 1.02x slower | +-----------------------------------------+---------+------------------------+ | react_agent_100x_checkpoint | 924 ms | 951 ms: 1.03x slower | +-----------------------------------------+---------+------------------------+ | fanout_to_subgraph_100x | 593 ms | 640 ms: 1.08x slower | +-----------------------------------------+---------+------------------------+ | fanout_to_subgraph_100x_checkpoint | 927 ms | 1.04 sec: 1.12x slower | +-----------------------------------------+---------+------------------------+ | Geometric mean | (ref) | 1.01x slower | +-----------------------------------------+---------+------------------------+ Benchmark hidden because not significant (11): fanout_to_subgraph_10x_checkpoint, fanout_to_subgraph_10x_checkpoint_sync, react_agent_10x_sync, react_agent_10x, react_agent_10x_checkpoint, wide_state_9x1200_sync, wide_state_15x600, react_agent_10x_checkpoint_sync, wide_state_15x600_checkpoint_sync, wide_state_25x300_sync, wide_state_25x300_checkpoint_sync