Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 16.11.2020 22:29
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 17512980 kB
MemAvailable 31453960 kB
Buffers 0 kB
Cached 14215580 kB
SwapCached 3832 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 2020-11-16 22:27:00
DTS_END                         2020-11-16 22:27:00.0820
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/56238
TRN_ID                          238119
ATT_ID                          679
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: 8861.49 23556 1063379
customer order: creation 164.38 366 19725
customer order: refuse 13.69 338 1643
order to supplier: creation 43.76 1279 5251
order to supplier: removal 3.22 100690 386
invoice (draft): creation 43.43 3655 5212
invoice (draft): removal 51.01 746 6121
invoice accept: apply 40.43 18646 4852
invoice accept: cancel 45.72 772 5486
customer reserve: creation 3699.10 186 443892
customer reserve: removal 4473.48 57 536817
realization accept: apply 80.22 184 9626
realization accept: cancel 79.18 95 9501
payment from customer: creation 56.82 134 6818
payment from customer: removal 5.49 92 659
payment to supplier: creation 46.68 147 5602
payment to supplier: removal 3.38 115 405
service: total inventory turnovers 4.37 1458 524
service: total monetary turnovers 6.31 25 757
service: aggregate perf. data 0.82 21924 98
service: refresh index statistics 0.03 320203 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 16-11-2020 22:29:48 to 16-11-2020 22:29:51.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6219
TEST_TIME 2 3890
TEST_TIME 3 4473
TEST_TIME 4 4560
TEST_TIME 5 4439
TEST_TIME 6 4366
TEST_TIME 7 4609
TEST_TIME 8 5023
TEST_TIME 9 5054
TEST_TIME 10 5383
TEST_TIME 11 5437
TEST_TIME 12 5713
TEST_TIME 13 5681
TEST_TIME 14 5908
TEST_TIME 15 6278
TEST_TIME 16 6874
TEST_TIME 17 7059
TEST_TIME 18 7322
TEST_TIME 19 7947
TEST_TIME 20 8266
TEST_TIME 21 8313
TEST_TIME 22 8964
TEST_TIME 23 9542
TEST_TIME 24 9945
TEST_TIME 25 9752
TEST_TIME 26 10081
TEST_TIME 27 9897
TEST_TIME 28 9732
TEST_TIME 29 9933
TEST_TIME 30 9688
TEST_TIME 31 9717
TEST_TIME 32 9734
TEST_TIME 33 9785
TEST_TIME 34 9896
TEST_TIME 35 9700
TEST_TIME 36 9623
TEST_TIME 37 9478
TEST_TIME 38 9496
TEST_TIME 39 9444
TEST_TIME 40 9287
TEST_TIME 41 9199
TEST_TIME 42 9114
TEST_TIME 43 9144
TEST_TIME 44 9041
TEST_TIME 45 8969
TEST_TIME 46 8985
TEST_TIME 47 8974
TEST_TIME 48 8879
TEST_TIME 49 8811
TEST_TIME 50 8681
TEST_TIME 51 8706
TEST_TIME 52 8627
TEST_TIME 53 8539
TEST_TIME 54 8557
TEST_TIME 55 8580
TEST_TIME 56 8553
TEST_TIME 57 8614
TEST_TIME 58 8657
TEST_TIME 59 8619
TEST_TIME 60 8634
TEST_TIME 61 8825
TEST_TIME 62 8850
TEST_TIME 63 8888
TEST_TIME 64 8902
TEST_TIME 65 8921
TEST_TIME 66 8951
TEST_TIME 67 8947
TEST_TIME 68 8948
TEST_TIME 69 9199
TEST_TIME 70 9087
TEST_TIME 71 8985
TEST_TIME 72 8913
TEST_TIME 73 8893
TEST_TIME 74 8922
TEST_TIME 75 8865
TEST_TIME 76 8811
TEST_TIME 77 8773
TEST_TIME 78 8754
TEST_TIME 79 8680
TEST_TIME 80 8772
TEST_TIME 81 8721
TEST_TIME 82 8728
TEST_TIME 83 8722
TEST_TIME 84 8771
TEST_TIME 85 8790
TEST_TIME 86 8779
TEST_TIME 87 8797
TEST_TIME 88 8855
TEST_TIME 89 8857
TEST_TIME 90 8887
TEST_TIME 91 8892
TEST_TIME 92 8902
TEST_TIME 93 8943
TEST_TIME 94 8963
TEST_TIME 95 8902
TEST_TIME 96 8884
TEST_TIME 97 8838
TEST_TIME 98 8853
TEST_TIME 99 8825
TEST_TIME 100 8827
TEST_TIME 101 8776
TEST_TIME 102 8764
TEST_TIME 103 8766
TEST_TIME 104 8766
TEST_TIME 105 8735
TEST_TIME 106 8785
TEST_TIME 107 8770
TEST_TIME 108 8744
TEST_TIME 109 8884
TEST_TIME 110 8930
TEST_TIME 111 9014
TEST_TIME 112 8998
TEST_TIME 113 8977
TEST_TIME 114 8968
TEST_TIME 115 9071
TEST_TIME 116 9051
TEST_TIME 117 8985
TEST_TIME 118 8950
TEST_TIME 119 8936
TEST_TIME 120 8861

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 16-11-2020 22:29:52 to 16-11-2020 22:29:55.

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 1474339 1474339 0 0.00 0 34439 7 0 0
doc_list_biud 1474339 1474339 0 0.00 0 26155 26 0 0
sp_add_invoice_to_stock 4945 4852 93 1.88 43 191602 18647 0 93
sp_cancel_adding_invoice 5486 5486 0 0.00 5 70091 773 0 0
sp_cancel_client_order 1643 1643 0 0.00 4 17691 338 0 0
sp_cancel_customer_reserve 536817 536817 0 0.00 1 24213 57 0 0
sp_cancel_pay_from_customer 659 659 0 0.00 2 9155 92 0 0
sp_cancel_pay_to_supplier 405 405 0 0.00 3 9737 115 0 0
sp_cancel_supplier_invoice 6130 6121 9 0.14 1 26163 746 0 9
sp_cancel_supplier_order 386 386 0 0.00 8 913739 100691 0 0
sp_cancel_write_off 9501 9501 0 0.00 1 6607 96 0 0
sp_client_order 19725 19725 0 0.00 3 35917 367 0 0
sp_customer_reserve 443892 443892 0 0.00 0 47531 187 0 0
sp_fill_shopping_cart 30179 30179 0 0.00 1 29659 43 0 0
sp_fill_shopping_cart_clo_res 443892 443892 0 0.00 0 19162 14 0 0
sp_get_clo_for_invoice 4852 4852 0 0.00 0 19162 355 0 0
sp_kill_cost_storno 16051 16051 0 0.00 0 8779 52 0 0
sp_kill_qstorno_ret_qs2qd 1089642 1089642 0 0.00 0 26153 31 0 0
sp_kill_qty_storno 574431 574431 0 0.00 0 26154 67 0 0
sp_lock_selected_doc 19887 19887 0 0.00 0 9578 5 0 0
sp_make_cost_storno 26897 26897 0 0.00 0 16117 62 0 0
sp_multiply_rows_for_pdistr 26897 26897 0 0.00 0 19013 32 0 0
sp_multiply_rows_for_qdistr 19725 19725 0 0.00 0 12417 142 0 0
sp_pay_from_customer 6818 6818 0 0.00 3 19025 134 0 0
sp_pay_to_supplier 5602 5602 0 0.00 5 14652 148 0 0
sp_payment_common 12420 12420 0 0.00 1 9905 36 0 0
sp_qd_handle_on_cancel_clo 1643 1643 0 0.00 0 17684 308 0 0
sp_qd_handle_on_invoice_upd_sts 10337 10337 0 0.00 0 18192 338 0 0
sp_qd_handle_on_reserve_upd_sts 9626 9626 0 0.00 0 9836 54 0 0
sp_reserve_write_off 9626 9626 0 0.00 6 15471 185 0 0
sp_supplier_invoice 5212 5212 0 0.00 7 116334 3656 0 0
sp_supplier_order 5251 5251 0 0.00 5 44313 1280 0 0
srv_aggregate_perf_data 98 98 0 0.00 2540 534897 21925 0 0
srv_fill_mon_cache_memory 155 155 0 0.00 1358 128262 34392 0 0
srv_find_qd_qs_mism 1017647 1017647 0 0.00 0 34438 6 0 0
srv_make_invnt_saldo 524 524 0 0.00 35 117715 1459 0 0
srv_make_money_saldo 757 757 0 0.00 1 1520 25 0 0
srv_recalc_idx_stat 4 4 0 0.00 203908 554892 320204 0 0
t$perf-abend:sp_add_invoice_to_stock 93 93 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4852 4852 0 0.00 0 11852 190 0 0
t$perf-norm:sp_cancel_adding_invoice 379 379 0 0.00 1 6408 121 0 0
t$perf-norm:sp_cancel_client_order 1643 1643 0 0.00 0 6947 24 0 0
t$perf-norm:sp_cancel_customer_reserve 606 606 0 0.00 0 2489 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 659 659 0 0.00 0 2626 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 405 405 0 0.00 0 410 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 409 409 0 0.00 0 1353 18 0 0
t$perf-norm:sp_cancel_supplier_order 386 386 0 0.00 0 25743 1897 0 0
t$perf-norm:sp_cancel_write_off 923 923 0 0.00 0 9224 16 0 0
t$perf-norm:sp_client_order 19725 19725 0 0.00 0 11221 20 0 0
t$perf-norm:sp_customer_reserve 944 944 0 0.00 0 1298 5 0 0
t$perf-norm:sp_pay_from_customer 6818 6818 0 0.00 0 9825 17 0 0
t$perf-norm:sp_pay_to_supplier 5602 5602 0 0.00 0 7910 17 0 0
t$perf-norm:sp_reserve_write_off 9626 9626 0 0.00 0 7434 12 0 0
t$perf-norm:sp_supplier_invoice 5212 5212 0 0.00 0 7224 23 0 0
t$perf-norm:sp_supplier_order 5251 5251 0 0.00 0 9192 23 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 345 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 155 155 0 0.00 0 1171 12 0 0
t$perf-norm:srv_make_invnt_saldo 524 524 0 0.00 0 535 15 0 0
t$perf-norm:srv_make_money_saldo 757 757 0 0.00 0 924 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 72 19 0 0
v_add_invoice_to_stock 9888 9702 186 1.88 0 12037 19 0 186
v_all_customers 35664 35664 0 0.00 0 19 1 0 0
v_all_suppliers 28626 28626 0 0.00 0 32 1 0 0
v_all_wares 39450 39450 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 758 758 0 0.00 0 507 7 0 0
v_cancel_client_order 3286 3286 0 0.00 0 8904 6 0 0
v_cancel_customer_prepayment 1318 1318 0 0.00 0 2370 5 0 0
v_cancel_customer_reserve 1212 1212 0 0.00 0 883 3 0 0
v_cancel_payment_to_supplier 810 810 0 0.00 0 3925 9 0 0
v_cancel_supplier_invoice 836 818 18 2.15 0 920 14 0 18
v_cancel_supplier_order 772 772 0 0.00 0 230 3 0 0
v_cancel_write_off 1846 1846 0 0.00 0 4368 14 0 0
v_max_id_clo_ord 5249 5249 0 0.00 0 717 2 0 0
v_max_id_clo_res 944 944 0 0.00 0 3262 9 0 0
v_max_id_ord_sup 5205 5205 0 0.00 0 6399 6 0 0
v_max_non_paid_invoice 1743 1743 0 0.00 0 735 3 0 0
v_max_non_paid_realizn 3722 3722 0 0.00 0 3396 5 0 0
v_min_id_clo_ord 5249 5249 0 0.00 0 6052 11 0 0
v_min_id_clo_res 944 944 0 0.00 0 7182 11 0 0
v_min_id_ord_sup 5205 5205 0 0.00 0 4870 10 0 0
v_min_non_paid_invoice 5602 5602 0 0.00 0 9896 25 0 0
v_min_non_paid_realizn 6818 6818 0 0.00 0 6984 24 0 0
v_our_firm 9978 9978 0 0.00 0 45 1 0 0
v_reserve_write_off 19252 19252 0 0.00 0 9450 5 0 0
x_lock_depdocs_on_canc_invoice 11198 11198 0 0.00 0 11889 116 0 0
x_lock_depdocs_on_canc_sup_ord 386 386 0 0.00 0 13274 463 0 0
x_make_qstorno_1000_1200 5251 5251 0 0.00 1 44301 1193 0 0
x_make_qstorno_1200_2000 5212 5212 0 0.00 3 112601 3497 0 0
x_make_qstorno_2100_3300 443892 443892 0 0.00 0 46226 170 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 16-11-2020 22:29:56 to 16-11-2020 22:30:01.

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:03 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:10 22348 8192000000 10255004288 10565132288 816570640 9.064 65 48 95 1 834348960 2287280 15491040
19:57:41 40227 8192000000 10342132848 10660323328 1391806848 14.522 100 86 172 1 1425600096 5289840 28503408
19:58:29 11799 8192000000 10362434560 10686517248 1426667120 14.832 100 91 182 0 1463491328 6697184 30127024
19:58:50 27942 8192000000 10387294224 10714365952 1436858528 14.922 100 88 176 0 1473398912 7557136 28983248
19:59:33 22721 8192000000 10421135392 10750705664 1472475424 15.235 100 93 186 0 1510997072 8306448 30215200
20:00:07 19538 8192000000 10426771392 10762592256 1485897616 15.353 100 86 172 1 1522770256 9032176 27840464
20:00:35 16513 8192000000 10443585856 10777255936 1495710624 15.439 100 85 170 0 1532317392 9262800 27343968
20:01:08 11012 8192000000 10460827424 10802933760 1522062160 15.668 100 85 170 1 1558720016 9735296 26922560
20:01:37 9942 8192000000 10493928768 10842075136 1550421232 15.914 100 79 158 1 1585274784 10061760 24791792
20:01:54 11109 8192000000 10510317856 10865369088 1570350080 16.085 100 75 150 1 1604189664 10510832 23328752
20:02:14 12425 8192000000 10545794368 10899763200 1601092816 16.349 100 83 166 0 1636812112 10791296 24928000
20:02:34 12472 8192000000 10569116144 10927308800 1626785184 16.568 100 77 154 0 1660903232 10964624 23153424
20:02:54 10403 8192000000 10597411472 10959613952 1648815888 16.754 100 82 164 0 1685610192 12250480 24543824
20:03:13 9036 8192000000 10601230544 10969403392 1663030592 16.874 100 82 163 2 1699614800 12971952 23612256
20:03:32 8667 8192000000 10620745552 10993922048 1685133920 17.060 100 77 154 0 1720007360 12460608 22412832
20:03:48 6106 8192000000 10641343600 11013619712 1702182656 17.203 100 87 175 5 1741041056 13048016 25810384
20:04:02 7794 8192000000 10661325280 11034447872 1720998000 17.361 100 82 165 0 1757595328 12673408 23923920
20:04:16 7613 8192000000 10670037456 11047006208 1731476208 17.448 100 77 152 0 1766291312 12741072 22074032
20:04:32 5540 8192000000 10683393456 11057983488 1745246112 17.562 100 75 150 0 1779079616 12381872 21451632
20:04:45 4577 8192000000 10687407632 11064610816 1755917472 17.651 100 82 162 0 1791408864 12988400 22502992
20:04:56 3333 8192000000 10701981584 11076075520 1761472416 17.697 100 83 165 3 1797083952 12656896 22954640
20:05:07 4768 8192000000 10705670784 11086712832 1765802048 17.732 100 82 164 1 1802663840 14242528 22619264
20:05:18 5361 8192000000 10714054032 11095339008 1775106064 17.809 100 85 171 2 1814063696 14961120 23996512
20:05:30 3594 8192000000 10723092832 11103305728 1785682256 17.896 100 87 173 2 1824633632 14712832 24238544
20:05:40 3008 8192000000 10725074784 11107680256 1789703088 17.929 100 86 172 1 1829408544 14516832 25188624
20:05:50 3540 8192000000 10720617440 11109036032 1792827200 17.955 100 78 156 0 1827111648 12871216 21413232
20:06:01 3079 8192000000 10731690368 11116359680 1798344416 18.000 100 82 165 0 1832825328 12321168 22159744
20:06:10 2201 8192000000 10739547632 11123437568 1803699520 18.044 100 79 157 0 1837312848 12517520 21095808
20:06:19 7159 8192000000 10745852944 11131191296 1813881344 18.128 100 89 180 1 1851608560 13044800 24682416
20:06:34 2908 8192000000 10766041728 11150753792 1820292816 18.180 100 84 166 1 1856057504 12703088 23061600
20:06:43 1826 8192000000 10764631264 11151269888 1826658960 18.232 100 86 170 0 1863816336 12426896 24730480
20:06:52 2739 8192000000 10783290400 11172958208 1843135504 18.366 100 89 179 0 1881951168 13381856 25433808
20:07:01 2099 8192000000 10783446096 11178418176 1849240816 18.416 100 90 176 2 1888220288 13129920 25849552
20:07:10 2012 8192000000 10793273920 11186851840 1850727728 18.428 100 92 185 2 1888707104 12765088 25214288
20:07:18 1799 8192000000 10801437824 11191934976 1857692320 18.485 100 89 178 0 1895768816 13382512 24693984
20:07:27 2908 8192000000 10808365120 11198697472 1862513440 18.524 100 91 182 1 1902149008 13722224 25913344
20:07:36 1876 8192000000 10812600400 11205136384 1866952448 18.560 100 90 180 0 1908348304 14613152 26782704
20:07:44 2279 8192000000 10812724864 11206754304 1870309456 18.587 100 92 185 1 1909762528 13490432 25962640
20:07:53 1308 8192000000 10828203056 11218173952 1873942992 18.616 100 93 187 0 1913672032 12950752 26778288
20:08:01 2417 8192000000 10823220256 11211493376 1878701392 18.655 100 92 182 3 1917435072 13776432 24957248
20:08:10 1402 8192000000 10823318400 11218980864 1881043984 18.674 100 89 177 1 1917274928 11478144 24752800
20:08:18 1068 8192000000 10827771584 11221323776 1885455600 18.709 100 96 191 0 1924361632 11703472 27202560
20:08:25 33153 8192000000 10795714784 11214131200 1877592912 18.646 100 46 92 2 1899345488 8117616 13634960
20:09:09 8567 8192000000 10803076864 11223113728 1881050560 18.674 100 52 104 0 1906024944 10435280 14539104
20:09:26 6667 8192000000 10789096944 11216867328 1879245504 18.659 100 34 68 0 1896156384 6951696 9959184
20:09:40 4867 8192000000 10817370448 11228782592 1887991728 18.730 100 40 80 3 1906752784 6927632 11833424
20:09:51 7105 8192000000 10807074928 11227029504 1886920960 18.721 100 24 48 0 1900245872 6720400 6604512
20:10:05 5519 8192000000 10809373424 11233157120 1892171264 18.763 100 26 52 1 1907438048 8141824 7124960
20:10:17 7030 8192000000 10809787344 11237625856 1896028048 18.794 100 31 62 2 1912795584 7120112 9647424
20:10:30 7839 8192000000 10802351808 11235500032 1893233712 18.772 100 18 36 0 1903745216 6057552 4453952
20:10:46 6634 8192000000 10812490592 11244244992 1896633248 18.799 100 18 37 1 1911145680 9948480 4563952
20:11:00 9324 8192000000 10804063072 11237236736 1900640800 18.831 100 26 52 2 1914213088 5819184 7753104
20:11:20 10478 8192000000 10799410272 11237974016 1899000464 18.818 100 21 42 2 1911608448 6905552 5702432
20:11:42 11966 8192000000 10810106416 11244093440 1899524864 18.822 100 16 32 1 1910203344 6299264 4379216
20:12:00 6670 8192000000 10813993600 11246546944 1900630608 18.831 100 21 41 3 1913072336 6237152 6204576
20:12:14 12707 8192000000 10803374912 11242274816 1900879216 18.833 100 14 28 2 1911046800 6025296 4142288
20:12:36 8134 8192000000 10820866208 11253002240 1908458944 18.894 100 20 40 2 1919787088 5961632 5366512
20:12:53 8022 8192000000 10828820144 11255595008 1915958032 18.954 100 42 85 6 1935004832 5952176 13094624
20:13:09 47374 8192000000 10820544608 11264339968 1913147744 18.932 100 20 41 1 1923987232 5208512 5630976
20:14:08 22969 8192000000 10808119440 11253235712 1894291088 18.780 99 13 26 0 1907570112 9723392 3555632
20:14:37 4155 8192000000 10851411584 11271307264 1919036656 18.979 100 52 102 0 1940445072 7273024 14135392
20:14:50 5249 8192000000 10834816032 11267293184 1899962576 18.826 99 31 62 0 1916421968 7982000 8477392
20:15:02 3155 8192000000 10832504160 11265015808 1913546864 18.935 100 32 63 2 1929016240 6012368 9457008
20:15:12 5499 8192000000 10847031424 11275091968 1916714192 18.961 100 30 61 0 1933651664 7103600 9833872
20:15:26 7643 8192000000 10839812128 11277836288 1920824240 18.993 100 24 48 0 1933858480 6524128 6510112
20:15:41 5718 8192000000 10843514736 11282169856 1922661328 19.008 100 26 52 0 1936375216 6362000 7351888
20:15:53 4774 8192000000 10842420704 11265306624 1912349168 18.926 100 29 57 2 1925894288 5825840 7719280
20:16:04 5893 8192000000 10803547280 11236089856 1862192176 18.521 98 28 56 0 1876042864 5653552 8197136
20:16:19 6620 8192000000 10812539232 11243327488 1876626832 18.638 99 26 51 0 1889433120 5477360 7328928
20:16:34 6925 8192000000 10810808880 11245920256 1892240688 18.764 100 17 34 0 1902449264 5511552 4697024
20:16:47 5142 8192000000 10795473904 11229499392 1873074608 18.609 99 25 49 3 1886357968 6057184 7226176
20:16:58 7942 8192000000 10785905568 11214491648 1856923904 18.478 98 24 48 1 1869485712 5545632 7016176
20:17:16 9513 8192000000 10753743616 11188342784 1781833376 17.865 95 18 36 0 1793147648 5460592 5853680
20:17:32 7125 8192000000 10785853408 11208921088 1843381168 18.368 99 24 48 0 1855761152 5689360 6690624
20:17:47 58394 8192000000 10730324224 11149811712 1707677696 17.249 92 33 66 1 1721563088 4673472 9211920
20:18:54 13312 8192000000 10701539424 11127934976 1739957264 17.518 95 22 44 1 1752068304 6080960 6030080
20:19:15 8727 8192000000 10745064896 11167510528 1798065632 17.998 98 25 50 2 1811742016 6458384 7218000
20:19:30 7082 8192000000 10730545456 11158183936 1811153904 18.105 99 33 65 2 1827479344 5962944 10362496
20:19:46 6473 8192000000 10685280384 11103195136 1722221472 17.371 95 35 70 1 1742193728 9973936 9998320
20:20:00 7124 8192000000 10722731824 11134734336 1748346752 17.588 96 28 54 1 1762028560 5371776 8310032
20:20:14 5915 8192000000 10716445136 11124256768 1753754832 17.633 97 34 68 1 1769494176 6211280 9528064
20:20:26 8610 8192000000 10704580368 11127791616 1768981456 17.759 98 31 62 0 1783991856 6366400 8644000
20:20:42 4674 8192000000 10733397984 11147005952 1796770640 17.987 99 33 66 1 1813995952 7934528 9290784
20:20:56 4952 8192000000 10699369568 11112574976 1769331152 17.761 99 25 50 1 1782676704 5731296 7614256
20:21:08 6715 8192000000 10690656112 11088166912 1733113520 17.461 97 21 43 0 1744897904 5609952 6174432
20:21:22 6411 8192000000 10692113280 11104874496 1734808080 17.475 97 21 42 3 1746386160 5661152 5916928
20:21:35 8532 8192000000 10713587456 11124568064 1794485856 17.969 100 31 62 1 1808621984 5060320 9075808
20:21:53 12016 8192000000 10749071344 11151773696 1806536048 18.068 100 29 57 2 1820901280 4958336 9406896
20:22:11 8673 8192000000 10743647408 11158290432 1820067824 18.178 100 22 44 0 1831860288 4999456 6793008
20:22:28 55586 8192000000 10780238400 11178766336 1838942000 18.332 100 48 96 3 1858313744 5081088 14290656
20:23:30 11773 8192000000 10752513664 11179806720 1840682640 18.346 100 22 44 1 1853729376 6569840 6476896
20:23:50 8497 8192000000 10761753984 11186774016 1844669264 18.379 100 20 40 2 1855571504 5926128 4976112
20:24:11 6851 8192000000 10771530560 11193044992 1852080320 18.439 100 37 74 1 1868493760 5465472 10947968
20:24:27 7752 8192000000 10776104496 11194187776 1854407536 18.458 100 37 75 3 1871652880 6222240 11023104
20:24:41 9418 8192000000 10760286784 11194679296 1852869088 18.445 100 22 44 0 1864912240 5269808 6773344
20:24:57 10024 8192000000 10771079728 11198722048 1858013776 18.487 100 25 50 1 1870031648 4747296 7270576
20:25:14 13324 8192000000 10772702304 11201568768 1859935120 18.503 100 15 30 0 1870320496 5773408 4611968
20:25:34 6735 8192000000 10776093120 11206197248 1861518528 18.516 100 11 22 1 1869827152 5054640 3253984
20:25:49 13755 8192000000 10773207648 11208167424 1864775408 18.542 100 20 40 2 1876786960 6186272 5825280
20:26:09 8536 8192000000 10783875840 11216510976 1871537536 18.597 100 12 24 0 1880547248 5372992 3636720
20:26:26 9087 8192000000 10790319120 11219886080 1877210944 18.643 100 25 50 1 1890027904 5108704 7708256
20:26:45 10593 8192000000 10785972320 11222695936 1877668832 18.646 100 12 24 1 1886564992 5573776 3322384
20:27:02 6525 8192000000 10845269760 11253211136 1903162160 18.852 100 54 110 2 1924117632 4482928 16472544
20:27:17 54295 8192000000 10852509696 11273551872 1920401984 18.990 100 48 94 2 1942561824 7241888 14917952
20:28:22 33660 8192000000 10855470096 11285803008 1933368304 19.094 100 47 90 3 1955881792 10201248 12312240
20:29:46 64174 8192000000 10869179200 11303112704 1915179984 18.948 99 36 72 3 1937455680 11611952 10663744
20:30:57 24820 8192000000 10873582448 11305807872 1941783920 19.161 100 26 52 2 1959406288 9816368 7806000
20:31:37 15523 8192000000 10881933360 11313070080 1949781152 19.225 100 34 66 3 1969316192 10235328 9299712
20:32:11 20995 8192000000 10890971616 11321102336 1956727984 19.280 100 48 96 0 1982509408 11906352 13875072
20:32:42 8588 8192000000 10897798064 11325607936 1960599040 19.311 100 54 108 2 1989270304 13169424 15501840
20:33:07 10716 8192000000 10905991616 11330146304 1967390832 19.365 100 48 96 3 1993961408 12404544 14166032
20:33:26 27128 8192000000 10911323344 11345674240 1975998960 19.433 100 40 80 1 2002733824 14776256 11958608
20:34:00 2561 8192000000 10919265552 11348271104 1982567520 19.485 100 54 108 1 2013905312 14782208 16555584
20:34:10 4630 8192000000 10919289808 11336269824 1969193616 19.379 100 72 141 0 2006031792 16317552 20520624
20:34:22 4703 8192000000 10917294336 11341651968 1975674624 19.430 100 72 142 3 2012557408 16455056 20427728
20:34:33 3394 8192000000 10928534112 11349716992 1980401104 19.468 100 65 126 2 2016462688 17216832 18844752
20:34:43 10371 8192000000 10937979696 11356352512 1984907760 19.504 100 73 146 1 2024968976 19549008 20512208
20:35:10 14496 8192000000 10941490320 11363860480 1986685648 19.518 100 76 151 1 2026901552 19073168 21142736
20:35:32 4453 8192000000 10944143712 11365761024 1992537808 19.564 100 70 141 3 2031871328 18201680 21131840
20:35:46 16729 8192000000 10938898736 11369586688 1995747376 19.589 100 53 105 0 2029736768 18152704 15836688
20:36:12 5675 8192000000 10878258832 11297873920 1905290256 18.869 97 52 101 2 1937446384 17281632 14874496
20:36:31 6638 8192000000 10900128416 11313381376 1932297680 19.085 99 59 113 1 1968925520 18806256 17821584
20:36:44 11038 8192000000 10906934400 11328540672 1956004304 19.274 100 63 126 1 1996496384 21561568 18930512
20:37:13 6100 8192000000 10917712352 11344121856 1967601280 19.366 100 64 129 2 2009328080 22764176 18962624
20:37:28 7245 8192000000 10920097200 11344515072 1967120304 19.363 100 55 107 1 2005973968 21989344 16864320
20:37:44 7193 8192000000 10923772640 11348480000 1960180400 19.307 99 53 106 2 1999611936 23419776 16011760
20:37:58 10243 8192000000 10931673296 11363225600 1984324272 19.499 100 58 116 1 2026642592 24474240 17844080
20:38:16 7790 8192000000 10953152256 11376824320 1991372896 19.555 100 59 117 2 2034596240 24941040 18282304
20:38:35 3214 8192000000 10954049888 11368882176 1974943232 19.425 99 70 139 0 2023593808 26656112 21994464
20:38:47 6007 8192000000 10956059632 11378892800 1993325616 19.570 100 63 126 1 2041588160 28255808 20006736
20:39:00 6735 8192000000 10956037952 11384270848 1997206944 19.601 100 57 114 1 2043582704 27917872 18457888
20:39:16 4211 8192000000 10962171664 11390259200 2009343808 19.696 100 59 118 0 2054980880 27216384 18420688
20:39:28 7914 8192000000 10955357792 11380674560 1981965952 19.480 99 65 130 1 2030764464 28922576 19875936
20:39:50 6303 8192000000 10945713200 11376148480 1985062112 19.505 100 61 122 1 2035544864 31859680 18623072
20:40:04 5317 8192000000 10920884048 11341746176 1954384848 19.261 99 63 126 1 2004928256 30919728 19623680
20:40:21 8805 8192000000 10939897440 11364675584 1971857616 19.400 100 64 128 1 2024616304 31468240 21290448
20:40:39 2764 8192000000 10932368736 11352862720 1962488560 19.326 100 67 134 1 2016886256 33543984 20853712
20:40:51 5979 8192000000 10946070752 11365670912 1970005200 19.385 100 72 143 3 2024691120 32857264 21828656
20:41:05 5448 8192000000 10953317232 11376435200 1984520880 19.500 100 69 136 2 2041212224 34895296 21796048
20:41:17 4034 8192000000 10936202800 11353518080 1955819920 19.273 99 80 156 0 2015571568 35631408 24120240
20:41:28 5270 8192000000 10941886096 11356205056 1935385648 19.110 98 70 139 1 1995204736 38152160 21666928
20:41:40 8407 8192000000 10941335264 11366281216 1967786336 19.368 100 64 129 2 2028756384 40760544 20209504
20:42:19 3671 8192000000 10970647584 11382169600 1984253872 19.498 100 74 147 2 2044434176 37586128 22594176
20:42:31 6790 8192000000 10935716656 11348099072 1946083952 19.195 98 80 162 1 2010148960 39217728 24847280
20:42:47 4194 8192000000 10948659968 11357814784 1950208752 19.228 99 71 142 0 2010798112 38530800 22058560
20:43:06 3493 8192000000 10940342672 11357650944 1959930560 19.305 100 72 144 0 2023809424 41394384 22484480
20:43:20 1577 8192000000 10945867376 11357405184 1967002992 19.362 100 82 164 1 2026804592 35063200 24738400
20:43:29 1358 8192000000 10959533040 11368353792 1972174864 19.403 100 89 177 2 2035379584 35651008 27553712
20:43:37 7120 8192000000 10926849104 11345817600 1952038480 19.243 99 70 141 0 2011162992 37245792 21878720
20:43:52 2251 8192000000 10918711824 11331743744 1925985312 19.035 99 72 142 0 1985549632 37225728 22338592
20:44:02 3509 8192000000 10947136704 11353600000 1959676624 19.303 100 85 168 0 2020412720 35410352 25325744
20:44:14 3089 8192000000 10940414816 11343339520 1940087504 19.147 99 89 178 2 2005273040 37390112 27795424
20:44:24 8338 8192000000 10931531696 11353985024 1955522000 19.270 100 73 146 0 2017396000 39128688 22745312
20:44:39 5494 8192000000 10946530112 11359985664 1961617360 19.319 100 74 147 1 2021554048 36768160 23168528
20:44:52 1963 8192000000 10946147616 11357634560 1962155520 19.323 100 76 152 0 2023809680 38302608 23351552
20:45:02 5419 8192000000 10933078928 11349434368 1928962336 19.059 98 71 139 0 1989352672 38707840 21682496
20:45:16 3645 8192000000 10930342432 11339812864 1925269824 19.029 98 89 178 1 1994253424 40114336 28869264
20:45:27 8257 8192000000 10918789840 11331280896 1936131824 19.116 99 78 154 2 1997990672 38742688 23116160
20:45:43 4883 8192000000 10931319856 11349200896 1953970576 19.258 100 74 147 0 2015495184 38290608 23234000
20:45:56 3873 8192000000 10933198992 11346563072 1953522096 19.255 100 81 162 0 2015537440 37869696 24145648
20:46:07 1960 8192000000 10925035104 11330359296 1934666672 19.104 99 84 168 0 2004653504 44089344 25897488
20:46:17 1816 8192000000 10935527568 11343749120 1942709424 19.168 100 89 181 0 2016784192 45933472 28141296
20:46:28 5173 8192000000 10905102080 11322859520 1923380144 19.014 99 58 116 0 1986039392 44197680 18461568
20:46:41 4691 8192000000 10902190080 11320152064 1902960448 18.850 98 61 122 2 1963389872 40964432 19464992
20:47:02 17128 8192000000 10857101152 11296092160 1892747264 18.768 99 30 60 0 1935730592 33084640 9898688
20:47:26 11420 8192000000 10864230352 11302068224 1892794832 18.768 99 23 46 1 1934766816 34324752 7647232
20:47:44 11355 8192000000 10841894048 11282497536 1866859856 18.559 98 31 60 2 1913814912 36782272 10172784
20:48:02 15044 8192000000 10867995504 11302084608 1899269184 18.820 100 28 56 0 1947598080 38598176 9730720
20:48:26 6294 8192000000 10898616000 11318960128 1914063456 18.939 100 45 89 1 1969383632 40940480 14379696
20:48:40 5305 8192000000 10909044208 11326853120 1931084832 19.076 100 72 143 0 1997251840 42438992 23728016
20:48:52 1788 8192000000 10935574784 11347337216 1940036736 19.147 100 86 174 0 2009716352 42781280 26898336
20:49:00 13950 8192000000 10897366912 11341443072 1935337120 19.110 100 44 87 2 1992669968 43242464 14090384
20:49:25 13166 8192000000 10907422272 11353833472 1940992016 19.155 100 40 80 3 1999068080 44638832 13437232
20:49:50 9134 8192000000 10888225472 11327877120 1911394480 18.918 99 32 60 2 1956753648 35575200 9783968
20:50:08 4566 8192000000 10883680192 11325243392 1924198208 19.020 100 25 49 2 1967500432 35025296 8276928
20:50:20 9098 8192000000 10890347328 11336224768 1914818832 18.945 99 31 62 1 1963183936 37421376 10943728
20:50:35 12884 8192000000 10897244528 11338387456 1933084176 19.092 100 28 54 1 1976645168 34787104 8773888
20:50:55 34208 8192000000 10874149840 11329695744 1918377056 18.974 99 18 36 1 1955002576 30540512 6085008
20:51:50 45031 8192000000 10898878688 11344203776 1924311040 19.021 99 26 52 4 1961822576 29264080 8247456
20:52:54 23620 8192000000 10864328896 11324047360 1887494512 18.726 97 27 54 1 1923818560 27423504 8900544
20:53:31 17168 8192000000 10864978800 11314200576 1930648080 19.072 100 24 48 3 1953743456 15971312 7124064
20:54:03 17150 8192000000 10896613104 11340001280 1953942928 19.258 100 43 84 1 1980888512 14673248 12272336
20:54:35 42953 8192000000 10879449296 11341602816 1930385056 19.070 99 21 42 2 1961354848 24523424 6446368
20:55:50 16599 8192000000 10881877232 11344535552 1942684240 19.168 100 13 26 0 1970236064 23029632 4522192
20:56:15 9356 8192000000 10877183312 11347275776 1942944656 19.170 100 12 24 0 1968919264 22458720 3515888
20:56:52 34828 8192000000 10877240672 11333722112 1940210896 19.148 100 10 20 3 1963141088 19934976 2995216
20:57:44 51790 8192000000 10875171456 11312951296 1911355504 18.918 98 25 50 3 1941948464 23229600 7363360
20:58:50 110941 8192000000 10910281440 11367018496 1960538464 19.310 100 39 79 0 1991389664 20396624 10454576
21:00:48 57921 8192000000 10899319824 11367362560 1960272368 19.308 100 8 16 0 1981417296 19077264 2067664
21:01:52 88122 8192000000 10888016016 11350609920 1950369008 19.229 99 19 38 0 1968911408 12751632 5790768
21:03:33 115885 8192000000 10890379968 11357757440 1919845616 18.986 97 15 30 1 1940173376 16129264 4198496
21:05:36 47328 8192000000 10896853808 11362562048 1961405024 19.317 100 11 22 0 1982567120 17590784 3571312
21:06:48 43855 8192000000 10894618896 11348037632 1935426320 19.110 98 20 40 0 1948599584 7640960 5532304
21:07:38 72368 8192000000 10882598896 11347726336 1951164048 19.236 99 23 47 1 1968754080 10571760 7018272
21:08:58 67363 8192000000 10884837328 11350446080 1938672560 19.136 99 9 18 0 1954613440 12992448 2948432
21:10:19 46470 8192000000 10883464272 11339173888 1943333184 19.173 99 27 53 3 1960847680 9406576 8107920
21:11:12 10656 8192000000 10875048784 11342880768 1957171184 19.284 100 14 28 1 1972222096 11051216 3999696
21:11:30 63625 8192000000 10899287696 11357450240 1944890944 19.186 99 20 40 0 1963153344 12679904 5582496
21:12:59 73814 8192000000 10886064960 11360083968 1950500240 19.230 99 11 22 0 1969689296 16009360 3179696
21:14:19 56678 8192000000 10888420176 11356028928 1953450576 19.254 99 19 38 0 1967607344 9131408 5025360
21:16:02 76904 8192000000 10897566688 11366719488 1975571552 19.430 100 14 28 1 1990662560 10738992 4352016
21:17:31 85227 8192000000 10899287392 11368124416 1980176880 19.466 100 22 44 2 1996749088 9266912 7305296
21:19:11 42674 8192000000 10894399840 11360923648 1960579648 19.311 99 14 28 0 1974188464 9692016 3916800
21:20:00 87499 8192000000 10892895968 11380264960 1977625344 19.446 100 16 32 0 1992669456 10427792 4616320
21:22:16 53916 8192000000 10892968048 11360550912 1926111744 19.036 97 13 26 0 1940458784 10621664 3725376
21:23:18 35199 8192000000 10889105072 11353186304 1935978144 19.115 98 23 46 0 1953231296 10428032 6825120
21:23:59 76129 8192000000 10888127296 11364249600 1947158176 19.204 99 13 26 1 1962903264 11931200 3813888
21:25:22 54387 8192000000 10925136304 11381415936 1968001664 19.370 99 27 53 1 1987061824 11922336 7137824
21:26:32 72682 8192000000 10920950944 11395354624 1989247424 19.538 100 31 63 3 2014535120 16566848 8720848
21:27:51 67523 8192000000 10911268080 11392114688 1962711904 19.328 98 15 30 0 1978546752 12240512 3594336
21:29:05 84971 8192000000 10881539376 11353616384 1849977440 18.422 93 9 18 1 1863638656 11484576 2176640
21:30:43 29932 8192000000 10898520304 11357687808 1965517984 19.350 100 26 52 2 1982029424 9567296 6944144
21:31:24 96089 8192000000 10896348304 11361132544 1864810656 18.542 94 28 56 1 1887145424 14317504 8017264
21:33:06 65396 8192000000 10890985424 11348148224 1880038896 18.665 96 22 44 1 1896075712 10054528 5982288
21:34:22 53356 8192000000 10871546864 11323375616 1824492000 18.214 94 17 34 0 1844615424 16176112 3947312
21:35:22 65133 8192000000 10871949216 11350544384 1881667504 18.679 97 14 28 1 1908304848 22593904 4043440
21:36:36 128247 8192000000 10827095168 11261210624 1795632848 17.978 93 20 39 0 1815618144 13568064 6417232
21:38:53 57990 8192000000 10842484592 11288932352 1859792688 18.502 97 35 69 1 1886744544 17717184 9234672
21:39:57 47709 8192000000 10829981808 11292598272 1880080512 18.666 98 22 44 0 1898577520 11942592 6554416
21:40:53 84614 8192000000 10820422848 11302133760 1838384816 18.328 96 10 20 0 1851801520 10625968 2790736
21:43:13 47325 8192000000 10827728240 11296251904 1882599072 18.686 98 17 34 2 1895765472 8038848 5127552
21:44:08 51553 8192000000 10831481136 11295625216 1878027616 18.649 98 18 36 1 1890915408 7732480 5155312
21:45:09 66204 8192000000 10818152320 11290615808 1865000928 18.544 97 8 17 0 1879627984 12253408 2373648
21:46:22 34469 8192000000 10831940992 11304091648 1909921040 18.906 100 15 29 0 1931659008 17238464 4499504
21:48:11 42837 8192000000 10858139680 11311652864 1888622336 18.735 97 24 48 0 1902512528 7497056 6393136
21:49:01 41908 8192000000 10855082288 11318243328 1919703968 18.984 99 33 66 0 1938661280 9699968 9257344
21:49:50 19034 8192000000 10871737056 11327799296 1942115008 19.164 100 28 56 2 1958369264 8582592 7671664
21:50:19 32295 8192000000 10870642592 11334131712 1935147232 19.108 99 28 56 0 1952941968 9167440 8627296
21:50:57 74832 8192000000 10882413616 11342618624 1908158368 18.892 98 18 36 0 1921821536 8280784 5382384
21:52:21 69559 8192000000 10901463184 11342262272 1899615392 18.823 97 25 50 0 1916291968 9818288 6858288
21:53:41 14041 8192000000 10898472704 11344465920 1937735952 19.129 99 42 83 0 1960741472 11314928 11690592
21:54:11 20828 8192000000 10863577600 11318587392 1893744432 18.776 97 41 82 2 1918721088 13121280 11855376
21:54:38 117162 8192000000 10870826464 11340546048 1857978048 18.487 96 25 50 3 1882079568 16295712 7805808
21:56:41 56128 8192000000 10869960784 11319119872 1907255584 18.885 98 23 46 0 1922720592 8716880 6748128
21:57:55 81021 8192000000 10874441472 11337256960 1924525504 19.023 98 17 34 0 1938408592 9196016 4687072
21:59:22 43866 8192000000 10879812368 11333525504 1917765952 18.969 98 12 24 1 1929183568 8324016 3093600
22:00:14 65647 8192000000 10884818848 11344601088 1891638768 18.759 96 17 34 0 1903804256 7969920 4195568
22:01:31 52126 8192000000 10888687904 11340865536 1908997184 18.899 97 27 53 0 1923341264 6894288 7449792
22:03:13 84424 8192000000 10892798128 11345715200 1950353152 19.229 99 29 58 1 1966562560 7886864 8322544
22:04:43 68573 8192000000 10899597072 11370663936 1955179248 19.268 99 20 40 1 1975714080 14634032 5900800
22:05:58 88804 8192000000 10891542656 11379949568 1967979552 19.369 100 4 8 1 1985419264 16246624 1193088
22:07:34 27738 8192000000 10885113152 11377364992 1949472816 19.222 99 5 11 0 1966830480 16215696 1141968
22:08:21 49212 8192000000 10909851632 11361247232 1970561472 19.390 100 20 39 1 1986523552 9725536 6236544
22:09:17 100406 8192000000 10903751072 11378176000 1973383648 19.412 100 10 20 0 1986422080 9854752 3183680
22:11:03 27492 8192000000 10910815696 11379601408 1990097008 19.545 100 20 40 0 2005744976 9998144 5649824
22:11:38 97207 8192000000 10923598160 11412336640 1975014912 19.425 99 13 26 0 1998113728 18953184 4145632
22:13:29 57419 8192000000 10930309184 11398504448 1978667568 19.454 99 17 34 2 2000353280 16800880 4884832
22:14:53 55870 8192000000 10928821408 11386707968 1939537408 19.143 97 29 58 1 1969758400 21405536 8815456
22:15:57 60416 8192000000 10907882752 11395440640 1956436112 19.278 99 10 20 0 1983541168 24010512 3094544
22:18:08 99998 8192000000 10877289840 11329290240 1877878048 18.648 96 10 20 2 1895509536 14731904 2899584
22:20:07 46625 8192000000 10887027824 11336384512 1898408352 18.813 97 33 66 1 1916859392 9361808 9089232
22:21:03 18268 8192000000 10905666976 11344625664 1943176688 19.172 99 56 112 1 1974390096 15540960 15672448
22:21:29 20578 8192000000 10912244800 11356233728 1953600208 19.255 100 38 76 0 1980070160 16056512 10413440
22:21:58 39431 8192000000 10871721136 11348803584 1908960448 18.898 98 37 74 0 1938836960 19926624 9949888
22:22:48 118346 8192000000 10870872480 11328851968 1898990704 18.818 98 18 36 1 1922318832 17705536 5622592
22:24:57 80705 8192000000 10852007184 11319537664 1888631840 18.735 97 16 32 2 1903352256 10404640 4315776
22:26:38 50916 8192000000 9389500176 9683210240 542469296 6.210 29 5 9 0 554490032 10586288 1434448

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 16-11-2020 22:30:02 to 16-11-2020 22:30:34.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 93 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 16-11-2020 22:30:35 to 16-11-2020 22:30:37.

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          238118
MON$OLDEST_ACTIVE               238461
MON$OLDEST_SNAPSHOT             238461
MON$NEXT_TRANSACTION            238461
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                       2019776
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.33390 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33390 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33390 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33390 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 ---
:180: 
:181: mscs-test-161.budzdorov.ru    Mon Nov 16 22:27:50 2020
:182:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:183: 
:184: 
:185: mscs-test-161.budzdorov.ru    Mon Nov 16 22:27:52 2020
:186:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:187: 
:188: 
:189: mscs-test-161.budzdorov.ru    Mon Nov 16 22:27:52 2020
:190:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:191: 
:192: 
:193: mscs-test-161.budzdorov.ru    Mon Nov 16 22:27:57 2020
:194:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:195: 
:196: 
:197: mscs-test-161.budzdorov.ru    Mon Nov 16 22:27:58 2020
:198:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:199: 
:200: 
:201: mscs-test-161.budzdorov.ru    Mon Nov 16 22:27:58 2020
:202:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:203: 
:204: 
:205: mscs-test-161.budzdorov.ru    Mon Nov 16 22:27:59 2020
:206:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:207: 
:208: 
:209: mscs-test-161.budzdorov.ru    Mon Nov 16 22:27:59 2020
:210:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:211: 
--- end of diff output ---

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

16.11.20 22:30:37. 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
2020-11-16 22:30:40 No severe PSQL-related problems occured
16.11.20 22:30:41. End of report.