Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 12.11.2026 14:50
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 cc11645eec8340f48398c8a2eb858648
Product UUID de98ff4e-d959-45a6-974b-0c761b9e398f
Virtualization kvm
Operating System Debian GNU/Linux 13 (trixie)
Kernel Linux 6.12.116+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 1w 5d
Command: who -b
bootup_info system boot 2026-11-09 10:54
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 8138016 kB
MemFree 1651916 kB
MemAvailable 7163592 kB
Buffers 80208 kB
Cached 5550856 kB
SwapCached 12 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
BugcheckAbort true false [ X ] firebird.conf
ClearGTTAtRetaining false false
ClientBatchBuffer 131072 131072
ConnectionIdleTimeout 0 0
ConnectionTimeout 180 180
CpuAffinityMask 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
GCPolicy combined combined
GuardianOption 1 1
IPv6V6Only false false
InlineSortThreshold 1000 1000
IpcName oemul_fb40SS FirebirdIPI [ X ] firebird.conf
KeyHolderPlugin [empty] [empty]
LegacyHash true true
LockAcquireSpins 0 0
LockHashSlots 30011 8191 [ X ] firebird.conf
LockMemSize 10485760 1048576 [ X ] firebird.conf
MaxIdentifierByteLength 252 252
MaxIdentifierCharLength 63 63
MaxUnflushedWriteTime -1 -1
MaxUnflushedWrites -1 -1
MaxUserTraceLogSize 10 10
OnDisconnectTriggerTimeout 180 180
OutputRedirectionFile /dev/null /dev/null
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 3400 0 [ X ] firebird.conf
SecurityDatabase /opt/fb40/security4.fdb /opt/fb40/security4.fdb
ServerMode Super Super [ X ] firebird.conf
SnapshotsMemSize 65536 65536
StatementTimeout 0 0
TcpLoopbackFastPath false false
TcpNoNagle true true
TcpRemoteBufferSize 8192 8192
TempBlockSize 1048576 1048576
TempCacheLimit 536870912 67108864 [ X ] firebird.conf
TempDirectories
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
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-fb40.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-fb40.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/fb40/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=3400
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-fb40-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-fb40
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-12 14:50:52
DTS_END                         2026-11-12 14:50:52.8320
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(59:5) ==> X_MAKE_QSTORNO_1200_2000(289:25) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(95:17)
IP                              ::1/47548
TRN_ID                          214461
ATT_ID                          451
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: 13914.58 796 695729
customer order: creation 634.00 48 31700
customer order: refuse 52.48 47 2624
order to supplier: creation 159.46 220 7973
order to supplier: removal 12.42 7654 621
invoice (draft): creation 161.86 370 8093
invoice (draft): removal 114.60 133 5730
invoice accept: apply 136.72 1530 6836
invoice accept: cancel 93.84 193 4692
customer reserve: creation 6742.70 26 337135
customer reserve: removal 4854.38 14 242719
realization accept: apply 295.86 37 14793
realization accept: cancel 162.66 19 8133
payment from customer: creation 207.90 33 10395
payment from customer: removal 21.14 19 1057
payment to supplier: creation 173.70 33 8685
payment to supplier: removal 12.00 16 600
service: total inventory turnovers 22.38 1490 1119
service: total monetary turnovers 51.58 12 2579
service: aggregate perf. data 4.86 1641 243
service: refresh index statistics 0.04 2381 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 12-11-2026 14:51:06 to 12-11-2026 14:51:07.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7251
TEST_TIME 2 8831
TEST_TIME 3 8952
TEST_TIME 4 9720
TEST_TIME 5 9986
TEST_TIME 6 10341
TEST_TIME 7 10686
TEST_TIME 8 10909
TEST_TIME 9 11328
TEST_TIME 10 11472
TEST_TIME 11 11624
TEST_TIME 12 11636
TEST_TIME 13 11997
TEST_TIME 14 12006
TEST_TIME 15 12186
TEST_TIME 16 12241
TEST_TIME 17 12217
TEST_TIME 18 12382
TEST_TIME 19 12383
TEST_TIME 20 12532
TEST_TIME 21 12627
TEST_TIME 22 12608
TEST_TIME 23 12578
TEST_TIME 24 12673
TEST_TIME 25 12701
TEST_TIME 26 12782
TEST_TIME 27 12812
TEST_TIME 28 12890
TEST_TIME 29 12932
TEST_TIME 30 13012
TEST_TIME 31 13031
TEST_TIME 32 13118
TEST_TIME 33 13160
TEST_TIME 34 13213
TEST_TIME 35 13268
TEST_TIME 36 13346
TEST_TIME 37 13381
TEST_TIME 38 13411
TEST_TIME 39 13505
TEST_TIME 40 13530
TEST_TIME 41 13632
TEST_TIME 42 13660
TEST_TIME 43 13696
TEST_TIME 44 13707
TEST_TIME 45 13779
TEST_TIME 46 13860
TEST_TIME 47 13851
TEST_TIME 48 13907
TEST_TIME 49 13926
TEST_TIME 50 13915

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 12-11-2026 14:51:08 to 12-11-2026 14:51:11.

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 1027685 1027685 0 0.00 0 1559 2 0 0
doc_list_biud 1027685 1027685 0 0.00 0 2125 5 0 0
sp_add_invoice_to_stock 6836 6836 0 0.00 5 13328 1530 0 0
sp_cancel_adding_invoice 4692 4692 0 0.00 3 5430 194 0 0
sp_cancel_client_order 2624 2624 0 0.00 3 1211 47 0 0
sp_cancel_customer_reserve 242719 242719 0 0.00 1 2054 14 0 0
sp_cancel_pay_from_customer 1057 1057 0 0.00 2 689 19 0 0
sp_cancel_pay_to_supplier 600 600 0 0.00 2 390 16 0 0
sp_cancel_supplier_invoice 5730 5730 0 0.00 2 1206 134 0 0
sp_cancel_supplier_order 621 621 0 0.00 3 44534 7654 0 0
sp_cancel_write_off 8133 8133 0 0.00 1 816 20 0 0
sp_client_order 31700 31700 0 0.00 4 2425 49 0 0
sp_customer_reserve 337135 337135 0 0.00 0 2571 27 0 0
sp_fill_shopping_cart 47766 47766 0 0.00 1 1898 21 0 0
sp_fill_shopping_cart_clo_res 337135 337135 0 0.00 0 1479 2 0 0
sp_get_clo_for_invoice 6836 6836 0 0.00 0 1573 34 0 0
sp_kill_cost_storno 14482 14482 0 0.00 0 727 9 0 0
sp_kill_qstorno_ret_qs2qd 499922 499922 0 0.00 0 2124 7 0 0
sp_kill_qty_storno 286148 286148 0 0.00 0 2124 16 0 0
sp_lock_selected_doc 30140 30140 0 0.00 0 468 1 0 0
sp_make_cost_storno 40709 40709 0 0.00 0 1311 7 0 0
sp_multiply_rows_for_pdistr 40709 40709 0 0.00 0 744 10 0 0
sp_multiply_rows_for_qdistr 31700 31700 0 0.00 0 1219 18 0 0
sp_pay_from_customer 10395 10395 0 0.00 2 1317 34 0 0
sp_pay_to_supplier 8685 8685 0 0.00 3 675 34 0 0
sp_payment_common 19080 19080 0 0.00 1 782 9 0 0
sp_qd_handle_on_cancel_clo 2624 2624 0 0.00 0 1138 31 0 0
sp_qd_handle_on_invoice_upd_sts 11528 11528 0 0.00 0 1502 63 0 0
sp_qd_handle_on_reserve_upd_sts 14793 14793 0 0.00 0 1376 11 0 0
sp_reserve_write_off 14793 14793 0 0.00 3 1383 37 0 0
sp_supplier_invoice 8093 8093 0 0.00 5 5535 370 0 0
sp_supplier_order 7973 7973 0 0.00 4 3757 220 0 0
srv_aggregate_perf_data 243 243 0 0.00 62 9052 1642 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 2 1142 289 0 0
srv_find_qd_qs_mism 646548 646548 0 0.00 0 1559 1 0 0
srv_make_invnt_saldo 1119 1119 0 0.00 1 4897 1490 0 0
srv_make_money_saldo 2579 2579 0 0.00 0 271 13 0 0
srv_recalc_idx_stat 2 2 0 0.00 259 4504 2382 0 0
v_add_invoice_to_stock 13672 13672 0 0.00 0 500 2 0 0
v_all_customers 47894 47894 0 0.00 0 51 1 0 0
v_all_suppliers 39994 39994 0 0.00 0 88 1 0 0
v_all_wares 63400 63400 0 0.00 0 42 1 0 0
v_cancel_adding_invoice 1182 1182 0 0.00 0 1137 4 0 0
v_cancel_client_order 5248 5248 0 0.00 0 1202 2 0 0
v_cancel_customer_prepayment 2114 2114 0 0.00 0 599 2 0 0
v_cancel_customer_reserve 2038 2038 0 0.00 0 772 2 0 0
v_cancel_payment_to_supplier 1200 1200 0 0.00 0 387 2 0 0
v_cancel_supplier_invoice 1092 1092 0 0.00 0 237 2 0 0
v_cancel_supplier_order 1242 1242 0 0.00 0 138 2 0 0
v_cancel_write_off 2906 2906 0 0.00 0 461 2 0 0
v_max_id_clo_ord 7973 7973 0 0.00 0 266 1 0 0
v_max_id_clo_res 1445 1445 0 0.00 0 298 2 0 0
v_max_id_ord_sup 8093 8093 0 0.00 0 962 2 0 0
v_max_non_paid_invoice 4754 4754 0 0.00 0 51 1 0 0
v_max_non_paid_realizn 10063 10063 0 0.00 0 42 1 0 0
v_min_id_clo_ord 7973 7973 0 0.00 0 410 3 0 0
v_min_id_clo_res 1445 1445 0 0.00 0 638 5 0 0
v_min_id_ord_sup 8093 8093 0 0.00 0 1708 6 0 0
v_min_non_paid_invoice 8685 8685 0 0.00 0 621 6 0 0
v_min_non_paid_realizn 10395 10395 0 0.00 0 483 3 0 0
v_our_firm 16170 16170 0 0.00 0 47 1 0 0
v_reserve_write_off 29586 29586 0 0.00 0 760 2 0 0
x_lock_depdocs_on_canc_invoice 9876 9876 0 0.00 0 1599 10 0 0
x_lock_depdocs_on_canc_sup_ord 621 621 0 0.00 0 673 13 0 0
x_make_qstorno_1000_1200 7973 7973 0 0.00 1 3316 165 0 0
x_make_qstorno_1200_2000 8093 8093 0 0.00 1 5083 322 0 0
x_make_qstorno_2100_3300 337135 337135 0 0.00 0 2569 23 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 12-11-2026 14:51:11 to 12-11-2026 14:51:15.

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
14:00:56 2 2147483648 2309418704 2313068544 3168592 0.147 1 1 2 0 3266032 61664 35776
14:01:57 567 2147483648 2548371296 2629406720 222133680 9.374 20 3 6 0 226716432 3820752 762000
14:02:58 243 2147483648 2549447936 2628775936 219391152 9.269 20 10 20 1 222689952 1507056 1791744
14:03:58 291 2147483648 2532380272 2606166016 205050784 8.716 20 13 21 0 208528768 1718784 1759200
14:04:59 141 2147483648 2547639904 2627780608 220037680 9.294 20 13 27 0 224467904 2458400 1971824
14:05:59 218 2147483648 2540879632 2620579840 213543216 9.044 20 10 18 0 216817728 1764384 1510128
14:07:00 268 2147483648 2540197984 2621153280 211585472 8.969 20 10 18 0 217772912 4578368 1609072
14:08:00 227 2147483648 2543002048 2625208320 214262560 9.072 20 9 18 0 218335712 2510000 1563152
14:09:01 335 2147483648 2544826848 2625478656 206665280 8.778 20 18 34 1 222082480 12245344 3171856
14:10:02 270 2147483648 2545991520 2628628480 219100304 9.258 20 14 29 0 224926256 3497952 2328000
14:11:02 475 2147483648 2545671408 2626940928 213795584 9.054 20 14 26 1 222303936 5408096 3100256
14:12:03 235 2147483648 2536214256 2614857728 207422928 8.808 20 9 19 0 212031120 3116944 1491248
14:13:04 158 2147483648 2556316336 2638200832 217613248 9.201 20 13 27 0 234365936 14340096 2412592
14:14:04 178 2147483648 2522056256 2600169472 196451600 8.381 19 9 17 0 199559584 1758176 1349808
14:15:05 100 2147483648 2541789120 2623856640 214074752 9.064 20 8 16 0 218261120 3028800 1157568
14:16:05 189 2147483648 2556703696 2638934016 220179264 9.299 20 11 22 0 232812144 10757888 1874992
14:17:06 197 2147483648 2532456864 2611851264 203880704 8.670 19 12 26 0 209407520 2515504 3011312
14:18:07 415 2147483648 2544752432 2626449408 213999840 9.062 20 11 22 0 221583888 5903600 1680448
14:19:08 296 2147483648 2541273344 2625609728 214359008 9.075 20 6 12 0 219159440 3751232 1049200
14:20:08 97 2147483648 2551218816 2632974336 213202944 9.031 20 12 24 0 227594752 12653152 1738656
14:21:08 255 2147483648 2541064592 2620170240 201619008 8.582 19 11 21 0 218100912 14634144 1847760
14:22:09 264 2147483648 2557618576 2640203776 216606656 9.162 20 11 22 0 231389648 12940384 1842608
14:23:10 1137 2147483648 2538085232 2619375616 210427472 8.924 20 9 18 0 214632464 2068688 2136304
14:24:11 210 2147483648 2553281808 2634190848 217309440 9.189 20 13 26 0 228974144 9177488 2487216
14:25:12 541 2147483648 2548408672 2631524352 219450112 9.271 20 11 22 1 225502224 4003440 2048672
14:26:13 159 2147483648 2555818720 2639515648 213864768 9.056 20 10 20 0 232294624 16935712 1494144
14:27:13 382 2147483648 2555930112 2637889536 216510448 9.158 20 12 24 0 231034480 12480256 2043776
14:28:14 238 2147483648 2554991984 2639261696 219650368 9.279 20 8 16 0 232329072 11504384 1174320
14:29:14 151 2147483648 2550926800 2632839168 212224464 8.993 20 13 26 0 226368464 12186368 1957632
14:30:15 311 2147483648 2555420128 2638295040 219166336 9.260 20 11 22 0 230622928 9626320 1830272
14:31:16 124 2147483648 2552861744 2635538432 220991264 9.330 20 12 22 1 227755536 4828528 1935744
14:32:16 172 2147483648 2555815472 2638782464 213830480 9.055 20 11 22 0 232049760 16116240 2103040
14:33:17 193 2147483648 2562282800 2645291008 217754704 9.206 20 11 23 0 238130656 18254176 2121776
14:34:17 569 2147483648 2550549648 2630938624 217008544 9.177 20 11 22 0 226491872 7547216 1936112
14:35:18 114 2147483648 2553951744 2640797696 215854256 9.133 20 11 22 0 230859056 12729936 2274864
14:36:18 548 2147483648 2547628464 2629820416 210824576 8.939 20 12 20 1 226696048 13937072 1934400
14:37:19 140 2147483648 2546751008 2629222400 215069792 9.103 20 13 25 0 222703056 5564080 2069184
14:38:19 187 2147483648 2538859184 2622320640 214144128 9.067 20 9 19 0 217139968 1312448 1683392
14:39:19 169 2147483648 2570955024 2652291072 218150544 9.221 20 13 26 0 247319632 27064896 2104192
14:40:20 317 2147483648 2549467840 2632036352 217896400 9.211 20 16 30 3 225461152 4575792 2988960
14:41:20 336 2147483648 2562136992 2645012480 212348832 8.998 20 9 18 1 239116096 24866464 1900800
14:42:21 174 2147483648 2550342000 2633412608 214198704 9.069 20 13 26 0 226128272 9754272 2175296
14:43:22 152 2147483648 2549593008 2635509760 214731920 9.090 20 9 16 0 225498992 9604880 1162192
14:44:22 237 2147483648 2554453072 2637967360 217654432 9.202 20 11 22 0 230108000 10428768 2024800
14:45:22 1080 2147483648 2536215120 2620690432 210073792 8.910 20 9 18 0 213282144 1649056 1559296
14:46:24 397 2147483648 2562242048 2647261184 217361328 9.191 20 8 16 0 238160368 19428496 1370544
14:47:24 156 2147483648 2549646384 2631671808 217135168 9.182 20 11 22 0 225710880 6835360 1740352
14:48:25 234 2147483648 2550631568 2632613888 209798944 8.900 20 12 24 0 226705072 14959632 1946496
14:49:25 177 2147483648 2546384800 2628644864 211188592 8.953 20 11 22 0 222009216 8929648 1890976
14:50:26 274 2147483648 2542946032 2626260992 211495920 8.965 20 10 18 0 218888672 5908640 1484112

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 12-11-2026 14:51:16 to 12-11-2026 14:51:30.

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 12-11-2026 14:51:30 to 12-11-2026 14:51:31.

Content of mon$database and FB version


MON$DATABASE_NAME               /var/db/oltp-emul/oltp-fb40.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          214630
MON$OLDEST_ACTIVE               214631
MON$OLDEST_SNAPSHOT             214631
MON$NEXT_TRANSACTION            214631
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-12 11:00:10.9960 GMT
MON$PAGES                       142936
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                        {4A267312-3AA2-4D7D-9898-F2C20E6BC6F7}
MON$FILE_ID                     01080000000000009fed070000000000
MON$NEXT_ATTACHMENT             560
MON$NEXT_STATEMENT              54
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.8.3340 Firebird 4.0 6a471bd
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.8.3340 Firebird 4.0 6a471bd"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.8.3340 Firebird 4.0 6a471bd/tcp (test-0)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.8.3340 Firebird 4.0 6a471bd/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 ---
--- end of diff output ---

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

12.11.26 14:51:32. There are 3 logs in /var/tmp/logs.oltp-fb40 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-12 14:51:33 No severe PSQL-related problems occured
12.11.26 14:51:34. End of report.