Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 04.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 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 1651596 kB
MemAvailable 7272612 kB
Buffers 87436 kB
Cached 5621820 kB
SwapCached 16 kB
Command: fdisk -l
./oltp_isql_run_worker.sh: line 54: fdisk: command not found

Firebird configuration

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

Server and database settinfs


SERVER_MODE                     SuperServer
DB_NAME                         /var/db/oltp-emul/oltp-hq40.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    262144
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/var/db/oltp-emul/oltp-hq40.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/var/db/oltp-emul/oltp_40.etalone.fdb
param=expected_workers, val=100
param=fbc, val=/opt/hq40/bin
param=file_name_this_host_info, val=test-0
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=html_chart_color_memo_all, val=green
param=html_chart_color_memo_att, val=green
param=html_chart_color_memo_stm, val=green
param=html_chart_color_memo_trn, val=green
param=html_chart_color_perf_score, val=green
param=init_buff, val=4096
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_passwd, val=0Ltp-Emu1
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=30400
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=results_storage_fbk, val=/mnt/oltp-emul/reports/oltp-hq40-results.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=sleep_min, val=0
param=test_intervals, val=30
param=test_time, val=50
param=tmpdir, val=/var/tmp/logs.oltp-hq40
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=use_es, val=0
param=used_in_replication, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=0
param=wait_if_not_exists, val=0
param=warm_time, val=0
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2026-11-04 16:50:57
DTS_END                         2026-11-04 16:50:57.8370
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/42064
TRN_ID                          186714
ATT_ID                          398
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: 11612.16 966 580608
customer order: creation 552.24 55 27612
customer order: refuse 43.30 46 2165
order to supplier: creation 142.18 229 7109
order to supplier: removal 10.36 8391 518
invoice (draft): creation 143.90 365 7195
invoice (draft): removal 101.08 139 5054
invoice accept: apply 121.50 1534 6075
invoice accept: cancel 82.10 208 4105
customer reserve: creation 5549.60 28 277480
customer reserve: removal 4037.12 15 201856
realization accept: apply 257.36 41 12868
realization accept: cancel 143.72 20 7186
payment from customer: creation 181.66 39 9083
payment from customer: removal 17.52 22 876
payment to supplier: creation 150.82 34 7541
payment to supplier: removal 10.46 18 523
service: total inventory turnovers 18.42 1795 921
service: total monetary turnovers 44.36 12 2218
service: aggregate perf. data 4.42 1555 221
service: refresh index statistics 0.04 4780 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 04-11-2026 16:51:23 to 04-11-2026 16:51:24.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5499
TEST_TIME 2 6362
TEST_TIME 3 6727
TEST_TIME 4 7377
TEST_TIME 5 7660
TEST_TIME 6 8161
TEST_TIME 7 8489
TEST_TIME 8 8799
TEST_TIME 9 8973
TEST_TIME 10 9149
TEST_TIME 11 9341
TEST_TIME 12 9455
TEST_TIME 13 9573
TEST_TIME 14 9828
TEST_TIME 15 9895
TEST_TIME 16 10054
TEST_TIME 17 10050
TEST_TIME 18 10206
TEST_TIME 19 10295
TEST_TIME 20 10273
TEST_TIME 21 10280
TEST_TIME 22 10363
TEST_TIME 23 10421
TEST_TIME 24 10496
TEST_TIME 25 10541
TEST_TIME 26 10590
TEST_TIME 27 10780
TEST_TIME 28 10776
TEST_TIME 29 10883
TEST_TIME 30 10918
TEST_TIME 31 10973
TEST_TIME 32 11015
TEST_TIME 33 11057
TEST_TIME 34 11054
TEST_TIME 35 11126
TEST_TIME 36 11134
TEST_TIME 37 11279
TEST_TIME 38 11312
TEST_TIME 39 11313
TEST_TIME 40 11354
TEST_TIME 41 11378
TEST_TIME 42 11281
TEST_TIME 43 11416
TEST_TIME 44 11393
TEST_TIME 45 11449
TEST_TIME 46 11451
TEST_TIME 47 11453
TEST_TIME 48 11557
TEST_TIME 49 11576
TEST_TIME 50 11612

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 04-11-2026 16:51:25 to 04-11-2026 16:51:27.

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 858650 858650 0 0.00 0 2234 2 0 0
doc_list_biud 858650 858650 0 0.00 0 2485 5 0 0
sp_add_invoice_to_stock 6075 6075 0 0.00 6 19293 1535 0 0
sp_cancel_adding_invoice 4105 4105 0 0.00 3 3849 208 0 0
sp_cancel_client_order 2165 2165 0 0.00 2 1139 46 0 0
sp_cancel_customer_reserve 201856 201856 0 0.00 1 2486 16 0 0
sp_cancel_pay_from_customer 876 876 0 0.00 2 484 23 0 0
sp_cancel_pay_to_supplier 523 523 0 0.00 2 255 18 0 0
sp_cancel_supplier_invoice 5054 5054 0 0.00 1 1689 140 0 0
sp_cancel_supplier_order 518 518 0 0.00 6 60391 8391 0 0
sp_cancel_write_off 7186 7186 0 0.00 1 1167 21 0 0
sp_client_order 27612 27612 0 0.00 4 2707 56 0 0
sp_customer_reserve 277480 277480 0 0.00 0 3529 28 0 0
sp_fill_shopping_cart 41916 41916 0 0.00 1 3049 22 0 0
sp_fill_shopping_cart_clo_res 277480 277480 0 0.00 0 1895 2 0 0
sp_get_clo_for_invoice 6075 6075 0 0.00 0 2777 34 0 0
sp_kill_cost_storno 12690 12690 0 0.00 0 1129 10 0 0
sp_kill_qstorno_ret_qs2qd 416470 416470 0 0.00 0 2484 8 0 0
sp_kill_qty_storno 239827 239827 0 0.00 0 2485 18 0 0
sp_lock_selected_doc 26192 26192 0 0.00 0 478 2 0 0
sp_make_cost_storno 35567 35567 0 0.00 0 2232 8 0 0
sp_multiply_rows_for_pdistr 35567 35567 0 0.00 0 1159 12 0 0
sp_multiply_rows_for_qdistr 27612 27612 0 0.00 0 1442 20 0 0
sp_pay_from_customer 9083 9083 0 0.00 3 2261 39 0 0
sp_pay_to_supplier 7541 7541 0 0.00 3 1335 34 0 0
sp_payment_common 16624 16624 0 0.00 1 801 7 0 0
sp_qd_handle_on_cancel_clo 2165 2165 0 0.00 0 1135 31 0 0
sp_qd_handle_on_invoice_upd_sts 10180 10180 0 0.00 0 1896 67 0 0
sp_qd_handle_on_reserve_upd_sts 12868 12868 0 0.00 0 1254 12 0 0
sp_reserve_write_off 12868 12868 0 0.00 3 1275 42 0 0
sp_supplier_invoice 7195 7195 0 0.00 6 4925 366 0 0
sp_supplier_order 7109 7109 0 0.00 5 5544 229 0 0
srv_aggregate_perf_data 221 221 0 0.00 82 10259 1556 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 2 1378 326 0 0
srv_find_qd_qs_mism 540227 540227 0 0.00 0 1216 1 0 0
srv_make_invnt_saldo 921 921 0 0.00 1 10103 1796 0 0
srv_make_money_saldo 2218 2218 0 0.00 0 334 12 0 0
srv_recalc_idx_stat 2 2 0 0.00 303 9258 4781 0 0
v_add_invoice_to_stock 12150 12150 0 0.00 0 1323 3 0 0
v_all_customers 42068 42068 0 0.00 0 59 1 0 0
v_all_suppliers 34560 34560 0 0.00 0 50 1 0 0
v_all_wares 55224 55224 0 0.00 0 78 1 0 0
v_cancel_adding_invoice 1036 1036 0 0.00 0 287 3 0 0
v_cancel_client_order 4330 4330 0 0.00 0 440 2 0 0
v_cancel_customer_prepayment 1752 1752 0 0.00 0 152 2 0 0
v_cancel_customer_reserve 1624 1624 0 0.00 0 470 2 0 0
v_cancel_payment_to_supplier 1046 1046 0 0.00 0 241 2 0 0
v_cancel_supplier_invoice 1006 1006 0 0.00 0 332 3 0 0
v_cancel_supplier_order 1036 1036 0 0.00 0 134 2 0 0
v_cancel_write_off 2668 2668 0 0.00 0 149 2 0 0
v_max_id_clo_ord 7109 7109 0 0.00 0 40 1 0 0
v_max_id_clo_res 1212 1212 0 0.00 0 560 2 0 0
v_max_id_ord_sup 7195 7195 0 0.00 0 874 3 0 0
v_max_non_paid_invoice 4565 4565 0 0.00 0 51 1 0 0
v_max_non_paid_realizn 8791 8791 0 0.00 0 73 1 0 0
v_min_id_clo_ord 7109 7109 0 0.00 0 366 3 0 0
v_min_id_clo_res 1212 1212 0 0.00 0 2311 6 0 0
v_min_id_ord_sup 7195 7195 0 0.00 0 1507 8 0 0
v_min_non_paid_invoice 7541 7541 0 0.00 0 278 2 0 0
v_min_non_paid_realizn 9083 9083 0 0.00 0 559 2 0 0
v_our_firm 13740 13740 0 0.00 0 89 1 0 0
v_reserve_write_off 25736 25736 0 0.00 0 672 2 0 0
x_lock_depdocs_on_canc_invoice 8656 8656 0 0.00 0 1193 8 0 0
x_lock_depdocs_on_canc_sup_ord 518 518 0 0.00 0 179 10 0 0
x_make_qstorno_1000_1200 7109 7109 0 0.00 1 5532 171 0 0
x_make_qstorno_1200_2000 7195 7195 0 0.00 1 4411 314 0 0
x_make_qstorno_2100_3300 277480 277480 0 0.00 0 3527 24 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 04-11-2026 16:51:28 to 04-11-2026 16:51:32.

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:01:02 2 2147483648 2309550144 2313269248 3168864 0.147 1 1 2 0 3266304 61664 35776
16:02:03 330 2147483648 2545918208 2626781184 219918672 9.289 20 8 14 0 221499856 761200 819984
16:03:04 355 2147483648 2540592768 2620567552 214656032 9.087 20 6 12 0 216472576 1336384 480160
16:04:04 246 2147483648 2537961984 2619179008 212724928 9.012 20 3 4 0 213921456 795376 401152
16:05:05 667 2147483648 2544544128 2625286144 214845360 9.094 20 5 10 0 219690704 3966176 879168
16:06:06 222 2147483648 2532006944 2609434624 203786208 8.667 20 11 18 1 206560784 1332832 1441744
16:07:07 458 2147483648 2549864720 2630496256 216695024 9.165 20 11 21 0 223336608 4956976 1684608
16:08:08 222 2147483648 2544392512 2626129920 216414416 9.154 20 9 19 1 218913744 938976 1560352
16:09:08 358 2147483648 2543163456 2625048576 214475472 9.080 20 10 21 0 218137136 1202656 2459008
16:10:09 256 2147483648 2548573920 2632163328 220610768 9.315 20 9 18 0 223821696 1853152 1357776
16:11:10 321 2147483648 2536626128 2622128128 204320464 8.687 20 7 13 0 212610832 7102704 1187664
16:12:10 304 2147483648 2544154208 2625249280 213743392 9.052 20 14 28 0 218466112 2470640 2252080
16:13:11 164 2147483648 2538873696 2622021632 210023840 8.908 20 8 14 0 213508672 2353808 1131024
16:14:12 205 2147483648 2548731968 2631565312 215909264 9.135 20 12 24 0 223464896 4999568 2556064
16:15:12 242 2147483648 2548143744 2631979008 214781232 9.092 20 7 12 1 222778912 7084432 913248
16:16:13 208 2147483648 2548585296 2632318976 217566176 9.199 20 12 21 1 223424576 4189728 1668672
16:17:13 281 2147483648 2545254800 2628648960 215438432 9.117 20 5 10 0 219091856 2769440 883984
16:18:14 104 2147483648 2548502992 2633650176 217198992 9.185 20 8 16 0 223121024 4865264 1056768
16:19:14 125 2147483648 2560134304 2645078016 221226528 9.339 20 8 16 0 233888128 11108880 1552720
16:20:15 214 2147483648 2558993104 2641399808 217479872 9.195 20 10 20 0 231921840 12721072 1720896
16:21:15 1377 2147483648 2544114064 2623275008 202915568 8.633 19 13 26 0 211878832 6694704 2268560
16:22:17 151 2147483648 2547110800 2635014144 214411648 9.077 20 10 20 0 221123264 5225600 1486016
16:23:18 330 2147483648 2559512560 2645811200 215968448 9.137 20 6 12 0 232764192 15621648 1174096
16:24:20 196 2147483648 2553918624 2637856768 213345120 9.036 20 8 16 0 228119248 13678736 1095392
16:25:20 185 2147483648 2551115712 2630893568 214221232 9.070 20 13 23 0 222721136 6601584 1898320
16:26:21 129 2147483648 2542175456 2625802240 210925968 8.943 20 4 8 0 216989424 4995136 1068320
16:27:21 325 2147483648 2555452224 2636046336 207759392 8.821 20 13 27 0 227682096 17803904 2118800
16:28:24 147 2147483648 2543380112 2630537216 213711792 9.050 20 8 15 0 217654960 2678272 1264896
16:29:24 236 2147483648 2573177296 2655887360 218135280 9.221 20 14 28 0 245814512 25337520 2341712
16:30:25 317 2147483648 2550497968 2635358208 217721712 9.205 20 10 21 0 223780496 4373456 1685328
16:31:26 183 2147483648 2552385072 2635870208 217125712 9.182 20 11 22 0 227269808 8482016 1662080
16:32:26 521 2147483648 2553233328 2638671872 213728720 9.051 20 10 20 1 228731776 12944560 2058496
16:33:27 183 2147483648 2546978256 2629488640 214573552 9.084 20 13 24 0 219947792 3296048 2078192
16:34:27 138 2147483648 2541855632 2624626688 209653984 8.894 20 10 20 0 215736240 4147216 1935040
16:35:28 247 2147483648 2557235088 2642763776 216868112 9.172 20 8 16 0 231939872 13475824 1595936
16:36:28 257 2147483648 2556053232 2641620992 217537888 9.198 20 9 18 1 230417312 10914384 1965040
16:37:30 226 2147483648 2555299552 2640416768 215600240 9.123 20 8 15 0 230183504 12738512 1844752
16:38:30 318 2147483648 2536770192 2619203584 206944736 8.789 20 8 16 0 211862096 3221120 1696240
16:39:31 325 2147483648 2547839776 2632646656 212683280 9.011 20 12 22 1 222290048 7793456 1813312
16:40:31 421 2147483648 2542336560 2623107072 205857216 8.747 19 13 26 0 215845184 7934352 2053616
16:41:33 441 2147483648 2545534320 2626437120 212143024 8.990 20 6 12 1 219485328 6396688 945616
16:42:34 1006 2147483648 2563607312 2645635072 212897600 9.019 20 11 22 0 237697056 23062704 1736752
16:43:35 236 2147483648 2558635296 2640474112 214258000 9.072 20 11 22 0 231140592 15303952 1578640
16:44:36 195 2147483648 2563789696 2646982656 216028144 9.140 20 16 33 0 236667696 17527760 3111792
16:45:38 511 2147483648 2570376208 2656321536 219143408 9.259 20 10 20 0 243606848 22909536 1553904
16:46:39 784 2147483648 2553056672 2634354688 214905520 9.096 20 10 20 0 225396272 9056416 1434336
16:47:40 261 2147483648 2555055984 2640969728 216645248 9.163 20 9 18 0 228524976 9988320 1891408
16:48:41 278 2147483648 2554314032 2639130624 214090544 9.065 20 9 14 3 227452432 12214768 1147120
16:49:42 626 2147483648 2556450096 2655850496 218869456 9.249 20 8 16 0 229256288 9234240 1152592
16:50:42 213 2147483648 2561962512 2644844544 217700000 9.204 20 11 22 0 234784928 15237424 1847504

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:16, from 04-11-2026 16:51:33 to 04-11-2026 16:51:49.

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:00, from 04-11-2026 16:51:50 to 04-11-2026 16:51:50.

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          186696
MON$OLDEST_ACTIVE               186960
MON$OLDEST_SNAPSHOT             186960
MON$NEXT_TRANSACTION            186960
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 13:00:11.1480 GMT
MON$PAGES                       126514
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                        {6CAAD4A0-2FC3-4762-B200-5142BE0BBA80}
MON$FILE_ID                     0108000000000000dded070000000000
MON$NEXT_ATTACHMENT             514
MON$NEXT_STATEMENT              54
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.8.3331 Firebird 4.0 HQbird
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.8.3331 Firebird 4.0 HQbird"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.8.3331 Firebird 4.0 HQbird/tcp (test-0)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.8.3331 Firebird 4.0 HQbird/tcp (test-0)/P17:C"
on disk structure version 13.0

Database statistics


Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation


Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
:6: 
:7: test-0    Wed Nov  4 16:50:59 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30400
:9: 
--- end of diff output ---

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

04.11.26 16:51:51. 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-04 16:51:53 No severe PSQL-related problems occured
04.11.26 16:51:53. End of report.