Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 10.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 2d
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 2240000 kB
MemAvailable 7199208 kB
Buffers 79284 kB
Cached 5006484 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-10 03:50:37
DTS_END                         2026-11-10 03:50:37.5760
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/60248
TRN_ID                          235277
ATT_ID                          482
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: 16434.30 962 821715
customer order: creation 699.72 40 34986
customer order: refuse 58.16 51 2908
order to supplier: creation 176.12 185 8806
order to supplier: removal 13.94 8166 697
invoice (draft): creation 175.02 336 8751
invoice (draft): removal 126.92 137 6346
invoice accept: apply 150.44 1373 7522
invoice accept: cancel 106.50 208 5325
customer reserve: creation 7975.88 21 398794
customer reserve: removal 5904.48 14 295224
realization accept: apply 322.26 33 16113
realization accept: cancel 182.20 18 9110
payment from customer: creation 231.12 30 11556
payment from customer: removal 22.44 17 1122
payment to supplier: creation 188.86 25 9443
payment to supplier: removal 13.94 17 697
service: total inventory turnovers 24.44 1327 1222
service: total monetary turnovers 56.38 13 2819
service: aggregate perf. data 5.44 1665 272
service: refresh index statistics 0.04 5560 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 10-11-2026 03:50:53 to 10-11-2026 03:50:54.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 11620
TEST_TIME 2 12778
TEST_TIME 3 13469
TEST_TIME 4 13910
TEST_TIME 5 14167
TEST_TIME 6 14430
TEST_TIME 7 14611
TEST_TIME 8 14740
TEST_TIME 9 14819
TEST_TIME 10 14744
TEST_TIME 11 14960
TEST_TIME 12 15010
TEST_TIME 13 15042
TEST_TIME 14 14980
TEST_TIME 15 15032
TEST_TIME 16 15077
TEST_TIME 17 15073
TEST_TIME 18 15153
TEST_TIME 19 15188
TEST_TIME 20 15210
TEST_TIME 21 15139
TEST_TIME 22 15224
TEST_TIME 23 15238
TEST_TIME 24 15246
TEST_TIME 25 15251
TEST_TIME 26 15244
TEST_TIME 27 15309
TEST_TIME 28 15316
TEST_TIME 29 15339
TEST_TIME 30 15295
TEST_TIME 31 15433
TEST_TIME 32 15582
TEST_TIME 33 15624
TEST_TIME 34 15729
TEST_TIME 35 15740
TEST_TIME 36 15889
TEST_TIME 37 15957
TEST_TIME 38 16088
TEST_TIME 39 16019
TEST_TIME 40 16129
TEST_TIME 41 16210
TEST_TIME 42 16268
TEST_TIME 43 16294
TEST_TIME 44 16279
TEST_TIME 45 16373
TEST_TIME 46 16452
TEST_TIME 47 16429
TEST_TIME 48 16508
TEST_TIME 49 16503
TEST_TIME 50 16434

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 10-11-2026 03:50:54 to 10-11-2026 03:50:56.

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 1208257 1208257 0 0.00 0 1622 2 0 0
doc_list_biud 1208257 1208257 0 0.00 0 2295 5 0 0
sp_add_invoice_to_stock 7522 7522 0 0.00 3 11708 1374 0 0
sp_cancel_adding_invoice 5325 5325 0 0.00 3 5708 209 0 0
sp_cancel_client_order 2908 2908 0 0.00 2 1129 51 0 0
sp_cancel_customer_reserve 295224 295224 0 0.00 1 1777 14 0 0
sp_cancel_pay_from_customer 1122 1122 0 0.00 1 577 18 0 0
sp_cancel_pay_to_supplier 697 697 0 0.00 1 480 17 0 0
sp_cancel_supplier_invoice 6346 6346 0 0.00 1 1929 137 0 0
sp_cancel_supplier_order 697 697 0 0.00 4 46612 8166 0 0
sp_cancel_write_off 9110 9110 0 0.00 1 859 18 0 0
sp_client_order 34986 34986 0 0.00 2 2159 40 0 0
sp_customer_reserve 398794 398794 0 0.00 0 2261 22 0 0
sp_fill_shopping_cart 52543 52543 0 0.00 0 2286 16 0 0
sp_fill_shopping_cart_clo_res 398794 398794 0 0.00 0 1307 2 0 0
sp_get_clo_for_invoice 7522 7522 0 0.00 0 1998 35 0 0
sp_kill_cost_storno 16254 16254 0 0.00 0 883 9 0 0
sp_kill_qstorno_ret_qs2qd 606601 606601 0 0.00 0 2295 7 0 0
sp_kill_qty_storno 343245 343245 0 0.00 0 2295 17 0 0
sp_lock_selected_doc 32988 32988 0 0.00 0 549 1 0 0
sp_make_cost_storno 44634 44634 0 0.00 0 890 7 0 0
sp_multiply_rows_for_pdistr 44634 44634 0 0.00 0 926 9 0 0
sp_multiply_rows_for_qdistr 34986 34986 0 0.00 0 2148 17 0 0
sp_pay_from_customer 11556 11556 0 0.00 2 1118 31 0 0
sp_pay_to_supplier 9443 9443 0 0.00 2 941 26 0 0
sp_payment_common 20999 20999 0 0.00 0 1113 6 0 0
sp_qd_handle_on_cancel_clo 2908 2908 0 0.00 0 1116 38 0 0
sp_qd_handle_on_invoice_upd_sts 12847 12847 0 0.00 0 2127 66 0 0
sp_qd_handle_on_reserve_upd_sts 16113 16113 0 0.00 0 1795 9 0 0
sp_reserve_write_off 16113 16113 0 0.00 3 1807 34 0 0
sp_supplier_invoice 8751 8751 0 0.00 4 6351 337 0 0
sp_supplier_order 8806 8806 0 0.00 4 1981 185 0 0
srv_aggregate_perf_data 272 272 0 0.00 29 17285 1665 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 6 505 300 0 0
srv_find_qd_qs_mism 764342 764342 0 0.00 0 1621 1 0 0
srv_make_invnt_saldo 1222 1222 0 0.00 0 3983 1328 0 0
srv_make_money_saldo 2819 2819 0 0.00 0 292 13 0 0
srv_recalc_idx_stat 2 2 0 0.00 285 10835 5560 0 0
v_add_invoice_to_stock 15044 15044 0 0.00 0 624 2 0 0
v_all_customers 53570 53570 0 0.00 0 70 0 0 0
v_all_suppliers 43126 43126 0 0.00 0 102 0 0 0
v_all_wares 69972 69972 0 0.00 0 113 0 0 0
v_cancel_adding_invoice 1392 1392 0 0.00 0 246 2 0 0
v_cancel_client_order 5816 5816 0 0.00 0 460 1 0 0
v_cancel_customer_prepayment 2244 2244 0 0.00 0 410 2 0 0
v_cancel_customer_reserve 2148 2148 0 0.00 0 186 2 0 0
v_cancel_payment_to_supplier 1394 1394 0 0.00 0 287 2 0 0
v_cancel_supplier_invoice 1210 1210 0 0.00 0 153 2 0 0
v_cancel_supplier_order 1394 1394 0 0.00 0 236 2 0 0
v_cancel_write_off 3108 3108 0 0.00 0 423 2 0 0
v_max_id_clo_ord 8806 8806 0 0.00 0 196 1 0 0
v_max_id_clo_res 1627 1627 0 0.00 0 214 1 0 0
v_max_id_ord_sup 8751 8751 0 0.00 0 744 2 0 0
v_max_non_paid_invoice 5437 5437 0 0.00 0 70 1 0 0
v_max_non_paid_realizn 11130 11130 0 0.00 0 127 1 0 0
v_min_id_clo_ord 8806 8806 0 0.00 0 563 2 0 0
v_min_id_clo_res 1627 1627 0 0.00 0 447 3 0 0
v_min_id_ord_sup 8751 8751 0 0.00 0 782 3 0 0
v_min_non_paid_invoice 9443 9443 0 0.00 0 336 2 0 0
v_min_non_paid_realizn 11556 11556 0 0.00 0 331 2 0 0
v_our_firm 17254 17254 0 0.00 0 33 0 0 0
v_reserve_write_off 32226 32226 0 0.00 0 780 1 0 0
x_lock_depdocs_on_canc_invoice 11066 11066 0 0.00 0 1117 10 0 0
x_lock_depdocs_on_canc_sup_ord 697 697 0 0.00 0 222 12 0 0
x_make_qstorno_1000_1200 8806 8806 0 0.00 1 1930 139 0 0
x_make_qstorno_1200_2000 8751 8751 0 0.00 1 6338 298 0 0
x_make_qstorno_2100_3300 398794 398794 0 0.00 0 2069 19 0 0

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

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:41 5 2147483648 2253167280 2255597568 4078656 0.189 1 1 2 0 4147712 60512 8544
03:01:42 271 2147483648 2495487344 2723684352 241099600 10.093 20 10 20 0 242146816 712416 334800
03:02:42 358 2147483648 2521322192 2768039936 263199264 10.918 20 12 27 0 264964208 1164592 600352
03:03:43 351 2147483648 2530410272 2778587136 274828624 11.345 20 14 28 0 276680176 1279984 571568
03:04:44 286 2147483648 2532259040 2777096192 272437984 11.258 20 16 31 1 276796064 3748768 609312
03:05:44 240 2147483648 2521421856 2763493376 263030848 10.911 20 15 30 1 268146016 4550896 564272
03:06:45 268 2147483648 2531559120 2782564352 271359584 11.218 20 14 27 0 274463792 2546816 557392
03:07:46 383 2147483648 2518640032 2748559360 258773808 10.754 20 6 12 0 263180832 4143872 263152
03:08:47 226 2147483648 2534774528 2770722816 267495680 11.076 20 13 24 0 279952352 11954624 502048
03:09:47 224 2147483648 2526091888 2773323776 269838544 11.162 20 12 23 1 271530528 1257872 434112
03:10:48 269 2147483648 2535400640 2777841664 267792448 11.087 20 14 26 1 281524832 13067568 664816
03:11:48 195 2147483648 2549004432 2798579712 274280048 11.325 20 8 16 0 293562032 18941264 340720
03:12:49 212 2147483648 2525757072 2763403264 264813344 10.977 20 16 32 0 269398368 3834896 750128
03:13:49 199 2147483648 2526511776 2765541376 266260960 11.031 20 10 20 0 271972144 5304336 406848
03:14:50 195 2147483648 2539185728 2783813632 271069648 11.207 20 15 30 0 283677120 11770416 837056
03:15:50 210 2147483648 2537368688 2787340288 272338848 11.254 20 7 14 0 280635296 8021984 274464
03:16:51 380 2147483648 2545426272 2787291136 272812320 11.271 20 15 29 0 289574816 16021408 741088
03:17:52 356 2147483648 2552887680 2797752320 273843440 11.309 20 10 20 0 297243056 22862000 537616
03:18:53 493 2147483648 2534346464 2773327872 267436144 11.074 20 13 26 0 278767600 10570352 761104
03:19:54 274 2147483648 2544556352 2791456768 272969344 11.277 20 12 22 0 288622864 15060032 593488
03:20:54 287 2147483648 2529421040 2779893760 271448896 11.221 20 7 14 0 277979568 6262528 268144
03:21:55 319 2147483648 2545850128 2795196416 274417072 11.330 20 13 27 0 290666400 15617952 631376
03:22:57 409 2147483648 2533487008 2767486976 266479152 11.039 20 12 24 0 275952176 8951872 521152
03:23:57 388 2147483648 2543826176 2795433984 276999760 11.425 20 11 21 0 288556144 11037696 518688
03:24:58 298 2147483648 2547524960 2798440448 274344464 11.327 20 15 31 0 290641712 15356112 941136
03:25:59 322 2147483648 2546957568 2797543424 273508368 11.297 20 12 24 0 291942256 17649872 784016
03:27:00 412 2147483648 2554108160 2802245632 272565904 11.262 20 16 32 1 297364704 23919040 879760
03:28:00 312 2147483648 2543677712 2797039616 271485136 11.223 20 12 25 0 287283952 15170016 628800
03:29:01 166 2147483648 2525013264 2762887168 264553024 10.968 20 6 12 2 269828720 4821184 454512
03:30:02 277 2147483648 2500338592 2728185856 246906336 10.311 20 11 20 0 248783936 1505312 372288
03:31:02 320 2147483648 2547512640 2793054208 271751216 11.232 20 11 22 0 289956576 17740560 464800
03:32:03 413 2147483648 2546588496 2791895040 275010160 11.352 20 11 22 0 289504192 14043136 450896
03:33:04 406 2147483648 2526095712 2774327296 268032656 11.096 20 9 18 0 269742272 1411120 298496
03:34:04 231 2147483648 2545768096 2794844160 270167696 11.174 20 11 18 2 290013648 19483792 362160
03:35:06 318 2147483648 2523476624 2759573504 264369152 10.961 20 12 23 0 272195136 7225888 600096
03:36:06 308 2147483648 2524031728 2766536704 264832624 10.978 20 12 25 0 268887744 3533920 521200
03:37:07 230 2147483648 2544169696 2791436288 264827472 10.978 20 13 24 1 287231152 21771536 632144
03:38:08 406 2147483648 2550644304 2795700224 265879280 11.016 20 16 31 0 293442608 26770448 792880
03:39:09 279 2147483648 2537073264 2783780864 268832608 11.125 20 15 30 1 279351056 9888640 629808
03:40:10 298 2147483648 2518975744 2752958464 253957344 10.575 20 11 22 0 260602160 6151408 493408
03:41:11 266 2147483648 2534943424 2775982080 265043872 10.986 20 10 20 0 278962624 13464048 454704
03:42:11 291 2147483648 2533628224 2782679040 261479136 10.854 20 7 14 0 277555728 15687632 388960
03:43:12 401 2147483648 2531477472 2774671360 266596224 11.043 20 9 16 1 275637888 8576944 464720
03:44:12 277 2147483648 2524380880 2761457664 262504544 10.892 20 14 28 0 268236896 5161760 570592
03:45:13 286 2147483648 2544643264 2798202880 269979968 11.167 20 12 24 0 288251664 17629504 642192
03:46:14 392 2147483648 2537203584 2788081664 269207344 11.139 20 11 22 1 278541920 8929072 405504
03:47:14 222 2147483648 2528388432 2762952704 261951440 10.871 20 13 27 1 272860400 10231888 677072
03:48:15 263 2147483648 2575472032 2818674688 269393312 11.146 20 13 26 0 318436448 48280384 762752
03:49:15 291 2147483648 2529244336 2781806592 269600272 11.153 20 12 24 0 274255808 4175248 480288
03:50:16 236 2147483648 2561097840 2804002816 266681600 11.046 20 12 24 0 304604288 37250400 672288

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

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 10-11-2026 03:51:11 to 10-11-2026 03:51:12.

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          234923
MON$OLDEST_ACTIVE               235718
MON$OLDEST_SNAPSHOT             235718
MON$NEXT_TRANSACTION            235718
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-10 00:00:12.1800 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                        {D018C5A5-783F-4551-A744-1999014D0863}
MON$FILE_ID                     0108000000000000c2ed070000000000
MON$NEXT_ATTACHMENT             609
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'

10.11.26 03:51:12. 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-10 03:51:13 No severe PSQL-related problems occured
10.11.26 03:51:13. End of report.