Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 09.11.2026 13: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 3666272 kB
MemAvailable 7498052 kB
Buffers 82640 kB
Cached 3919060 kB
SwapCached 0 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, Legacy_Auth Srp256, Srp, Legacy_Auth
AuthServer Srp256 Srp256
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
DummyPacketInterval 0 0
EventMemSize 65536 65536
ExtConnPoolLifeTime 7200 7200
ExtConnPoolSize 0 0
ExternalFileAccess None None
FileSystemCacheSize 0 0
FileSystemCacheThreshold 65536 65536
GCPolicy combined combined
GuardianOption 1 1
IPv6V6Only false false
InlineSortThreshold 1000 1000
IpcName oemul_fb50SS FirebirdIPI [ X ] firebird.conf
KeyHolderPlugin [empty] [empty]
LegacyHash true true
LockAcquireSpins 0 0
LockHashSlots 30011 8191 [ X ] firebird.conf
LockMemSize 10485760 1048576 [ X ] firebird.conf
MaxIdentifierByteLength 252 252
MaxIdentifierCharLength 63 63
MaxParallelWorkers 1 1
MaxStatementCacheSize 2097152 2097152
MaxUnflushedWriteTime -1 -1
MaxUnflushedWrites -1 -1
MaxUserTraceLogSize 10 10
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 3500 0 [ X ] firebird.conf
SecurityDatabase /opt/fb50/security5.fdb /opt/fb50/security5.fdb
ServerMode Super Super [ X ] firebird.conf
SnapshotsMemSize 65536 65536
StatementTimeout 0 0
SubQueryConversion false false
TcpNoNagle true true
TcpRemoteBufferSize 8192 8192
TempBlockSize 1048576 1048576
TempCacheLimit 536870912 67108864 [ X ] firebird.conf
TempDirectories
TempTableDirectory [empty] [empty]
TipCacheBlockSize 4194304 4194304
TraceDSQL 0 0
TracePlugin fbtrace fbtrace
UdfAccess Restrict UDF None [ X ] firebird.conf
UseFileSystemCache true true [ X ] firebird.conf
UserManager Srp Srp
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-fb50.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-fb50.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/fb50/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=3500
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-fb50-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-fb50
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-09 13:50:42
DTS_END                         2026-11-09 13:50:42.5920
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/38818
TRN_ID                          216328
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: 13920.14 958 696007
customer order: creation 635.36 41 31768
customer order: refuse 52.44 218 2622
order to supplier: creation 165.00 191 8250
order to supplier: removal 11.80 8632 590
invoice (draft): creation 161.72 326 8086
invoice (draft): removal 115.42 134 5771
invoice accept: apply 138.60 1360 6930
invoice accept: cancel 94.74 203 4737
customer reserve: creation 6649.32 24 332466
customer reserve: removal 4927.02 14 246351
realization accept: apply 299.96 31 14998
realization accept: cancel 173.50 18 8675
payment from customer: creation 209.70 32 10485
payment from customer: removal 21.36 17 1068
payment to supplier: creation 175.18 26 8759
payment to supplier: removal 12.20 18 610
service: total inventory turnovers 20.70 1638 1035
service: total monetary turnovers 50.88 12 2544
service: aggregate perf. data 5.18 1334 259
service: refresh index statistics 0.06 4899 3

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 9465
TEST_TIME 2 10505
TEST_TIME 3 10884
TEST_TIME 4 11398
TEST_TIME 5 11571
TEST_TIME 6 11725
TEST_TIME 7 11921
TEST_TIME 8 12214
TEST_TIME 9 12496
TEST_TIME 10 12580
TEST_TIME 11 12486
TEST_TIME 12 12742
TEST_TIME 13 12784
TEST_TIME 14 12644
TEST_TIME 15 12671
TEST_TIME 16 12812
TEST_TIME 17 12758
TEST_TIME 18 12913
TEST_TIME 19 12899
TEST_TIME 20 13082
TEST_TIME 21 12950
TEST_TIME 22 12925
TEST_TIME 23 12961
TEST_TIME 24 12844
TEST_TIME 25 12936
TEST_TIME 26 12912
TEST_TIME 27 12918
TEST_TIME 28 12973
TEST_TIME 29 13013
TEST_TIME 30 12990
TEST_TIME 31 13090
TEST_TIME 32 13029
TEST_TIME 33 13210
TEST_TIME 34 13291
TEST_TIME 35 13356
TEST_TIME 36 13446
TEST_TIME 37 13464
TEST_TIME 38 13550
TEST_TIME 39 13541
TEST_TIME 40 13618
TEST_TIME 41 13626
TEST_TIME 42 13717
TEST_TIME 43 13783
TEST_TIME 44 13822
TEST_TIME 45 13806
TEST_TIME 46 13727
TEST_TIME 47 13856
TEST_TIME 48 13945
TEST_TIME 49 13937
TEST_TIME 50 13920

Performance per minute, chart


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

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 1026640 1026640 0 0.00 0 2296 2 0 0
doc_list_biud 1026640 1026640 0 0.00 0 2994 6 0 0
sp_add_invoice_to_stock 6930 6930 0 0.00 2 16745 1361 0 0
sp_cancel_adding_invoice 4737 4737 0 0.00 2 4931 204 0 0
sp_cancel_client_order 2622 2622 0 0.00 2 2311 218 0 0
sp_cancel_customer_reserve 246351 246351 0 0.00 1 2338 15 0 0
sp_cancel_pay_from_customer 1068 1068 0 0.00 1 676 18 0 0
sp_cancel_pay_to_supplier 610 610 0 0.00 1 483 19 0 0
sp_cancel_supplier_invoice 5771 5771 0 0.00 1 2355 135 0 0
sp_cancel_supplier_order 590 590 0 0.00 3 58994 8633 0 0
sp_cancel_write_off 8675 8675 0 0.00 1 1574 19 0 0
sp_client_order 31768 31768 0 0.00 2 1941 42 0 0
sp_customer_reserve 332466 332466 0 0.00 0 3004 24 0 0
sp_fill_shopping_cart 48104 48104 0 0.00 0 2753 17 0 0
sp_fill_shopping_cart_clo_res 332466 332466 0 0.00 0 1589 2 0 0
sp_get_clo_for_invoice 6930 6930 0 0.00 0 2652 33 0 0
sp_kill_cost_storno 15090 15090 0 0.00 0 1096 9 0 0
sp_kill_qstorno_ret_qs2qd 507738 507738 0 0.00 0 2994 8 0 0
sp_kill_qty_storno 290674 290674 0 0.00 0 2994 19 0 0
sp_lock_selected_doc 30568 30568 0 0.00 0 759 1 0 0
sp_make_cost_storno 41172 41172 0 0.00 0 1213 7 0 0
sp_multiply_rows_for_pdistr 41172 41172 0 0.00 0 1209 9 0 0
sp_multiply_rows_for_qdistr 31768 31768 0 0.00 0 1493 17 0 0
sp_pay_from_customer 10485 10485 0 0.00 2 1479 33 0 0
sp_pay_to_supplier 8759 8759 0 0.00 2 1062 27 0 0
sp_payment_common 19244 19244 0 0.00 0 917 6 0 0
sp_qd_handle_on_cancel_clo 2622 2622 0 0.00 0 2292 206 0 0
sp_qd_handle_on_invoice_upd_sts 11667 11667 0 0.00 0 2358 63 0 0
sp_qd_handle_on_reserve_upd_sts 14998 14998 0 0.00 0 1257 9 0 0
sp_reserve_write_off 14998 14998 0 0.00 2 1942 32 0 0
sp_supplier_invoice 8086 8086 0 0.00 3 6333 326 0 0
sp_supplier_order 8250 8250 0 0.00 3 2484 191 0 0
srv_aggregate_perf_data 259 259 0 0.00 50 8035 1335 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 4 513 291 0 0
srv_find_qd_qs_mism 648196 648196 0 0.00 0 2296 1 0 0
srv_make_invnt_saldo 1035 1035 0 0.00 1 4954 1639 0 0
srv_make_money_saldo 2544 2544 0 0.00 0 347 13 0 0
srv_recalc_idx_stat 3 3 0 0.00 578 13191 4899 0 0
v_add_invoice_to_stock 13860 13860 0 0.00 0 676 2 0 0
v_all_customers 48336 48336 0 0.00 0 51 0 0 0
v_all_suppliers 40186 40186 0 0.00 0 85 0 0 0
v_all_wares 63536 63536 0 0.00 0 51 0 0 0
v_cancel_adding_invoice 1254 1254 0 0.00 0 344 2 0 0
v_cancel_client_order 5244 5244 0 0.00 0 596 2 0 0
v_cancel_customer_prepayment 2136 2136 0 0.00 0 674 2 0 0
v_cancel_customer_reserve 2086 2086 0 0.00 0 333 2 0 0
v_cancel_payment_to_supplier 1220 1220 0 0.00 0 475 2 0 0
v_cancel_supplier_invoice 1218 1218 0 0.00 0 621 3 0 0
v_cancel_supplier_order 1180 1180 0 0.00 0 480 2 0 0
v_cancel_write_off 2942 2942 0 0.00 0 331 2 0 0
v_max_id_clo_ord 8250 8250 0 0.00 0 637 1 0 0
v_max_id_clo_res 1504 1504 0 0.00 0 836 2 0 0
v_max_id_ord_sup 8086 8086 0 0.00 0 1300 2 0 0
v_max_non_paid_invoice 5002 5002 0 0.00 0 56 1 0 0
v_max_non_paid_realizn 10164 10164 0 0.00 0 77 1 0 0
v_min_id_clo_ord 8250 8250 0 0.00 0 668 2 0 0
v_min_id_clo_res 1504 1504 0 0.00 0 740 4 0 0
v_min_id_ord_sup 8086 8086 0 0.00 0 1223 3 0 0
v_min_non_paid_invoice 8759 8759 0 0.00 0 362 2 0 0
v_min_non_paid_realizn 10485 10485 0 0.00 0 446 2 0 0
v_our_firm 15842 15842 0 0.00 0 39 1 0 0
v_reserve_write_off 29996 29996 0 0.00 0 418 1 0 0
x_lock_depdocs_on_canc_invoice 9899 9899 0 0.00 0 1002 9 0 0
x_lock_depdocs_on_canc_sup_ord 590 590 0 0.00 0 188 10 0 0
x_make_qstorno_1000_1200 8250 8250 0 0.00 1 2319 141 0 0
x_make_qstorno_1200_2000 8086 8086 0 0.00 1 5787 288 0 0
x_make_qstorno_2100_3300 332466 332466 0 0.00 0 3003 21 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 09-11-2026 13:51:01 to 09-11-2026 13:51:05.

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
13:00:46 4 2147483648 2253215136 2255597568 4112736 0.191 1 1 2 0 4181792 60512 8544
13:01:47 286 2147483648 2515799584 2785140736 258791584 10.754 20 11 24 0 260367376 1116976 458816
13:02:48 318 2147483648 2528441168 2778386432 270090368 11.171 20 12 25 0 275067456 4524016 453072
13:03:48 226 2147483648 2526676704 2775019520 272336816 11.254 20 6 12 0 273653184 1092848 223520
13:04:49 257 2147483648 2524617872 2747535360 261005312 10.836 20 10 20 0 270399744 8921536 472896
13:05:50 218 2147483648 2524174544 2773270528 268236144 11.103 20 10 19 2 269982480 1386480 359856
13:06:51 250 2147483648 2526819008 2773716992 271278224 11.215 20 11 22 0 275504192 3717984 507984
13:07:51 272 2147483648 2522260048 2758049792 263027888 10.911 20 10 19 0 267809568 4297824 483856
13:08:52 246 2147483648 2529891360 2763247616 267516736 11.077 20 12 24 0 274640128 6685104 438288
13:09:52 290 2147483648 2542870208 2796359680 274751536 11.342 20 7 14 0 288264416 13132672 380208
13:10:53 199 2147483648 2529873520 2768777216 270990528 11.205 20 9 18 0 273519792 2203440 325824
13:11:54 189 2147483648 2540423264 2780315648 268421712 11.110 20 9 18 0 284947328 16075024 450592
13:12:54 460 2147483648 2535877360 2783088640 274453088 11.331 20 10 20 0 281110848 6269312 388448
13:13:55 320 2147483648 2526985664 2768482304 270637808 11.192 20 8 16 0 272790912 1879216 273888
13:14:56 333 2147483648 2522884288 2764378112 265057536 10.986 20 16 30 0 267284416 1691280 535600
13:15:57 284 2147483648 2532306864 2779181056 266732784 11.048 20 11 21 0 276495584 9325248 437552
13:16:57 222 2147483648 2532381840 2772238336 270647904 11.192 20 9 18 0 276526192 5546720 331568
13:17:58 492 2147483648 2542271904 2785226752 271449440 11.221 20 9 18 0 285661376 13822272 389664
13:18:59 148 2147483648 2516672160 2738827264 256856176 10.683 20 10 20 0 260775168 3536928 382064
13:19:59 384 2147483648 2537174816 2778832896 271287632 11.215 20 13 25 0 282082032 10266288 528112
13:21:00 298 2147483648 2535237824 2783891456 276546640 11.408 20 8 16 0 280048416 3155552 346224
13:22:01 351 2147483648 2526532112 2763472896 266752208 11.049 20 14 28 0 270827152 3487984 586960
13:23:02 306 2147483648 2522686864 2744147968 254582048 10.598 20 9 18 0 268219584 13235072 402464
13:24:02 210 2147483648 2539094672 2782650368 275206688 11.359 20 15 26 3 282985200 7090032 688480
13:25:03 169 2147483648 2534580704 2763198464 263520336 10.929 20 13 25 0 279935072 15806912 607824
13:26:03 295 2147483648 2539777872 2780086272 273764224 11.306 20 16 32 0 283476720 8983472 729024
13:27:04 340 2147483648 2551812384 2796965888 276538544 11.408 20 13 27 1 296767136 19577488 651104
13:28:04 163 2147483648 2550618864 2789560320 271887744 11.237 20 12 24 0 294365696 21903440 574512
13:29:05 285 2147483648 2543335968 2790305792 275208560 11.359 20 12 24 1 288115456 12318608 588288
13:30:06 205 2147483648 2513596560 2742321152 246764992 10.306 20 8 17 0 255798208 8648304 384912
13:31:07 398 2147483648 2548321872 2793385984 277900288 11.457 20 14 28 0 290495232 11970048 624896
13:32:08 257 2147483648 2529503072 2780192768 274830528 11.345 20 5 10 0 276353296 1281696 241072
13:33:09 276 2147483648 2530073264 2767986688 258730864 10.752 19 9 18 0 274315504 15248208 336432
13:34:10 319 2147483648 2541779872 2790998016 270834672 11.199 20 10 20 0 285879712 14621888 423152
13:35:10 177 2147483648 2527868816 2771738624 266190352 11.028 20 9 19 0 270911920 4317360 404208
13:36:10 300 2147483648 2518365040 2754076672 253868640 10.571 19 7 14 0 263025008 8848208 308160
13:37:11 262 2147483648 2533511840 2769408000 260118176 10.804 20 10 21 0 278540464 17871232 551056
13:38:12 311 2147483648 2539305248 2779844608 267311776 11.069 20 11 22 0 284197552 16468720 417056
13:39:12 285 2147483648 2535855856 2775351296 266951072 11.056 20 11 23 0 278803136 11361056 491008
13:40:14 431 2147483648 2541003776 2793259008 270225648 11.176 20 7 14 0 283689856 13174480 289728
13:41:15 188 2147483648 2524692384 2759012352 259384352 10.776 20 10 20 0 268301024 8465568 451104
13:42:15 348 2147483648 2532821456 2764611584 260405232 10.814 20 17 34 0 274995520 13940544 649744
13:43:16 409 2147483648 2532364736 2774253568 264091040 10.950 20 7 12 0 274003440 9729760 182640
13:44:17 223 2147483648 2524673440 2780082176 266166816 11.027 20 12 25 0 269602816 2903488 532512
13:45:18 285 2147483648 2537836176 2781290496 265908752 11.018 20 10 20 1 281797696 15438224 450720
13:46:19 421 2147483648 2531199184 2780672000 269703280 11.157 20 12 24 0 273406064 3085792 616992
13:47:20 249 2147483648 2546090592 2805780480 269994400 11.168 20 9 18 0 290729920 20292480 443040
13:48:21 252 2147483648 2524716720 2762346496 262044704 10.875 20 13 26 0 267485904 4915872 525328
13:49:21 407 2147483648 2544569712 2781900800 264607088 10.970 20 11 22 0 286614656 21553056 454512
13:50:24 502 2147483648 2533277200 2782072832 268312016 11.106 20 10 20 0 276002096 7299728 390352

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:12, from 09-11-2026 13:51:05 to 09-11-2026 13:51:17.

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 09-11-2026 13:51:17 to 09-11-2026 13:51:18.

Content of mon$database and FB version


MON$DATABASE_NAME               /var/db/oltp-emul/oltp-fb50.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   1
MON$OLDEST_TRANSACTION          216492
MON$OLDEST_ACTIVE               216493
MON$OLDEST_SNAPSHOT             216493
MON$NEXT_TRANSACTION            216493
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-09 10:00:09.8400 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                        {740AFF06-D56F-44F8-B6B2-994EE1725602}
MON$FILE_ID                     01080000000000007aed070000000000
MON$NEXT_ATTACHMENT             578
MON$NEXT_STATEMENT              512
MON$REPLICA_MODE                0


ISQL Version: LI-V5.0.5.1956 Firebird 5.0 35c6556
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V5.0.5.1956 Firebird 5.0 35c6556"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V5.0.5.1956 Firebird 5.0 35c6556/tcp (test-0)/P19:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V5.0.5.1956 Firebird 5.0 35c6556/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-fb50 according to config parameter 'remove_isql_logs'

09.11.26 13:51:18. There are 3 logs in /var/tmp/logs.oltp-fb50 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-09 13:51:19 No severe PSQL-related problems occured
09.11.26 13:51:19. End of report.