Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 14.11.2026 03: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 6d
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 2297828 kB
MemAvailable 7174788 kB
Buffers 81372 kB
Cached 4913408 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-14 03:50:33
DTS_END                         2026-11-14 03:50:33.7000
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/56474
TRN_ID                          245927
ATT_ID                          503
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: 16392.64 971 819632
customer order: creation 728.78 35 36439
customer order: refuse 59.46 55 2973
order to supplier: creation 183.96 173 9198
order to supplier: removal 12.80 8430 640
invoice (draft): creation 186.10 302 9305
invoice (draft): removal 132.34 124 6617
invoice accept: apply 158.52 1256 7926
invoice accept: cancel 109.96 196 5498
customer reserve: creation 7864.90 21 393245
customer reserve: removal 5858.30 14 292915
realization accept: apply 338.12 30 16906
realization accept: cancel 191.32 16 9566
payment from customer: creation 242.80 30 12140
payment from customer: removal 23.44 15 1172
payment to supplier: creation 197.52 23 9876
payment to supplier: removal 13.14 16 657
service: total inventory turnovers 26.78 1228 1339
service: total monetary turnovers 58.04 12 2902
service: aggregate perf. data 6.32 1405 316
service: refresh index statistics 0.04 6035 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 14-11-2026 03:50:44 to 14-11-2026 03:50:45.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 16923
TEST_TIME 2 15888
TEST_TIME 3 15997
TEST_TIME 4 15872
TEST_TIME 5 16167
TEST_TIME 6 16037
TEST_TIME 7 16072
TEST_TIME 8 16034
TEST_TIME 9 16102
TEST_TIME 10 15979
TEST_TIME 11 15959
TEST_TIME 12 15901
TEST_TIME 13 15968
TEST_TIME 14 16012
TEST_TIME 15 16001
TEST_TIME 16 15976
TEST_TIME 17 16010
TEST_TIME 18 15996
TEST_TIME 19 15950
TEST_TIME 20 15954
TEST_TIME 21 15910
TEST_TIME 22 15891
TEST_TIME 23 15837
TEST_TIME 24 15883
TEST_TIME 25 15816
TEST_TIME 26 15715
TEST_TIME 27 15740
TEST_TIME 28 15748
TEST_TIME 29 15663
TEST_TIME 30 15646
TEST_TIME 31 15590
TEST_TIME 32 15786
TEST_TIME 33 15769
TEST_TIME 34 15950
TEST_TIME 35 15922
TEST_TIME 36 15993
TEST_TIME 37 16099
TEST_TIME 38 16142
TEST_TIME 39 16143
TEST_TIME 40 16130
TEST_TIME 41 16285
TEST_TIME 42 16323
TEST_TIME 43 16379
TEST_TIME 44 16433
TEST_TIME 45 16391
TEST_TIME 46 16453
TEST_TIME 47 16422
TEST_TIME 48 16528
TEST_TIME 49 16488
TEST_TIME 50 16393

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 14-11-2026 03:50:46 to 14-11-2026 03:50:48.

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 1210826 1210826 0 0.00 0 942 2 0 0
doc_list_biud 1210826 1210826 0 0.00 0 2234 5 0 0
sp_add_invoice_to_stock 7926 7926 0 0.00 6 13373 1256 0 0
sp_cancel_adding_invoice 5498 5498 0 0.00 3 6510 197 0 0
sp_cancel_client_order 2973 2973 0 0.00 2 2090 56 0 0
sp_cancel_customer_reserve 292915 292915 0 0.00 1 2235 14 0 0
sp_cancel_pay_from_customer 1172 1172 0 0.00 1 575 16 0 0
sp_cancel_pay_to_supplier 657 657 0 0.00 2 291 17 0 0
sp_cancel_supplier_invoice 6617 6617 0 0.00 1 2027 125 0 0
sp_cancel_supplier_order 640 640 0 0.00 5 62883 8431 0 0
sp_cancel_write_off 9566 9566 0 0.00 1 762 17 0 0
sp_client_order 36439 36439 0 0.00 3 1659 35 0 0
sp_customer_reserve 393245 393245 0 0.00 0 2726 21 0 0
sp_fill_shopping_cart 54942 54942 0 0.00 0 2529 16 0 0
sp_fill_shopping_cart_clo_res 393245 393245 0 0.00 0 2342 2 0 0
sp_get_clo_for_invoice 7926 7926 0 0.00 0 2393 33 0 0
sp_kill_cost_storno 16893 16893 0 0.00 0 913 7 0 0
sp_kill_qstorno_ret_qs2qd 602653 602653 0 0.00 0 2022 7 0 0
sp_kill_qty_storno 343041 343041 0 0.00 0 2230 16 0 0
sp_lock_selected_doc 34413 34413 0 0.00 0 759 1 0 0
sp_make_cost_storno 46848 46848 0 0.00 0 808 5 0 0
sp_multiply_rows_for_pdistr 46848 46848 0 0.00 0 826 8 0 0
sp_multiply_rows_for_qdistr 36439 36439 0 0.00 0 1071 15 0 0
sp_pay_from_customer 12140 12140 0 0.00 1 1523 31 0 0
sp_pay_to_supplier 9876 9876 0 0.00 2 1021 24 0 0
sp_payment_common 22016 22016 0 0.00 0 1509 8 0 0
sp_qd_handle_on_cancel_clo 2973 2973 0 0.00 0 2085 42 0 0
sp_qd_handle_on_invoice_upd_sts 13424 13424 0 0.00 0 1483 61 0 0
sp_qd_handle_on_reserve_upd_sts 16906 16906 0 0.00 0 1225 9 0 0
sp_reserve_write_off 16906 16906 0 0.00 2 1304 31 0 0
sp_supplier_invoice 9305 9305 0 0.00 3 5131 302 0 0
sp_supplier_order 9198 9198 0 0.00 3 1939 174 0 0
srv_aggregate_perf_data 316 316 0 0.00 72 6452 1405 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 3 814 310 0 0
srv_find_qd_qs_mism 765011 765011 0 0.00 0 935 1 0 0
srv_make_invnt_saldo 1339 1339 0 0.00 1 4170 1229 0 0
srv_make_money_saldo 2902 2902 0 0.00 0 245 12 0 0
srv_recalc_idx_stat 2 2 0 0.00 199 11872 6036 0 0
v_add_invoice_to_stock 15852 15852 0 0.00 0 614 2 0 0
v_all_customers 55534 55534 0 0.00 0 88 0 0 0
v_all_suppliers 45870 45870 0 0.00 0 48 0 0 0
v_all_wares 72878 72878 0 0.00 0 68 0 0 0
v_cancel_adding_invoice 1396 1396 0 0.00 0 473 2 0 0
v_cancel_client_order 5946 5946 0 0.00 0 483 1 0 0
v_cancel_customer_prepayment 2344 2344 0 0.00 0 304 1 0 0
v_cancel_customer_reserve 2268 2268 0 0.00 0 183 2 0 0
v_cancel_payment_to_supplier 1314 1314 0 0.00 0 204 2 0 0
v_cancel_supplier_invoice 1326 1326 0 0.00 0 571 2 0 0
v_cancel_supplier_order 1280 1280 0 0.00 0 600 2 0 0
v_cancel_write_off 3288 3288 0 0.00 0 360 2 0 0
v_max_id_clo_ord 9198 9198 0 0.00 0 206 1 0 0
v_max_id_clo_res 1719 1719 0 0.00 0 1096 2 0 0
v_max_id_ord_sup 9305 9305 0 0.00 0 1027 2 0 0
v_max_non_paid_invoice 5444 5444 0 0.00 0 250 1 0 0
v_max_non_paid_realizn 11743 11743 0 0.00 0 176 1 0 0
v_min_id_clo_ord 9198 9198 0 0.00 0 597 2 0 0
v_min_id_clo_res 1719 1719 0 0.00 0 1382 5 0 0
v_min_id_ord_sup 9305 9305 0 0.00 0 960 3 0 0
v_min_non_paid_invoice 9876 9876 0 0.00 0 410 3 0 0
v_min_non_paid_realizn 12140 12140 0 0.00 0 819 5 0 0
v_our_firm 18138 18138 0 0.00 0 25 0 0 0
v_reserve_write_off 33812 33812 0 0.00 0 585 1 0 0
x_lock_depdocs_on_canc_invoice 11452 11452 0 0.00 0 909 9 0 0
x_lock_depdocs_on_canc_sup_ord 640 640 0 0.00 0 152 10 0 0
x_make_qstorno_1000_1200 9198 9198 0 0.00 1 1894 127 0 0
x_make_qstorno_1200_2000 9305 9305 0 0.00 1 5092 265 0 0
x_make_qstorno_2100_3300 393245 393245 0 0.00 0 2693 19 0 0

Completed "Performance in DETAILS". Done for 00:00:03, from 14-11-2026 03:50:48 to 14-11-2026 03:50:51.

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:00:36 3 2147483648 2253169168 2255597568 4080464 0.189 1 1 2 0 4149520 60512 8544
03:01:37 282 2147483648 2523906912 2759663616 268193424 11.102 20 12 22 0 269530048 964816 371808
03:02:38 168 2147483648 2522250192 2756235264 265804592 11.014 20 11 22 0 268383392 2139888 438912
03:03:39 315 2147483648 2489525408 2690859008 232016768 9.750 19 11 21 0 235795360 3400064 378528
03:04:39 226 2147483648 2529258864 2783920128 271550848 11.225 20 14 29 0 274390336 2219424 620064
03:05:40 270 2147483648 2531493712 2783199232 270543792 11.188 20 15 31 0 277240368 6009872 686704
03:06:40 184 2147483648 2516719488 2735800320 254362048 10.590 20 12 25 0 262133296 7155120 616128
03:07:41 242 2147483648 2535872208 2785538048 273401856 11.293 20 13 28 0 280655184 6683616 569712
03:08:41 258 2147483648 2526777504 2755842048 264625072 10.970 20 13 27 0 272187200 7015472 546656
03:09:42 287 2147483648 2533719520 2770776064 267372256 11.071 20 13 26 0 278319120 10401584 545280
03:10:42 234 2147483648 2538840800 2769055744 269159184 11.137 20 14 27 1 283858816 13986768 712864
03:11:43 319 2147483648 2539326112 2782461952 271576000 11.226 20 15 32 1 284916288 12664080 676208
03:12:43 331 2147483648 2506498800 2731274240 241668224 10.115 18 13 26 0 251372928 9166752 537952
03:13:44 289 2147483648 2558239360 2796658688 270472336 11.185 20 14 27 0 302046736 30947040 627360
03:14:44 320 2147483648 2542558608 2794270720 275988208 11.388 20 12 24 0 287538192 10941808 608176
03:15:45 262 2147483648 2533879888 2778079232 271719392 11.231 20 14 29 0 279322464 6821712 781360
03:16:46 239 2147483648 2536367296 2791505920 275169488 11.358 20 14 26 2 282229920 6345792 714640
03:17:46 321 2147483648 2535686656 2776649728 268089904 11.098 20 16 32 0 279704416 10808624 805888
03:18:47 291 2147483648 2546721264 2796298240 274704704 11.341 20 12 23 1 291775824 16479472 591648
03:19:47 324 2147483648 2538227248 2785894400 273906560 11.311 20 13 26 0 281748672 7198896 643216
03:20:48 240 2147483648 2534883168 2773577728 267079088 11.061 20 11 22 0 280216960 12629200 508672
03:21:48 269 2147483648 2542682208 2786951168 274455360 11.332 20 14 28 0 288196656 13022128 719168
03:22:49 308 2147483648 2518076432 2756485120 259709296 10.788 19 5 10 1 262122208 2129200 283712
03:23:49 374 2147483648 2542985104 2785038336 272996608 11.278 20 14 28 1 287508544 13800592 711344
03:24:50 441 2147483648 2542870800 2790604800 277085680 11.428 20 10 20 0 287932320 10166896 679744
03:25:51 166 2147483648 2524649504 2759847936 264685040 10.972 20 8 16 0 269557920 4532672 340208
03:26:51 302 2147483648 2546979872 2790031360 276174768 11.394 20 12 26 0 293305200 16389184 741248
03:27:52 491 2147483648 2551855680 2811400192 278587856 11.483 20 11 22 0 294852480 15482400 782224
03:28:53 809 2147483648 2534241120 2773405696 260872336 10.831 19 10 20 0 273271776 11797376 602064
03:29:54 303 2147483648 2535335808 2770186240 267758224 11.086 20 11 22 0 280463456 11934784 770448
03:30:55 255 2147483648 2540687312 2783010816 276350480 11.401 20 15 29 0 285585440 8661008 573952
03:31:55 249 2147483648 2552832576 2796154880 273443328 11.294 20 12 24 0 296801328 22856848 501152
03:32:56 264 2147483648 2527243808 2773729280 269790544 11.160 20 13 26 0 272286768 1987488 508736
03:33:56 250 2147483648 2540511424 2786942976 269376768 11.145 20 14 28 0 283682592 13702064 603760
03:34:57 225 2147483648 2524492096 2763259904 263994272 10.947 20 13 24 0 268998032 4614816 388944
03:35:57 282 2147483648 2532363248 2766983168 264743120 10.975 20 12 24 0 276836144 11489536 603488
03:36:58 276 2147483648 2546664448 2793492480 269982352 11.167 20 13 26 0 289779744 19171888 625504
03:37:58 314 2147483648 2504251472 2718781440 241914928 10.124 19 10 20 0 246202272 3885408 401936
03:38:59 215 2147483648 2530184032 2765426688 262588240 10.895 20 5 10 0 275962480 13201152 173088
03:39:59 678 2147483648 2524716304 2770309120 263310640 10.922 20 3 6 0 270156288 6694368 151280
03:41:00 530 2147483648 2559453392 2796122112 255779392 10.643 19 6 12 0 293464352 37324672 360288
03:42:02 334 2147483648 2535277888 2764787712 262043904 10.875 20 13 26 0 278449200 15834880 570416
03:43:03 233 2147483648 2536934928 2779557888 267822976 11.088 20 11 22 0 279417120 11160576 433568
03:44:03 386 2147483648 2514210032 2744827904 250958544 10.463 19 13 26 0 257358016 5875312 524160
03:45:04 351 2147483648 2529900064 2772779008 269695616 11.157 20 10 20 0 273840256 3563360 581280
03:46:04 315 2147483648 2548406928 2796646400 270731616 11.195 20 10 20 0 290936896 19769488 435792
03:47:05 399 2147483648 2527000640 2766360576 265164096 10.990 20 17 34 0 272049888 6239760 646032
03:48:05 235 2147483648 2530777136 2765864960 260085408 10.802 20 7 14 0 275310432 14917392 307632
03:49:06 277 2147483648 2541843952 2786140160 269986016 11.168 20 9 18 0 286623520 16208576 428928
03:50:06 282 2147483648 2538606448 2775441408 263839312 10.941 20 13 27 0 280565568 16100336 625920

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:10, from 14-11-2026 03:50:51 to 14-11-2026 03:51:01.

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

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          246077
MON$OLDEST_ACTIVE               246078
MON$OLDEST_SNAPSHOT             246078
MON$NEXT_TRANSACTION            246078
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-14 00:00:10.2770 GMT
MON$PAGES                       193732
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                        {0FBDD3D9-E63F-4B81-A064-D5E7953897A4}
MON$FILE_ID                     0108000000000000c2ed070000000000
MON$NEXT_ATTACHMENT             623
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'

14.11.26 03:51:02. 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-14 03:51:03 No severe PSQL-related problems occured
14.11.26 03:51:03. End of report.