Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 08.11.2026 21: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 1w 1d
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 2183052 kB
MemAvailable 7147672 kB
Buffers 91804 kB
Cached 4961520 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-08 21:50:38
DTS_END                         2026-11-08 21:50:38.6950
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/50468
TRN_ID                          220078
ATT_ID                          459
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: 14297.30 1243 714865
customer order: creation 650.92 40 32546
customer order: refuse 51.90 55 2595
order to supplier: creation 163.08 195 8154
order to supplier: removal 12.20 8753 610
invoice (draft): creation 165.18 332 8259
invoice (draft): removal 118.90 133 5945
invoice accept: apply 143.62 1391 7181
invoice accept: cancel 101.04 208 5052
customer reserve: creation 6775.68 25 338784
customer reserve: removal 5115.36 15 255768
realization accept: apply 307.80 31 15390
realization accept: cancel 188.70 17 9435
payment from customer: creation 217.24 35 10862
payment from customer: removal 20.24 16 1012
payment to supplier: creation 176.32 27 8816
payment to supplier: removal 11.22 15 561
service: total inventory turnovers 21.38 1536 1069
service: total monetary turnovers 51.64 14 2582
service: aggregate perf. data 4.84 1612 242
service: refresh index statistics 0.04 10408 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 08-11-2026 21:50:55 to 08-11-2026 21:50:56.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 11586
TEST_TIME 2 11740
TEST_TIME 3 11858
TEST_TIME 4 12330
TEST_TIME 5 12538
TEST_TIME 6 12727
TEST_TIME 7 12710
TEST_TIME 8 12950
TEST_TIME 9 12987
TEST_TIME 10 13046
TEST_TIME 11 12974
TEST_TIME 12 13028
TEST_TIME 13 13031
TEST_TIME 14 13034
TEST_TIME 15 12844
TEST_TIME 16 12953
TEST_TIME 17 13074
TEST_TIME 18 13046
TEST_TIME 19 12990
TEST_TIME 20 13047
TEST_TIME 21 13103
TEST_TIME 22 13148
TEST_TIME 23 13069
TEST_TIME 24 13107
TEST_TIME 25 13124
TEST_TIME 26 13156
TEST_TIME 27 13108
TEST_TIME 28 13245
TEST_TIME 29 13294
TEST_TIME 30 13256
TEST_TIME 31 13311
TEST_TIME 32 13376
TEST_TIME 33 13464
TEST_TIME 34 13455
TEST_TIME 35 13627
TEST_TIME 36 13691
TEST_TIME 37 13747
TEST_TIME 38 13855
TEST_TIME 39 13891
TEST_TIME 40 13991
TEST_TIME 41 14067
TEST_TIME 42 14079
TEST_TIME 43 14146
TEST_TIME 44 14173
TEST_TIME 45 14160
TEST_TIME 46 14196
TEST_TIME 47 14241
TEST_TIME 48 14315
TEST_TIME 49 14403
TEST_TIME 50 14297

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 08-11-2026 21:50:57 to 08-11-2026 21:50:59.

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 1054359 1054359 0 0.00 0 1584 2 0 0
doc_list_biud 1054359 1054359 0 0.00 0 2051 5 0 0
sp_add_invoice_to_stock 7181 7181 0 0.00 5 12524 1391 0 0
sp_cancel_adding_invoice 5052 5052 0 0.00 3 6399 208 0 0
sp_cancel_client_order 2595 2595 0 0.00 2 1684 55 0 0
sp_cancel_customer_reserve 255768 255768 0 0.00 1 1917 16 0 0
sp_cancel_pay_from_customer 1012 1012 0 0.00 1 448 16 0 0
sp_cancel_pay_to_supplier 561 561 0 0.00 1 266 16 0 0
sp_cancel_supplier_invoice 5945 5945 0 0.00 2 1614 133 0 0
sp_cancel_supplier_order 610 610 0 0.00 7 54206 8754 0 0
sp_cancel_write_off 9435 9435 0 0.00 1 1281 18 0 0
sp_client_order 32546 32546 0 0.00 2 2494 41 0 0
sp_customer_reserve 338784 338784 0 0.00 0 2920 25 0 0
sp_fill_shopping_cart 48959 48959 0 0.00 0 2671 17 0 0
sp_fill_shopping_cart_clo_res 338784 338784 0 0.00 0 1586 2 0 0
sp_get_clo_for_invoice 7181 7181 0 0.00 0 1916 34 0 0
sp_kill_cost_storno 16060 16060 0 0.00 0 1264 8 0 0
sp_kill_qstorno_ret_qs2qd 527526 527526 0 0.00 0 2051 8 0 0
sp_kill_qty_storno 301976 301976 0 0.00 0 2051 18 0 0
sp_lock_selected_doc 30986 30986 0 0.00 0 778 1 0 0
sp_make_cost_storno 42249 42249 0 0.00 0 1391 6 0 0
sp_multiply_rows_for_pdistr 42249 42249 0 0.00 0 831 9 0 0
sp_multiply_rows_for_qdistr 32546 32546 0 0.00 0 1903 17 0 0
sp_pay_from_customer 10862 10862 0 0.00 2 932 36 0 0
sp_pay_to_supplier 8816 8816 0 0.00 2 1431 27 0 0
sp_payment_common 19678 19678 0 0.00 0 760 9 0 0
sp_qd_handle_on_cancel_clo 2595 2595 0 0.00 0 1669 41 0 0
sp_qd_handle_on_invoice_upd_sts 12233 12233 0 0.00 0 1531 64 0 0
sp_qd_handle_on_reserve_upd_sts 15390 15390 0 0.00 0 1523 10 0 0
sp_reserve_write_off 15390 15390 0 0.00 2 1532 32 0 0
sp_supplier_invoice 8259 8259 0 0.00 3 5809 333 0 0
sp_supplier_order 8154 8154 0 0.00 4 3925 195 0 0
srv_aggregate_perf_data 242 242 0 0.00 11 8663 1613 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 3 618 335 0 0
srv_find_qd_qs_mism 667542 667542 0 0.00 0 1583 1 0 0
srv_make_invnt_saldo 1069 1069 0 0.00 1 4987 1537 0 0
srv_make_money_saldo 2582 2582 0 0.00 0 363 15 0 0
srv_recalc_idx_stat 2 2 0 0.00 609 20207 10408 0 0
v_add_invoice_to_stock 14362 14362 0 0.00 0 666 2 0 0
v_all_customers 49346 49346 0 0.00 0 67 0 0 0
v_all_suppliers 40142 40142 0 0.00 0 68 0 0 0
v_all_wares 65092 65092 0 0.00 0 47 0 0 0
v_cancel_adding_invoice 1300 1300 0 0.00 0 455 2 0 0
v_cancel_client_order 5190 5190 0 0.00 0 452 1 0 0
v_cancel_customer_prepayment 2024 2024 0 0.00 0 92 1 0 0
v_cancel_customer_reserve 1906 1906 0 0.00 0 491 2 0 0
v_cancel_payment_to_supplier 1122 1122 0 0.00 0 49 1 0 0
v_cancel_supplier_invoice 1066 1066 0 0.00 0 51 2 0 0
v_cancel_supplier_order 1220 1220 0 0.00 0 605 2 0 0
v_cancel_write_off 3002 3002 0 0.00 0 372 2 0 0
v_max_id_clo_ord 8154 8154 0 0.00 0 365 1 0 0
v_max_id_clo_res 1501 1501 0 0.00 0 260 2 0 0
v_max_id_ord_sup 8259 8259 0 0.00 0 682 1 0 0
v_max_non_paid_invoice 5158 5158 0 0.00 0 124 2 0 0
v_max_non_paid_realizn 10489 10489 0 0.00 0 389 1 0 0
v_min_id_clo_ord 8154 8154 0 0.00 0 942 2 0 0
v_min_id_clo_res 1501 1501 0 0.00 0 569 5 0 0
v_min_id_ord_sup 8259 8259 0 0.00 0 1483 4 0 0
v_min_non_paid_invoice 8816 8816 0 0.00 0 472 3 0 0
v_min_non_paid_realizn 10862 10862 0 0.00 0 646 6 0 0
v_our_firm 16492 16492 0 0.00 0 59 1 0 0
v_reserve_write_off 30780 30780 0 0.00 0 732 1 0 0
x_lock_depdocs_on_canc_invoice 10464 10464 0 0.00 0 1224 10 0 0
x_lock_depdocs_on_canc_sup_ord 610 610 0 0.00 0 283 10 0 0
x_make_qstorno_1000_1200 8154 8154 0 0.00 1 3884 146 0 0
x_make_qstorno_1200_2000 8259 8259 0 0.00 1 5702 293 0 0
x_make_qstorno_2100_3300 338784 338784 0 0.00 0 2904 22 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 08-11-2026 21:50:59 to 08-11-2026 21:51:03.

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
21:00:41 3 2147483648 2253167280 2255597568 4078656 0.189 1 1 2 0 4147712 60512 8544
21:01:43 324 2147483648 2481092432 2694328320 220278192 9.303 18 10 17 1 223233680 2646464 309024
21:02:44 322 2147483648 2526291456 2781790208 271191520 11.212 20 14 24 2 273283760 1668160 424080
21:03:45 336 2147483648 2527380208 2771189760 270763840 11.196 20 11 21 1 273031872 1885216 382816
21:04:46 237 2147483648 2517698832 2743980032 262173408 10.880 20 14 28 0 263885520 1175824 536288
21:05:46 308 2147483648 2529187744 2781622272 268789648 11.124 20 14 28 0 274530944 5226304 514992
21:06:47 309 2147483648 2526365360 2770567168 270212032 11.176 20 9 18 0 273203296 2598144 393120
21:07:48 264 2147483648 2523796928 2760830976 265214528 10.992 20 10 20 1 269442848 3777520 450800
21:08:48 221 2147483648 2529115392 2780717056 273636016 11.302 20 9 18 1 276383968 2367680 380272
21:09:49 193 2147483648 2530529392 2770493440 269262688 11.141 20 11 22 0 275010704 5292880 455136
21:10:49 309 2147483648 2533569344 2774523904 274304592 11.326 20 11 20 2 278677536 3924112 448832
21:11:50 192 2147483648 2529739184 2776629248 271104288 11.209 20 11 25 1 275017200 3391216 521696
21:12:50 320 2147483648 2520356816 2753273856 262222960 10.881 20 9 17 0 265238240 2629056 386224
21:13:51 275 2147483648 2530891408 2778460160 272815072 11.271 20 6 12 0 275998016 2974672 208272
21:14:51 335 2147483648 2533108384 2778116096 271176192 11.211 20 10 20 0 275653344 4061696 415456
21:15:52 390 2147483648 2550008560 2792194048 271743632 11.232 20 9 18 0 295033504 22808304 481568
21:16:53 260 2147483648 2560853280 2812104704 274675216 11.340 20 10 20 0 305650400 30495568 479616
21:17:53 221 2147483648 2533946624 2783264768 272501488 11.260 20 14 28 0 277344192 4238992 603712
21:18:54 283 2147483648 2535048544 2774491136 264090512 10.950 20 8 14 0 277179152 12666624 422016
21:19:54 480 2147483648 2535115008 2777423872 268032640 11.096 20 10 20 0 279132512 10601680 498192
21:20:55 411 2147483648 2539275584 2784874496 271930432 11.239 20 9 18 0 285576000 13290784 354784
21:21:56 223 2147483648 2522652160 2749612032 253399184 10.554 19 14 28 0 266854672 12768928 686560
21:22:56 393 2147483648 2536194912 2780172288 269830624 11.162 20 12 23 0 284743440 14342688 570128
21:23:57 248 2147483648 2535448736 2773610496 267714720 11.084 20 10 20 0 280016848 11864336 437792
21:24:58 432 2147483648 2535412832 2777108480 267507408 11.076 20 13 26 0 280105936 12040496 558032
21:25:59 408 2147483648 2535298224 2771034112 267022288 11.059 20 12 24 0 278091184 10594144 474752
21:27:00 378 2147483648 2543111664 2789908480 274439904 11.331 20 18 33 2 286012048 10732656 839488
21:28:01 590 2147483648 2550456256 2796257280 273814512 11.308 20 13 26 0 293275872 18918160 543200
21:29:02 367 2147483648 2531551584 2771197952 268352736 11.108 20 10 19 0 275209632 6419840 437056
21:30:03 366 2147483648 2506224736 2738188288 245689664 10.266 20 14 28 0 248948640 2638112 620864
21:31:04 413 2147483648 2517765904 2750652416 260546608 10.819 19 12 24 0 264022608 3008016 467984
21:32:05 324 2147483648 2543473824 2790842368 272894416 11.274 20 7 14 0 287855968 14566368 395184
21:33:05 514 2147483648 2523067248 2757103616 255742384 10.641 19 12 24 0 269035952 12778592 514976
21:34:06 227 2147483648 2524853248 2765017088 262592144 10.895 20 10 18 2 268183008 5261664 329200
21:35:07 606 2147483648 2550685200 2804011008 269830944 11.162 20 10 20 1 293474032 23196720 446368
21:36:08 366 2147483648 2531759376 2767577088 259651600 10.786 20 13 26 0 275820144 15513136 655408
21:37:09 347 2147483648 2524950912 2759995392 261412112 10.851 20 11 22 0 271267600 9372480 483008
21:38:10 250 2147483648 2530594528 2773999616 269507808 11.150 20 14 27 0 276106192 5995904 602480
21:39:11 299 2147483648 2529714928 2776436736 269979136 11.167 20 15 30 0 273672032 3052464 640432
21:40:11 618 2147483648 2538745504 2790002688 267743264 11.085 20 9 18 0 283798784 15398848 656672
21:41:12 327 2147483648 2534811664 2773164032 260685536 10.825 20 7 14 0 278487248 17474240 327472
21:42:13 228 2147483648 2519580976 2757746688 258800112 10.755 20 8 16 0 267129856 7946704 383040
21:43:13 506 2147483648 2521432480 2755174400 259768816 10.791 20 9 18 0 266223488 6069392 385280
21:44:14 202 2147483648 2524442976 2762039296 262522400 10.893 20 13 27 0 266827136 3783808 520928
21:45:14 212 2147483648 2529060512 2772451328 265551904 11.004 20 11 22 0 272682304 6728720 401680
21:46:14 213 2147483648 2527477424 2767093760 265269344 10.994 20 14 28 0 272253648 6358080 626224
21:47:15 334 2147483648 2523492528 2768105472 266176496 11.027 20 9 18 1 267913680 1264496 472688
21:48:15 414 2147483648 2539152288 2782433280 260963408 10.835 20 12 24 0 282282672 20724784 594480
21:49:16 329 2147483648 2562638128 2808246272 267668448 11.082 20 13 26 1 306233296 37938960 625888
21:50:17 332 2147483648 2536725584 2788233216 269378656 11.145 20 9 18 0 280056624 10250912 427056

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:12, from 08-11-2026 21:51:03 to 08-11-2026 21:51:15.

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

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          219602
MON$OLDEST_ACTIVE               220221
MON$OLDEST_SNAPSHOT             220221
MON$NEXT_TRANSACTION            220221
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-08 18:00:11.0800 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                        {CD82FBB2-6AD0-400F-BDEB-8FD203252311}
MON$FILE_ID                     0108000000000000c2ed070000000000
MON$NEXT_ATTACHMENT             582
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'

08.11.26 21:51:16. 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-08 21:51:16 No severe PSQL-related problems occured
08.11.26 21:51:17. End of report.