Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 10.11.2026 21: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 3d
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 2201700 kB
MemAvailable 7177764 kB
Buffers 80280 kB
Cached 5017432 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 21:50:35
DTS_END                         2026-11-10 21:50:35.5920
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/46720
TRN_ID                          220920
ATT_ID                          450
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: 14288.78 1115 714439
customer order: creation 658.56 43 32928
customer order: refuse 52.20 52 2610
order to supplier: creation 168.40 199 8420
order to supplier: removal 12.52 8191 626
invoice (draft): creation 164.44 358 8222
invoice (draft): removal 116.46 138 5823
invoice accept: apply 140.42 1418 7021
invoice accept: cancel 95.92 203 4796
customer reserve: creation 6907.72 24 345386
customer reserve: removal 4988.20 15 249410
realization accept: apply 305.56 36 15278
realization accept: cancel 173.18 19 8659
payment from customer: creation 215.34 33 10767
payment from customer: removal 20.20 18 1010
payment to supplier: creation 177.92 27 8896
payment to supplier: removal 12.68 17 634
service: total inventory turnovers 21.50 1529 1075
service: total monetary turnovers 52.70 14 2635
service: aggregate perf. data 4.82 1727 241
service: refresh index statistics 0.04 8236 2

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 11112
TEST_TIME 2 12368
TEST_TIME 3 12619
TEST_TIME 4 13206
TEST_TIME 5 13549
TEST_TIME 6 13535
TEST_TIME 7 13614
TEST_TIME 8 13678
TEST_TIME 9 13688
TEST_TIME 10 13663
TEST_TIME 11 13736
TEST_TIME 12 13591
TEST_TIME 13 13736
TEST_TIME 14 13760
TEST_TIME 15 13711
TEST_TIME 16 13667
TEST_TIME 17 13822
TEST_TIME 18 13795
TEST_TIME 19 13704
TEST_TIME 20 13789
TEST_TIME 21 13700
TEST_TIME 22 13668
TEST_TIME 23 13684
TEST_TIME 24 13638
TEST_TIME 25 13610
TEST_TIME 26 13592
TEST_TIME 27 13609
TEST_TIME 28 13572
TEST_TIME 29 13659
TEST_TIME 30 13612
TEST_TIME 31 13715
TEST_TIME 32 13667
TEST_TIME 33 13812
TEST_TIME 34 13885
TEST_TIME 35 13852
TEST_TIME 36 13968
TEST_TIME 37 14016
TEST_TIME 38 14030
TEST_TIME 39 14033
TEST_TIME 40 14084
TEST_TIME 41 14167
TEST_TIME 42 14188
TEST_TIME 43 14223
TEST_TIME 44 14286
TEST_TIME 45 14286
TEST_TIME 46 14272
TEST_TIME 47 14327
TEST_TIME 48 14405
TEST_TIME 49 14367
TEST_TIME 50 14289

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 10-11-2026 21:50:54 to 10-11-2026 21: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 1054780 1054780 0 0.00 0 1362 2 0 0
doc_list_biud 1054780 1054780 0 0.00 0 2793 5 0 0
sp_add_invoice_to_stock 7021 7021 0 0.00 6 13686 1418 0 0
sp_cancel_adding_invoice 4796 4796 0 0.00 3 5242 203 0 0
sp_cancel_client_order 2610 2610 0 0.00 2 2380 53 0 0
sp_cancel_customer_reserve 249410 249410 0 0.00 1 1408 15 0 0
sp_cancel_pay_from_customer 1010 1010 0 0.00 1 819 18 0 0
sp_cancel_pay_to_supplier 634 634 0 0.00 1 288 18 0 0
sp_cancel_supplier_invoice 5823 5823 0 0.00 1 1846 139 0 0
sp_cancel_supplier_order 626 626 0 0.00 8 48562 8191 0 0
sp_cancel_write_off 8659 8659 0 0.00 1 1350 20 0 0
sp_client_order 32928 32928 0 0.00 2 1539 43 0 0
sp_customer_reserve 345386 345386 0 0.00 0 2576 24 0 0
sp_fill_shopping_cart 49570 49570 0 0.00 0 2660 18 0 0
sp_fill_shopping_cart_clo_res 345386 345386 0 0.00 0 1314 2 0 0
sp_get_clo_for_invoice 7021 7021 0 0.00 0 2197 34 0 0
sp_kill_cost_storno 15099 15099 0 0.00 0 776 9 0 0
sp_kill_qstorno_ret_qs2qd 513928 513928 0 0.00 0 1866 8 0 0
sp_kill_qty_storno 294223 294223 0 0.00 0 2793 17 0 0
sp_lock_selected_doc 30870 30870 0 0.00 0 876 1 0 0
sp_make_cost_storno 41962 41962 0 0.00 0 791 7 0 0
sp_multiply_rows_for_pdistr 41962 41962 0 0.00 0 853 10 0 0
sp_multiply_rows_for_qdistr 32928 32928 0 0.00 0 1481 17 0 0
sp_pay_from_customer 10767 10767 0 0.00 2 1013 34 0 0
sp_pay_to_supplier 8896 8896 0 0.00 2 1184 27 0 0
sp_payment_common 19663 19663 0 0.00 0 831 7 0 0
sp_qd_handle_on_cancel_clo 2610 2610 0 0.00 0 2364 38 0 0
sp_qd_handle_on_invoice_upd_sts 11817 11817 0 0.00 0 2793 65 0 0
sp_qd_handle_on_reserve_upd_sts 15278 15278 0 0.00 0 1354 10 0 0
sp_reserve_write_off 15278 15278 0 0.00 2 1358 37 0 0
sp_supplier_invoice 8222 8222 0 0.00 4 6333 359 0 0
sp_supplier_order 8420 8420 0 0.00 3 3024 200 0 0
srv_aggregate_perf_data 241 241 0 0.00 8 9006 1728 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 6 656 342 0 0
srv_find_qd_qs_mism 663848 663848 0 0.00 0 1362 1 0 0
srv_make_invnt_saldo 1075 1075 0 0.00 1 4656 1530 0 0
srv_make_money_saldo 2635 2635 0 0.00 0 981 15 0 0
srv_recalc_idx_stat 2 2 0 0.00 345 16128 8237 0 0
v_add_invoice_to_stock 14042 14042 0 0.00 0 845 2 0 0
v_all_customers 50166 50166 0 0.00 0 42 0 0 0
v_all_suppliers 41162 41162 0 0.00 0 81 0 0 0
v_all_wares 65856 65856 0 0.00 0 73 0 0 0
v_cancel_adding_invoice 1284 1284 0 0.00 0 41 2 0 0
v_cancel_client_order 5220 5220 0 0.00 0 396 1 0 0
v_cancel_customer_prepayment 2020 2020 0 0.00 0 750 2 0 0
v_cancel_customer_reserve 2048 2048 0 0.00 0 278 2 0 0
v_cancel_payment_to_supplier 1268 1268 0 0.00 0 285 2 0 0
v_cancel_supplier_invoice 1078 1078 0 0.00 0 463 3 0 0
v_cancel_supplier_order 1252 1252 0 0.00 0 234 2 0 0
v_cancel_write_off 2972 2972 0 0.00 0 435 2 0 0
v_max_id_clo_ord 8420 8420 0 0.00 0 653 1 0 0
v_max_id_clo_res 1509 1509 0 0.00 0 194 2 0 0
v_max_id_ord_sup 8222 8222 0 0.00 0 907 2 0 0
v_max_non_paid_invoice 4957 4957 0 0.00 0 464 1 0 0
v_max_non_paid_realizn 10426 10426 0 0.00 0 63 1 0 0
v_min_id_clo_ord 8420 8420 0 0.00 0 454 2 0 0
v_min_id_clo_res 1509 1509 0 0.00 0 678 5 0 0
v_min_id_ord_sup 8222 8222 0 0.00 0 1261 5 0 0
v_min_non_paid_invoice 8896 8896 0 0.00 0 496 2 0 0
v_min_non_paid_realizn 10767 10767 0 0.00 0 465 2 0 0
v_our_firm 16372 16372 0 0.00 0 42 1 0 0
v_reserve_write_off 30556 30556 0 0.00 0 1129 1 0 0
x_lock_depdocs_on_canc_invoice 10080 10080 0 0.00 0 834 9 0 0
x_lock_depdocs_on_canc_sup_ord 626 626 0 0.00 0 1059 14 0 0
x_make_qstorno_1000_1200 8420 8420 0 0.00 1 2998 148 0 0
x_make_qstorno_1200_2000 8222 8222 0 0.00 1 5700 314 0 0
x_make_qstorno_2100_3300 345386 345386 0 0.00 0 2567 21 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 10-11-2026 21:50:56 to 10-11-2026 21: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
21:00:39 6 2147483648 2253169168 2255597568 4080464 0.189 1 1 2 0 4149520 60512 8544
21:01:40 281 2147483648 2487499360 2714185728 225751904 9.512 19 9 17 0 227096688 1020928 323856
21:02:41 282 2147483648 2527650816 2779443200 270311040 11.180 20 12 20 2 273859888 3085776 463072
21:03:42 240 2147483648 2528553952 2770391040 271237392 11.214 20 8 15 1 274550432 2993568 319472
21:04:42 263 2147483648 2522484720 2758168576 266762208 11.049 20 11 22 1 269612032 2410544 439280
21:05:43 417 2147483648 2517974288 2756673536 257280912 10.698 20 10 18 1 263400624 5689184 430528
21:06:44 295 2147483648 2527902128 2777448448 272108048 11.246 20 11 22 0 274055184 1561072 386064
21:07:45 271 2147483648 2527417088 2760187904 263361344 10.924 20 10 20 1 273306272 9450336 494592
21:08:45 350 2147483648 2537012272 2775023616 270660784 11.192 20 12 24 0 281968000 10719056 588160
21:09:47 187 2147483648 2527003120 2766888960 267721120 11.084 20 12 25 0 270968416 2716000 531296
21:10:47 250 2147483648 2527650176 2766798848 268991936 11.131 20 13 27 0 274306128 4759056 555136
21:11:48 272 2147483648 2544194240 2785632256 270857552 11.200 20 13 26 0 289196144 17682752 655840
21:12:49 260 2147483648 2533592224 2771193856 268635536 11.118 20 13 26 1 278574192 9301376 637280
21:13:50 188 2147483648 2533536272 2777022464 272939200 11.276 20 14 28 0 278702688 5195808 567680
21:14:50 257 2147483648 2526819696 2756980736 261519008 10.855 20 12 25 0 271208240 8964384 724848
21:15:50 314 2147483648 2531940336 2774994944 271378320 11.219 20 8 17 0 277188096 5376704 433072
21:16:51 350 2147483648 2533764528 2776297472 267081280 11.061 20 10 20 0 283827888 16243792 502816
21:17:52 311 2147483648 2538523152 2776891392 270529568 11.188 20 13 28 1 283185984 11925696 730720
21:18:53 220 2147483648 2536865056 2787528704 274203968 11.322 20 12 24 0 282595968 7688320 703680
21:19:53 299 2147483648 2545076768 2794270720 275530928 11.371 20 12 24 0 290054464 14051648 471888
21:20:54 308 2147483648 2540303072 2776195072 266814112 11.051 20 12 24 0 284600816 17257040 529664
21:21:55 507 2147483648 2553551744 2801754112 274405456 11.330 20 13 26 0 297498208 22428928 663824
21:22:55 283 2147483648 2541348336 2793082880 275553856 11.372 20 10 21 0 286279152 10088896 636400
21:23:56 323 2147483648 2530232960 2774573056 272456448 11.258 20 9 15 1 275411168 2631328 323392
21:24:57 409 2147483648 2541837568 2783522816 270148016 11.174 20 9 18 0 286490192 15978752 363424
21:25:57 262 2147483648 2541016192 2793246720 276551376 11.408 20 9 19 0 285409776 8441184 417216
21:26:58 308 2147483648 2516568800 2744688640 246079520 10.280 18 9 18 0 256969280 10387616 502144
21:27:58 306 2147483648 2513513440 2743558144 244302128 10.214 19 15 28 2 251768640 6687808 778704
21:28:59 515 2147483648 2551511888 2795175936 273871264 11.310 20 10 20 0 294424816 19975776 577776
21:30:00 418 2147483648 2509586320 2739359744 246311968 10.289 20 15 32 0 253529328 6586944 630416
21:31:01 652 2147483648 2547227056 2787086336 271975696 11.241 20 10 20 0 293744544 21308688 460160
21:32:02 332 2147483648 2534301936 2776432640 269427856 11.147 20 8 16 0 278900224 9163056 309312
21:33:03 225 2147483648 2532203968 2768027648 261189360 10.843 20 8 16 0 278443232 16883744 370128
21:34:03 381 2147483648 2533821024 2773651456 266601840 11.043 20 9 18 1 276074096 9155696 316560
21:35:04 562 2147483648 2527243088 2769145856 263533168 10.930 20 9 18 0 271148496 7175680 439648
21:36:05 293 2147483648 2537725552 2776911872 265821008 11.014 20 12 24 0 281541840 15181520 539312
21:37:06 322 2147483648 2526895248 2771107840 266080352 11.024 20 6 12 0 273307840 6981120 246368
21:38:07 656 2147483648 2510214976 2750181376 254259856 10.586 19 4 8 0 256273904 1697808 316240
21:39:08 442 2147483648 2525286912 2771820544 265425120 11.000 20 12 24 0 268757056 2910272 421664
21:40:09 319 2147483648 2533084016 2767384576 261919104 10.870 20 11 20 0 277343024 14993104 430816
21:41:10 424 2147483648 2534584304 2780225536 265685456 11.009 20 5 10 0 278854480 12924576 244448
21:42:11 363 2147483648 2529097952 2774237184 265146208 10.989 20 11 22 0 273372720 7699344 527168
21:43:11 353 2147483648 2520006416 2758934528 254239136 10.585 20 9 18 0 268591840 14041408 311296
21:44:12 315 2147483648 2546410080 2793164800 270482480 11.186 20 9 18 1 291617856 20439552 695824
21:45:12 375 2147483648 2519031984 2755850240 252472560 10.519 20 10 20 1 258249360 5401552 375248
21:46:13 486 2147483648 2526288240 2766221312 262111184 10.877 20 8 16 0 269225856 6755456 359216
21:47:14 344 2147483648 2533496400 2776719360 269518224 11.150 20 9 18 0 277144064 7265040 360800
21:48:14 328 2147483648 2543804064 2796986368 269298080 11.142 20 12 24 0 287042192 17209472 534640
21:49:16 352 2147483648 2540046784 2784329728 267571280 11.079 20 12 22 1 282882496 14742592 568624
21:50:17 394 2147483648 2527671136 2760302592 254795440 10.606 19 9 18 0 271680096 16454464 430192

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 10-11-2026 21:51:00 to 10-11-2026 21: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 10-11-2026 21:51:13 to 10-11-2026 21: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          219912
MON$OLDEST_ACTIVE               221069
MON$OLDEST_SNAPSHOT             221069
MON$NEXT_TRANSACTION            221069
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 18:00:09.3960 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                        {904802EF-1827-452D-A219-017158089FF2}
MON$FILE_ID                     0108000000000000c2ed070000000000
MON$NEXT_ATTACHMENT             585
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'

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