Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 05.11.2026 22: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 5d
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 1702108 kB
MemAvailable 7271504 kB
Buffers 89736 kB
Cached 5566872 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-05 22:51:02
DTS_END                         2026-11-05 22:51:02.2650
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/36406
TRN_ID                          177826
ATT_ID                          391
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: 10448.58 1043 522429
customer order: creation 522.20 59 26110
customer order: refuse 44.00 52 2200
order to supplier: creation 133.54 232 6677
order to supplier: removal 9.94 8253 497
invoice (draft): creation 133.48 388 6674
invoice (draft): removal 95.26 146 4763
invoice accept: apply 110.02 1622 5501
invoice accept: cancel 75.76 204 3788
customer reserve: creation 4924.84 30 246242
customer reserve: removal 3600.50 16 180025
realization accept: apply 244.98 45 12249
realization accept: cancel 144.32 22 7216
payment from customer: creation 172.00 42 8600
payment from customer: removal 16.46 23 823
payment to supplier: creation 146.46 36 7323
payment to supplier: removal 10.32 19 516
service: total inventory turnovers 17.40 1935 870
service: total monetary turnovers 43.08 13 2154
service: aggregate perf. data 3.98 1618 199
service: refresh index statistics 0.04 6101 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 05-11-2026 22:51:32 to 05-11-2026 22:51:33.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 11901
TEST_TIME 2 9739
TEST_TIME 3 9367
TEST_TIME 4 9124
TEST_TIME 5 9156
TEST_TIME 6 9103
TEST_TIME 7 8964
TEST_TIME 8 9080
TEST_TIME 9 9131
TEST_TIME 10 9280
TEST_TIME 11 9340
TEST_TIME 12 9544
TEST_TIME 13 9545
TEST_TIME 14 9630
TEST_TIME 15 9526
TEST_TIME 16 9660
TEST_TIME 17 9752
TEST_TIME 18 9754
TEST_TIME 19 9833
TEST_TIME 20 9834
TEST_TIME 21 9823
TEST_TIME 22 9921
TEST_TIME 23 9934
TEST_TIME 24 9945
TEST_TIME 25 9970
TEST_TIME 26 9986
TEST_TIME 27 10067
TEST_TIME 28 9976
TEST_TIME 29 10019
TEST_TIME 30 10086
TEST_TIME 31 10139
TEST_TIME 32 10167
TEST_TIME 33 10187
TEST_TIME 34 10318
TEST_TIME 35 10306
TEST_TIME 36 10312
TEST_TIME 37 10359
TEST_TIME 38 10349
TEST_TIME 39 10440
TEST_TIME 40 10373
TEST_TIME 41 10433
TEST_TIME 42 10452
TEST_TIME 43 10419
TEST_TIME 44 10498
TEST_TIME 45 10522
TEST_TIME 46 10511
TEST_TIME 47 10551
TEST_TIME 48 10575
TEST_TIME 49 10661
TEST_TIME 50 10449

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 05-11-2026 22:51:34 to 05-11-2026 22:51:37.

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 771503 771503 0 0.00 0 1898 3 0 0
doc_list_biud 771503 771503 0 0.00 0 4512 6 0 0
sp_add_invoice_to_stock 5501 5501 0 0.00 5 18465 1623 0 0
sp_cancel_adding_invoice 3788 3788 0 0.00 3 6318 205 0 0
sp_cancel_client_order 2200 2200 0 0.00 2 4521 53 0 0
sp_cancel_customer_reserve 180025 180025 0 0.00 1 3676 16 0 0
sp_cancel_pay_from_customer 823 823 0 0.00 2 775 23 0 0
sp_cancel_pay_to_supplier 516 516 0 0.00 2 287 19 0 0
sp_cancel_supplier_invoice 4763 4763 0 0.00 1 3487 147 0 0
sp_cancel_supplier_order 497 497 0 0.00 8 49156 8254 0 0
sp_cancel_write_off 7216 7216 0 0.00 1 1862 22 0 0
sp_client_order 26110 26110 0 0.00 3 2599 60 0 0
sp_customer_reserve 246242 246242 0 0.00 0 4002 31 0 0
sp_fill_shopping_cart 39461 39461 0 0.00 1 3312 22 0 0
sp_fill_shopping_cart_clo_res 246242 246242 0 0.00 0 2567 3 0 0
sp_get_clo_for_invoice 5501 5501 0 0.00 0 4575 37 0 0
sp_kill_cost_storno 12343 12343 0 0.00 0 974 11 0 0
sp_kill_qstorno_ret_qs2qd 372526 372526 0 0.00 0 3880 8 0 0
sp_kill_qty_storno 216239 216239 0 0.00 0 4512 19 0 0
sp_lock_selected_doc 24717 24717 0 0.00 0 433 2 0 0
sp_make_cost_storno 33673 33673 0 0.00 0 1100 8 0 0
sp_multiply_rows_for_pdistr 33673 33673 0 0.00 0 753 14 0 0
sp_multiply_rows_for_qdistr 26110 26110 0 0.00 0 2005 21 0 0
sp_pay_from_customer 8600 8600 0 0.00 3 1314 42 0 0
sp_pay_to_supplier 7323 7323 0 0.00 3 1324 37 0 0
sp_payment_common 15923 15923 0 0.00 1 655 8 0 0
sp_qd_handle_on_cancel_clo 2200 2200 0 0.00 0 4512 37 0 0
sp_qd_handle_on_invoice_upd_sts 9289 9289 0 0.00 0 2086 70 0 0
sp_qd_handle_on_reserve_upd_sts 12249 12249 0 0.00 0 2058 14 0 0
sp_reserve_write_off 12249 12249 0 0.00 3 2063 46 0 0
sp_supplier_invoice 6674 6674 0 0.00 5 7143 388 0 0
sp_supplier_order 6677 6677 0 0.00 4 3696 233 0 0
srv_aggregate_perf_data 199 199 0 0.00 90 13091 1619 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 13 1586 326 0 0
srv_find_qd_qs_mism 485240 485240 0 0.00 0 1894 2 0 0
srv_make_invnt_saldo 870 870 0 0.00 0 7267 1936 0 0
srv_make_money_saldo 2154 2154 0 0.00 0 422 14 0 0
srv_recalc_idx_stat 2 2 0 0.00 620 11583 6102 0 0
v_add_invoice_to_stock 11002 11002 0 0.00 0 1326 3 0 0
v_all_customers 39830 39830 0 0.00 0 63 1 0 0
v_all_suppliers 33230 33230 0 0.00 0 78 1 0 0
v_all_wares 52220 52220 0 0.00 0 60 1 0 0
v_cancel_adding_invoice 898 898 0 0.00 0 548 3 0 0
v_cancel_client_order 4400 4400 0 0.00 0 598 2 0 0
v_cancel_customer_prepayment 1646 1646 0 0.00 0 249 2 0 0
v_cancel_customer_reserve 1632 1632 0 0.00 0 745 2 0 0
v_cancel_payment_to_supplier 1032 1032 0 0.00 0 30 1 0 0
v_cancel_supplier_invoice 974 974 0 0.00 0 484 4 0 0
v_cancel_supplier_order 994 994 0 0.00 0 267 2 0 0
v_cancel_write_off 2358 2358 0 0.00 0 311 2 0 0
v_max_id_clo_ord 6677 6677 0 0.00 0 39 1 0 0
v_max_id_clo_res 1304 1304 0 0.00 0 305 2 0 0
v_max_id_ord_sup 6674 6674 0 0.00 0 1336 3 0 0
v_max_non_paid_invoice 4059 4059 0 0.00 0 49 1 0 0
v_max_non_paid_realizn 8299 8299 0 0.00 0 55 1 0 0
v_min_id_clo_ord 6677 6677 0 0.00 0 711 3 0 0
v_min_id_clo_res 1304 1304 0 0.00 0 853 7 0 0
v_min_id_ord_sup 6674 6674 0 0.00 0 1893 9 0 0
v_min_non_paid_invoice 7323 7323 0 0.00 0 649 3 0 0
v_min_non_paid_realizn 8600 8600 0 0.00 0 327 3 0 0
v_our_firm 12992 12992 0 0.00 0 82 1 0 0
v_reserve_write_off 24498 24498 0 0.00 0 874 2 0 0
x_lock_depdocs_on_canc_invoice 8064 8064 0 0.00 0 1654 9 0 0
x_lock_depdocs_on_canc_sup_ord 497 497 0 0.00 0 479 9 0 0
x_make_qstorno_1000_1200 6677 6677 0 0.00 1 3692 173 0 0
x_make_qstorno_1200_2000 6674 6674 0 0.00 1 6571 334 0 0
x_make_qstorno_2100_3300 246242 246242 0 0.00 0 3999 26 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 05-11-2026 22:51:38 to 05-11-2026 22:51:43.

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
22:01:07 13 2147483648 2309550144 2313269248 3168864 0.147 1 1 2 0 3266304 61664 35776
22:02:08 290 2147483648 2549605760 2630733824 222402752 9.384 20 12 26 0 225660096 1084496 2172848
22:03:08 159 2147483648 2538450880 2619060224 212322272 8.997 20 1 2 0 214162816 918336 922208
22:04:09 350 2147483648 2556963904 2638319616 223367216 9.421 20 12 25 0 230618096 5012704 2238176
22:05:10 351 2147483648 2540799632 2620653568 212568000 9.006 20 7 15 0 215193760 1349184 1276576
22:06:11 497 2147483648 2550818416 2631327744 221476672 9.349 20 12 24 1 225700112 1281984 2941456
22:07:12 341 2147483648 2543331728 2621046784 208490304 8.849 20 10 20 0 215629792 5615328 1524160
22:08:12 235 2147483648 2549881072 2633068544 221552736 9.352 20 6 12 0 225033344 2052960 1427648
22:09:13 370 2147483648 2535690704 2617692160 206549088 8.774 20 10 18 1 211022336 2911440 1561808
22:10:14 257 2147483648 2536616080 2619035648 211169232 8.952 20 5 8 1 213030144 719072 1141840
22:11:15 203 2147483648 2553178672 2636644352 217521824 9.197 20 10 18 0 228260144 8928512 1809808
22:12:15 224 2147483648 2542885424 2629496832 208552336 8.851 20 10 18 0 222547936 11489872 2505728
22:13:16 571 2147483648 2546956864 2629292032 214797600 9.092 20 8 14 1 220362976 4518560 1046816
22:14:17 171 2147483648 2553137104 2636709888 222574800 9.391 20 9 18 1 227149488 3281568 1293120
22:15:17 179 2147483648 2559937184 2644369408 215617376 9.124 20 9 18 0 234563184 17138368 1807440
22:16:18 153 2147483648 2533394192 2613129216 201471312 8.577 20 15 30 1 206756544 2715520 2569712
22:17:19 261 2147483648 2546840768 2628861952 212566688 9.006 20 10 19 0 219581392 5039728 1974976
22:18:19 267 2147483648 2550721264 2635014144 218965136 9.252 20 11 22 0 225384976 4537488 1882352
22:19:20 263 2147483648 2552024384 2633842688 215071824 9.103 20 11 22 0 225328880 8222560 2034496
22:20:21 186 2147483648 2549066512 2631237632 216640720 9.163 20 14 28 0 222802080 3866976 2294384
22:21:21 220 2147483648 2554989920 2635612160 216867808 9.172 20 12 24 0 228070592 9023264 2179520
22:22:22 455 2147483648 2539742672 2620702720 210002000 8.907 20 11 22 0 214179584 2303152 1874432
22:23:23 227 2147483648 2550213728 2632781824 216837616 9.171 20 10 20 0 223195968 4836064 1522288
22:24:24 822 2147483648 2549125680 2631049216 216639968 9.163 20 9 17 0 221929520 4048528 1241024
22:25:25 202 2147483648 2542819968 2625359872 210300768 8.919 20 5 10 0 217099184 5804880 993536
22:26:25 224 2147483648 2542219952 2624315392 210589888 8.930 20 10 20 0 216645648 4542352 1513408
22:27:26 588 2147483648 2530897968 2607493120 196283264 8.374 19 9 18 0 199511104 1832416 1395424
22:28:27 175 2147483648 2551373728 2635227136 214319984 9.074 20 7 14 1 226000416 10666384 1014048
22:29:27 229 2147483648 2540377536 2623463424 207110448 8.796 20 5 10 0 215282656 7403744 768464
22:30:28 722 2147483648 2554599248 2638303232 214334912 9.074 20 9 17 1 228727648 12977344 1415392
22:31:29 267 2147483648 2565974080 2648657920 222514608 9.388 20 14 29 0 237883040 13004560 2363872
22:32:30 455 2147483648 2556114160 2641674240 220677536 9.318 20 9 18 0 230635296 8341200 1616560
22:33:31 312 2147483648 2554362272 2645233664 215351584 9.114 20 7 14 0 228736368 12123808 1260976
22:34:31 446 2147483648 2544803488 2629226496 215265968 9.110 20 11 23 1 219049792 1868576 1915248
22:35:32 240 2147483648 2573776192 2658250752 218428592 9.232 20 13 26 0 246543024 26215408 1899024
22:36:33 153 2147483648 2547845600 2633469952 215755888 9.129 20 9 18 0 221193488 4035072 1402528
22:37:33 367 2147483648 2539040240 2621251584 201660096 8.584 19 10 20 0 212309376 8811888 1837392
22:38:34 301 2147483648 2557818832 2642804736 213388080 9.038 20 11 22 0 231500496 16396800 1715616
22:39:34 315 2147483648 2560233488 2647658496 215816816 9.132 20 10 18 0 235057344 17543184 1697344
22:40:35 139 2147483648 2557469520 2640760832 217092256 9.181 20 14 28 0 230495840 10978400 2425184
22:41:36 1586 2147483648 2535233200 2615959552 197784416 8.433 19 9 18 0 207140832 7893072 1463344
22:42:38 663 2147483648 2562693056 2653696000 214661456 9.087 20 10 20 0 235712000 19244160 1806384
22:43:39 149 2147483648 2560421968 2645635072 218360752 9.229 20 10 19 0 233763120 13747024 1655344
22:44:39 109 2147483648 2543154896 2629091328 214376240 9.076 20 7 12 0 217104800 1624192 1104368
22:45:40 119 2147483648 2564615904 2649321472 212420416 9.001 20 10 20 0 237777744 23670896 1686432
22:46:40 163 2147483648 2549127728 2635714560 214220672 9.070 20 10 20 0 222907504 6975248 1711584
22:47:40 202 2147483648 2548295712 2632777728 215447600 9.117 20 8 16 0 222017728 5069680 1500448
22:48:41 276 2147483648 2543389424 2628726784 209576336 8.891 20 7 14 0 216151840 5374384 1201120
22:49:41 362 2147483648 2563171840 2657148928 213228544 9.032 20 7 14 0 235955200 21423504 1303152
22:50:43 276 2147483648 2557553392 2644480000 216579968 9.161 20 12 24 1 229481984 11101680 1800336

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:15, from 05-11-2026 22:51:44 to 05-11-2026 22:51:59.

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 22:52:00 to 05-11-2026 22:52:01.

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          177974
MON$OLDEST_ACTIVE               177975
MON$OLDEST_SNAPSHOT             177975
MON$NEXT_TRANSACTION            177975
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-05 19:00:12.4200 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                        {7D5A04B7-1B37-4958-B8AD-2FE8D20EC70C}
MON$FILE_ID                     0108000000000000dded070000000000
MON$NEXT_ATTACHMENT             499
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    Thu Nov  5 22:51:06 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'

05.11.26 22:52:01. 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-05 22:52:03 No severe PSQL-related problems occured
05.11.26 22:52:04. End of report.