Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 06.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 6d
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 1918924 kB
MemAvailable 7183076 kB
Buffers 90252 kB
Cached 5260916 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-06 15:50:44
DTS_END                         2026-11-06 15:50:44.5610
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(95:17)
IP                              ::1/44206
TRN_ID                          197270
ATT_ID                          425
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: 12269.98 926 613499
customer order: creation 581.66 48 29083
customer order: refuse 46.82 51 2341
order to supplier: creation 147.60 213 7380
order to supplier: removal 11.30 7728 565
invoice (draft): creation 145.44 355 7272
invoice (draft): removal 101.20 132 5060
invoice accept: apply 125.42 1509 6271
invoice accept: cancel 84.68 199 4234
customer reserve: creation 5912.74 27 295637
customer reserve: removal 4234.42 15 211721
realization accept: apply 270.68 38 13534
realization accept: cancel 154.46 20 7723
payment from customer: creation 192.76 33 9638
payment from customer: removal 18.84 18 942
payment to supplier: creation 159.30 29 7965
payment to supplier: removal 11.24 19 562
service: total inventory turnovers 18.90 1791 945
service: total monetary turnovers 48.16 11 2408
service: aggregate perf. data 4.32 1493 216
service: refresh index statistics 0.04 4796 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 06-11-2026 15:51:00 to 06-11-2026 15:51:01.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6771
TEST_TIME 2 7870
TEST_TIME 3 8454
TEST_TIME 4 8375
TEST_TIME 5 8739
TEST_TIME 6 9129
TEST_TIME 7 9415
TEST_TIME 8 9534
TEST_TIME 9 9846
TEST_TIME 10 10156
TEST_TIME 11 10388
TEST_TIME 12 10576
TEST_TIME 13 10583
TEST_TIME 14 10805
TEST_TIME 15 10782
TEST_TIME 16 10916
TEST_TIME 17 11047
TEST_TIME 18 11064
TEST_TIME 19 11266
TEST_TIME 20 11372
TEST_TIME 21 11349
TEST_TIME 22 11464
TEST_TIME 23 11483
TEST_TIME 24 11588
TEST_TIME 25 11572
TEST_TIME 26 11532
TEST_TIME 27 11626
TEST_TIME 28 11732
TEST_TIME 29 11726
TEST_TIME 30 11756
TEST_TIME 31 11770
TEST_TIME 32 11870
TEST_TIME 33 11768
TEST_TIME 34 11846
TEST_TIME 35 11906
TEST_TIME 36 11999
TEST_TIME 37 12067
TEST_TIME 38 12042
TEST_TIME 39 12145
TEST_TIME 40 12215
TEST_TIME 41 12235
TEST_TIME 42 12257
TEST_TIME 43 12283
TEST_TIME 44 12222
TEST_TIME 45 12276
TEST_TIME 46 12278
TEST_TIME 47 12324
TEST_TIME 48 12374
TEST_TIME 49 12343
TEST_TIME 50 12270

Performance per minute, chart


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

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 907558 907558 0 0.00 0 3284 2 0 0
doc_list_biud 907558 907558 0 0.00 0 3316 5 0 0
sp_add_invoice_to_stock 6271 6271 0 0.00 6 17828 1509 0 0
sp_cancel_adding_invoice 4234 4234 0 0.00 3 5159 200 0 0
sp_cancel_client_order 2341 2341 0 0.00 2 1771 52 0 0
sp_cancel_customer_reserve 211721 211721 0 0.00 1 2266 15 0 0
sp_cancel_pay_from_customer 942 942 0 0.00 1 567 18 0 0
sp_cancel_pay_to_supplier 562 562 0 0.00 1 534 19 0 0
sp_cancel_supplier_invoice 5060 5060 0 0.00 1 2654 132 0 0
sp_cancel_supplier_order 565 565 0 0.00 5 57854 7729 0 0
sp_cancel_write_off 7723 7723 0 0.00 1 1714 20 0 0
sp_client_order 29083 29083 0 0.00 2 4362 48 0 0
sp_customer_reserve 295637 295637 0 0.00 0 6583 27 0 0
sp_fill_shopping_cart 43735 43735 0 0.00 0 2891 18 0 0
sp_fill_shopping_cart_clo_res 295637 295637 0 0.00 0 2179 2 0 0
sp_get_clo_for_invoice 6271 6271 0 0.00 0 1967 36 0 0
sp_kill_cost_storno 13461 13461 0 0.00 0 1064 9 0 0
sp_kill_qstorno_ret_qs2qd 436790 436790 0 0.00 0 3315 8 0 0
sp_kill_qty_storno 251449 251449 0 0.00 0 3315 17 0 0
sp_lock_selected_doc 27549 27549 0 0.00 0 808 1 0 0
sp_make_cost_storno 37408 37408 0 0.00 0 1055 7 0 0
sp_multiply_rows_for_pdistr 37408 37408 0 0.00 0 934 10 0 0
sp_multiply_rows_for_qdistr 29083 29083 0 0.00 0 1884 19 0 0
sp_pay_from_customer 9638 9638 0 0.00 2 1339 34 0 0
sp_pay_to_supplier 7965 7965 0 0.00 2 1426 29 0 0
sp_payment_common 17603 17603 0 0.00 0 1214 7 0 0
sp_qd_handle_on_cancel_clo 2341 2341 0 0.00 0 1747 37 0 0
sp_qd_handle_on_invoice_upd_sts 10505 10505 0 0.00 0 2617 63 0 0
sp_qd_handle_on_reserve_upd_sts 13534 13534 0 0.00 0 1584 12 0 0
sp_reserve_write_off 13534 13534 0 0.00 2 3292 38 0 0
sp_supplier_invoice 7272 7272 0 0.00 3 10089 355 0 0
sp_supplier_order 7380 7380 0 0.00 3 4441 213 0 0
srv_aggregate_perf_data 216 216 0 0.00 44 12442 1493 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 6 759 342 0 0
srv_find_qd_qs_mism 569950 569950 0 0.00 0 3284 1 0 0
srv_make_invnt_saldo 945 945 0 0.00 0 6126 1792 0 0
srv_make_money_saldo 2408 2408 0 0.00 0 339 11 0 0
srv_recalc_idx_stat 2 2 0 0.00 455 9138 4797 0 0
v_add_invoice_to_stock 12542 12542 0 0.00 0 1553 2 0 0
v_all_customers 44498 44498 0 0.00 0 103 0 0 0
v_all_suppliers 36090 36090 0 0.00 0 78 0 0 0
v_all_wares 58166 58166 0 0.00 0 106 0 0 0
v_cancel_adding_invoice 1126 1126 0 0.00 0 399 2 0 0
v_cancel_client_order 4682 4682 0 0.00 0 310 2 0 0
v_cancel_customer_prepayment 1884 1884 0 0.00 0 435 2 0 0
v_cancel_customer_reserve 1838 1838 0 0.00 0 1564 3 0 0
v_cancel_payment_to_supplier 1124 1124 0 0.00 0 198 2 0 0
v_cancel_supplier_invoice 1012 1012 0 0.00 0 661 4 0 0
v_cancel_supplier_order 1130 1130 0 0.00 0 858 3 0 0
v_cancel_write_off 2692 2692 0 0.00 0 778 3 0 0
v_max_id_clo_ord 7380 7380 0 0.00 0 221 1 0 0
v_max_id_clo_res 1333 1333 0 0.00 0 159 2 0 0
v_max_id_ord_sup 7272 7272 0 0.00 0 1300 2 0 0
v_max_non_paid_invoice 4572 4572 0 0.00 0 529 1 0 0
v_max_non_paid_realizn 9258 9258 0 0.00 0 65 1 0 0
v_min_id_clo_ord 7380 7380 0 0.00 0 1146 3 0 0
v_min_id_clo_res 1333 1333 0 0.00 0 609 4 0 0
v_min_id_ord_sup 7272 7272 0 0.00 0 1833 6 0 0
v_min_non_paid_invoice 7965 7965 0 0.00 0 526 2 0 0
v_min_non_paid_realizn 9638 9638 0 0.00 0 377 2 0 0
v_our_firm 14428 14428 0 0.00 0 93 1 0 0
v_reserve_write_off 27068 27068 0 0.00 0 1565 1 0 0
x_lock_depdocs_on_canc_invoice 8788 8788 0 0.00 0 1496 8 0 0
x_lock_depdocs_on_canc_sup_ord 565 565 0 0.00 0 223 9 0 0
x_make_qstorno_1000_1200 7380 7380 0 0.00 1 4248 163 0 0
x_make_qstorno_1200_2000 7272 7272 0 0.00 1 9998 311 0 0
x_make_qstorno_2100_3300 295637 295637 0 0.00 0 6582 23 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 06-11-2026 15:51:05 to 06-11-2026 15:51:09.

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:48 5 2147483648 2253167280 2255597568 4078656 0.189 1 1 2 0 4147712 60512 8544
15:01:50 401 2147483648 2522863200 2798100480 269029840 11.132 20 5 10 0 269562704 383232 149632
15:02:51 340 2147483648 2526480800 2775412736 272126752 11.246 20 6 12 0 273328320 949904 251664
15:03:52 459 2147483648 2500851680 2719842304 246402832 10.293 20 10 18 0 247409872 763296 243744
15:04:53 285 2147483648 2529088064 2776014848 273429888 11.294 20 10 20 0 275496144 1719712 346544
15:05:53 203 2147483648 2523245888 2769076224 267017344 11.058 20 11 23 1 269012384 1410544 584496
15:06:54 362 2147483648 2527939184 2777010176 270529392 11.188 20 9 17 1 273777632 2943296 304944
15:07:55 308 2147483648 2509838592 2732888064 255258416 10.623 20 9 18 0 257590688 1906880 425392
15:08:55 382 2147483648 2531787760 2777669632 272716128 11.268 20 8 17 0 278022304 4970096 336080
15:09:56 265 2147483648 2521040608 2763370496 262816736 10.903 20 11 22 0 267047744 3824000 407008
15:10:57 352 2147483648 2520901232 2756358144 263106624 10.914 20 7 14 0 266742880 3372832 263424
15:11:57 218 2147483648 2528138048 2780061696 270415920 11.183 20 7 13 0 274709648 4081536 212192
15:12:58 223 2147483648 2526562448 2771435520 269566192 11.152 20 6 12 1 272273312 2505888 201232
15:13:59 510 2147483648 2529132528 2772082688 271403728 11.220 20 5 10 0 274089120 2531776 153616
15:14:59 188 2147483648 2532914880 2779484160 268405376 11.110 20 15 27 0 275940608 7054496 480736
15:16:00 476 2147483648 2528923376 2765565952 261842432 10.867 20 11 22 0 273358224 11094816 420976
15:17:01 220 2147483648 2533217504 2784464896 271990864 11.241 20 7 14 0 279387856 7000304 396688
15:18:02 289 2147483648 2529843168 2772353024 269297296 11.142 20 5 10 0 275732320 6261328 173696
15:19:03 418 2147483648 2539188736 2789027840 270036256 11.169 20 6 12 0 287385296 17062912 286128
15:20:03 348 2147483648 2539257504 2782224384 269931168 11.166 20 11 22 0 284152656 13757664 463824
15:21:04 212 2147483648 2535382240 2786390016 274372288 11.329 20 14 28 0 279449328 4423776 653264
15:22:05 286 2147483648 2525069616 2767482880 267368704 11.071 20 5 9 0 271097424 3577776 150944
15:23:06 161 2147483648 2534963600 2773671936 270112848 11.172 20 11 22 0 279647392 9121856 412688
15:24:06 419 2147483648 2544487744 2788347904 270831056 11.199 20 11 22 0 286883216 15549264 502896
15:25:08 622 2147483648 2536822992 2782658560 273643424 11.302 20 10 20 0 281192144 7173984 374736
15:26:09 504 2147483648 2535801264 2777620480 269286384 11.142 20 10 18 1 279981312 10262752 432176
15:27:11 759 2147483648 2530232912 2764091392 259314240 10.774 20 6 12 0 271859936 12268560 277136
15:28:12 246 2147483648 2537374976 2787299328 270976160 11.204 20 10 20 0 290501664 19012000 513504
15:29:12 430 2147483648 2532496832 2779537408 273650800 11.302 20 11 22 0 277650816 3569824 430192
15:30:13 393 2147483648 2532918976 2760523776 268182640 11.101 20 9 18 0 278017728 9503200 331888
15:31:14 163 2147483648 2538054624 2777563136 270451360 11.185 20 10 20 0 283005584 12078912 475312
15:32:15 379 2147483648 2540990592 2802184192 270631536 11.191 20 8 17 2 285286896 14171104 484256
15:33:15 325 2147483648 2529635664 2772766720 265498208 11.002 20 8 16 1 274059616 8232416 328992
15:34:16 435 2147483648 2532207072 2774237184 263327344 10.922 20 8 16 0 274864816 11192848 344624
15:35:17 189 2147483648 2525943728 2765737984 264324176 10.959 20 13 26 0 270718368 5884928 509264
15:36:17 156 2147483648 2531018352 2776215552 268031568 11.096 20 3 6 0 275699344 7584784 82992
15:37:18 469 2147483648 2535760112 2776338432 268242464 11.104 20 10 20 0 279084576 10404192 437920
15:38:20 240 2147483648 2522963280 2769133568 264852880 10.979 20 5 10 1 268340112 3251728 235504
15:39:20 264 2147483648 2541448096 2783010816 268196528 11.102 20 12 24 0 285220096 16506560 517008
15:40:21 421 2147483648 2528692576 2765873152 262189184 10.880 20 12 24 0 271714880 9025632 500064
15:41:22 483 2147483648 2533642336 2769952768 263250016 10.919 20 9 18 0 276252896 12636256 366624
15:42:23 215 2147483648 2533612608 2774417408 266885408 11.054 20 10 19 0 277626256 10375136 365712
15:43:23 397 2147483648 2525230080 2770718720 262617312 10.896 20 9 17 0 270121600 7168160 336128
15:44:24 429 2147483648 2524468768 2764800000 260086608 10.802 20 12 23 0 268974960 8491728 396624
15:45:25 335 2147483648 2533416176 2785853440 266997808 11.058 20 6 12 0 278515376 11275360 242208
15:46:26 220 2147483648 2528403216 2772746240 268687408 11.120 20 9 18 0 275132512 6122144 322960
15:47:26 545 2147483648 2538416192 2786349056 270827792 11.199 20 9 18 0 282502704 11272512 402400
15:48:28 332 2147483648 2538767952 2776981504 262952112 10.908 20 11 22 0 282203728 18745712 505904
15:49:28 352 2147483648 2547502992 2789822464 263735904 10.937 20 11 22 0 290885984 26650192 499888
15:50:30 255 2147483648 2524716400 2757156864 250267216 10.437 19 8 16 0 268771184 18151328 352640

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 06-11-2026 15:51:10 to 06-11-2026 15:51:24.

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 06-11-2026 15:51:24 to 06-11-2026 15:51:25.

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          197413
MON$OLDEST_ACTIVE               197414
MON$OLDEST_SNAPSHOT             197414
MON$NEXT_TRANSACTION            197414
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-06 12:00:11.1060 GMT
MON$PAGES                       161432
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                                                                                                                                                                                      
MON$SEC_DATABASE                Default
MON$CRYPT_STATE                 0
MON$GUID                        {DC3C79A0-AD07-448B-9B99-83E30477B36A}
MON$FILE_ID                     0108000000000000c2ed070000000000
MON$NEXT_ATTACHMENT             545
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'

06.11.26 15:51:26. 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-06 15:51:26 No severe PSQL-related problems occured
06.11.26 15:51:27. End of report.