Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 13.11.2026 12: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 6d
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 1761724 kB
MemAvailable 7439296 kB
Buffers 81148 kB
Cached 5717312 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, 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
GCPolicy combined combined
GuardianOption 1 1
IPv6V6Only false false
InlineSortThreshold 1000 1000
IpcName oemul_fb60SS 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
MaxParallelWorkers 1 1
MaxStatementCacheSize 2097152 2097152
MaxUnflushedWriteTime -1 -1
MaxUnflushedWrites -1 -1
MaxUserTraceLogSize 10 10
OnDisconnectTriggerTimeout 180 180
OptimizeForFirstRows false false
OutputRedirectionFile /dev/null /dev/null
ParallelWorkers 1 1
ProcessPriorityLevel 0 0
Providers Remote, Engine14, Loopback Remote, Engine14, Loopback
ReadConsistency true true
RemoteAccess true true
RemoteAuxPort 0 0
RemoteBindAddress
RemoteFileOpenAbility false false
RemoteServiceName gds_db gds_db
RemoteServicePort 3600 0 [ X ] firebird.conf
RemoteServiceUnixSocket
SecurityDatabase /opt/fb60/security6.fdb /opt/fb60/security6.fdb
ServerMode Super Super [ X ] firebird.conf
SnapshotsMemSize 65536 65536
StatementTimeout 0 0
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-fb60.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    262144
PAGE_SIZE                       8192


Test configuration settings

param=OLTP_ROOT_DIR, val=/mnt/oltp-emul
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-fb60.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/var/db/oltp-emul/oltp_60.etalone.fdb
param=expected_workers, val=100
param=fbc, val=/opt/fb60/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=red
param=html_chart_color_memo_att, val=red
param=html_chart_color_memo_stm, val=red
param=html_chart_color_memo_trn, val=red
param=html_chart_color_perf_score, val=red
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=3600
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-fb60-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-fb60
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-13 12:50:51
DTS_END                         2026-11-13 12:50:51.5290
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(211:18) ==> SP_CANCEL_CUSTOMER_RESERVE(55:5) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(98:17)
IP                              ::1/52256
TRN_ID                          178369
ATT_ID                          382
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: 10443.58 1122 522179
customer order: creation 526.78 43 26339
customer order: refuse 44.04 77 2202
order to supplier: creation 135.78 371 6789
order to supplier: removal 10.00 10118 500
invoice (draft): creation 130.56 2203 6528
invoice (draft): removal 90.48 172 4524
invoice accept: apply 113.42 1421 5671
invoice accept: cancel 75.52 226 3776
customer reserve: creation 4986.26 27 249313
customer reserve: removal 3535.44 21 176772
realization accept: apply 246.90 29 12345
realization accept: cancel 132.84 19 6642
payment from customer: creation 174.54 31 8727
payment from customer: removal 16.08 20 804
payment to supplier: creation 144.50 25 7225
payment to supplier: removal 9.48 16 474
service: total inventory turnovers 23.60 1154 1180
service: total monetary turnovers 43.14 9 2157
service: aggregate perf. data 4.18 1698 209
service: refresh index statistics 0.04 4765 2

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8354
TEST_TIME 2 8933
TEST_TIME 3 9449
TEST_TIME 4 9799
TEST_TIME 5 9762
TEST_TIME 6 9891
TEST_TIME 7 10163
TEST_TIME 8 10290
TEST_TIME 9 10378
TEST_TIME 10 10400
TEST_TIME 11 10445
TEST_TIME 12 10451
TEST_TIME 13 10365
TEST_TIME 14 10437
TEST_TIME 15 10395
TEST_TIME 16 10469
TEST_TIME 17 10361
TEST_TIME 18 10472
TEST_TIME 19 10461
TEST_TIME 20 10479
TEST_TIME 21 10623
TEST_TIME 22 10639
TEST_TIME 23 10672
TEST_TIME 24 10738
TEST_TIME 25 10653
TEST_TIME 26 10666
TEST_TIME 27 10601
TEST_TIME 28 10668
TEST_TIME 29 10702
TEST_TIME 30 10660
TEST_TIME 31 10683
TEST_TIME 32 10676
TEST_TIME 33 10674
TEST_TIME 34 10707
TEST_TIME 35 10644
TEST_TIME 36 10632
TEST_TIME 37 10655
TEST_TIME 38 10639
TEST_TIME 39 10645
TEST_TIME 40 10655
TEST_TIME 41 10641
TEST_TIME 42 10624
TEST_TIME 43 10680
TEST_TIME 44 10644
TEST_TIME 45 10583
TEST_TIME 46 10561
TEST_TIME 47 10579
TEST_TIME 48 10539
TEST_TIME 49 10541
TEST_TIME 50 10444

Performance per minute, chart


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

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 774738 774738 0 0.00 0 1589 2 0 0
doc_list_biud 774738 774738 0 0.00 0 2594 7 0 0
sp_add_invoice_to_stock 5671 5671 0 0.00 6 15183 1421 0 0
sp_cancel_adding_invoice 3776 3776 0 0.00 3 7269 227 0 0
sp_cancel_client_order 2202 2202 0 0.00 2 1275 77 0 0
sp_cancel_customer_reserve 176772 176772 0 0.00 1 2595 22 0 0
sp_cancel_pay_from_customer 804 804 0 0.00 2 1949 21 0 0
sp_cancel_pay_to_supplier 474 474 0 0.00 2 442 16 0 0
sp_cancel_supplier_invoice 4524 4524 0 0.00 1 1950 173 0 0
sp_cancel_supplier_order 500 500 0 0.00 11 85475 10119 0 0
sp_cancel_write_off 6642 6642 0 0.00 1 1476 20 0 0
sp_client_order 26339 26339 0 0.00 2 2677 44 0 0
sp_customer_reserve 249313 249313 0 0.00 0 4518 27 0 0
sp_fill_shopping_cart 39656 39656 0 0.00 0 10979 351 0 0
sp_fill_shopping_cart_clo_res 249313 249313 0 0.00 0 1295 2 0 0
sp_get_clo_for_invoice 5671 5671 0 0.00 0 1287 34 0 0
sp_kill_cost_storno 11696 11696 0 0.00 0 806 8 0 0
sp_kill_qstorno_ret_qs2qd 365210 365210 0 0.00 0 2491 11 0 0
sp_kill_qty_storno 212432 212432 0 0.00 0 2594 23 0 0
sp_lock_selected_doc 25015 25015 0 0.00 0 296 1 0 0
sp_make_cost_storno 33968 33968 0 0.00 0 480 6 0 0
sp_multiply_rows_for_pdistr 33968 33968 0 0.00 0 818 8 0 0
sp_multiply_rows_for_qdistr 26339 26339 0 0.00 0 1239 15 0 0
sp_pay_from_customer 8727 8727 0 0.00 2 1456 31 0 0
sp_pay_to_supplier 7225 7225 0 0.00 2 2112 26 0 0
sp_payment_common 15952 15952 0 0.00 0 2109 8 0 0
sp_qd_handle_on_cancel_clo 2202 2202 0 0.00 0 1259 55 0 0
sp_qd_handle_on_invoice_upd_sts 9447 9447 0 0.00 0 1717 61 0 0
sp_qd_handle_on_reserve_upd_sts 12345 12345 0 0.00 0 1111 8 0 0
sp_reserve_write_off 12345 12345 0 0.00 2 1127 29 0 0
sp_supplier_invoice 6528 6528 0 0.00 21 13129 2204 0 0
sp_supplier_order 6789 6789 0 0.00 8 7505 372 0 0
srv_aggregate_perf_data 209 209 0 0.00 67 9846 1699 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 7 841 297 0 0
srv_find_qd_qs_mism 484970 484970 0 0.00 0 1580 2 0 0
srv_make_invnt_saldo 1180 1180 0 0.00 0 4435 1155 0 0
srv_make_money_saldo 2157 2157 0 0.00 0 282 9 0 0
srv_recalc_idx_stat 2 2 0 0.00 247 9283 4765 0 0
v_add_invoice_to_stock 11342 11342 0 0.00 0 700 2 0 0
v_all_customers 40152 40152 0 0.00 0 71 2 0 0
v_all_suppliers 32548 32548 0 0.00 0 42 1 0 0
v_all_wares 52678 52678 0 0.00 0 70 1 0 0
v_cancel_adding_invoice 932 932 0 0.00 0 32 2 0 0
v_cancel_client_order 4404 4404 0 0.00 0 469 2 0 0
v_cancel_customer_prepayment 1608 1608 0 0.00 0 220 2 0 0
v_cancel_customer_reserve 1660 1660 0 0.00 0 245 2 0 0
v_cancel_payment_to_supplier 948 948 0 0.00 0 427 2 0 0
v_cancel_supplier_invoice 982 982 0 0.00 0 296 3 0 0
v_cancel_supplier_order 1000 1000 0 0.00 0 310 2 0 0
v_cancel_write_off 2464 2464 0 0.00 0 112 2 0 0
v_max_id_clo_ord 6789 6789 0 0.00 0 563 71 0 0
v_max_id_clo_res 1202 1202 0 0.00 0 1133 3 0 0
v_max_id_ord_sup 6528 6528 0 0.00 0 4945 891 0 0
v_max_non_paid_invoice 4268 4268 0 0.00 0 40 1 0 0
v_max_non_paid_realizn 8427 8427 0 0.00 0 94 1 0 0
v_min_id_clo_ord 6789 6789 0 0.00 0 5587 96 0 0
v_min_id_clo_res 1202 1202 0 0.00 0 442 4 0 0
v_min_id_ord_sup 6528 6528 0 0.00 0 9485 962 0 0
v_min_non_paid_invoice 7225 7225 0 0.00 0 830 2 0 0
v_min_non_paid_realizn 8727 8727 0 0.00 0 494 2 0 0
v_our_firm 13126 13126 0 0.00 0 47 1 0 0
v_reserve_write_off 24690 24690 0 0.00 0 613 1 0 0
x_lock_depdocs_on_canc_invoice 7809 7809 0 0.00 0 913 8 0 0
x_lock_depdocs_on_canc_sup_ord 500 500 0 0.00 0 179 7 0 0
x_make_qstorno_1000_1200 6789 6789 0 0.00 1 4491 148 0 0
x_make_qstorno_1200_2000 6528 6528 0 0.00 1 4712 314 0 0
x_make_qstorno_2100_3300 249313 249313 0 0.00 0 4517 24 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 13-11-2026 12:51:08 to 13-11-2026 12:51:12.

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
12:00:55 5 2147483648 2257003968 2259726336 35552 0.001 1 1 2 0 194256 116736 41968
12:01:55 280 2147483648 2336901328 2430390272 -271776 -0.012 19 11 26 1 2950064 1136016 2085824
12:02:56 215 2147483648 2343700320 2443767808 373248 0.017 20 10 21 0 3248880 1349568 1526064
12:03:56 301 2147483648 2346505792 2448797696 108432 0.005 20 12 24 1 4243520 2357536 1777552
12:04:57 334 2147483648 2345626608 2451103744 979664 0.045 20 7 15 1 3149440 1255280 914496
12:05:57 203 2147483648 2347840224 2452754432 -1108656 -0.051 20 7 17 0 3530000 1641584 2997072
12:06:58 185 2147483648 2348061392 2453794816 345536 0.016 20 11 24 0 3469312 1585488 1538288
12:07:58 329 2147483648 2352118640 2459787264 713792 0.033 20 8 17 0 3971648 2089072 1168784
12:08:59 217 2147483648 2354207424 2459750400 -1388320 -0.064 20 14 32 0 5668704 3769952 3287072
12:09:59 455 2147483648 2355398432 2464923648 -4322272 -0.201 20 13 34 0 3717616 1835728 6204160
12:11:00 212 2147483648 2356480272 2463813632 -1264656 -0.058 20 15 33 1 7278336 5378240 3164752
12:12:01 505 2147483648 2356504688 2463059968 -1282800 -0.059 20 7 16 0 9870960 7997152 3156608
12:13:01 295 2147483648 2356726912 2467356672 -3587776 -0.167 20 14 37 0 5123952 3236368 5475360
12:14:02 167 2147483648 2359768944 2466160640 -4835184 -0.225 20 13 32 1 9884096 7983952 6735328
12:15:03 840 2147483648 2351168336 2462158848 906400 0.042 20 5 10 0 5868256 3972640 989216
12:16:04 175 2147483648 2358815440 2467725312 -739744 -0.034 20 12 25 0 9509184 7619904 2629024
12:17:04 381 2147483648 2359100544 2470338560 -1253344 -0.058 20 7 17 0 6671168 4779824 3144688
12:18:05 357 2147483648 2358148848 2468896768 -1943184 -0.090 20 9 22 0 5691424 3801120 3833488
12:19:06 241 2147483648 2363201392 2477989888 -6854592 -0.320 20 16 44 0 4852368 2966688 8740272
12:20:06 151 2147483648 2357106608 2470268928 -231808 -0.010 20 7 15 0 8562240 6673552 2120496
12:21:06 478 2147483648 2365723120 2472849408 -1725568 -0.080 20 9 20 0 16251712 14358752 3618528
12:22:08 292 2147483648 2366236080 2475745280 -2482736 -0.115 20 15 34 0 10997520 9105856 4374400
12:23:09 685 2147483648 2369453776 2477654016 -1270560 -0.059 20 13 27 0 18128208 16239360 3159408
12:24:10 222 2147483648 2369341216 2480476160 -9792944 -0.458 19 15 38 0 8659280 6859680 11592544
12:25:11 206 2147483648 2360463200 2477731840 -4457120 -0.207 20 15 34 1 4662560 2770416 6349264
12:26:11 222 2147483648 2375913984 2486030336 -8214384 -0.383 20 18 44 0 15094544 13207232 10101696
12:27:11 214 2147483648 2362484352 2480590848 -6226256 -0.290 20 13 35 0 3610080 1719360 8116976
12:28:12 170 2147483648 2386340048 2484981760 -3668768 -0.171 20 15 33 0 29542336 27653808 5557296
12:29:12 318 2147483648 2369624448 2482122752 -4308544 -0.201 20 13 31 1 11334096 9439712 6202928
12:30:13 430 2147483648 2360320240 2458157056 -5930272 -0.276 20 17 42 0 5880464 3976160 7834576
12:31:14 370 2147483648 2376907168 2476838912 -10978544 -0.513 20 15 38 0 14127568 12233808 12872304
12:32:14 200 2147483648 2363453680 2465120256 -2440784 -0.113 20 13 30 0 10561872 8671184 4331472
12:33:15 338 2147483648 2373042128 2477654016 -10052480 -0.470 20 16 41 0 11369168 9481056 11940592
12:34:15 275 2147483648 2374090896 2483200000 -11037952 -0.516 20 16 37 0 11770976 9876176 12932752
12:35:16 283 2147483648 2372662656 2488066048 -14513888 -0.680 20 16 42 0 6316736 4424544 16406080
12:36:17 279 2147483648 2361225712 2476675072 -5675152 -0.264 20 15 37 0 5247168 3363136 7559184
12:37:17 259 2147483648 2368365536 2479198208 -3741504 -0.174 20 16 34 2 12162176 10266640 5637040
12:38:18 216 2147483648 2381263280 2487095296 -7353296 -0.343 20 19 42 0 18721792 16834960 9240128
12:39:18 218 2147483648 2384403232 2492760064 -18861712 -0.886 20 17 44 1 14172544 12282080 20752176
12:40:19 430 2147483648 2390057040 2502455296 -20813920 -0.978 20 17 45 0 13813472 11917952 22709440
12:41:19 288 2147483648 2374496640 2482708480 -6625792 -0.309 20 15 35 1 15480784 13610992 8495584
12:42:20 185 2147483648 2371645456 2486673408 -4160864 -0.194 20 13 31 0 11428336 9539472 6049728
12:43:21 195 2147483648 2383225872 2489815040 -4050864 -0.188 20 12 26 0 25475440 23585040 5941264
12:44:21 420 2147483648 2385526944 2496909312 -13363120 -0.626 20 18 46 0 18571216 16674400 15259936
12:45:22 293 2147483648 2384417392 2501386240 -22674288 -1.067 20 16 45 0 9933168 8049568 24557888
12:46:22 253 2147483648 2392698128 2503315456 -13174320 -0.617 20 16 38 0 23411616 21523888 15062048
12:47:24 296 2147483648 2377290464 2494709760 -17344768 -0.814 20 16 44 0 8594736 6712736 19226768
12:48:24 224 2147483648 2366130112 2486218752 -4699104 -0.219 20 16 36 0 8220752 6335216 6584640
12:49:25 325 2147483648 2394360064 2505252864 -22214000 -1.045 20 19 51 0 19192656 17299088 24107568
12:50:26 330 2147483648 2363233296 2482835456 -1392544 -0.064 20 15 31 0 7049616 5172320 3269840

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

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 13-11-2026 12:51:26 to 13-11-2026 12:51:26.

Content of mon$database and FB version


MON$DATABASE_NAME               /var/db/oltp-emul/oltp-fb60.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   14
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          178368
MON$OLDEST_ACTIVE               179085
MON$OLDEST_SNAPSHOT             179085
MON$NEXT_TRANSACTION            179085
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-13 09:00:10.6910 GMT
MON$PAGES                       144876
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                        {76465F9D-96F2-496A-90C2-F2C5CA849205}
MON$FILE_ID                     0108000000000000c3ec070000000000
MON$NEXT_ATTACHMENT             514
MON$NEXT_STATEMENT              900
MON$REPLICA_MODE                0


ISQL Version: LI-T6.0.0.2463 Firebird 6.0 d2acce6
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-T6.0.0.2463 Firebird 6.0 d2acce6"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-T6.0.0.2463 Firebird 6.0 d2acce6/tcp (test-0)/P20:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-T6.0.0.2463 Firebird 6.0 d2acce6/tcp (test-0)/P20:C"
on disk structure version 14.0

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 ---
:6: 
:7: test-0    Fri Nov 13 12:50:52 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3600
:9: 
:10: 
:11: test-0    Fri Nov 13 12:50:53 2026
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3600
:13: 
--- end of diff output ---

Final processing ISQL logs in /var/tmp/logs.oltp-fb60 according to config parameter 'remove_isql_logs'

13.11.26 12:51:27. There are 3 logs in /var/tmp/logs.oltp-fb60 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-13 12:51:28 No severe PSQL-related problems occured
13.11.26 12:51:28. End of report.