Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 05.11.2026 18:51
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 5d
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 1638236 kB
MemAvailable 7472140 kB
Buffers 89472 kB
Cached 5829100 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, 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-05 18:51:02
DTS_END                         2026-11-05 18:51:02.4880
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(98:17)
IP                              ::1/36530
TRN_ID                          155350
ATT_ID                          351
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: 8368.96 1099 418448
customer order: creation 459.52 53 22976
customer order: refuse 36.30 72 1815
order to supplier: creation 117.46 399 5873
order to supplier: removal 8.50 8947 425
invoice (draft): creation 113.94 1834 5697
invoice (draft): removal 73.20 170 3660
invoice accept: apply 98.54 1571 4927
invoice accept: cancel 61.00 235 3050
customer reserve: creation 4006.56 33 200328
customer reserve: removal 2706.82 21 135341
realization accept: apply 212.88 36 10644
realization accept: cancel 117.96 23 5898
payment from customer: creation 151.22 36 7561
payment from customer: removal 14.12 20 706
payment to supplier: creation 124.00 30 6200
payment to supplier: removal 8.44 19 422
service: total inventory turnovers 17.94 1710 897
service: total monetary turnovers 37.04 6 1852
service: aggregate perf. data 3.48 1491 174
service: refresh index statistics 0.04 5270 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 05-11-2026 18:51:24 to 05-11-2026 18:51:26.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 10723
TEST_TIME 2 9015
TEST_TIME 3 8538
TEST_TIME 4 8479
TEST_TIME 5 7475
TEST_TIME 6 7642
TEST_TIME 7 7904
TEST_TIME 8 7999
TEST_TIME 9 7985
TEST_TIME 10 8214
TEST_TIME 11 8283
TEST_TIME 12 8425
TEST_TIME 13 8371
TEST_TIME 14 8379
TEST_TIME 15 8527
TEST_TIME 16 8596
TEST_TIME 17 8547
TEST_TIME 18 8508
TEST_TIME 19 8500
TEST_TIME 20 8558
TEST_TIME 21 8567
TEST_TIME 22 8538
TEST_TIME 23 8617
TEST_TIME 24 8457
TEST_TIME 25 8497
TEST_TIME 26 8472
TEST_TIME 27 8617
TEST_TIME 28 8687
TEST_TIME 29 8769
TEST_TIME 30 8730
TEST_TIME 31 8717
TEST_TIME 32 8628
TEST_TIME 33 8698
TEST_TIME 34 8680
TEST_TIME 35 8713
TEST_TIME 36 8729
TEST_TIME 37 8698
TEST_TIME 38 8703
TEST_TIME 39 8685
TEST_TIME 40 8731
TEST_TIME 41 8683
TEST_TIME 42 8661
TEST_TIME 43 8691
TEST_TIME 44 8701
TEST_TIME 45 8673
TEST_TIME 46 8542
TEST_TIME 47 8505
TEST_TIME 48 8509
TEST_TIME 49 8537
TEST_TIME 50 8369

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 05-11-2026 18:51:26 to 05-11-2026 18:51:29.

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 623603 623603 0 0.00 0 5921 3 0 0
doc_list_biud 623603 623603 0 0.00 0 3925 7 0 0
sp_add_invoice_to_stock 4927 4927 0 0.00 5 16151 1572 0 0
sp_cancel_adding_invoice 3050 3050 0 0.00 3 9281 235 0 0
sp_cancel_client_order 1815 1815 0 0.00 2 1821 73 0 0
sp_cancel_customer_reserve 135341 135341 0 0.00 1 3995 21 0 0
sp_cancel_pay_from_customer 706 706 0 0.00 1 438 21 0 0
sp_cancel_pay_to_supplier 422 422 0 0.00 1 383 20 0 0
sp_cancel_supplier_invoice 3660 3660 0 0.00 1 3359 171 0 0
sp_cancel_supplier_order 425 425 0 0.00 5 71370 8947 0 0
sp_cancel_write_off 5898 5898 0 0.00 1 1300 23 0 0
sp_client_order 22976 22976 0 0.00 3 3244 54 0 0
sp_customer_reserve 200328 200328 0 0.00 0 4491 33 0 0
sp_fill_shopping_cart 34546 34546 0 0.00 0 22295 280 0 0
sp_fill_shopping_cart_clo_res 200328 200328 0 0.00 0 3828 2 0 0
sp_get_clo_for_invoice 4927 4927 0 0.00 0 1540 33 0 0
sp_kill_cost_storno 10076 10076 0 0.00 0 1043 8 0 0
sp_kill_qstorno_ret_qs2qd 280665 280665 0 0.00 0 3909 11 0 0
sp_kill_qty_storno 165760 165760 0 0.00 0 3925 23 0 0
sp_lock_selected_doc 21441 21441 0 0.00 0 375 1 0 0
sp_make_cost_storno 29332 29332 0 0.00 0 1550 6 0 0
sp_multiply_rows_for_pdistr 29332 29332 0 0.00 0 710 10 0 0
sp_multiply_rows_for_qdistr 22976 22976 0 0.00 0 1911 18 0 0
sp_pay_from_customer 7561 7561 0 0.00 3 1677 37 0 0
sp_pay_to_supplier 6200 6200 0 0.00 2 1093 31 0 0
sp_payment_common 13761 13761 0 0.00 0 1575 8 0 0
sp_qd_handle_on_cancel_clo 1815 1815 0 0.00 0 1777 50 0 0
sp_qd_handle_on_invoice_upd_sts 7977 7977 0 0.00 0 3359 62 0 0
sp_qd_handle_on_reserve_upd_sts 10644 10644 0 0.00 0 1441 11 0 0
sp_reserve_write_off 10644 10644 0 0.00 2 1559 37 0 0
sp_supplier_invoice 5697 5697 0 0.00 27 24291 1835 0 0
sp_supplier_order 5873 5873 0 0.00 25 17156 400 0 0
srv_aggregate_perf_data 174 174 0 0.00 16 7706 1492 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 6 1435 292 0 0
srv_find_qd_qs_mism 387237 387237 0 0.00 0 5920 2 0 0
srv_make_invnt_saldo 897 897 0 0.00 1 11741 1710 0 0
srv_make_money_saldo 1852 1852 0 0.00 0 331 6 0 0
srv_recalc_idx_stat 2 2 0 0.00 737 9804 5271 0 0
v_add_invoice_to_stock 9854 9854 0 0.00 0 689 3 0 0
v_all_customers 35282 35282 0 0.00 0 179 2 0 0
v_all_suppliers 27874 27874 0 0.00 0 146 1 0 0
v_all_wares 45952 45952 0 0.00 0 98 1 0 0
v_cancel_adding_invoice 832 832 0 0.00 0 641 3 0 0
v_cancel_client_order 3630 3630 0 0.00 0 455 2 0 0
v_cancel_customer_prepayment 1412 1412 0 0.00 0 165 3 0 0
v_cancel_customer_reserve 1410 1410 0 0.00 0 450 3 0 0
v_cancel_payment_to_supplier 844 844 0 0.00 0 326 2 0 0
v_cancel_supplier_invoice 764 764 0 0.00 0 453 4 0 0
v_cancel_supplier_order 850 850 0 0.00 0 76 2 0 0
v_cancel_write_off 1998 1998 0 0.00 0 528 3 0 0
v_max_id_clo_ord 5873 5873 0 0.00 1 615 67 0 0
v_max_id_clo_res 1077 1077 0 0.00 0 65 2 0 0
v_max_id_ord_sup 5697 5697 0 0.00 1 10658 675 0 0
v_max_non_paid_invoice 3833 3833 0 0.00 0 75 2 0 0
v_max_non_paid_realizn 7239 7239 0 0.00 0 116 1 0 0
v_min_id_clo_ord 5873 5873 0 0.00 1 5369 99 0 0
v_min_id_clo_res 1077 1077 0 0.00 0 1665 12 0 0
v_min_id_ord_sup 5697 5697 0 0.00 1 14221 751 0 0
v_min_non_paid_invoice 6200 6200 0 0.00 0 255 2 0 0
v_min_non_paid_realizn 7561 7561 0 0.00 0 573 2 0 0
v_our_firm 11314 11314 0 0.00 0 209 1 0 0
v_reserve_write_off 21288 21288 0 0.00 0 615 2 0 0
x_lock_depdocs_on_canc_invoice 6328 6328 0 0.00 0 968 7 0 0
x_lock_depdocs_on_canc_sup_ord 425 425 0 0.00 0 195 7 0 0
x_make_qstorno_1000_1200 5873 5873 0 0.00 1 12861 182 0 0
x_make_qstorno_1200_2000 5697 5697 0 0.00 1 8699 370 0 0
x_make_qstorno_2100_3300 200328 200328 0 0.00 0 4486 29 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 05-11-2026 18:51:29 to 05-11-2026 18:51:33.

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
18:01:07 4 2147483648 2257003360 2259726336 35552 0.001 1 1 2 0 194256 116736 41968
18:02:07 307 2147483648 2336844048 2431627264 30080 0.001 20 14 25 1 2991344 1043936 1917328
18:03:08 276 2147483648 2340927872 2440282112 581616 0.027 20 9 21 0 3281952 1397200 1303136
18:04:09 150 2147483648 2342110112 2444754944 1069712 0.049 20 6 13 0 2802752 904304 828736
18:05:10 243 2147483648 2342425360 2446131200 1258880 0.058 20 5 11 0 2902848 1025104 618864
18:06:10 248 2147483648 2344200000 2448351232 1482384 0.068 20 4 8 0 3236144 1339824 413936
18:07:11 259 2147483648 2347020384 2453516288 -411504 -0.019 20 9 19 0 5002272 3115504 2298272
18:08:12 127 2147483648 2348310640 2456256512 95104 0.004 20 14 31 2 3378448 1497408 1785936
18:09:13 240 2147483648 2351656224 2458947584 -605296 -0.028 20 9 19 0 6395728 4499424 2501600
18:10:13 233 2147483648 2347328304 2454843392 -2263616 -0.105 19 14 30 2 3502352 1733808 4032160
18:11:14 697 2147483648 2350754096 2458816512 186608 0.008 20 11 28 0 4575664 2684848 1704208
18:12:16 134 2147483648 2347346912 2456322048 -1492336 -0.069 19 14 30 2 3319824 1521312 3290848
18:13:16 373 2147483648 2355723888 2462420992 -526304 -0.024 20 8 16 1 8792592 6917920 2400976
18:14:17 224 2147483648 2346343248 2460262400 1611232 0.074 20 3 7 0 2745136 853024 280880
18:15:17 229 2147483648 2364479968 2467278848 -95344 -0.004 20 12 23 1 17091856 15190992 1996208
18:16:18 256 2147483648 2348869920 2462248960 1333024 0.062 20 3 6 0 4506032 2627040 545968
18:17:19 206 2147483648 2353058256 2465230848 635184 0.029 20 7 15 1 7284784 5415440 1234160
18:18:19 261 2147483648 2359479056 2473963520 -3925248 -0.183 20 10 24 0 7753168 5863440 5814976
18:19:20 248 2147483648 2355238352 2468745216 -7707408 -0.360 19 13 31 1 4971552 3182480 9496480
18:20:21 181 2147483648 2355543280 2470891520 -1970256 -0.091 20 11 25 0 6282864 4405728 3847392
18:21:21 182 2147483648 2358869840 2472464384 -1683536 -0.078 20 9 22 0 9693568 7807104 3570000
18:22:22 191 2147483648 2356481216 2470215680 -176896 -0.008 20 7 15 0 6940752 5054832 2062816
18:23:24 331 2147483648 2356686352 2474029056 -3152368 -0.147 20 13 31 0 4445504 2550528 5047344
18:24:25 301 2147483648 2360980720 2477555712 -4641696 -0.216 20 16 38 0 6328176 4446224 6523648
18:25:26 1435 2147483648 2350299296 2469502976 1027248 0.047 20 6 12 0 3910384 2038080 845056
18:26:29 150 2147483648 2357256512 2479652864 -2980064 -0.138 20 12 28 2 5900800 4012064 4868800
18:27:29 259 2147483648 2358364896 2478444544 -4552048 -0.212 20 14 37 0 3723232 1836224 6439056
18:28:30 182 2147483648 2368826656 2483249152 -5043216 -0.235 20 11 25 0 14130816 12237008 6937024
18:29:30 305 2147483648 2365044192 2484506624 -6904128 -0.322 20 17 43 0 7666880 5778800 8792208
18:30:31 246 2147483648 2363836656 2485473280 -9495456 -0.444 20 14 36 0 4197088 2307760 11384784
18:31:32 92 2147483648 2356411664 2457325568 -5881360 -0.274 20 10 22 0 5843760 3946560 7778560
18:32:32 130 2147483648 2363600352 2461163520 -4376384 -0.204 20 11 27 0 10528016 8651760 6252640
18:33:33 863 2147483648 2352700704 2463076352 -207104 -0.009 20 7 15 0 3509840 1622576 2094368
18:34:34 231 2147483648 2370445152 2479128576 -9108720 -0.425 20 16 43 0 10448000 8561296 10995424
18:35:34 206 2147483648 2357284192 2472464384 -2748608 -0.128 20 11 27 0 4225728 2336608 4637728
18:36:35 190 2147483648 2361790320 2471927808 -2407360 -0.112 20 14 31 0 11451520 9567680 4291200
18:37:35 284 2147483648 2367047200 2480414720 -9348880 -0.437 20 16 43 0 5352432 3455952 11245360
18:38:36 276 2147483648 2364476928 2478780416 -8940672 -0.418 20 15 40 0 5992096 4100992 10831776
18:39:36 184 2147483648 2360922448 2473754624 -3369632 -0.157 20 13 32 0 7100032 5208096 5261568
18:40:37 928 2147483648 2364375712 2477948928 -5306688 -0.247 20 13 30 0 9434992 7543360 7198320
18:41:39 394 2147483648 2363784320 2477760512 -756752 -0.035 20 11 24 0 12036656 10146032 2647376
18:42:40 321 2147483648 2361206384 2481659904 -4951840 -0.231 20 11 26 0 4554640 2663776 6842704
18:43:41 230 2147483648 2368527184 2484457472 -2163648 -0.100 20 13 24 2 11658464 9763760 4058352
18:44:41 382 2147483648 2363917936 2480185344 -523584 -0.024 20 9 19 0 9384080 7498320 2409344
18:45:42 198 2147483648 2369873520 2491277312 -8794112 -0.411 20 14 33 0 9380000 7483456 10690656
18:46:43 124 2147483648 2368196192 2480939008 -1988816 -0.092 20 12 25 0 14993296 13113776 3868336
18:47:44 194 2147483648 2362490896 2484334592 -2603360 -0.121 20 8 18 0 9490144 7612016 4481488
18:48:44 211 2147483648 2378489696 2494332928 -8827248 -0.412 20 14 33 0 17346368 15453456 10720160
18:49:45 164 2147483648 2373547760 2486894592 -7712432 -0.360 20 13 32 0 14995408 13101376 9606464
18:50:46 429 2147483648 2370654752 2490064896 -4302032 -0.200 20 12 28 0 11467040 9574352 6194720

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:15, from 05-11-2026 18:51:34 to 05-11-2026 18:51:49.

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 05-11-2026 18:51:49 to 05-11-2026 18:51:50.

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          155069
MON$OLDEST_ACTIVE               155598
MON$OLDEST_SNAPSHOT             155598
MON$NEXT_TRANSACTION            155598
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-05 15:00:12.6260 GMT
MON$PAGES                       120785
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                        {ACE84E4A-1935-4320-A4B2-AB953901DF9C}
MON$FILE_ID                     0108000000000000c3ec070000000000
MON$NEXT_ATTACHMENT             475
MON$NEXT_STATEMENT              900
MON$REPLICA_MODE                0


ISQL Version: LI-T6.0.0.2447 Firebird 6.0 d9d931a
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-T6.0.0.2447 Firebird 6.0 d9d931a"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-T6.0.0.2447 Firebird 6.0 d9d931a/tcp (test-0)/P20:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-T6.0.0.2447 Firebird 6.0 d9d931a/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    Thu Nov  5 18:51:03 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3600
:9: 
:10: 
:11: test-0    Thu Nov  5 18:51:04 2026
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3600
:13: 
:14: 
:15: test-0    Thu Nov  5 18:51:04 2026
:16:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3600
:17: 
--- end of diff output ---

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

05.11.26 18:51:50. 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-05 18:51:51 No severe PSQL-related problems occured
05.11.26 18:51:52. End of report.