Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 22.03.2021 16:28
Common Performance Final Results
  1. Hardware and OS info
  2. Test configuration
  3. Test Finish details
  4. Test workload details
  5. 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. Performance, DETAILS per units
  4. Memory consumption, metadata cache, attachments activity    as table    as chart
  5. Monitoring data: STATEMENTS activity, as chart
  6. 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 mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID df9f488d08424df294c459d6c283e9c3
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-03-04 16:07
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.26
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17428584 kB
MemAvailable 31553788 kB
Buffers 0 kB
Cached 14268424 kB
SwapCached 0 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

SERVER_MODE                     SuperServer 3.0.8
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
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=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
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=init_buff, val=10000
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_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
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=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.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=test_intervals, val=60
param=test_time, val=120
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
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 2021-03-22 16:27:24
DTS_END                         2021-03-22 16:27:24.8860
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/57608
TRN_ID                          232515
ATT_ID                          698
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 50

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 120 minutes: 9366.33 19476 1123959
customer order: creation 171.26 402 20551
customer order: refuse 14.63 346 1756
order to supplier: creation 45.24 1322 5429
order to supplier: removal 3.53 100873 424
invoice (draft): creation 45.74 3261 5489
invoice (draft): removal 54.74 762 6569
invoice accept: apply 41.35 17617 4962
invoice accept: cancel 49.76 761 5971
customer reserve: creation 3833.47 175 460016
customer reserve: removal 4804.47 59 576536
realization accept: apply 82.35 178 9882
realization accept: cancel 91.54 101 10985
payment from customer: creation 59.04 124 7085
payment from customer: removal 5.35 71 642
payment to supplier: creation 47.87 131 5744
payment to supplier: removal 3.67 91 440
service: total inventory turnovers 5.03 1310 603
service: total monetary turnovers 6.38 32 766
service: aggregate perf. data 0.88 22087 105
service: refresh index statistics 0.03 239810 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 22-03-2021 16:29:12 to 22-03-2021 16:29:14.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2683
TEST_TIME 2 3922
TEST_TIME 3 4077
TEST_TIME 4 3766
TEST_TIME 5 4068
TEST_TIME 6 3905
TEST_TIME 7 3915
TEST_TIME 8 5090
TEST_TIME 9 5100
TEST_TIME 10 6262
TEST_TIME 11 6281
TEST_TIME 12 6766
TEST_TIME 13 6950
TEST_TIME 14 6976
TEST_TIME 15 7454
TEST_TIME 16 7396
TEST_TIME 17 7333
TEST_TIME 18 7679
TEST_TIME 19 7990
TEST_TIME 20 8300
TEST_TIME 21 8351
TEST_TIME 22 8584
TEST_TIME 23 8659
TEST_TIME 24 9396
TEST_TIME 25 9407
TEST_TIME 26 9801
TEST_TIME 27 10018
TEST_TIME 28 10860
TEST_TIME 29 11209
TEST_TIME 30 11156
TEST_TIME 31 10986
TEST_TIME 32 10750
TEST_TIME 33 10746
TEST_TIME 34 10833
TEST_TIME 35 10709
TEST_TIME 36 10775
TEST_TIME 37 10695
TEST_TIME 38 10460
TEST_TIME 39 10367
TEST_TIME 40 10327
TEST_TIME 41 10400
TEST_TIME 42 10526
TEST_TIME 43 10475
TEST_TIME 44 10379
TEST_TIME 45 10253
TEST_TIME 46 10072
TEST_TIME 47 9998
TEST_TIME 48 10005
TEST_TIME 49 9869
TEST_TIME 50 9804
TEST_TIME 51 9638
TEST_TIME 52 9592
TEST_TIME 53 9634
TEST_TIME 54 9648
TEST_TIME 55 9634
TEST_TIME 56 9595
TEST_TIME 57 9754
TEST_TIME 58 9688
TEST_TIME 59 9776
TEST_TIME 60 9759
TEST_TIME 61 9819
TEST_TIME 62 9838
TEST_TIME 63 9907
TEST_TIME 64 9879
TEST_TIME 65 10000
TEST_TIME 66 9944
TEST_TIME 67 9946
TEST_TIME 68 9814
TEST_TIME 69 9912
TEST_TIME 70 9822
TEST_TIME 71 9803
TEST_TIME 72 9751
TEST_TIME 73 9684
TEST_TIME 74 9632
TEST_TIME 75 9683
TEST_TIME 76 9656
TEST_TIME 77 9626
TEST_TIME 78 9647
TEST_TIME 79 9694
TEST_TIME 80 9653
TEST_TIME 81 9650
TEST_TIME 82 9680
TEST_TIME 83 9655
TEST_TIME 84 9687
TEST_TIME 85 9700
TEST_TIME 86 9732
TEST_TIME 87 9703
TEST_TIME 88 9777
TEST_TIME 89 9819
TEST_TIME 90 9739
TEST_TIME 91 9692
TEST_TIME 92 9648
TEST_TIME 93 9590
TEST_TIME 94 9565
TEST_TIME 95 9555
TEST_TIME 96 9532
TEST_TIME 97 9477
TEST_TIME 98 9525
TEST_TIME 99 9532
TEST_TIME 100 9554
TEST_TIME 101 9515
TEST_TIME 102 9479
TEST_TIME 103 9544
TEST_TIME 104 9534
TEST_TIME 105 9627
TEST_TIME 106 9593
TEST_TIME 107 9598
TEST_TIME 108 9607
TEST_TIME 109 9606
TEST_TIME 110 9689
TEST_TIME 111 9694
TEST_TIME 112 9617
TEST_TIME 113 9563
TEST_TIME 114 9536
TEST_TIME 115 9518
TEST_TIME 116 9465
TEST_TIME 117 9460
TEST_TIME 118 9433
TEST_TIME 119 9428
TEST_TIME 120 9368

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 22-03-2021 16:29:15 to 22-03-2021 16:29:19.

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 1551019 1551019 0 0.00 0 13582 6 0 0
doc_list_biud 1551016 1551016 0 0.00 0 75643 27 0 0
sp_add_invoice_to_stock 5070 4962 108 2.13 47 190338 17617 0 108
sp_cancel_adding_invoice 5971 5971 0 0.00 4 98959 761 0 0
sp_cancel_client_order 1756 1756 0 0.00 4 8604 346 0 0
sp_cancel_customer_reserve 576536 576536 0 0.00 1 75644 59 0 0
sp_cancel_pay_from_customer 642 642 0 0.00 3 5701 72 0 0
sp_cancel_pay_to_supplier 440 440 0 0.00 2 4334 92 0 0
sp_cancel_supplier_invoice 6573 6569 4 0.06 1 68820 762 0 4
sp_cancel_supplier_order 424 424 0 0.00 8 1004955 100874 0 0
sp_cancel_write_off 10985 10985 0 0.00 1 10755 101 0 0
sp_client_order 20551 20551 0 0.00 4 48866 403 0 0
sp_customer_reserve 460016 460016 0 0.00 0 87048 176 0 0
sp_fill_shopping_cart 31460 31460 0 0.00 1 15433 39 0 0
sp_fill_shopping_cart_clo_res 460015 460015 0 0.00 0 19091 14 0 0
sp_get_clo_for_invoice 4959 4959 0 0.00 0 20127 265 0 0
sp_kill_cost_storno 18038 18038 0 0.00 0 10753 53 0 0
sp_kill_qstorno_ret_qs2qd 1171050 1171050 0 0.00 0 75419 32 0 0
sp_kill_qty_storno 617080 617080 0 0.00 0 75643 68 0 0
sp_lock_selected_doc 20577 20577 0 0.00 0 5876 6 0 0
sp_make_cost_storno 27670 27670 0 0.00 0 13569 49 0 0
sp_multiply_rows_for_pdistr 27670 27670 0 0.00 0 8775 29 0 0
sp_multiply_rows_for_qdistr 20551 20551 0 0.00 0 48856 169 0 0
sp_pay_from_customer 7085 7085 0 0.00 4 37735 124 0 0
sp_pay_to_supplier 5744 5744 0 0.00 5 14904 132 0 0
sp_payment_common 12828 12828 0 0.00 1 37668 40 0 0
sp_qd_handle_on_cancel_clo 1756 1756 0 0.00 0 8593 319 0 0
sp_qd_handle_on_invoice_upd_sts 10929 10929 0 0.00 0 14409 302 0 0
sp_qd_handle_on_reserve_upd_sts 9881 9881 0 0.00 0 13140 60 0 0
sp_reserve_write_off 9882 9882 0 0.00 6 13172 179 0 0
sp_supplier_invoice 5489 5489 0 0.00 6 85714 3262 0 0
sp_supplier_order 5429 5429 0 0.00 5 34793 1322 0 0
srv_aggregate_perf_data 105 105 0 0.00 2654 759370 22087 0 0
srv_fill_mon_cache_memory 159 159 0 0.00 1541 161638 31850 0 0
srv_find_qd_qs_mism 1077097 1077097 0 0.00 0 10475 5 0 0
srv_make_invnt_saldo 603 603 0 0.00 25 134329 1310 0 0
srv_make_money_saldo 766 766 0 0.00 1 8326 33 0 0
srv_recalc_idx_stat 4 4 0 0.00 129869 322166 239811 0 0
t$perf-abend:sp_add_invoice_to_stock 108 108 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 4 4 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4962 4962 0 0.00 0 7706 156 0 0
t$perf-norm:sp_cancel_adding_invoice 430 430 0 0.00 0 2578 97 0 0
t$perf-norm:sp_cancel_client_order 1756 1756 0 0.00 0 1689 13 0 0
t$perf-norm:sp_cancel_customer_reserve 652 652 0 0.00 0 3335 23 0 0
t$perf-norm:sp_cancel_pay_from_customer 642 642 0 0.00 0 2793 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 440 440 0 0.00 0 1906 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 381 381 0 0.00 0 557 11 0 0
t$perf-norm:sp_cancel_supplier_order 424 424 0 0.00 0 27561 1540 0 0
t$perf-norm:sp_cancel_write_off 1013 1013 0 0.00 0 1694 7 0 0
t$perf-norm:sp_client_order 20551 20551 0 0.00 0 8590 17 0 0
t$perf-norm:sp_customer_reserve 921 921 0 0.00 0 2267 7 0 0
t$perf-norm:sp_pay_from_customer 7085 7085 0 0.00 0 7554 11 0 0
t$perf-norm:sp_pay_to_supplier 5744 5744 0 0.00 0 4907 9 0 0
t$perf-norm:sp_reserve_write_off 9882 9882 0 0.00 0 9980 9 0 0
t$perf-norm:sp_supplier_invoice 5489 5489 0 0.00 0 3774 16 0 0
t$perf-norm:sp_supplier_order 5429 5429 0 0.00 0 9009 19 0 0
t$perf-norm:srv_aggregate_perf_data 105 105 0 0.00 0 55 1 0 0
t$perf-norm:srv_fill_mon_cache_memory 159 159 0 0.00 0 7873 60 0 0
t$perf-norm:srv_make_invnt_saldo 603 603 0 0.00 0 5814 30 0 0
t$perf-norm:srv_make_money_saldo 766 766 0 0.00 0 3913 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 9 3 0 0
v_add_invoice_to_stock 10132 9916 216 2.13 0 13295 23 0 216
v_all_customers 38174 38174 0 0.00 0 26 1 0 0
v_all_suppliers 30382 30382 0 0.00 0 14 1 0 0
v_all_wares 41098 41098 0 0.00 0 121 1 0 0
v_cancel_adding_invoice 860 860 0 0.00 0 2180 8 0 0
v_cancel_client_order 3512 3512 0 0.00 0 5198 6 0 0
v_cancel_customer_prepayment 1284 1284 0 0.00 0 5666 10 0 0
v_cancel_customer_reserve 1304 1304 0 0.00 0 5668 12 0 0
v_cancel_payment_to_supplier 880 880 0 0.00 0 2539 8 0 0
v_cancel_supplier_invoice 770 762 8 1.03 0 13304 44 0 8
v_cancel_supplier_order 848 848 0 0.00 0 318 3 0 0
v_cancel_write_off 2026 2026 0 0.00 0 1986 13 0 0
v_max_id_clo_ord 5429 5429 0 0.00 0 264 1 0 0
v_max_id_clo_res 921 921 0 0.00 0 2160 20 0 0
v_max_id_ord_sup 5482 5482 0 0.00 0 2235 3 0 0
v_max_non_paid_invoice 1463 1463 0 0.00 0 1053 4 0 0
v_max_non_paid_realizn 3455 3455 0 0.00 0 1045 3 0 0
v_min_id_clo_ord 5429 5429 0 0.00 0 2979 6 0 0
v_min_id_clo_res 921 921 0 0.00 0 7261 13 0 0
v_min_id_ord_sup 5482 5482 0 0.00 0 7988 13 0 0
v_min_non_paid_invoice 5743 5743 0 0.00 0 8426 23 0 0
v_min_non_paid_realizn 7085 7085 0 0.00 0 29034 25 0 0
v_our_firm 10184 10184 0 0.00 0 25 1 0 0
v_reserve_write_off 19762 19762 0 0.00 0 11971 8 0 0
x_lock_depdocs_on_canc_invoice 12159 12159 0 0.00 0 17960 107 0 0
x_lock_depdocs_on_canc_sup_ord 424 424 0 0.00 0 3241 323 0 0
x_make_qstorno_1000_1200 5429 5429 0 0.00 2 34735 1242 0 0
x_make_qstorno_1200_2000 5489 5489 0 0.00 2 85694 3121 0 0
x_make_qstorno_2100_3300 460016 460016 0 0.00 0 87047 160 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 22-03-2021 16:29:20 to 22-03-2021 16:29:24.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, 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        = metadata cache, 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: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
13:57:28 10 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:34 14118 8192000000 10207829184 10507657216 971741328 10.604 78 66 135 1 997544576 2965520 22837728
13:57:55 31926 8192000000 10313949136 10630094848 1350915216 14.156 100 83 165 0 1382948064 4179536 27853312
13:58:36 29847 8192000000 10374748224 10693115904 1411630704 14.698 100 91 182 0 1447126704 5724192 29771808
13:59:20 21812 8192000000 10403242640 10729115648 1452180656 15.057 100 89 177 2 1487733168 7043056 28509456
13:59:52 14175 8192000000 10422674080 10751389696 1476529056 15.271 100 90 179 0 1512538880 7738928 28270896
14:00:13 27624 8192000000 10446315856 10776264704 1494391856 15.427 100 88 176 0 1530908864 8345760 28171248
14:00:48 17550 8192000000 10443000608 10779860992 1506126800 15.530 100 88 176 1 1543434224 8850656 28456768
14:01:14 20220 8192000000 10463039488 10803011584 1523074832 15.677 100 84 167 1 1558220848 8944032 26201984
14:01:46 17392 8192000000 10484098944 10826862592 1541960880 15.841 100 81 163 1 1576439344 9517872 24960592
14:02:15 18859 8192000000 10519569216 10865950720 1572223408 16.101 100 86 172 0 1608609024 10250880 26134736
14:02:45 15299 8192000000 10528940912 10885275648 1589581024 16.250 100 70 139 0 1621235344 10474096 21180224
14:03:10 12305 8192000000 10560891456 10916069376 1617274256 16.487 100 85 170 0 1653685776 10785408 25626112
14:03:33 12200 8192000000 10586181744 10946400256 1639467712 16.675 100 83 168 1 1676315264 12243648 24603904
14:03:55 7952 8192000000 10606508928 10971705344 1666663360 16.905 100 80 160 0 1702802208 12725840 23413008
14:04:11 10300 8192000000 10625750816 10996486144 1689399840 17.096 100 75 150 0 1722915232 12185568 21329824
14:04:28 7833 8192000000 10643236288 11015024640 1702443424 17.206 100 75 148 3 1736746336 12450400 21852512
14:04:43 5746 8192000000 10656766336 11027247104 1718442656 17.339 100 78 154 1 1753840704 13026352 22371696
14:04:56 5257 8192000000 10657028544 11036336128 1728054064 17.419 100 72 143 0 1760460608 12374048 20032496
14:05:11 7968 8192000000 10672596720 11051327488 1739813008 17.517 100 79 157 0 1774673072 12606864 22253200
14:05:25 5573 8192000000 10686994016 11063377920 1755711904 17.649 100 79 158 1 1790913584 13044304 22157376
14:05:38 8119 8192000000 10701740032 11082465280 1764536704 17.722 100 75 150 0 1798369888 12604016 21229168
14:05:53 5197 8192000000 10708172112 11090194432 1775423824 17.812 100 79 158 1 1810510384 13185584 21900976
14:06:06 9391 8192000000 10707531856 11095711744 1779815264 17.848 100 72 144 2 1812890080 13050272 20024544
14:06:24 4907 8192000000 10715858240 11106873344 1784663328 17.888 100 64 127 3 1813506656 11235632 17607696
14:06:36 3958 8192000000 10745478960 11130388480 1806281728 18.065 100 71 141 0 1836817136 10245712 20289696
14:06:46 3961 8192000000 10754411824 11139555328 1817941392 18.161 100 87 172 0 1853536864 11507872 24087600
14:06:57 4634 8192000000 10769120160 11151519744 1822117248 18.195 100 87 172 3 1858951552 12638736 24195568
14:07:08 3264 8192000000 10771936960 11153498112 1827406208 18.238 100 86 171 1 1865456992 14024912 24025872
14:07:18 4449 8192000000 10781665760 11162681344 1833354176 18.287 100 90 180 0 1873256208 15459296 24442736
14:07:29 1650 8192000000 10776726576 11163537408 1837177872 18.318 100 95 190 0 1879614832 15365920 27071040
14:07:37 2706 8192000000 10781506464 11166318592 1841035040 18.349 100 85 169 1 1878505216 14033200 23436976
14:07:47 3318 8192000000 10783689472 11173679104 1847899024 18.405 100 87 171 2 1885598160 13412016 24287120
14:07:57 2693 8192000000 10790229488 11182661632 1853130992 18.448 100 90 174 5 1890389488 12642048 24616448
14:08:07 3556 8192000000 10795053664 11185524736 1854863984 18.462 100 88 173 0 1890385632 11488448 24033200
14:08:16 2256 8192000000 10807422384 11192913920 1858877232 18.494 100 90 180 1 1897604608 13049120 25678256
14:08:25 2720 8192000000 10804511792 11193024512 1861524848 18.516 100 94 188 2 1901334736 13355264 26454624
14:08:35 1397 8192000000 10812366560 11201671168 1867166816 18.561 100 95 190 1 1907466736 13431104 26868816
14:08:43 1938 8192000000 10818672528 11205693440 1870146736 18.585 100 95 191 0 1909803600 13163184 26493680
14:08:51 1563 8192000000 10817753024 11205611520 1871039488 18.593 100 90 180 1 1909429568 12740304 25649776
14:08:59 2156 8192000000 10815516896 11205685248 1876788080 18.639 100 92 180 0 1915322608 13044016 25490512
14:09:07 31442 8192000000 10800318752 11200876544 1867885456 18.567 100 49 98 1 1892345408 9008336 15451616
14:09:46 17093 8192000000 10822644384 11217379328 1879872736 18.664 100 89 181 2 1916075888 9847168 26355984
14:10:10 2360 8192000000 10822098048 11216285696 1880644352 18.670 100 85 170 1 1917709216 12361024 24703840
14:10:19 1383 8192000000 10826049952 11220348928 1879065200 18.658 100 88 177 0 1917727504 14008880 24653424
14:10:27 3356 8192000000 10798727616 11211558912 1872580496 18.605 100 54 108 0 1899912304 12076592 15255216
14:10:37 2114 8192000000 10786712368 11208093696 1874128256 18.618 100 43 86 1 1895019168 8988640 11902272
14:10:46 3020 8192000000 10797755136 11206922240 1874819424 18.623 100 58 116 1 1903963600 11888992 17255184
14:10:59 8002 8192000000 10790626624 11209424896 1873162800 18.610 100 41 80 3 1893271088 8784976 11323312
14:11:13 10656 8192000000 10789411664 11210518528 1877709136 18.647 100 36 71 2 1895725856 7249216 10767504
14:11:31 47317 8192000000 10785755392 11218079744 1877967280 18.649 100 41 82 1 1895761312 5696848 12097184
14:12:27 13517 8192000000 10797475184 11223957504 1881428448 18.677 100 29 58 0 1896613680 6877776 8307456
14:12:47 6218 8192000000 10788442816 11222040576 1881992416 18.681 100 32 64 2 1898627248 7554496 9080336
14:13:01 3267 8192000000 10798848816 11226050560 1886951392 18.721 100 40 80 1 1905445168 7003984 11489792
14:13:16 6167 8192000000 10789863120 11223883776 1883063792 18.690 100 28 56 1 1897293296 5536784 8692720
14:13:31 4191 8192000000 10797331408 11227713536 1885545696 18.710 100 41 81 2 1905584064 8528480 11509888
14:13:43 7669 8192000000 10807508032 11229700096 1886070416 18.714 100 28 55 2 1899828320 5182080 8575824
14:13:57 4411 8192000000 10814198672 11230289920 1888362720 18.733 100 31 62 1 1907640896 10778176 8500000
14:14:08 8485 8192000000 10792965648 11229175808 1886787360 18.720 100 25 50 0 1900088416 5846608 7454448
14:14:23 10056 8192000000 10805583712 11236941824 1887611744 18.727 100 16 32 0 1897534080 5697136 4225200
14:14:39 7571 8192000000 10809940512 11236331520 1890304832 18.748 100 23 46 0 1903320512 6914464 6101216
14:14:53 11486 8192000000 10800641216 11232301056 1871015088 18.592 99 14 28 0 1880802144 5922960 3864096
14:15:11 6701 8192000000 10798402784 11232837632 1889148704 18.739 100 22 45 0 1901546272 6199168 6198400
14:15:25 18943 8192000000 10826864592 11243339776 1893169632 18.771 100 25 50 2 1906884240 5373120 8341488
14:15:50 60040 8192000000 10818878144 11246440448 1897274992 18.804 100 47 93 0 1917097056 5992640 13829424
14:16:56 6120 8192000000 10820629440 11247980544 1896626400 18.799 100 35 71 0 1914667840 8709808 9331632
14:17:09 5927 8192000000 10819821824 11251068928 1897939312 18.810 100 34 68 4 1914217712 7140816 9137584
14:17:22 3493 8192000000 10820243840 11252490240 1901100416 18.835 100 42 84 0 1921877744 7954384 12822944
14:17:33 6741 8192000000 10803455568 11234287616 1872796304 18.607 99 29 57 2 1887527072 6183888 8546880
14:17:47 3237 8192000000 10811286624 11242328064 1897105968 18.803 100 38 74 2 1914933632 6343744 11483920
14:17:58 5555 8192000000 10820306144 11248627712 1896006928 18.794 100 26 52 1 1914096176 10535632 7553616
14:18:13 5031 8192000000 10777663520 11209662464 1832371456 18.279 97 26 52 1 1846227776 6660496 7195824
14:18:25 7605 8192000000 10780634976 11213869056 1856018096 18.471 99 27 54 1 1870002720 6480272 7504352
14:18:39 6625 8192000000 10785911872 11222511616 1875041296 18.625 100 30 59 2 1889500160 6516560 7942304
14:18:54 6479 8192000000 10782986608 11205623808 1852514032 18.443 99 32 62 3 1867410080 6359120 8536928
14:19:11 6089 8192000000 10746033424 11158298624 1793035280 17.957 96 24 47 1 1805008416 5249184 6723952
14:19:25 6597 8192000000 10748828480 11174440960 1779382960 17.844 96 19 38 1 1790991584 6309264 5299360
14:19:38 7324 8192000000 10763572768 11187224576 1818229936 18.163 98 28 56 1 1831900896 5690336 7980624
14:19:51 9861 8192000000 10750810352 11184537600 1825667072 18.224 99 24 48 1 1838889568 5911072 7311424
14:20:08 8115 8192000000 10742881568 11165409280 1814948624 18.136 99 25 50 1 1827942160 5875280 7118256
14:20:23 59122 8192000000 10724615136 11105869824 1664213328 16.884 91 56 112 1 1685708304 5142512 16352464
14:21:29 11157 8192000000 10685444960 11105894400 1709138512 17.262 95 19 37 3 1720326736 6141632 5046592
14:21:48 8341 8192000000 10703144640 11108466688 1753485136 17.630 98 33 66 1 1770171152 7776000 8910016
14:22:02 6029 8192000000 10688253744 11095166976 1755788320 17.650 99 45 90 4 1777001568 8357776 12855472
14:22:14 7708 8192000000 10708535872 11112222720 1754196400 17.636 98 34 68 0 1771631472 6758800 10676272
14:22:30 8570 8192000000 10710085536 11122147328 1754117232 17.636 98 28 54 1 1767772032 5573760 8081040
14:22:46 6825 8192000000 10678582720 11092299776 1711948848 17.285 95 25 50 1 1724803728 5387904 7466976
14:23:01 8117 8192000000 10712834976 11128381440 1794043472 17.965 100 31 62 4 1808636528 5679328 8913728
14:23:15 4575 8192000000 10713319600 11131129856 1784257856 17.885 99 22 43 2 1800064912 9828032 5979024
14:23:26 10131 8192000000 10719370544 11133861888 1788491824 17.919 99 33 66 3 1804435376 5169264 10774288
14:23:44 7619 8192000000 10721259792 11137531904 1803964464 18.046 99 27 54 0 1817908720 6133920 7810336
14:24:01 6985 8192000000 10735461648 11152375808 1820958336 18.186 100 30 60 2 1834984752 5099104 8927312
14:24:14 8479 8192000000 10739161792 11159265280 1795663504 17.978 98 34 69 1 1812276752 5626416 10986832
14:24:29 8641 8192000000 10769481008 11167895552 1836154592 18.309 100 46 95 3 1856382896 5304288 14924016
14:24:44 59227 8192000000 10734682240 11169730560 1832721232 18.282 100 26 51 1 1845072880 5364096 6987552
14:25:50 10749 8192000000 10761698688 11177955328 1838133168 18.326 100 22 42 1 1849609056 5569152 5906736
14:26:08 10738 8192000000 10761568272 11185672192 1844271520 18.376 100 32 64 1 1859842992 6775248 8796224
14:26:25 7338 8192000000 10764682336 11186315264 1846759680 18.396 100 33 66 2 1865756992 9413216 9584096
14:26:42 7859 8192000000 10786823088 11203964928 1858738432 18.493 100 40 80 3 1876582192 6036928 11806832
14:26:57 7654 8192000000 10786386928 11207344128 1862018736 18.520 100 30 60 2 1875662528 5493616 8150176
14:27:12 5703 8192000000 10794370096 11215040512 1875638816 18.630 100 32 64 1 1890492256 4885552 9967888
14:27:29 20518 8192000000 10808959264 11227721728 1888128976 18.731 100 47 92 2 1907901456 5079568 14692912
14:27:56 16127 8192000000 10818364880 11237883904 1896027456 18.794 100 48 96 0 1916642512 6561536 14053520
14:28:22 22671 8192000000 10839220800 11258519552 1904020768 18.859 100 47 93 2 1924622576 7572768 13029040
14:28:51 11833 8192000000 10847847488 11264274432 1915201904 18.948 100 49 98 1 1940930208 11664864 14063440
14:29:14 17499 8192000000 10867362768 11283533824 1924835376 19.026 100 49 99 1 1952562000 12511856 15214768
14:29:41 14106 8192000000 10867090944 11292286976 1928420480 19.054 100 39 78 4 1952848160 13460816 10966864
14:30:04 8036 8192000000 10887472368 11300954112 1940276080 19.149 100 61 121 3 1973168192 15478288 17413824
14:30:23 9520 8192000000 10887376928 11307786240 1944352928 19.181 100 59 116 1 1976792368 16009408 16430032
14:31:28 49215 8192000000 10874387664 11315888128 1945501344 19.191 100 32 64 1 1973442992 18153632 9788016
14:33:23 21075 8192000000 10905813008 11333758976 1960100336 19.307 100 53 106 3 1993589072 18146560 15342176
14:33:53 14532 8192000000 10905392112 11338182656 1964088208 19.339 100 45 90 2 1998271424 20886080 13297136
14:34:15 3580 8192000000 10922800960 11338612736 1967264032 19.364 100 62 121 1 2006283408 20756208 18263168
14:34:27 1840 8192000000 10943015984 11352096768 1973910256 19.416 100 78 157 1 2021111168 23700176 23500736
14:34:41 25615 8192000000 10935647424 11359174656 1977326048 19.444 100 64 128 0 2023017600 27020256 18671296
14:35:17 8623 8192000000 10921814400 11349049344 1967177232 19.363 100 56 110 1 2012875520 28712032 16986256
14:35:34 9308 8192000000 10929762416 11358957568 1971661040 19.399 100 51 103 2 2016835984 29662240 15512704
14:35:53 12423 8192000000 10918553536 11356422144 1976833072 19.440 100 54 106 1 2015863984 23125296 15905616
14:36:14 4223 8192000000 10935757776 11359948800 1981844928 19.479 100 63 128 0 2025328976 24298912 19185136
14:36:26 7385 8192000000 10946349136 11370758144 1988520656 19.532 100 77 150 2 2038555920 26881968 23153296
14:36:44 9403 8192000000 10943476256 11367661568 1982726944 19.486 100 71 140 1 2033072656 29396160 20949552
14:37:05 8949 8192000000 10939139872 11376967680 1986282144 19.514 100 55 108 0 2034529584 31439936 16807504
14:37:21 3110 8192000000 10940997872 11378216960 1990612624 19.549 100 59 115 3 2036914560 28364560 17937376
14:37:32 8514 8192000000 10936785792 11373953024 1991840496 19.558 100 53 106 1 2031827824 22916304 17071024
14:37:48 3532 8192000000 10951680432 11375616000 1991456896 19.555 100 62 124 2 2034354704 24386576 18511232
14:38:01 2676 8192000000 10964776400 11385081856 1997339936 19.602 100 69 137 1 2046548624 29066960 20141728
14:38:13 5538 8192000000 10959066992 11383840768 1978405376 19.452 99 69 138 0 2031068688 32609216 20054096
14:38:26 5197 8192000000 10961666304 11388944384 1994387072 19.578 100 67 134 0 2048722928 34532272 19803584
14:38:39 3928 8192000000 10970300448 11395674112 1999908384 19.622 100 75 145 1 2057355888 35735840 21711664
14:38:51 4907 8192000000 10971994160 11400548352 2001736896 19.636 100 67 134 0 2057107472 35554240 19816336
14:39:04 2847 8192000000 10965609760 11391569920 1997668240 19.604 100 67 132 0 2053186240 35974544 19543456
14:39:15 6933 8192000000 10963495184 11396227072 2002111968 19.639 100 62 124 3 2055883760 35440192 18331600
14:39:29 2167 8192000000 10998218112 11411439616 2011552528 19.714 100 94 185 2 2077324416 37443776 28328112
14:39:40 5879 8192000000 10987744768 11411546112 2011102288 19.710 100 82 165 2 2074869920 39140304 24627328
14:39:57 6145 8192000000 10979043424 11410706432 2009615248 19.698 100 64 127 0 2067029248 38383744 19030256
14:40:11 2538 8192000000 10979089072 11401555968 1995803008 19.590 99 78 157 3 2055966704 36812880 23350816
14:40:21 7040 8192000000 10984627232 11410726912 2011268608 19.712 100 76 151 1 2071351136 37688912 22393616
14:40:38 2197 8192000000 10989716096 11413512192 2017795216 19.763 100 80 158 0 2077240528 36302016 23143296
14:40:48 2013 8192000000 11002575840 11422752768 2019408864 19.776 100 80 161 0 2080732928 37275152 24048912
14:40:57 6170 8192000000 10999563424 11426488320 2023298160 19.806 100 79 159 5 2084548656 37732640 23517856
14:41:15 1763 8192000000 10990832032 11412430848 2014917040 19.740 100 90 175 2 2079906416 38158448 26830928
14:41:25 2547 8192000000 10997126896 11417927680 2015628192 19.746 100 83 162 1 2079672752 38309552 25735008
14:41:36 3421 8192000000 11001122256 11426222080 2021873232 19.795 100 77 154 3 2085648464 40029920 23745312
14:41:47 2143 8192000000 10991136960 11420270592 2013678288 19.730 100 67 132 3 2074936256 40480144 20777824
14:41:57 3607 8192000000 11006202000 11430105088 2021305952 19.790 100 73 145 1 2084704800 41189664 22209184
14:42:08 1895 8192000000 10988913520 11414765568 1997354304 19.602 99 72 143 0 2060409504 41417552 21637648
14:42:16 2219 8192000000 11005469152 11428417536 2019496880 19.776 100 86 167 1 2087128096 41884784 25746432
14:42:26 4679 8192000000 11001587360 11428302848 2018013232 19.765 100 69 137 0 2081409392 42194352 21201808
14:42:38 1762 8192000000 11011794768 11431940096 2023593360 19.808 100 91 180 1 2093590512 42588912 27408240
14:42:47 1539 8192000000 11011447568 11429457920 2027767712 19.841 100 82 166 1 2090511472 37686160 25057600
14:42:56 2860 8192000000 10987524432 11401879552 2002712976 19.644 99 84 167 0 2067778464 38859248 26206240
14:43:06 5594 8192000000 10995405296 11410001920 1997594816 19.604 99 75 149 1 2058953264 38306912 23051536
14:43:23 5228 8192000000 10993568608 11415789568 1998733328 19.613 99 71 138 2 2060810656 40983264 21094064
14:43:35 4703 8192000000 11003733104 11427360768 2019812336 19.779 100 76 150 2 2085604576 42005600 23786640
14:43:46 3260 8192000000 10994988544 11419770880 2010595248 19.706 100 73 146 0 2077282320 43455824 23231248
14:43:58 2894 8192000000 11012625264 11430989824 2020865488 19.787 100 82 162 1 2091467072 45313392 25288192
14:44:08 4006 8192000000 10987716656 11413549056 2004812928 19.661 100 66 132 0 2071559520 46165600 20580992
14:44:22 2166 8192000000 10983228640 11405365248 1982343312 19.483 99 68 136 0 2051393600 47487216 21563072
14:44:32 3097 8192000000 10993343936 11416346624 2000635712 19.628 100 69 138 0 2070497936 47708368 22153856
14:44:46 7323 8192000000 10964150288 11390058496 1960437408 19.310 98 61 119 1 2028660912 49091056 19132448
14:45:05 2839 8192000000 10978408752 11405471744 1980510496 19.469 100 63 125 1 2051470240 50952352 20007392
14:45:16 4387 8192000000 10967214432 11391860736 1964607600 19.343 99 60 120 2 2033208528 48506240 20094688
14:45:28 4923 8192000000 10979964000 11401871360 1989176336 19.537 100 77 153 1 2065079776 50371536 25531904
14:45:43 4111 8192000000 10981427360 11404800000 1990291728 19.546 100 73 146 1 2063919440 50773472 22854240
14:45:57 7633 8192000000 10962317904 11401125888 1973234480 19.411 99 48 94 2 2039732080 50764880 15732720
14:46:17 9276 8192000000 10965553072 11406712832 1992933488 19.567 100 47 94 0 2055653344 47110928 15608928
14:46:32 15311 8192000000 10970739008 11401588736 1987516128 19.524 100 54 108 4 2052823232 47389520 17917584
14:46:54 6712 8192000000 10969608256 11400335360 1975338112 19.428 99 55 108 1 2042199776 49964864 16896800
14:47:08 10834 8192000000 10964424784 11407826944 1990089152 19.544 100 45 90 0 2055038640 50859616 14089872
14:47:27 15832 8192000000 10957570848 11403767808 1971456736 19.397 99 29 58 0 2027428384 46515888 9455760
14:47:54 12401 8192000000 10940529824 11384029184 1945506960 19.191 98 31 61 2 2004550288 49136544 9906784
14:48:19 12142 8192000000 10952876080 11392643072 1947820272 19.209 98 36 72 1 2012108960 51842704 12445984
14:48:38 12650 8192000000 10948375632 11390103552 1951536432 19.239 99 40 80 0 2017009152 51695792 13776928
14:48:58 16395 8192000000 10928734928 11377356800 1911142656 18.916 97 30 60 0 1970614272 48891984 10579632
14:49:22 10452 8192000000 10928616784 11370967040 1930767600 19.073 98 43 86 0 1993877472 49290416 13819456
14:49:42 12648 8192000000 10928031616 11369369600 1937194336 19.124 99 32 63 1 1999273792 51167776 10911680
14:50:06 5478 8192000000 10937289328 11369713664 1941736512 19.161 99 46 90 0 2007473536 50449280 15287744
14:50:19 15311 8192000000 10921341104 11358339072 1928108096 19.052 99 38 76 0 1989984672 49145280 12731296
14:50:45 11059 8192000000 10933967904 11370070016 1934205760 19.100 99 42 84 2 2001229744 52707056 14316928
14:51:02 8041 8192000000 10934589600 11368386560 1946578544 19.199 100 48 95 2 2016357280 53443072 16335664
14:51:25 21778 8192000000 10937222304 11384758272 1937723392 19.129 99 32 64 1 2006748768 58100192 10925184
14:52:00 19687 8192000000 10923778192 11373314048 1950256256 19.229 100 29 58 2 2006459248 45685968 10517024
14:52:52 21668 8192000000 10919530064 11367567360 1934950384 19.106 100 27 54 4 1995300640 50911456 9438800
14:53:42 35000 8192000000 10908059904 11364941824 1933539776 19.095 100 20 40 1 1999537552 58424576 7573200
14:55:49 27287 8192000000 10868405296 11323011072 1874077184 18.617 97 18 35 2 1905680784 25369296 6234304
14:56:29 34982 8192000000 10840085808 11307196416 1894457680 18.782 99 10 20 0 1912826256 14912640 3455936
14:57:10 71712 8192000000 10858920368 11310931968 1879750960 18.663 98 12 24 0 1900167888 17267840 3149088
14:58:28 112491 8192000000 10870252848 11329912832 1903813504 18.857 98 23 47 0 1920313072 10486752 6012816
15:00:34 48926 8192000000 10875740368 11339018240 1937788560 19.129 100 19 38 4 1960223456 17031424 5403472
15:01:29 59076 8192000000 10883809664 11328094208 1910330000 18.909 98 13 26 0 1923290960 9679264 3281696
15:02:46 80782 8192000000 10892305920 11363311616 1969060048 19.378 100 20 40 2 1993991984 18696224 6235712
15:05:24 41043 8192000000 10921316144 11354656768 1940871664 19.154 98 72 141 7 1975428496 14973984 19582848
15:06:12 8677 8192000000 10922444976 11366522880 1977724288 19.447 100 73 144 2 2014047184 15912352 20410544
15:06:33 27910 8192000000 10907714624 11361718272 1951925360 19.242 99 37 74 0 1979703424 17413360 10364704
15:07:13 43930 8192000000 10894499200 11343114240 1908551232 18.895 97 38 77 1 1937252976 17205024 11496720
15:08:12 46109 8192000000 10886303504 11352625152 1920117104 18.988 98 36 72 4 1946673440 16366384 10189952
15:09:11 53227 8192000000 10867669936 11352010752 1945004304 19.187 100 9 18 0 1960220384 12331072 2885008
15:10:15 97907 8192000000 10874380384 11346497536 1943137408 19.172 100 9 18 0 1958129968 12153552 2839008
15:12:08 50685 8192000000 10883208384 11351805952 1953063792 19.251 100 17 33 2 1967585376 9959424 4562160
15:13:10 30481 8192000000 10866561408 11339112448 1933379184 19.094 99 21 42 0 1951893936 12125056 6389696
15:14:14 44466 8192000000 10857451360 11336785920 1923846432 19.018 99 12 24 1 1940186576 12673968 3666176
15:15:05 46720 8192000000 10872801024 11348283392 1917424336 18.966 99 4 8 0 1926341600 7735680 1181584
15:16:14 24897 8192000000 10891870880 11347427328 1961092000 19.315 100 29 58 4 1975386272 5981040 8313232
15:16:46 58118 8192000000 10861606064 11336855552 1922595104 19.008 98 20 39 0 1933615552 6214944 4805504
15:17:52 86848 8192000000 10867445744 11345530880 1922105072 19.004 98 16 32 1 1937210272 10224688 4880512
15:21:04 42442 8192000000 10892819568 11373850624 1973683328 19.415 100 26 52 1 1993112816 11361456 8068032
15:22:09 28203 8192000000 10901892640 11371905024 1961044544 19.314 99 26 52 4 1977874880 8755152 8075184
15:22:45 18629 8192000000 10922785312 11382579200 1987915728 19.527 100 28 55 2 2002476512 7453008 7107776
15:23:11 37585 8192000000 10911599760 11385806848 1973985248 19.417 99 27 54 2 1991992576 10062768 7944560
15:24:03 67504 8192000000 10893527808 11386064896 1960914912 19.313 99 16 32 0 1978383424 12000592 5467920
15:25:21 52781 8192000000 10914850928 11387064320 1969964256 19.385 99 27 54 1 1989299552 11390816 7944480
15:26:20 64825 8192000000 10891304448 11378429952 1924885216 19.026 97 15 30 1 1946445984 17671072 3889696
15:27:33 62562 8192000000 10889074768 11357143040 1923886816 19.018 97 19 38 1 1939541792 10536720 5118256
15:28:53 92515 8192000000 10912800048 11395653632 1949000256 19.219 98 14 28 1 1972305856 19371216 3934384
15:30:32 92558 8192000000 10894482704 11363729408 1826697856 18.232 92 14 28 0 1844085328 13556656 3830816
15:32:13 83755 8192000000 10913770112 11383734272 1919259680 18.981 97 14 28 0 1942748592 19511168 3977744
15:33:52 117076 8192000000 10907848656 11353731072 1943460320 19.174 99 23 46 0 1967632704 17153712 7018672
15:35:58 88887 8192000000 10894076512 11377872896 1957846464 19.289 99 28 56 0 1980281392 15273536 7161392
15:37:34 18590 8192000000 10916757712 11384696832 1956251728 19.276 99 32 64 0 1979069248 13840400 8977120
15:38:08 8430 8192000000 10933123760 11374243840 1982175632 19.482 100 65 129 1 2009912416 8657088 19079696
15:38:25 50612 8192000000 10880488672 11363749888 1957179824 19.284 99 21 42 1 1973810208 11358336 5272048
15:39:31 84669 8192000000 10899414800 11380080640 1955644176 19.271 99 11 22 0 1970052640 11103520 3304944
15:41:17 74768 8192000000 10878599072 11364151296 1922994208 19.011 97 17 34 1 1943491600 15113360 5384032
15:43:12 56187 8192000000 10886540032 11350716416 1868025776 18.568 95 14 29 0 1883163440 11226416 3911248
15:44:17 44256 8192000000 10876130112 11356610560 1943708928 19.176 99 22 44 2 1962902432 13191104 6002400
15:45:07 59336 8192000000 10876405072 11353227264 1901210736 18.836 97 13 26 0 1920459424 15110848 4137840
15:46:16 37592 8192000000 10882496304 11355504640 1949661136 19.224 99 41 82 1 1970596832 8829360 12106336
15:46:59 30808 8192000000 10884293968 11340685312 1902594720 18.847 97 26 52 2 1916065008 6467936 7002352
15:47:44 39430 8192000000 10883806992 11344035840 1904088896 18.859 97 29 58 3 1925522832 13291984 8141952
15:48:30 28183 8192000000 10866393648 11325689856 1889986480 18.746 97 28 56 3 1906701968 9230336 7485152
15:49:04 40530 8192000000 10872610368 11328348160 1896564032 18.799 98 31 62 1 1916256480 10764448 8928000
15:49:54 37743 8192000000 10872250480 11327541248 1918879824 18.978 99 14 28 0 1931427104 8050288 4496992
15:50:59 53014 8192000000 10881329488 11358633984 1928592112 19.056 99 20 40 0 1945206080 10770256 5843712
15:52:01 54398 8192000000 10869499984 11328839680 1882728736 18.687 96 21 42 3 1899477472 11234512 5514224
15:53:16 45586 8192000000 10866735856 11334291456 1920874864 18.994 99 26 52 1 1945194928 16966176 7353888
15:54:08 28165 8192000000 10880499584 11340763136 1909969888 18.906 98 27 54 1 1929510160 12541408 6998864
15:54:43 29631 8192000000 10891501104 11341062144 1907433184 18.886 98 35 67 0 1928675888 11467728 9774976
15:55:22 56403 8192000000 10876157328 11345772544 1889586336 18.742 97 7 15 0 1900615152 9380576 1648240
15:57:09 108107 8192000000 10877725264 11351076864 1948935280 19.218 99 18 36 0 1966076832 12142976 4998576
15:59:04 75443 8192000000 10885566416 11345719296 1928321728 19.053 97 23 46 0 1943070224 8383840 6364656
16:00:28 54212 8192000000 10892581536 11359768576 1953932528 19.258 99 34 67 0 1975445792 12130768 9382496
16:01:37 66914 8192000000 10882864448 11362828288 1948224176 19.212 99 12 24 0 1964400032 12669072 3506784
16:02:57 90742 8192000000 10911226784 11388071936 1978940128 19.456 100 16 32 0 1998572096 14026448 5605520
16:04:41 48760 8192000000 10899426256 11393396736 1964623696 19.343 99 9 18 0 1982864560 15511248 2729616
16:05:36 75336 8192000000 10898964544 11373101056 1943920800 19.178 98 16 30 1 1961580224 13227824 4431600
16:06:59 52767 8192000000 10910478144 11389947904 1966185968 19.355 99 18 35 1 1982789296 11703952 4899376
16:08:11 85693 8192000000 10902506160 11370029056 1901119984 18.835 95 15 30 0 1914654128 9150272 4383872
16:09:43 24700 8192000000 10938341728 11390402560 1986916848 19.519 100 40 80 1 2009370624 11128192 11325584
16:10:20 71174 8192000000 10911102448 11399237632 1967360240 19.365 99 29 55 1 1995242608 19859872 8022496
16:12:57 61298 8192000000 10907028880 11373301760 1918737296 18.977 97 21 42 1 1937640912 13180096 5723520
16:14:05 28881 8192000000 10916920448 11382714368 1955644848 19.271 99 37 74 2 1978015392 11506432 10864112
16:15:07 55327 8192000000 10908464432 11370180608 1939428656 19.142 98 23 46 0 1958020048 12490464 6100928
16:16:09 50306 8192000000 10890891408 11356721152 1858217472 18.489 94 25 50 0 1878570208 13529920 6822816
16:17:06 51615 8192000000 10890009760 11376312320 1954105712 19.259 100 19 38 0 1975411360 15544000 5761648
16:18:04 161637 8192000000 10886021488 11363213312 1904957664 18.866 97 13 26 0 1923499904 15351872 3190368
16:20:52 88539 8192000000 10874341904 11357982720 1892710672 18.768 96 26 52 1 1907726736 7394128 7621936
16:22:28 88697 8192000000 10856795744 11338039296 1907758768 18.889 98 8 16 1 1918584976 8413200 2413008
16:24:44 61918 8192000000 10864124304 11339726848 1925571552 19.031 99 10 20 0 1934724384 6683584 2469248
16:25:55 48748 8192000000 10869724464 11343220736 1921516960 18.999 98 32 63 1 1940821552 9538176 9766416
16:27:02 48306 8192000000 9044213984 9273520128 220030688 2.615 12 3 6 0 222284704 1555648 698368

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 22-03-2021 16:29:25 to 22-03-2021 16:29:57.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 108 v_add_invoice_to_stock 335544517
except 4 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 22-03-2021 16:29:58 to 22-03-2021 16:30:00.

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          232820
MON$OLDEST_ACTIVE               232821
MON$OLDEST_SNAPSHOT             232821
MON$NEXT_TRANSACTION            232821
MON$PAGE_BUFFERS                1000000
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               2020-04-03 16:41:55.3470
MON$PAGES                       2028832
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33428 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33428 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33428 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33428 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.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 ---
:122: 
:123: mscs-test-161.budzdorov.ru    Mon Mar 22 16:27:52 2021
:124:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:125: 
--- end of diff output ---

Final processing ISQL logs in /var/tmp/logs-oltp30 according to config parameter 'remove_isql_logs'

22.03.21 16:30:01. There are 3 logs in /var/tmp/logs-oltp30 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
2021-03-22 16:30:03 No severe PSQL-related problems occured
22.03.21 16:30:04. End of report.