Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 09.11.2026 19: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 2d
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 2401416 kB
MemAvailable 7473564 kB
Buffers 77648 kB
Cached 5127928 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
AllowUpdateOverwrite true true
AuditTraceConfigFile [empty] [empty]
AuthClient Srp256, Srp, Legacy_Auth Srp256, Srp, Legacy_Auth
AuthServer Srp256 Srp256
BugcheckAbort true false [ X ] firebird.conf
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
DefaultProfilerPlugin Default_Profiler Default_Profiler
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_fb50SS 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
MaxParallelWorkers 1 1
MaxStatementCacheSize 2097152 2097152
MaxUnflushedWriteTime -1 -1
MaxUnflushedWrites -1 -1
MaxUserTraceLogSize 10 10
OnDisconnectTriggerTimeout 180 180
OptimizeForFirstRows false false
OuterJoinConversion true true
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
RemoteServiceName gds_db gds_db
RemoteServicePort 3500 0 [ X ] firebird.conf
SecurityDatabase /opt/fb50/security5.fdb /opt/fb50/security5.fdb
ServerMode Super Super [ X ] firebird.conf
SnapshotsMemSize 65536 65536
StatementTimeout 0 0
SubQueryConversion 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
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-fb50.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-fb50.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/var/db/oltp-emul/oltp_50.etalone.fdb
param=expected_workers, val=100
param=fbc, val=/opt/fb50/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=blue
param=html_chart_color_memo_att, val=blue
param=html_chart_color_memo_stm, val=blue
param=html_chart_color_memo_trn, val=blue
param=html_chart_color_perf_score, val=blue
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=3500
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-fb50-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-fb50
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-09 19:50:37
DTS_END                         2026-11-09 19:50:37.2600
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/54862
TRN_ID                          221110
ATT_ID                          460
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: 14469.10 1337 723455
customer order: creation 651.58 40 32579
customer order: refuse 53.88 51 2694
order to supplier: creation 164.84 192 8242
order to supplier: removal 11.44 8894 572
invoice (draft): creation 166.08 330 8304
invoice (draft): removal 116.70 133 5835
invoice accept: apply 143.28 1386 7164
invoice accept: cancel 97.78 198 4889
customer reserve: creation 7031.56 23 351578
customer reserve: removal 5036.58 15 251829
realization accept: apply 308.74 31 15437
realization accept: cancel 179.16 17 8958
payment from customer: creation 218.12 32 10906
payment from customer: removal 20.30 17 1015
payment to supplier: creation 177.86 26 8893
payment to supplier: removal 13.14 16 657
service: total inventory turnovers 21.14 1608 1057
service: total monetary turnovers 51.88 15 2594
service: aggregate perf. data 5.00 1411 250
service: refresh index statistics 0.04 12312 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 09-11-2026 19:50:54 to 09-11-2026 19:50:55.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 10717
TEST_TIME 2 11113
TEST_TIME 3 11507
TEST_TIME 4 11777
TEST_TIME 5 12031
TEST_TIME 6 12139
TEST_TIME 7 12419
TEST_TIME 8 12719
TEST_TIME 9 12915
TEST_TIME 10 13079
TEST_TIME 11 13180
TEST_TIME 12 13383
TEST_TIME 13 13670
TEST_TIME 14 13711
TEST_TIME 15 13831
TEST_TIME 16 13904
TEST_TIME 17 13893
TEST_TIME 18 13977
TEST_TIME 19 14026
TEST_TIME 20 14080
TEST_TIME 21 14048
TEST_TIME 22 14029
TEST_TIME 23 14026
TEST_TIME 24 14023
TEST_TIME 25 13967
TEST_TIME 26 13987
TEST_TIME 27 13990
TEST_TIME 28 13937
TEST_TIME 29 14021
TEST_TIME 30 13994
TEST_TIME 31 13983
TEST_TIME 32 14051
TEST_TIME 33 14174
TEST_TIME 34 14262
TEST_TIME 35 14257
TEST_TIME 36 14274
TEST_TIME 37 14438
TEST_TIME 38 14473
TEST_TIME 39 14437
TEST_TIME 40 14469
TEST_TIME 41 14472
TEST_TIME 42 14537
TEST_TIME 43 14518
TEST_TIME 44 14635
TEST_TIME 45 14618
TEST_TIME 46 14616
TEST_TIME 47 14596
TEST_TIME 48 14593
TEST_TIME 49 14613
TEST_TIME 50 14469

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 09-11-2026 19:50:56 to 09-11-2026 19:50:58.

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 1072165 1072165 0 0.00 0 1516 2 0 0
doc_list_biud 1072165 1072165 0 0.00 0 2804 5 0 0
sp_add_invoice_to_stock 7164 7164 0 0.00 5 16319 1387 0 0
sp_cancel_adding_invoice 4889 4889 0 0.00 3 5158 198 0 0
sp_cancel_client_order 2694 2694 0 0.00 2 1081 52 0 0
sp_cancel_customer_reserve 251829 251829 0 0.00 1 2488 15 0 0
sp_cancel_pay_from_customer 1015 1015 0 0.00 1 324 18 0 0
sp_cancel_pay_to_supplier 657 657 0 0.00 1 362 16 0 0
sp_cancel_supplier_invoice 5835 5835 0 0.00 2 2573 133 0 0
sp_cancel_supplier_order 572 572 0 0.00 5 51464 8894 0 0
sp_cancel_write_off 8958 8958 0 0.00 1 853 18 0 0
sp_client_order 32579 32579 0 0.00 2 1683 40 0 0
sp_customer_reserve 351578 351578 0 0.00 0 3726 24 0 0
sp_fill_shopping_cart 49125 49125 0 0.00 0 1377 17 0 0
sp_fill_shopping_cart_clo_res 351578 351578 0 0.00 0 2429 2 0 0
sp_get_clo_for_invoice 7164 7164 0 0.00 0 1901 34 0 0
sp_kill_cost_storno 15519 15519 0 0.00 0 936 8 0 0
sp_kill_qstorno_ret_qs2qd 519023 519023 0 0.00 0 2541 8 0 0
sp_kill_qty_storno 297378 297378 0 0.00 0 2803 17 0 0
sp_lock_selected_doc 31237 31237 0 0.00 0 455 1 0 0
sp_make_cost_storno 42400 42400 0 0.00 0 1115 6 0 0
sp_multiply_rows_for_pdistr 42400 42400 0 0.00 0 923 9 0 0
sp_multiply_rows_for_qdistr 32579 32579 0 0.00 0 1414 17 0 0
sp_pay_from_customer 10906 10906 0 0.00 1 2375 33 0 0
sp_pay_to_supplier 8893 8893 0 0.00 2 2386 27 0 0
sp_payment_common 19799 19799 0 0.00 0 812 8 0 0
sp_qd_handle_on_cancel_clo 2694 2694 0 0.00 0 1080 38 0 0
sp_qd_handle_on_invoice_upd_sts 12053 12053 0 0.00 0 2803 65 0 0
sp_qd_handle_on_reserve_upd_sts 15437 15437 0 0.00 0 1386 10 0 0
sp_reserve_write_off 15437 15437 0 0.00 2 1487 32 0 0
sp_supplier_invoice 8304 8304 0 0.00 5 5740 330 0 0
sp_supplier_order 8242 8242 0 0.00 3 3219 193 0 0
srv_aggregate_perf_data 250 250 0 0.00 13 7654 1412 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 3 474 292 0 0
srv_find_qd_qs_mism 674036 674036 0 0.00 0 1515 1 0 0
srv_make_invnt_saldo 1057 1057 0 0.00 5 5467 1609 0 0
srv_make_money_saldo 2594 2594 0 0.00 0 342 15 0 0
srv_recalc_idx_stat 2 2 0 0.00 378 24247 12313 0 0
v_add_invoice_to_stock 14328 14328 0 0.00 0 747 2 0 0
v_all_customers 49592 49592 0 0.00 0 127 0 0 0
v_all_suppliers 40654 40654 0 0.00 0 85 0 0 0
v_all_wares 65158 65158 0 0.00 0 55 0 0 0
v_cancel_adding_invoice 1288 1288 0 0.00 0 299 2 0 0
v_cancel_client_order 5388 5388 0 0.00 0 321 1 0 0
v_cancel_customer_prepayment 2030 2030 0 0.00 0 300 2 0 0
v_cancel_customer_reserve 1964 1964 0 0.00 0 130 2 0 0
v_cancel_payment_to_supplier 1314 1314 0 0.00 0 55 1 0 0
v_cancel_supplier_invoice 1152 1152 0 0.00 0 420 3 0 0
v_cancel_supplier_order 1144 1144 0 0.00 0 57 2 0 0
v_cancel_write_off 2992 2992 0 0.00 0 338 2 0 0
v_max_id_clo_ord 8242 8242 0 0.00 0 689 1 0 0
v_max_id_clo_res 1466 1466 0 0.00 0 283 2 0 0
v_max_id_ord_sup 8304 8304 0 0.00 0 880 2 0 0
v_max_non_paid_invoice 5112 5112 0 0.00 0 317 2 0 0
v_max_non_paid_realizn 10584 10584 0 0.00 0 122 1 0 0
v_min_id_clo_ord 8242 8242 0 0.00 0 548 2 0 0
v_min_id_clo_res 1466 1466 0 0.00 0 539 3 0 0
v_min_id_ord_sup 8304 8304 0 0.00 0 1231 4 0 0
v_min_non_paid_invoice 8893 8893 0 0.00 0 318 3 0 0
v_min_non_paid_realizn 10906 10906 0 0.00 0 573 4 0 0
v_our_firm 16210 16210 0 0.00 0 38 1 0 0
v_reserve_write_off 30874 30874 0 0.00 0 751 1 0 0
x_lock_depdocs_on_canc_invoice 10148 10148 0 0.00 0 946 9 0 0
x_lock_depdocs_on_canc_sup_ord 572 572 0 0.00 0 274 10 0 0
x_make_qstorno_1000_1200 8242 8242 0 0.00 1 3213 143 0 0
x_make_qstorno_1200_2000 8304 8304 0 0.00 1 5730 293 0 0
x_make_qstorno_2100_3300 351578 351578 0 0.00 0 3726 21 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 09-11-2026 19:50:58 to 09-11-2026 19:51:02.

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
19:00:41 3 2147483648 2253215136 2255597568 4112736 0.191 1 1 2 0 4181792 60512 8544
19:01:42 258 2147483648 2496105840 2734194688 239681056 10.040 19 10 18 0 241650416 1793568 175792
19:02:42 249 2147483648 2529433712 2781126656 271142352 11.210 20 7 14 0 275383808 3955648 285808
19:03:44 293 2147483648 2525551872 2771738624 270766864 11.196 20 10 21 0 273047136 1875408 404864
19:04:44 266 2147483648 2505481376 2711339008 249486048 10.408 20 13 26 1 252475456 2554592 434816
19:05:45 285 2147483648 2531819152 2782265344 275236912 11.360 20 10 20 0 277171968 1594976 340080
19:06:45 181 2147483648 2522830720 2751905792 266102896 11.025 20 11 21 1 268712608 2237984 371728
19:07:46 248 2147483648 2528638768 2781184000 272184528 11.248 20 13 26 0 274982512 2280720 517264
19:08:46 192 2147483648 2524911728 2753441792 261425232 10.852 20 8 16 1 270257040 8518976 312832
19:09:47 188 2147483648 2538953504 2792423424 274576560 11.336 20 7 15 0 283908768 8980912 351296
19:10:47 212 2147483648 2540106896 2775719936 269987568 11.168 20 11 22 0 286155264 15711376 456320
19:11:48 231 2147483648 2535358128 2787500032 274808096 11.344 20 12 21 1 280454928 5283760 363072
19:12:48 365 2147483648 2534705264 2770636800 265474112 11.002 20 12 24 0 278435200 12460656 500432
19:13:49 312 2147483648 2538872080 2784854016 272060704 11.244 20 16 32 0 281548512 8832624 655184
19:14:50 322 2147483648 2521019712 2757779456 264461536 10.964 20 10 21 0 266093680 1253184 378960
19:15:51 167 2147483648 2530228224 2774941696 267757120 11.086 20 11 22 0 274795104 6606368 431616
19:16:51 403 2147483648 2530934080 2773307392 269696736 11.157 20 11 22 0 275249792 5160688 392368
19:17:52 188 2147483648 2546338240 2784149504 271075968 11.208 20 13 26 0 289205248 17595936 533344
19:18:52 275 2147483648 2537997712 2780033024 272924400 11.275 20 13 26 0 284227168 10752784 549984
19:19:53 313 2147483648 2535592144 2771038208 268062800 11.097 20 11 22 0 278351360 9853408 435152
19:20:53 334 2147483648 2529330576 2768556032 267706400 11.084 20 12 23 0 272939904 4725664 507840
19:21:54 246 2147483648 2518313856 2735263744 249928800 10.424 20 10 19 0 262960400 12706944 324656
19:22:55 237 2147483648 2551001264 2794737664 274081216 11.318 20 9 18 0 295321728 20781488 459024
19:23:55 293 2147483648 2540273696 2791018496 272959488 11.277 20 12 24 1 285587072 12100544 527040
19:24:56 464 2147483648 2545788624 2789519360 271919536 11.239 20 14 28 0 288957424 16420288 617600
19:25:57 253 2147483648 2543643280 2773389312 264511520 10.966 20 11 22 0 285474688 20468928 494240
19:26:57 325 2147483648 2551006512 2801074176 278001360 11.461 20 9 18 0 295888544 17490784 396400
19:27:58 244 2147483648 2536283488 2774999040 268454448 11.111 20 14 28 0 278791568 9756736 580384
19:28:59 217 2147483648 2543101408 2780012544 272380992 11.256 20 16 32 3 286991184 13879600 730592
19:29:59 319 2147483648 2535780288 2779996160 273379360 11.292 20 11 21 0 278275552 4365744 530448
19:31:00 381 2147483648 2543539648 2789998592 278969872 11.497 20 8 16 0 288069120 8747472 351776
19:32:02 400 2147483648 2545222848 2792464384 266879840 11.053 20 9 18 0 287978720 20700928 397952
19:33:03 408 2147483648 2545288384 2796040192 264793568 10.976 20 5 10 0 288869744 23798912 277264
19:34:03 349 2147483648 2530383168 2772029440 264625760 10.970 20 8 16 0 274104464 9097808 380896
19:35:05 256 2147483648 2522681728 2761416704 263875632 10.943 20 9 18 1 267015568 2866272 273664
19:36:06 253 2147483648 2530762976 2769072128 267558160 11.078 20 5 10 0 275186960 7443776 185024
19:37:06 275 2147483648 2525931792 2757898240 251015552 10.465 19 10 20 0 268560528 17110624 434352
19:38:07 450 2147483648 2538721488 2785710080 267405760 11.073 20 6 10 1 283140512 15434480 300272
19:39:08 274 2147483648 2525232352 2765402112 265326384 10.996 20 12 25 0 268713968 2879040 508544
19:40:08 307 2147483648 2531164992 2780770304 267903184 11.091 20 10 19 1 276150144 7785744 461216
19:41:09 265 2147483648 2532597744 2768826368 257718416 10.715 20 12 23 0 276356832 18170928 467488
19:42:10 296 2147483648 2514356928 2736709632 245626048 10.263 19 7 14 0 258512960 12513392 373520
19:43:11 375 2147483648 2533705968 2780987392 269544048 11.151 20 13 26 0 275904720 5807600 553072
19:44:11 299 2147483648 2551999984 2794209280 265940032 11.019 20 10 22 0 294891808 28426160 525616
19:45:13 421 2147483648 2532037456 2774867968 268237168 11.103 20 9 18 0 275608016 6990672 380176
19:46:14 305 2147483648 2534900032 2781249536 267689680 11.083 20 12 23 0 278721072 10525520 505872
19:47:15 345 2147483648 2528488240 2772697088 267708416 11.084 20 13 24 0 272609024 4408736 491872
19:48:15 343 2147483648 2524669648 2769944576 265559168 11.005 20 6 12 0 270144256 4375584 209504
19:49:16 314 2147483648 2548786064 2795352064 268478256 11.112 20 11 22 0 292221584 23192896 550432
19:50:16 273 2147483648 2524836816 2766188544 264439520 10.963 20 12 24 0 269204368 4330032 434816

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:12, from 09-11-2026 19:51:03 to 09-11-2026 19:51:15.

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 09-11-2026 19:51:15 to 09-11-2026 19:51:16.

Content of mon$database and FB version


MON$DATABASE_NAME               /var/db/oltp-emul/oltp-fb50.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   1
MON$OLDEST_TRANSACTION          221007
MON$OLDEST_ACTIVE               221224
MON$OLDEST_SNAPSHOT             221224
MON$NEXT_TRANSACTION            221224
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-09 16:00:09.3580 GMT
MON$PAGES                       182308
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                        {15B9EA9F-E0A0-434C-83B5-7B98A1495EA1}
MON$FILE_ID                     01080000000000007aed070000000000
MON$NEXT_ATTACHMENT             584
MON$NEXT_STATEMENT              512
MON$REPLICA_MODE                0


ISQL Version: LI-V5.0.5.1956 Firebird 5.0 35c6556
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V5.0.5.1956 Firebird 5.0 35c6556"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V5.0.5.1956 Firebird 5.0 35c6556/tcp (test-0)/P19:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V5.0.5.1956 Firebird 5.0 35c6556/tcp (test-0)/P19:C"
on disk structure version 13.1

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  9 19:50:41 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3500
:9: 
:10: 
:11: test-0    Mon Nov  9 19:50:41 2026
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3500
:13: 
:14: 
:15: test-0    Mon Nov  9 19:50:41 2026
:16:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3500
:17: 
--- end of diff output ---

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

09.11.26 19:51:17. There are 3 logs in /var/tmp/logs.oltp-fb50 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-09 19:51:17 No severe PSQL-related problems occured
09.11.26 19:51:18. End of report.