Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 26.02.2021 19: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 16867600 kB
MemAvailable 31128752 kB
Buffers 0 kB
Cached 14851492 kB
SwapCached 3276 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-02-26 19:27:23
DTS_END                         2021-02-26 19:27:23.6910
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/38446
TRN_ID                          245414
ATT_ID                          710
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: 9559.19 20309 1147103
customer order: creation 177.67 356 21320
customer order: refuse 14.85 353 1782
order to supplier: creation 48.40 1257 5808
order to supplier: removal 3.49 98645 419
invoice (draft): creation 47.35 3164 5682
invoice (draft): removal 53.68 826 6441
invoice accept: apply 43.17 18626 5180
invoice accept: cancel 48.41 717 5809
customer reserve: creation 4072.05 182 488646
customer reserve: removal 4743.50 56 569220
realization accept: apply 89.44 171 10733
realization accept: cancel 84.27 101 10112
payment from customer: creation 60.95 115 7314
payment from customer: removal 5.74 59 689
payment to supplier: creation 49.99 138 5999
payment to supplier: removal 3.60 147 432
service: total inventory turnovers 5.05 858 606
service: total monetary turnovers 6.70 60 804
service: aggregate perf. data 0.86 24229 103
service: refresh index statistics 0.03 256126 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 26-02-2021 19:29:10 to 26-02-2021 19:29:12.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5587
TEST_TIME 2 5663
TEST_TIME 3 5943
TEST_TIME 4 5724
TEST_TIME 5 5444
TEST_TIME 6 5722
TEST_TIME 7 5454
TEST_TIME 8 5565
TEST_TIME 9 5712
TEST_TIME 10 6330
TEST_TIME 11 6368
TEST_TIME 12 6534
TEST_TIME 13 7450
TEST_TIME 14 7212
TEST_TIME 15 7286
TEST_TIME 16 7610
TEST_TIME 17 7599
TEST_TIME 18 7712
TEST_TIME 19 8022
TEST_TIME 20 7971
TEST_TIME 21 8389
TEST_TIME 22 8855
TEST_TIME 23 9086
TEST_TIME 24 9098
TEST_TIME 25 9451
TEST_TIME 26 11036
TEST_TIME 27 10782
TEST_TIME 28 10579
TEST_TIME 29 11145
TEST_TIME 30 11093
TEST_TIME 31 11149
TEST_TIME 32 10995
TEST_TIME 33 10991
TEST_TIME 34 10893
TEST_TIME 35 10790
TEST_TIME 36 10717
TEST_TIME 37 10711
TEST_TIME 38 10588
TEST_TIME 39 10612
TEST_TIME 40 10523
TEST_TIME 41 10558
TEST_TIME 42 10489
TEST_TIME 43 10319
TEST_TIME 44 10147
TEST_TIME 45 10159
TEST_TIME 46 10173
TEST_TIME 47 10122
TEST_TIME 48 10070
TEST_TIME 49 9998
TEST_TIME 50 10023
TEST_TIME 51 10021
TEST_TIME 52 10051
TEST_TIME 53 10045
TEST_TIME 54 9978
TEST_TIME 55 9991
TEST_TIME 56 9958
TEST_TIME 57 9893
TEST_TIME 58 9832
TEST_TIME 59 9746
TEST_TIME 60 9732
TEST_TIME 61 9637
TEST_TIME 62 9582
TEST_TIME 63 9621
TEST_TIME 64 9575
TEST_TIME 65 9680
TEST_TIME 66 9742
TEST_TIME 67 9745
TEST_TIME 68 9860
TEST_TIME 69 9858
TEST_TIME 70 9799
TEST_TIME 71 9874
TEST_TIME 72 9911
TEST_TIME 73 9928
TEST_TIME 74 9961
TEST_TIME 75 10012
TEST_TIME 76 10026
TEST_TIME 77 9904
TEST_TIME 78 9886
TEST_TIME 79 9902
TEST_TIME 80 9880
TEST_TIME 81 9832
TEST_TIME 82 9779
TEST_TIME 83 9740
TEST_TIME 84 9755
TEST_TIME 85 9703
TEST_TIME 86 9651
TEST_TIME 87 9639
TEST_TIME 88 9708
TEST_TIME 89 9668
TEST_TIME 90 9696
TEST_TIME 91 9755
TEST_TIME 92 9741
TEST_TIME 93 9778
TEST_TIME 94 9792
TEST_TIME 95 9827
TEST_TIME 96 9849
TEST_TIME 97 9914
TEST_TIME 98 9887
TEST_TIME 99 9916
TEST_TIME 100 9886
TEST_TIME 101 9805
TEST_TIME 102 9759
TEST_TIME 103 9760
TEST_TIME 104 9736
TEST_TIME 105 9685
TEST_TIME 106 9663
TEST_TIME 107 9626
TEST_TIME 108 9630
TEST_TIME 109 9643
TEST_TIME 110 9631
TEST_TIME 111 9672
TEST_TIME 112 9666
TEST_TIME 113 9686
TEST_TIME 114 9670
TEST_TIME 115 9680
TEST_TIME 116 9662
TEST_TIME 117 9661
TEST_TIME 118 9691
TEST_TIME 119 9634
TEST_TIME 120 9568

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 26-02-2021 19:29:14 to 26-02-2021 19:29:17.

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 1596991 1596991 0 0.00 0 28398 6 0 0
doc_list_biud 1596991 1596991 0 0.00 0 27698 26 0 0
sp_add_invoice_to_stock 5319 5180 139 2.61 27 229187 18626 0 139
sp_cancel_adding_invoice 5809 5809 0 0.00 3 43707 718 0 0
sp_cancel_client_order 1782 1782 0 0.00 3 19820 354 0 0
sp_cancel_customer_reserve 569220 569220 0 0.00 1 27700 57 0 0
sp_cancel_pay_from_customer 689 689 0 0.00 3 7514 60 0 0
sp_cancel_pay_to_supplier 432 432 0 0.00 2 9968 148 0 0
sp_cancel_supplier_invoice 6446 6441 5 0.07 2 11870 827 0 5
sp_cancel_supplier_order 419 419 0 0.00 6 1196944 98646 0 0
sp_cancel_write_off 10112 10112 0 0.00 1 14678 102 0 0
sp_client_order 21320 21320 0 0.00 4 28592 357 0 0
sp_customer_reserve 488646 488646 0 0.00 0 110630 182 0 0
sp_fill_shopping_cart 32808 32808 0 0.00 1 15872 36 0 0
sp_fill_shopping_cart_clo_res 488629 488629 0 0.00 0 22091 14 0 0
sp_get_clo_for_invoice 5163 5163 0 0.00 0 29847 286 0 0
sp_kill_cost_storno 17042 17042 0 0.00 0 20657 50 0 0
sp_kill_qstorno_ret_qs2qd 1155412 1155412 0 0.00 0 27695 31 0 0
sp_kill_qty_storno 609679 609679 0 0.00 0 27698 67 0 0
sp_lock_selected_doc 21781 21781 0 0.00 0 11258 7 0 0
sp_make_cost_storno 29209 29209 0 0.00 0 28382 48 0 0
sp_multiply_rows_for_pdistr 29209 29209 0 0.00 0 18544 30 0 0
sp_multiply_rows_for_qdistr 21320 21320 0 0.00 0 15745 169 0 0
sp_pay_from_customer 7314 7314 0 0.00 5 21059 115 0 0
sp_pay_to_supplier 5999 5999 0 0.00 5 28861 139 0 0
sp_payment_common 13313 13313 0 0.00 1 28794 33 0 0
sp_qd_handle_on_cancel_clo 1782 1782 0 0.00 0 19811 322 0 0
sp_qd_handle_on_invoice_upd_sts 10972 10972 0 0.00 0 20969 301 0 0
sp_qd_handle_on_reserve_upd_sts 10733 10733 0 0.00 0 18608 55 0 0
sp_reserve_write_off 10733 10733 0 0.00 6 23568 171 0 0
sp_supplier_invoice 5682 5682 0 0.00 7 108679 3164 0 0
sp_supplier_order 5808 5808 0 0.00 4 27373 1258 0 0
srv_aggregate_perf_data 103 103 0 0.00 3015 508693 24229 0 0
srv_fill_mon_cache_memory 165 165 0 0.00 1523 162667 32301 0 0
srv_find_qd_qs_mism 1096121 1096121 0 0.00 0 26792 6 0 0
srv_make_invnt_saldo 606 606 0 0.00 39 19210 859 0 0
srv_make_money_saldo 804 804 0 0.00 0 33763 61 0 0
srv_recalc_idx_stat 4 4 0 0.00 124185 349962 256126 0 0
t$perf-abend:sp_add_invoice_to_stock 139 139 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5180 5180 0 0.00 0 11169 162 0 0
t$perf-norm:sp_cancel_adding_invoice 400 400 0 0.00 1 5755 82 0 0
t$perf-norm:sp_cancel_client_order 1782 1782 0 0.00 0 1316 9 0 0
t$perf-norm:sp_cancel_customer_reserve 702 702 0 0.00 0 2442 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 689 689 0 0.00 0 1795 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 432 432 0 0.00 0 2054 10 0 0
t$perf-norm:sp_cancel_supplier_invoice 406 406 0 0.00 0 1545 16 0 0
t$perf-norm:sp_cancel_supplier_order 419 419 0 0.00 0 24226 1561 0 0
t$perf-norm:sp_cancel_write_off 1056 1056 0 0.00 0 10955 17 0 0
t$perf-norm:sp_client_order 21320 21320 0 0.00 0 6272 15 0 0
t$perf-norm:sp_customer_reserve 1070 1070 0 0.00 0 5915 9 0 0
t$perf-norm:sp_pay_from_customer 7314 7314 0 0.00 0 9696 9 0 0
t$perf-norm:sp_pay_to_supplier 5999 5999 0 0.00 0 4105 9 0 0
t$perf-norm:sp_reserve_write_off 10733 10733 0 0.00 0 13342 10 0 0
t$perf-norm:sp_supplier_invoice 5682 5682 0 0.00 0 5802 14 0 0
t$perf-norm:sp_supplier_order 5808 5808 0 0.00 0 20991 18 0 0
t$perf-norm:srv_aggregate_perf_data 103 103 0 0.00 0 127 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 165 165 0 0.00 0 337 5 0 0
t$perf-norm:srv_make_invnt_saldo 606 606 0 0.00 0 2398 23 0 0
t$perf-norm:srv_make_money_saldo 804 804 0 0.00 0 3153 18 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 10602 10324 278 2.62 0 4031 17 0 278
v_all_customers 38240 38240 0 0.00 0 18 1 0 0
v_all_suppliers 31562 31562 0 0.00 0 89 1 0 0
v_all_wares 42640 42640 0 0.00 0 36 1 0 0
v_cancel_adding_invoice 800 800 0 0.00 0 1741 11 0 0
v_cancel_client_order 3564 3564 0 0.00 0 5561 6 0 0
v_cancel_customer_prepayment 1378 1378 0 0.00 0 706 3 0 0
v_cancel_customer_reserve 1404 1404 0 0.00 0 2174 6 0 0
v_cancel_payment_to_supplier 864 864 0 0.00 0 5881 15 0 0
v_cancel_supplier_invoice 822 812 10 1.21 0 3537 20 0 10
v_cancel_supplier_order 838 838 0 0.00 0 517 4 0 0
v_cancel_write_off 2112 2112 0 0.00 0 8324 18 0 0
v_max_id_clo_ord 5808 5808 0 0.00 0 360 1 0 0
v_max_id_clo_res 1070 1070 0 0.00 0 3190 18 0 0
v_max_id_ord_sup 5680 5680 0 0.00 0 2272 3 0 0
v_max_non_paid_invoice 1706 1706 0 0.00 0 2735 4 0 0
v_max_non_paid_realizn 4164 4164 0 0.00 0 7146 7 0 0
v_min_id_clo_ord 5808 5808 0 0.00 0 2855 5 0 0
v_min_id_clo_res 1070 1070 0 0.00 0 4005 10 0 0
v_min_id_ord_sup 5680 5680 0 0.00 0 9063 10 0 0
v_min_non_paid_invoice 5999 5999 0 0.00 0 18460 20 0 0
v_min_non_paid_realizn 7314 7314 0 0.00 0 7672 15 0 0
v_our_firm 10700 10700 0 0.00 0 65 1 0 0
v_reserve_write_off 21466 21466 0 0.00 0 16371 7 0 0
x_lock_depdocs_on_canc_invoice 11844 11844 0 0.00 0 24150 117 0 0
x_lock_depdocs_on_canc_sup_ord 419 419 0 0.00 0 8209 352 0 0
x_make_qstorno_1000_1200 5808 5808 0 0.00 2 27363 1186 0 0
x_make_qstorno_1200_2000 5681 5681 0 0.00 3 108571 3031 0 0
x_make_qstorno_2100_3300 488646 488646 0 0.00 0 110626 166 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 26-02-2021 19:29:18 to 26-02-2021 19:29:22.

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
16:57:27 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:33 28805 8192000000 10275717840 10583322624 913476064 10.032 71 55 110 0 934821440 2613632 18731744
16:58:14 25703 8192000000 10341363072 10656854016 1391384720 14.518 100 90 180 0 1426168336 5146240 29637376
16:58:49 17865 8192000000 10368240784 10687750144 1429467648 14.857 100 92 184 0 1465847408 6260480 30119280
16:59:19 29481 8192000000 10397718704 10719096832 1445271712 14.996 100 87 173 0 1480303728 7075680 27956336
16:59:56 28891 8192000000 10421360368 10746490880 1468017920 15.196 100 92 184 0 1505832496 7945648 29868928
17:00:33 25163 8192000000 10440377872 10767441920 1489015312 15.380 100 93 186 2 1527789584 8931952 29842320
17:01:05 23064 8192000000 10448913248 10780045312 1502656128 15.499 100 88 176 0 1540039648 9329536 28053984
17:01:35 17676 8192000000 10452939120 10797551616 1520599136 15.655 100 81 162 2 1555192080 9299216 25293728
17:02:02 12498 8192000000 10487944528 10830675968 1543337920 15.852 100 82 163 0 1577560608 9109584 25113104
17:02:23 12078 8192000000 10511667408 10864246784 1573578448 16.113 100 74 148 0 1605528464 9538720 22411296
17:02:44 15944 8192000000 10545844752 10899787776 1596284496 16.308 100 76 151 2 1629039744 9965936 22789312
17:03:12 11805 8192000000 10576003888 10933133312 1633773312 16.627 100 79 157 1 1667976544 11143424 23059808
17:03:34 14621 8192000000 10595347040 10958962688 1648550368 16.752 100 74 149 1 1681789408 11596000 21643040
17:03:56 13617 8192000000 10609698960 10982203392 1677314848 16.995 100 75 150 0 1711093168 11681376 22096944
17:04:20 8087 8192000000 10630636208 11008086016 1695973120 17.151 100 67 133 3 1726391152 11469104 18948928
17:04:35 7082 8192000000 10647470560 11021443072 1714282896 17.305 100 69 136 2 1745498080 11353744 19861440
17:04:50 11681 8192000000 10668300160 11045064704 1731438144 17.447 100 74 148 1 1764268976 12340976 20489856
17:05:09 6275 8192000000 10696148768 11065405440 1747797104 17.583 100 84 169 1 1785829648 14169184 23863360
17:05:22 7185 8192000000 10693730160 11068403712 1758660416 17.673 100 83 166 2 1795250464 13564944 23025104
17:05:36 5507 8192000000 10705520112 11085352960 1771010576 17.775 100 91 182 2 1809900496 12720800 26169120
17:05:47 3731 8192000000 10712671632 11095621632 1779137824 17.842 100 74 148 3 1812574240 12633056 20803360
17:05:58 3911 8192000000 10732774016 11112665088 1788935744 17.923 100 82 163 1 1824853760 13020384 22897632
17:06:10 2431 8192000000 10734680048 11116740608 1799082544 18.006 100 81 160 0 1834027344 12480400 22464400
17:06:19 11496 8192000000 10734056928 11127119872 1807071472 18.072 100 79 158 1 1843260528 13769280 22419776
17:06:37 3327 8192000000 10756021344 11142701056 1814092048 18.129 100 70 140 1 1847266400 13835376 19338976
17:06:48 2733 8192000000 10765636544 11151966208 1824556688 18.215 100 74 145 2 1857572400 12607184 20408528
17:06:57 2423 8192000000 10763155920 11147558912 1827861120 18.242 100 73 146 1 1861574848 12416784 21296944
17:07:06 3116 8192000000 10782301472 11167899648 1840247968 18.343 100 88 176 0 1877841184 13037088 24556128
17:07:15 2210 8192000000 10784930240 11171393536 1844635184 18.379 100 92 184 1 1885414208 13746128 27032896
17:07:24 1836 8192000000 10788946448 11175194624 1844710368 18.379 100 87 173 1 1882936640 13789968 24436304
17:07:32 2542 8192000000 10787834336 11178295296 1849371232 18.417 100 88 176 0 1886761808 13288160 24102416
17:07:41 2350 8192000000 10796174960 11185303552 1855361040 18.466 100 88 178 1 1894794688 14033280 25400368
17:07:50 1345 8192000000 10805598672 11191939072 1861389824 18.515 100 93 186 1 1901779840 14302192 26087824
17:07:58 1856 8192000000 10805139280 11191799808 1863015136 18.528 100 86 170 0 1901895712 14118624 24761952
17:08:06 1741 8192000000 10815205904 11201630208 1870025296 18.584 100 96 192 1 1910155344 13279040 26851008
17:08:14 12393 8192000000 10801358128 11197444096 1863714096 18.533 100 70 134 2 1894111744 11071312 19326336
17:08:36 929 8192000000 10817145008 11203350528 1869431520 18.580 100 90 183 1 1906951440 11251184 26268736
17:08:43 8009 8192000000 10793212048 11194486784 1863882128 18.535 100 58 115 4 1891183456 10695344 16605984
17:09:00 3515 8192000000 10789336336 11196481536 1864060064 18.536 100 48 96 0 1887380592 9633216 13687312
17:09:11 6339 8192000000 10781815328 11193786368 1864581344 18.540 100 37 74 0 1883105792 8552624 9971824
17:09:27 6870 8192000000 10786962576 11193552896 1862551904 18.524 100 32 64 1 1879141392 7100304 9489184
17:09:40 9152 8192000000 10758233248 11191652352 1860562496 18.508 100 13 26 2 1870661472 6611216 3487760
17:09:56 5922 8192000000 10776188944 11198451712 1866514000 18.556 100 28 56 0 1882010032 7627696 7868336
17:10:10 7425 8192000000 10788211472 11202170880 1869540688 18.581 100 27 54 1 1883861984 6119872 8201424
17:10:24 4402 8192000000 10787829072 11210162176 1873244032 18.611 100 29 58 3 1888777376 7459600 8073744
17:10:37 6088 8192000000 10780570240 11208499200 1875280048 18.627 100 32 64 2 1891576176 7379552 8916576
17:10:55 14176 8192000000 10784693040 11214057472 1879024032 18.657 100 18 36 1 1889807008 5642464 5140512
17:11:18 6993 8192000000 10802103792 11223007232 1883364224 18.692 100 19 38 1 1895135152 5486208 6284720
17:11:34 76369 8192000000 10814320560 11230117888 1891642048 18.759 100 30 54 1 1905203552 5227648 8333856
17:13:01 5248 8192000000 10806423792 11236343808 1888513936 18.734 100 23 46 1 1901415648 6821632 6080080
17:13:13 6167 8192000000 10821889664 11242889216 1894173776 18.779 100 35 70 1 1912296656 8362240 9760640
17:13:26 4957 8192000000 10831682864 11250454528 1899586752 18.823 100 37 74 2 1918220208 8526608 10106848
17:13:37 6200 8192000000 10818703632 11248734208 1900449760 18.830 100 34 66 1 1916847760 7099984 9298016
17:13:50 6046 8192000000 10827294304 11252125696 1900956672 18.834 100 36 73 1 1918831264 6950080 10924512
17:14:04 6213 8192000000 10833056320 11253682176 1906526256 18.879 100 32 65 0 1922359168 5671280 10161632
17:14:18 6008 8192000000 10819589008 11251433472 1904419616 18.862 100 33 68 1 1920431648 6691056 9320976
17:14:32 14027 8192000000 10841529728 11263336448 1904448064 18.862 100 19 38 0 1919771712 10001216 5322432
17:14:55 7505 8192000000 10813811696 11249614848 1889967584 18.746 99 22 44 3 1909815152 14416752 5430816
17:15:13 6981 8192000000 10826392464 11259486208 1906047344 18.875 100 18 36 0 1917241392 6379968 4814080
17:15:27 6371 8192000000 10832199872 11261607936 1909376704 18.902 100 30 60 2 1924821968 6851248 8594016
17:15:41 9253 8192000000 10832185904 11266711552 1911376224 18.918 100 25 50 1 1928687664 10263648 7047792
17:15:56 9460 8192000000 10815596544 11253645312 1893563552 18.774 99 25 50 2 1906178896 5637040 6978304
17:16:12 60295 8192000000 10823773952 11249856512 1869575744 18.581 98 24 49 3 1881235680 5050928 6609008
17:17:22 8713 8192000000 10801022496 11234217984 1877958528 18.649 99 26 52 1 1891813104 6479728 7374848
17:17:38 5314 8192000000 10817049776 11241099264 1887926640 18.729 100 39 78 2 1910794160 11335072 11532448
17:17:50 7250 8192000000 10817448752 11248979968 1899528624 18.823 100 24 48 1 1912047232 6063344 6455264
17:18:05 5214 8192000000 10829595664 11255861248 1906033488 18.875 100 34 68 4 1922829248 7284144 9511616
17:18:19 7852 8192000000 10754352176 11180290048 1798145776 17.999 95 27 54 3 1812380944 6543632 7691536
17:18:34 2698 8192000000 10790394704 11214696448 1869822464 18.583 100 31 62 1 1885873792 6369264 9682064
17:18:45 8077 8192000000 10741746832 11159552000 1729166816 17.429 93 29 57 3 1747569984 10406144 7997024
17:19:00 7077 8192000000 10691127056 11096166400 1718185472 17.337 95 29 58 1 1731435776 5351776 7898528
17:19:14 8329 8192000000 10732146224 11147694080 1796633568 17.986 99 24 48 1 1808406000 5872752 5899680
17:19:29 3909 8192000000 10723928896 11138633728 1795394880 17.976 99 35 70 1 1812172816 6701984 10075952
17:19:40 8040 8192000000 10680129184 11082227712 1620846320 16.517 91 20 40 2 1631679024 4431600 6401104
17:19:56 6426 8192000000 10689222784 11093839872 1734845680 17.476 98 30 60 0 1749235936 5181712 9208544
17:20:11 13413 8192000000 10702822896 11110481920 1753160256 17.628 98 35 70 2 1769763456 5678768 10924432
17:20:32 11158 8192000000 10708885152 11124891648 1756935168 17.659 98 18 36 0 1767730992 5703776 5092048
17:20:51 6820 8192000000 10702591232 11119898624 1763317120 17.712 98 28 56 0 1777797712 6522336 7958256
17:21:06 71140 8192000000 10699399232 11115651072 1697953504 17.168 94 26 52 0 1710393648 4894720 7545424
17:22:25 14005 8192000000 10716272704 11130241024 1725046624 17.394 96 19 38 1 1735703680 5624624 5032432
17:22:48 7372 8192000000 10738209024 11152424960 1794776608 17.971 99 38 74 1 1811739008 7104512 9857888
17:23:02 2420 8192000000 10756409040 11159822336 1824320160 18.213 100 52 104 6 1846847168 7786480 14740528
17:23:12 7256 8192000000 10732870400 11156520960 1818562624 18.166 100 20 40 0 1830669648 5797504 6309520
17:23:25 8363 8192000000 10750661088 11169177600 1831824112 18.274 100 21 40 0 1843676432 6079040 5773280
17:23:40 6969 8192000000 10759232320 11181789184 1839530768 18.337 100 25 49 2 1852161856 5538496 7092592
17:23:54 6692 8192000000 10779727728 11191230464 1845141760 18.383 100 39 78 1 1863157328 6161488 11854080
17:24:09 7287 8192000000 10764198144 11188109312 1829434224 18.255 99 28 57 1 1843755536 6036224 8285088
17:24:28 6594 8192000000 10766650752 11190517760 1853815216 18.453 100 35 70 1 1870239456 5776064 10648176
17:24:45 9707 8192000000 10769750400 11195416576 1850795136 18.429 100 18 36 1 1861523632 5452000 5276496
17:25:02 12068 8192000000 10776763488 11202072576 1859559712 18.500 100 21 42 1 1871398512 5600688 6238112
17:25:21 8754 8192000000 10776753680 11208511488 1864849648 18.543 100 21 43 0 1876345280 5320368 6175264
17:25:41 16699 8192000000 10789340848 11217301504 1866185056 18.553 100 26 52 1 1883711472 10216896 7309520
17:26:07 60185 8192000000 10800948816 11223334912 1876362080 18.636 100 36 73 2 1892319696 5670944 10286672
17:27:14 4772 8192000000 10818551984 11242934272 1892829216 18.769 100 31 62 2 1907591088 6672096 8089776
17:27:29 17508 8192000000 10837099520 11255128064 1903411824 18.854 100 50 98 1 1924386432 7410800 13563808
17:27:58 36277 8192000000 10843868960 11264765952 1913946688 18.938 100 53 104 2 1938501856 8983808 15571360
17:28:42 5624 8192000000 10849843568 11270668288 1921925024 19.002 100 56 112 0 1946730176 9166592 15638560
17:28:58 15196 8192000000 10856436960 11281616896 1924293120 19.021 100 56 112 2 1949420672 9229216 15898336
17:29:27 4685 8192000000 10873375360 11293532160 1935674768 19.112 100 59 117 1 1962013424 9239312 17099344
17:29:41 17268 8192000000 10879811888 11299504128 1939701248 19.144 100 59 118 2 1968317520 10985856 17630416
17:30:07 13854 8192000000 10872812000 11298095104 1941665168 19.160 100 49 98 2 1966353680 11147856 13540656
17:30:30 20346 8192000000 10868857888 11303419904 1947032080 19.203 100 47 92 1 1969651232 9357968 13261184
17:31:01 39464 8192000000 10879019568 11319660544 1955094208 19.267 100 35 68 3 1975404752 10015760 10294784
17:31:58 18608 8192000000 10899165600 11331334144 1964696912 19.343 100 38 75 1 1985669376 10360464 10612000
17:32:28 15773 8192000000 10914168048 11343593472 1974383792 19.420 100 54 108 0 2004631168 14671840 15575536
17:32:55 28110 8192000000 10902453312 11345285120 1975304096 19.428 100 41 82 0 2002733056 15428960 12000000
17:33:30 23930 8192000000 10898925696 11350073344 1975601312 19.430 100 28 54 2 1996776992 13038384 8137296
17:34:07 16685 8192000000 10918913056 11358257152 1983392224 19.492 100 37 74 1 2010035008 15859952 10782832
17:34:44 5954 8192000000 10938524640 11371962368 1995839504 19.590 100 48 95 1 2027953840 17722256 14392080
17:34:58 5464 8192000000 10950828896 11379712000 2004015040 19.654 100 63 124 1 2042002736 18755168 19232528
17:35:11 3396 8192000000 10949257856 11379724288 2006060992 19.671 100 61 122 0 2044024544 20052496 17911056
17:35:21 5140 8192000000 10960213296 11386834944 2010661664 19.707 100 69 138 1 2051432976 20293104 20478208
17:35:34 10351 8192000000 10959036480 11388940288 2010341536 19.704 100 66 132 0 2052485872 21656432 20487904
17:35:59 6544 8192000000 10948169456 11377246208 1990470480 19.548 99 60 120 4 2031115632 22033440 18611712
17:36:16 13800 8192000000 10956085616 11382333440 2002660096 19.644 100 59 118 1 2042399600 22014416 17725088
17:36:40 5681 8192000000 10969987728 11391426560 1993213440 19.569 99 71 142 1 2038609424 24252224 21143760
17:36:53 3809 8192000000 10988023360 11399962624 2016800800 19.755 100 79 156 1 2066584400 26281408 23502192
17:37:03 1581 8192000000 10979669584 11395784704 2001343840 19.633 99 88 174 0 2052211568 24735376 26132352
17:37:12 10331 8192000000 10963452640 11386658816 1992063776 19.560 99 75 150 1 2036465776 22339488 22062512
17:37:33 9125 8192000000 10958107088 11384582144 2000790192 19.629 100 65 127 3 2044516816 25164752 18561872
17:37:50 7563 8192000000 10962658096 11394805760 2007285664 19.680 100 58 115 1 2050852976 26801136 16766176
17:38:06 9916 8192000000 10971646384 11403116544 2013825392 19.732 100 59 114 0 2059103808 28112384 17166032
17:38:23 5545 8192000000 10958532160 11379306496 1991592800 19.556 99 65 131 2 2040794688 29602256 19599632
17:38:38 4159 8192000000 10981691488 11404636160 2012900368 19.724 100 71 142 2 2066792960 31692848 22199744
17:38:49 3597 8192000000 10997984448 11415392256 2017928976 19.764 100 82 164 0 2077103440 33873536 25300928
17:39:01 2199 8192000000 10987169952 11406811136 2012148144 19.718 100 82 162 1 2070539776 33897680 24493952
17:39:11 2338 8192000000 10989962944 11407888384 1999410384 19.618 99 87 174 0 2062021776 36475696 26135696
17:39:20 6956 8192000000 10984948736 11414044672 2011543312 19.714 100 71 142 1 2069786016 36654672 21588032
17:39:44 4454 8192000000 10980953216 11412963328 2011010560 19.709 100 67 134 0 2071839536 39866528 20962448
17:39:57 10321 8192000000 10989559808 11411247104 2010861936 19.708 100 72 143 0 2070355872 37297440 22196496
17:40:22 3022 8192000000 10987364944 11414528000 2010186848 19.703 100 70 137 2 2070083776 38521360 21375568
17:40:32 4426 8192000000 10950355376 11375513600 1967289104 19.364 98 76 154 2 2023822320 33563424 22969792
17:40:44 4873 8192000000 10953409072 11378659328 1979354480 19.460 99 65 127 0 2033343888 34818640 19170768
17:40:57 2630 8192000000 10961641376 11395670016 1999990656 19.623 100 64 123 1 2053323120 33914464 19418000
17:41:08 7969 8192000000 10960185584 11381510144 1957474320 19.286 98 67 130 3 2010348144 33149392 19724432
17:41:23 3216 8192000000 10963295616 11383095296 1972957920 19.409 99 75 148 3 2033552480 37379632 23214928
17:41:33 2982 8192000000 10957808848 11380899840 1971410208 19.397 99 71 140 0 2031888496 38460640 22017648
17:41:44 1826 8192000000 10957298960 11377504256 1977459056 19.445 100 80 160 2 2042466800 40728576 24279168
17:41:55 16193 8192000000 10959234128 11388932096 1983309088 19.491 100 72 144 1 2048176576 43239328 21628160
17:42:30 2693 8192000000 10950917104 11384360960 1975954288 19.433 100 56 112 0 2036404144 42688496 17761360
17:42:40 4223 8192000000 10934695104 11359158272 1944446512 19.182 98 64 126 0 2007258576 42570032 20242032
17:42:53 8612 8192000000 10943723680 11380043776 1974172192 19.419 100 47 92 1 2032536448 43426720 14937536
17:43:17 4536 8192000000 10942406016 11383480320 1979489552 19.461 100 50 99 0 2034239536 38955040 15794944
17:43:29 5551 8192000000 10941808256 11379437568 1973357840 19.412 100 42 83 0 2024238224 38050128 12830256
17:43:45 6390 8192000000 10959933296 11391451136 1966410080 19.357 99 55 110 1 2021890672 38459104 17021488
17:44:01 3795 8192000000 10962239808 11380314112 1979350176 19.460 100 73 147 3 2041758000 40496032 21911792
17:44:12 4029 8192000000 10961510272 11383140352 1980254256 19.467 100 74 146 2 2042264352 39246640 22763456
17:44:24 1521 8192000000 10938893312 11354411008 1941950416 19.162 98 82 163 1 2005847312 39987712 23909184
17:44:34 2748 8192000000 10963892608 11382542336 1977042592 19.441 100 70 140 0 2041639616 43377440 21219584
17:44:45 3683 8192000000 10968092432 11383885824 1977391264 19.444 100 81 162 2 2048408048 46229168 24787616
17:44:58 4449 8192000000 10966402480 11385769984 1967003152 19.362 99 74 148 1 2036137504 46768048 22366304
17:45:10 2897 8192000000 10975308752 11392774144 1987374320 19.523 100 75 150 1 2059570448 48902400 23293728
17:45:25 2271 8192000000 10974312304 11394007040 1975319792 19.428 99 76 144 1 2045766560 47697728 22749040
17:45:39 8554 8192000000 10954791200 11393511424 1975575056 19.430 100 52 104 0 2041395648 48649264 17171328
17:45:55 10915 8192000000 10960922288 11400601600 1970998944 19.393 99 54 107 1 2040240272 51164016 18077312
17:46:18 11149 8192000000 10948044240 11390636032 1967676528 19.367 99 39 76 0 2032815008 51348608 13789872
17:46:36 4287 8192000000 10967258960 11406585856 1989024864 19.536 100 48 95 1 2051486112 46708368 15752880
17:46:53 6473 8192000000 10951179552 11388985344 1974030480 19.417 100 49 98 0 2038968640 48775504 16162656
17:47:10 14180 8192000000 10957021024 11397943296 1982419424 19.484 100 39 78 0 2045022128 49509536 13093168
17:47:33 12247 8192000000 10971380832 11406422016 1983430192 19.492 100 45 90 2 2049824976 50950880 15443904
17:47:58 8749 8192000000 10953269264 11387154432 1963842064 19.337 99 54 101 4 2036015424 55047040 17126320
17:48:15 12568 8192000000 10967625008 11401641984 1976873488 19.440 100 48 96 2 2051016128 57230848 16911792
17:48:37 11276 8192000000 10971675440 11417284608 1989121680 19.537 100 50 99 0 2065546224 59129472 17295072
17:48:55 17687 8192000000 10964399216 11423178752 1986453344 19.516 100 30 60 1 2051988672 54688416 10846912
17:49:36 18278 8192000000 10957930640 11419189248 1968588144 19.374 99 30 58 1 2037388432 57903152 10897136
17:50:05 16147 8192000000 10959378400 11414200320 1984930112 19.504 100 41 82 1 2050791808 51723712 14137984
17:50:33 13306 8192000000 10919506672 11370061824 1900892144 18.833 97 27 54 2 1962685936 52891104 8902688
17:51:05 23359 8192000000 10890613200 11345367040 1871513472 18.597 97 19 38 0 1936182928 57279488 7389968
17:51:35 27401 8192000000 10892895152 11337437184 1885572288 18.710 99 28 56 1 1956609088 60611968 10424832
17:52:09 20676 8192000000 10895454016 11325935616 1808777152 18.086 95 27 54 0 1887672032 68498176 10396704
17:52:37 24494 8192000000 10916789392 11359031296 1916502336 18.959 100 38 76 1 1996673504 67033728 13137440
17:53:11 12625 8192000000 10932602192 11380842496 1934040672 19.099 100 38 76 1 2011423376 63962896 13419808
17:53:59 55102 8192000000 10889464096 11334877184 1962080544 19.323 100 22 44 2 1985725136 16779696 6864896
17:55:01 25246 8192000000 10889232416 11343003648 1952072336 19.243 100 32 64 2 1976912256 15618320 9221600
17:55:41 30563 8192000000 10879651232 11340042240 1921968096 19.003 99 23 46 3 1958734400 29345360 7420944
17:56:18 11288 8192000000 10868806864 11343933440 1922510960 19.007 100 7 14 0 1949735344 24790000 2434384
17:56:40 15285 8192000000 10855528960 11343114240 1912937376 18.930 100 5 10 0 1938558624 24241168 1380080
17:57:03 35182 8192000000 10870448480 11344896000 1932995520 19.091 100 13 24 2 1952255760 15907104 3353136
17:57:47 76920 8192000000 10873434544 11345301504 1926962992 19.043 99 9 18 0 1942758080 13764160 2030928
17:59:10 77566 8192000000 10865729808 11312431104 1837650496 18.322 94 21 42 0 1852422464 8956288 5815680
18:00:34 61030 8192000000 10875886320 11339030528 1933720368 19.097 100 14 28 2 1952280240 14739184 3820688
18:01:44 111028 8192000000 10879783792 11338645504 1913082160 18.931 98 11 22 1 1927364912 10276496 4006256
18:03:41 147992 8192000000 10904963664 11343192064 1902815840 18.849 97 16 32 1 1918196784 10634480 4746464
18:06:20 27328 8192000000 10895222464 11353554944 1960436272 19.310 100 45 90 2 1986245312 12643648 13165392
18:06:55 122977 8192000000 10885203296 11331731456 1886695600 18.719 96 14 28 0 1901312224 10913040 3703584
18:09:06 132086 8192000000 10898494256 11348594688 1928686064 19.056 98 24 48 1 1949217184 13551824 6979296
18:11:57 30221 8192000000 10899951360 11330121728 1952069840 19.243 99 47 88 1 1969845648 5377168 12398640
18:12:37 62175 8192000000 10895870704 11354980352 1930805440 19.073 98 28 56 1 1950300864 10450048 9045376
18:13:54 51415 8192000000 10910449504 11359027200 1967146944 19.363 100 49 98 0 1992434032 11711536 13575552
18:15:02 121449 8192000000 10923702144 11379806208 1969699232 19.383 99 31 61 0 1987725984 9241920 8784832
18:18:00 56017 8192000000 10919545216 11376640000 1964038064 19.338 99 27 54 0 1981761760 9893824 7829872
18:19:03 50270 8192000000 10918833120 11387699200 1989303872 19.538 100 46 94 1 2013473312 10008064 14161376
18:20:00 40570 8192000000 10909970304 11384897536 1989086704 19.537 100 20 40 1 2003909520 9101392 5721424
18:20:53 29033 8192000000 10926491152 11398397952 1998953152 19.614 100 22 44 0 2013752752 8496064 6303536
18:21:29 58320 8192000000 10911492384 11388121088 1977822128 19.447 99 12 24 0 1989961280 8609312 3529840
18:22:33 24198 8192000000 10886733776 11369607168 1928855312 19.058 97 7 14 1 1938374112 7732032 1786768
18:23:04 13669 8192000000 10896044304 11367514112 1971264752 19.395 100 15 31 0 1983476304 8257952 3953600
18:23:24 162667 8192000000 10877139040 11362422784 1913099312 18.932 97 14 28 0 1925240816 8047392 4094112
18:26:30 23989 8192000000 10902933040 11370627072 1977271584 19.443 100 32 65 2 1993425344 7352512 8801248
18:27:00 29515 8192000000 10880172896 11349610496 1922353696 19.006 97 29 57 1 1937517808 7344672 7819440
18:27:38 28435 8192000000 10887554880 11358347264 1956972640 19.282 99 16 32 1 1967806320 6063936 4769744
18:28:13 47946 8192000000 10877612112 11346419712 1938218656 19.133 98 22 44 0 1956186928 11616192 6352080
18:29:11 78957 8192000000 10883423312 11373510656 1964725424 19.344 100 12 24 0 1976614896 8444672 3444800
18:30:36 74093 8192000000 10864355520 11334131712 1800716928 18.020 91 19 39 2 1816329424 10117280 5495216
18:31:56 53418 8192000000 10885339056 11373060096 1951499296 19.238 100 17 34 1 1976301328 19451392 5350640
18:32:56 41311 8192000000 10886053008 11354206208 1926903376 19.042 98 21 42 2 1948877920 15431616 6542928
18:33:54 30723 8192000000 10890917408 11366600704 1944872688 19.186 99 14 28 2 1969543936 20637824 4033424
18:34:32 45343 8192000000 10917812544 11379556352 1973812512 19.416 100 36 70 3 1999497360 15341792 10343056
18:35:31 40849 8192000000 10900390576 11363389440 1912095456 18.923 97 28 56 1 1935266928 15342128 7829344
18:36:18 34928 8192000000 10874498976 11340615680 1871988608 18.600 95 27 54 1 1892802816 13169600 7644608
18:37:05 82887 8192000000 10868577344 11338190848 1846936464 18.397 95 25 50 1 1869764736 16457552 6370720
18:38:36 76221 8192000000 10887144640 11342966784 1893655872 18.775 97 19 39 2 1906821232 8539920 4625440
18:40:00 25493 8192000000 10900953008 11354099712 1937753728 19.129 99 44 88 1 1963223056 13297904 12171424
18:40:34 82449 8192000000 10869436112 11329462272 1823468960 18.206 94 30 58 1 1852394640 21306432 7619248
18:42:11 50133 8192000000 10866530352 11333959680 1863239472 18.530 96 19 38 1 1880046336 11186240 5620624
18:43:07 60419 8192000000 10832505888 11300978688 1832788576 18.282 95 13 26 1 1847229216 11126432 3314208
18:44:46 101036 8192000000 10845811376 11315712000 1857555216 18.483 97 28 55 0 1876601472 11195120 7851136
18:46:57 24124 8192000000 10851392416 11319181312 1920525936 18.991 100 33 65 0 1941734672 12430240 8778496
18:47:29 39537 8192000000 10838187936 11308707840 1900983248 18.834 99 19 36 1 1914763824 8689168 5091408
18:48:15 46017 8192000000 10832390064 11304247296 1878178560 18.650 98 11 21 1 1888007616 6516064 3312992
18:49:07 49008 8192000000 10837301008 11311869952 1896658672 18.799 99 10 20 0 1908922528 9372656 2891200
18:50:02 46321 8192000000 10847056368 11315945472 1906401264 18.878 99 14 28 1 1920664176 10409152 3853760
18:51:07 60047 8192000000 10848201600 11327045632 1924817968 19.025 100 9 18 0 1938200048 10869040 2513040
18:52:32 49989 8192000000 10857417808 11340464128 1937441616 19.126 100 13 26 1 1950120704 9209680 3469408
18:53:29 42912 8192000000 10868114528 11342970880 1924646544 19.024 99 13 26 0 1940224928 12110976 3467408
18:54:20 54532 8192000000 10844876528 11324731392 1877146432 18.642 97 15 30 2 1894479264 13322608 4010224
18:55:37 35465 8192000000 10859742368 11329470464 1939271104 19.141 100 24 48 2 1953687536 7482512 6933920
18:56:19 20678 8192000000 10872926288 11333783552 1927150192 19.044 99 27 52 2 1942437024 7764752 7522080
18:56:47 44955 8192000000 10881059520 11347267584 1950723920 19.232 100 28 56 0 1970148288 11701664 7722704
18:57:38 34060 8192000000 10900076144 11360477184 1948558160 19.215 99 38 75 1 1970386560 11038432 10789968
18:58:25 72562 8192000000 10893873360 11364896768 1927906064 19.050 98 17 35 0 1947052816 14316656 4830096
18:59:45 75858 8192000000 10913088160 11385356288 1971180416 19.395 100 11 22 0 1983529760 9216928 3132416
19:01:07 54761 8192000000 10892738192 11372257280 1920126672 18.988 97 12 24 2 1936294896 12529792 3638432
19:02:08 52589 8192000000 10915932992 11370143744 1973821424 19.416 100 24 48 1 1995432352 14727968 6882960
19:03:07 17307 8192000000 10913743504 11368140800 1937006736 19.123 98 37 73 1 1956383344 9426608 9950000
19:03:33 43165 8192000000 10904555712 11380936704 1950395392 19.230 99 20 40 1 1968574576 12554368 5624816
19:04:22 66915 8192000000 10900544432 11379232768 1939112800 19.140 99 9 18 0 1958787392 17132656 2541936
19:05:35 50660 8192000000 10908580384 11368038400 1934153552 19.100 98 16 32 1 1948607360 9711856 4741952
19:07:05 75827 8192000000 10894067600 11355332608 1922022496 19.003 97 34 68 0 1941653248 10011920 9618832
19:08:47 77870 8192000000 10904445856 11370196992 1965197056 19.347 100 30 60 2 1982298400 8639232 8462112
19:10:13 61155 8192000000 10846376976 11328008192 1898350400 18.813 96 17 34 3 1911435248 8309504 4775344
19:11:20 28325 8192000000 10855678000 11344707584 1931501184 19.079 99 8 16 0 1944132176 10188288 2442704
19:12:03 11401 8192000000 10860550752 11351093248 1947142000 19.204 100 6 12 1 1956046192 7616608 1287584
19:12:21 69482 8192000000 10872061616 11361431552 1938336720 19.133 99 8 16 0 1946838272 6643696 1857856
19:14:23 47796 8192000000 10907402608 11386945536 1979753168 19.463 100 25 51 3 1999767536 12608608 7405760
19:16:16 51325 8192000000 10885058640 11347529728 1912754272 18.929 98 22 43 1 1932208368 13023840 6430256
19:17:16 67452 8192000000 10864589664 11331026944 1820469040 18.182 93 20 40 0 1842640576 15623680 6547856
19:18:33 61976 8192000000 10871243824 11339116544 1899864640 18.825 98 12 24 0 1914955808 12015568 3075600
19:19:44 33259 8192000000 10883589104 11339902976 1887166336 18.723 97 28 56 0 1903457936 8372320 7919280
19:20:26 38970 8192000000 10856755552 11330457600 1903308768 18.853 98 34 68 0 1926877792 13641040 9927984
19:21:16 45732 8192000000 10873870096 11340132352 1862324352 18.522 96 23 45 2 1879232560 10633872 6274336
19:22:14 49130 8192000000 10897249408 11354918912 1927068864 19.043 99 33 67 3 1949208720 12977152 9162704
19:23:21 15937 8192000000 10880916112 11330609152 1908279776 18.893 98 35 70 0 1928176448 10391008 9505664
19:23:45 11778 8192000000 10883456960 11335045120 1921939808 19.002 99 45 90 1 1945524160 11509728 12074624
19:24:07 13682 8192000000 10889972304 11341217792 1930900528 19.074 99 48 96 1 1955274048 11467808 12905712
19:24:33 10951 8192000000 10900538112 11343699968 1947887376 19.210 100 58 112 1 1974671824 11633840 15150608
19:24:52 34988 8192000000 10885833648 11345018880 1924339312 19.022 99 54 108 0 1954105456 14747856 15018288
19:25:37 74663 8192000000 10848511200 11306881024 1875532992 18.629 97 34 68 2 1896072976 10889088 9650896
19:27:05 38108 8192000000 8885749488 9050214400 66126384 0.800 4 3 4 1 67260224 515680 618160

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 26-02-2021 19:29:24 to 26-02-2021 19:29:56.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 139 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 26-02-2021 19:29:56 to 26-02-2021 19:29:58.

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          245812
MON$OLDEST_ACTIVE               245813
MON$OLDEST_SNAPSHOT             245813
MON$NEXT_TRANSACTION            245813
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                       2043424
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.33420 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33420 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33420 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33420 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 ---
--- end of diff output ---

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

26.02.21 19:29:59. 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-02-26 19:30:02 No severe PSQL-related problems occured
26.02.21 19:30:03. End of report.