Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 02.11.2026 03: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 1d
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 2158972 kB
MemAvailable 7147856 kB
Buffers 79928 kB
Cached 5036176 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
AllowUpdateOverwrite true true
AuditTraceConfigFile [empty] [empty]
AuthClient Srp256, Srp, gssauth, Legacy_Auth Srp256, Srp, gssauth, Legacy_Auth
AuthServer Srp256 Srp256
BlobTempSpace 0 0
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
DisableLogNetIOErrors true true
DummyPacketInterval 0 0
EnableMonDebug false false
EventMemSize 65536 65536
ExtConnPoolLifeTime 7200 7200
ExtConnPoolSize 0 0
ExternalFileAccess None None
FileSystemCacheSize 0 0
FileSystemCacheThreshold 65536 65536
FillMonCallStack true true
FillMonCompiledStatements true true
FillMonStatements true true
GCPolicy combined combined
GuardianOption 1 1
HQbirdVersionString true true
IPv6V6Only false false
InlineSortThreshold 1000 1000
IpcName oemul_hq50SS FirebirdIPI [ X ] firebird.conf
KeyHolderPlugin [empty] [empty]
LegacyHash true true
LegacyIntForCount false false
LegacyTimeLiterals false false
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
MaxStatementCacheSize 2097152 2097152
MaxTempBlobs 1000 1000
MaxUnflushedWriteTime -1 -1
MaxUnflushedWrites -1 -1
MaxUserTraceLogSize 10 10
MinDbCachePages 30000 30000
MonitoringPlugin [empty] [empty]
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 30500 0 [ X ] firebird.conf
SecurityDatabase /opt/hq50/security5.fdb /opt/hq50/security5.fdb
ServerMode Super Super [ X ] firebird.conf
SnapshotsMemSize 65536 65536
SqlSubstDirectory subst subst
StatementTimeout 0 0
SubQueryConversion 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
TraceAll false false
TraceDSQL 0 0
TracePlugin fbtrace fbtrace
UdfAccess Restrict UDF None [ X ] firebird.conf
UseFileSystemCache true true [ X ] firebird.conf
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-hq50.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-hq50.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/hq50/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=30500
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-hq50-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-hq50
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-02 03:51:00
DTS_END                         2026-11-02 03:51:00.0250
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/35392
TRN_ID                          225643
ATT_ID                          466
EXC_UNIT                        2


Test workload details

SETTING_NAME SETTING_VALUE
WORKING_MODE SMALL_03
C_WARES_MAX_ID 400
C_CUSTOMER_DOC_MAX_ROWS 10
C_SUPPLIER_DOC_MAX_ROWS 50
C_CUSTOMER_DOC_MAX_QTY 15
C_SUPPLIER_DOC_MAX_QTY 50
C_NUMBER_OF_AGENTS 1000

Indexes for heavy-loaded tables

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_ASC WORKER_ID,DOC_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_DEC WORKER_ID,DOC_ID
XQD_1200_2000 XQD_1200_2000_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID

Performance in TOTAL

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE
*** OVERALL *** for 50 minutes: 15194.50 991 759725
customer order: creation 668.08 40 33404
customer order: refuse 53.86 53 2693
order to supplier: creation 173.80 186 8690
order to supplier: removal 12.56 8681 628
invoice (draft): creation 167.66 328 8383
invoice (draft): removal 121.70 131 6085
invoice accept: apply 145.04 1385 7252
invoice accept: cancel 102.76 201 5138
customer reserve: creation 7301.64 23 365082
customer reserve: removal 5441.34 14 272067
realization accept: apply 311.72 33 15586
realization accept: cancel 179.20 17 8960
payment from customer: creation 218.12 31 10906
payment from customer: removal 21.82 17 1091
payment to supplier: creation 182.00 25 9100
payment to supplier: removal 12.96 16 648
service: total inventory turnovers 22.32 1485 1116
service: total monetary turnovers 53.50 14 2675
service: aggregate perf. data 4.38 1788 219
service: refresh index statistics 0.04 5361 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 02-11-2026 03:51:17 to 02-11-2026 03:51:18.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 18747
TEST_TIME 2 15523
TEST_TIME 3 14719
TEST_TIME 4 14589
TEST_TIME 5 14650
TEST_TIME 6 14598
TEST_TIME 7 14645
TEST_TIME 8 14664
TEST_TIME 9 14639
TEST_TIME 10 14612
TEST_TIME 11 14574
TEST_TIME 12 14502
TEST_TIME 13 14685
TEST_TIME 14 14858
TEST_TIME 15 14814
TEST_TIME 16 14714
TEST_TIME 17 14726
TEST_TIME 18 14651
TEST_TIME 19 14710
TEST_TIME 20 14594
TEST_TIME 21 14572
TEST_TIME 22 14611
TEST_TIME 23 14434
TEST_TIME 24 14463
TEST_TIME 25 14458
TEST_TIME 26 14539
TEST_TIME 27 14463
TEST_TIME 28 14479
TEST_TIME 29 14462
TEST_TIME 30 14462
TEST_TIME 31 14506
TEST_TIME 32 14543
TEST_TIME 33 14661
TEST_TIME 34 14652
TEST_TIME 35 14730
TEST_TIME 36 14840
TEST_TIME 37 14915
TEST_TIME 38 14900
TEST_TIME 39 14915
TEST_TIME 40 14966
TEST_TIME 41 15000
TEST_TIME 42 15062
TEST_TIME 43 15126
TEST_TIME 44 15263
TEST_TIME 45 15290
TEST_TIME 46 15314
TEST_TIME 47 15365
TEST_TIME 48 15394
TEST_TIME 49 15505

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 02-11-2026 03:51:18 to 02-11-2026 03:51:20.

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 1118368 1118368 0 0.00 0 1600 2 0 0
doc_list_biud 1118368 1118368 0 0.00 0 3748 5 0 0
sp_add_invoice_to_stock 7252 7252 0 0.00 4 13806 1385 0 0
sp_cancel_adding_invoice 5138 5138 0 0.00 2 7210 201 0 0
sp_cancel_client_order 2693 2693 0 0.00 2 2186 54 0 0
sp_cancel_customer_reserve 272067 272067 0 0.00 1 1640 15 0 0
sp_cancel_pay_from_customer 1091 1091 0 0.00 1 460 18 0 0
sp_cancel_pay_to_supplier 648 648 0 0.00 1 497 16 0 0
sp_cancel_supplier_invoice 6085 6085 0 0.00 1 2757 131 0 0
sp_cancel_supplier_order 628 628 0 0.00 6 61159 8682 0 0
sp_cancel_write_off 8960 8960 0 0.00 1 1230 18 0 0
sp_client_order 33404 33404 0 0.00 2 1675 40 0 0
sp_customer_reserve 365082 365082 0 0.00 0 2685 23 0 0
sp_fill_shopping_cart 50477 50477 0 0.00 0 2778 17 0 0
sp_fill_shopping_cart_clo_res 365082 365082 0 0.00 0 1227 2 0 0
sp_get_clo_for_invoice 7252 7252 0 0.00 0 2573 35 0 0
sp_kill_cost_storno 15837 15837 0 0.00 0 1009 9 0 0
sp_kill_qstorno_ret_qs2qd 559807 559807 0 0.00 0 3748 7 0 0
sp_kill_qty_storno 318409 318409 0 0.00 0 3748 17 0 0
sp_lock_selected_doc 31676 31676 0 0.00 0 666 1 0 0
sp_make_cost_storno 42844 42844 0 0.00 0 1253 7 0 0
sp_multiply_rows_for_pdistr 42844 42844 0 0.00 0 681 9 0 0
sp_multiply_rows_for_qdistr 33404 33404 0 0.00 0 1248 16 0 0
sp_pay_from_customer 10906 10906 0 0.00 2 1272 32 0 0
sp_pay_to_supplier 9100 9100 0 0.00 2 1261 25 0 0
sp_payment_common 20006 20006 0 0.00 0 860 6 0 0
sp_qd_handle_on_cancel_clo 2693 2693 0 0.00 0 2180 39 0 0
sp_qd_handle_on_invoice_upd_sts 12390 12390 0 0.00 0 2481 64 0 0
sp_qd_handle_on_reserve_upd_sts 15586 15586 0 0.00 0 1784 10 0 0
sp_reserve_write_off 15586 15586 0 0.00 2 1792 34 0 0
sp_supplier_invoice 8383 8383 0 0.00 4 6450 329 0 0
sp_supplier_order 8690 8690 0 0.00 4 2962 187 0 0
srv_aggregate_perf_data 219 219 0 0.00 13 8949 1789 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 4 628 317 0 0
srv_find_qd_qs_mism 707516 707516 0 0.00 0 1600 1 0 0
srv_make_invnt_saldo 1116 1116 0 0.00 1 4319 1485 0 0
srv_make_money_saldo 2675 2675 0 0.00 0 384 14 0 0
srv_recalc_idx_stat 2 2 0 0.00 1203 9520 5362 0 0
v_add_invoice_to_stock 14504 14504 0 0.00 0 592 2 0 0
v_all_customers 50574 50574 0 0.00 0 139 0 0 0
v_all_suppliers 41892 41892 0 0.00 0 99 0 0 0
v_all_wares 66808 66808 0 0.00 0 78 0 0 0
v_cancel_adding_invoice 1308 1308 0 0.00 0 61 2 0 0
v_cancel_client_order 5386 5386 0 0.00 0 475 1 0 0
v_cancel_customer_prepayment 2182 2182 0 0.00 0 282 2 0 0
v_cancel_customer_reserve 2044 2044 0 0.00 0 526 2 0 0
v_cancel_payment_to_supplier 1296 1296 0 0.00 0 295 2 0 0
v_cancel_supplier_invoice 1160 1160 0 0.00 0 430 3 0 0
v_cancel_supplier_order 1256 1256 0 0.00 0 143 2 0 0
v_cancel_write_off 3044 3044 0 0.00 0 379 2 0 0
v_max_id_clo_ord 8690 8690 0 0.00 0 453 1 0 0
v_max_id_clo_res 1523 1523 0 0.00 0 455 2 0 0
v_max_id_ord_sup 8383 8383 0 0.00 0 1016 1 0 0
v_max_non_paid_invoice 5227 5227 0 0.00 0 47 1 0 0
v_max_non_paid_realizn 10650 10650 0 0.00 0 68 1 0 0
v_min_id_clo_ord 8690 8690 0 0.00 0 475 2 0 0
v_min_id_clo_res 1523 1523 0 0.00 0 580 4 0 0
v_min_id_ord_sup 8383 8383 0 0.00 0 1006 3 0 0
v_min_non_paid_invoice 9100 9100 0 0.00 0 855 2 0 0
v_min_non_paid_realizn 10906 10906 0 0.00 0 301 2 0 0
v_our_firm 16746 16746 0 0.00 0 91 1 0 0
v_reserve_write_off 31172 31172 0 0.00 0 668 1 0 0
x_lock_depdocs_on_canc_invoice 10643 10643 0 0.00 0 1091 10 0 0
x_lock_depdocs_on_canc_sup_ord 628 628 0 0.00 0 185 10 0 0
x_make_qstorno_1000_1200 8690 8690 0 0.00 1 2917 136 0 0
x_make_qstorno_1200_2000 8383 8383 0 0.00 1 6217 291 0 0
x_make_qstorno_2100_3300 365082 365082 0 0.00 0 2683 20 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 02-11-2026 03:51:20 to 02-11-2026 03:51:24.

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
03:01:03 3 2147483648 2253167280 2255597568 4078656 0.189 1 1 2 0 4147712 60512 8544
03:02:05 354 2147483648 2510812272 2778951680 256039552 10.652 19 10 22 0 258562464 2224272 298640
03:03:06 227 2147483648 2529225664 2785587200 269614704 11.154 20 10 20 0 276581648 6664448 302496
03:04:07 433 2147483648 2528604672 2773467136 270730672 11.195 20 9 18 0 272973920 1760768 482480
03:05:07 289 2147483648 2519374064 2749718528 265634032 11.007 20 7 13 1 266312256 452928 225296
03:06:08 339 2147483648 2523299504 2763440128 265554032 11.004 20 13 26 0 268838096 2771920 512144
03:07:09 259 2147483648 2522725168 2751770624 264851568 10.979 20 9 18 0 267197344 1944736 401040
03:08:10 308 2147483648 2523869120 2765701120 266576480 11.042 20 14 27 1 268840656 1555264 708912
03:09:10 387 2147483648 2529881552 2760241152 262509584 10.892 20 9 18 1 274217392 11237872 469936
03:10:11 306 2147483648 2529781952 2767249408 265998544 11.021 20 12 26 1 274485968 7873168 614256
03:11:12 232 2147483648 2518237696 2752487424 256611072 10.673 19 10 20 0 263511904 6494240 406592
03:12:12 219 2147483648 2529443200 2772283392 269114704 11.136 20 12 23 1 274607632 4690912 802016
03:13:13 298 2147483648 2531915632 2773135360 271766928 11.233 20 14 28 1 274330544 2031600 532016
03:14:13 295 2147483648 2529099520 2773397504 269765520 11.160 20 12 24 0 274588768 4274064 549184
03:15:14 433 2147483648 2553823648 2801127424 273881920 11.311 20 10 20 1 296850944 22452576 516448
03:16:15 239 2147483648 2529643360 2767179776 267439088 11.074 20 13 26 0 276164080 8077184 647808
03:17:15 291 2147483648 2537284912 2784403456 275278416 11.362 20 14 28 0 284896240 9117936 499888
03:18:16 517 2147483648 2546016880 2792529920 273281344 11.289 20 13 26 0 290100496 16282128 537024
03:19:17 222 2147483648 2535777872 2778148864 269491104 11.149 20 11 22 0 280239648 10263984 484560
03:20:18 205 2147483648 2544489856 2789470208 268477904 11.112 20 12 24 0 284623456 15604208 541344
03:21:18 303 2147483648 2532218240 2774732800 271815168 11.235 20 14 28 0 277282656 4735104 732384
03:22:19 241 2147483648 2533574656 2785136640 274720832 11.341 20 8 17 0 278837184 3766000 350352
03:23:19 353 2147483648 2535759392 2784563200 270322864 11.180 20 11 22 0 282135056 11240448 571744
03:24:20 337 2147483648 2534609456 2779705344 271776160 11.233 20 13 26 0 278842176 6324272 741744
03:25:21 329 2147483648 2553087824 2797035520 274185744 11.322 20 10 20 0 295950384 21295920 468720
03:26:21 471 2147483648 2538618608 2780712960 269953664 11.166 20 12 24 0 283816160 13258304 604192
03:27:22 603 2147483648 2552474720 2800168960 275694368 11.377 20 8 16 0 298166976 22074464 398144
03:28:23 313 2147483648 2525146208 2760265728 258588368 10.747 19 14 26 0 268233312 8910000 734944
03:29:24 310 2147483648 2541839536 2784985088 269742736 11.159 20 11 22 0 284530976 14233024 555216
03:30:25 419 2147483648 2538807648 2780549120 272100416 11.245 20 13 26 0 283199264 10347296 751552
03:31:26 369 2147483648 2536703040 2766745600 269556688 11.152 20 10 20 1 279521088 9515392 449008
03:32:27 252 2147483648 2550793600 2799874048 277466272 11.442 20 12 24 0 294479568 16487040 526256
03:33:28 433 2147483648 2527426816 2761388032 259473728 10.780 20 14 28 0 270915376 10759232 682416
03:34:29 338 2147483648 2540445520 2775400448 266550336 11.041 20 9 18 0 284616896 17675136 391424
03:35:30 360 2147483648 2529584640 2775310336 263791984 10.939 20 14 28 6 273661152 9261024 608144
03:36:32 238 2147483648 2526465024 2774835200 264381328 10.961 20 10 20 1 271388992 6598368 409296
03:37:33 286 2147483648 2548420512 2790969344 271851856 11.236 20 14 28 0 292198880 19695568 651456
03:38:34 307 2147483648 2527479968 2775322624 266467088 11.038 20 14 27 0 271589504 4605632 516784
03:39:34 168 2147483648 2533335600 2784280576 265983824 11.020 20 11 22 0 277555712 11026608 545280
03:40:34 210 2147483648 2530161792 2774339584 265808272 11.014 20 10 20 0 275009184 8760976 439936
03:41:35 210 2147483648 2526031072 2761314304 260834224 10.830 20 12 24 1 269852496 8513104 505168
03:42:36 333 2147483648 2544046288 2787307520 266273104 11.031 20 11 23 0 287444896 20695168 476624
03:43:36 291 2147483648 2533267376 2771329024 262137360 10.878 20 9 18 0 276512864 13938240 437264
03:44:37 241 2147483648 2550821920 2805207040 268312944 11.106 20 6 12 0 297267888 28567024 387920
03:45:38 304 2147483648 2540115312 2779209728 256297376 10.662 20 12 23 1 283597168 26506704 793088
03:46:38 412 2147483648 2525650816 2771451904 264455216 10.964 20 8 16 0 271070224 6316096 298912
03:47:39 370 2147483648 2544082240 2793758720 267454288 11.074 20 11 22 0 287705024 19642944 607792
03:48:40 313 2147483648 2516603408 2744451072 248005008 10.353 19 9 18 0 260068400 11703504 359888
03:49:40 264 2147483648 2540941040 2783031296 266617856 11.044 20 14 28 0 284335408 16935680 781872
03:50:41 430 2147483648 2551185392 2795761664 269124512 11.136 20 10 20 0 294728608 25054416 549680

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:12, from 02-11-2026 03:51:24 to 02-11-2026 03:51:36.

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 02-11-2026 03:51:36 to 02-11-2026 03:51:37.

Content of mon$database and FB version


MON$DATABASE_NAME               /var/db/oltp-emul/oltp-hq50.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   1
MON$OLDEST_TRANSACTION          225951
MON$OLDEST_ACTIVE               225952
MON$OLDEST_SNAPSHOT             225952
MON$NEXT_TRANSACTION            225952
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-02 00:00:11.9280 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                        {83A913B8-7EF8-49D9-BCCF-64C3D4846254}
MON$FILE_ID                     0108000000000000c2ed070000000000
MON$NEXT_ATTACHMENT             594
MON$NEXT_STATEMENT              512
MON$REPLICA_MODE                0


ISQL Version: LI-V5.0.5.1916 Firebird 5.0 HQbird
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V5.0.5.1916 Firebird 5.0 HQbird"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V5.0.5.1916 Firebird 5.0 HQbird/tcp (test-0)/P19:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V5.0.5.1916 Firebird 5.0 HQbird/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 ---
--- end of diff output ---

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

02.11.26 03:51:37. There are 3 logs in /var/tmp/logs.oltp-hq50 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-02 03:51:38 No severe PSQL-related problems occured
02.11.26 03:51:38. End of report.