Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 08.11.2026 03: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
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 2273628 kB
MemAvailable 7174964 kB
Buffers 91388 kB
Cached 4896968 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 03:50:48
DTS_END                         2026-11-08 03:50:48.3250
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(95:17)
IP                              ::1/40106
TRN_ID                          235383
ATT_ID                          486
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: 16119.08 964 805954
customer order: creation 690.96 38 34548
customer order: refuse 57.82 51 2891
order to supplier: creation 178.30 185 8915
order to supplier: removal 13.54 8010 677
invoice (draft): creation 177.48 334 8874
invoice (draft): removal 129.52 129 6476
invoice accept: apply 150.76 1324 7538
invoice accept: cancel 106.60 190 5330
customer reserve: creation 7767.36 21 388368
customer reserve: removal 5784.78 13 289239
realization accept: apply 325.08 31 16254
realization accept: cancel 189.56 17 9478
payment from customer: creation 234.08 29 11704
payment from customer: removal 21.50 17 1075
payment to supplier: creation 191.86 23 9593
payment to supplier: removal 14.08 15 704
service: total inventory turnovers 24.58 1324 1229
service: total monetary turnovers 56.00 13 2800
service: aggregate perf. data 5.18 1675 259
service: refresh index statistics 0.04 5847 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 08-11-2026 03:51:03 to 08-11-2026 03:51:04.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8937
TEST_TIME 2 11315
TEST_TIME 3 12325
TEST_TIME 4 12679
TEST_TIME 5 13348
TEST_TIME 6 13471
TEST_TIME 7 13991
TEST_TIME 8 14266
TEST_TIME 9 14386
TEST_TIME 10 14297
TEST_TIME 11 14479
TEST_TIME 12 14393
TEST_TIME 13 14677
TEST_TIME 14 14634
TEST_TIME 15 14840
TEST_TIME 16 14655
TEST_TIME 17 14908
TEST_TIME 18 14923
TEST_TIME 19 14968
TEST_TIME 20 14931
TEST_TIME 21 15010
TEST_TIME 22 14953
TEST_TIME 23 15015
TEST_TIME 24 14996
TEST_TIME 25 15049
TEST_TIME 26 15046
TEST_TIME 27 14979
TEST_TIME 28 15010
TEST_TIME 29 15137
TEST_TIME 30 15141
TEST_TIME 31 15189
TEST_TIME 32 15178
TEST_TIME 33 15238
TEST_TIME 34 15390
TEST_TIME 35 15370
TEST_TIME 36 15543
TEST_TIME 37 15549
TEST_TIME 38 15612
TEST_TIME 39 15645
TEST_TIME 40 15732
TEST_TIME 41 15784
TEST_TIME 42 15917
TEST_TIME 43 15965
TEST_TIME 44 15998
TEST_TIME 45 16002
TEST_TIME 46 16036
TEST_TIME 47 16060
TEST_TIME 48 16091
TEST_TIME 49 16158
TEST_TIME 50 16119

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 08-11-2026 03:51:05 to 08-11-2026 03:51:07.

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 1185649 1185649 0 0.00 0 1882 2 0 0
doc_list_biud 1185649 1185649 0 0.00 0 4123 5 0 0
sp_add_invoice_to_stock 7538 7538 0 0.00 5 11894 1324 0 0
sp_cancel_adding_invoice 5330 5330 0 0.00 2 6351 190 0 0
sp_cancel_client_order 2891 2891 0 0.00 2 1864 51 0 0
sp_cancel_customer_reserve 289239 289239 0 0.00 1 1678 14 0 0
sp_cancel_pay_from_customer 1075 1075 0 0.00 1 1584 17 0 0
sp_cancel_pay_to_supplier 704 704 0 0.00 1 552 15 0 0
sp_cancel_supplier_invoice 6476 6476 0 0.00 1 4125 129 0 0
sp_cancel_supplier_order 677 677 0 0.00 5 63905 8010 0 0
sp_cancel_write_off 9478 9478 0 0.00 1 705 18 0 0
sp_client_order 34548 34548 0 0.00 2 2617 39 0 0
sp_customer_reserve 388368 388368 0 0.00 0 2852 22 0 0
sp_fill_shopping_cart 52337 52337 0 0.00 0 2125 16 0 0
sp_fill_shopping_cart_clo_res 388368 388368 0 0.00 0 1579 2 0 0
sp_get_clo_for_invoice 7538 7538 0 0.00 0 2097 35 0 0
sp_kill_cost_storno 16587 16587 0 0.00 0 850 8 0 0
sp_kill_qstorno_ret_qs2qd 595109 595109 0 0.00 0 4122 7 0 0
sp_kill_qty_storno 337883 337883 0 0.00 0 4122 16 0 0
sp_lock_selected_doc 33068 33068 0 0.00 0 648 1 0 0
sp_make_cost_storno 45089 45089 0 0.00 0 1054 6 0 0
sp_multiply_rows_for_pdistr 45089 45089 0 0.00 0 1881 9 0 0
sp_multiply_rows_for_qdistr 34548 34548 0 0.00 0 950 16 0 0
sp_pay_from_customer 11704 11704 0 0.00 2 1055 30 0 0
sp_pay_to_supplier 9593 9593 0 0.00 2 846 24 0 0
sp_payment_common 21297 21297 0 0.00 0 540 5 0 0
sp_qd_handle_on_cancel_clo 2891 2891 0 0.00 0 1553 37 0 0
sp_qd_handle_on_invoice_upd_sts 12868 12868 0 0.00 0 3080 60 0 0
sp_qd_handle_on_reserve_upd_sts 16254 16254 0 0.00 0 1336 10 0 0
sp_reserve_write_off 16254 16254 0 0.00 2 1889 31 0 0
sp_supplier_invoice 8874 8874 0 0.00 4 5842 334 0 0
sp_supplier_order 8915 8915 0 0.00 3 3377 185 0 0
srv_aggregate_perf_data 259 259 0 0.00 30 9120 1675 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 4 930 305 0 0
srv_find_qd_qs_mism 750228 750228 0 0.00 0 1814 1 0 0
srv_make_invnt_saldo 1229 1229 0 0.00 0 4383 1324 0 0
srv_make_money_saldo 2800 2800 0 0.00 0 251 14 0 0
srv_recalc_idx_stat 2 2 0 0.00 551 11144 5848 0 0
v_add_invoice_to_stock 15076 15076 0 0.00 0 561 2 0 0
v_all_customers 52916 52916 0 0.00 0 49 0 0 0
v_all_suppliers 44486 44486 0 0.00 0 63 0 0 0
v_all_wares 69096 69096 0 0.00 0 49 0 0 0
v_cancel_adding_invoice 1404 1404 0 0.00 0 429 2 0 0
v_cancel_client_order 5782 5782 0 0.00 0 519 1 0 0
v_cancel_customer_prepayment 2150 2150 0 0.00 0 166 1 0 0
v_cancel_customer_reserve 2062 2062 0 0.00 0 364 2 0 0
v_cancel_payment_to_supplier 1408 1408 0 0.00 0 549 2 0 0
v_cancel_supplier_invoice 1156 1156 0 0.00 0 723 3 0 0
v_cancel_supplier_order 1354 1354 0 0.00 0 720 3 0 0
v_cancel_write_off 3236 3236 0 0.00 0 480 2 0 0
v_max_id_clo_ord 8915 8915 0 0.00 0 296 1 0 0
v_max_id_clo_res 1660 1660 0 0.00 0 444 2 0 0
v_max_id_ord_sup 8874 8874 0 0.00 0 794 2 0 0
v_max_non_paid_invoice 5139 5139 0 0.00 0 58 1 0 0
v_max_non_paid_realizn 11138 11138 0 0.00 0 460 1 0 0
v_min_id_clo_ord 8915 8915 0 0.00 0 441 2 0 0
v_min_id_clo_res 1660 1660 0 0.00 0 646 3 0 0
v_min_id_ord_sup 8874 8874 0 0.00 0 998 4 0 0
v_min_non_paid_invoice 9593 9593 0 0.00 0 282 1 0 0
v_min_non_paid_realizn 11704 11704 0 0.00 0 439 2 0 0
v_our_firm 17312 17312 0 0.00 0 69 0 0 0
v_reserve_write_off 32508 32508 0 0.00 0 524 1 0 0
x_lock_depdocs_on_canc_invoice 11228 11228 0 0.00 0 1180 8 0 0
x_lock_depdocs_on_canc_sup_ord 677 677 0 0.00 0 146 9 0 0
x_make_qstorno_1000_1200 8915 8915 0 0.00 1 3053 138 0 0
x_make_qstorno_1200_2000 8874 8874 0 0.00 1 5156 296 0 0
x_make_qstorno_2100_3300 388368 388368 0 0.00 0 2741 19 0 0

Completed "Performance in DETAILS". Done for 00:00:03, from 08-11-2026 03:51:07 to 08-11-2026 03:51:10.

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
03:00:51 3 2147483648 2253167280 2255597568 4078656 0.189 1 1 2 0 4147712 60512 8544
03:01:52 290 2147483648 2506252128 2766569472 251693040 10.490 19 11 24 0 253100848 910256 497552
03:02:53 233 2147483648 2525795472 2779353088 270787824 11.197 20 10 20 0 272696912 1542160 366928
03:03:54 264 2147483648 2529558720 2775363584 273711568 11.304 20 15 26 2 275626656 1455472 459616
03:04:55 259 2147483648 2504778096 2730176512 249777760 10.419 19 14 28 0 252435712 2101232 556720
03:05:55 214 2147483648 2527818064 2770685952 265960720 11.019 20 15 28 0 271444048 4916784 566544
03:06:56 319 2147483648 2528124704 2766999552 270174512 11.175 20 11 22 0 272659568 2054816 430240
03:07:56 215 2147483648 2524785184 2767360000 266155872 11.027 20 9 17 0 270207296 3765184 286240
03:08:56 332 2147483648 2541179600 2782773248 272829536 11.272 20 14 28 0 285203520 11760400 613584
03:09:57 154 2147483648 2514539808 2748563456 254284848 10.587 19 13 28 0 259724704 4887840 552016
03:10:57 297 2147483648 2537328352 2770345984 268412928 11.110 20 15 30 0 282082592 13060704 608960
03:11:58 275 2147483648 2531512000 2769276928 267474496 11.075 20 13 25 3 276578016 8586064 517456
03:12:59 341 2147483648 2535367104 2771218432 265379616 10.998 20 10 20 0 279735824 13874960 481248
03:13:59 183 2147483648 2532100688 2775461888 269178528 11.138 20 11 22 0 277044432 7333904 532000
03:15:00 196 2147483648 2537685152 2773680128 266962448 11.056 20 15 30 0 282831456 15099072 769936
03:16:00 225 2147483648 2533143616 2772217856 270172800 11.174 20 14 26 0 276209168 5549936 486432
03:17:01 922 2147483648 2544730560 2794053632 269948288 11.166 20 12 24 0 293005904 22494368 563248
03:18:03 222 2147483648 2522040448 2755260416 258007424 10.725 19 14 28 0 266165888 7521024 637440
03:19:03 270 2147483648 2537018768 2778898432 271080000 11.208 20 10 20 0 283750160 12226960 443200
03:20:03 267 2147483648 2528640528 2769162240 269452880 11.148 20 10 20 2 273089200 3233728 402592
03:21:04 486 2147483648 2533258528 2777247744 259132080 10.767 20 12 24 0 272047200 12346528 568592
03:22:06 291 2147483648 2547804544 2795966464 275837904 11.382 20 10 20 0 290915664 14613840 463920
03:23:09 249 2147483648 2537955952 2778279936 268599680 11.117 20 10 20 0 281562560 12530768 432112
03:24:09 300 2147483648 2531121808 2770804736 264426512 10.963 20 10 18 1 274988688 10102576 459600
03:25:10 350 2147483648 2550528272 2793738240 274420704 11.330 20 12 24 0 294679104 19680672 577728
03:26:11 185 2147483648 2541241632 2785918976 276532784 11.408 20 15 30 0 286756448 9533680 689984
03:27:11 176 2147483648 2531402704 2762358784 264169904 10.953 20 11 22 0 273988192 9350208 468080
03:28:11 344 2147483648 2547947872 2798559232 277577552 11.446 20 15 30 1 292179104 13880256 721296
03:29:12 284 2147483648 2583321200 2828677120 279929744 11.532 20 13 26 1 326204240 45622304 652192
03:30:12 470 2147483648 2515753776 2721075200 239534704 10.034 20 13 26 0 259269648 19206304 528640
03:31:13 361 2147483648 2543070288 2778980352 270828304 11.199 20 10 19 0 286846512 15568192 450016
03:32:14 329 2147483648 2532753280 2775789568 270751184 11.196 20 8 16 0 283911152 12808864 351104
03:33:14 257 2147483648 2521537952 2758483968 261379488 10.850 20 9 18 0 271075984 9247392 449104
03:34:15 329 2147483648 2536497056 2775371776 267213104 11.066 20 13 26 0 282060320 14235120 612096
03:35:15 294 2147483648 2527330976 2775027712 267072336 11.060 20 9 18 0 271815424 4382176 360912
03:36:16 236 2147483648 2526696208 2772062208 266773168 11.049 20 10 20 0 269786512 2582224 431120
03:37:16 359 2147483648 2527953392 2778116096 269836272 11.162 20 13 26 0 272266688 1977200 453216
03:38:17 415 2147483648 2535295136 2770604032 264445296 10.964 20 14 27 0 277057024 12063392 548336
03:39:17 298 2147483648 2528886464 2767486976 265289584 10.995 20 9 18 0 273552640 7896576 366480
03:40:18 287 2147483648 2538229904 2785759232 257717024 10.714 20 16 29 0 278732224 20285344 729856
03:41:18 256 2147483648 2538304944 2774487040 258905904 10.759 20 15 30 0 280151664 20505456 740304
03:42:19 264 2147483648 2529963088 2775785472 263810736 10.940 20 8 16 0 274438448 10293616 334096
03:43:19 341 2147483648 2538331152 2774368256 261476096 10.854 20 14 29 0 282892064 20725600 690368
03:44:21 406 2147483648 2532975648 2776522752 266526240 11.040 20 9 18 0 276228432 9365056 337136
03:45:21 303 2147483648 2533452480 2777157632 267466480 11.075 20 8 16 0 275511920 7653744 391696
03:46:22 406 2147483648 2517380304 2757107712 260113904 10.803 20 8 16 0 263006304 2644096 248304
03:47:22 316 2147483648 2544104592 2788667392 266517616 11.040 20 8 16 0 287858912 20912976 428320
03:48:27 247 2147483648 2528203968 2766430208 262006688 10.873 20 10 20 2 269818784 7268528 543568
03:49:27 246 2147483648 2550091408 2778869760 259491808 10.780 20 16 32 0 292988896 32620272 876816
03:50:28 453 2147483648 2533092880 2782953472 267319472 11.070 20 7 14 0 276310784 8769760 221552

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

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 03:51:22 to 08-11-2026 03:51:22.

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          235278
MON$OLDEST_ACTIVE               235565
MON$OLDEST_SNAPSHOT             235565
MON$NEXT_TRANSACTION            235565
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 00:00:13.8420 GMT
MON$PAGES                       193732
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                        {66E12D91-605E-422A-8AC1-7149FDA40E2E}
MON$FILE_ID                     0108000000000000c2ed070000000000
MON$NEXT_ATTACHMENT             607
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 03:51:23. 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 03:51:23 No severe PSQL-related problems occured
08.11.26 03:51:24. End of report.