Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 08.11.2026 15:50
Common Performance Final Results
  1. Hardware and OS info
  2. Firebird configuration
  3. Test configuration
  4. Test Finish details
  5. Test workload details
  6. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score:    as table     as chart
  2. Performance per MINUTE, during test_time phase:    as table     as chart
  3. External connections pool: DISABLED. Test config parameter 'use_es' must be 2; ExtConnPoolSize must be ^> 0.
  4. Performance, DETAILS per units
  5. Memory consumption, metadata cache, attachments activity    as table    as chart
  6. Monitoring data: STATEMENTS activity, as chart
  7. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database statistics was not gathered. Change config parameter 'run_db_statistics' to 1.
  3. Database validation was not performed. Change config parameter 'run_db_validation' to 1.
  4. New in firebird.log while test was run
  5. Final processing of ISQL logs

Hardware and OS info

Command: hostnamectl
Static hostname test-0
Icon name computer-vm
Chassis vm 🖴
Machine ID de98ff4ed95945a6974b0c761b9e398f
Boot ID 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 1w 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 2035864 kB
MemAvailable 7181444 kB
Buffers 91696 kB
Cached 5137100 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-08 15:50:42
DTS_END                         2026-11-08 15:50:42.4890
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(211:18) ==> SP_CANCEL_CUSTOMER_RESERVE(55:5) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(95:17)
IP                              ::1/43662
TRN_ID                          214248
ATT_ID                          459
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: 13825.54 912 691277
customer order: creation 633.00 44 31650
customer order: refuse 52.40 54 2620
order to supplier: creation 159.34 199 7967
order to supplier: removal 11.78 8943 589
invoice (draft): creation 160.76 336 8038
invoice (draft): removal 115.08 133 5754
invoice accept: apply 140.34 1391 7017
invoice accept: cancel 97.56 201 4878
customer reserve: creation 6567.80 25 328390
customer reserve: removal 4939.62 15 246981
realization accept: apply 295.42 33 14771
realization accept: cancel 161.62 18 8081
payment from customer: creation 210.34 33 10517
payment from customer: removal 18.76 19 938
payment to supplier: creation 171.90 26 8595
payment to supplier: removal 11.96 17 598
service: total inventory turnovers 21.28 1589 1064
service: total monetary turnovers 51.92 13 2596
service: aggregate perf. data 4.60 1658 230
service: refresh index statistics 0.06 3493 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 08-11-2026 15:50:58 to 08-11-2026 15:50:59.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7645
TEST_TIME 2 8276
TEST_TIME 3 8738
TEST_TIME 4 9454
TEST_TIME 5 9875
TEST_TIME 6 10099
TEST_TIME 7 10375
TEST_TIME 8 10720
TEST_TIME 9 11024
TEST_TIME 10 11210
TEST_TIME 11 11441
TEST_TIME 12 11574
TEST_TIME 13 11766
TEST_TIME 14 11878
TEST_TIME 15 11893
TEST_TIME 16 12297
TEST_TIME 17 12205
TEST_TIME 18 12305
TEST_TIME 19 12417
TEST_TIME 20 12378
TEST_TIME 21 12551
TEST_TIME 22 12527
TEST_TIME 23 12653
TEST_TIME 24 12649
TEST_TIME 25 12755
TEST_TIME 26 12704
TEST_TIME 27 12767
TEST_TIME 28 12803
TEST_TIME 29 12820
TEST_TIME 30 12845
TEST_TIME 31 12897
TEST_TIME 32 12944
TEST_TIME 33 13049
TEST_TIME 34 13111
TEST_TIME 35 13110
TEST_TIME 36 13263
TEST_TIME 37 13301
TEST_TIME 38 13343
TEST_TIME 39 13357
TEST_TIME 40 13424
TEST_TIME 41 13512
TEST_TIME 42 13579
TEST_TIME 43 13573
TEST_TIME 44 13610
TEST_TIME 45 13621
TEST_TIME 46 13714
TEST_TIME 47 13768
TEST_TIME 48 13785
TEST_TIME 49 13882
TEST_TIME 50 13826

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 08-11-2026 15:51:00 to 08-11-2026 15:51:02.

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 1018715 1018715 0 0.00 0 1385 2 0 0
doc_list_biud 1018715 1018715 0 0.00 0 2375 5 0 0
sp_add_invoice_to_stock 7017 7017 0 0.00 6 14019 1392 0 0
sp_cancel_adding_invoice 4878 4878 0 0.00 2 4235 201 0 0
sp_cancel_client_order 2620 2620 0 0.00 2 1450 55 0 0
sp_cancel_customer_reserve 246981 246981 0 0.00 1 2364 16 0 0
sp_cancel_pay_from_customer 938 938 0 0.00 1 362 19 0 0
sp_cancel_pay_to_supplier 598 598 0 0.00 1 205 17 0 0
sp_cancel_supplier_invoice 5754 5754 0 0.00 2 1545 134 0 0
sp_cancel_supplier_order 589 589 0 0.00 7 47945 8943 0 0
sp_cancel_write_off 8081 8081 0 0.00 1 819 19 0 0
sp_client_order 31650 31650 0 0.00 3 2472 44 0 0
sp_customer_reserve 328390 328390 0 0.00 0 2904 25 0 0
sp_fill_shopping_cart 47655 47655 0 0.00 0 3756 17 0 0
sp_fill_shopping_cart_clo_res 328390 328390 0 0.00 0 1492 2 0 0
sp_get_clo_for_invoice 7017 7017 0 0.00 0 2221 35 0 0
sp_kill_cost_storno 14495 14495 0 0.00 0 810 9 0 0
sp_kill_qstorno_ret_qs2qd 508386 508386 0 0.00 0 2360 8 0 0
sp_kill_qty_storno 290691 290691 0 0.00 0 2375 18 0 0
sp_lock_selected_doc 30150 30150 0 0.00 0 1324 1 0 0
sp_make_cost_storno 40900 40900 0 0.00 0 1000 7 0 0
sp_multiply_rows_for_pdistr 40900 40900 0 0.00 0 857 9 0 0
sp_multiply_rows_for_qdistr 31650 31650 0 0.00 0 1589 18 0 0
sp_pay_from_customer 10517 10517 0 0.00 2 1525 33 0 0
sp_pay_to_supplier 8595 8595 0 0.00 2 1003 27 0 0
sp_payment_common 19112 19112 0 0.00 0 951 6 0 0
sp_qd_handle_on_cancel_clo 2620 2620 0 0.00 0 1431 40 0 0
sp_qd_handle_on_invoice_upd_sts 11895 11895 0 0.00 0 2375 65 0 0
sp_qd_handle_on_reserve_upd_sts 14771 14771 0 0.00 0 1195 10 0 0
sp_reserve_write_off 14771 14771 0 0.00 2 1395 34 0 0
sp_supplier_invoice 8038 8038 0 0.00 4 6505 336 0 0
sp_supplier_order 7967 7967 0 0.00 4 2996 200 0 0
srv_aggregate_perf_data 230 230 0 0.00 102 7474 1658 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 8 690 353 0 0
srv_find_qd_qs_mism 644379 644379 0 0.00 0 1385 1 0 0
srv_make_invnt_saldo 1064 1064 0 0.00 0 5258 1590 0 0
srv_make_money_saldo 2596 2596 0 0.00 0 336 13 0 0
srv_recalc_idx_stat 3 3 0 0.00 447 9538 3493 0 0
v_add_invoice_to_stock 14034 14034 0 0.00 0 496 2 0 0
v_all_customers 48118 48118 0 0.00 0 63 0 0 0
v_all_suppliers 39068 39068 0 0.00 0 152 0 0 0
v_all_wares 63300 63300 0 0.00 0 76 0 0 0
v_cancel_adding_invoice 1214 1214 0 0.00 0 222 2 0 0
v_cancel_client_order 5240 5240 0 0.00 0 409 1 0 0
v_cancel_customer_prepayment 1876 1876 0 0.00 0 295 2 0 0
v_cancel_customer_reserve 2052 2052 0 0.00 0 725 2 0 0
v_cancel_payment_to_supplier 1196 1196 0 0.00 0 183 2 0 0
v_cancel_supplier_invoice 1046 1046 0 0.00 0 322 3 0 0
v_cancel_supplier_order 1178 1178 0 0.00 0 1259 3 0 0
v_cancel_write_off 2922 2922 0 0.00 0 491 2 0 0
v_max_id_clo_ord 7967 7967 0 0.00 0 211 1 0 0
v_max_id_clo_res 1525 1525 0 0.00 0 395 2 0 0
v_max_id_ord_sup 8038 8038 0 0.00 0 920 2 0 0
v_max_non_paid_invoice 5066 5066 0 0.00 0 430 1 0 0
v_max_non_paid_realizn 10190 10190 0 0.00 0 63 1 0 0
v_min_id_clo_ord 7967 7967 0 0.00 0 388 2 0 0
v_min_id_clo_res 1525 1525 0 0.00 0 822 5 0 0
v_min_id_ord_sup 8038 8038 0 0.00 0 1207 4 0 0
v_min_non_paid_invoice 8595 8595 0 0.00 0 727 2 0 0
v_min_non_paid_realizn 10517 10517 0 0.00 0 427 2 0 0
v_our_firm 15836 15836 0 0.00 0 36 1 0 0
v_reserve_write_off 29542 29542 0 0.00 0 1352 1 0 0
x_lock_depdocs_on_canc_invoice 10109 10109 0 0.00 0 1668 9 0 0
x_lock_depdocs_on_canc_sup_ord 589 589 0 0.00 0 296 11 0 0
x_make_qstorno_1000_1200 7967 7967 0 0.00 1 2825 151 0 0
x_make_qstorno_1200_2000 8038 8038 0 0.00 1 6470 294 0 0
x_make_qstorno_2100_3300 328390 328390 0 0.00 0 2904 22 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 08-11-2026 15:51:02 to 08-11-2026 15:51:07.

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
15:00:46 7 2147483648 2253167280 2255597568 4078656 0.189 1 1 2 0 4147712 60512 8544
15:01:47 377 2147483648 2521226224 2794483712 267431104 11.074 20 10 20 0 268786224 1011920 343200
15:02:48 393 2147483648 2523444752 2772344832 268787568 11.124 20 8 15 1 270306800 1090096 429136
15:03:50 471 2147483648 2524999056 2760810496 267615040 11.080 20 9 18 0 272349360 4308336 425984
15:04:51 421 2147483648 2524449088 2775441408 268608624 11.117 20 9 19 0 270052672 1096848 347200
15:05:52 373 2147483648 2527324800 2770542592 271036464 11.206 20 10 19 0 273449840 2094416 318960
15:06:53 524 2147483648 2519473376 2751066112 257190992 10.695 20 11 20 0 259532960 2060560 281408
15:07:54 592 2147483648 2529946880 2775908352 271816992 11.235 20 12 25 0 276353904 4043488 493424
15:08:55 305 2147483648 2502326576 2711945216 238117168 9.981 20 7 15 0 246458768 7973280 368320
15:09:55 340 2147483648 2528622336 2766934016 267967056 11.093 20 12 23 1 273367472 4904576 495840
15:10:56 359 2147483648 2531742048 2769682432 266608096 11.043 20 12 22 1 276350704 9292624 449984
15:11:57 288 2147483648 2534618384 2773008384 271033360 11.206 20 6 12 0 280039696 8686448 319888
15:12:58 342 2147483648 2534365872 2771501056 266922896 11.055 20 17 32 2 278116176 10514528 678752
15:13:58 272 2147483648 2529297568 2768220160 266955008 11.056 20 7 14 0 274284400 7043136 286256
15:14:59 255 2147483648 2534127808 2770341888 269235904 11.140 20 9 18 0 277497728 7922352 339472
15:15:59 478 2147483648 2557935152 2797207552 272414064 11.257 20 10 20 0 303218400 30188224 616112
15:17:00 308 2147483648 2519672624 2744254464 256423920 10.666 20 13 25 0 264116976 7284160 408896
15:18:02 454 2147483648 2536383056 2773938176 266019104 11.022 20 8 15 0 282247328 15804976 423248
15:19:03 223 2147483648 2508803104 2727632896 241709856 10.116 19 7 13 0 250491536 8524560 257120
15:20:03 289 2147483648 2538476256 2783059968 272250848 11.251 20 10 19 0 281672304 9035536 385920
15:21:03 303 2147483648 2537227792 2789335040 270503264 11.187 20 9 19 0 282133056 11176752 453040
15:22:04 690 2147483648 2524787424 2766893056 268129408 11.099 20 5 10 0 270899968 2554528 216032
15:23:06 318 2147483648 2541878928 2786566144 272871648 11.274 20 15 29 0 284283088 10750256 661184
15:24:08 271 2147483648 2536902864 2780237824 271677552 11.230 20 8 15 0 281799312 9901680 220080
15:25:09 329 2147483648 2553212048 2799861760 273598880 11.300 20 13 27 0 297217936 23014448 604608
15:26:11 412 2147483648 2529151024 2757189632 263736608 10.937 20 13 26 0 272367088 8120224 510256
15:27:11 374 2147483648 2543798784 2784727040 271402208 11.220 20 13 25 0 287776496 15842128 532160
15:28:12 277 2147483648 2540472944 2781511680 269986368 11.168 20 13 26 0 284585136 14009584 589184
15:29:13 310 2147483648 2531417776 2769231872 265099728 10.988 20 9 17 0 276617072 11166416 350928
15:30:14 378 2147483648 2540499936 2759290880 267582096 11.079 20 12 24 0 284564720 16506512 476112
15:31:16 256 2147483648 2566656000 2816499712 281667728 11.595 20 15 29 0 311615664 29279264 668672
15:32:16 251 2147483648 2531771728 2774855680 261457072 10.853 19 7 14 0 275356752 13655264 244416
15:33:17 332 2147483648 2550502944 2795520000 268603920 11.117 20 7 14 0 294187024 25259568 323536
15:34:17 289 2147483648 2521039264 2755063808 259257904 10.772 20 8 16 1 265316688 5648256 410528
15:35:18 376 2147483648 2520236368 2763780096 263435232 10.926 20 12 24 0 266561072 2718720 407120
15:36:19 335 2147483648 2545518720 2790162432 263765120 10.938 20 11 22 0 288716768 24365104 586544
15:37:19 383 2147483648 2528026832 2776813568 265359904 10.997 20 9 17 0 272342896 6624352 358640
15:38:20 194 2147483648 2532715952 2778804224 265393456 10.999 20 11 22 0 277557424 11655232 508736
15:39:20 403 2147483648 2534027296 2778116096 264180048 10.954 20 13 26 0 276502432 11802976 519408
15:40:21 325 2147483648 2531966784 2774614016 266224160 11.029 20 10 19 1 275809712 9199136 386416
15:41:22 335 2147483648 2529011088 2774872064 268469440 11.112 20 11 22 0 273634464 4778720 386304
15:42:23 274 2147483648 2548772512 2809352192 271003680 11.205 20 10 20 0 294783904 23243552 536672
15:43:24 365 2147483648 2516582832 2756116480 252055440 10.504 20 5 9 0 258528176 6253536 219200
15:44:24 317 2147483648 2546988192 2794012672 263742032 10.938 20 10 21 1 292275104 27978240 554832
15:45:25 467 2147483648 2532698320 2784747520 270273472 11.178 20 8 16 0 276132912 5622160 237280
15:46:26 325 2147483648 2529084848 2782998528 257102736 10.692 19 8 16 0 274211472 16750528 358208
15:47:26 445 2147483648 2538760640 2788626432 264273296 10.957 20 8 16 0 289506608 24822160 411152
15:48:28 289 2147483648 2536835984 2787422208 266265392 11.031 20 14 28 0 278807248 11948112 593744
15:49:30 297 2147483648 2541725520 2791968768 266818112 11.051 20 11 22 0 285103072 17824896 460064
15:50:30 455 2147483648 2533578896 2783416320 269793808 11.161 20 12 24 1 277548384 7269792 484784

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:11, from 08-11-2026 15:51:07 to 08-11-2026 15:51:18.

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

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          214247
MON$OLDEST_ACTIVE               215039
MON$OLDEST_SNAPSHOT             215039
MON$NEXT_TRANSACTION            215039
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-08 12:00:10.9170 GMT
MON$PAGES                       171564
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                        {23F47C03-92F3-4F4B-8DD7-E36A465D5B70}
MON$FILE_ID                     0108000000000000c2ed070000000000
MON$NEXT_ATTACHMENT             573
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'

08.11.26 15:51:19. 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-08 15:51:20 No severe PSQL-related problems occured
08.11.26 15:51:20. End of report.