Partitioned PG11: insert.sql
pgbench -n -T 60 -f insert.sql -Dtbl=p16 rosmerta_vof
transaction type: insert.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 10445
latency average = 5.744 ms
tps = 174.081740 (including connections establishing)
tps = 174.088280 (excluding connections establishing)
TimescaleDb PG11: insert.sql
pgbench -n -T 60 -f insert.sql -Dtbl=ts16 rosmerta_vof
transaction type: insert.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 8848
latency average = 6.782 ms
tps = 147.459264 (including connections establishing)
tps = 147.466031 (excluding connections establishing)
Partitioned PG12: insert.sql
pgbench -n -T 60 -f insert.sql -Dtbl=p16 -p 4432
transaction type: insert.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 16629
latency average = 3.608 ms
tps = 277.137229 (including connections establishing)
tps = 277.149228 (excluding connections establishing)
Partitioned PG11: select_static.sql
pgbench -n -T 60 -f select_static.sql -Dtbl=p16 rosmerta_vof
transaction type: select_static.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 169949
latency average = 0.353 ms
tps = 2832.469075 (including connections establishing)
tps = 2832.596881 (excluding connections establishing)
TimescaleDb PG11: select_static.sql
pgbench -n -T 60 -f select_static.sql -Dtbl=ts16 rosmerta_vof
transaction type: select_static.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 73578
latency average = 0.815 ms
tps = 1226.291135 (including connections establishing)
tps = 1226.341644 (excluding connections establishing)
Partitioned PG12: select_static.sql
pgbench -n -T 60 -f select_static.sql -Dtbl=p16 -p 4432
transaction type: select_static.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 301338
latency average = 0.199 ms
tps = 5022.287655 (including connections establishing)
tps = 5022.474060 (excluding connections establishing)
Partitioned PG11: select_static_fnc.sql -Dfnc=p16at
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p16at -Dtbl=p16 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 161681
latency average = 0.371 ms
tps = 2694.669969 (including connections establishing)
tps = 2694.772223 (excluding connections establishing)
TimescaleDb PG11: select_static_fnc.sql -Dfnc=ts16at
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=ts16at -Dtbl=ts16 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 106271
latency average = 0.565 ms
tps = 1771.174751 (including connections establishing)
tps = 1771.284738 (excluding connections establishing)
Partitioned PG12: select_static_fnc.sql -Dfnc=p16at
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p16at -Dtbl=p16 -p 4432
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 257395
latency average = 0.233 ms
tps = 4289.912157 (including connections establishing)
tps = 4290.089070 (excluding connections establishing)
Partitioned PG11: select_static_fnc.sql -Dfnc=p16at_ni
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p16at_ni -Dtbl=p16 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 108208
latency average = 0.554 ms
tps = 1803.457937 (including connections establishing)
tps = 1803.535042 (excluding connections establishing)
TimescaleDb PG11: select_static_fnc.sql -Dfnc=ts16at_ni
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=ts16at_ni -Dtbl=ts16 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 72358
latency average = 0.829 ms
tps = 1205.955114 (including connections establishing)
tps = 1206.015774 (excluding connections establishing)
Partitioned PG12: select_static_fnc.sql -Dfnc=p16at_ni
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p16at_ni -Dtbl=p16 -p 4432
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 120297
latency average = 0.499 ms
tps = 2004.935683 (including connections establishing)
tps = 2005.042653 (excluding connections establishing)
Partitioned PG11: select_static_fnc.sql -Dfnc=p16at_ni_plpg
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p16at_ni_plpg -Dtbl=p16 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 354616
latency average = 0.169 ms
tps = 5910.257333 (including connections establishing)
tps = 5910.557740 (excluding connections establishing)
TimescaleDb PG11: select_static_fnc.sql -Dfnc=ts16at_ni_plpg
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=ts16at_ni_plpg -Dtbl=ts16 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 70350
latency average = 0.853 ms
tps = 1172.494955 (including connections establishing)
tps = 1172.544373 (excluding connections establishing)
Partitioned PG12: select_static_fnc.sql -Dfnc=p16at_ni_plpg
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p16at_ni_plpg -Dtbl=p16 -p 4432
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 258476
latency average = 0.232 ms
tps = 4307.912768 (including connections establishing)
tps = 4308.136898 (excluding connections establishing)
Partitioned PG11: select_static_fnc.sql -Dfnc=p16_limit_at
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p16_limit_at -Dtbl=p16 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 147371
latency average = 0.407 ms
tps = 2456.178433 (including connections establishing)
tps = 2456.261927 (excluding connections establishing)
TimescaleDb PG11: select_static_fnc.sql -Dfnc=ts16_limit_at
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=ts16_limit_at -Dtbl=ts16 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 99709
latency average = 0.602 ms
tps = 1661.801636 (including connections establishing)
tps = 1661.867625 (excluding connections establishing)
Partitioned PG12: select_static_fnc.sql -Dfnc=p16_limit_at
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p16_limit_at -Dtbl=p16 -p 4432
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 232411
latency average = 0.258 ms
tps = 3873.511328 (including connections establishing)
tps = 3873.683301 (excluding connections establishing)
Partitioned PG11: select_now.sql
pgbench -n -T 60 -f select_now.sql -Dtbl=p16 rosmerta_vof
transaction type: select_now.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 115399
latency average = 0.520 ms
tps = 1923.305386 (including connections establishing)
tps = 1923.380781 (excluding connections establishing)
TimescaleDb PG11: select_now.sql
pgbench -n -T 60 -f select_now.sql -Dtbl=ts16 rosmerta_vof
transaction type: select_now.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 71569
latency average = 0.838 ms
tps = 1192.801088 (including connections establishing)
tps = 1192.844239 (excluding connections establishing)
Partitioned PG12: select_now.sql
pgbench -n -T 60 -f select_now.sql -Dtbl=p16 -p 4432
transaction type: select_now.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 117900
latency average = 0.509 ms
tps = 1964.996164 (including connections establishing)
tps = 1965.070045 (excluding connections establishing)
Partitioned PG11: select_now_fnc.sql -Dfnc=p16at
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p16at -Dtbl=p16 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 108803
latency average = 0.551 ms
tps = 1813.379426 (including connections establishing)
tps = 1813.443672 (excluding connections establishing)
TimescaleDb PG11: select_now_fnc.sql -Dfnc=ts16at
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=ts16at -Dtbl=ts16 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 63237
latency average = 0.949 ms
tps = 1053.944354 (including connections establishing)
tps = 1053.980563 (excluding connections establishing)
Partitioned PG12: select_now_fnc.sql -Dfnc=p16at
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p16at -Dtbl=p16 -p 4432
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 94059
latency average = 0.638 ms
tps = 1567.637089 (including connections establishing)
tps = 1567.704940 (excluding connections establishing)
Partitioned PG11: select_now_fnc.sql -Dfnc=p16at_ni
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p16at_ni -Dtbl=p16 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 109763
latency average = 0.547 ms
tps = 1829.372398 (including connections establishing)
tps = 1829.436692 (excluding connections establishing)
TimescaleDb PG11: select_now_fnc.sql -Dfnc=ts16at_ni
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=ts16at_ni -Dtbl=ts16 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 72870
latency average = 0.823 ms
tps = 1214.494466 (including connections establishing)
tps = 1214.554090 (excluding connections establishing)
Partitioned PG12: select_now_fnc.sql -Dfnc=p16at_ni
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p16at_ni -Dtbl=p16 -p 4432
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 121102
latency average = 0.495 ms
tps = 2018.360254 (including connections establishing)
tps = 2018.435019 (excluding connections establishing)
Partitioned PG11: select_now_fnc.sql -Dfnc=p16at_ni_plpg
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p16at_ni_plpg -Dtbl=p16 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 373406
latency average = 0.161 ms
tps = 6223.408258 (including connections establishing)
tps = 6223.636374 (excluding connections establishing)
TimescaleDb PG11: select_now_fnc.sql -Dfnc=ts16at_ni_plpg
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=ts16at_ni_plpg -Dtbl=ts16 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 267629
latency average = 0.224 ms
tps = 4460.472876 (including connections establishing)
tps = 4460.657658 (excluding connections establishing)
Partitioned PG12: select_now_fnc.sql -Dfnc=p16at_ni_plpg
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p16at_ni_plpg -Dtbl=p16 -p 4432
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 377918
latency average = 0.159 ms
tps = 6298.606954 (including connections establishing)
tps = 6298.852304 (excluding connections establishing)
Partitioned PG11: select_now_fnc.sql -Dfnc=p16_limit_at
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p16_limit_at -Dtbl=p16 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 69712
latency average = 0.861 ms
tps = 1161.864709 (including connections establishing)
tps = 1161.905375 (excluding connections establishing)
TimescaleDb PG11: select_now_fnc.sql -Dfnc=ts16_limit_at
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=ts16_limit_at -Dtbl=ts16 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 55768
latency average = 1.076 ms
tps = 929.456948 (including connections establishing)
tps = 929.496710 (excluding connections establishing)
Partitioned PG12: select_now_fnc.sql -Dfnc=p16_limit_at
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p16_limit_at -Dtbl=p16 -p 4432
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 93813
latency average = 0.640 ms
tps = 1563.548709 (including connections establishing)
tps = 1563.614257 (excluding connections establishing)
Partitioned PG11: select_nested_loop.sql
pgbench -n -T 60 -f select_nested_loop.sql -Dtbl=p16 rosmerta_vof
transaction type: select_nested_loop.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 47094
latency average = 1.274 ms
tps = 784.884600 (including connections establishing)
tps = 784.916247 (excluding connections establishing)
TimescaleDb PG11: select_nested_loop.sql
pgbench -n -T 60 -f select_nested_loop.sql -Dtbl=ts16 rosmerta_vof
transaction type: select_nested_loop.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 33621
latency average = 1.785 ms
tps = 560.343335 (including connections establishing)
tps = 560.364525 (excluding connections establishing)
Partitioned PG12: select_nested_loop.sql
pgbench -n -T 60 -f select_nested_loop.sql -Dtbl=p16 -p 4432
transaction type: select_nested_loop.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 60789
latency average = 0.987 ms
tps = 1013.142740 (including connections establishing)
tps = 1013.194945 (excluding connections establishing)
Partitioned PG11: insert.sql
pgbench -n -T 60 -f insert.sql -Dtbl=p64 rosmerta_vof
transaction type: insert.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 11697
latency average = 5.130 ms
tps = 194.937835 (including connections establishing)
tps = 194.945397 (excluding connections establishing)
TimescaleDb PG11: insert.sql
pgbench -n -T 60 -f insert.sql -Dtbl=ts64 rosmerta_vof
transaction type: insert.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 10753
latency average = 5.580 ms
tps = 179.211415 (including connections establishing)
tps = 179.218684 (excluding connections establishing)
Partitioned PG12: insert.sql
pgbench -n -T 60 -f insert.sql -Dtbl=p64 -p 4432
transaction type: insert.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 17464
latency average = 3.436 ms
tps = 291.059312 (including connections establishing)
tps = 291.070192 (excluding connections establishing)
Partitioned PG11: select_static.sql
pgbench -n -T 60 -f select_static.sql -Dtbl=p64 rosmerta_vof
transaction type: select_static.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 83685
latency average = 0.717 ms
tps = 1394.737857 (including connections establishing)
tps = 1394.790145 (excluding connections establishing)
TimescaleDb PG11: select_static.sql
pgbench -n -T 60 -f select_static.sql -Dtbl=ts64 rosmerta_vof
transaction type: select_static.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 73084
latency average = 0.821 ms
tps = 1218.044926 (including connections establishing)
tps = 1218.103086 (excluding connections establishing)
Partitioned PG12: select_static.sql
pgbench -n -T 60 -f select_static.sql -Dtbl=p64 -p 4432
transaction type: select_static.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 303352
latency average = 0.198 ms
tps = 5055.847207 (including connections establishing)
tps = 5056.099770 (excluding connections establishing)
Partitioned PG11: select_static_fnc.sql -Dfnc=p64at
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p64at -Dtbl=p64 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 79348
latency average = 0.756 ms
tps = 1322.439776 (including connections establishing)
tps = 1322.495753 (excluding connections establishing)
TimescaleDb PG11: select_static_fnc.sql -Dfnc=ts64at
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=ts64at -Dtbl=ts64 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 40665
latency average = 1.475 ms
tps = 677.742966 (including connections establishing)
tps = 677.765934 (excluding connections establishing)
Partitioned PG12: select_static_fnc.sql -Dfnc=p64at
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p64at -Dtbl=p64 -p 4432
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 259718
latency average = 0.231 ms
tps = 4328.621374 (including connections establishing)
tps = 4328.790385 (excluding connections establishing)
Partitioned PG11: select_static_fnc.sql -Dfnc=p64at_ni
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p64at_ni -Dtbl=p64 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 40069
latency average = 1.497 ms
tps = 667.809870 (including connections establishing)
tps = 667.841150 (excluding connections establishing)
TimescaleDb PG11: select_static_fnc.sql -Dfnc=ts64at_ni
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=ts64at_ni -Dtbl=ts64 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 18676
latency average = 3.213 ms
tps = 311.265658 (including connections establishing)
tps = 311.281211 (excluding connections establishing)
Partitioned PG12: select_static_fnc.sql -Dfnc=p64at_ni
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p64at_ni -Dtbl=p64 -p 4432
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 43925
latency average = 1.366 ms
tps = 732.072634 (including connections establishing)
tps = 732.108387 (excluding connections establishing)
Partitioned PG11: select_static_fnc.sql -Dfnc=p64at_ni_plpg
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p64at_ni_plpg -Dtbl=p64 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 280429
latency average = 0.214 ms
tps = 4673.800503 (including connections establishing)
tps = 4673.984093 (excluding connections establishing)
TimescaleDb PG11: select_static_fnc.sql -Dfnc=ts64at_ni_plpg
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=ts64at_ni_plpg -Dtbl=ts64 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 72343
latency average = 0.829 ms
tps = 1205.714028 (including connections establishing)
tps = 1205.779654 (excluding connections establishing)
Partitioned PG12: select_static_fnc.sql -Dfnc=p64at_ni_plpg
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p64at_ni_plpg -Dtbl=p64 -p 4432
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 256039
latency average = 0.234 ms
tps = 4267.308469 (including connections establishing)
tps = 4267.462717 (excluding connections establishing)
Partitioned PG11: select_static_fnc.sql -Dfnc=p64_limit_at
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p64_limit_at -Dtbl=p64 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 73307
latency average = 0.818 ms
tps = 1221.773665 (including connections establishing)
tps = 1221.817747 (excluding connections establishing)
TimescaleDb PG11: select_static_fnc.sql -Dfnc=ts64_limit_at
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=ts64_limit_at -Dtbl=ts64 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 40096
latency average = 1.496 ms
tps = 668.251800 (including connections establishing)
tps = 668.279078 (excluding connections establishing)
Partitioned PG12: select_static_fnc.sql -Dfnc=p64_limit_at
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p64_limit_at -Dtbl=p64 -p 4432
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 233010
latency average = 0.258 ms
tps = 3883.481668 (including connections establishing)
tps = 3883.652585 (excluding connections establishing)
Partitioned PG11: select_now.sql
pgbench -n -T 60 -f select_now.sql -Dtbl=p64 rosmerta_vof
transaction type: select_now.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 38190
latency average = 1.571 ms
tps = 636.493087 (including connections establishing)
tps = 636.518236 (excluding connections establishing)
TimescaleDb PG11: select_now.sql
pgbench -n -T 60 -f select_now.sql -Dtbl=ts64 rosmerta_vof
transaction type: select_now.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 19110
latency average = 3.140 ms
tps = 318.489634 (including connections establishing)
tps = 318.501596 (excluding connections establishing)
Partitioned PG12: select_now.sql
pgbench -n -T 60 -f select_now.sql -Dtbl=p64 -p 4432
transaction type: select_now.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 36693
latency average = 1.635 ms
tps = 611.534242 (including connections establishing)
tps = 611.567249 (excluding connections establishing)
Partitioned PG11: select_now_fnc.sql -Dfnc=p64at
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p64at -Dtbl=p64 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 38411
latency average = 1.562 ms
tps = 640.170291 (including connections establishing)
tps = 640.197713 (excluding connections establishing)
TimescaleDb PG11: select_now_fnc.sql -Dfnc=ts64at
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=ts64at -Dtbl=ts64 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 20376
latency average = 2.945 ms
tps = 339.595145 (including connections establishing)
tps = 339.606457 (excluding connections establishing)
Partitioned PG12: select_now_fnc.sql -Dfnc=p64at
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p64at -Dtbl=p64 -p 4432
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 38428
latency average = 1.561 ms
tps = 640.456660 (including connections establishing)
tps = 640.480070 (excluding connections establishing)
Partitioned PG11: select_now_fnc.sql -Dfnc=p64at_ni
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p64at_ni -Dtbl=p64 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 41498
latency average = 1.446 ms
tps = 691.624363 (including connections establishing)
tps = 691.647745 (excluding connections establishing)
TimescaleDb PG11: select_now_fnc.sql -Dfnc=ts64at_ni
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=ts64at_ni -Dtbl=ts64 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 19110
latency average = 3.140 ms
tps = 318.493818 (including connections establishing)
tps = 318.507062 (excluding connections establishing)
Partitioned PG12: select_now_fnc.sql -Dfnc=p64at_ni
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p64at_ni -Dtbl=p64 -p 4432
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 46122
latency average = 1.301 ms
tps = 768.697362 (including connections establishing)
tps = 768.724009 (excluding connections establishing)
Partitioned PG11: select_now_fnc.sql -Dfnc=p64at_ni_plpg
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p64at_ni_plpg -Dtbl=p64 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 301369
latency average = 0.199 ms
tps = 5022.796549 (including connections establishing)
tps = 5022.965629 (excluding connections establishing)
TimescaleDb PG11: select_now_fnc.sql -Dfnc=ts64at_ni_plpg
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=ts64at_ni_plpg -Dtbl=ts64 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 273993
latency average = 0.219 ms
tps = 4566.539196 (including connections establishing)
tps = 4566.693954 (excluding connections establishing)
Partitioned PG12: select_now_fnc.sql -Dfnc=p64at_ni_plpg
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p64at_ni_plpg -Dtbl=p64 -p 4432
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 383598
latency average = 0.156 ms
tps = 6393.285437 (including connections establishing)
tps = 6393.512747 (excluding connections establishing)
Partitioned PG11: select_now_fnc.sql -Dfnc=p64_limit_at
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p64_limit_at -Dtbl=p64 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 18389
latency average = 3.263 ms
tps = 306.468158 (including connections establishing)
tps = 306.478816 (excluding connections establishing)
TimescaleDb PG11: select_now_fnc.sql -Dfnc=ts64_limit_at
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=ts64_limit_at -Dtbl=ts64 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 16796
latency average = 3.572 ms
tps = 279.932201 (including connections establishing)
tps = 279.942138 (excluding connections establishing)
Partitioned PG12: select_now_fnc.sql -Dfnc=p64_limit_at
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p64_limit_at -Dtbl=p64 -p 4432
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 29743
latency average = 2.017 ms
tps = 495.709657 (including connections establishing)
tps = 495.727988 (excluding connections establishing)
Partitioned PG11: select_nested_loop.sql
pgbench -n -T 60 -f select_nested_loop.sql -Dtbl=p64 rosmerta_vof
transaction type: select_nested_loop.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 15371
latency average = 3.903 ms
tps = 256.182240 (including connections establishing)
tps = 256.190896 (excluding connections establishing)
TimescaleDb PG11: select_nested_loop.sql
pgbench -n -T 60 -f select_nested_loop.sql -Dtbl=ts64 rosmerta_vof
transaction type: select_nested_loop.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 10300
latency average = 5.825 ms
tps = 171.659381 (including connections establishing)
tps = 171.665592 (excluding connections establishing)
Partitioned PG12: select_nested_loop.sql
pgbench -n -T 60 -f select_nested_loop.sql -Dtbl=p64 -p 4432
transaction type: select_nested_loop.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 21133
latency average = 2.839 ms
tps = 352.201782 (including connections establishing)
tps = 352.213944 (excluding connections establishing)
Partitioned PG11: insert.sql
pgbench -n -T 60 -f insert.sql -Dtbl=p256 rosmerta_vof
transaction type: insert.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 11117
latency average = 5.397 ms
tps = 185.273252 (including connections establishing)
tps = 185.280304 (excluding connections establishing)
TimescaleDb PG11: insert.sql
pgbench -n -T 60 -f insert.sql -Dtbl=ts256 rosmerta_vof
transaction type: insert.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 10443
latency average = 5.746 ms
tps = 174.024994 (including connections establishing)
tps = 174.032100 (excluding connections establishing)
Partitioned PG12: insert.sql
pgbench -n -T 60 -f insert.sql -Dtbl=p256 -p 4432
transaction type: insert.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 17290
latency average = 3.470 ms
tps = 288.155182 (including connections establishing)
tps = 288.165390 (excluding connections establishing)
Partitioned PG11: select_static.sql
pgbench -n -T 60 -f select_static.sql -Dtbl=p256 rosmerta_vof
transaction type: select_static.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 24775
latency average = 2.422 ms
tps = 412.910959 (including connections establishing)
tps = 412.926179 (excluding connections establishing)
TimescaleDb PG11: select_static.sql
pgbench -n -T 60 -f select_static.sql -Dtbl=ts256 rosmerta_vof
transaction type: select_static.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 73541
latency average = 0.816 ms
tps = 1225.671537 (including connections establishing)
tps = 1225.735933 (excluding connections establishing)
Partitioned PG12: select_static.sql
pgbench -n -T 60 -f select_static.sql -Dtbl=p256 -p 4432
transaction type: select_static.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 290916
latency average = 0.206 ms
tps = 4848.584402 (including connections establishing)
tps = 4848.795373 (excluding connections establishing)
Partitioned PG11: select_static_fnc.sql -Dfnc=p256at
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p256at -Dtbl=p256 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 24370
latency average = 2.462 ms
tps = 406.153946 (including connections establishing)
tps = 406.169060 (excluding connections establishing)
TimescaleDb PG11: select_static_fnc.sql -Dfnc=ts256at
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=ts256at -Dtbl=ts256 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 12226
latency average = 4.908 ms
tps = 203.758176 (including connections establishing)
tps = 203.767877 (excluding connections establishing)
Partitioned PG12: select_static_fnc.sql -Dfnc=p256at
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p256at -Dtbl=p256 -p 4432
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 258705
latency average = 0.232 ms
tps = 4311.737174 (including connections establishing)
tps = 4311.892797 (excluding connections establishing)
Partitioned PG11: select_static_fnc.sql -Dfnc=p256at_ni
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p256at_ni -Dtbl=p256 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 10941
latency average = 5.484 ms
tps = 182.339180 (including connections establishing)
tps = 182.346984 (excluding connections establishing)
TimescaleDb PG11: select_static_fnc.sql -Dfnc=ts256at_ni
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=ts256at_ni -Dtbl=ts256 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 4195
latency average = 14.303 ms
tps = 69.915829 (including connections establishing)
tps = 69.918877 (excluding connections establishing)
Partitioned PG12: select_static_fnc.sql -Dfnc=p256at_ni
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p256at_ni -Dtbl=p256 -p 4432
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 11963
latency average = 5.016 ms
tps = 199.373102 (including connections establishing)
tps = 199.380591 (excluding connections establishing)
Partitioned PG11: select_static_fnc.sql -Dfnc=p256at_ni_plpg
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p256at_ni_plpg -Dtbl=p256 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 158463
latency average = 0.379 ms
tps = 2641.033561 (including connections establishing)
tps = 2641.129330 (excluding connections establishing)
TimescaleDb PG11: select_static_fnc.sql -Dfnc=ts256at_ni_plpg
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=ts256at_ni_plpg -Dtbl=ts256 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 70860
latency average = 0.847 ms
tps = 1180.997003 (including connections establishing)
tps = 1181.038554 (excluding connections establishing)
Partitioned PG12: select_static_fnc.sql -Dfnc=p256at_ni_plpg
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p256at_ni_plpg -Dtbl=p256 -p 4432
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 261615
latency average = 0.229 ms
tps = 4360.236317 (including connections establishing)
tps = 4360.406415 (excluding connections establishing)
Partitioned PG11: select_static_fnc.sql -Dfnc=p256_limit_at
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p256_limit_at -Dtbl=p256 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 23219
latency average = 2.584 ms
tps = 386.976088 (including connections establishing)
tps = 386.990224 (excluding connections establishing)
TimescaleDb PG11: select_static_fnc.sql -Dfnc=ts256_limit_at
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=ts256_limit_at -Dtbl=ts256 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 11427
latency average = 5.251 ms
tps = 190.444425 (including connections establishing)
tps = 190.451590 (excluding connections establishing)
Partitioned PG12: select_static_fnc.sql -Dfnc=p256_limit_at
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p256_limit_at -Dtbl=p256 -p 4432
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 234381
latency average = 0.256 ms
tps = 3906.340525 (including connections establishing)
tps = 3906.475831 (excluding connections establishing)
Partitioned PG11: select_now.sql
pgbench -n -T 60 -f select_now.sql -Dtbl=p256 rosmerta_vof
transaction type: select_now.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 9850
latency average = 6.091 ms
tps = 164.163328 (including connections establishing)
tps = 164.168826 (excluding connections establishing)
TimescaleDb PG11: select_now.sql
pgbench -n -T 60 -f select_now.sql -Dtbl=ts256 rosmerta_vof
transaction type: select_now.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 4321
latency average = 13.888 ms
tps = 72.002245 (including connections establishing)
tps = 72.005543 (excluding connections establishing)
Partitioned PG12: select_now.sql
pgbench -n -T 60 -f select_now.sql -Dtbl=p256 -p 4432
transaction type: select_now.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 9966
latency average = 6.020 ms
tps = 166.099236 (including connections establishing)
tps = 166.106052 (excluding connections establishing)
Partitioned PG11: select_now_fnc.sql -Dfnc=p256at
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p256at -Dtbl=p256 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 10179
latency average = 5.895 ms
tps = 169.638934 (including connections establishing)
tps = 169.645516 (excluding connections establishing)
TimescaleDb PG11: select_now_fnc.sql -Dfnc=ts256at
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=ts256at -Dtbl=ts256 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 4375
latency average = 13.716 ms
tps = 72.909942 (including connections establishing)
tps = 72.914055 (excluding connections establishing)
Partitioned PG12: select_now_fnc.sql -Dfnc=p256at
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p256at -Dtbl=p256 -p 4432
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 9494
latency average = 6.320 ms
tps = 158.218625 (including connections establishing)
tps = 158.225082 (excluding connections establishing)
Partitioned PG11: select_now_fnc.sql -Dfnc=p256at_ni
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p256at_ni -Dtbl=p256 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 10905
latency average = 5.502 ms
tps = 181.744538 (including connections establishing)
tps = 181.751460 (excluding connections establishing)
TimescaleDb PG11: select_now_fnc.sql -Dfnc=ts256at_ni
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=ts256at_ni -Dtbl=ts256 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 4200
latency average = 14.288 ms
tps = 69.987894 (including connections establishing)
tps = 69.990457 (excluding connections establishing)
Partitioned PG12: select_now_fnc.sql -Dfnc=p256at_ni
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p256at_ni -Dtbl=p256 -p 4432
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 12155
latency average = 4.937 ms
tps = 202.568551 (including connections establishing)
tps = 202.575702 (excluding connections establishing)
Partitioned PG11: select_now_fnc.sql -Dfnc=p256at_ni_plpg
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p256at_ni_plpg -Dtbl=p256 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 159970
latency average = 0.375 ms
tps = 2666.154277 (including connections establishing)
tps = 2666.246706 (excluding connections establishing)
TimescaleDb PG11: select_now_fnc.sql -Dfnc=ts256at_ni_plpg
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=ts256at_ni_plpg -Dtbl=ts256 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 252695
latency average = 0.237 ms
tps = 4211.571430 (including connections establishing)
tps = 4211.734208 (excluding connections establishing)
Partitioned PG12: select_now_fnc.sql -Dfnc=p256at_ni_plpg
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p256at_ni_plpg -Dtbl=p256 -p 4432
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 372350
latency average = 0.161 ms
tps = 6205.819090 (including connections establishing)
tps = 6206.041514 (excluding connections establishing)
Partitioned PG11: select_now_fnc.sql -Dfnc=p256_limit_at
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p256_limit_at -Dtbl=p256 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 3366
latency average = 17.829 ms
tps = 56.089677 (including connections establishing)
tps = 56.091868 (excluding connections establishing)
TimescaleDb PG11: select_now_fnc.sql -Dfnc=ts256_limit_at
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=ts256_limit_at -Dtbl=ts256 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 2992
latency average = 20.056 ms
tps = 49.861524 (including connections establishing)
tps = 49.863835 (excluding connections establishing)
Partitioned PG12: select_now_fnc.sql -Dfnc=p256_limit_at
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p256_limit_at -Dtbl=p256 -p 4432
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 6100
latency average = 9.836 ms
tps = 101.662988 (including connections establishing)
tps = 101.666716 (excluding connections establishing)
Partitioned PG11: select_nested_loop.sql
pgbench -n -T 60 -f select_nested_loop.sql -Dtbl=p256 rosmerta_vof
transaction type: select_nested_loop.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 2711
latency average = 22.140 ms
tps = 45.167019 (including connections establishing)
tps = 45.168820 (excluding connections establishing)
TimescaleDb PG11: select_nested_loop.sql
pgbench -n -T 60 -f select_nested_loop.sql -Dtbl=ts256 rosmerta_vof
transaction type: select_nested_loop.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 2300
latency average = 26.090 ms
tps = 38.328851 (including connections establishing)
tps = 38.330269 (excluding connections establishing)
Partitioned PG12: select_nested_loop.sql
pgbench -n -T 60 -f select_nested_loop.sql -Dtbl=p256 -p 4432
transaction type: select_nested_loop.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 4580
latency average = 13.102 ms
tps = 76.324607 (including connections establishing)
tps = 76.327814 (excluding connections establishing)
Partitioned PG11: insert.sql
pgbench -n -T 60 -f insert.sql -Dtbl=p1024 rosmerta_vof
transaction type: insert.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 9383
latency average = 6.395 ms
tps = 156.382250 (including connections establishing)
tps = 156.387735 (excluding connections establishing)
TimescaleDb PG11: insert.sql
pgbench -n -T 60 -f insert.sql -Dtbl=ts1024 rosmerta_vof
transaction type: insert.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 9543
latency average = 6.288 ms
tps = 159.039791 (including connections establishing)
tps = 159.046434 (excluding connections establishing)
Partitioned PG12: insert.sql
pgbench -n -T 60 -f insert.sql -Dtbl=p1024 -p 4432
transaction type: insert.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 14855
latency average = 4.039 ms
tps = 247.567576 (including connections establishing)
tps = 247.580810 (excluding connections establishing)
Partitioned PG11: select_static.sql
pgbench -n -T 60 -f select_static.sql -Dtbl=p1024 rosmerta_vof
transaction type: select_static.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 2278
latency average = 26.343 ms
tps = 37.960886 (including connections establishing)
tps = 37.962380 (excluding connections establishing)
TimescaleDb PG11: select_static.sql
pgbench -n -T 60 -f select_static.sql -Dtbl=ts1024 rosmerta_vof
transaction type: select_static.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 66344
latency average = 0.904 ms
tps = 1105.731118 (including connections establishing)
tps = 1105.788659 (excluding connections establishing)
Partitioned PG12: select_static.sql
pgbench -n -T 60 -f select_static.sql -Dtbl=p1024 -p 4432
transaction type: select_static.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 272444
latency average = 0.220 ms
tps = 4540.721775 (including connections establishing)
tps = 4540.945210 (excluding connections establishing)
Partitioned PG11: select_static_fnc.sql -Dfnc=p1024at
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p1024at -Dtbl=p1024 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 2310
latency average = 25.978 ms
tps = 38.494294 (including connections establishing)
tps = 38.496586 (excluding connections establishing)
TimescaleDb PG11: select_static_fnc.sql -Dfnc=ts1024at
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=ts1024at -Dtbl=ts1024 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 1557
latency average = 38.542 ms
tps = 25.945797 (including connections establishing)
tps = 25.947109 (excluding connections establishing)
Partitioned PG12: select_static_fnc.sql -Dfnc=p1024at
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p1024at -Dtbl=p1024 -p 4432
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 239076
latency average = 0.251 ms
tps = 3984.587522 (including connections establishing)
tps = 3984.792620 (excluding connections establishing)
Partitioned PG11: select_static_fnc.sql -Dfnc=p1024at_ni
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p1024at_ni -Dtbl=p1024 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 1221
latency average = 49.155 ms
tps = 20.343610 (including connections establishing)
tps = 20.344471 (excluding connections establishing)
TimescaleDb PG11: select_static_fnc.sql -Dfnc=ts1024at_ni
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=ts1024at_ni -Dtbl=ts1024 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 739
latency average = 81.246 ms
tps = 12.308371 (including connections establishing)
tps = 12.309017 (excluding connections establishing)
Partitioned PG12: select_static_fnc.sql -Dfnc=p1024at_ni
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p1024at_ni -Dtbl=p1024 -p 4432
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 1711
latency average = 35.103 ms
tps = 28.487981 (including connections establishing)
tps = 28.488956 (excluding connections establishing)
Partitioned PG11: select_static_fnc.sql -Dfnc=p1024at_ni_plpg
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p1024at_ni_plpg -Dtbl=p1024 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 55887
latency average = 1.074 ms
tps = 931.437440 (including connections establishing)
tps = 931.477609 (excluding connections establishing)
TimescaleDb PG11: select_static_fnc.sql -Dfnc=ts1024at_ni_plpg
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=ts1024at_ni_plpg -Dtbl=ts1024 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 65189
latency average = 0.920 ms
tps = 1086.478734 (including connections establishing)
tps = 1086.524413 (excluding connections establishing)
Partitioned PG12: select_static_fnc.sql -Dfnc=p1024at_ni_plpg
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p1024at_ni_plpg -Dtbl=p1024 -p 4432
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 242391
latency average = 0.248 ms
tps = 4039.841134 (including connections establishing)
tps = 4040.007763 (excluding connections establishing)
Partitioned PG11: select_static_fnc.sql -Dfnc=p1024_limit_at
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p1024_limit_at -Dtbl=p1024 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 2503
latency average = 23.974 ms
tps = 41.711923 (including connections establishing)
tps = 41.713556 (excluding connections establishing)
TimescaleDb PG11: select_static_fnc.sql -Dfnc=ts1024_limit_at
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=ts1024_limit_at -Dtbl=ts1024 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 1754
latency average = 34.214 ms
tps = 29.227921 (including connections establishing)
tps = 29.229176 (excluding connections establishing)
Partitioned PG12: select_static_fnc.sql -Dfnc=p1024_limit_at
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p1024_limit_at -Dtbl=p1024 -p 4432
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 201170
latency average = 0.298 ms
tps = 3352.816712 (including connections establishing)
tps = 3352.995714 (excluding connections establishing)
Partitioned PG11: select_now.sql
pgbench -n -T 60 -f select_now.sql -Dtbl=p1024 rosmerta_vof
transaction type: select_now.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 1161
latency average = 51.715 ms
tps = 19.336812 (including connections establishing)
tps = 19.337787 (excluding connections establishing)
TimescaleDb PG11: select_now.sql
pgbench -n -T 60 -f select_now.sql -Dtbl=ts1024 rosmerta_vof
transaction type: select_now.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 693
latency average = 86.654 ms
tps = 11.540209 (including connections establishing)
tps = 11.540853 (excluding connections establishing)
Partitioned PG12: select_now.sql
pgbench -n -T 60 -f select_now.sql -Dtbl=p1024 -p 4432
transaction type: select_now.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 1163
latency average = 51.615 ms
tps = 19.374324 (including connections establishing)
tps = 19.375062 (excluding connections establishing)
Partitioned PG11: select_now_fnc.sql -Dfnc=p1024at
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p1024at -Dtbl=p1024 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 1150
latency average = 52.218 ms
tps = 19.150537 (including connections establishing)
tps = 19.151500 (excluding connections establishing)
TimescaleDb PG11: select_now_fnc.sql -Dfnc=ts1024at
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=ts1024at -Dtbl=ts1024 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 727
latency average = 82.555 ms
tps = 12.113191 (including connections establishing)
tps = 12.113749 (excluding connections establishing)
Partitioned PG12: select_now_fnc.sql -Dfnc=p1024at
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p1024at -Dtbl=p1024 -p 4432
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 1230
latency average = 48.809 ms
tps = 20.487895 (including connections establishing)
tps = 20.488713 (excluding connections establishing)
Partitioned PG11: select_now_fnc.sql -Dfnc=p1024at_ni
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p1024at_ni -Dtbl=p1024 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 1206
latency average = 49.756 ms
tps = 20.097996 (including connections establishing)
tps = 20.098881 (excluding connections establishing)
TimescaleDb PG11: select_now_fnc.sql -Dfnc=ts1024at_ni
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=ts1024at_ni -Dtbl=ts1024 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 689
latency average = 87.126 ms
tps = 11.477572 (including connections establishing)
tps = 11.478147 (excluding connections establishing)
Partitioned PG12: select_now_fnc.sql -Dfnc=p1024at_ni
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p1024at_ni -Dtbl=p1024 -p 4432
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 1582
latency average = 37.930 ms
tps = 26.364533 (including connections establishing)
tps = 26.365717 (excluding connections establishing)
Partitioned PG11: select_now_fnc.sql -Dfnc=p1024at_ni_plpg
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p1024at_ni_plpg -Dtbl=p1024 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 53978
latency average = 1.112 ms
tps = 899.625174 (including connections establishing)
tps = 899.656472 (excluding connections establishing)
TimescaleDb PG11: select_now_fnc.sql -Dfnc=ts1024at_ni_plpg
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=ts1024at_ni_plpg -Dtbl=ts1024 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 204263
latency average = 0.294 ms
tps = 3404.375431 (including connections establishing)
tps = 3404.546171 (excluding connections establishing)
Partitioned PG12: select_now_fnc.sql -Dfnc=p1024at_ni_plpg
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p1024at_ni_plpg -Dtbl=p1024 -p 4432
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 335117
latency average = 0.179 ms
tps = 5585.259072 (including connections establishing)
tps = 5585.513169 (excluding connections establishing)
Partitioned PG11: select_now_fnc.sql -Dfnc=p1024_limit_at
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p1024_limit_at -Dtbl=p1024 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 207
latency average = 290.522 ms
tps = 3.442075 (including connections establishing)
tps = 3.442260 (excluding connections establishing)
TimescaleDb PG11: select_now_fnc.sql -Dfnc=ts1024_limit_at
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=ts1024_limit_at -Dtbl=ts1024 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 185
latency average = 325.269 ms
tps = 3.074378 (including connections establishing)
tps = 3.074525 (excluding connections establishing)
Partitioned PG12: select_now_fnc.sql -Dfnc=p1024_limit_at
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p1024_limit_at -Dtbl=p1024 -p 4432
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 320
latency average = 187.691 ms
tps = 5.327912 (including connections establishing)
tps = 5.328116 (excluding connections establishing)
Partitioned PG11: select_nested_loop.sql
pgbench -n -T 60 -f select_nested_loop.sql -Dtbl=p1024 rosmerta_vof
transaction type: select_nested_loop.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 241
latency average = 249.857 ms
tps = 4.002292 (including connections establishing)
tps = 4.002488 (excluding connections establishing)
TimescaleDb PG11: select_nested_loop.sql
pgbench -n -T 60 -f select_nested_loop.sql -Dtbl=ts1024 rosmerta_vof
transaction type: select_nested_loop.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 386
latency average = 155.554 ms
tps = 6.428632 (including connections establishing)
tps = 6.428970 (excluding connections establishing)
Partitioned PG12: select_nested_loop.sql
pgbench -n -T 60 -f select_nested_loop.sql -Dtbl=p1024 -p 4432
transaction type: select_nested_loop.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 638
latency average = 94.165 ms
tps = 10.619651 (including connections establishing)
tps = 10.620131 (excluding connections establishing)
Partitioned PG11: insert.sql
pgbench -n -T 60 -f insert.sql -Dtbl=p4096 rosmerta_vof
transaction type: insert.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 5427
latency average = 11.058 ms
tps = 90.434650 (including connections establishing)
tps = 90.440211 (excluding connections establishing)
TimescaleDb PG11: insert.sql
pgbench -n -T 60 -f insert.sql -Dtbl=ts4096 rosmerta_vof
transaction type: insert.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 9894
latency average = 6.065 ms
tps = 164.890706 (including connections establishing)
tps = 164.899635 (excluding connections establishing)
Partitioned PG12: insert.sql
pgbench -n -T 60 -f insert.sql -Dtbl=p4096 -p 4432
transaction type: insert.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 14788
latency average = 4.057 ms
tps = 246.459354 (including connections establishing)
tps = 246.473189 (excluding connections establishing)
Partitioned PG11: select_static.sql
pgbench -n -T 60 -f select_static.sql -Dtbl=p4096 rosmerta_vof
transaction type: select_static.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 179
latency average = 336.672 ms
tps = 2.970253 (including connections establishing)
tps = 2.970425 (excluding connections establishing)
TimescaleDb PG11: select_static.sql
pgbench -n -T 60 -f select_static.sql -Dtbl=ts4096 rosmerta_vof
transaction type: select_static.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 58723
latency average = 1.022 ms
tps = 978.708107 (including connections establishing)
tps = 978.757440 (excluding connections establishing)
Partitioned PG12: select_static.sql
pgbench -n -T 60 -f select_static.sql -Dtbl=p4096 -p 4432
transaction type: select_static.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 265767
latency average = 0.226 ms
tps = 4429.433950 (including connections establishing)
tps = 4429.607681 (excluding connections establishing)
Partitioned PG11: select_static_fnc.sql -Dfnc=p4096at
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p4096at -Dtbl=p4096 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 192
latency average = 313.891 ms
tps = 3.185822 (including connections establishing)
tps = 3.185970 (excluding connections establishing)
TimescaleDb PG11: select_static_fnc.sql -Dfnc=ts4096at
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=ts4096at -Dtbl=ts4096 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 150
latency average = 400.404 ms
tps = 2.497480 (including connections establishing)
tps = 2.497586 (excluding connections establishing)
Partitioned PG12: select_static_fnc.sql -Dfnc=p4096at
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p4096at -Dtbl=p4096 -p 4432
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 236101
latency average = 0.254 ms
tps = 3934.999368 (including connections establishing)
tps = 3935.198556 (excluding connections establishing)
Partitioned PG11: select_static_fnc.sql -Dfnc=p4096at_ni
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p4096at_ni -Dtbl=p4096 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 141
latency average = 427.633 ms
tps = 2.338455 (including connections establishing)
tps = 2.338549 (excluding connections establishing)
TimescaleDb PG11: select_static_fnc.sql -Dfnc=ts4096at_ni
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=ts4096at_ni -Dtbl=ts4096 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 90
latency average = 669.118 ms
tps = 1.494505 (including connections establishing)
tps = 1.494571 (excluding connections establishing)
Partitioned PG12: select_static_fnc.sql -Dfnc=p4096at_ni
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p4096at_ni -Dtbl=p4096 -p 4432
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 254
latency average = 237.007 ms
tps = 4.219281 (including connections establishing)
tps = 4.219498 (excluding connections establishing)
Partitioned PG11: select_static_fnc.sql -Dfnc=p4096at_ni_plpg
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p4096at_ni_plpg -Dtbl=p4096 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 13919
latency average = 4.311 ms
tps = 231.972070 (including connections establishing)
tps = 231.984194 (excluding connections establishing)
TimescaleDb PG11: select_static_fnc.sql -Dfnc=ts4096at_ni_plpg
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=ts4096at_ni_plpg -Dtbl=ts4096 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 54120
latency average = 1.109 ms
tps = 901.989935 (including connections establishing)
tps = 902.035185 (excluding connections establishing)
Partitioned PG12: select_static_fnc.sql -Dfnc=p4096at_ni_plpg
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p4096at_ni_plpg -Dtbl=p4096 -p 4432
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 211120
latency average = 0.284 ms
tps = 3518.651498 (including connections establishing)
tps = 3518.863156 (excluding connections establishing)
Partitioned PG11: select_static_fnc.sql -Dfnc=p4096_limit_at
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p4096_limit_at -Dtbl=p4096 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 189
latency average = 318.211 ms
tps = 3.142565 (including connections establishing)
tps = 3.142706 (excluding connections establishing)
TimescaleDb PG11: select_static_fnc.sql -Dfnc=ts4096_limit_at
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=ts4096_limit_at -Dtbl=ts4096 rosmerta_vof
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 163
latency average = 369.059 ms
tps = 2.709595 (including connections establishing)
tps = 2.709720 (excluding connections establishing)
Partitioned PG12: select_static_fnc.sql -Dfnc=p4096_limit_at
pgbench -n -T 60 -f select_static_fnc.sql -Dfnc=p4096_limit_at -Dtbl=p4096 -p 4432
transaction type: select_static_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 211556
latency average = 0.284 ms
tps = 3525.918097 (including connections establishing)
tps = 3526.068228 (excluding connections establishing)
Partitioned PG11: select_now.sql
pgbench -n -T 60 -f select_now.sql -Dtbl=p4096 rosmerta_vof
transaction type: select_now.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 138
latency average = 435.411 ms
tps = 2.296679 (including connections establishing)
tps = 2.296775 (excluding connections establishing)
TimescaleDb PG11: select_now.sql
pgbench -n -T 60 -f select_now.sql -Dtbl=ts4096 rosmerta_vof
transaction type: select_now.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 93
latency average = 648.311 ms
tps = 1.542469 (including connections establishing)
tps = 1.542537 (excluding connections establishing)
Partitioned PG12: select_now.sql
pgbench -n -T 60 -f select_now.sql -Dtbl=p4096 -p 4432
transaction type: select_now.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 238
latency average = 252.578 ms
tps = 3.959175 (including connections establishing)
tps = 3.959356 (excluding connections establishing)
Partitioned PG11: select_now_fnc.sql -Dfnc=p4096at
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p4096at -Dtbl=p4096 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 138
latency average = 435.007 ms
tps = 2.298811 (including connections establishing)
tps = 2.298910 (excluding connections establishing)
TimescaleDb PG11: select_now_fnc.sql -Dfnc=ts4096at
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=ts4096at -Dtbl=ts4096 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 94
latency average = 638.465 ms
tps = 1.566256 (including connections establishing)
tps = 1.566336 (excluding connections establishing)
Partitioned PG12: select_now_fnc.sql -Dfnc=p4096at
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p4096at -Dtbl=p4096 -p 4432
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 245
latency average = 245.496 ms
tps = 4.073380 (including connections establishing)
tps = 4.073552 (excluding connections establishing)
Partitioned PG11: select_now_fnc.sql -Dfnc=p4096at_ni
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p4096at_ni -Dtbl=p4096 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 139
latency average = 433.905 ms
tps = 2.304653 (including connections establishing)
tps = 2.304754 (excluding connections establishing)
TimescaleDb PG11: select_now_fnc.sql -Dfnc=ts4096at_ni
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=ts4096at_ni -Dtbl=ts4096 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 91
latency average = 662.816 ms
tps = 1.508715 (including connections establishing)
tps = 1.508784 (excluding connections establishing)
Partitioned PG12: select_now_fnc.sql -Dfnc=p4096at_ni
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p4096at_ni -Dtbl=p4096 -p 4432
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 268
latency average = 224.326 ms
tps = 4.457807 (including connections establishing)
tps = 4.458018 (excluding connections establishing)
Partitioned PG11: select_now_fnc.sql -Dfnc=p4096at_ni_plpg
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p4096at_ni_plpg -Dtbl=p4096 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 14487
latency average = 4.142 ms
tps = 241.440575 (including connections establishing)
tps = 241.450264 (excluding connections establishing)
TimescaleDb PG11: select_now_fnc.sql -Dfnc=ts4096at_ni_plpg
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=ts4096at_ni_plpg -Dtbl=ts4096 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 140776
latency average = 0.426 ms
tps = 2346.252360 (including connections establishing)
tps = 2346.350527 (excluding connections establishing)
Partitioned PG12: select_now_fnc.sql -Dfnc=p4096at_ni_plpg
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p4096at_ni_plpg -Dtbl=p4096 -p 4432
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 301074
latency average = 0.199 ms
tps = 5017.890336 (including connections establishing)
tps = 5018.137795 (excluding connections establishing)
Partitioned PG11: select_now_fnc.sql -Dfnc=p4096_limit_at
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p4096_limit_at -Dtbl=p4096 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 10
latency average = 6135.190 ms
tps = 0.162994 (including connections establishing)
tps = 0.163001 (excluding connections establishing)
TimescaleDb PG11: select_now_fnc.sql -Dfnc=ts4096_limit_at
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=ts4096_limit_at -Dtbl=ts4096 rosmerta_vof
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 9
latency average = 6929.569 ms
tps = 0.144309 (including connections establishing)
tps = 0.144317 (excluding connections establishing)
Partitioned PG12: select_now_fnc.sql -Dfnc=p4096_limit_at
pgbench -n -T 60 -f select_now_fnc.sql -Dfnc=p4096_limit_at -Dtbl=p4096 -p 4432
transaction type: select_now_fnc.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 15
latency average = 4057.142 ms
tps = 0.246479 (including connections establishing)
tps = 0.246490 (excluding connections establishing)
Partitioned PG11: select_nested_loop.sql
pgbench -n -T 60 -f select_nested_loop.sql -Dtbl=p4096 rosmerta_vof
transaction type: select_nested_loop.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 17
latency average = 3724.658 ms
tps = 0.268481 (including connections establishing)
tps = 0.268495 (excluding connections establishing)
TimescaleDb PG11: select_nested_loop.sql
pgbench -n -T 60 -f select_nested_loop.sql -Dtbl=ts4096 rosmerta_vof
transaction type: select_nested_loop.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 39
latency average = 1550.594 ms
tps = 0.644914 (including connections establishing)
tps = 0.644946 (excluding connections establishing)
Partitioned PG12: select_nested_loop.sql
pgbench -n -T 60 -f select_nested_loop.sql -Dtbl=p4096 -p 4432
transaction type: select_nested_loop.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 64
latency average = 943.340 ms
tps = 1.060063 (including connections establishing)
tps = 1.060124 (excluding connections establishing)
Partitioned PG11: select_now_limit.sql
pgbench -n -T 60 -f select_now_limit.sql -Dtbl=p16 rosmerta_vof
transaction type: select_now_limit.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 67537
latency average = 0.888 ms
tps = 1125.608535 (including connections establishing)
tps = 1125.664786 (excluding connections establishing)
TimescaleDb PG11: select_now_limit.sql
pgbench -n -T 60 -f select_now_limit.sql -Dtbl=ts16 rosmerta_vof
transaction type: select_now_limit.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 59640
latency average = 1.006 ms
tps = 993.991143 (including connections establishing)
tps = 994.031032 (excluding connections establishing)
Partitioned PG12: select_now_limit.sql
pgbench -n -T 60 -f select_now_limit.sql -Dtbl=p16 -p 4432
transaction type: select_now_limit.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 96107
latency average = 0.624 ms
tps = 1601.770553 (including connections establishing)
tps = 1601.833785 (excluding connections establishing)
Partitioned PG11: select_static_limit.sql
pgbench -n -T 60 -f select_static_limit.sql -Dtbl=p16 rosmerta_vof
transaction type: select_static_limit.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 147996
latency average = 0.405 ms
tps = 2466.595198 (including connections establishing)
tps = 2466.697827 (excluding connections establishing)
TimescaleDb PG11: select_static_limit.sql
pgbench -n -T 60 -f select_static_limit.sql -Dtbl=ts16 rosmerta_vof
transaction type: select_static_limit.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 65574
latency average = 0.915 ms
tps = 1092.898374 (including connections establishing)
tps = 1092.943790 (excluding connections establishing)
Partitioned PG12: select_static_limit.sql
pgbench -n -T 60 -f select_static_limit.sql -Dtbl=p16 -p 4432
transaction type: select_static_limit.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 257415
latency average = 0.233 ms
tps = 4290.223597 (including connections establishing)
tps = 4290.407439 (excluding connections establishing)
Partitioned PG11: select_now_limit.sql
pgbench -n -T 60 -f select_now_limit.sql -Dtbl=p64 rosmerta_vof
transaction type: select_now_limit.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 17515
latency average = 3.426 ms
tps = 291.914898 (including connections establishing)
tps = 291.928347 (excluding connections establishing)
TimescaleDb PG11: select_now_limit.sql
pgbench -n -T 60 -f select_now_limit.sql -Dtbl=ts64 rosmerta_vof
transaction type: select_now_limit.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 15561
latency average = 3.856 ms
tps = 259.335134 (including connections establishing)
tps = 259.348486 (excluding connections establishing)
Partitioned PG12: select_now_limit.sql
pgbench -n -T 60 -f select_now_limit.sql -Dtbl=p64 -p 4432
transaction type: select_now_limit.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 28495
latency average = 2.106 ms
tps = 474.900712 (including connections establishing)
tps = 474.921778 (excluding connections establishing)
Partitioned PG11: select_static_limit.sql
pgbench -n -T 60 -f select_static_limit.sql -Dtbl=p64 rosmerta_vof
transaction type: select_static_limit.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 74001
latency average = 0.811 ms
tps = 1233.341029 (including connections establishing)
tps = 1233.388645 (excluding connections establishing)
TimescaleDb PG11: select_static_limit.sql
pgbench -n -T 60 -f select_static_limit.sql -Dtbl=ts64 rosmerta_vof
transaction type: select_static_limit.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 67544
latency average = 0.888 ms
tps = 1125.725832 (including connections establishing)
tps = 1125.785173 (excluding connections establishing)
Partitioned PG12: select_static_limit.sql
pgbench -n -T 60 -f select_static_limit.sql -Dtbl=p64 -p 4432
transaction type: select_static_limit.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 256751
latency average = 0.234 ms
tps = 4279.156675 (including connections establishing)
tps = 4279.379739 (excluding connections establishing)
Partitioned PG11: select_now_limit.sql
pgbench -n -T 60 -f select_now_limit.sql -Dtbl=p256 rosmerta_vof
transaction type: select_now_limit.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 3297
latency average = 18.204 ms
tps = 54.933030 (including connections establishing)
tps = 54.936255 (excluding connections establishing)
TimescaleDb PG11: select_now_limit.sql
pgbench -n -T 60 -f select_now_limit.sql -Dtbl=ts256 rosmerta_vof
transaction type: select_now_limit.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 2998
latency average = 20.021 ms
tps = 49.947214 (including connections establishing)
tps = 49.949620 (excluding connections establishing)
Partitioned PG12: select_now_limit.sql
pgbench -n -T 60 -f select_now_limit.sql -Dtbl=p256 -p 4432
transaction type: select_now_limit.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 5951
latency average = 10.083 ms
tps = 99.176007 (including connections establishing)
tps = 99.181123 (excluding connections establishing)
Partitioned PG11: select_static_limit.sql
pgbench -n -T 60 -f select_static_limit.sql -Dtbl=p256 rosmerta_vof
transaction type: select_static_limit.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 21567
latency average = 2.782 ms
tps = 359.438532 (including connections establishing)
tps = 359.454115 (excluding connections establishing)
TimescaleDb PG11: select_static_limit.sql
pgbench -n -T 60 -f select_static_limit.sql -Dtbl=ts256 rosmerta_vof
transaction type: select_static_limit.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 65761
latency average = 0.912 ms
tps = 1096.010066 (including connections establishing)
tps = 1096.056766 (excluding connections establishing)
Partitioned PG12: select_static_limit.sql
pgbench -n -T 60 -f select_static_limit.sql -Dtbl=p256 -p 4432
transaction type: select_static_limit.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 258843
latency average = 0.232 ms
tps = 4314.036721 (including connections establishing)
tps = 4314.205539 (excluding connections establishing)
Partitioned PG11: select_now_limit.sql
pgbench -n -T 60 -f select_now_limit.sql -Dtbl=p1024 rosmerta_vof
transaction type: select_now_limit.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 210
latency average = 285.990 ms
tps = 3.496628 (including connections establishing)
tps = 3.496758 (excluding connections establishing)
TimescaleDb PG11: select_now_limit.sql
pgbench -n -T 60 -f select_now_limit.sql -Dtbl=ts1024 rosmerta_vof
transaction type: select_now_limit.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 186
latency average = 323.086 ms
tps = 3.095147 (including connections establishing)
tps = 3.095268 (excluding connections establishing)
Partitioned PG12: select_now_limit.sql
pgbench -n -T 60 -f select_now_limit.sql -Dtbl=p1024 -p 4432
transaction type: select_now_limit.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 333
latency average = 180.237 ms
tps = 5.548239 (including connections establishing)
tps = 5.548516 (excluding connections establishing)
Partitioned PG11: select_static_limit.sql
pgbench -n -T 60 -f select_static_limit.sql -Dtbl=p1024 rosmerta_vof
transaction type: select_static_limit.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 2524
latency average = 23.772 ms
tps = 42.066319 (including connections establishing)
tps = 42.068476 (excluding connections establishing)
TimescaleDb PG11: select_static_limit.sql
pgbench -n -T 60 -f select_static_limit.sql -Dtbl=ts1024 rosmerta_vof
transaction type: select_static_limit.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 66114
latency average = 0.908 ms
tps = 1101.886531 (including connections establishing)
tps = 1101.929841 (excluding connections establishing)
Partitioned PG12: select_static_limit.sql
pgbench -n -T 60 -f select_static_limit.sql -Dtbl=p1024 -p 4432
transaction type: select_static_limit.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 254151
latency average = 0.236 ms
tps = 4235.829172 (including connections establishing)
tps = 4236.018281 (excluding connections establishing)
Partitioned PG11: select_now_limit.sql
pgbench -n -T 60 -f select_now_limit.sql -Dtbl=p4096 rosmerta_vof
transaction type: select_now_limit.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 10
latency average = 6108.171 ms
tps = 0.163715 (including connections establishing)
tps = 0.163722 (excluding connections establishing)
TimescaleDb PG11: select_now_limit.sql
pgbench -n -T 60 -f select_now_limit.sql -Dtbl=ts4096 rosmerta_vof
transaction type: select_now_limit.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 9
latency average = 6894.731 ms
tps = 0.145038 (including connections establishing)
tps = 0.145045 (excluding connections establishing)
Partitioned PG12: select_now_limit.sql
pgbench -n -T 60 -f select_now_limit.sql -Dtbl=p4096 -p 4432
transaction type: select_now_limit.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 15
latency average = 4066.530 ms
tps = 0.245910 (including connections establishing)
tps = 0.245922 (excluding connections establishing)
Partitioned PG11: select_static_limit.sql
pgbench -n -T 60 -f select_static_limit.sql -Dtbl=p4096 rosmerta_vof
transaction type: select_static_limit.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 191
latency average = 314.268 ms
tps = 3.182000 (including connections establishing)
tps = 3.182152 (excluding connections establishing)
TimescaleDb PG11: select_static_limit.sql
pgbench -n -T 60 -f select_static_limit.sql -Dtbl=ts4096 rosmerta_vof
transaction type: select_static_limit.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 58912
latency average = 1.018 ms
tps = 981.851487 (including connections establishing)
tps = 981.898912 (excluding connections establishing)
Partitioned PG12: select_static_limit.sql
pgbench -n -T 60 -f select_static_limit.sql -Dtbl=p4096 -p 4432
transaction type: select_static_limit.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 60 s
number of transactions actually processed: 250139
latency average = 0.240 ms
tps = 4168.966574 (including connections establishing)
tps = 4169.189706 (excluding connections establishing)