Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 02.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 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 2d
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 1955932 kB
MemAvailable 7183152 kB
Buffers 81468 kB
Cached 5270536 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-02 15:50:48
DTS_END                         2026-11-02 15:50:48.1620
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(59:5) ==> X_MAKE_QSTORNO_1200_2000(289:25) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(95:17)
IP                              ::1/36084
TRN_ID                          198143
ATT_ID                          428
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: 11824.94 964 591247
customer order: creation 582.18 48 29109
customer order: refuse 49.00 58 2450
order to supplier: creation 149.00 209 7450
order to supplier: removal 10.38 8653 519
invoice (draft): creation 147.16 354 7358
invoice (draft): removal 100.88 135 5044
invoice accept: apply 126.50 1462 6325
invoice accept: cancel 83.66 221 4183
customer reserve: creation 5665.58 27 283279
customer reserve: removal 4031.30 16 201565
realization accept: apply 272.86 37 13643
realization accept: cancel 151.32 20 7566
payment from customer: creation 194.10 38 9705
payment from customer: removal 17.80 19 890
payment to supplier: creation 160.64 31 8032
payment to supplier: removal 11.08 20 554
service: total inventory turnovers 19.26 1795 963
service: total monetary turnovers 47.48 11 2374
service: aggregate perf. data 4.72 1404 236
service: refresh index statistics 0.04 4727 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 02-11-2026 15:51:09 to 02-11-2026 15:51:10.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5490
TEST_TIME 2 6631
TEST_TIME 3 7427
TEST_TIME 4 7904
TEST_TIME 5 8341
TEST_TIME 6 8602
TEST_TIME 7 8918
TEST_TIME 8 8806
TEST_TIME 9 8752
TEST_TIME 10 9013
TEST_TIME 11 9177
TEST_TIME 12 9293
TEST_TIME 13 9369
TEST_TIME 14 9623
TEST_TIME 15 9715
TEST_TIME 16 9714
TEST_TIME 17 9916
TEST_TIME 18 9917
TEST_TIME 19 10137
TEST_TIME 20 10172
TEST_TIME 21 10187
TEST_TIME 22 10174
TEST_TIME 23 10322
TEST_TIME 24 10280
TEST_TIME 25 10480
TEST_TIME 26 10488
TEST_TIME 27 10615
TEST_TIME 28 10633
TEST_TIME 29 10702
TEST_TIME 30 10699
TEST_TIME 31 10767
TEST_TIME 32 10887
TEST_TIME 33 10881
TEST_TIME 34 11085
TEST_TIME 35 11086
TEST_TIME 36 11143
TEST_TIME 37 11234
TEST_TIME 38 11293
TEST_TIME 39 11360
TEST_TIME 40 11386
TEST_TIME 41 11491
TEST_TIME 42 11506
TEST_TIME 43 11562
TEST_TIME 44 11614
TEST_TIME 45 11637
TEST_TIME 46 11691
TEST_TIME 47 11677
TEST_TIME 48 11777
TEST_TIME 49 11839
TEST_TIME 50 11825

Performance per minute, chart


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

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 876852 876852 0 0.00 0 1381 2 0 0
doc_list_biud 876852 876852 0 0.00 0 3794 6 0 0
sp_add_invoice_to_stock 6325 6325 0 0.00 6 15312 1462 0 0
sp_cancel_adding_invoice 4183 4183 0 0.00 3 8951 222 0 0
sp_cancel_client_order 2450 2450 0 0.00 2 1974 59 0 0
sp_cancel_customer_reserve 201565 201565 0 0.00 1 3795 17 0 0
sp_cancel_pay_from_customer 890 890 0 0.00 1 428 20 0 0
sp_cancel_pay_to_supplier 554 554 0 0.00 2 541 20 0 0
sp_cancel_supplier_invoice 5044 5044 0 0.00 1 1527 136 0 0
sp_cancel_supplier_order 519 519 0 0.00 7 47388 8653 0 0
sp_cancel_write_off 7566 7566 0 0.00 1 2604 21 0 0
sp_client_order 29109 29109 0 0.00 3 3051 49 0 0
sp_customer_reserve 283279 283279 0 0.00 0 3589 28 0 0
sp_fill_shopping_cart 43917 43917 0 0.00 0 2888 18 0 0
sp_fill_shopping_cart_clo_res 283279 283279 0 0.00 0 1440 2 0 0
sp_get_clo_for_invoice 6325 6325 0 0.00 0 1817 33 0 0
sp_kill_cost_storno 13193 13193 0 0.00 0 1147 9 0 0
sp_kill_qstorno_ret_qs2qd 416259 416259 0 0.00 0 3586 8 0 0
sp_kill_qty_storno 241295 241295 0 0.00 0 3793 19 0 0
sp_lock_selected_doc 27788 27788 0 0.00 0 838 1 0 0
sp_make_cost_storno 37705 37705 0 0.00 0 1064 7 0 0
sp_multiply_rows_for_pdistr 37705 37705 0 0.00 0 1019 11 0 0
sp_multiply_rows_for_qdistr 29109 29109 0 0.00 0 1485 19 0 0
sp_pay_from_customer 9705 9705 0 0.00 2 2084 38 0 0
sp_pay_to_supplier 8032 8032 0 0.00 2 1963 31 0 0
sp_payment_common 17737 17737 0 0.00 0 882 8 0 0
sp_qd_handle_on_cancel_clo 2450 2450 0 0.00 0 1482 42 0 0
sp_qd_handle_on_invoice_upd_sts 10508 10508 0 0.00 0 2731 66 0 0
sp_qd_handle_on_reserve_upd_sts 13643 13643 0 0.00 0 3083 13 0 0
sp_reserve_write_off 13643 13643 0 0.00 2 3087 37 0 0
sp_supplier_invoice 7358 7358 0 0.00 4 5091 354 0 0
sp_supplier_order 7450 7450 0 0.00 3 4490 209 0 0
srv_aggregate_perf_data 236 236 0 0.00 0 6173 1404 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 3 824 367 0 0
srv_find_qd_qs_mism 549483 549483 0 0.00 0 1380 1 0 0
srv_make_invnt_saldo 963 963 0 0.00 1 5928 1796 0 0
srv_make_money_saldo 2374 2374 0 0.00 0 246 11 0 0
srv_recalc_idx_stat 2 2 0 0.00 583 8872 4728 0 0
v_add_invoice_to_stock 12650 12650 0 0.00 0 724 2 0 0
v_all_customers 44540 44540 0 0.00 0 54 0 0 0
v_all_suppliers 36120 36120 0 0.00 0 166 0 0 0
v_all_wares 58218 58218 0 0.00 0 184 0 0 0
v_cancel_adding_invoice 1130 1130 0 0.00 0 819 4 0 0
v_cancel_client_order 4900 4900 0 0.00 0 1970 2 0 0
v_cancel_customer_prepayment 1780 1780 0 0.00 0 77 2 0 0
v_cancel_customer_reserve 1888 1888 0 0.00 0 284 2 0 0
v_cancel_payment_to_supplier 1108 1108 0 0.00 0 204 2 0 0
v_cancel_supplier_invoice 1026 1026 0 0.00 0 810 4 0 0
v_cancel_supplier_order 1038 1038 0 0.00 0 869 3 0 0
v_cancel_write_off 2770 2770 0 0.00 0 676 2 0 0
v_max_id_clo_ord 7450 7450 0 0.00 0 540 1 0 0
v_max_id_clo_res 1379 1379 0 0.00 0 1166 2 0 0
v_max_id_ord_sup 7358 7358 0 0.00 0 762 2 0 0
v_max_non_paid_invoice 4780 4780 0 0.00 0 104 2 0 0
v_max_non_paid_realizn 9338 9338 0 0.00 0 104 1 0 0
v_min_id_clo_ord 7450 7450 0 0.00 0 494 2 0 0
v_min_id_clo_res 1379 1379 0 0.00 0 1157 10 0 0
v_min_id_ord_sup 7358 7358 0 0.00 0 1548 6 0 0
v_min_non_paid_invoice 8032 8032 0 0.00 0 586 3 0 0
v_min_non_paid_realizn 9705 9705 0 0.00 0 789 4 0 0
v_our_firm 14412 14412 0 0.00 0 54 1 0 0
v_reserve_write_off 27286 27286 0 0.00 0 736 1 0 0
x_lock_depdocs_on_canc_invoice 8714 8714 0 0.00 0 1344 9 0 0
x_lock_depdocs_on_canc_sup_ord 519 519 0 0.00 0 338 10 0 0
x_make_qstorno_1000_1200 7450 7450 0 0.00 1 4472 157 0 0
x_make_qstorno_1200_2000 7358 7358 0 0.00 1 5060 310 0 0
x_make_qstorno_2100_3300 283279 283279 0 0.00 0 3587 24 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 02-11-2026 15:51:13 to 02-11-2026 15:51:17.

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:52 3 2147483648 2253167280 2255597568 4078656 0.189 1 1 2 0 4147712 60512 8544
15:01:54 223 2147483648 2524622288 2799947776 269939712 11.166 20 16 30 1 271373696 898432 535552
15:02:55 251 2147483648 2525224816 2766901248 270815184 11.198 20 11 20 1 272028432 778272 434976
15:03:55 481 2147483648 2514308000 2752114688 252954592 10.537 19 11 23 0 255345808 2020144 371072
15:04:56 388 2147483648 2529228624 2771947520 272384496 11.256 20 8 16 0 277086176 4448752 252928
15:05:57 339 2147483648 2491538672 2700251136 233043040 9.789 19 7 12 0 234297328 1061456 192832
15:06:58 364 2147483648 2525764336 2768482304 269919584 11.165 20 9 18 1 272688048 2501520 266944
15:07:59 327 2147483648 2505341712 2723721216 247970656 10.351 20 10 21 0 251066864 2694944 401264
15:08:59 206 2147483648 2526473952 2769084416 269107392 11.135 20 12 21 1 272265568 2776640 381536
15:10:00 442 2147483648 2528550560 2782625792 271645696 11.229 20 8 16 0 274404880 2403712 355472
15:11:01 606 2147483648 2521931648 2752995328 261669232 10.861 20 9 18 0 268380288 6424272 286784
15:12:02 260 2147483648 2530933872 2778275840 272557472 11.262 20 6 12 0 276068960 3321168 190320
15:13:03 249 2147483648 2530824688 2781151232 271621168 11.228 20 9 18 0 277862512 5886512 354832
15:14:04 419 2147483648 2532695728 2769932288 266911856 11.055 20 7 14 0 278239152 10999568 327728
15:15:05 618 2147483648 2537520528 2781085696 269335552 11.144 20 9 18 0 282417408 12704624 377232
15:16:06 265 2147483648 2503858880 2727006208 247410896 10.330 19 8 16 1 250288240 2573472 303872
15:17:06 343 2147483648 2529403872 2768363520 267511632 11.077 20 8 14 1 274769536 6925776 332128
15:18:07 601 2147483648 2536085664 2781564928 270660800 11.192 20 14 28 0 280196240 8872288 663152
15:19:08 333 2147483648 2530773472 2756075520 257980688 10.724 20 9 18 0 276273904 17810384 482832
15:20:09 351 2147483648 2532256032 2772238336 269146688 11.137 20 6 12 0 276719408 7336640 236080
15:21:10 824 2147483648 2528745504 2773938176 266599952 11.043 20 5 10 0 274762080 7858816 303312
15:22:12 411 2147483648 2534895984 2778615808 270443952 11.184 20 13 24 1 280986112 9963216 578944
15:23:13 558 2147483648 2535398832 2775646208 270364944 11.182 20 10 19 0 280607920 9858432 384544
15:24:14 340 2147483648 2531714816 2777673728 272456512 11.258 20 12 24 0 276038768 3139968 442288
15:25:15 341 2147483648 2535702912 2778726400 273127216 11.283 20 12 24 0 280165264 6574000 464048
15:26:18 343 2147483648 2532227904 2775388160 272332224 11.254 20 12 24 0 277073648 4207568 533856
15:27:19 412 2147483648 2547260160 2791645184 273781968 11.307 20 12 23 0 290744608 16463648 498992
15:28:20 364 2147483648 2518467536 2748612608 255845104 10.645 19 12 22 2 263143664 6755856 542704
15:29:20 393 2147483648 2528877968 2768904192 267515840 11.077 20 13 26 0 273353552 5364192 473520
15:30:21 222 2147483648 2534741168 2770522112 275440288 11.368 20 10 19 1 279889680 3977280 472112
15:31:23 220 2147483648 2536956288 2789941248 271951456 11.240 20 8 16 0 279594544 7332416 310672
15:32:24 444 2147483648 2551417328 2794782720 267492064 11.076 20 8 16 1 294363488 26411008 460416
15:33:25 406 2147483648 2539954528 2785624064 269064128 11.134 20 12 24 1 283182432 13438576 679728
15:34:26 216 2147483648 2549224688 2799046656 266322848 11.033 20 10 19 0 293037712 26264000 450864
15:35:27 472 2147483648 2524628144 2760593408 260350352 10.812 20 6 12 0 268480608 7930704 199552
15:36:27 219 2147483648 2526648512 2764533760 262689824 10.899 20 9 16 1 270184944 7181952 313168
15:37:28 187 2147483648 2538527456 2778632192 266887408 11.054 20 8 16 0 283470336 16232096 350832
15:38:29 278 2147483648 2534216832 2784952320 269704144 11.157 20 7 14 1 277910144 7902944 303056
15:39:29 221 2147483648 2541133216 2794078208 267188160 11.065 20 11 20 2 286427392 18668976 570256
15:40:30 293 2147483648 2525585616 2771312640 264667680 10.972 20 13 24 1 269850640 4600032 582928
15:41:30 344 2147483648 2541446720 2782572544 266194208 11.028 20 13 26 0 284989184 18255840 539136
15:42:31 327 2147483648 2526464768 2766139392 259876576 10.795 20 11 21 0 269382848 9135664 370608
15:43:32 184 2147483648 2528041632 2777051136 266591568 11.043 20 11 22 0 271888176 4877168 419440
15:44:33 479 2147483648 2538631568 2786279424 268564080 11.115 20 11 22 0 282599616 13530672 504864
15:45:34 525 2147483648 2539001328 2783875072 268370464 11.108 20 13 26 0 282370208 13490288 509456
15:46:35 328 2147483648 2549779840 2793709568 268230080 11.103 20 12 24 0 292835616 24077920 527616
15:47:36 408 2147483648 2519768224 2756370432 254922608 10.611 19 6 12 0 263651520 8423968 304944
15:48:37 418 2147483648 2536335136 2773065728 262028880 10.874 20 10 20 0 280622992 18212448 381664
15:49:38 434 2147483648 2548679072 2794237952 268765984 11.123 20 14 28 0 291853040 22534736 552320
15:50:39 376 2147483648 2553771376 2797539328 270191776 11.175 20 9 18 1 298363504 27751952 419776

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 02-11-2026 15:51:18 to 02-11-2026 15:51:32.

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 02-11-2026 15:51:32 to 02-11-2026 15:51:33.

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          197406
MON$OLDEST_ACTIVE               198294
MON$OLDEST_SNAPSHOT             198294
MON$NEXT_TRANSACTION            198294
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-02 12:00:11.2120 GMT
MON$PAGES                       161432
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                        {634C1694-2F5C-4937-A868-DB5398AAD471}
MON$FILE_ID                     0108000000000000c2ed070000000000
MON$NEXT_ATTACHMENT             546
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'

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