Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 18.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 4d
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 2181800 kB
MemAvailable 7216404 kB
Buffers 80016 kB
Cached 5037620 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-18 15:50:34
DTS_END                         2026-11-18 15:50:34.2620
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/43576
TRN_ID                          228855
ATT_ID                          483
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: 15478.52 1060 773926
customer order: creation 679.06 43 33953
customer order: refuse 54.88 54 2744
order to supplier: creation 172.82 206 8641
order to supplier: removal 13.28 9173 664
invoice (draft): creation 172.62 362 8631
invoice (draft): removal 124.96 151 6248
invoice accept: apply 146.94 1439 7347
invoice accept: cancel 103.10 226 5155
customer reserve: creation 7452.62 23 372631
customer reserve: removal 5541.20 16 277060
realization accept: apply 316.36 35 15818
realization accept: cancel 175.58 19 8779
payment from customer: creation 222.90 32 11145
payment from customer: removal 21.12 17 1056
payment to supplier: creation 182.90 25 9145
payment to supplier: removal 12.52 19 626
service: total inventory turnovers 24.82 1311 1241
service: total monetary turnovers 55.74 13 2787
service: aggregate perf. data 5.06 1806 253
service: refresh index statistics 0.04 6239 2

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 13245
TEST_TIME 2 13721
TEST_TIME 3 14065
TEST_TIME 4 14495
TEST_TIME 5 14347
TEST_TIME 6 14459
TEST_TIME 7 14560
TEST_TIME 8 14651
TEST_TIME 9 14795
TEST_TIME 10 14788
TEST_TIME 11 14799
TEST_TIME 12 14741
TEST_TIME 13 14862
TEST_TIME 14 14876
TEST_TIME 15 14798
TEST_TIME 16 14692
TEST_TIME 17 14873
TEST_TIME 18 14968
TEST_TIME 19 14969
TEST_TIME 20 14901
TEST_TIME 21 14938
TEST_TIME 22 14924
TEST_TIME 23 14914
TEST_TIME 24 14852
TEST_TIME 25 14657
TEST_TIME 26 14759
TEST_TIME 27 14703
TEST_TIME 28 14713
TEST_TIME 29 14680
TEST_TIME 30 14672
TEST_TIME 31 14658
TEST_TIME 32 14759
TEST_TIME 33 14774
TEST_TIME 34 14858
TEST_TIME 35 14907
TEST_TIME 36 14865
TEST_TIME 37 15135
TEST_TIME 38 15129
TEST_TIME 39 15253
TEST_TIME 40 15259
TEST_TIME 41 15295
TEST_TIME 42 15346
TEST_TIME 43 15383
TEST_TIME 44 15410
TEST_TIME 45 15406
TEST_TIME 46 15410
TEST_TIME 47 15439
TEST_TIME 48 15546
TEST_TIME 49 15634
TEST_TIME 50 15479

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 18-11-2026 15:50:51 to 18-11-2026 15:50:53.

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 1139559 1139559 0 0.00 0 1991 2 0 0
doc_list_biud 1139559 1139559 0 0.00 0 1675 6 0 0
sp_add_invoice_to_stock 7347 7347 0 0.00 6 14007 1439 0 0
sp_cancel_adding_invoice 5155 5155 0 0.00 2 5193 226 0 0
sp_cancel_client_order 2744 2744 0 0.00 2 1092 55 0 0
sp_cancel_customer_reserve 277060 277060 0 0.00 1 1676 17 0 0
sp_cancel_pay_from_customer 1056 1056 0 0.00 1 149 18 0 0
sp_cancel_pay_to_supplier 626 626 0 0.00 2 579 19 0 0
sp_cancel_supplier_invoice 6248 6248 0 0.00 2 1765 152 0 0
sp_cancel_supplier_order 664 664 0 0.00 6 73607 9173 0 0
sp_cancel_write_off 8779 8779 0 0.00 1 1050 20 0 0
sp_client_order 33953 33953 0 0.00 3 2230 43 0 0
sp_customer_reserve 372631 372631 0 0.00 0 2008 24 0 0
sp_fill_shopping_cart 51225 51225 0 0.00 0 2352 19 0 0
sp_fill_shopping_cart_clo_res 372631 372631 0 0.00 0 1730 2 0 0
sp_get_clo_for_invoice 7347 7347 0 0.00 0 2264 38 0 0
sp_kill_cost_storno 15616 15616 0 0.00 0 624 9 0 0
sp_kill_qstorno_ret_qs2qd 569811 569811 0 0.00 0 1649 8 0 0
sp_kill_qty_storno 323815 323815 0 0.00 0 1675 19 0 0
sp_lock_selected_doc 32115 32115 0 0.00 0 513 1 0 0
sp_make_cost_storno 43455 43455 0 0.00 0 717 7 0 0
sp_multiply_rows_for_pdistr 43455 43455 0 0.00 0 500 9 0 0
sp_multiply_rows_for_qdistr 33953 33953 0 0.00 0 1452 19 0 0
sp_pay_from_customer 11145 11145 0 0.00 2 754 32 0 0
sp_pay_to_supplier 9145 9145 0 0.00 2 646 26 0 0
sp_payment_common 20290 20290 0 0.00 0 526 6 0 0
sp_qd_handle_on_cancel_clo 2744 2744 0 0.00 0 1086 40 0 0
sp_qd_handle_on_invoice_upd_sts 12502 12502 0 0.00 0 1320 74 0 0
sp_qd_handle_on_reserve_upd_sts 15818 15818 0 0.00 0 1169 10 0 0
sp_reserve_write_off 15818 15818 0 0.00 2 1192 35 0 0
sp_supplier_invoice 8631 8631 0 0.00 4 6309 363 0 0
sp_supplier_order 8641 8641 0 0.00 4 2012 206 0 0
srv_aggregate_perf_data 253 253 0 0.00 51 8608 1806 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 3 778 317 0 0
srv_find_qd_qs_mism 720701 720701 0 0.00 0 1988 1 0 0
srv_make_invnt_saldo 1241 1241 0 0.00 0 4571 1311 0 0
srv_make_money_saldo 2787 2787 0 0.00 0 317 14 0 0
srv_recalc_idx_stat 2 2 0 0.00 420 12058 6239 0 0
v_add_invoice_to_stock 14694 14694 0 0.00 0 575 2 0 0
v_all_customers 51950 51950 0 0.00 0 66 0 0 0
v_all_suppliers 42308 42308 0 0.00 0 101 0 0 0
v_all_wares 67906 67906 0 0.00 0 83 0 0 0
v_cancel_adding_invoice 1316 1316 0 0.00 0 173 2 0 0
v_cancel_client_order 5488 5488 0 0.00 0 236 1 0 0
v_cancel_customer_prepayment 2112 2112 0 0.00 0 139 1 0 0
v_cancel_customer_reserve 2108 2108 0 0.00 0 445 2 0 0
v_cancel_payment_to_supplier 1252 1252 0 0.00 0 451 2 0 0
v_cancel_supplier_invoice 1270 1270 0 0.00 0 579 3 0 0
v_cancel_supplier_order 1328 1328 0 0.00 0 211 2 0 0
v_cancel_write_off 3026 3026 0 0.00 0 588 2 0 0
v_max_id_clo_ord 8641 8641 0 0.00 0 390 1 0 0
v_max_id_clo_res 1557 1557 0 0.00 0 317 2 0 0
v_max_id_ord_sup 8631 8631 0 0.00 0 790 1 0 0
v_max_non_paid_invoice 5263 5263 0 0.00 0 74 1 0 0
v_max_non_paid_realizn 10744 10744 0 0.00 0 139 1 0 0
v_min_id_clo_ord 8641 8641 0 0.00 0 365 2 0 0
v_min_id_clo_res 1557 1557 0 0.00 0 404 4 0 0
v_min_id_ord_sup 8631 8631 0 0.00 0 1220 4 0 0
v_min_non_paid_invoice 9145 9145 0 0.00 0 183 2 0 0
v_min_non_paid_realizn 11145 11145 0 0.00 0 511 2 0 0
v_our_firm 16758 16758 0 0.00 0 35 1 0 0
v_reserve_write_off 31636 31636 0 0.00 0 648 1 0 0
x_lock_depdocs_on_canc_invoice 10768 10768 0 0.00 0 1044 11 0 0
x_lock_depdocs_on_canc_sup_ord 664 664 0 0.00 0 179 14 0 0
x_make_qstorno_1000_1200 8641 8641 0 0.00 1 1976 152 0 0
x_make_qstorno_1200_2000 8631 8631 0 0.00 1 6235 321 0 0
x_make_qstorno_2100_3300 372631 372631 0 0.00 0 2005 21 0 0

Completed "Performance in DETAILS". Done for 00:00:03, from 18-11-2026 15:50:53 to 18-11-2026 15:50:56.

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:37 3 2147483648 2253217776 2255728640 4114768 0.191 1 1 2 0 4183824 60512 8544
15:01:39 291 2147483648 2489187712 2685771776 232701072 9.776 20 9 17 0 234020256 1075072 244112
15:02:40 335 2147483648 2495477552 2705076224 236171472 9.907 19 14 29 1 240746912 3806880 768560
15:03:40 309 2147483648 2525440640 2772156416 268191424 11.102 20 11 22 0 271224304 2612576 420304
15:04:41 316 2147483648 2535517424 2783514624 275354784 11.364 20 13 27 1 281014256 5125680 533792
15:05:41 239 2147483648 2507980752 2726166528 250181904 10.434 19 11 22 0 252649744 2001840 466000
15:06:42 262 2147483648 2530872096 2775502848 273079504 11.281 20 10 19 0 277517840 4022832 415504
15:07:42 234 2147483648 2531169520 2771746816 270036800 11.169 20 10 19 0 277382192 6908624 436768
15:08:43 312 2147483648 2529759712 2771374080 268810976 11.124 20 12 24 0 276365984 6879856 675152
15:09:43 315 2147483648 2529446272 2760552448 259878768 10.795 20 16 34 0 272360240 11632400 849072
15:10:44 286 2147483648 2520901536 2753552384 259749936 10.790 20 15 30 0 265543824 5140656 653232
15:11:45 332 2147483648 2538313296 2774695936 267522752 11.077 20 15 29 0 282363344 14081696 758896
15:12:45 285 2147483648 2528332688 2771079168 271193184 11.212 20 12 23 0 274104080 2321584 589312
15:13:46 311 2147483648 2522484432 2751070208 260072480 10.802 20 12 24 0 268379888 7766560 540848
15:14:46 183 2147483648 2531141760 2774331392 272572256 11.263 20 9 19 0 276579328 3363008 644064
15:15:47 258 2147483648 2543248768 2781679616 275103856 11.355 20 14 30 0 288311728 12470240 737632
15:16:47 777 2147483648 2555973120 2795724800 275381280 11.365 20 11 23 0 300200816 24260464 559072
15:17:48 367 2147483648 2539898336 2783707136 271041776 11.206 20 16 34 1 285870896 14035040 794080
15:18:49 272 2147483648 2528510640 2768355328 263099216 10.914 20 12 24 0 273589488 10058864 431408
15:19:49 355 2147483648 2536235968 2779140096 272614912 11.264 20 12 24 0 276895872 3654656 626304
15:20:50 173 2147483648 2537349376 2779095040 269486384 11.149 20 10 20 0 282405728 12272544 646800
15:21:50 329 2147483648 2535805600 2780442624 274345296 11.328 20 12 25 0 280347216 5324944 676976
15:22:51 215 2147483648 2540326128 2792624128 274864512 11.347 20 16 30 0 285627408 9972112 790784
15:23:51 346 2147483648 2528883872 2766602240 265043888 10.986 20 12 27 0 273585296 7981488 559920
15:24:52 320 2147483648 2529059760 2767966208 269443776 11.148 20 7 14 0 273726320 4007680 274864
15:25:53 389 2147483648 2556819824 2799058944 272123456 11.246 20 14 28 1 301033968 28057600 852912
15:26:54 443 2147483648 2570576176 2818732032 275789200 11.380 20 10 19 0 313718112 37368976 559936
15:27:55 380 2147483648 2547265936 2789117952 273365360 11.292 20 13 26 0 290487472 16355904 766208
15:28:55 173 2147483648 2549877648 2802610176 278957984 11.496 20 10 20 0 293659520 14044224 657312
15:29:56 303 2147483648 2540775472 2776625152 268059360 11.097 20 11 20 1 284975296 16331360 584576
15:30:56 367 2147483648 2554813424 2795520000 279774912 11.526 20 10 20 0 299591136 19352352 463872
15:31:57 283 2147483648 2569634176 2820063232 280563184 11.555 20 16 32 0 312623376 31253312 806880
15:32:59 355 2147483648 2531819280 2778947584 263860672 10.942 20 13 23 0 269893664 5606272 426720
15:34:00 307 2147483648 2535518736 2782068736 267178576 11.064 20 12 24 1 278337440 10623888 534976
15:35:01 271 2147483648 2533198976 2766114816 260822368 10.830 20 15 31 0 277832128 16319456 690304
15:36:02 262 2147483648 2526163360 2771189760 265036256 10.985 20 12 25 0 270544960 5010320 498384
15:37:02 326 2147483648 2557840224 2802405376 266976464 11.057 20 10 20 0 301566080 34106848 482768
15:38:03 420 2147483648 2529722304 2773405696 266350704 11.034 20 6 12 0 273143952 6544192 249056
15:39:04 265 2147483648 2539454912 2792300544 267801392 11.087 20 9 18 0 286605184 18360144 443648
15:40:05 336 2147483648 2540343392 2784292864 267447376 11.074 20 14 28 0 283234080 15162720 623984
15:41:06 371 2147483648 2533668784 2779172864 269221008 11.140 20 11 21 0 277596064 7999520 375536
15:42:06 302 2147483648 2537544176 2782507008 267297840 11.069 20 10 21 0 282364960 14561344 505776
15:43:07 378 2147483648 2527893440 2757222400 255121808 10.618 20 9 18 0 271351568 15864112 365648
15:44:07 311 2147483648 2529912800 2772824064 263753728 10.938 20 10 18 1 274087600 9996256 337616
15:45:08 304 2147483648 2524449920 2754953216 256762128 10.679 20 12 24 0 267424608 10175312 487168
15:46:08 306 2147483648 2524417152 2758676480 262501200 10.892 20 11 22 2 267750176 4699392 549584
15:47:10 323 2147483648 2531183072 2776641536 267970000 11.093 20 12 25 0 275768368 7266864 531504
15:48:11 295 2147483648 2525551360 2744487936 242776144 10.156 19 14 27 0 265704144 22368128 559872
15:49:11 275 2147483648 2542406048 2789957632 270992640 11.205 20 12 24 0 285943296 14336000 614656
15:50:13 412 2147483648 2546594272 2785218560 269346592 11.144 20 16 32 0 288076192 18030896 698704

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:10, from 18-11-2026 15:50:57 to 18-11-2026 15:51:07.

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 18-11-2026 15:51:08 to 18-11-2026 15:51:08.

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          227388
MON$OLDEST_ACTIVE               229064
MON$OLDEST_SNAPSHOT             229064
MON$NEXT_TRANSACTION            229064
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-18 12:00:08.8950 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                        {71E6E1A6-D0F3-4DE8-87CD-F0EFEF0621C1}
MON$FILE_ID                     0108000000000000c2ed070000000000
MON$NEXT_ATTACHMENT             599
MON$NEXT_STATEMENT              512
MON$REPLICA_MODE                0


ISQL Version: LI-V5.0.5.1979 Firebird 5.0 HQbird
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V5.0.5.1979 Firebird 5.0 HQbird"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V5.0.5.1979 Firebird 5.0 HQbird/tcp (test-0)/P19:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V5.0.5.1979 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'

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