Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 04.01.2021 22: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 e0e7b46250ba4f9795ceb55e0face73f
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 2020-09-25 13:42
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.00
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 17298040 kB
MemAvailable 31411884 kB
Buffers 0 kB
Cached 14396280 kB
SwapCached 4864 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-01-04 22:27:08
DTS_END                         2021-01-04 22:27:08.8390
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/43308
TRN_ID                          239377
ATT_ID                          638
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: 9336.58 20413 1120390
customer order: creation 173.90 342 20868
customer order: refuse 14.34 363 1721
order to supplier: creation 47.14 1196 5657
order to supplier: removal 3.38 102855 406
invoice (draft): creation 45.85 3418 5502
invoice (draft): removal 53.61 764 6433
invoice accept: apply 41.83 18017 5019
invoice accept: cancel 48.34 777 5801
customer reserve: creation 3890.86 176 466903
customer reserve: removal 4717.63 58 566115
realization accept: apply 84.11 172 10093
realization accept: cancel 83.13 101 9976
payment from customer: creation 60.73 99 7287
payment from customer: removal 5.77 88 692
payment to supplier: creation 49.84 108 5981
payment to supplier: removal 3.77 124 452
service: total inventory turnovers 4.99 1104 599
service: total monetary turnovers 6.61 23 793
service: aggregate perf. data 0.73 24643 88
service: refresh index statistics 0.03 253835 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 04-01-2021 22:28:35 to 04-01-2021 22:28:37.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6272
TEST_TIME 2 6163
TEST_TIME 3 5556
TEST_TIME 4 5382
TEST_TIME 5 5504
TEST_TIME 6 5585
TEST_TIME 7 6063
TEST_TIME 8 6105
TEST_TIME 9 6349
TEST_TIME 10 6973
TEST_TIME 11 7132
TEST_TIME 12 7399
TEST_TIME 13 7728
TEST_TIME 14 8367
TEST_TIME 15 8735
TEST_TIME 16 8910
TEST_TIME 17 9087
TEST_TIME 18 9454
TEST_TIME 19 9325
TEST_TIME 20 9222
TEST_TIME 21 9233
TEST_TIME 22 9322
TEST_TIME 23 9441
TEST_TIME 24 9199
TEST_TIME 25 9990
TEST_TIME 26 10561
TEST_TIME 27 11558
TEST_TIME 28 11433
TEST_TIME 29 11379
TEST_TIME 30 11261
TEST_TIME 31 11180
TEST_TIME 32 11183
TEST_TIME 33 10872
TEST_TIME 34 10868
TEST_TIME 35 10711
TEST_TIME 36 10498
TEST_TIME 37 10532
TEST_TIME 38 10493
TEST_TIME 39 10524
TEST_TIME 40 10431
TEST_TIME 41 10410
TEST_TIME 42 10352
TEST_TIME 43 10402
TEST_TIME 44 10293
TEST_TIME 45 10280
TEST_TIME 46 10151
TEST_TIME 47 10241
TEST_TIME 48 10081
TEST_TIME 49 10025
TEST_TIME 50 10051
TEST_TIME 51 10001
TEST_TIME 52 9910
TEST_TIME 53 9975
TEST_TIME 54 9976
TEST_TIME 55 9989
TEST_TIME 56 10126
TEST_TIME 57 10176
TEST_TIME 58 10130
TEST_TIME 59 10107
TEST_TIME 60 10148
TEST_TIME 61 10087
TEST_TIME 62 10297
TEST_TIME 63 10212
TEST_TIME 64 10073
TEST_TIME 65 10070
TEST_TIME 66 10012
TEST_TIME 67 9945
TEST_TIME 68 9995
TEST_TIME 69 9921
TEST_TIME 70 9863
TEST_TIME 71 9860
TEST_TIME 72 9785
TEST_TIME 73 9725
TEST_TIME 74 9733
TEST_TIME 75 9688
TEST_TIME 76 9750
TEST_TIME 77 9730
TEST_TIME 78 9708
TEST_TIME 79 9770
TEST_TIME 80 9734
TEST_TIME 81 9776
TEST_TIME 82 9721
TEST_TIME 83 9731
TEST_TIME 84 9782
TEST_TIME 85 9800
TEST_TIME 86 9891
TEST_TIME 87 9880
TEST_TIME 88 9831
TEST_TIME 89 9746
TEST_TIME 90 9666
TEST_TIME 91 9672
TEST_TIME 92 9619
TEST_TIME 93 9561
TEST_TIME 94 9628
TEST_TIME 95 9575
TEST_TIME 96 9552
TEST_TIME 97 9507
TEST_TIME 98 9505
TEST_TIME 99 9531
TEST_TIME 100 9668
TEST_TIME 101 9657
TEST_TIME 102 9639
TEST_TIME 103 9591
TEST_TIME 104 9696
TEST_TIME 105 9670
TEST_TIME 106 9660
TEST_TIME 107 9667
TEST_TIME 108 9676
TEST_TIME 109 9604
TEST_TIME 110 9554
TEST_TIME 111 9529
TEST_TIME 112 9471
TEST_TIME 113 9479
TEST_TIME 114 9463
TEST_TIME 115 9465
TEST_TIME 116 9422
TEST_TIME 117 9422
TEST_TIME 118 9417
TEST_TIME 119 9387
TEST_TIME 120 9340

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 04-01-2021 22:28:39 to 04-01-2021 22:28:42.

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 1551718 1551718 0 0.00 0 19560 6 0 0
doc_list_biud 1551718 1551718 0 0.00 0 58371 27 0 0
sp_add_invoice_to_stock 5137 5019 118 2.29 23 195086 18018 0 118
sp_cancel_adding_invoice 5801 5801 0 0.00 5 57750 777 0 0
sp_cancel_client_order 1721 1721 0 0.00 4 12723 364 0 0
sp_cancel_customer_reserve 566115 566115 0 0.00 1 58372 58 0 0
sp_cancel_pay_from_customer 692 692 0 0.00 3 3895 89 0 0
sp_cancel_pay_to_supplier 452 452 0 0.00 3 6843 125 0 0
sp_cancel_supplier_invoice 6441 6433 8 0.12 2 15064 765 0 8
sp_cancel_supplier_order 406 406 0 0.00 6 935741 102856 0 0
sp_cancel_write_off 9976 9976 0 0.00 1 23913 102 0 0
sp_client_order 20868 20868 0 0.00 3 45150 342 0 0
sp_customer_reserve 466903 466903 0 0.00 0 91842 177 0 0
sp_fill_shopping_cart 32012 32012 0 0.00 1 19312 39 0 0
sp_fill_shopping_cart_clo_res 466897 466897 0 0.00 0 17375 13 0 0
sp_get_clo_for_invoice 5013 5013 0 0.00 0 20804 279 0 0
sp_kill_cost_storno 16921 16921 0 0.00 0 6889 51 0 0
sp_kill_qstorno_ret_qs2qd 1149045 1149045 0 0.00 0 58366 32 0 0
sp_kill_qty_storno 605558 605558 0 0.00 0 58371 69 0 0
sp_lock_selected_doc 20883 20883 0 0.00 0 8125 6 0 0
sp_make_cost_storno 28374 28374 0 0.00 0 11284 46 0 0
sp_multiply_rows_for_pdistr 28374 28374 0 0.00 0 7286 25 0 0
sp_multiply_rows_for_qdistr 20868 20868 0 0.00 0 45132 157 0 0
sp_pay_from_customer 7287 7287 0 0.00 4 10047 100 0 0
sp_pay_to_supplier 5981 5981 0 0.00 4 10436 108 0 0
sp_payment_common 13268 13268 0 0.00 1 9210 25 0 0
sp_qd_handle_on_cancel_clo 1721 1721 0 0.00 0 12701 325 0 0
sp_qd_handle_on_invoice_upd_sts 10814 10814 0 0.00 0 30537 347 0 0
sp_qd_handle_on_reserve_upd_sts 10093 10093 0 0.00 0 14300 68 0 0
sp_reserve_write_off 10093 10093 0 0.00 6 14679 173 0 0
sp_supplier_invoice 5502 5502 0 0.00 7 81381 3419 0 0
sp_supplier_order 5657 5657 0 0.00 5 40521 1196 0 0
srv_aggregate_perf_data 88 88 0 0.00 2022 405715 24644 0 0
srv_fill_mon_cache_memory 162 162 0 0.00 932 171260 32169 0 0
srv_find_qd_qs_mism 1071441 1071441 0 0.00 0 19559 5 0 0
srv_make_invnt_saldo 599 599 0 0.00 41 74443 1104 0 0
srv_make_money_saldo 793 793 0 0.00 0 580 23 0 0
srv_recalc_idx_stat 4 4 0 0.00 156420 352988 253836 0 0
t$perf-abend:sp_add_invoice_to_stock 118 118 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5019 5019 0 0.00 0 11792 185 0 0
t$perf-norm:sp_cancel_adding_invoice 408 408 0 0.00 1 4997 115 0 0
t$perf-norm:sp_cancel_client_order 1721 1721 0 0.00 0 4889 14 0 0
t$perf-norm:sp_cancel_customer_reserve 672 672 0 0.00 0 3853 19 0 0
t$perf-norm:sp_cancel_pay_from_customer 692 692 0 0.00 0 1842 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 452 452 0 0.00 0 247 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 403 403 0 0.00 0 2994 35 0 0
t$perf-norm:sp_cancel_supplier_order 406 406 0 0.00 0 23854 1378 0 0
t$perf-norm:sp_cancel_write_off 1023 1023 0 0.00 0 1256 7 0 0
t$perf-norm:sp_client_order 20868 20868 0 0.00 0 8992 21 0 0
t$perf-norm:sp_customer_reserve 971 971 0 0.00 0 610 4 0 0
t$perf-norm:sp_pay_from_customer 7287 7287 0 0.00 0 8982 10 0 0
t$perf-norm:sp_pay_to_supplier 5981 5981 0 0.00 0 4392 8 0 0
t$perf-norm:sp_reserve_write_off 10093 10093 0 0.00 0 8180 10 0 0
t$perf-norm:sp_supplier_invoice 5502 5502 0 0.00 0 4624 20 0 0
t$perf-norm:sp_supplier_order 5657 5657 0 0.00 0 3849 16 0 0
t$perf-norm:srv_aggregate_perf_data 88 88 0 0.00 0 156 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 162 162 0 0.00 0 428 6 0 0
t$perf-norm:srv_make_invnt_saldo 599 599 0 0.00 0 2250 29 0 0
t$perf-norm:srv_make_money_saldo 793 793 0 0.00 0 715 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 3 2 0 0
v_add_invoice_to_stock 10262 10026 236 2.29 0 7043 21 0 236
v_all_customers 38082 38082 0 0.00 0 92 1 0 0
v_all_suppliers 30872 30872 0 0.00 0 109 1 0 0
v_all_wares 41730 41730 0 0.00 0 27 1 0 0
v_cancel_adding_invoice 816 816 0 0.00 0 428 7 0 0
v_cancel_client_order 3442 3442 0 0.00 0 5167 8 0 0
v_cancel_customer_prepayment 1384 1384 0 0.00 0 3865 10 0 0
v_cancel_customer_reserve 1344 1344 0 0.00 0 703 3 0 0
v_cancel_payment_to_supplier 904 904 0 0.00 0 6235 17 0 0
v_cancel_supplier_invoice 822 806 16 1.94 0 3348 17 0 16
v_cancel_supplier_order 812 812 0 0.00 0 2131 8 0 0
v_cancel_write_off 2046 2046 0 0.00 0 3037 15 0 0
v_max_id_clo_ord 5654 5654 0 0.00 0 523 1 0 0
v_max_id_clo_res 971 971 0 0.00 0 3865 16 0 0
v_max_id_ord_sup 5493 5493 0 0.00 0 3703 6 0 0
v_max_non_paid_invoice 1692 1692 0 0.00 0 368 3 0 0
v_max_non_paid_realizn 3777 3777 0 0.00 0 1651 5 0 0
v_min_id_clo_ord 5654 5654 0 0.00 0 6412 8 0 0
v_min_id_clo_res 971 971 0 0.00 0 5117 13 0 0
v_min_id_ord_sup 5493 5493 0 0.00 0 8700 7 0 0
v_min_non_paid_invoice 5981 5981 0 0.00 0 9199 15 0 0
v_min_non_paid_realizn 7287 7287 0 0.00 0 5513 16 0 0
v_our_firm 10668 10668 0 0.00 0 80 1 0 0
v_reserve_write_off 20186 20186 0 0.00 0 6912 5 0 0
x_lock_depdocs_on_canc_invoice 11831 11831 0 0.00 0 12052 116 0 0
x_lock_depdocs_on_canc_sup_ord 406 406 0 0.00 0 4294 356 0 0
x_make_qstorno_1000_1200 5657 5657 0 0.00 1 40512 1105 0 0
x_make_qstorno_1200_2000 5502 5502 0 0.00 3 75731 3274 0 0
x_make_qstorno_2100_3300 466903 466903 0 0.00 0 91840 161 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 04-01-2021 22:28:43 to 04-01-2021 22:28:47.

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
19:57:12 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:18 18018 8192000000 10227875968 10526728192 749223504 8.379 60 49 98 0 768484272 2182480 17078288
19:57:46 38980 8192000000 10331782208 10644570112 1356343696 14.205 100 81 162 0 1388443456 4881296 27218464
19:58:31 18090 8192000000 10357990592 10673930240 1411479248 14.697 100 92 185 0 1447988864 6118304 30391312
19:59:01 42790 8192000000 10397015872 10721964032 1439339888 14.944 100 91 182 0 1476824800 7058928 30425984
19:59:52 17758 8192000000 10416045232 10741231616 1466737904 15.185 100 93 186 1 1505434528 8108272 30588352
20:00:18 29162 8192000000 10438356784 10768302080 1475693216 15.264 100 92 182 2 1513809824 8731408 29385200
20:00:56 16890 8192000000 10451675200 10786959360 1502755936 15.500 100 87 174 1 1539983376 9233392 27994048
20:01:21 11328 8192000000 10457802112 10801934336 1519656720 15.647 100 81 162 2 1555043552 9328400 26058432
20:01:43 14875 8192000000 10493623792 10845122560 1550936320 15.918 100 77 152 1 1583823616 9218928 23668368
20:02:08 13666 8192000000 10540418240 10888646656 1586205888 16.221 100 77 154 0 1619611232 9492944 23912400
20:02:32 9851 8192000000 10544439168 10903875584 1607751648 16.406 100 69 138 0 1638678272 10220416 20706208
20:02:49 10587 8192000000 10573809616 10929565696 1626637984 16.566 100 83 165 0 1663449184 10905296 25905904
20:03:09 13236 8192000000 10594237072 10953867264 1653167488 16.791 100 82 164 0 1689937856 12154080 24616288
20:03:32 15253 8192000000 10621702928 10984796160 1677281152 16.994 100 88 176 1 1715500064 13212880 25006032
20:04:00 8641 8192000000 10635522528 11000647680 1693371104 17.130 100 81 160 1 1729719840 13625120 22723616
20:04:15 8090 8192000000 10649819856 11016851456 1706684448 17.241 100 90 180 1 1747585968 14245008 26656512
20:04:31 10843 8192000000 10653944208 11030843392 1714332112 17.305 100 73 146 0 1748049024 12951840 20765072
20:04:48 7907 8192000000 10670059728 11041419264 1729837392 17.434 100 86 172 1 1768187456 13459072 24890992
20:05:03 5340 8192000000 10673882512 11052240896 1741359872 17.530 100 85 170 0 1780334320 13848080 25126368
20:05:15 4387 8192000000 10692764112 11066667008 1749849920 17.600 100 86 171 1 1787876016 13928656 24097440
20:05:26 4057 8192000000 10689747632 11071320064 1755971104 17.651 100 78 156 0 1791662096 13870560 21820432
20:05:36 4219 8192000000 10712722400 11085275136 1764992400 17.726 100 86 172 1 1802462880 13377120 24093360
20:05:47 3886 8192000000 10720040880 11098157056 1775335776 17.811 100 91 182 3 1814803072 13865776 25601520
20:05:58 3810 8192000000 10725398864 11100844032 1781500976 17.862 100 82 160 1 1817259904 13513408 22245520
20:06:09 4913 8192000000 10727737104 11112488960 1789820288 17.930 100 85 170 0 1826491184 12875584 23795312
20:06:21 3540 8192000000 10735486960 11117060096 1793806832 17.963 100 86 172 3 1830820144 12908144 24105168
20:06:31 3099 8192000000 10746115232 11128770560 1803153920 18.040 100 83 166 0 1839934800 13153792 23627088
20:06:41 2182 8192000000 10742927536 11125657600 1808099136 18.080 100 86 174 1 1845163600 12998720 24065744
20:06:49 2448 8192000000 10745452896 11130494976 1808904144 18.087 100 83 166 0 1845067712 13420464 22743104
20:06:59 8376 8192000000 10753670432 11136008192 1811672480 18.110 100 87 171 2 1848812560 13690512 23449568
20:07:15 4792 8192000000 10755817408 11146158080 1821751392 18.192 100 86 171 2 1859699840 13783632 24164816
20:07:27 2565 8192000000 10775251504 11163553792 1836003936 18.308 100 89 178 1 1874574592 12778464 25792192
20:07:36 1882 8192000000 10791614688 11179569152 1840243488 18.343 100 87 173 2 1882931296 17432704 25255104
20:07:44 1551 8192000000 10790338192 11176755200 1845918608 18.389 100 91 182 0 1886518192 14275584 26324000
20:07:52 1685 8192000000 10793655568 11182931968 1855227872 18.465 100 93 184 3 1896111088 13552656 27330560
20:08:00 1756 8192000000 10802633664 11189669888 1858241952 18.489 100 91 183 2 1897338032 12639856 26456224
20:08:08 2090 8192000000 10801741024 11191250944 1858218400 18.489 100 89 178 1 1895414944 11920800 25275744
20:08:17 1803 8192000000 10805738464 11195715584 1868962464 18.576 100 94 189 1 1908007152 12880864 26163824
20:08:25 1730 8192000000 10818993728 11209519104 1867789568 18.566 100 82 164 2 1904323184 13732272 22801344
20:08:33 39465 8192000000 10794315296 11204083712 1865340080 18.547 100 60 117 1 1892245696 9645552 17260064
20:09:19 2436 8192000000 10823411072 11216125952 1877727200 18.647 100 91 183 0 1915804032 10957344 27119488
20:09:28 5625 8192000000 10810832000 11212201984 1873990000 18.617 100 70 135 1 1903922800 11373440 18559360
20:09:40 6382 8192000000 10793952784 11209850880 1873461152 18.612 100 57 115 0 1901443344 11272864 16709328
20:09:55 4759 8192000000 10773872960 11202396160 1868335664 18.571 100 33 66 0 1885855248 7944176 9575408
20:10:06 5132 8192000000 10786750720 11208871936 1873362496 18.611 100 33 66 2 1889546688 7210592 8973600
20:10:19 2920 8192000000 10790159920 11211358208 1873936176 18.616 100 36 71 1 1892196784 7658784 10601824
20:10:29 7194 8192000000 10783648928 11211689984 1873805376 18.615 100 24 48 0 1887362544 6569456 6987712
20:10:43 2938 8192000000 10804413120 11218321408 1880231760 18.667 100 49 98 3 1901165632 7114720 13819152
20:10:52 4187 8192000000 10784464560 11216306176 1878675472 18.654 100 29 58 2 1894142640 7552128 7915040
20:11:03 3381 8192000000 10800767600 11222286336 1884302624 18.700 100 41 82 0 1904048272 8348048 11397600
20:11:17 7788 8192000000 10798908864 11224895488 1883080224 18.690 100 35 71 2 1900197200 7291920 9825056
20:11:32 5733 8192000000 10795815408 11227410432 1886203008 18.715 100 34 68 0 1904296976 7896528 10197440
20:11:46 5183 8192000000 10796915712 11224035328 1886665120 18.719 100 19 38 2 1897916800 5876960 5374720
20:12:05 10214 8192000000 10804092160 11234217984 1892041872 18.762 100 15 29 3 1901598544 5293696 4262976
20:12:24 13815 8192000000 10793422976 11236483072 1895477808 18.790 100 17 34 2 1906460448 6476384 4506256
20:12:46 7311 8192000000 10803480560 11242881024 1897437520 18.806 100 16 31 1 1907156480 5838416 3880544
20:13:02 11983 8192000000 10805862720 11239116800 1896384544 18.797 100 13 26 1 1905504928 5750816 3369568
20:13:20 7237 8192000000 10809327216 11241594880 1898162608 18.812 100 23 46 1 1910628432 6376448 6089376
20:13:36 76047 8192000000 10842870576 11255648256 1909073520 18.899 100 55 108 3 1930231168 5044096 16113552
20:14:58 5595 8192000000 10826582720 11260116992 1907566112 18.887 100 41 82 0 1927952368 9236320 11149936
20:15:10 8099 8192000000 10829433328 11258687488 1904202432 18.860 100 24 48 1 1917593664 6603744 6787488
20:15:27 5380 8192000000 10825112320 11252736000 1897382256 18.805 100 33 66 1 1914005040 7438352 9184432
20:15:40 5068 8192000000 10817031968 11248455680 1895602816 18.791 100 26 52 0 1909659504 6898784 7157904
20:15:52 3186 8192000000 10824422192 11259187200 1903395968 18.854 100 37 74 0 1925450704 11555168 10499568
20:16:01 5847 8192000000 10820192880 11254505472 1903802160 18.857 100 28 57 0 1917347712 6064048 7481504
20:16:14 3972 8192000000 10805373792 11238907904 1887394720 18.725 99 35 70 2 1903937952 6638016 9905216
20:16:27 7935 8192000000 10822197232 11252592640 1895950112 18.794 100 29 58 0 1914806800 10745840 8110848
20:16:42 9645 8192000000 10810040704 11243278336 1878686416 18.654 99 19 38 0 1889551568 5899072 4966080
20:16:57 6148 8192000000 10813791296 11251163136 1880464880 18.669 99 20 40 1 1900643216 15048896 5129440
20:17:12 8140 8192000000 10800415872 11228426240 1852725056 18.444 98 16 32 3 1862916320 5509296 4681968
20:17:27 45536 8192000000 10807737264 11229986816 1867135808 18.561 99 28 55 0 1881237344 5900112 8201424
20:18:25 25519 8192000000 10783817952 11208458240 1775251440 17.810 94 19 38 1 1786085552 4981152 5852960
20:18:57 5466 8192000000 10777568928 11206225920 1857887008 18.486 99 24 48 1 1871218816 6496608 6835200
20:19:09 3360 8192000000 10749093056 11168251904 1795663472 17.978 96 39 72 4 1813043056 5655376 11724208
20:19:22 5318 8192000000 10741154096 11164930048 1783919072 17.882 97 31 61 3 1803382992 9897680 9566240
20:19:39 5876 8192000000 10724258800 11144695808 1792982256 17.956 98 32 64 1 1809273248 6924928 9366064
20:19:51 4893 8192000000 10729648784 11147448320 1784226432 17.884 98 36 72 2 1801426432 7114144 10085856
20:20:04 10463 8192000000 10677232512 11093004288 1643267488 16.707 91 20 38 3 1654853904 5234640 6351776
20:20:21 8716 8192000000 10691397008 11097788416 1698498656 17.173 95 28 54 0 1711883632 5359568 8025408
20:20:36 5750 8192000000 10688063824 11102826496 1742710704 17.541 98 22 44 3 1754205920 5287200 6208016
20:20:48 9074 8192000000 10703232560 11121086464 1754166848 17.636 98 16 32 2 1764233520 5677968 4388704
20:21:07 8530 8192000000 10700407440 11120361472 1725775216 17.400 96 15 28 0 1735526400 5304864 4446320
20:21:22 7128 8192000000 10675463792 11088056320 1740640976 17.524 97 22 44 1 1752777984 5687008 6450000
20:21:36 10688 8192000000 10693225648 11117535232 1760656672 17.690 98 16 32 0 1770724704 5188976 4879056
20:21:57 63333 8192000000 10762392800 11149578240 1780283856 17.852 98 52 103 0 1802262896 5993344 15985696
20:23:06 7204 8192000000 10721437984 11148890112 1813525488 18.125 100 18 35 2 1824367968 6064112 4778368
20:23:24 9967 8192000000 10729811440 11160870912 1803560176 18.043 99 21 41 5 1815268416 5549184 6159056
20:23:42 5792 8192000000 10747387376 11162492928 1823929424 18.210 100 29 58 1 1838602816 6319856 8353536
20:23:56 6403 8192000000 10767257856 11181494272 1840182816 18.342 100 32 62 2 1855268656 6766816 8319024
20:24:09 5222 8192000000 10762213904 11181625344 1842225952 18.359 100 43 86 1 1862991584 8848000 11917632
20:24:22 6634 8192000000 10776962784 11194372096 1848641520 18.411 100 38 76 0 1870583056 10765216 11176320
20:24:35 7691 8192000000 10770002256 11191508992 1851955248 18.438 100 32 65 2 1866130320 4732048 9443024
20:24:51 10969 8192000000 10763897024 11195310080 1854007808 18.455 100 23 46 0 1866717216 4889552 7819856
20:25:09 14557 8192000000 10766930432 11201413120 1858917776 18.495 100 13 26 2 1868006480 4938160 4150544
20:25:31 7659 8192000000 10773466368 11207602176 1863960832 18.535 100 23 47 1 1876737856 5876144 6900880
20:25:46 7313 8192000000 10787338528 11214774272 1871573136 18.597 100 33 66 0 1886872864 5717328 9582400
20:26:14 8905 8192000000 10789002208 11218108416 1872549968 18.605 100 21 41 2 1884167904 5675520 5942416
20:26:30 56364 8192000000 10808339888 11228676096 1878448160 18.653 100 25 49 1 1892745360 5271536 9025664
20:27:48 22899 8192000000 10829691328 11253448704 1907098368 18.883 100 41 77 1 1924767040 5918192 11750480
20:28:27 5182 8192000000 10849359600 11271434240 1919556960 18.983 100 48 96 2 1941073840 7374640 14142240
20:28:42 10736 8192000000 10857262464 11279249408 1925411664 19.030 100 48 94 3 1947854336 9242832 13199840
20:28:59 17052 8192000000 10869743968 11289128960 1929209808 19.061 100 53 106 0 1954183680 10456112 14517760
20:29:24 23731 8192000000 10883077232 11306807296 1943913648 19.178 100 51 102 1 1972685776 14230144 14541984
20:30:04 25772 8192000000 10888088048 11319132160 1950310224 19.229 100 47 94 1 1976579760 12410976 13858560
20:30:53 17530 8192000000 10889990720 11328290816 1959458320 19.302 100 33 66 1 1984294128 14859264 9976544
20:31:19 12556 8192000000 10911425280 11337367552 1965236048 19.348 100 48 96 2 1997002800 17433088 14333664
20:31:39 15114 8192000000 10902684128 11342127104 1968092480 19.370 100 44 88 0 2001062992 19787056 13183456
20:32:12 11693 8192000000 10906743680 11341041664 1955551872 19.271 99 53 107 0 1990749344 19073312 16124160
20:32:36 16103 8192000000 10916160672 11346284544 1972748096 19.407 100 51 102 0 2007443600 19672800 15022704
20:33:00 9187 8192000000 10922094880 11351957504 1974127520 19.418 100 48 94 1 2009090720 20511376 14451824
20:33:20 4407 8192000000 10927211360 11354365952 1978760400 19.455 100 60 116 2 2015946240 20194704 16991136
20:33:36 3524 8192000000 10941998208 11363086336 1984862304 19.503 100 68 136 3 2026331152 22625440 18843408
20:33:59 15289 8192000000 10908802912 11341266944 1960712608 19.312 99 54 107 1 1999265200 22832528 15720064
20:34:24 10020 8192000000 10909518144 11346030592 1971344176 19.396 100 46 92 3 2007079440 20957232 14778032
20:35:03 15572 8192000000 10927356672 11358601216 1980584544 19.469 100 54 107 2 2016695456 20784368 15326544
20:35:26 3087 8192000000 10926979680 11355168768 1979665776 19.462 100 66 132 2 2020719760 21959904 19094080
20:35:37 4876 8192000000 10932407200 11354251264 1976572208 19.438 100 67 135 0 2017995744 22018112 19405424
20:35:49 3597 8192000000 10938783856 11358150656 1981728816 19.478 100 71 141 2 2024999296 23344128 19926352
20:35:59 3123 8192000000 10952002208 11367534592 1986955504 19.520 100 79 155 1 2033696096 23780896 22959696
20:36:20 7405 8192000000 10943302448 11371462656 1989114608 19.537 100 64 126 1 2031196304 23812832 18268864
20:36:37 2770 8192000000 10954322704 11375529984 1994677696 19.581 100 70 141 2 2040642560 25092448 20872416
20:36:47 1777 8192000000 10973761184 11386097664 2003956640 19.654 100 83 166 0 2056008112 27410896 24640576
20:36:56 5156 8192000000 10953842768 11384627200 1999562080 19.619 100 71 142 2 2048764992 28163584 21039328
20:37:07 1622 8192000000 10972850128 11388305408 2002882384 19.645 100 69 136 1 2050269344 27556640 19830320
20:37:16 2988 8192000000 10965104672 11380957184 1997950848 19.607 100 84 163 2 2050799696 28712112 24136736
20:37:26 3470 8192000000 10981388048 11392528384 2002324592 19.641 100 86 170 1 2058564144 30646912 25592640
20:37:37 2002 8192000000 10987056368 11400765440 2008921648 19.693 100 91 182 2 2067364016 30750000 27692368
20:37:45 7153 8192000000 10972016016 11401519104 2009131824 19.695 100 74 148 0 2063304080 31749824 22422432
20:38:01 14082 8192000000 10972348160 11403812864 2010741920 19.707 100 55 110 3 2059795376 32255264 16798192
20:38:22 15749 8192000000 10978719792 11416350720 2013325584 19.728 100 64 128 3 2069077104 36089440 19662080
20:38:56 3917 8192000000 10981673456 11415638016 2013123072 19.726 100 55 108 3 2067774656 36975824 17675760
20:39:08 7266 8192000000 10963951936 11405119488 2002241200 19.640 100 50 98 1 2056442048 37812896 16387952
20:39:24 8319 8192000000 10969560848 11402051584 1986293680 19.514 99 66 132 0 2044286192 37745840 20246672
20:39:40 4022 8192000000 10985911920 11412406272 2007752736 19.684 100 76 152 0 2070282704 38422000 24107968
20:39:52 4455 8192000000 10989198736 11418546176 2009858208 19.700 100 74 149 0 2074433728 42130240 22445280
20:40:05 5890 8192000000 10984640368 11415642112 1996641696 19.596 99 74 148 2 2056140288 34734256 24764336
20:40:24 2158 8192000000 10972546704 11405475840 1992527104 19.564 99 61 118 2 2047072976 35286944 19258928
20:40:37 4664 8192000000 11000286240 11418099712 2005321040 19.665 100 82 161 2 2071300400 41011712 24967648
20:40:53 3406 8192000000 10970575280 11391455232 1989157328 19.537 100 74 148 3 2051700944 40407440 22136176
20:41:04 2526 8192000000 10979622048 11403452416 1996154928 19.592 100 88 174 0 2064532384 41564816 26812640
20:41:13 1461 8192000000 10987752160 11410423808 2005586080 19.667 100 86 173 2 2070068720 39109680 25372960
20:41:22 4296 8192000000 10978453504 11408281600 2008642032 19.691 100 75 150 0 2067107104 35834224 22630848
20:41:33 4723 8192000000 10969187760 11400601600 1983434816 19.492 99 68 136 0 2039652688 35748768 20469104
20:41:46 2385 8192000000 10952544160 11370659840 1957655424 19.287 98 74 149 0 2014079088 34074400 22349264
20:41:58 12501 8192000000 10930815760 11360366592 1947058192 19.203 99 71 141 0 1999997792 32303328 20636272
20:42:20 3402 8192000000 10966647680 11388387328 1993101760 19.568 100 83 163 5 2051492880 33075776 25315344
20:42:32 3248 8192000000 10975118288 11391987712 1991627312 19.557 100 87 174 0 2052731312 34897312 26206688
20:42:42 3896 8192000000 10978513856 11394531328 1995885216 19.590 100 85 169 0 2057768832 36280544 25603072
20:42:52 932 8192000000 10957596416 11383881728 1982917712 19.488 100 75 150 2 2043257728 36441312 23898704
20:43:02 8028 8192000000 10902440544 11337936896 1927956912 19.051 99 49 98 1 1976990368 34080352 14953104
20:43:17 3575 8192000000 10921875056 11358818304 1959591888 19.303 100 46 92 0 2007345296 32838608 14914800
20:43:28 10023 8192000000 10908097616 11339972608 1927400832 19.046 98 44 88 1 1972991008 31341616 14248560
20:43:51 1727 8192000000 10944218624 11369926656 1970409552 19.389 100 70 138 0 2027171280 35669280 21092448
20:44:01 2000 8192000000 10942521008 11358539776 1960282160 19.308 99 81 162 1 2022968192 37134096 25551936
20:44:10 2994 8192000000 10956901136 11382325248 1971303520 19.396 100 67 134 0 2036352800 44428416 20620864
20:44:21 6260 8192000000 10946560560 11370332160 1950720784 19.232 99 68 133 1 2013760736 42940352 20099600
20:44:35 3688 8192000000 10940254320 11370401792 1968725216 19.375 100 65 128 3 2029085232 40216352 20143664
20:44:48 10714 8192000000 10910255824 11339546624 1921346112 18.998 98 40 80 2 1972605696 38349520 12910064
20:45:10 2111 8192000000 10954122400 11375923200 1976169712 19.434 100 88 176 1 2043788288 40440656 27177920
20:45:19 2542 8192000000 10964700704 11385466880 1976346256 19.436 100 90 178 1 2048612704 44665344 27601104
20:45:28 1817 8192000000 10982292880 11400744960 1991089632 19.552 100 80 161 0 2061809344 46176768 24542944
20:45:38 5164 8192000000 10939753808 11366633472 1965188544 19.347 99 55 110 0 2028707104 45451744 18066816
20:45:51 12801 8192000000 10938474176 11382358016 1976440128 19.437 100 46 92 2 2031243920 40480480 14323312
20:46:27 11454 8192000000 10919611824 11350757376 1938862240 19.138 99 47 94 0 1992979440 39217120 14900080
20:46:51 6314 8192000000 10928603504 11362938880 1951045840 19.235 99 53 106 3 2004429552 36861856 16521856
20:47:05 1230 8192000000 10914747920 11333914624 1929399232 19.062 98 62 124 1 1987443712 37463456 20581024
20:47:14 7788 8192000000 10953841456 11369631744 1972684928 19.407 100 81 162 1 2037890592 40148832 25056832
20:47:29 4376 8192000000 10975373376 11387420672 1982148160 19.482 100 80 160 2 2051320160 44617568 24554432
20:47:41 6156 8192000000 10949744512 11380551680 1965159776 19.347 99 54 108 1 2026027808 43778528 17089504
20:47:58 9735 8192000000 10924227328 11363430400 1941278656 19.157 99 39 78 0 2001126064 47181344 12666064
20:48:25 11235 8192000000 10939043840 11383590912 1974237088 19.419 100 38 74 0 2028657168 41981712 12438368
20:48:45 10630 8192000000 10939870848 11371917312 1939309504 19.141 98 37 74 2 1993688768 42109280 12269984
20:49:02 6405 8192000000 10964505280 11386728448 1978867904 19.456 100 55 110 0 2040077968 43693824 17516240
20:49:18 6919 8192000000 10938816224 11372781568 1950974640 19.234 99 41 82 4 2009203728 44789456 13439632
20:49:37 11595 8192000000 10947588160 11387670528 1955592320 19.271 99 40 79 2 2016749840 48253648 12903872
20:49:59 25305 8192000000 10955537296 11397402624 1974175296 19.419 100 37 73 1 2034907856 48695248 12037312
20:51:00 15488 8192000000 10947099264 11392675840 1975302768 19.427 100 31 62 2 2034084992 48706704 10075520
20:51:42 23620 8192000000 10937542464 11395555328 1942822352 19.169 99 27 54 0 2017085904 63558176 10705376
20:52:18 13952 8192000000 10913209776 11381800960 1939920400 19.146 100 17 34 0 1997729216 51253104 6555712
20:53:14 27325 8192000000 10901735888 11352649728 1926010176 19.035 99 23 46 2 1989840464 55575136 8255152
20:53:48 29338 8192000000 10872208096 11346288640 1898852240 18.817 98 12 24 1 1950415792 47049904 4513648
20:54:24 42844 8192000000 10824668432 11280392192 1815703296 18.143 94 10 20 0 1831728736 13158544 2866896
20:55:23 69488 8192000000 10843634320 11304607744 1875372448 18.628 98 15 30 0 1896866448 16754752 4739248
20:56:55 43281 8192000000 10866900320 11299401728 1897813184 18.809 99 30 56 5 1914133664 8626016 7694464
20:57:50 116589 8192000000 10871282880 11332997120 1891771152 18.760 97 29 58 2 1908073536 8764816 7537568
21:00:36 51729 8192000000 10891860304 11349438464 1963514864 19.334 100 34 70 0 1983539120 9625968 10398288
21:01:38 151445 8192000000 10901991328 11338768384 1869177424 18.578 95 41 86 0 1895034304 14384688 11472192
21:04:18 48998 8192000000 10894441008 11353186304 1959545712 19.302 100 42 80 4 1982945520 11820304 11579504
21:05:53 42911 8192000000 10907774928 11370819584 1973047584 19.410 100 34 68 1 1998142272 15173520 9921168
21:06:43 16644 8192000000 10913346304 11373772800 1973513888 19.413 100 33 64 1 2000239872 16382240 10343744
21:07:08 11602 8192000000 10914607200 11373514752 1980125776 19.466 100 34 67 2 2003121360 13432944 9562640
21:07:33 9736 8192000000 10921500928 11382177792 1986685808 19.518 100 30 60 0 2007652256 12368208 8598240
21:07:55 48931 8192000000 10907640032 11383721984 1986542128 19.516 100 19 38 0 2005862784 13471536 5849120
21:08:54 18685 8192000000 10903887952 11365912576 1959713296 19.304 99 26 52 1 1980230368 12470176 8046896
21:09:23 32251 8192000000 10905696736 11374628864 1976759504 19.439 100 21 41 1 1998694000 15464880 6469616
21:10:04 11202 8192000000 10914235504 11384266752 1981323888 19.475 100 19 38 1 2004283760 17134512 5825360
21:10:21 16712 8192000000 10911804336 11390205952 1983115136 19.489 100 16 31 2 2004346304 16153248 5077920
21:12:11 76979 8192000000 10909936720 11401539584 1990248976 19.546 100 10 20 1 2004035872 10611856 3175040
21:13:34 82022 8192000000 10899539360 11391754240 1973136544 19.410 99 15 31 0 1989485024 12144880 4203600
21:15:08 34611 8192000000 10905974560 11389300736 1987648656 19.525 100 6 12 0 2000613696 11160752 1804288
21:15:49 38613 8192000000 10894514544 11382710272 1952796080 19.249 98 14 28 1 1967238592 9847888 4594624
21:17:19 83864 8192000000 10918588288 11400228864 1978089696 19.450 99 15 30 1 1992460576 10182448 4188432
21:18:52 107569 8192000000 10920734736 11398213632 1979903312 19.464 99 19 37 1 1998500336 13362960 5234064
21:20:47 43795 8192000000 10923820976 11404505088 1996147872 19.592 100 16 32 2 2011022224 9642528 5231824
21:21:38 84425 8192000000 10921634960 11401060352 1974407184 19.420 99 20 40 0 1994542064 14300192 5834688
21:23:09 72726 8192000000 10900672544 11374501888 1915229072 18.949 96 15 30 1 1938199440 17978192 4992176
21:24:29 74016 8192000000 10909522544 11359232000 1863889264 18.535 94 13 26 1 1877156400 9867200 3399936
21:25:50 29628 8192000000 10888735968 11348516864 1906112880 18.875 97 47 94 3 1930907664 12041072 12753712
21:26:31 48040 8192000000 10877729552 11349000192 1934334544 19.102 99 19 38 0 1953366192 14198416 4833232
21:27:31 32348 8192000000 10893178432 11346989056 1916304016 18.957 98 22 44 1 1932322816 10653920 5364880
21:28:15 41675 8192000000 10886579520 11342409728 1898529248 18.814 97 28 56 1 1921677696 15480976 7667472
21:29:03 66946 8192000000 10850165216 11319373824 1845614000 18.386 95 13 26 1 1861161168 12399776 3147392
21:30:16 157264 8192000000 10847133488 11322523648 1830174880 18.261 94 31 62 1 1852445088 14051568 8218640
21:32:59 72369 8192000000 10841950224 11315933184 1884941600 18.705 98 11 22 1 1899819792 12183200 2694992
21:34:18 10490 8192000000 10861318432 11320299520 1898035472 18.810 98 34 68 0 1920316736 12443168 9838096
21:34:35 19675 8192000000 10865643360 11307614208 1890061952 18.746 98 45 90 1 1912013328 9092224 12859152
21:35:07 65256 8192000000 10850255024 11319894016 1887711808 18.727 98 17 34 2 1901390736 8694192 4984736
21:36:35 38038 8192000000 10860727824 11332599808 1934076576 19.099 100 15 30 0 1949895680 12373616 3445488
21:37:19 72177 8192000000 10833304768 11312943104 1821677328 18.191 94 13 26 1 1834466272 9067440 3721504
21:38:39 78706 8192000000 10832064336 11308630016 1896840976 18.801 98 14 27 0 1908779872 7800800 4138096
21:40:18 89176 8192000000 10842493696 11326988288 1908097792 18.891 99 12 24 0 1926681744 15215072 3368880
21:41:54 90722 8192000000 10838989696 11306500096 1835497968 18.304 95 8 16 0 1855160560 17607760 2054832
21:43:49 46406 8192000000 10850092048 11319984128 1917914400 18.970 100 22 44 0 1934072512 9792528 6365584
21:44:42 30430 8192000000 10863676656 11327467520 1898401856 18.813 98 33 66 2 1917533296 8920016 10211424
21:45:19 85502 8192000000 10843194800 11321868288 1857058848 18.479 96 14 28 2 1872424992 11463520 3902624
21:46:50 65786 8192000000 10870439152 11327668224 1898725440 18.816 98 14 28 1 1915548784 13027968 3795376
21:48:06 65287 8192000000 10856393744 11317989376 1912955472 18.930 99 20 39 0 1932766928 13429664 6381792
21:49:19 43696 8192000000 10878082736 11329757184 1922314464 19.005 99 36 72 1 1942859232 10294368 10250400
21:50:15 57007 8192000000 10863126320 11330928640 1917449024 18.966 99 29 58 1 1939572272 13960448 8162800
21:51:46 56010 8192000000 10875035104 11337707520 1929471168 19.063 100 24 48 1 1952675392 16494832 6709392
21:52:48 171259 8192000000 10857991984 11331698688 1882591680 18.686 97 13 26 0 1903764704 17423312 3749712
21:55:52 106386 8192000000 10888883088 11338153984 1952048912 19.243 100 46 92 0 1974362528 9145008 13168608
21:57:45 8627 8192000000 10880360720 11326971904 1945247760 19.189 100 59 114 0 1971814176 11033824 15532592
21:58:03 7885 8192000000 10879116576 11330957312 1934670544 19.104 99 57 114 1 1960590160 10481408 15438208
21:58:31 46149 8192000000 10860200480 11328069632 1904751552 18.864 98 17 34 0 1918970960 9901232 4318176
21:59:23 105879 8192000000 10873933600 11349327872 1914595776 18.944 98 13 26 0 1933182912 15204960 3382176
22:01:22 34436 8192000000 10867158320 11361062912 1938762096 19.137 100 6 12 0 1958304208 18188640 1353472
22:02:03 40245 8192000000 10873237040 11356098560 1948713872 19.216 100 10 20 0 1965126896 13943680 2469344
22:03:26 45245 8192000000 10900337264 11370164224 1975842160 19.432 100 24 48 0 1995601552 12668544 7090848
22:04:18 44402 8192000000 10927133616 11379273728 1963516064 19.334 99 23 47 2 1987201232 16454048 7231120
22:05:09 75776 8192000000 10913122192 11385196544 1979800960 19.463 100 18 36 0 2011489552 26155872 5532720
22:06:34 54589 8192000000 10892106384 11361959936 1908259952 18.893 97 21 42 0 1937354032 22642816 6451264
22:07:42 86649 8192000000 10870115088 11319447552 1848756880 18.412 95 18 36 2 1862000960 8449456 4794624
22:09:18 18025 8192000000 10895580704 11349389312 1954128736 19.259 100 46 91 1 1978907648 11279296 13499616
22:09:47 47988 8192000000 10899950880 11351179264 1916888944 18.962 98 29 59 2 1938309632 13113616 8307072
22:10:56 70678 8192000000 10857739648 11328675840 1888157296 18.731 97 14 28 1 1907076144 14955328 3963520
22:12:14 44692 8192000000 10883348944 11323572224 1865374064 18.547 96 34 67 2 1885996080 11838448 8783568
22:13:06 29110 8192000000 10874085232 11329581056 1933067872 19.091 100 28 56 0 1953105808 12667648 7370288
22:13:44 42430 8192000000 10876848368 11330400256 1886869648 18.721 97 29 58 0 1905611408 10671888 8069872
22:14:34 31384 8192000000 10882654352 11336216576 1907481984 18.886 98 33 66 2 1930136800 13343776 9311040
22:15:17 126215 8192000000 10852849312 11306659840 1878657392 18.654 97 24 48 1 1896802128 11682720 6462016
22:17:42 57176 8192000000 10854422208 11327680512 1931726816 19.081 100 15 30 0 1946351360 10432048 4192496
22:19:20 69559 8192000000 10848121504 11320156160 1925599440 19.032 99 12 24 0 1943029488 13460704 3969344
22:20:36 52928 8192000000 10853130912 11335262208 1919918336 18.986 99 10 20 1 1934926016 11953200 3054480
22:21:44 80484 8192000000 10837893152 11309477888 1857757968 18.485 96 13 26 0 1871416976 9672064 3986944
22:23:16 58886 8192000000 10883324544 11334488064 1922122704 19.004 99 26 52 0 1941009328 11156112 7730512
22:24:21 28438 8192000000 10820897904 11297325056 1900011200 18.826 98 27 54 1 1923677632 15909680 7756752
22:25:59 34105 8192000000 10836736448 11304701952 1910433344 18.910 99 10 20 0 1921753504 8596272 2723888
22:26:40 39775 8192000000 9130355488 9363525632 298627792 3.517 16 3 4 2 301237488 1849952 759744

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 04-01-2021 22:28:49 to 04-01-2021 22:29:20.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 118 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 04-01-2021 22:29:21 to 04-01-2021 22:29:23.

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          239675
MON$OLDEST_ACTIVE               239676
MON$OLDEST_SNAPSHOT             239676
MON$NEXT_TRANSACTION            239676
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                       2034336
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.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 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 ---
:412: 
:413: mscs-test-161.budzdorov.ru    Mon Jan  4 22:27:22 2021
:414:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:415: 
:416: 
:417: mscs-test-161.budzdorov.ru    Mon Jan  4 22:27:23 2021
:418:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:419: 
--- end of diff output ---

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

04.01.21 22:29:24. 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-01-04 22:29:27 No severe PSQL-related problems occured
04.01.21 22:29:28. End of report.