Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 11.11.2026 09: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 cc11645eec8340f48398c8a2eb858648
Product UUID de98ff4e-d959-45a6-974b-0c761b9e398f
Virtualization kvm
Operating System Debian GNU/Linux 13 (trixie)
Kernel Linux 6.12.116+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 4d
Command: who -b
bootup_info system boot 2026-11-09 10:54
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 8138016 kB
MemFree 2117764 kB
MemAvailable 7194388 kB
Buffers 79980 kB
Cached 5118484 kB
SwapCached 12 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-11 09:50:39
DTS_END                         2026-11-11 09:50:39.2940
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/49294
TRN_ID                          221124
ATT_ID                          469
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: 14843.60 914 742180
customer order: creation 661.26 42 33063
customer order: refuse 53.68 45 2684
order to supplier: creation 168.80 200 8440
order to supplier: removal 12.82 7985 641
invoice (draft): creation 165.96 360 8298
invoice (draft): removal 116.38 135 5819
invoice accept: apply 142.28 1403 7114
invoice accept: cancel 96.44 193 4822
customer reserve: creation 7286.40 23 364320
customer reserve: removal 5146.32 14 257316
realization accept: apply 306.00 33 15300
realization accept: cancel 176.46 18 8823
payment from customer: creation 220.82 32 11041
payment from customer: removal 19.84 16 992
payment to supplier: creation 178.24 29 8912
payment to supplier: removal 12.38 16 619
service: total inventory turnovers 21.76 1531 1088
service: total monetary turnovers 52.44 13 2622
service: aggregate perf. data 5.26 1673 263
service: refresh index statistics 0.06 4511 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 11-11-2026 09:50:53 to 11-11-2026 09:50:55.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 10475
TEST_TIME 2 11320
TEST_TIME 3 11189
TEST_TIME 4 11545
TEST_TIME 5 11619
TEST_TIME 6 12260
TEST_TIME 7 12661
TEST_TIME 8 12724
TEST_TIME 9 12980
TEST_TIME 10 13035
TEST_TIME 11 13307
TEST_TIME 12 13457
TEST_TIME 13 13405
TEST_TIME 14 13509
TEST_TIME 15 13518
TEST_TIME 16 13681
TEST_TIME 17 13732
TEST_TIME 18 13963
TEST_TIME 19 13973
TEST_TIME 20 14077
TEST_TIME 21 13916
TEST_TIME 22 14123
TEST_TIME 23 14150
TEST_TIME 24 14226
TEST_TIME 25 14116
TEST_TIME 26 14178
TEST_TIME 27 14163
TEST_TIME 28 14250
TEST_TIME 29 14338
TEST_TIME 30 14307
TEST_TIME 31 14350
TEST_TIME 32 14393
TEST_TIME 33 14466
TEST_TIME 34 14562
TEST_TIME 35 14602
TEST_TIME 36 14604
TEST_TIME 37 14686
TEST_TIME 38 14711
TEST_TIME 39 14737
TEST_TIME 40 14859
TEST_TIME 41 14932
TEST_TIME 42 14962
TEST_TIME 43 15028
TEST_TIME 44 14944
TEST_TIME 45 14917
TEST_TIME 46 14948
TEST_TIME 47 14931
TEST_TIME 48 14966
TEST_TIME 49 14927
TEST_TIME 50 14844

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 11-11-2026 09:50:55 to 11-11-2026 09:50:57.

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 1096999 1096999 0 0.00 0 1401 2 0 0
doc_list_biud 1096999 1096999 0 0.00 0 2077 5 0 0
sp_add_invoice_to_stock 7114 7114 0 0.00 4 12817 1403 0 0
sp_cancel_adding_invoice 4822 4822 0 0.00 3 4979 193 0 0
sp_cancel_client_order 2684 2684 0 0.00 2 976 46 0 0
sp_cancel_customer_reserve 257316 257316 0 0.00 1 2078 14 0 0
sp_cancel_pay_from_customer 992 992 0 0.00 1 337 17 0 0
sp_cancel_pay_to_supplier 619 619 0 0.00 1 491 16 0 0
sp_cancel_supplier_invoice 5819 5819 0 0.00 1 2014 135 0 0
sp_cancel_supplier_order 641 641 0 0.00 5 53594 7985 0 0
sp_cancel_write_off 8823 8823 0 0.00 1 919 18 0 0
sp_client_order 33063 33063 0 0.00 2 3273 43 0 0
sp_customer_reserve 364320 364320 0 0.00 0 4439 23 0 0
sp_fill_shopping_cart 49801 49801 0 0.00 0 3425 18 0 0
sp_fill_shopping_cart_clo_res 364320 364320 0 0.00 0 1165 2 0 0
sp_get_clo_for_invoice 7114 7114 0 0.00 0 2116 36 0 0
sp_kill_cost_storno 15256 15256 0 0.00 0 1317 9 0 0
sp_kill_qstorno_ret_qs2qd 529915 529915 0 0.00 0 2074 7 0 0
sp_kill_qty_storno 302519 302519 0 0.00 0 2077 17 0 0
sp_lock_selected_doc 31111 31111 0 0.00 0 717 1 0 0
sp_make_cost_storno 42367 42367 0 0.00 0 668 6 0 0
sp_multiply_rows_for_pdistr 42367 42367 0 0.00 0 779 10 0 0
sp_multiply_rows_for_qdistr 33063 33063 0 0.00 0 1180 17 0 0
sp_pay_from_customer 11041 11041 0 0.00 2 1153 32 0 0
sp_pay_to_supplier 8912 8912 0 0.00 2 822 30 0 0
sp_payment_common 19953 19953 0 0.00 0 716 8 0 0
sp_qd_handle_on_cancel_clo 2684 2684 0 0.00 0 972 32 0 0
sp_qd_handle_on_invoice_upd_sts 11936 11936 0 0.00 0 1899 66 0 0
sp_qd_handle_on_reserve_upd_sts 15300 15300 0 0.00 0 1482 10 0 0
sp_reserve_write_off 15300 15300 0 0.00 2 1486 33 0 0
sp_supplier_invoice 8298 8298 0 0.00 4 5772 360 0 0
sp_supplier_order 8440 8440 0 0.00 5 2749 200 0 0
srv_aggregate_perf_data 263 263 0 0.00 43 10375 1674 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 4 601 314 0 0
srv_find_qd_qs_mism 688977 688977 0 0.00 0 1400 1 0 0
srv_make_invnt_saldo 1088 1088 0 0.00 1 5551 1532 0 0
srv_make_money_saldo 2622 2622 0 0.00 0 368 13 0 0
srv_recalc_idx_stat 3 3 0 0.00 468 12257 4512 0 0
v_add_invoice_to_stock 14228 14228 0 0.00 0 664 2 0 0
v_all_customers 50764 50764 0 0.00 0 177 0 0 0
v_all_suppliers 41526 41526 0 0.00 0 77 0 0 0
v_all_wares 66126 66126 0 0.00 0 92 0 0 0
v_cancel_adding_invoice 1218 1218 0 0.00 0 227 2 0 0
v_cancel_client_order 5368 5368 0 0.00 0 475 1 0 0
v_cancel_customer_prepayment 1984 1984 0 0.00 0 205 2 0 0
v_cancel_customer_reserve 2090 2090 0 0.00 0 397 2 0 0
v_cancel_payment_to_supplier 1238 1238 0 0.00 0 83 1 0 0
v_cancel_supplier_invoice 1216 1216 0 0.00 0 680 3 0 0
v_cancel_supplier_order 1282 1282 0 0.00 0 360 2 0 0
v_cancel_write_off 2998 2998 0 0.00 0 473 3 0 0
v_max_id_clo_ord 8440 8440 0 0.00 0 397 1 0 0
v_max_id_clo_res 1575 1575 0 0.00 0 686 2 0 0
v_max_id_ord_sup 8298 8298 0 0.00 0 833 2 0 0
v_max_non_paid_invoice 4887 4887 0 0.00 0 45 1 0 0
v_max_non_paid_realizn 10592 10592 0 0.00 0 40 1 0 0
v_min_id_clo_ord 8440 8440 0 0.00 0 557 2 0 0
v_min_id_clo_res 1575 1575 0 0.00 0 846 5 0 0
v_min_id_ord_sup 8298 8298 0 0.00 0 2110 4 0 0
v_min_non_paid_invoice 8912 8912 0 0.00 0 432 5 0 0
v_min_non_paid_realizn 11041 11041 0 0.00 0 475 2 0 0
v_our_firm 16260 16260 0 0.00 0 50 1 0 0
v_reserve_write_off 30600 30600 0 0.00 0 771 1 0 0
x_lock_depdocs_on_canc_invoice 10033 10033 0 0.00 0 2613 9 0 0
x_lock_depdocs_on_canc_sup_ord 641 641 0 0.00 0 327 10 0 0
x_make_qstorno_1000_1200 8440 8440 0 0.00 1 2699 149 0 0
x_make_qstorno_1200_2000 8298 8298 0 0.00 1 5706 316 0 0
x_make_qstorno_2100_3300 364320 364320 0 0.00 0 4434 20 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 11-11-2026 09:50:57 to 11-11-2026 09:51:01.

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
09:00:42 3 2147483648 2253169168 2255597568 4080464 0.189 1 1 2 0 4149520 60512 8544
09:01:43 330 2147483648 2517319088 2789228544 264548992 10.967 20 4 8 0 266543744 1832384 162368
09:02:44 573 2147483648 2527369952 2777939968 269990592 11.168 20 7 14 0 272981152 2758096 232464
09:03:45 334 2147483648 2526762128 2767966208 271642912 11.228 20 12 25 0 273096016 1046336 406768
09:04:46 307 2147483648 2522087776 2759753728 262025312 10.874 20 13 26 0 267909456 5421664 462480
09:05:47 301 2147483648 2528252128 2772979712 272838512 11.272 20 10 20 0 274690944 1432320 420112
09:06:48 196 2147483648 2526552896 2768433152 265003904 10.984 20 8 16 0 272483984 7194240 285840
09:07:50 219 2147483648 2529841680 2775527424 269343968 11.144 20 10 20 0 274654624 4828800 481856
09:08:50 256 2147483648 2521901872 2760331264 256315216 10.662 19 15 30 0 265217024 8289072 612736
09:09:51 399 2147483648 2533823584 2786127872 273800416 11.308 20 8 15 0 278509984 4432864 276704
09:10:52 295 2147483648 2530778912 2777575424 270017504 11.169 20 9 16 1 275959632 5660416 281712
09:11:53 191 2147483648 2532211680 2770894848 269164112 11.137 20 14 29 0 276771872 6945664 662096
09:12:54 217 2147483648 2526218032 2782621696 270386320 11.182 20 3 6 0 272192384 1695824 110240
09:13:54 332 2147483648 2541403792 2783051776 267913392 11.091 20 12 24 0 283484704 15095264 476048
09:14:55 298 2147483648 2542373088 2786086912 272678256 11.266 20 12 24 0 287181616 13982176 521184
09:15:56 314 2147483648 2540647968 2780319744 266389936 11.035 20 15 29 0 286536480 19427632 718912
09:16:57 258 2147483648 2529087040 2780684288 270733744 11.195 20 9 17 0 275060592 4009200 317648
09:17:57 307 2147483648 2539918720 2793492480 271114528 11.209 20 14 27 1 283323584 11623520 585536
09:18:58 228 2147483648 2524934944 2768556032 266842128 11.052 20 11 21 1 270027984 2795440 390416
09:19:58 310 2147483648 2540261200 2789249024 270840864 11.199 20 11 21 0 283395296 12078592 475840
09:20:59 319 2147483648 2525059904 2766168064 263038736 10.912 20 11 23 0 268876960 5249392 588832
09:21:59 310 2147483648 2546085200 2795634688 270686912 11.193 20 7 14 0 291346192 20288960 370320
09:23:00 346 2147483648 2545223504 2794500096 274515712 11.334 20 13 26 0 288409120 13359056 534352
09:24:01 275 2147483648 2544984496 2799771648 274879056 11.347 20 14 28 0 288868928 13389200 600672
09:25:01 269 2147483648 2517912608 2746494976 255750928 10.641 20 11 22 0 262470112 6261152 458032
09:26:02 482 2147483648 2525309120 2767650816 267246784 11.067 20 8 16 0 270347056 2888400 211872
09:27:03 242 2147483648 2536289344 2789249024 272024352 11.242 20 11 21 0 280306624 7917728 364544
09:28:04 385 2147483648 2542007040 2775617536 264177856 10.954 20 10 20 0 285946016 21306016 462144
09:29:04 270 2147483648 2561667440 2807402496 276680864 11.413 20 12 24 0 305662464 28467664 513936
09:30:05 334 2147483648 2522759232 2756534272 248485536 10.370 20 12 23 0 267099984 18087264 527184
09:31:05 251 2147483648 2543992208 2794213376 271772368 11.233 20 4 8 0 288883968 16863744 247856
09:32:07 404 2147483648 2524347056 2763644928 265387504 10.998 20 5 10 0 268820688 3249680 183504
09:33:07 292 2147483648 2539626224 2785431552 251347552 10.477 19 11 21 0 273521824 21768832 405440
09:34:08 465 2147483648 2533787776 2780966912 267348448 11.071 20 11 21 2 277545488 9669200 527840
09:35:09 307 2147483648 2521603120 2756128768 252725040 10.529 19 10 20 0 265645280 12409792 510448
09:36:09 248 2147483648 2533523968 2777436160 265684064 11.009 20 11 22 1 276645296 10488208 473024
09:37:10 339 2147483648 2538706896 2784370688 265967456 11.020 20 9 17 0 283465328 17090992 406880
09:38:11 452 2147483648 2526331952 2755928064 250587936 10.449 19 9 19 0 268255680 17199328 468416
09:39:11 391 2147483648 2536071040 2781474816 267816560 11.088 20 12 24 0 280095408 11774256 504592
09:40:12 295 2147483648 2532994512 2768957440 259090432 10.765 20 10 20 1 277930544 18417552 422560
09:41:13 565 2147483648 2538935408 2779738112 264898880 10.980 20 8 16 0 281449840 16250880 300080
09:42:14 253 2147483648 2537012800 2783756288 270066400 11.171 20 11 22 0 282387408 11847104 473904
09:43:14 283 2147483648 2531467552 2780729344 266718176 11.047 20 10 17 2 275098816 8020560 360080
09:44:14 384 2147483648 2523264064 2756587520 260485952 10.817 20 9 17 0 267504432 6667216 351264
09:45:15 207 2147483648 2524258208 2753187840 256353952 10.664 20 10 20 0 267677776 10882736 441088
09:46:17 340 2147483648 2534201952 2770411520 261708320 10.862 20 9 18 0 279082768 16984608 389840
09:47:17 204 2147483648 2524960240 2764808192 263526880 10.930 20 5 10 0 269592848 5767360 298608
09:48:18 256 2147483648 2527230256 2760757248 260764880 10.827 20 13 26 0 272022960 10590096 667984
09:49:18 204 2147483648 2532464432 2775261184 264246832 10.956 20 8 16 0 277076272 12509200 320240
09:50:19 356 2147483648 2525233328 2751635456 252818624 10.532 20 12 24 0 269318208 16070160 429424

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:12, from 11-11-2026 09:51:01 to 11-11-2026 09:51:13.

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 11-11-2026 09:51:13 to 11-11-2026 09:51:14.

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          221123
MON$OLDEST_ACTIVE               223206
MON$OLDEST_SNAPSHOT             223206
MON$NEXT_TRANSACTION            223206
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-11 06:00:09.8060 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                        {BB0CBA84-6B29-49E6-A38C-34F55F79E889}
MON$FILE_ID                     0108000000000000c2ed070000000000
MON$NEXT_ATTACHMENT             588
MON$NEXT_STATEMENT              512
MON$REPLICA_MODE                0


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

11.11.26 09:51:14. 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-11 09:51:15 No severe PSQL-related problems occured
11.11.26 09:51:15. End of report.