Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 15.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 e92ae1229cb64d19992a66f8d80a9f04
Product UUID de98ff4e-d959-45a6-974b-0c761b9e398f
Virtualization kvm
Operating System Debian GNU/Linux 13 (trixie)
Kernel Linux 6.12.117+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 2w 1d
Command: who -b
bootup_info system boot 2026-11-14 21: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 8138028 kB
MemFree 2210288 kB
MemAvailable 7192912 kB
Buffers 46656 kB
Cached 5022968 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-15 15:50:34
DTS_END                         2026-11-15 15:50:34.7200
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(292:30) ==> SP_CUSTOMER_RESERVE(63:5) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(95:17)
IP                              ::1/45866
TRN_ID                          220568
ATT_ID                          470
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: 14907.02 1217 745351
customer order: creation 651.98 41 32599
customer order: refuse 54.20 51 2710
order to supplier: creation 163.62 197 8181
order to supplier: removal 12.18 9093 609
invoice (draft): creation 166.94 346 8347
invoice (draft): removal 121.10 139 6055
invoice accept: apply 142.80 1418 7140
invoice accept: cancel 100.20 189 5010
customer reserve: creation 7183.30 23 359165
customer reserve: removal 5324.38 15 266219
realization accept: apply 305.78 34 15289
realization accept: cancel 176.26 18 8813
payment from customer: creation 216.96 31 10848
payment from customer: removal 20.38 18 1019
payment to supplier: creation 174.96 25 8748
payment to supplier: removal 12.92 16 646
service: total inventory turnovers 22.24 1483 1112
service: total monetary turnovers 52.30 14 2615
service: aggregate perf. data 4.46 1783 223
service: refresh index statistics 0.06 9409 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 15-11-2026 15:50:54 to 15-11-2026 15:50:55.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 12035
TEST_TIME 2 12457
TEST_TIME 3 12680
TEST_TIME 4 13160
TEST_TIME 5 13314
TEST_TIME 6 13553
TEST_TIME 7 13561
TEST_TIME 8 13718
TEST_TIME 9 13721
TEST_TIME 10 13843
TEST_TIME 11 13741
TEST_TIME 12 13861
TEST_TIME 13 14041
TEST_TIME 14 14037
TEST_TIME 15 13970
TEST_TIME 16 13986
TEST_TIME 17 14033
TEST_TIME 18 13968
TEST_TIME 19 14049
TEST_TIME 20 14007
TEST_TIME 21 14107
TEST_TIME 22 14141
TEST_TIME 23 14096
TEST_TIME 24 14074
TEST_TIME 25 14055
TEST_TIME 26 14086
TEST_TIME 27 14028
TEST_TIME 28 14040
TEST_TIME 29 14080
TEST_TIME 30 14021
TEST_TIME 31 14148
TEST_TIME 32 14154
TEST_TIME 33 14194
TEST_TIME 34 14253
TEST_TIME 35 14255
TEST_TIME 36 14379
TEST_TIME 37 14422
TEST_TIME 38 14583
TEST_TIME 39 14613
TEST_TIME 40 14647
TEST_TIME 41 14709
TEST_TIME 42 14720
TEST_TIME 43 14775
TEST_TIME 44 14774
TEST_TIME 45 14834
TEST_TIME 46 14839
TEST_TIME 47 14939
TEST_TIME 48 15041
TEST_TIME 49 15020
TEST_TIME 50 14907

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:01, from 15-11-2026 15:50:56 to 15-11-2026 15: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 1096946 1096946 0 0.00 0 1325 2 0 0
doc_list_biud 1096946 1096946 0 0.00 0 2623 5 0 0
sp_add_invoice_to_stock 7140 7140 0 0.00 4 12871 1418 0 0
sp_cancel_adding_invoice 5010 5010 0 0.00 3 5683 190 0 0
sp_cancel_client_order 2710 2710 0 0.00 2 1431 51 0 0
sp_cancel_customer_reserve 266219 266219 0 0.00 1 2624 15 0 0
sp_cancel_pay_from_customer 1019 1019 0 0.00 1 572 18 0 0
sp_cancel_pay_to_supplier 646 646 0 0.00 1 160 17 0 0
sp_cancel_supplier_invoice 6055 6055 0 0.00 2 2211 139 0 0
sp_cancel_supplier_order 609 609 0 0.00 5 63031 9093 0 0
sp_cancel_write_off 8813 8813 0 0.00 1 739 18 0 0
sp_client_order 32599 32599 0 0.00 2 2032 42 0 0
sp_customer_reserve 359165 359165 0 0.00 0 2855 23 0 0
sp_fill_shopping_cart 49127 49127 0 0.00 0 2848 18 0 0
sp_fill_shopping_cart_clo_res 359165 359165 0 0.00 0 1514 2 0 0
sp_get_clo_for_invoice 7140 7140 0 0.00 0 2272 38 0 0
sp_kill_cost_storno 15488 15488 0 0.00 0 922 8 0 0
sp_kill_qstorno_ret_qs2qd 547915 547915 0 0.00 0 2583 8 0 0
sp_kill_qty_storno 311845 311845 0 0.00 0 2623 17 0 0
sp_lock_selected_doc 31084 31084 0 0.00 0 827 1 0 0
sp_make_cost_storno 42025 42025 0 0.00 0 655 7 0 0
sp_multiply_rows_for_pdistr 42025 42025 0 0.00 0 984 9 0 0
sp_multiply_rows_for_qdistr 32599 32599 0 0.00 0 1656 17 0 0
sp_pay_from_customer 10848 10848 0 0.00 2 927 32 0 0
sp_pay_to_supplier 8748 8748 0 0.00 2 701 26 0 0
sp_payment_common 19596 19596 0 0.00 0 899 6 0 0
sp_qd_handle_on_cancel_clo 2710 2710 0 0.00 0 787 37 0 0
sp_qd_handle_on_invoice_upd_sts 12150 12150 0 0.00 0 1955 68 0 0
sp_qd_handle_on_reserve_upd_sts 15289 15289 0 0.00 0 1427 10 0 0
sp_reserve_write_off 15289 15289 0 0.00 2 1482 35 0 0
sp_supplier_invoice 8347 8347 0 0.00 3 5484 347 0 0
sp_supplier_order 8181 8181 0 0.00 3 2653 198 0 0
srv_aggregate_perf_data 223 223 0 0.00 36 8913 1783 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 3 658 335 0 0
srv_find_qd_qs_mism 693765 693765 0 0.00 0 1324 1 0 0
srv_make_invnt_saldo 1112 1112 0 0.00 0 5120 1484 0 0
srv_make_money_saldo 2615 2615 0 0.00 0 310 15 0 0
srv_recalc_idx_stat 3 3 0 0.00 790 16392 9409 0 0
v_add_invoice_to_stock 14280 14280 0 0.00 0 875 2 0 0
v_all_customers 49858 49858 0 0.00 0 64 0 0 0
v_all_suppliers 40248 40248 0 0.00 0 85 0 0 0
v_all_wares 65198 65198 0 0.00 0 121 0 0 0
v_cancel_adding_invoice 1186 1186 0 0.00 0 749 2 0 0
v_cancel_client_order 5420 5420 0 0.00 0 268 1 0 0
v_cancel_customer_prepayment 2038 2038 0 0.00 0 230 1 0 0
v_cancel_customer_reserve 2096 2096 0 0.00 0 880 2 0 0
v_cancel_payment_to_supplier 1292 1292 0 0.00 0 152 1 0 0
v_cancel_supplier_invoice 1076 1076 0 0.00 0 189 3 0 0
v_cancel_supplier_order 1218 1218 0 0.00 0 377 2 0 0
v_cancel_write_off 2984 2984 0 0.00 0 645 3 0 0
v_max_id_clo_ord 8181 8181 0 0.00 0 261 1 0 0
v_max_id_clo_res 1452 1452 0 0.00 0 272 2 0 0
v_max_id_ord_sup 8347 8347 0 0.00 0 755 2 0 0
v_max_non_paid_invoice 5152 5152 0 0.00 0 73 1 0 0
v_max_non_paid_realizn 10508 10508 0 0.00 0 68 1 0 0
v_min_id_clo_ord 8181 8181 0 0.00 0 779 2 0 0
v_min_id_clo_res 1452 1452 0 0.00 0 491 4 0 0
v_min_id_ord_sup 8347 8347 0 0.00 0 2119 4 0 0
v_min_non_paid_invoice 8748 8748 0 0.00 0 259 2 0 0
v_min_non_paid_realizn 10848 10848 0 0.00 0 895 2 0 0
v_our_firm 16020 16020 0 0.00 0 61 1 0 0
v_reserve_write_off 30578 30578 0 0.00 0 800 1 0 0
x_lock_depdocs_on_canc_invoice 10527 10527 0 0.00 0 946 9 0 0
x_lock_depdocs_on_canc_sup_ord 609 609 0 0.00 0 348 12 0 0
x_make_qstorno_1000_1200 8181 8181 0 0.00 1 2541 145 0 0
x_make_qstorno_1200_2000 8347 8347 0 0.00 1 5445 304 0 0
x_make_qstorno_2100_3300 359165 359165 0 0.00 0 2854 20 0 0

Completed "Performance in DETAILS". Done for 00:00:03, from 15-11-2026 15:50:58 to 15-11-2026 15: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
15:00:38 3 2147483648 2253169168 2255597568 4080464 0.189 1 1 2 0 4149520 60512 8544
15:01:39 290 2147483648 2462183184 2656235520 206181760 8.760 18 12 21 1 207041776 532576 327440
15:02:40 287 2147483648 2524305680 2778910720 268828064 11.125 20 10 23 0 270634736 1318480 488192
15:03:40 318 2147483648 2534181392 2781143040 273875248 11.310 20 12 24 0 280976880 6588992 512640
15:04:41 290 2147483648 2528031616 2756415488 264374640 10.961 20 13 26 0 272502880 7526096 602144
15:05:42 319 2147483648 2526209472 2778902528 269963008 11.167 20 11 24 0 272850464 2412576 474880
15:06:42 406 2147483648 2535540848 2768019456 269420176 11.147 20 13 26 0 280621344 10663056 538112
15:07:43 278 2147483648 2504412928 2727378944 243383456 10.179 19 10 20 0 248205712 4478400 343856
15:08:44 353 2147483648 2531922944 2776924160 270004000 11.168 20 12 24 0 277237920 6734768 499152
15:09:44 258 2147483648 2509256912 2740305920 250820272 10.458 20 11 21 0 253046976 1795792 430912
15:10:45 339 2147483648 2537458464 2772652032 269277520 11.142 20 11 21 0 282272848 12503760 491568
15:11:45 284 2147483648 2532142960 2775965696 271594320 11.227 20 13 26 0 277092208 4958528 539360
15:12:46 389 2147483648 2526807792 2755452928 263464880 10.927 20 12 24 0 270299536 6402816 431840
15:13:47 297 2147483648 2545732192 2794713088 272811040 11.271 20 11 22 0 290816000 17470272 534688
15:14:47 288 2147483648 2536271120 2786250752 272137920 11.247 20 13 26 0 280202048 7473680 590448
15:15:48 228 2147483648 2532156544 2777096192 272070464 11.244 20 11 21 0 277345760 4727568 547728
15:16:49 293 2147483648 2542424976 2792484864 273658784 11.302 20 11 22 0 286785008 12639200 487024
15:17:49 257 2147483648 2538187936 2778730496 269681552 11.156 20 10 20 0 284422544 14247584 493408
15:18:50 379 2147483648 2536681088 2784952320 275552928 11.372 20 11 20 0 281469984 5466960 450096
15:19:52 249 2147483648 2527247936 2775384064 268023760 11.095 20 6 12 0 272210688 3955696 231232
15:20:52 309 2147483648 2523919120 2750402560 261539584 10.856 20 14 28 0 268650032 6312016 798432
15:21:53 298 2147483648 2542640224 2789236736 274738384 11.342 20 13 26 0 286267440 10788000 741056
15:22:53 260 2147483648 2530957984 2774405120 269879200 11.164 20 13 27 0 273923264 3239360 804704
15:23:54 228 2147483648 2537325216 2772967424 266457664 11.038 20 10 20 0 281003088 13932224 613200
15:24:54 345 2147483648 2553466272 2796249088 273352592 11.291 20 11 24 0 297646400 23688672 605136
15:25:55 281 2147483648 2553727168 2802061312 278445376 11.477 20 15 31 0 297582976 18381824 755776
15:26:56 306 2147483648 2543045648 2785423360 277049584 11.426 20 13 25 0 288807872 10851936 906352
15:27:56 452 2147483648 2548235504 2791190528 272119776 11.246 20 9 18 1 292531744 19852960 559008
15:28:57 519 2147483648 2538013040 2778120192 271110800 11.209 20 14 28 0 282361552 10388592 862160
15:29:58 266 2147483648 2534866944 2775916544 269733552 11.158 20 14 30 1 279729552 9040752 955248
15:30:58 226 2147483648 2553476352 2799984640 276573248 11.409 20 12 24 0 298493120 21444080 475792
15:31:59 416 2147483648 2531237984 2772185088 268075104 11.097 20 9 18 0 275218672 6761424 382144
15:32:59 293 2147483648 2540214816 2786549760 266644208 11.045 20 10 20 0 284595648 17517728 433712
15:34:00 637 2147483648 2535919632 2773954560 260209968 10.807 20 7 14 0 279425600 18888944 326688
15:35:01 487 2147483648 2533942928 2776424448 267439408 11.074 20 14 28 0 278833280 10748944 644928
15:36:02 464 2147483648 2559208528 2799984640 263392688 10.925 20 13 24 0 303328144 39428400 507056
15:37:06 404 2147483648 2541134016 2784821248 265823136 11.014 20 12 25 0 285629424 19207984 598304
15:38:06 176 2147483648 2533371344 2772164608 263529056 10.930 20 10 20 0 278209760 14263088 417616
15:39:07 468 2147483648 2527801536 2766827520 262441104 10.890 20 13 26 0 269933440 7037296 455040
15:40:07 457 2147483648 2537574800 2785312768 269460432 11.148 20 12 24 0 281605696 11710048 435216
15:41:08 299 2147483648 2529783296 2773823488 261426448 10.852 20 11 23 0 272930768 11018416 485904
15:42:09 332 2147483648 2530581744 2767429632 259941024 10.797 20 17 31 1 272949296 12351904 656368
15:43:09 263 2147483648 2522250352 2773491712 267037536 11.059 20 3 6 0 267515328 364592 113200
15:44:10 332 2147483648 2524890608 2769940480 264511648 10.966 20 8 16 0 269995888 5199072 285168
15:45:11 322 2147483648 2543557008 2775502848 262127696 10.878 20 11 22 0 286935264 24243456 564112
15:46:11 658 2147483648 2534096624 2772180992 262207552 10.881 20 8 16 0 277078336 14541344 329440
15:47:12 325 2147483648 2549270848 2795737088 269897520 11.164 20 16 31 2 292760240 22138912 723808
15:48:14 364 2147483648 2536803232 2772971520 263169344 10.916 20 8 16 0 280227664 16672080 386240
15:49:14 229 2147483648 2545100784 2785800192 265799008 11.014 20 15 31 2 286138496 19648224 691264
15:50:15 302 2147483648 2544842304 2790772736 271634432 11.228 20 10 20 0 288456768 16335584 486752

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:12, from 15-11-2026 15:51:01 to 15-11-2026 15: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 15-11-2026 15:51:13 to 15-11-2026 15: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          219743
MON$OLDEST_ACTIVE               220707
MON$OLDEST_SNAPSHOT             220707
MON$NEXT_TRANSACTION            220707
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-15 12:00:09.3910 GMT
MON$PAGES                       182308
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                                                                                                                                                                                      
MON$SEC_DATABASE                Default
MON$CRYPT_STATE                 0
MON$GUID                        {985A5077-01ED-41A5-9F94-B18AFF94D8AF}
MON$FILE_ID                     0108000000000000c2ed070000000000
MON$NEXT_ATTACHMENT             582
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'

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