Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 01.11.2026 17:56
Common Performance Final Results
  1. Hardware and OS info
  2. Test configuration
  3. Test Finish details
  4. Test workload details
  5. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score:    as table     as chart
  2. Performance per MINUTE, during test_time phase:    as table     as chart
  3. External connections pool: DISABLED. Test config parameter 'use_es' must be 2; ExtConnPoolSize must be ^> 0.
  4. Performance, DETAILS per units
  5. Memory consumption, metadata cache, attachments activity    as table    as chart
  6. Monitoring data: STATEMENTS activity, as chart
  7. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database statistics was not gathered. Change config parameter 'run_db_statistics' to 1.
  3. Database validation was not performed. Change config parameter 'run_db_validation' to 1.
  4. New in firebird.log while test was run
  5. Final processing of ISQL logs

Hardware and OS info

Command: hostnamectl
Static hostname test-0
Icon name computer-vm
Chassis vm 🖴
Machine ID de98ff4ed95945a6974b0c761b9e398f
Boot ID 2bf17960cddd47aabfae2d899d34f677
Product UUID de98ff4e-d959-45a6-974b-0c761b9e398f
Virtualization kvm
Operating System Debian GNU/Linux 13 (trixie)
Kernel Linux 6.12.113+deb13-amd64
Architecture x86-64
Hardware Vendor Selectel
Hardware Model OpenStack Nova
Hardware Serial de98ff4e-d959-45a6-974b-0c761b9e398f
Firmware Version 1.15.0-1
Firmware Date Tue 2014-04-01
Firmware Age 12y 7month 1d
Command: who -b
bootup_info system boot 2026-10-26 18:11
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
./oltp_isql_run_worker.sh line 54: dmidecode: command not found
Command: dmesg | grep DMI
[ 0.000000] DMI Selectel OpenStack Nova, BIOS 1.15.0-1 04/01/2014
[ 0.000000] DMI Memory slots populated: 1/1
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Address sizes 46 bits physical, 48 bits virtual
Byte Order Little Endian
CPU(s) 4
On-line CPU(s) list 0-3
Vendor ID GenuineIntel
Model name Intel(R) Xeon(R) CPU E5-2630 v3 @ 2.40GHz
CPU family 6
Model 63
Thread(s) per core 1
Core(s) per socket 1
Socket(s) 4
Stepping 2
BogoMIPS 4799.99
Hypervisor vendor KVM
Virtualization type full
L1d cache 128 KiB (4 instances)
L1i cache 128 KiB (4 instances)
L2 cache 16 MiB (4 instances)
L3 cache 64 MiB (4 instances)
NUMA node(s) 1
NUMA node0 CPU(s) 0-3
Vulnerability Gather data sampling Not affected
Vulnerability Indirect target selection Mitigation; Aligned branch/return thunks
Vulnerability Itlb multihit Not affected
Vulnerability L1tf Mitigation; PTE Inversion
Vulnerability Mds Mitigation; Clear CPU buffers; SMT Host state unknown
Vulnerability Meltdown Mitigation; PTI
Vulnerability Mmio stale data Vulnerable: Clear CPU buffers attempted, no microcode; SMT Host state unknown
Vulnerability Reg file data sampling Not affected
Vulnerability Retbleed Not affected
Vulnerability Spec rstack overflow Not affected
Vulnerability Spec store bypass Mitigation; Speculative Store Bypass disabled via prctl
Vulnerability Spectre v1 Mitigation; usercopy/swapgs barriers and __user pointer sanitization
Vulnerability Spectre v2 Mitigation; Retpolines; IBPB conditional; IBRS_FW; STIBP disabled; RSB filling; PBRSB-eIBRS Not affected; BHI Retpoline
Vulnerability Srbds Not affected
Vulnerability Tsa Not affected
Vulnerability Tsx async abort Not affected
Vulnerability Vmscape Not affected
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 8138024 kB
MemFree 2074980 kB
MemAvailable 7313476 kB
Buffers 88196 kB
Cached 5311932 kB
SwapCached 0 kB
Command: fdisk -l
./oltp_isql_run_worker.sh: line 54: fdisk: command not found

Server and database settinfs


SERVER_MODE                     SuperServer 3.0.15
DB_NAME                         /var/db/oltp-emul/oltp-hq30.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    262144
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/var/db/oltp-emul/oltp-hq30.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/var/db/oltp-emul/oltp_30.etalone.fdb
param=expected_workers, val=100
param=fbc, val=/opt/hq30/bin
param=file_name_this_host_info, val=test-0
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=html_chart_color_memo_all, val=magenta
param=html_chart_color_memo_att, val=magenta
param=html_chart_color_memo_stm, val=magenta
param=html_chart_color_memo_trn, val=magenta
param=html_chart_color_perf_score, val=magenta
param=init_buff, val=4096
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_passwd, val=0Ltp-Emu1
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=30300
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=results_storage_fbk, val=/mnt/oltp-emul/reports/oltp-hq30-results.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=sleep_min, val=0
param=test_intervals, val=30
param=test_time, val=55
param=tmpdir, val=/var/tmp/logs.oltp-hq30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=use_es, val=0
param=used_in_replication, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=0
param=wait_if_not_exists, val=0
param=warm_time, val=0
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2026-11-01 17:56:41
DTS_END                         2026-11-01 17:56:41.6800
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(211:18) ==> SP_CANCEL_CUSTOMER_RESERVE(55:5) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(95:17)
IP                              ::1/37934
TRN_ID                          188580
ATT_ID                          405
EXC_UNIT                        2


Test workload details

SETTING_NAME SETTING_VALUE
WORKING_MODE SMALL_03
C_WARES_MAX_ID 400
C_CUSTOMER_DOC_MAX_ROWS 10
C_SUPPLIER_DOC_MAX_ROWS 50
C_CUSTOMER_DOC_MAX_QTY 15
C_SUPPLIER_DOC_MAX_QTY 50
C_NUMBER_OF_AGENTS 1000

Indexes for heavy-loaded tables

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_ASC WORKER_ID,DOC_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_DEC WORKER_ID,DOC_ID
XQD_1200_2000 XQD_1200_2000_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID

Performance in TOTAL

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE
*** OVERALL *** for 55 minutes: 10686.27 1061 587745
customer order: creation 507.20 57 27896
customer order: refuse 39.33 50 2163
order to supplier: creation 129.09 243 7100
order to supplier: removal 9.69 9790 533
invoice (draft): creation 128.45 390 7065
invoice (draft): removal 93.62 149 5149
invoice accept: apply 109.24 1895 6008
invoice accept: cancel 76.73 211 4220
customer reserve: creation 4996.85 35 274827
customer reserve: removal 3817.91 18 209985
realization accept: apply 238.84 44 13136
realization accept: cancel 135.89 24 7474
payment from customer: creation 168.29 38 9256
payment from customer: removal 15.65 20 861
payment to supplier: creation 137.62 34 7569
payment to supplier: removal 9.36 19 515
service: total inventory turnovers 28.51 607 1568
service: total monetary turnovers 40.09 8 2205
service: aggregate perf. data 3.87 1817 213
service: refresh index statistics 0.04 5768 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 01-11-2026 17:56:58 to 01-11-2026 17:57:00.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6003
TEST_TIME 2 6493
TEST_TIME 3 7011
TEST_TIME 4 7578
TEST_TIME 5 7843
TEST_TIME 6 7905
TEST_TIME 7 8152
TEST_TIME 8 8296
TEST_TIME 9 8364
TEST_TIME 10 8673
TEST_TIME 11 8826
TEST_TIME 12 8981
TEST_TIME 13 9102
TEST_TIME 14 9275
TEST_TIME 15 9372
TEST_TIME 16 9384
TEST_TIME 17 9499
TEST_TIME 18 9621
TEST_TIME 19 9607
TEST_TIME 20 9740
TEST_TIME 21 9616
TEST_TIME 22 9616
TEST_TIME 23 9590
TEST_TIME 24 9622
TEST_TIME 25 9623
TEST_TIME 26 9630
TEST_TIME 27 9831
TEST_TIME 28 9756
TEST_TIME 29 9960
TEST_TIME 30 9984
TEST_TIME 31 10021
TEST_TIME 32 10035
TEST_TIME 33 10052
TEST_TIME 34 10082
TEST_TIME 35 10175
TEST_TIME 36 10225
TEST_TIME 37 10286
TEST_TIME 38 10326
TEST_TIME 39 10338
TEST_TIME 40 10320
TEST_TIME 41 10328
TEST_TIME 42 10429
TEST_TIME 43 10460
TEST_TIME 44 10513
TEST_TIME 45 10501
TEST_TIME 46 10547
TEST_TIME 47 10546
TEST_TIME 48 10569
TEST_TIME 49 10593
TEST_TIME 50 10624
TEST_TIME 51 10676
TEST_TIME 52 10685
TEST_TIME 53 10737
TEST_TIME 54 10775
TEST_TIME 55 10686

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 01-11-2026 17:57:01 to 01-11-2026 17:57:04.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 863983 863983 0 0.00 0 1297 3 0 0
doc_list_biud 863983 863983 0 0.00 0 3160 6 0 0
sp_add_invoice_to_stock 6008 6008 0 0.00 8 21839 1895 0 0
sp_cancel_adding_invoice 4220 4220 0 0.00 4 4649 211 0 0
sp_cancel_client_order 2163 2163 0 0.00 3 957 50 0 0
sp_cancel_customer_reserve 209985 209985 0 0.00 1 3161 18 0 0
sp_cancel_pay_from_customer 861 861 0 0.00 2 322 21 0 0
sp_cancel_pay_to_supplier 515 515 0 0.00 2 252 20 0 0
sp_cancel_supplier_invoice 5149 5149 0 0.00 1 1463 149 0 0
sp_cancel_supplier_order 533 533 0 0.00 6 56975 9790 0 0
sp_cancel_write_off 7474 7474 0 0.00 1 1718 24 0 0
sp_client_order 27896 27896 0 0.00 4 1993 58 0 0
sp_customer_reserve 274827 274827 0 0.00 0 3989 36 0 0
sp_fill_shopping_cart 42061 42061 0 0.00 1 2167 22 0 0
sp_fill_shopping_cart_clo_res 274827 274827 0 0.00 0 1536 4 0 0
sp_get_clo_for_invoice 6008 6008 0 0.00 0 1139 41 0 0
sp_kill_cost_storno 13070 13070 0 0.00 0 419 10 0 0
sp_kill_qstorno_ret_qs2qd 433126 433126 0 0.00 0 2187 9 0 0
sp_kill_qty_storno 248668 248668 0 0.00 0 3160 20 0 0
sp_lock_selected_doc 26418 26418 0 0.00 0 243 2 0 0
sp_make_cost_storno 35969 35969 0 0.00 0 1112 8 0 0
sp_multiply_rows_for_pdistr 35969 35969 0 0.00 0 670 12 0 0
sp_multiply_rows_for_qdistr 27896 27896 0 0.00 0 1938 23 0 0
sp_pay_from_customer 9256 9256 0 0.00 3 1357 38 0 0
sp_pay_to_supplier 7569 7569 0 0.00 3 1273 35 0 0
sp_payment_common 16825 16825 0 0.00 1 619 9 0 0
sp_qd_handle_on_cancel_clo 2163 2163 0 0.00 0 923 33 0 0
sp_qd_handle_on_invoice_upd_sts 10228 10228 0 0.00 0 1576 75 0 0
sp_qd_handle_on_reserve_upd_sts 13136 13136 0 0.00 0 1567 14 0 0
sp_reserve_write_off 13136 13136 0 0.00 3 1575 45 0 0
sp_supplier_invoice 7065 7065 0 0.00 5 5643 391 0 0
sp_supplier_order 7100 7100 0 0.00 4 3465 244 0 0
srv_aggregate_perf_data 213 213 0 0.00 66 13241 1818 0 0
srv_fill_mon_cache_memory 54 54 0 0.00 2 2190 429 0 0
srv_find_qd_qs_mism 547225 547225 0 0.00 0 1297 2 0 0
srv_make_invnt_saldo 1568 1568 0 0.00 0 97197 607 0 0
srv_make_money_saldo 2205 2205 0 0.00 0 610 9 0 0
srv_recalc_idx_stat 2 2 0 0.00 207 11330 5769 0 0
v_add_invoice_to_stock 12016 12016 0 0.00 0 585 3 0 0
v_all_customers 42472 42472 0 0.00 0 107 1 0 0
v_all_suppliers 34312 34312 0 0.00 0 66 1 0 0
v_all_wares 55792 55792 0 0.00 0 61 1 0 0
v_cancel_adding_invoice 1010 1010 0 0.00 0 261 3 0 0
v_cancel_client_order 4326 4326 0 0.00 0 320 2 0 0
v_cancel_customer_prepayment 1722 1722 0 0.00 0 108 2 0 0
v_cancel_customer_reserve 1748 1748 0 0.00 0 600 2 0 0
v_cancel_payment_to_supplier 1030 1030 0 0.00 0 63 2 0 0
v_cancel_supplier_invoice 1004 1004 0 0.00 0 87 3 0 0
v_cancel_supplier_order 1066 1066 0 0.00 0 243 2 0 0
v_cancel_write_off 2642 2642 0 0.00 0 347 2 0 0
v_max_id_clo_ord 7100 7100 0 0.00 0 430 2 0 0
v_max_id_clo_res 1346 1346 0 0.00 0 117 2 0 0
v_max_id_ord_sup 7065 7065 0 0.00 0 671 2 0 0
v_max_non_paid_invoice 4578 4578 0 0.00 0 55 2 0 0
v_max_non_paid_realizn 8935 8935 0 0.00 0 130 2 0 0
v_min_id_clo_ord 7100 7100 0 0.00 0 411 3 0 0
v_min_id_clo_res 1346 1346 0 0.00 0 610 6 0 0
v_min_id_ord_sup 7065 7065 0 0.00 0 2055 8 0 0
v_min_non_paid_invoice 7569 7569 0 0.00 0 609 3 0 0
v_min_non_paid_realizn 9256 9256 0 0.00 0 273 3 0 0
v_our_firm 13962 13962 0 0.00 0 50 1 0 0
v_reserve_write_off 26272 26272 0 0.00 0 608 2 0 0
x_lock_depdocs_on_canc_invoice 8867 8867 0 0.00 0 894 9 0 0
x_lock_depdocs_on_canc_sup_ord 533 533 0 0.00 0 163 11 0 0
x_make_qstorno_1000_1200 7100 7100 0 0.00 1 3327 186 0 0
x_make_qstorno_1200_2000 7065 7065 0 0.00 1 4690 337 0 0
x_make_qstorno_2100_3300 274827 274827 0 0.00 0 3975 30 0 0

Completed "Performance in DETAILS". Done for 00:00:06, from 01-11-2026 17:57:04 to 01-11-2026 17:57:10.

Memory consumption, metadata cache, attachments activity

Data in this report:
  page cache memo used            = total size of page cache, bytes
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = size of cache for metadata, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 262144 for all connections, with total size: 2147483648                                                                                                                                                                      

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
17:01:46 2 2147483648 2318244288 2325499904 3922944 0.182 1 1 2 0 4021632 55888 42800
17:02:47 209 2147483648 2601939664 2688372736 270724256 11.195 20 8 14 1 272746448 574928 1447264
17:03:48 247 2147483648 2595812800 2678128640 261677520 10.861 20 13 25 0 264995760 625376 2692864
17:04:49 344 2147483648 2603963312 2690551808 272147776 11.247 20 8 16 0 274483472 964112 1371584
17:05:49 187 2147483648 2595597216 2680713216 263336608 10.923 20 9 18 1 267563840 1579024 2648208
17:06:50 203 2147483648 2605321760 2692268032 269717632 11.158 20 9 18 0 276077024 4649152 1710240
17:07:51 202 2147483648 2584825152 2669105152 253601888 10.561 20 8 15 0 255987904 754032 1631984
17:08:51 115 2147483648 2600869008 2690076672 269856640 11.163 20 5 10 0 272485776 972208 1656928
17:09:52 811 2147483648 2586960256 2671476736 254220768 10.585 20 8 16 0 257117536 1104816 1791952
17:10:53 738 2147483648 2596630800 2685104128 266531392 11.040 20 7 13 0 268593312 1006848 1055072
17:11:54 143 2147483648 2601149264 2687033344 266676624 11.046 20 15 31 0 271440736 1898272 2865840
17:12:55 187 2147483648 2591079632 2675445760 256409840 10.666 20 14 27 0 260358368 1428496 2520032
17:13:55 513 2147483648 2587977216 2674106368 252752880 10.530 19 9 18 0 255602576 1037072 1812624
17:14:56 1391 2147483648 2601428608 2689183744 268372304 11.108 20 9 18 0 271214032 1237456 1604272
17:15:58 144 2147483648 2596397344 2684133376 264292016 10.958 20 7 14 0 266693552 1057488 1344048
17:16:58 171 2147483648 2592216848 2677821440 259060880 10.764 20 13 23 0 262222272 1073264 2088128
17:17:59 525 2147483648 2601563264 2688602112 267737200 11.085 20 17 34 1 271676768 1176576 2762992
17:19:00 1623 2147483648 2598931568 2687897600 265265088 10.994 20 13 26 1 270489648 2466800 2757760
17:20:04 180 2147483648 2596898800 2685235200 265088912 10.987 20 12 21 0 269132400 1273792 2769696
17:21:04 266 2147483648 2595544592 2686349312 264998736 10.984 20 4 8 0 266447312 934784 513792
17:22:05 1217 2147483648 2597209968 2683318272 260905008 10.833 20 14 26 0 265611264 1432096 3274160
17:23:11 259 2147483648 2593498400 2680729600 260753696 10.827 20 10 20 0 263930320 1475904 1700720
17:24:12 403 2147483648 2601157296 2689769472 267565936 11.079 20 11 20 0 271123280 1379872 2177472
17:25:13 262 2147483648 2595693904 2684067840 261449424 10.853 20 10 20 0 265556832 1902048 2205360
17:26:16 147 2147483648 2597802560 2686361600 260479360 10.817 20 10 20 0 267702992 5433440 1790192
17:27:16 238 2147483648 2592872960 2682527744 260033296 10.800 20 5 10 0 262685504 1616768 1035440
17:28:17 181 2147483648 2602753248 2691141632 268636816 11.118 20 12 24 0 272479504 1497952 2344736
17:29:17 197 2147483648 2582258288 2667741184 248920176 10.387 19 11 22 1 252863872 1661088 2282608
17:30:18 390 2147483648 2591388896 2680393728 256832752 10.682 20 7 14 0 262017360 3421888 1762720
17:31:19 390 2147483648 2606262464 2696048640 272814000 11.271 20 10 20 0 275882416 1291616 1776800
17:32:19 646 2147483648 2603312480 2695241728 269419872 11.147 20 7 14 1 273696976 2752400 1524704
17:33:20 178 2147483648 2599067440 2688761856 264721696 10.974 20 9 18 0 268228608 1651152 1855760
17:34:21 594 2147483648 2590312464 2679083008 256835664 10.682 20 7 14 0 259637200 1539904 1261632
17:35:22 266 2147483648 2601901792 2692550656 267690944 11.083 20 8 16 0 271955728 2257312 2007472
17:36:22 370 2147483648 2601501680 2692374528 268091376 11.098 20 11 20 2 271444080 1680464 1672240
17:37:23 340 2147483648 2595489440 2684981248 261778000 10.865 20 10 20 0 265135280 1667808 1689472
17:38:25 156 2147483648 2592588288 2682474496 259293360 10.773 20 7 14 0 262613456 2069264 1250832
17:39:26 523 2147483648 2600244608 2690531328 266975152 11.057 20 7 13 0 269470896 1325488 1170256
17:40:27 396 2147483648 2596023728 2686136320 263008832 10.910 20 6 12 1 265488192 1162352 1317008
17:41:28 359 2147483648 2582681824 2670665728 250699888 10.453 19 10 20 1 253462944 988544 1774512
17:42:29 128 2147483648 2591370176 2678616064 256864656 10.683 20 10 20 0 260362016 1575584 1921776
17:43:29 576 2147483648 2604933248 2696040448 266734592 11.048 20 10 20 0 273821920 4852160 2235168
17:44:30 179 2147483648 2600825280 2689122304 265569120 11.005 20 12 24 0 269725136 1831728 2324288
17:45:31 234 2147483648 2598988624 2689781760 265930256 11.018 20 5 10 0 268665360 1831280 903824
17:46:32 639 2147483648 2593878960 2683731968 260939024 10.834 20 6 12 0 263056400 1108272 1009104
17:47:33 269 2147483648 2591310288 2680786944 257647008 10.712 20 7 13 0 260845440 1892752 1305680
17:48:33 259 2147483648 2600196064 2690183168 266715824 11.047 20 11 22 0 269939056 924208 2299024
17:49:34 780 2147483648 2598700496 2686369792 262957056 10.909 20 12 24 0 267309488 2158336 2194096
17:50:36 263 2147483648 2596880800 2686799872 263254736 10.920 20 12 22 0 266522640 1405968 1861936
17:51:37 457 2147483648 2602334864 2690326528 264303856 10.958 20 14 28 0 270931984 3703680 2924448
17:52:38 2183 2147483648 2597074960 2685460480 261730208 10.863 20 9 18 0 264963008 1652128 1580672
17:53:40 736 2147483648 2600103776 2688573440 262606256 10.896 20 10 19 0 269485088 4897168 1981664
17:54:42 112 2147483648 2587451520 2676969472 254797840 10.606 20 8 15 0 257592592 1485552 1309200
17:55:42 408 2147483648 2601959456 2692935680 264528272 10.967 20 8 14 0 271394736 5245584 1620880

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:18, from 01-11-2026 17:57:11 to 01-11-2026 17:57:29.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 01-11-2026 17:57:29 to 01-11-2026 17:57:30.

Content of mon$database and FB version


MON$DATABASE_NAME               /var/db/oltp-emul/oltp-hq30.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          188579
MON$OLDEST_ACTIVE               188881
MON$OLDEST_SNAPSHOT             188881
MON$NEXT_TRANSACTION            188881
MON$PAGE_BUFFERS                262144
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2026-11-01 17:00:11.3140
MON$PAGES                       119456
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.15.33892 Firebird 3.0 HQbird
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.15.33892 Firebird 3.0 HQbird"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.15.33892 Firebird 3.0 HQbird/tcp (test-0)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.15.33892 Firebird 3.0 HQbird/tcp (test-0)/P15:C"
on disk structure version 12.0

Database statistics


Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation


Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
:6: 
:7: test-0    Sun Nov  1 17:56:43 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:9: 
--- end of diff output ---

Final processing ISQL logs in /var/tmp/logs.oltp-hq30 according to config parameter 'remove_isql_logs'

01.11.26 17:57:31. There are 3 logs in /var/tmp/logs.oltp-hq30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2026-11-01 17:57:32 No severe PSQL-related problems occured
01.11.26 17:57:33. End of report.