Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 05.11.2026 02: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 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 4d
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 1960680 kB
MemAvailable 7291120 kB
Buffers 88304 kB
Cached 5329732 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
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-05 02:50:50
DTS_END                         2026-11-05 02:50:50.4690
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/54088
TRN_ID                          222609
ATT_ID                          466
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: 14583.82 913 729191
customer order: creation 656.38 45 32819
customer order: refuse 51.08 45 2554
order to supplier: creation 171.24 208 8562
order to supplier: removal 12.06 8514 603
invoice (draft): creation 166.96 358 8348
invoice (draft): removal 120.60 131 6030
invoice accept: apply 142.90 1513 7145
invoice accept: cancel 100.80 199 5040
customer reserve: creation 6963.96 26 348198
customer reserve: removal 5194.46 14 259723
realization accept: apply 305.92 37 15296
realization accept: cancel 180.50 18 9025
payment from customer: creation 221.56 32 11078
payment from customer: removal 21.12 18 1056
payment to supplier: creation 180.94 29 9047
payment to supplier: removal 12.00 18 600
service: total inventory turnovers 23.70 1396 1185
service: total monetary turnovers 52.02 13 2601
service: aggregate perf. data 5.58 1535 279
service: refresh index statistics 0.04 4108 2

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8860
TEST_TIME 2 10426
TEST_TIME 3 11293
TEST_TIME 4 11513
TEST_TIME 5 11749
TEST_TIME 6 11967
TEST_TIME 7 12228
TEST_TIME 8 12375
TEST_TIME 9 12459
TEST_TIME 10 12633
TEST_TIME 11 12744
TEST_TIME 12 12779
TEST_TIME 13 12903
TEST_TIME 14 12849
TEST_TIME 15 12804
TEST_TIME 16 12842
TEST_TIME 17 12926
TEST_TIME 18 12971
TEST_TIME 19 12960
TEST_TIME 20 13041
TEST_TIME 21 13069
TEST_TIME 22 13086
TEST_TIME 23 13172
TEST_TIME 24 13228
TEST_TIME 25 13241
TEST_TIME 26 13195
TEST_TIME 27 13266
TEST_TIME 28 13468
TEST_TIME 29 13419
TEST_TIME 30 13455
TEST_TIME 31 13515
TEST_TIME 32 13648
TEST_TIME 33 13646
TEST_TIME 34 13751
TEST_TIME 35 13714
TEST_TIME 36 13852
TEST_TIME 37 13843
TEST_TIME 38 13911
TEST_TIME 39 13960
TEST_TIME 40 14049
TEST_TIME 41 14149
TEST_TIME 42 14178
TEST_TIME 43 14188
TEST_TIME 44 14399
TEST_TIME 45 14350
TEST_TIME 46 14428
TEST_TIME 47 14473
TEST_TIME 48 14528
TEST_TIME 49 14594
TEST_TIME 50 14584

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 05-11-2026 02:51:08 to 05-11-2026 02: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 1076295 1076295 0 0.00 0 1267 2 0 0
doc_list_biud 1076295 1076295 0 0.00 0 3708 5 0 0
sp_add_invoice_to_stock 7145 7145 0 0.00 4 22171 1513 0 0
sp_cancel_adding_invoice 5040 5040 0 0.00 3 4217 200 0 0
sp_cancel_client_order 2554 2554 0 0.00 2 2465 46 0 0
sp_cancel_customer_reserve 259723 259723 0 0.00 1 1907 15 0 0
sp_cancel_pay_from_customer 1056 1056 0 0.00 2 931 18 0 0
sp_cancel_pay_to_supplier 600 600 0 0.00 2 523 19 0 0
sp_cancel_supplier_invoice 6030 6030 0 0.00 1 1854 131 0 0
sp_cancel_supplier_order 603 603 0 0.00 4 52260 8514 0 0
sp_cancel_write_off 9025 9025 0 0.00 1 867 19 0 0
sp_client_order 32819 32819 0 0.00 4 1479 46 0 0
sp_customer_reserve 348198 348198 0 0.00 0 2603 27 0 0
sp_fill_shopping_cart 49729 49729 0 0.00 1 3080 21 0 0
sp_fill_shopping_cart_clo_res 348198 348198 0 0.00 0 1664 2 0 0
sp_get_clo_for_invoice 7145 7145 0 0.00 0 1758 34 0 0
sp_kill_cost_storno 15721 15721 0 0.00 0 754 9 0 0
sp_kill_qstorno_ret_qs2qd 535104 535104 0 0.00 0 3706 7 0 0
sp_kill_qty_storno 305416 305416 0 0.00 0 3708 17 0 0
sp_lock_selected_doc 30995 30995 0 0.00 0 802 1 0 0
sp_make_cost_storno 42566 42566 0 0.00 0 1171 7 0 0
sp_multiply_rows_for_pdistr 42566 42566 0 0.00 0 570 10 0 0
sp_multiply_rows_for_qdistr 32819 32819 0 0.00 0 1321 17 0 0
sp_pay_from_customer 11078 11078 0 0.00 3 1255 33 0 0
sp_pay_to_supplier 9047 9047 0 0.00 3 1126 29 0 0
sp_payment_common 20125 20125 0 0.00 1 657 6 0 0
sp_qd_handle_on_cancel_clo 2554 2554 0 0.00 0 2457 30 0 0
sp_qd_handle_on_invoice_upd_sts 12185 12185 0 0.00 0 1512 66 0 0
sp_qd_handle_on_reserve_upd_sts 15296 15296 0 0.00 0 1534 11 0 0
sp_reserve_write_off 15296 15296 0 0.00 3 1882 37 0 0
sp_supplier_invoice 8348 8348 0 0.00 6 5070 358 0 0
sp_supplier_order 8562 8562 0 0.00 5 2806 209 0 0
srv_aggregate_perf_data 279 279 0 0.00 29 11232 1535 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 2 915 284 0 0
srv_find_qd_qs_mism 679965 679965 0 0.00 0 1267 1 0 0
srv_make_invnt_saldo 1185 1185 0 0.00 0 5228 1397 0 0
srv_make_money_saldo 2601 2601 0 0.00 0 333 13 0 0
srv_recalc_idx_stat 2 2 0 0.00 196 8020 4108 0 0
v_add_invoice_to_stock 14290 14290 0 0.00 0 623 2 0 0
v_all_customers 50258 50258 0 0.00 0 36 1 0 0
v_all_suppliers 41516 41516 0 0.00 0 66 1 0 0
v_all_wares 65638 65638 0 0.00 0 50 1 0 0
v_cancel_adding_invoice 1212 1212 0 0.00 0 330 2 0 0
v_cancel_client_order 5108 5108 0 0.00 0 482 1 0 0
v_cancel_customer_prepayment 2112 2112 0 0.00 0 125 1 0 0
v_cancel_customer_reserve 2100 2100 0 0.00 0 448 2 0 0
v_cancel_payment_to_supplier 1200 1200 0 0.00 0 91 1 0 0
v_cancel_supplier_invoice 1122 1122 0 0.00 0 380 3 0 0
v_cancel_supplier_order 1206 1206 0 0.00 0 37 1 0 0
v_cancel_write_off 3048 3048 0 0.00 0 116 2 0 0
v_max_id_clo_ord 8562 8562 0 0.00 0 352 1 0 0
v_max_id_clo_res 1467 1467 0 0.00 0 648 3 0 0
v_max_id_ord_sup 8348 8348 0 0.00 0 684 2 0 0
v_max_non_paid_invoice 5199 5199 0 0.00 0 71 1 0 0
v_max_non_paid_realizn 10609 10609 0 0.00 0 60 1 0 0
v_min_id_clo_ord 8562 8562 0 0.00 0 651 3 0 0
v_min_id_clo_res 1467 1467 0 0.00 0 710 4 0 0
v_min_id_ord_sup 8348 8348 0 0.00 0 1274 5 0 0
v_min_non_paid_invoice 9047 9047 0 0.00 0 475 2 0 0
v_min_non_paid_realizn 11078 11078 0 0.00 0 605 2 0 0
v_our_firm 16318 16318 0 0.00 0 41 1 0 0
v_reserve_write_off 30592 30592 0 0.00 0 657 2 0 0
x_lock_depdocs_on_canc_invoice 10509 10509 0 0.00 0 1281 10 0 0
x_lock_depdocs_on_canc_sup_ord 603 603 0 0.00 0 111 11 0 0
x_make_qstorno_1000_1200 8562 8562 0 0.00 1 2767 149 0 0
x_make_qstorno_1200_2000 8348 8348 0 0.00 1 5004 313 0 0
x_make_qstorno_2100_3300 348198 348198 0 0.00 0 2516 23 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 05-11-2026 02:51:11 to 05-11-2026 02: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
02:00:54 2 2147483648 2309418704 2313068544 3168592 0.147 1 1 2 0 3266032 61664 35776
02:01:54 296 2147483648 2523956240 2596577280 198715072 8.469 19 11 20 0 202466368 1689184 2062112
02:02:54 225 2147483648 2551071184 2629824512 223085616 9.410 20 16 30 0 227650432 2104880 2459936
02:03:55 321 2147483648 2548607744 2627981312 218288160 9.226 20 15 31 0 226801664 6019584 2493920
02:04:55 428 2147483648 2525794864 2602536960 198408112 8.457 20 8 16 0 201167312 1024256 1734944
02:05:56 252 2147483648 2542821040 2621837312 213147648 9.029 20 11 23 0 218623440 3511888 1963904
02:06:57 282 2147483648 2544714720 2625470464 214767040 9.091 20 11 23 0 221113600 4609552 1737008
02:07:57 223 2147483648 2527064192 2606456832 201520448 8.578 19 7 14 0 204931328 1812416 1598464
02:08:58 217 2147483648 2543534128 2622914560 214736496 9.090 20 17 34 0 221516480 3836560 2943424
02:09:58 198 2147483648 2546155440 2625241088 213374400 9.038 20 11 22 0 222769680 7643840 1751440
02:10:59 435 2147483648 2546437488 2626150400 217482080 9.195 20 13 24 0 222528352 3002272 2044000
02:11:59 242 2147483648 2548010448 2628710400 214851424 9.094 20 12 23 1 225320784 8369904 2099456
02:13:00 184 2147483648 2548456592 2629021696 213025376 9.024 20 12 24 0 224668720 9538176 2105168
02:14:00 157 2147483648 2539109120 2619715584 210517664 8.927 20 13 22 0 216058512 3481648 2059200
02:15:01 556 2147483648 2549428272 2630983680 215267376 9.110 20 9 18 0 224648240 7755472 1625392
02:16:02 866 2147483648 2553410016 2635128832 219535904 9.274 20 13 24 2 229525904 8105344 1884656
02:17:03 208 2147483648 2557745952 2637996032 216640960 9.163 20 12 23 0 233484048 14777520 2065568
02:18:04 418 2147483648 2552429872 2632630272 213380752 9.038 20 12 24 0 228451792 12925536 2145504
02:19:05 145 2147483648 2546835968 2629107712 214387792 9.077 20 10 20 0 223179440 6937840 1853808
02:20:05 132 2147483648 2553679760 2638381056 212301008 8.996 20 11 22 0 229385904 15401600 1683296
02:21:05 311 2147483648 2539210832 2623254528 211246288 8.955 20 8 16 1 216170096 3455280 1468528
02:22:06 197 2147483648 2555569040 2635354112 211618192 8.970 20 16 32 2 231273136 17156848 2498096
02:23:07 488 2147483648 2560132512 2641690624 213987056 9.061 20 13 25 0 235676288 19405072 2284160
02:24:07 907 2147483648 2564002368 2649448448 222518000 9.388 20 12 24 0 242149168 17201040 2430128
02:25:09 465 2147483648 2541216560 2622935040 211968960 8.983 20 14 28 0 218898640 4225312 2704368
02:26:10 103 2147483648 2549434160 2629939200 211980704 8.984 20 12 24 0 225671936 11539088 2152144
02:27:10 382 2147483648 2556574352 2648940544 218149920 9.221 20 10 20 0 233011296 13076464 1784912
02:28:12 254 2147483648 2585921520 2669060096 222962384 9.405 20 14 28 0 261673680 36334640 2376656
02:29:13 133 2147483648 2535861952 2611425280 198507104 8.461 20 13 26 0 211086224 10300128 2278992
02:30:13 138 2147483648 2558207280 2640502784 220381584 9.307 20 12 24 0 233783584 11326656 2075344
02:31:13 160 2147483648 2534060048 2613489664 200184944 8.526 19 11 22 0 210513984 8295744 2033296
02:32:14 281 2147483648 2557107600 2641944576 220008064 9.292 20 11 22 0 234142768 12372256 1762448
02:33:14 201 2147483648 2555995024 2637230080 217432384 9.194 20 13 26 1 230980064 11214912 2332768
02:34:15 131 2147483648 2562732480 2645508096 219049664 9.256 20 13 26 0 238493600 17252432 2191504
02:35:15 157 2147483648 2554786144 2637963264 212232688 8.993 20 13 25 0 230304800 15848976 2223136
02:36:16 246 2147483648 2546001936 2634149888 214050640 9.064 20 11 24 0 221558928 5567680 1940608
02:37:16 672 2147483648 2546872320 2629148672 213871072 9.057 20 8 16 1 221179728 6181360 1127296
02:38:17 170 2147483648 2551483712 2632704000 210217408 8.916 20 12 24 0 226802880 14715536 1869936
02:39:18 267 2147483648 2554506144 2636054528 216475424 9.157 20 14 28 0 228102112 9347040 2279648
02:40:19 193 2147483648 2552257280 2633097216 217319392 9.189 20 14 26 0 227531680 8100992 2111296
02:41:19 191 2147483648 2555979920 2637713408 211843344 8.978 20 9 18 0 231502352 18327184 1331824
02:42:20 151 2147483648 2560289776 2642124800 219956160 9.290 20 14 28 0 236182512 13616640 2609712
02:43:20 313 2147483648 2558802816 2640343040 215836896 9.132 20 11 26 1 235047168 17162176 2048096
02:44:21 209 2147483648 2569479552 2668802048 215835120 9.132 20 11 22 0 245432032 27236480 2360432
02:45:22 280 2147483648 2555715296 2639908864 216176080 9.145 20 8 16 0 230198080 12905008 1116992
02:46:22 269 2147483648 2568738160 2653097984 212979504 9.022 20 12 25 0 244512144 29269520 2263120
02:47:23 225 2147483648 2551066800 2631401472 213379008 9.038 20 9 17 0 225530640 10955904 1195728
02:48:23 232 2147483648 2554542464 2641289216 216693456 9.165 20 5 10 0 229682704 12292320 696928
02:49:23 132 2147483648 2557666576 2640470016 216702240 9.166 20 12 24 0 232695712 13800240 2193232
02:50:24 264 2147483648 2554023216 2634084352 212584176 9.007 20 18 36 0 227503328 11874224 3044928

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 05-11-2026 02:51:15 to 05-11-2026 02:51:28.

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 05-11-2026 02:51:28 to 05-11-2026 02:51:29.

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          222310
MON$OLDEST_ACTIVE               222799
MON$OLDEST_SNAPSHOT             222799
MON$NEXT_TRANSACTION            222799
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-04 23:00:11.2340 GMT
MON$PAGES                       151912
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                        {A5ACD602-E6FC-46C2-AA1B-6C9E0684F0BB}
MON$FILE_ID                     01080000000000009fed070000000000
MON$NEXT_ATTACHMENT             573
MON$NEXT_STATEMENT              54
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.8.3338 Firebird 4.0 6329bc9
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.8.3338 Firebird 4.0 6329bc9"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.8.3338 Firebird 4.0 6329bc9/tcp (test-0)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.8.3338 Firebird 4.0 6329bc9/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'

05.11.26 02:51:29. 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-05 02:51:31 No severe PSQL-related problems occured
05.11.26 02:51:31. End of report.