Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 02.11.2026 10:51
Common Performance Final Results
  1. Hardware and OS info
  2. Firebird configuration
  3. Test configuration
  4. Test Finish details
  5. Test workload details
  6. 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 2d
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 1775248 kB
MemAvailable 7267372 kB
Buffers 80304 kB
Cached 5537444 kB
SwapCached 16 kB
Command: fdisk -l
./oltp_isql_run_worker.sh: line 54: fdisk: command not found

Firebird configuration

PARAM_NAME PARAM_VALUE PARAM_DEFAULT is set ? PARAM_SOURCE
AllowEncryptedSecurityDatabase false false
AuditTraceConfigFile [empty] [empty]
AuthClient Srp256, Srp, Legacy_Auth Srp256, Srp, Legacy_Auth
AuthServer Srp256 Srp256
BlobTempSpace 0 0
BugcheckAbort true false [ X ] firebird.conf
ClearGTTAtRetaining false false
ClientBatchBuffer 131072 131072
ConnectionIdleTimeout 0 0
ConnectionTimeout 180 180
CpuAffinityMask 0 0
DSQLCacheSize 0 0
DataTypeCompatibility
DatabaseAccess Full Full
DatabaseGrowthIncrement 134217728 134217728
DeadlockTimeout 10 10
DefaultDbCachePages 262144 2048 [ X ] firebird.conf
DefaultTimeZone
DummyPacketInterval 0 0
EventMemSize 65536 65536
ExtConnPoolLifeTime 7200 7200
ExtConnPoolSize 0 0
ExternalFileAccess None None
FileSystemCacheSize 0 0
FileSystemCacheThreshold 65536 65536
ForceLockTimeoutForWaitTransactions -1 -1
GCPolicy combined combined
GuardianOption 1 1
HQbirdVersionString true true
IPv6V6Only false false
InlineSortThreshold 1000 1000
IpcName oemul_hq40SS FirebirdIPI [ X ] firebird.conf
KeyHolderPlugin [empty] [empty]
LeftJoinConversion false false
LegacyHash true true
LockAcquireSpins 0 0
LockHashSlots 30011 8191 [ X ] firebird.conf
LockMemSize 10485760 1048576 [ X ] firebird.conf
MaxCountAttachments 0 0
MaxDbCachePages 2048 2048
MaxIdentifierByteLength 252 252
MaxIdentifierCharLength 63 63
MaxParallelWorkers 1 1
MaxTempBlobs 1000 1000
MaxUnflushedWriteTime -1 -1
MaxUnflushedWrites -1 -1
MaxUserTraceLogSize 10 10
MinDbCachePages 30000 30000
MonitoringPlugin [empty] [empty]
OnDisconnectTriggerTimeout 180 180
OutputRedirectionFile /dev/null /dev/null
ParallelWorkers 1 1
ProcessPriorityLevel 0 0
Providers Remote, Engine13, Loopback Remote, Engine13, Loopback
ReadConsistency true true
Redirection false false
RelaxedAliasChecking false false
RemoteAccess true true
RemoteAuxPort 0 0
RemoteBindAddress
RemoteFileOpenAbility false false
RemotePipeName interbas interbas
RemoteServiceName gds_db gds_db
RemoteServicePort 30400 0 [ X ] firebird.conf
SecurityDatabase /opt/hq40/security4.fdb /opt/hq40/security4.fdb
ServerMode Super Super [ X ] firebird.conf
SnapshotsMemSize 65536 65536
SqlSubstDirectory subst subst
StatementTimeout 0 0
TcpLoopbackFastPath false false
TcpNoNagle true true
TcpRemoteBufferSize 8192 8192
TempBlockSize 1048576 1048576
TempCacheLimit 536870912 67108864 [ X ] firebird.conf
TempDirectories
TempSpaceLogThreshold 0 0
TempTableDirectory [empty] [empty]
TipCacheBlockSize 4194304 4194304
TraceDSQL 0 0
TracePlugin fbtrace fbtrace
UdfAccess Restrict UDF None [ X ] firebird.conf
UseFileSystemCache true true [ X ] firebird.conf
UseLegacyKernelObjectsNames false false
UserManager Srp Srp
WarnCountAttachments 0 0
WireCompression false false
WireCrypt Required
WireCryptPlugin ChaCha64, ChaCha, Arc4 ChaCha64, ChaCha, Arc4

Server and database settinfs


SERVER_MODE                     SuperServer
DB_NAME                         /var/db/oltp-emul/oltp-hq40.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-hq40.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/var/db/oltp-emul/oltp_40.etalone.fdb
param=expected_workers, val=100
param=fbc, val=/opt/hq40/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=green
param=html_chart_color_memo_att, val=green
param=html_chart_color_memo_stm, val=green
param=html_chart_color_memo_trn, val=green
param=html_chart_color_perf_score, val=green
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=30400
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-hq40-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=50
param=tmpdir, val=/var/tmp/logs.oltp-hq40
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-02 10:50:59
DTS_END                         2026-11-02 10:50:59.9280
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(292:30) ==> SP_CUSTOMER_RESERVE(63:5) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(95:17)
IP                              ::1/41250
TRN_ID                          203696
ATT_ID                          433
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 50 minutes: 13342.56 950 667128
customer order: creation 602.64 50 30132
customer order: refuse 49.44 44 2472
order to supplier: creation 152.42 223 7621
order to supplier: removal 11.66 7998 583
invoice (draft): creation 153.04 390 7652
invoice (draft): removal 110.38 140 5519
invoice accept: apply 129.46 1501 6473
invoice accept: cancel 90.50 199 4525
customer reserve: creation 6411.70 25 320585
customer reserve: removal 4719.26 14 235963
realization accept: apply 278.82 40 13941
realization accept: cancel 166.00 20 8300
payment from customer: creation 201.18 42 10059
payment from customer: removal 18.54 19 927
payment to supplier: creation 162.38 34 8119
payment to supplier: removal 11.44 19 572
service: total inventory turnovers 20.60 1644 1030
service: total monetary turnovers 48.48 13 2424
service: aggregate perf. data 4.58 1536 229
service: refresh index statistics 0.04 5056 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 02-11-2026 10:51:15 to 02-11-2026 10:51:16.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5652
TEST_TIME 2 7705
TEST_TIME 3 8507
TEST_TIME 4 8845
TEST_TIME 5 9091
TEST_TIME 6 9643
TEST_TIME 7 9984
TEST_TIME 8 10631
TEST_TIME 9 10720
TEST_TIME 10 11009
TEST_TIME 11 11067
TEST_TIME 12 11250
TEST_TIME 13 11365
TEST_TIME 14 11515
TEST_TIME 15 11571
TEST_TIME 16 11762
TEST_TIME 17 11923
TEST_TIME 18 11939
TEST_TIME 19 12013
TEST_TIME 20 12061
TEST_TIME 21 12246
TEST_TIME 22 12336
TEST_TIME 23 12324
TEST_TIME 24 12334
TEST_TIME 25 12427
TEST_TIME 26 12419
TEST_TIME 27 12513
TEST_TIME 28 12597
TEST_TIME 29 12551
TEST_TIME 30 12651
TEST_TIME 31 12600
TEST_TIME 32 12573
TEST_TIME 33 12585
TEST_TIME 34 12670
TEST_TIME 35 12724
TEST_TIME 36 12739
TEST_TIME 37 12821
TEST_TIME 38 12926
TEST_TIME 39 13026
TEST_TIME 40 13049
TEST_TIME 41 13051
TEST_TIME 42 13030
TEST_TIME 43 13044
TEST_TIME 44 13043
TEST_TIME 45 13163
TEST_TIME 46 13223
TEST_TIME 47 13307
TEST_TIME 48 13350
TEST_TIME 49 13317
TEST_TIME 50 13343

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 02-11-2026 10:51:17 to 02-11-2026 10:51:20.

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 981135 981135 0 0.00 0 1949 2 0 0
doc_list_biud 981135 981135 0 0.00 0 2224 5 0 0
sp_add_invoice_to_stock 6473 6473 0 0.00 8 12281 1501 0 0
sp_cancel_adding_invoice 4525 4525 0 0.00 3 4931 200 0 0
sp_cancel_client_order 2472 2472 0 0.00 2 1123 45 0 0
sp_cancel_customer_reserve 235963 235963 0 0.00 1 1946 14 0 0
sp_cancel_pay_from_customer 927 927 0 0.00 2 350 20 0 0
sp_cancel_pay_to_supplier 572 572 0 0.00 2 349 19 0 0
sp_cancel_supplier_invoice 5519 5519 0 0.00 2 1666 141 0 0
sp_cancel_supplier_order 583 583 0 0.00 6 40830 7998 0 0
sp_cancel_write_off 8300 8300 0 0.00 1 1205 20 0 0
sp_client_order 30132 30132 0 0.00 3 1867 51 0 0
sp_customer_reserve 320585 320585 0 0.00 0 3046 26 0 0
sp_fill_shopping_cart 45405 45405 0 0.00 1 2927 22 0 0
sp_fill_shopping_cart_clo_res 320585 320585 0 0.00 0 1235 2 0 0
sp_get_clo_for_invoice 6473 6473 0 0.00 0 1024 33 0 0
sp_kill_cost_storno 14324 14324 0 0.00 0 702 10 0 0
sp_kill_qstorno_ret_qs2qd 486328 486328 0 0.00 0 2223 7 0 0
sp_kill_qty_storno 277776 277776 0 0.00 0 2224 17 0 0
sp_lock_selected_doc 28369 28369 0 0.00 0 176 2 0 0
sp_make_cost_storno 38592 38592 0 0.00 0 777 8 0 0
sp_multiply_rows_for_pdistr 38592 38592 0 0.00 0 687 12 0 0
sp_multiply_rows_for_qdistr 30132 30132 0 0.00 0 847 19 0 0
sp_pay_from_customer 10059 10059 0 0.00 3 1497 42 0 0
sp_pay_to_supplier 8119 8119 0 0.00 3 1002 35 0 0
sp_payment_common 18178 18178 0 0.00 1 761 11 0 0
sp_qd_handle_on_cancel_clo 2472 2472 0 0.00 0 1119 30 0 0
sp_qd_handle_on_invoice_upd_sts 10998 10998 0 0.00 0 1467 66 0 0
sp_qd_handle_on_reserve_upd_sts 13941 13941 0 0.00 0 1853 12 0 0
sp_reserve_write_off 13941 13941 0 0.00 3 1968 40 0 0
sp_supplier_invoice 7652 7652 0 0.00 6 5305 390 0 0
sp_supplier_order 7621 7621 0 0.00 5 3801 223 0 0
srv_aggregate_perf_data 229 229 0 0.00 26 6311 1536 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 4 2211 350 0 0
srv_find_qd_qs_mism 619617 619617 0 0.00 0 1949 1 0 0
srv_make_invnt_saldo 1030 1030 0 0.00 0 5595 1645 0 0
srv_make_money_saldo 2424 2424 0 0.00 0 370 13 0 0
srv_recalc_idx_stat 2 2 0 0.00 385 9728 5057 0 0
v_add_invoice_to_stock 12946 12946 0 0.00 0 408 2 0 0
v_all_customers 46374 46374 0 0.00 0 51 1 0 0
v_all_suppliers 37294 37294 0 0.00 0 64 1 0 0
v_all_wares 60264 60264 0 0.00 0 37 1 0 0
v_cancel_adding_invoice 1146 1146 0 0.00 0 93 2 0 0
v_cancel_client_order 4944 4944 0 0.00 0 317 1 0 0
v_cancel_customer_prepayment 1854 1854 0 0.00 0 329 2 0 0
v_cancel_customer_reserve 1834 1834 0 0.00 0 431 2 0 0
v_cancel_payment_to_supplier 1144 1144 0 0.00 0 77 2 0 0
v_cancel_supplier_invoice 982 982 0 0.00 0 458 3 0 0
v_cancel_supplier_order 1166 1166 0 0.00 0 200 2 0 0
v_cancel_write_off 2840 2840 0 0.00 0 264 2 0 0
v_max_id_clo_ord 7621 7621 0 0.00 0 51 1 0 0
v_max_id_clo_res 1441 1441 0 0.00 0 181 2 0 0
v_max_id_ord_sup 7652 7652 0 0.00 0 1026 2 0 0
v_max_non_paid_invoice 4745 4745 0 0.00 0 95 2 0 0
v_max_non_paid_realizn 9535 9535 0 0.00 0 482 2 0 0
v_min_id_clo_ord 7621 7621 0 0.00 0 463 3 0 0
v_min_id_clo_res 1441 1441 0 0.00 0 704 4 0 0
v_min_id_ord_sup 7652 7652 0 0.00 0 1405 7 0 0
v_min_non_paid_invoice 8119 8119 0 0.00 0 591 4 0 0
v_min_non_paid_realizn 10059 10059 0 0.00 0 630 7 0 0
v_our_firm 14938 14938 0 0.00 0 105 1 0 0
v_reserve_write_off 27882 27882 0 0.00 0 650 2 0 0
x_lock_depdocs_on_canc_invoice 9553 9553 0 0.00 0 944 9 0 0
x_lock_depdocs_on_canc_sup_ord 583 583 0 0.00 0 358 11 0 0
x_make_qstorno_1000_1200 7621 7621 0 0.00 1 3572 167 0 0
x_make_qstorno_1200_2000 7652 7652 0 0.00 1 5272 338 0 0
x_make_qstorno_2100_3300 320585 320585 0 0.00 0 3043 22 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 02-11-2026 10:51:20 to 02-11-2026 10:51:24.

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
10:01:05 3 2147483648 2309550144 2313269248 3168864 0.147 1 1 2 0 3266304 61664 35776
10:02:05 257 2147483648 2550473984 2632941568 223233872 9.416 20 6 10 0 225880720 1930352 716496
10:03:06 189 2147483648 2549887584 2629566464 221330288 9.343 20 10 18 0 224243744 1449600 1463856
10:04:07 894 2147483648 2538537440 2617692160 211132960 8.951 20 8 16 0 214140208 1167536 1839712
10:05:08 265 2147483648 2553188768 2635280384 221418928 9.346 20 11 22 0 227266960 4159072 1688960
10:06:09 268 2147483648 2540882000 2619973632 211497456 8.965 20 11 20 0 215470640 2494304 1478880
10:07:09 405 2147483648 2556152208 2639200256 222606544 9.392 20 15 29 1 228478176 3188800 2682832
10:08:10 266 2147483648 2554455664 2634485760 213027776 9.024 20 14 29 1 228074944 12466160 2581008
10:09:10 2210 2147483648 2550649040 2633134080 217691648 9.204 20 16 32 0 223594672 3506880 2396144
10:10:15 160 2147483648 2557255312 2637398016 215323680 9.113 20 13 26 0 230814432 13109584 2381168
10:11:15 346 2147483648 2554786144 2639462400 222715328 9.396 20 10 22 0 230595488 6150736 1729424
10:12:16 180 2147483648 2543643712 2623488000 207663536 8.817 20 13 26 1 217111664 7100672 2347456
10:13:16 199 2147483648 2552077488 2640289792 216277312 9.149 20 8 16 0 226080464 8426480 1376672
10:14:17 192 2147483648 2553191488 2638012416 218456656 9.233 20 10 20 1 227987648 7788192 1742800
10:15:17 119 2147483648 2546071872 2627993600 209790848 8.899 20 10 20 0 219563088 8144304 1627936
10:16:18 256 2147483648 2554653968 2638004224 219645008 9.278 20 12 26 0 229087776 7334160 2108608
10:17:18 241 2147483648 2559744800 2644578304 220583808 9.314 20 14 26 0 233524624 10790528 2150288
10:18:19 273 2147483648 2541830496 2623496192 209603264 8.892 20 13 27 0 215917808 4311392 2003152
10:19:19 125 2147483648 2549973680 2632908800 218174880 9.222 20 12 22 0 223256448 3639232 1442336
10:20:20 497 2147483648 2552840160 2635665408 217298000 9.188 20 13 27 0 227134416 7705184 2131232
10:21:20 166 2147483648 2546019600 2627194880 213386384 9.038 20 13 26 0 219267840 3979728 1901728
10:22:21 246 2147483648 2562099152 2645401600 219698976 9.281 20 15 30 0 235393296 12951280 2743040
10:23:21 221 2147483648 2554376592 2636197888 214697328 9.088 20 12 24 0 228037728 11474048 1866352
10:24:22 143 2147483648 2541606288 2626277376 208913280 8.865 20 5 10 0 215377424 5279968 1184176
10:25:22 360 2147483648 2558731664 2643017728 219675504 9.280 20 9 19 0 230968048 9603072 1689472
10:26:23 234 2147483648 2549303072 2637156352 212706784 9.012 20 3 6 0 224167520 11019408 441328
10:27:23 136 2147483648 2568698608 2650759168 214488928 9.080 20 13 26 0 242316640 25613968 2213744
10:28:24 239 2147483648 2557110176 2645184512 218010816 9.216 20 6 12 0 231150384 12300960 838608
10:29:24 305 2147483648 2554762976 2638131200 215310528 9.112 20 12 24 0 230819056 13105504 2403024
10:30:25 605 2147483648 2560629616 2645655552 215314000 9.112 20 11 22 0 234437216 17375040 1748176
10:31:26 164 2147483648 2550209968 2633826304 218414800 9.231 20 10 18 1 224711008 4344288 1951920
10:32:27 764 2147483648 2548407760 2628431872 212427776 9.001 20 12 24 0 221786752 7352368 2006608
10:33:28 340 2147483648 2555604560 2638688256 220275616 9.303 20 12 24 0 230144256 7787760 2080880
10:34:29 186 2147483648 2548534880 2630799360 214288400 9.073 20 11 20 0 222129696 6081184 1760112
10:35:29 129 2147483648 2559498656 2643410944 213159824 9.029 20 13 28 1 233430608 17371072 2899712
10:36:29 140 2147483648 2548044032 2632048640 216145392 9.144 20 12 24 0 221856896 3891408 1820096
10:37:30 304 2147483648 2572863136 2655825920 216192608 9.146 20 12 24 0 244208000 26041568 1973824
10:38:30 133 2147483648 2557361904 2640785408 218959712 9.252 20 12 25 0 230840976 9875616 2005648
10:39:32 525 2147483648 2566127280 2651848704 218447360 9.233 20 10 19 0 239994016 19539600 2007056
10:40:32 166 2147483648 2546001808 2631069696 215474800 9.118 20 6 12 0 220504272 4173488 855984
10:41:33 138 2147483648 2553388736 2636644352 215498752 9.119 20 10 20 0 225871296 8928960 1443584
10:42:33 150 2147483648 2541713568 2624835584 212551664 9.006 20 11 17 0 214744624 1235584 957376
10:43:33 802 2147483648 2561340224 2652397568 219426816 9.270 20 9 18 0 235418336 13921136 2070384
10:44:36 140 2147483648 2527439600 2608197632 196758208 8.393 19 10 20 0 201145600 3046320 1341072
10:45:37 157 2147483648 2564374864 2648010752 216777680 9.168 20 10 19 0 236967632 18741088 1448864
10:46:37 581 2147483648 2573888944 2658082816 217884528 9.211 20 12 24 0 245330512 25067680 2378304
10:47:40 531 2147483648 2560820224 2643996672 218493712 9.234 20 13 24 0 234356320 13419056 2443552
10:48:40 593 2147483648 2555729120 2639859712 214334128 9.074 20 8 16 0 227315792 11546720 1434944
10:49:41 185 2147483648 2555068560 2635096064 211883232 8.980 20 17 34 0 226821936 11935584 3003120
10:50:43 1098 2147483648 2551313472 2635976704 216927840 9.174 20 8 16 1 224437952 6029568 1480544

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:15, from 02-11-2026 10:51:25 to 02-11-2026 10:51:40.

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 02-11-2026 10:51:40 to 02-11-2026 10:51:41.

Content of mon$database and FB version


MON$DATABASE_NAME               /var/db/oltp-emul/oltp-hq40.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          203723
MON$OLDEST_ACTIVE               203874
MON$OLDEST_SNAPSHOT             203874
MON$NEXT_TRANSACTION            203874
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-02 07:00:11.8370 GMT
MON$PAGES                       134470
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                                                                                                                                                                                      
MON$SEC_DATABASE                Default
MON$CRYPT_STATE                 0
MON$GUID                        {85C46B54-4EA0-4584-B622-CF010EBE2195}
MON$FILE_ID                     0108000000000000dded070000000000
MON$NEXT_ATTACHMENT             542
MON$NEXT_STATEMENT              54
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.8.3331 Firebird 4.0 HQbird
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.8.3331 Firebird 4.0 HQbird"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.8.3331 Firebird 4.0 HQbird/tcp (test-0)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.8.3331 Firebird 4.0 HQbird/tcp (test-0)/P17:C"
on disk structure version 13.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    Mon Nov  2 10:51:00 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30400
:9: 
:10: 
:11: test-0    Mon Nov  2 10:51:01 2026
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30400
:13: 
--- end of diff output ---

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

02.11.26 10:51:42. There are 3 logs in /var/tmp/logs.oltp-hq40 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-02 10:51:43 No severe PSQL-related problems occured
02.11.26 10:51:43. End of report.