Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 14.11.2026 16: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 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 2w
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 1929208 kB
MemAvailable 7261496 kB
Buffers 81780 kB
Cached 5372696 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
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-14 16:50:48
DTS_END                         2026-11-14 16:50:48.9170
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/38412
TRN_ID                          233689
ATT_ID                          480
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: 15664.46 851 783223
customer order: creation 686.36 46 34318
customer order: refuse 54.90 44 2745
order to supplier: creation 176.48 204 8824
order to supplier: removal 12.06 9163 603
invoice (draft): creation 174.08 361 8704
invoice (draft): removal 123.06 141 6153
invoice accept: apply 150.48 1415 7524
invoice accept: cancel 103.18 194 5159
customer reserve: creation 7658.66 23 382933
customer reserve: removal 5463.84 14 273192
realization accept: apply 327.98 37 16399
realization accept: cancel 192.38 19 9619
payment from customer: creation 230.12 35 11506
payment from customer: removal 22.22 19 1111
payment to supplier: creation 189.14 31 9457
payment to supplier: removal 13.46 17 673
service: total inventory turnovers 24.70 1337 1235
service: total monetary turnovers 56.12 14 2806
service: aggregate perf. data 5.20 1824 260
service: refresh index statistics 0.04 2075 2

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 9984
TEST_TIME 2 11478
TEST_TIME 3 12300
TEST_TIME 4 12640
TEST_TIME 5 12843
TEST_TIME 6 13228
TEST_TIME 7 13354
TEST_TIME 8 13467
TEST_TIME 9 13545
TEST_TIME 10 13561
TEST_TIME 11 13790
TEST_TIME 12 13873
TEST_TIME 13 13906
TEST_TIME 14 14054
TEST_TIME 15 14075
TEST_TIME 16 14206
TEST_TIME 17 14309
TEST_TIME 18 14364
TEST_TIME 19 14320
TEST_TIME 20 14506
TEST_TIME 21 14523
TEST_TIME 22 14464
TEST_TIME 23 14606
TEST_TIME 24 14752
TEST_TIME 25 14616
TEST_TIME 26 14662
TEST_TIME 27 14753
TEST_TIME 28 14762
TEST_TIME 29 14756
TEST_TIME 30 14759
TEST_TIME 31 14787
TEST_TIME 32 14979
TEST_TIME 33 14960
TEST_TIME 34 15152
TEST_TIME 35 15080
TEST_TIME 36 15273
TEST_TIME 37 15338
TEST_TIME 38 15379
TEST_TIME 39 15461
TEST_TIME 40 15446
TEST_TIME 41 15539
TEST_TIME 42 15592
TEST_TIME 43 15616
TEST_TIME 44 15612
TEST_TIME 45 15661
TEST_TIME 46 15581
TEST_TIME 47 15758
TEST_TIME 48 15747
TEST_TIME 49 15712
TEST_TIME 50 15664

Performance per minute, chart


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

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 1156635 1156635 0 0.00 0 1436 2 0 0
doc_list_biud 1156635 1156635 0 0.00 0 2013 5 0 0
sp_add_invoice_to_stock 7524 7524 0 0.00 9 11455 1416 0 0
sp_cancel_adding_invoice 5159 5159 0 0.00 3 4899 195 0 0
sp_cancel_client_order 2745 2745 0 0.00 2 799 45 0 0
sp_cancel_customer_reserve 273192 273192 0 0.00 1 1851 14 0 0
sp_cancel_pay_from_customer 1111 1111 0 0.00 2 536 19 0 0
sp_cancel_pay_to_supplier 673 673 0 0.00 2 312 18 0 0
sp_cancel_supplier_invoice 6153 6153 0 0.00 1 1838 142 0 0
sp_cancel_supplier_order 603 603 0 0.00 5 63967 9163 0 0
sp_cancel_write_off 9619 9619 0 0.00 1 770 20 0 0
sp_client_order 34318 34318 0 0.00 4 1447 47 0 0
sp_customer_reserve 382933 382933 0 0.00 0 2888 23 0 0
sp_fill_shopping_cart 51846 51846 0 0.00 1 2916 20 0 0
sp_fill_shopping_cart_clo_res 382933 382933 0 0.00 0 1708 2 0 0
sp_get_clo_for_invoice 7524 7524 0 0.00 0 2043 33 0 0
sp_kill_cost_storno 16562 16562 0 0.00 0 920 10 0 0
sp_kill_qstorno_ret_qs2qd 562759 562759 0 0.00 0 2013 7 0 0
sp_kill_qty_storno 321394 321394 0 0.00 0 2013 17 0 0
sp_lock_selected_doc 32833 32833 0 0.00 0 730 2 0 0
sp_make_cost_storno 44886 44886 0 0.00 0 1017 8 0 0
sp_multiply_rows_for_pdistr 44886 44886 0 0.00 0 612 11 0 0
sp_multiply_rows_for_qdistr 34318 34318 0 0.00 0 1387 18 0 0
sp_pay_from_customer 11506 11506 0 0.00 3 1070 36 0 0
sp_pay_to_supplier 9457 9457 0 0.00 3 761 31 0 0
sp_payment_common 20963 20963 0 0.00 1 692 6 0 0
sp_qd_handle_on_cancel_clo 2745 2745 0 0.00 0 793 30 0 0
sp_qd_handle_on_invoice_upd_sts 12683 12683 0 0.00 0 1638 70 0 0
sp_qd_handle_on_reserve_upd_sts 16399 16399 0 0.00 0 938 10 0 0
sp_reserve_write_off 16399 16399 0 0.00 3 1426 38 0 0
sp_supplier_invoice 8704 8704 0 0.00 5 5198 361 0 0
sp_supplier_order 8824 8824 0 0.00 6 2226 205 0 0
srv_aggregate_perf_data 260 260 0 0.00 66 8570 1825 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 3 637 202 0 0
srv_find_qd_qs_mism 727641 727641 0 0.00 0 1433 1 0 0
srv_make_invnt_saldo 1235 1235 0 0.00 1 4251 1338 0 0
srv_make_money_saldo 2806 2806 0 0.00 0 368 15 0 0
srv_recalc_idx_stat 2 2 0 0.00 203 3948 2076 0 0
v_add_invoice_to_stock 15048 15048 0 0.00 0 730 2 0 0
v_all_customers 52368 52368 0 0.00 0 51 1 0 0
v_all_suppliers 43566 43566 0 0.00 0 42 1 0 0
v_all_wares 68636 68636 0 0.00 0 36 1 0 0
v_cancel_adding_invoice 1258 1258 0 0.00 0 303 2 0 0
v_cancel_client_order 5490 5490 0 0.00 0 565 1 0 0
v_cancel_customer_prepayment 2222 2222 0 0.00 0 123 1 0 0
v_cancel_customer_reserve 2182 2182 0 0.00 0 78 2 0 0
v_cancel_payment_to_supplier 1346 1346 0 0.00 0 128 1 0 0
v_cancel_supplier_invoice 1114 1114 0 0.00 0 25 2 0 0
v_cancel_supplier_order 1206 1206 0 0.00 0 88 1 0 0
v_cancel_write_off 3002 3002 0 0.00 0 577 2 0 0
v_max_id_clo_ord 8824 8824 0 0.00 0 39 1 0 0
v_max_id_clo_res 1610 1610 0 0.00 0 247 1 0 0
v_max_id_ord_sup 8704 8704 0 0.00 0 701 2 0 0
v_max_non_paid_invoice 5202 5202 0 0.00 0 69 1 0 0
v_max_non_paid_realizn 11074 11074 0 0.00 0 40 1 0 0
v_min_id_clo_ord 8824 8824 0 0.00 0 347 2 0 0
v_min_id_clo_res 1610 1610 0 0.00 0 645 3 0 0
v_min_id_ord_sup 8704 8704 0 0.00 0 815 4 0 0
v_min_non_paid_invoice 9457 9457 0 0.00 0 471 2 0 0
v_min_non_paid_realizn 11506 11506 0 0.00 0 424 2 0 0
v_our_firm 17132 17132 0 0.00 0 28 1 0 0
v_reserve_write_off 32798 32798 0 0.00 0 696 2 0 0
x_lock_depdocs_on_canc_invoice 10755 10755 0 0.00 0 1503 9 0 0
x_lock_depdocs_on_canc_sup_ord 603 603 0 0.00 0 205 12 0 0
x_make_qstorno_1000_1200 8824 8824 0 0.00 1 2123 148 0 0
x_make_qstorno_1200_2000 8704 8704 0 0.00 1 4631 320 0 0
x_make_qstorno_2100_3300 382933 382933 0 0.00 0 2886 20 0 0

Completed "Performance in DETAILS". Done for 00:00:03, from 14-11-2026 16:51:15 to 14-11-2026 16:51:18.

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
16:00:52 3 2147483648 2309550144 2313269248 3168864 0.147 1 1 2 0 3266304 61664 35776
16:01:52 171 2147483648 2528645456 2601246720 197308112 8.414 20 11 22 0 201233376 2547072 1378192
16:02:53 218 2147483648 2546481984 2627096576 219046848 9.256 20 9 20 0 221410576 759984 1603744
16:03:53 261 2147483648 2551820400 2632949760 219734944 9.282 20 15 32 1 226129728 2854544 3540240
16:04:54 189 2147483648 2542202208 2623066112 211556224 8.967 20 7 12 0 217416784 4410256 1450304
16:05:55 181 2147483648 2518445040 2593554432 186766128 8.001 18 10 20 0 195085872 6277424 2042320
16:06:55 172 2147483648 2553097760 2636115968 222047920 9.370 20 13 27 0 227487360 2811616 2627824
16:07:56 247 2147483648 2543296736 2624053248 210911600 8.943 20 14 28 0 217066576 3981856 2173120
16:08:56 230 2147483648 2552096880 2638024704 220066592 9.295 20 10 18 0 225687568 4241136 1379840
16:09:57 202 2147483648 2548987872 2629574656 212354384 8.998 20 15 30 1 222711344 7676832 2680128
16:10:57 159 2147483648 2555178000 2637062144 215385040 9.115 20 10 20 0 228536064 11468048 1682976
16:11:57 187 2147483648 2556116256 2638151680 215678160 9.126 20 13 23 1 229499424 12178736 1642528
16:12:58 329 2147483648 2546923152 2626572288 208822192 8.862 20 13 26 0 220123984 9406096 1895696
16:13:59 255 2147483648 2568705024 2652991488 219677520 9.280 20 12 25 0 241192336 19521504 1993312
16:14:59 168 2147483648 2548601360 2633224192 216938464 9.175 20 9 18 0 222834080 4454768 1440848
16:16:00 128 2147483648 2553478976 2634289152 214740416 9.090 20 17 35 1 226796928 8821600 3234912
16:17:00 120 2147483648 2554969872 2637725696 215400544 9.116 20 14 28 0 229717040 11636176 2680320
16:18:00 167 2147483648 2563212320 2646949888 216049776 9.140 20 11 22 0 236084960 18057472 1977712
16:19:01 198 2147483648 2560098576 2640338944 211686624 8.972 20 16 32 0 233040576 18495712 2858240
16:20:02 158 2147483648 2576667680 2658045952 219587360 9.276 20 12 23 0 248950944 27211504 2152080
16:21:02 139 2147483648 2547205648 2626957312 203418736 8.652 20 14 30 0 220556512 14609376 2528400
16:22:02 176 2147483648 2549115424 2631249920 211270384 8.956 20 16 32 0 221305504 7523872 2511248
16:23:03 163 2147483648 2561481312 2643566592 211492512 8.965 20 14 28 0 235001408 21072640 2436256
16:24:04 254 2147483648 2565323072 2647949312 211976368 8.984 20 12 23 0 239079696 24985712 2117616
16:25:04 153 2147483648 2546268976 2629976064 212686960 9.011 20 8 16 0 220781232 6718528 1375744
16:26:05 159 2147483648 2551196544 2632925184 209491984 8.888 20 8 16 0 223605936 12812144 1301808
16:27:05 171 2147483648 2568155616 2650120192 214875040 9.095 20 11 21 0 240719152 23988848 1855264
16:28:06 141 2147483648 2557301712 2637545472 213325392 9.036 20 13 26 0 229808320 14172880 2310048
16:29:06 272 2147483648 2545157648 2629570560 209794448 8.899 20 9 17 0 218393456 7151856 1447152
16:30:06 120 2147483648 2561451696 2642829312 219515488 9.273 20 12 24 0 234093360 12733952 1843920
16:31:07 271 2147483648 2548769952 2633756672 214096112 9.065 20 12 24 0 222445728 6331136 2018480
16:32:07 141 2147483648 2573578032 2658893824 217079824 9.180 20 8 16 0 246785216 28098256 1607136
16:33:08 338 2147483648 2552799536 2634457088 212497536 9.004 20 12 24 1 224604048 9988496 2118016
16:34:08 230 2147483648 2563894368 2650013696 211180224 8.953 20 8 15 0 238044864 25350656 1513984
16:35:09 161 2147483648 2542979328 2626953216 211505280 8.965 20 10 20 0 216564816 3599872 1459664
16:36:09 116 2147483648 2588995040 2673356800 221157632 9.336 20 15 27 1 262582448 39059200 2365616
16:37:09 212 2147483648 2569340512 2653749248 215618176 9.124 20 11 21 0 241945824 24651088 1676560
16:38:10 192 2147483648 2560633536 2643898368 218318496 9.228 20 13 26 0 232775424 12191600 2265328
16:39:10 165 2147483648 2573265552 2655612928 213157616 9.029 20 12 24 0 245867888 30294496 2415776
16:40:11 203 2147483648 2555634032 2639904768 215423232 9.116 20 10 20 0 227319568 10188400 1707936
16:41:11 635 2147483648 2572841840 2658693120 214891968 9.096 20 6 12 1 245528848 29594752 1042128
16:42:12 228 2147483648 2559262160 2642509824 216012688 9.139 20 13 26 0 229851664 11751536 2087440
16:43:13 232 2147483648 2558562384 2642251776 212256464 8.994 20 13 26 0 229861424 15379296 2225664
16:44:14 158 2147483648 2561962896 2644602880 216850896 9.171 20 15 30 0 233653168 14194544 2607728
16:45:14 219 2147483648 2567185344 2649280512 215425376 9.116 20 11 22 0 238851472 21670848 1755248
16:46:14 140 2147483648 2546934880 2628026368 210291616 8.919 20 11 22 0 218116048 6043808 1780624
16:47:15 243 2147483648 2564332208 2661904384 216438608 9.155 20 7 14 0 239857616 22246304 1172704
16:48:15 101 2147483648 2556455616 2648055808 216946032 9.175 20 6 12 0 229299920 11340032 1013856
16:49:16 218 2147483648 2538772160 2622599168 207089040 8.795 20 8 16 0 212747120 4038464 1619616
16:50:16 133 2147483648 2567374208 2650386432 215391696 9.115 20 13 27 0 239237648 21572704 2273248

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

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 14-11-2026 16:51:32 to 14-11-2026 16:51:33.

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          231952
MON$OLDEST_ACTIVE               233862
MON$OLDEST_SNAPSHOT             233862
MON$NEXT_TRANSACTION            233862
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-14 13:00:10.6700 GMT
MON$PAGES                       161432
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                        {A60C0DA3-42DE-4796-A2BC-C18F8EE42873}
MON$FILE_ID                     0108000000000000dded070000000000
MON$NEXT_ATTACHMENT             589
MON$NEXT_STATEMENT              54
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.8.3332 Firebird 4.0 HQbird
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.8.3332 Firebird 4.0 HQbird"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.8.3332 Firebird 4.0 HQbird/tcp (test-0)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.8.3332 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    Sat Nov 14 16:50:50 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30400
:9: 
:10: 
:11: test-0    Sat Nov 14 16:50:51 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'

14.11.26 16:51:33. 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-14 16:51:34 No severe PSQL-related problems occured
14.11.26 16:51:35. End of report.