Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 07.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 2bf17960cddd47aabfae2d899d34f677
Product UUID de98ff4e-d959-45a6-974b-0c761b9e398f
Virtualization kvm
Operating System Debian GNU/Linux 13 (trixie)
Kernel Linux 6.12.113+deb13-amd64
Architecture x86-64
Hardware Vendor Selectel
Hardware Model OpenStack Nova
Hardware Serial de98ff4e-d959-45a6-974b-0c761b9e398f
Firmware Version 1.15.0-1
Firmware Date Tue 2014-04-01
Firmware Age 12y 7month 1w
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 2246652 kB
MemAvailable 7161872 kB
Buffers 90516 kB
Cached 4911540 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-07 09:50:35
DTS_END                         2026-11-07 09:50:35.7160
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/36296
TRN_ID                          224571
ATT_ID                          471
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: 15154.10 1083 757705
customer order: creation 663.40 40 33170
customer order: refuse 53.64 44 2682
order to supplier: creation 172.00 182 8600
order to supplier: removal 11.86 8291 593
invoice (draft): creation 167.90 321 8395
invoice (draft): removal 122.26 119 6113
invoice accept: apply 144.48 1401 7224
invoice accept: cancel 101.72 194 5086
customer reserve: creation 7259.94 23 362997
customer reserve: removal 5453.94 13 272697
realization accept: apply 306.02 31 15301
realization accept: cancel 177.58 19 8879
payment from customer: creation 222.44 31 11122
payment from customer: removal 20.66 16 1033
payment to supplier: creation 182.64 24 9132
payment to supplier: removal 13.24 19 662
service: total inventory turnovers 21.98 1507 1099
service: total monetary turnovers 52.98 11 2649
service: aggregate perf. data 5.36 1522 268
service: refresh index statistics 0.06 7853 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 07-11-2026 09:50:56 to 07-11-2026 09:50:57.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 10968
TEST_TIME 2 11910
TEST_TIME 3 12225
TEST_TIME 4 12779
TEST_TIME 5 12809
TEST_TIME 6 12955
TEST_TIME 7 12980
TEST_TIME 8 13102
TEST_TIME 9 13107
TEST_TIME 10 13297
TEST_TIME 11 13380
TEST_TIME 12 13490
TEST_TIME 13 13390
TEST_TIME 14 13519
TEST_TIME 15 13588
TEST_TIME 16 13583
TEST_TIME 17 13638
TEST_TIME 18 13716
TEST_TIME 19 13738
TEST_TIME 20 13881
TEST_TIME 21 13970
TEST_TIME 22 14034
TEST_TIME 23 14105
TEST_TIME 24 14092
TEST_TIME 25 14202
TEST_TIME 26 14118
TEST_TIME 27 14294
TEST_TIME 28 14323
TEST_TIME 29 14348
TEST_TIME 30 14408
TEST_TIME 31 14439
TEST_TIME 32 14460
TEST_TIME 33 14578
TEST_TIME 34 14607
TEST_TIME 35 14634
TEST_TIME 36 14688
TEST_TIME 37 14742
TEST_TIME 38 14845
TEST_TIME 39 14892
TEST_TIME 40 14913
TEST_TIME 41 14930
TEST_TIME 42 14985
TEST_TIME 43 14976
TEST_TIME 44 15030
TEST_TIME 45 15062
TEST_TIME 46 15093
TEST_TIME 47 15179
TEST_TIME 48 15264
TEST_TIME 49 15309
TEST_TIME 50 15154

Performance per minute, chart


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

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 1114706 1114706 0 0.00 0 2119 2 0 0
doc_list_biud 1114706 1114706 0 0.00 0 1863 5 0 0
sp_add_invoice_to_stock 7224 7224 0 0.00 7 17024 1402 0 0
sp_cancel_adding_invoice 5086 5086 0 0.00 3 6031 195 0 0
sp_cancel_client_order 2682 2682 0 0.00 2 1433 44 0 0
sp_cancel_customer_reserve 272697 272697 0 0.00 1 1810 14 0 0
sp_cancel_pay_from_customer 1033 1033 0 0.00 1 965 17 0 0
sp_cancel_pay_to_supplier 662 662 0 0.00 1 1659 19 0 0
sp_cancel_supplier_invoice 6113 6113 0 0.00 1 2099 120 0 0
sp_cancel_supplier_order 593 593 0 0.00 4 49605 8292 0 0
sp_cancel_write_off 8879 8879 0 0.00 1 1300 20 0 0
sp_client_order 33170 33170 0 0.00 2 2271 40 0 0
sp_customer_reserve 362997 362997 0 0.00 0 2176 24 0 0
sp_fill_shopping_cart 50165 50165 0 0.00 0 2057 17 0 0
sp_fill_shopping_cart_clo_res 362997 362997 0 0.00 0 1435 2 0 0
sp_get_clo_for_invoice 7224 7224 0 0.00 0 2259 34 0 0
sp_kill_cost_storno 15660 15660 0 0.00 0 1287 8 0 0
sp_kill_qstorno_ret_qs2qd 560979 560979 0 0.00 0 1796 7 0 0
sp_kill_qty_storno 318575 318575 0 0.00 0 1862 15 0 0
sp_lock_selected_doc 31287 31287 0 0.00 0 958 1 0 0
sp_make_cost_storno 42779 42779 0 0.00 0 906 7 0 0
sp_multiply_rows_for_pdistr 42779 42779 0 0.00 0 1085 9 0 0
sp_multiply_rows_for_qdistr 33170 33170 0 0.00 0 1070 16 0 0
sp_pay_from_customer 11122 11122 0 0.00 2 1505 31 0 0
sp_pay_to_supplier 9132 9132 0 0.00 2 1094 25 0 0
sp_payment_common 20254 20254 0 0.00 0 922 6 0 0
sp_qd_handle_on_cancel_clo 2682 2682 0 0.00 0 1404 30 0 0
sp_qd_handle_on_invoice_upd_sts 12310 12310 0 0.00 0 1862 62 0 0
sp_qd_handle_on_reserve_upd_sts 15301 15301 0 0.00 0 1821 10 0 0
sp_reserve_write_off 15301 15301 0 0.00 2 2200 32 0 0
sp_supplier_invoice 8395 8395 0 0.00 4 6137 322 0 0
sp_supplier_order 8600 8600 0 0.00 3 2606 183 0 0
srv_aggregate_perf_data 268 268 0 0.00 9 7150 1522 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 5 626 318 0 0
srv_find_qd_qs_mism 705666 705666 0 0.00 0 2119 1 0 0
srv_make_invnt_saldo 1099 1099 0 0.00 0 4449 1508 0 0
srv_make_money_saldo 2649 2649 0 0.00 0 290 11 0 0
srv_recalc_idx_stat 3 3 0 0.00 812 11881 7854 0 0
v_add_invoice_to_stock 14448 14448 0 0.00 0 737 2 0 0
v_all_customers 50908 50908 0 0.00 0 61 0 0 0
v_all_suppliers 41806 41806 0 0.00 0 59 0 0 0
v_all_wares 66340 66340 0 0.00 0 197 0 0 0
v_cancel_adding_invoice 1368 1368 0 0.00 0 377 2 0 0
v_cancel_client_order 5364 5364 0 0.00 0 350 1 0 0
v_cancel_customer_prepayment 2066 2066 0 0.00 0 271 2 0 0
v_cancel_customer_reserve 2044 2044 0 0.00 0 591 2 0 0
v_cancel_payment_to_supplier 1324 1324 0 0.00 0 364 2 0 0
v_cancel_supplier_invoice 1078 1078 0 0.00 0 462 3 0 0
v_cancel_supplier_order 1186 1186 0 0.00 0 127 2 0 0
v_cancel_write_off 3094 3094 0 0.00 0 1081 2 0 0
v_max_id_clo_ord 8600 8600 0 0.00 0 199 1 0 0
v_max_id_clo_res 1545 1545 0 0.00 0 306 2 0 0
v_max_id_ord_sup 8395 8395 0 0.00 0 923 1 0 0
v_max_non_paid_invoice 5224 5224 0 0.00 0 31 1 0 0
v_max_non_paid_realizn 10585 10585 0 0.00 0 118 1 0 0
v_min_id_clo_ord 8600 8600 0 0.00 0 780 2 0 0
v_min_id_clo_res 1545 1545 0 0.00 0 1693 35 0 0
v_min_id_ord_sup 8395 8395 0 0.00 0 1308 4 0 0
v_min_non_paid_invoice 9132 9132 0 0.00 0 354 2 0 0
v_min_non_paid_realizn 11122 11122 0 0.00 0 536 2 0 0
v_our_firm 16506 16506 0 0.00 0 87 1 0 0
v_reserve_write_off 30602 30602 0 0.00 0 592 1 0 0
x_lock_depdocs_on_canc_invoice 10660 10660 0 0.00 0 1323 9 0 0
x_lock_depdocs_on_canc_sup_ord 593 593 0 0.00 0 118 11 0 0
x_make_qstorno_1000_1200 8600 8600 0 0.00 1 2475 132 0 0
x_make_qstorno_1200_2000 8395 8395 0 0.00 1 5966 281 0 0
x_make_qstorno_2100_3300 362997 362997 0 0.00 0 2175 21 0 0

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

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:39 4 2147483648 2253167280 2255597568 4078656 0.189 1 1 2 0 4147712 60512 8544
09:01:40 303 2147483648 2513653696 2776862720 255962656 10.649 20 15 30 0 258983216 2503104 517456
09:02:41 207 2147483648 2523269376 2780602368 269236688 11.140 20 8 17 0 271087808 1457712 393408
09:03:42 222 2147483648 2527199200 2774519808 270912672 11.202 20 12 24 0 273058880 1727904 418304
09:04:43 349 2147483648 2527923968 2764115968 269222192 11.140 20 14 28 0 273051904 3271664 558048
09:05:43 315 2147483648 2515219472 2744033280 258162064 10.731 20 10 21 1 260661760 1972800 526896
09:06:44 320 2147483648 2528471936 2771415040 269553024 11.152 20 4 8 0 276153056 6466752 133280
09:07:45 215 2147483648 2516844576 2739310592 259598448 10.784 20 9 16 1 263074560 2930176 545936
09:08:45 351 2147483648 2534911488 2774544384 271343104 11.217 20 15 30 0 280385600 8397248 645248
09:09:46 331 2147483648 2513024800 2735837184 248603136 10.375 20 8 17 0 254873088 5893440 376512
09:10:47 259 2147483648 2527675760 2766098432 266672576 11.046 20 13 26 0 271978384 4810288 495520
09:11:47 182 2147483648 2527445552 2772951040 267497536 11.076 20 9 18 0 273699376 5841712 360128
09:12:48 205 2147483648 2527953840 2770440192 266722016 11.048 20 13 25 0 273960944 6718896 520032
09:13:48 400 2147483648 2523254272 2763751424 266469280 11.038 20 6 12 0 271895440 5162880 263280
09:14:49 372 2147483648 2524071168 2764169216 265446864 11.001 20 14 27 0 269916912 3891120 578928
09:15:49 256 2147483648 2531959680 2769395712 267460000 11.075 20 12 22 1 277213920 9358384 395536
09:16:50 311 2147483648 2531258976 2765791232 264984144 10.983 20 16 33 1 275103472 9301904 817424
09:17:51 228 2147483648 2519217808 2744483840 257111392 10.692 20 8 16 0 264480112 7071120 297600
09:18:51 219 2147483648 2528644672 2763427840 262106928 10.877 20 11 22 0 273376656 10651152 618576
09:19:52 217 2147483648 2529552608 2774196224 268167424 11.101 20 6 12 1 273605664 5191472 246768
09:20:53 333 2147483648 2530027360 2771873792 265542064 11.004 20 9 18 0 271863872 5999504 322304
09:21:54 272 2147483648 2523739696 2768072704 268937936 11.129 20 9 18 0 270509328 1268816 302576
09:22:54 340 2147483648 2506757104 2734264320 248390368 10.367 19 5 10 0 252116912 3463760 262784
09:23:56 239 2147483648 2510432128 2737201152 251658000 10.489 19 12 24 0 256973376 4795760 519616
09:24:56 547 2147483648 2552161488 2793144320 267940368 11.092 20 10 19 0 298004496 29492064 572064
09:25:57 516 2147483648 2530072560 2777673728 269244160 11.140 20 13 26 0 273980768 4098384 638224
09:26:58 403 2147483648 2531909840 2754195456 255302432 10.625 20 14 26 1 274341344 18462912 576000
09:27:59 203 2147483648 2539940432 2782302208 269684512 11.157 20 10 21 0 283095376 12923168 487696
09:28:59 237 2147483648 2533813744 2791968768 270696448 11.194 20 10 19 1 278048992 6863296 489248
09:30:00 271 2147483648 2501898960 2723610624 231758000 9.740 20 12 24 0 245710720 13440864 511856
09:31:01 297 2147483648 2530467952 2764734464 259514592 10.781 19 11 22 0 273209312 13239856 454864
09:32:01 314 2147483648 2538656352 2781003776 266081472 11.024 20 12 25 0 281852464 15152032 618960
09:33:02 294 2147483648 2536099952 2775212032 263322448 10.922 20 13 26 0 277716864 13797872 596544
09:34:03 221 2147483648 2538458528 2786471936 269001488 11.131 20 8 16 0 282950160 13628480 320192
09:35:03 292 2147483648 2527670192 2776571904 264643152 10.971 20 11 22 1 271685152 6529280 512720
09:36:04 399 2147483648 2538769696 2773278720 260421024 10.815 20 12 22 1 283133760 22150640 562096
09:37:05 443 2147483648 2518570768 2753691648 259156048 10.768 20 11 22 1 264053056 4421136 475872
09:38:05 178 2147483648 2548339760 2787713024 265788352 11.013 20 12 24 0 292547712 26267104 492256
09:39:06 227 2147483648 2543238224 2791604224 268952112 11.130 20 9 18 0 285930608 16615248 363248
09:40:07 539 2147483648 2526188464 2754854912 258957776 10.761 20 8 17 0 270035168 10698416 378976
09:41:08 514 2147483648 2522020912 2754781184 255597472 10.636 19 8 16 0 264496192 8625040 273680
09:42:09 588 2147483648 2532556448 2770825216 263173568 10.917 20 11 22 0 281235904 17690976 371360
09:43:10 335 2147483648 2535640592 2773835776 264012400 10.948 20 9 17 0 278355328 13966784 376144
09:44:10 286 2147483648 2538333536 2783879168 269228368 11.140 20 11 21 0 281879024 12193072 457584
09:45:11 305 2147483648 2528981760 2778931200 269631536 11.155 20 15 27 0 273154528 3014576 508416
09:46:12 262 2147483648 2523445568 2764013568 256012032 10.651 20 13 27 1 266468752 9886256 570464
09:47:13 445 2147483648 2534681760 2769453056 262730288 10.900 20 9 18 0 275594784 12485552 378944
09:48:14 617 2147483648 2550358384 2797666304 268098928 11.098 20 10 21 0 294337184 25679648 558608
09:49:15 255 2147483648 2560543424 2806280192 268047552 11.096 20 11 22 0 304289936 35761120 481264
09:50:15 205 2147483648 2509573232 2740527104 249065776 10.392 19 14 28 1 252427840 2831072 530992

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE

Completed "Exceptions occured during test was in run". Done for 00:00:00, from 07-11-2026 09:51:16 to 07-11-2026 09:51:16.

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          224097
MON$OLDEST_ACTIVE               224697
MON$OLDEST_SNAPSHOT             224697
MON$NEXT_TRANSACTION            224697
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-07 06:00:09.7110 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                        {B7FF1483-B89A-48E8-8926-E6185EAB072B}
MON$FILE_ID                     0108000000000000c2ed070000000000
MON$NEXT_ATTACHMENT             590
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'

07.11.26 09:51:17. 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-07 09:51:17 No severe PSQL-related problems occured
07.11.26 09:51:18. End of report.