Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 25.11.2020 19: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 17472564 kB
MemAvailable 31695700 kB
Buffers 0 kB
Cached 14259580 kB
SwapCached 2112 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-25 19:27:03
DTS_END                         2020-11-25 19:27:03.8610
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/52596
TRN_ID                          244027
ATT_ID                          687
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: 9735.29 16881 1168235
customer order: creation 182.02 326 21842
customer order: refuse 14.66 324 1759
order to supplier: creation 46.74 1262 5609
order to supplier: removal 3.57 86683 428
invoice (draft): creation 47.87 3046 5744
invoice (draft): removal 55.53 683 6663
invoice accept: apply 43.78 16659 5253
invoice accept: cancel 50.48 692 6057
customer reserve: creation 4064.40 163 487728
customer reserve: removal 4901.20 49 588144
realization accept: apply 87.96 174 10555
realization accept: cancel 99.76 90 11971
payment from customer: creation 62.73 110 7528
payment from customer: removal 5.97 77 716
payment to supplier: creation 52.33 155 6280
payment to supplier: removal 3.80 130 456
service: total inventory turnovers 4.60 1223 552
service: total monetary turnovers 7.08 39 850
service: aggregate perf. data 0.80 23066 96
service: refresh index statistics 0.03 202676 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 25-11-2020 19:29:36 to 25-11-2020 19:29:38.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 10513
TEST_TIME 2 5992
TEST_TIME 3 6230
TEST_TIME 4 6482
TEST_TIME 5 5813
TEST_TIME 6 5708
TEST_TIME 7 5879
TEST_TIME 8 6006
TEST_TIME 9 6727
TEST_TIME 10 6754
TEST_TIME 11 6818
TEST_TIME 12 7888
TEST_TIME 13 7800
TEST_TIME 14 8447
TEST_TIME 15 8526
TEST_TIME 16 8762
TEST_TIME 17 8673
TEST_TIME 18 9130
TEST_TIME 19 9446
TEST_TIME 20 9580
TEST_TIME 21 9632
TEST_TIME 22 9428
TEST_TIME 23 9663
TEST_TIME 24 10417
TEST_TIME 25 10631
TEST_TIME 26 10477
TEST_TIME 27 10566
TEST_TIME 28 11050
TEST_TIME 29 11603
TEST_TIME 30 11366
TEST_TIME 31 11311
TEST_TIME 32 11274
TEST_TIME 33 11481
TEST_TIME 34 11414
TEST_TIME 35 11458
TEST_TIME 36 11310
TEST_TIME 37 11144
TEST_TIME 38 11081
TEST_TIME 39 10840
TEST_TIME 40 10816
TEST_TIME 41 10853
TEST_TIME 42 10753
TEST_TIME 43 10701
TEST_TIME 44 10608
TEST_TIME 45 10642
TEST_TIME 46 10674
TEST_TIME 47 10667
TEST_TIME 48 10608
TEST_TIME 49 10604
TEST_TIME 50 10508
TEST_TIME 51 10355
TEST_TIME 52 10310
TEST_TIME 53 10244
TEST_TIME 54 10192
TEST_TIME 55 10075
TEST_TIME 56 10092
TEST_TIME 57 10040
TEST_TIME 58 10035
TEST_TIME 59 10019
TEST_TIME 60 9983
TEST_TIME 61 10108
TEST_TIME 62 10134
TEST_TIME 63 10226
TEST_TIME 64 10195
TEST_TIME 65 10300
TEST_TIME 66 10239
TEST_TIME 67 10297
TEST_TIME 68 10320
TEST_TIME 69 10332
TEST_TIME 70 10341
TEST_TIME 71 10389
TEST_TIME 72 10268
TEST_TIME 73 10291
TEST_TIME 74 10244
TEST_TIME 75 10201
TEST_TIME 76 10163
TEST_TIME 77 10102
TEST_TIME 78 10060
TEST_TIME 79 10037
TEST_TIME 80 9930
TEST_TIME 81 9903
TEST_TIME 82 9957
TEST_TIME 83 9925
TEST_TIME 84 9930
TEST_TIME 85 10066
TEST_TIME 86 10095
TEST_TIME 87 10081
TEST_TIME 88 10044
TEST_TIME 89 10086
TEST_TIME 90 10119
TEST_TIME 91 10132
TEST_TIME 92 10147
TEST_TIME 93 10170
TEST_TIME 94 10110
TEST_TIME 95 10086
TEST_TIME 96 10047
TEST_TIME 97 10030
TEST_TIME 98 10001
TEST_TIME 99 9940
TEST_TIME 100 9923
TEST_TIME 101 9856
TEST_TIME 102 9794
TEST_TIME 103 9795
TEST_TIME 104 9802
TEST_TIME 105 9794
TEST_TIME 106 9794
TEST_TIME 107 9836
TEST_TIME 108 9820
TEST_TIME 109 9806
TEST_TIME 110 9824
TEST_TIME 111 9846
TEST_TIME 112 9843
TEST_TIME 113 9918
TEST_TIME 114 9972
TEST_TIME 115 9977
TEST_TIME 116 9935
TEST_TIME 117 9868
TEST_TIME 118 9837
TEST_TIME 119 9807
TEST_TIME 120 9741

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 25-11-2020 19:29:40 to 25-11-2020 19:29:43.

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 1619424 1619424 0 0.00 0 17837 6 0 0
doc_list_biud 1619424 1619424 0 0.00 0 39956 23 0 0
sp_add_invoice_to_stock 5387 5253 134 2.48 38 182431 16660 0 134
sp_cancel_adding_invoice 6057 6057 0 0.00 5 87736 693 0 0
sp_cancel_client_order 1759 1759 0 0.00 4 10061 325 0 0
sp_cancel_customer_reserve 588144 588144 0 0.00 1 39959 50 0 0
sp_cancel_pay_from_customer 716 716 0 0.00 3 5308 77 0 0
sp_cancel_pay_to_supplier 456 456 0 0.00 3 8694 130 0 0
sp_cancel_supplier_invoice 6679 6663 16 0.23 2 14265 683 0 16
sp_cancel_supplier_order 428 428 0 0.00 5 833032 86684 0 0
sp_cancel_write_off 11971 11971 0 0.00 1 15727 91 0 0
sp_client_order 21842 21842 0 0.00 4 19585 327 0 0
sp_customer_reserve 487728 487728 0 0.00 0 102125 164 0 0
sp_fill_shopping_cart 33193 33193 0 0.00 1 12365 33 0 0
sp_fill_shopping_cart_clo_res 487724 487724 0 0.00 0 15341 14 0 0
sp_get_clo_for_invoice 5244 5244 0 0.00 0 27304 271 0 0
sp_kill_cost_storno 19200 19200 0 0.00 0 14086 47 0 0
sp_kill_qstorno_ret_qs2qd 1195350 1195350 0 0.00 0 39828 27 0 0
sp_kill_qty_storno 630821 630821 0 0.00 0 39956 58 0 0
sp_lock_selected_doc 21746 21746 0 0.00 0 9109 7 0 0
sp_make_cost_storno 29607 29607 0 0.00 0 17834 58 0 0
sp_multiply_rows_for_pdistr 29607 29607 0 0.00 0 7892 27 0 0
sp_multiply_rows_for_qdistr 21842 21842 0 0.00 0 13636 158 0 0
sp_pay_from_customer 7528 7528 0 0.00 4 20503 110 0 0
sp_pay_to_supplier 6280 6280 0 0.00 5 20719 156 0 0
sp_payment_common 13808 13808 0 0.00 2 20491 32 0 0
sp_qd_handle_on_cancel_clo 1759 1759 0 0.00 0 10051 289 0 0
sp_qd_handle_on_invoice_upd_sts 11301 11301 0 0.00 0 19456 284 0 0
sp_qd_handle_on_reserve_upd_sts 10555 10555 0 0.00 0 20428 48 0 0
sp_reserve_write_off 10555 10555 0 0.00 6 20459 174 0 0
sp_supplier_invoice 5744 5744 0 0.00 5 81206 3047 0 0
sp_supplier_order 5609 5609 0 0.00 5 57618 1263 0 0
srv_aggregate_perf_data 96 96 0 0.00 3667 418617 23066 0 0
srv_fill_mon_cache_memory 166 166 0 0.00 601 144196 33085 0 0
srv_find_qd_qs_mism 1117634 1117634 0 0.00 0 8993 5 0 0
srv_make_invnt_saldo 552 552 0 0.00 28 84094 1223 0 0
srv_make_money_saldo 850 850 0 0.00 1 15835 39 0 0
srv_recalc_idx_stat 4 4 0 0.00 85870 361555 202677 0 0
t$perf-abend:sp_add_invoice_to_stock 134 134 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 16 16 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5253 5253 0 0.00 0 13523 139 0 0
t$perf-norm:sp_cancel_adding_invoice 459 459 0 0.00 0 10360 103 0 0
t$perf-norm:sp_cancel_client_order 1759 1759 0 0.00 0 1959 12 0 0
t$perf-norm:sp_cancel_customer_reserve 748 748 0 0.00 0 1302 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 716 716 0 0.00 0 274 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 456 456 0 0.00 0 825 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 410 410 0 0.00 0 502 13 0 0
t$perf-norm:sp_cancel_supplier_order 428 428 0 0.00 0 18227 1315 0 0
t$perf-norm:sp_cancel_write_off 971 971 0 0.00 0 2457 6 0 0
t$perf-norm:sp_client_order 21842 21842 0 0.00 0 16383 15 0 0
t$perf-norm:sp_customer_reserve 1030 1030 0 0.00 0 2494 7 0 0
t$perf-norm:sp_pay_from_customer 7528 7528 0 0.00 0 4864 8 0 0
t$perf-norm:sp_pay_to_supplier 6280 6280 0 0.00 0 7019 7 0 0
t$perf-norm:sp_reserve_write_off 10555 10555 0 0.00 0 4888 8 0 0
t$perf-norm:sp_supplier_invoice 5744 5744 0 0.00 0 12055 18 0 0
t$perf-norm:sp_supplier_order 5609 5609 0 0.00 0 3800 13 0 0
t$perf-norm:srv_aggregate_perf_data 96 96 0 0.00 0 290 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 166 166 0 0.00 0 837 7 0 0
t$perf-norm:srv_make_invnt_saldo 552 552 0 0.00 0 1054 14 0 0
t$perf-norm:srv_make_money_saldo 850 850 0 0.00 0 1198 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 4 0 0
v_add_invoice_to_stock 10756 10488 268 2.49 0 4753 18 0 268
v_all_customers 39904 39904 0 0.00 0 46 1 0 0
v_all_suppliers 31614 31614 0 0.00 0 102 1 0 0
v_all_wares 43684 43684 0 0.00 0 27 1 0 0
v_cancel_adding_invoice 918 918 0 0.00 0 1627 7 0 0
v_cancel_client_order 3518 3518 0 0.00 0 6916 7 0 0
v_cancel_customer_prepayment 1432 1432 0 0.00 0 3410 9 0 0
v_cancel_customer_reserve 1496 1496 0 0.00 0 3029 7 0 0
v_cancel_payment_to_supplier 912 912 0 0.00 0 7538 17 0 0
v_cancel_supplier_invoice 852 820 32 3.75 0 4764 18 0 32
v_cancel_supplier_order 856 856 0 0.00 0 2095 8 0 0
v_cancel_write_off 1942 1942 0 0.00 0 2104 12 0 0
v_max_id_clo_ord 5609 5609 0 0.00 0 464 1 0 0
v_max_id_clo_res 1030 1030 0 0.00 0 2188 17 0 0
v_max_id_ord_sup 5742 5742 0 0.00 0 4396 4 0 0
v_max_non_paid_invoice 1824 1824 0 0.00 0 4009 7 0 0
v_max_non_paid_realizn 3847 3847 0 0.00 0 2626 3 0 0
v_min_id_clo_ord 5609 5609 0 0.00 0 4285 9 0 0
v_min_id_clo_res 1030 1030 0 0.00 0 3369 10 0 0
v_min_id_ord_sup 5742 5742 0 0.00 0 3618 5 0 0
v_min_non_paid_invoice 6280 6280 0 0.00 0 15617 23 0 0
v_min_non_paid_realizn 7528 7528 0 0.00 0 20484 20 0 0
v_our_firm 11142 11142 0 0.00 0 15 1 0 0
v_reserve_write_off 21110 21110 0 0.00 0 8956 8 0 0
x_lock_depdocs_on_canc_invoice 12310 12310 0 0.00 0 20030 109 0 0
x_lock_depdocs_on_canc_sup_ord 428 428 0 0.00 0 19935 409 0 0
x_make_qstorno_1000_1200 5609 5609 0 0.00 2 57602 1188 0 0
x_make_qstorno_1200_2000 5744 5744 0 0.00 2 81091 2933 0 0
x_make_qstorno_2100_3300 487728 487728 0 0.00 0 100303 148 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 25-11-2020 19:29:44 to 25-11-2020 19:29:48.

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:07 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:14 25254 8192000000 10279618944 10590195712 924983024 10.145 70 60 120 0 947036832 2628784 19425024
16:57:46 19414 8192000000 10331968128 10647781376 1382935296 14.443 100 85 170 0 1415984304 4724592 28324416
16:58:20 26651 8192000000 10379272688 10697752576 1426902432 14.834 100 88 176 0 1462014992 6198816 28913744
16:58:59 24777 8192000000 10392337232 10716684288 1443596032 14.981 100 91 182 0 1481152960 7316656 30240272
16:59:36 22504 8192000000 10412426864 10739294208 1459620592 15.123 100 84 166 1 1494278208 7608000 27049616
17:00:10 19083 8192000000 10430747760 10761203712 1481745728 15.317 100 89 178 0 1518624576 8217696 28661152
17:00:41 18845 8192000000 10450938672 10786119680 1503759680 15.509 100 83 166 0 1539308336 9114944 26433712
17:01:10 15544 8192000000 10471960256 10808573952 1520716000 15.656 100 87 174 0 1557940704 9519216 27705488
17:01:39 15982 8192000000 10494361776 10836107264 1549638432 15.907 100 87 174 2 1586833184 10367136 26827616
17:02:04 16921 8192000000 10514453744 10867343360 1563543552 16.027 100 81 162 1 1599873680 10949232 25380896
17:02:36 12963 8192000000 10551174176 10908643328 1605663760 16.388 100 77 154 0 1639942208 11201136 23077312
17:03:03 11282 8192000000 10577061808 10938097664 1635845248 16.645 100 83 166 0 1672593456 12038736 24709472
17:03:27 13266 8192000000 10596266400 10964299776 1656945968 16.823 100 74 148 0 1690598032 12276752 21375312
17:03:51 8513 8192000000 10625038080 10994376704 1685451040 17.063 100 85 168 1 1722201984 12858112 23892832
17:04:09 8664 8192000000 10636124352 11010580480 1701015520 17.194 100 83 167 0 1737328960 12033536 24279904
17:04:25 7663 8192000000 10659920464 11029684224 1716449776 17.323 100 86 172 0 1753523728 12275632 24798320
17:04:40 8643 8192000000 10668505280 11044212736 1728949184 17.427 100 81 162 1 1764652000 12504016 23198800
17:04:56 6001 8192000000 10682473184 11053916160 1737328416 17.496 100 82 165 0 1774200816 12984384 23888016
17:05:09 5876 8192000000 10686214304 11067633664 1749046496 17.594 100 78 155 0 1784919552 13049392 22823664
17:05:22 5585 8192000000 10696636224 11075002368 1758615616 17.673 100 79 156 1 1794048240 12521360 22911264
17:05:34 3786 8192000000 10700474512 11085389824 1767222896 17.744 100 72 144 1 1799416016 12096160 20096960
17:05:45 3412 8192000000 10714456992 11095265280 1776738992 17.823 100 75 150 0 1810020592 11826304 21455296
17:05:55 3688 8192000000 10728942176 11109478400 1792971904 17.956 100 90 180 2 1830435712 11983152 25480656
17:06:06 2841 8192000000 10735708048 11117015040 1798341920 18.000 100 83 165 1 1833401152 12153648 22905584
17:06:15 4406 8192000000 10743156816 11127250944 1806886064 18.070 100 80 160 1 1842420800 12636944 22897792
17:06:26 4467 8192000000 10750967264 11131052032 1808458096 18.083 100 85 169 0 1845325936 13435040 23432800
17:06:37 3001 8192000000 10755856544 11139555328 1814332000 18.131 100 90 179 0 1853084000 14146688 24605312
17:06:47 9927 8192000000 10759831968 11142811648 1816870192 18.152 100 90 180 3 1856338384 14628000 24840192
17:07:03 6033 8192000000 10761064624 11149148160 1819954784 18.177 100 80 160 1 1856501040 14426208 22120048
17:07:16 2154 8192000000 10784523952 11165552640 1831974448 18.275 100 91 182 2 1872635776 15064624 25596704
17:07:25 2869 8192000000 10786555424 11168985088 1840661888 18.346 100 90 178 0 1879674304 14049136 24963280
17:07:34 2126 8192000000 10780255136 11166633984 1841861264 18.356 100 90 179 0 1880745664 13238096 25646304
17:07:43 1563 8192000000 10789213376 11173564416 1846777072 18.396 100 93 185 1 1885603648 12751968 26074608
17:07:51 2472 8192000000 10789683472 11177148416 1849599760 18.419 100 84 168 4 1886295712 13343760 23352192
17:08:01 2710 8192000000 10804278256 11190792192 1854780288 18.461 100 90 181 3 1893735616 13649424 25305904
17:08:10 2879 8192000000 10804648400 11190804480 1856914352 18.478 100 91 182 1 1896935328 13858640 26162336
17:08:19 1371 8192000000 10806449216 11194335232 1863637312 18.533 100 93 189 2 1903720112 14260048 25822752
17:08:27 1543 8192000000 10810596944 11196375040 1862994512 18.528 100 95 190 1 1905377664 14629968 27753184
17:08:35 1770 8192000000 10809590304 11200372736 1864526960 18.540 100 90 179 0 1903239264 13984144 24728160
17:08:43 1649 8192000000 10803877744 11197968384 1870055232 18.585 100 94 188 2 1909614016 13656512 25902272
17:08:51 1518 8192000000 10815818592 11202707456 1870337520 18.587 100 91 184 3 1910485504 13015872 27132112
17:08:58 1676 8192000000 10819517200 11207573504 1871382304 18.595 100 97 193 1 1912512912 13378464 27752144
17:09:06 1023 8192000000 10821390576 11210063872 1875654816 18.630 100 95 189 2 1916740720 13969040 27116864
17:09:14 1232 8192000000 10825118432 11212152832 1874754960 18.623 100 93 188 0 1914937248 11900432 28281856
17:09:21 1740 8192000000 10818341872 11211382784 1877577584 18.646 100 83 165 1 1913813360 12463712 23772064
17:09:32 38018 8192000000 10813149040 11214491648 1875046880 18.625 100 62 125 1 1900747952 6983392 18717680
17:10:16 3960 8192000000 10816451760 11220549632 1881432368 18.677 100 75 150 2 1913913840 10531696 21949776
17:10:26 4442 8192000000 10787281776 11212574720 1874537040 18.621 100 41 83 1 1895901328 9728992 11635296
17:10:38 6670 8192000000 10784558544 11210407936 1872007040 18.601 100 26 51 1 1885436032 6606112 6822880
17:10:51 8294 8192000000 10786559728 11213983744 1874566672 18.621 100 31 62 0 1890383808 6751920 9065216
17:11:06 6105 8192000000 10795216992 11215912960 1874807232 18.623 100 30 60 1 1890499440 7261968 8430240
17:11:21 15171 8192000000 10786270944 11218075648 1876670480 18.638 100 19 38 2 1888043264 5695264 5677520
17:11:42 9491 8192000000 10791979264 11227803648 1881994288 18.681 100 20 40 1 1894343408 6415728 5933392
17:12:01 5381 8192000000 10799561840 11229315072 1884624992 18.702 100 14 28 0 1893984528 5285088 4074448
17:12:18 9624 8192000000 10797980176 11233120256 1890385968 18.749 100 19 38 0 1901326352 5967216 4973168
17:12:34 7955 8192000000 10804590992 11234054144 1888317680 18.732 100 11 22 1 1896547024 5338544 2890800
17:12:48 12539 8192000000 10795330752 11233693696 1890766544 18.752 100 16 32 1 1901602288 6115664 4720080
17:13:09 12800 8192000000 10802913744 11241115648 1895481136 18.790 100 35 70 1 1915945184 10987456 9476592
17:13:29 63454 8192000000 10822168128 11247951872 1896500816 18.798 100 35 68 2 1911473072 5082384 9889872
17:14:40 24107 8192000000 10822354352 11254206464 1899045024 18.819 100 13 26 0 1907817584 5573776 3198784
17:15:10 10539 8192000000 10824806896 11257774080 1885718832 18.711 99 27 54 2 1899804800 6434512 7651456
17:15:28 5279 8192000000 10821551136 11257049088 1905900752 18.874 100 28 56 4 1920809376 7424416 7484208
17:15:39 4335 8192000000 10827153968 11262943232 1906955632 18.882 100 23 46 1 1924441568 10863232 6622704
17:15:55 3793 8192000000 10824731376 11261997056 1904375168 18.861 100 27 54 0 1927115488 15201984 7538336
17:16:06 5719 8192000000 10808428480 11245662208 1888722656 18.735 99 18 36 2 1900110448 6153888 5233904
17:16:18 6479 8192000000 10817585152 11251056640 1888684832 18.735 99 32 62 3 1903697088 5693072 9319184
17:16:31 10619 8192000000 10813840736 11242110976 1864441408 18.539 98 15 30 1 1874061888 5591936 4028544
17:16:49 6598 8192000000 10797154080 11236421632 1854447488 18.458 98 24 49 1 1867320672 6076320 6796864
17:17:02 13322 8192000000 10795871584 11231821824 1855808304 18.469 98 8 16 1 1862705184 4959040 1937840
17:17:25 13550 8192000000 10786997440 11220230144 1817206592 18.155 96 17 34 0 1828164176 5638240 5319344
17:17:48 8630 8192000000 10772448608 11202953216 1833586608 18.289 98 14 28 1 1842547024 5211952 3748464
17:18:06 15147 8192000000 10772922880 11196149760 1810569776 18.101 97 12 24 2 1819708368 5834656 3303936
17:18:27 79593 8192000000 10695297824 11116216320 1690735104 17.107 91 31 62 0 1705015424 5266896 9013424
17:19:56 7750 8192000000 10743436112 11159863296 1764998528 17.726 96 27 54 2 1778740096 6390144 7351424
17:20:10 2967 8192000000 10712257712 11123421184 1757259952 17.662 97 45 90 4 1778026800 8273184 12493664
17:20:20 7051 8192000000 10725424896 11134496768 1755027488 17.643 97 34 69 0 1771459072 6617136 9814448
17:20:34 6958 8192000000 10714157456 11139985408 1775060208 17.809 98 34 68 0 1791758464 6961840 9736416
17:20:48 7021 8192000000 10699197744 11118710784 1744036496 17.552 97 17 34 0 1753877024 4807552 5032976
17:21:02 8334 8192000000 10693027760 11104256000 1733003744 17.460 96 26 52 2 1749511424 9312880 7194800
17:21:16 4964 8192000000 10690272032 11096707072 1759528336 17.680 99 37 72 0 1776352784 5877008 10947440
17:21:30 9160 8192000000 10727890160 11139936256 1793110848 17.957 100 23 46 0 1806225616 6516064 6598704
17:21:45 9323 8192000000 10725380496 11140562944 1770045584 17.767 98 32 65 1 1786156560 5989264 10121712
17:22:04 7056 8192000000 10706696016 11121135616 1786280864 17.901 99 26 52 1 1800194672 6252704 7661104
17:22:21 10219 8192000000 10706234624 11120181248 1741445888 17.531 96 30 57 0 1754991168 4747584 8797696
17:22:39 7089 8192000000 10714055552 11132739584 1771024272 17.775 98 22 44 3 1782908864 5258656 6625936
17:22:56 14054 8192000000 10732516048 11154132992 1817556912 18.158 100 24 48 3 1830628736 5320928 7750896
17:23:17 17757 8192000000 10754108272 11170488320 1827255872 18.237 100 22 44 0 1840222032 5253744 7712416
17:23:56 46530 8192000000 10768014384 11180314624 1843901984 18.373 100 40 80 2 1862401872 7333552 11166336
17:24:50 12211 8192000000 10764162832 11186036736 1843189328 18.367 100 22 44 2 1854976768 5789024 5998416
17:25:10 6860 8192000000 10776977136 11197431808 1852312864 18.441 100 34 68 0 1868303472 5810896 10179712
17:25:23 6272 8192000000 10772635680 11186966528 1836742000 18.314 99 29 58 1 1850451632 5264432 8445200
17:25:37 9057 8192000000 10763080000 11191881728 1852073984 18.439 100 17 34 1 1862604448 5694560 4835904
17:25:54 10789 8192000000 10774176736 11203129344 1858457008 18.491 100 20 38 1 1869391584 5050560 5884016
17:26:14 3998 8192000000 10785128160 11213799424 1865461792 18.548 100 32 64 1 1885919760 11882512 8575456
17:26:26 7799 8192000000 10778663104 11208245248 1865746768 18.550 100 22 45 5 1877754816 5674304 6333744
17:26:40 15029 8192000000 10779390192 11214000128 1869192784 18.578 100 18 37 1 1880029120 5332656 5503680
17:27:02 21104 8192000000 10812707616 11229413376 1878906064 18.656 100 29 58 1 1893024000 5488144 8629792
17:27:30 6940 8192000000 10832786944 11245412352 1900831552 18.833 100 56 112 0 1923694864 6320144 16543168
17:27:47 4431 8192000000 10849983968 11259400192 1910237504 18.909 100 60 121 3 1935554480 8496544 16820432
17:28:04 3910 8192000000 10851295744 11265601536 1917295376 18.965 100 58 116 0 1943118800 9118400 16705024
17:28:17 8481 8192000000 10855047904 11274158080 1923291712 19.013 100 50 99 1 1946686880 8704880 14690288
17:28:38 42181 8192000000 10873635632 11293773824 1929440944 19.062 100 59 116 2 1954879872 9089040 16349888
17:29:37 43373 8192000000 10868730736 11299606528 1944101264 19.179 100 50 98 4 1970416384 11435792 14879328
17:30:28 18798 8192000000 10878693136 11303706624 1925602896 19.032 99 52 104 0 1952296032 11129328 15563808
17:30:59 31032 8192000000 10877153424 11316842496 1949937280 19.226 100 50 100 2 1979302912 14422752 14942880
17:31:41 10350 8192000000 10887253760 11320598528 1955435712 19.270 100 44 88 2 1980630064 12183040 13011312
17:31:59 27422 8192000000 10905330256 11332325376 1964054672 19.338 100 51 102 0 1993552320 14833568 14664080
17:32:35 23855 8192000000 10900221616 11336794112 1966914560 19.361 100 51 100 1 1996810384 15229648 14666176
17:33:38 16642 8192000000 10918919424 11353464832 1974439632 19.421 100 42 83 2 2009851392 23086944 12324816
17:34:04 11147 8192000000 10927281856 11355672576 1977804288 19.447 100 45 88 1 2008863968 17926384 13133296
17:34:25 15490 8192000000 10915571856 11356352512 1983482176 19.492 100 51 103 1 2018406560 19653168 15271216
17:34:47 6723 8192000000 10920557744 11354980352 1978051360 19.449 100 50 100 2 2013944224 20786080 15106784
17:35:01 12361 8192000000 10940649008 11371782144 1982102912 19.481 100 49 98 3 2020024272 24252992 13668368
17:35:20 2851 8192000000 10931791136 11355381760 1974716736 19.423 100 64 130 1 2013738784 21083328 17938720
17:35:30 5682 8192000000 10938516512 11359653888 1980428976 19.468 100 72 142 1 2024556944 23439088 20688880
17:35:42 3276 8192000000 10946932000 11363037184 1983510128 19.492 100 79 158 1 2030404288 23815024 23079136
17:35:54 4555 8192000000 10947355648 11371532288 1987299744 19.522 100 73 145 0 2037624672 28588464 21736464
17:36:08 5595 8192000000 10959883040 11377811456 1992585248 19.564 100 72 140 3 2038639536 24985456 21068832
17:36:21 2307 8192000000 10962732416 11380981760 1997773856 19.605 100 79 159 1 2048222160 27215072 23233232
17:36:31 5553 8192000000 10954866960 11373256704 1991312048 19.554 100 87 170 2 2044682560 27706128 25664384
17:36:57 18912 8192000000 10934705632 11377836032 1989077760 19.537 100 46 91 2 2027039280 24546016 13415504
17:37:25 5260 8192000000 10950758224 11385372672 1991291664 19.554 100 58 114 1 2039520240 31514752 16713824
17:37:37 9168 8192000000 10952617856 11377545216 1974702240 19.423 99 63 126 2 2021926512 28615968 18608304
17:37:53 3319 8192000000 10958178224 11385913344 1996602320 19.596 100 74 147 2 2049719792 29558256 23559216
17:38:05 11161 8192000000 10932553200 11370352640 1958986352 19.298 98 64 127 0 2007759872 29948096 18825424
17:38:27 3596 8192000000 10946805600 11371978752 1972597440 19.406 99 66 129 0 2022940064 32037568 18305056
17:38:38 2325 8192000000 10962117984 11376852992 1990388800 19.547 100 82 163 0 2048277296 33635792 24252704
17:38:48 2018 8192000000 10969813248 11382784000 1988462944 19.532 100 89 178 0 2050199888 34785392 26951552
17:38:59 9943 8192000000 10954130272 11375702016 1970166224 19.387 99 73 146 0 2025949824 33974240 21809360
17:39:18 1820 8192000000 10965749840 11388579840 1990666816 19.549 100 81 162 2 2047259936 32808576 23784544
17:39:26 3581 8192000000 10974150256 11392983040 1996540448 19.595 100 87 175 2 2058672992 35249472 26883072
17:39:38 2583 8192000000 10959328496 11377774592 1977898144 19.448 99 79 160 0 2037381552 35683648 23799760
17:39:48 2387 8192000000 10965179168 11383418880 1990527792 19.548 100 79 154 1 2048345504 34723168 23094544
17:39:58 3708 8192000000 10958578000 11387867136 1995161584 19.585 100 73 147 0 2049619232 31579152 22878496
17:40:11 3081 8192000000 10969570992 11393196032 1998299648 19.609 100 54 108 0 2043492832 29092544 16100640
17:40:21 5835 8192000000 10944712816 11365732352 1978517488 19.453 99 78 158 0 2033282608 30611680 24153440
17:40:35 4079 8192000000 10945671808 11366133760 1972834816 19.408 99 75 148 1 2026954832 31601712 22518304
17:40:48 1854 8192000000 10960507744 11376750592 1973092064 19.410 99 80 157 3 2028891696 32658800 23140832
17:40:57 5536 8192000000 10957367552 11384696832 1972166560 19.403 99 71 142 1 2031496496 37462224 21867712
17:41:11 4644 8192000000 10955525984 11378499584 1964515904 19.342 99 69 136 3 2021458544 35283392 21659248
17:41:25 1148 8192000000 10962636448 11374731264 1974866272 19.424 99 90 179 2 2040000768 37530368 27604128
17:41:33 1121 8192000000 10975714448 11392520192 1990572336 19.548 100 85 171 1 2055986096 38992208 26421552
17:41:42 2217 8192000000 10965343760 11392700416 1995001664 19.583 100 70 140 0 2048231184 32605760 20623760
17:41:50 599 8192000000 10969230992 11393110016 1997001024 19.599 100 78 155 2 2052158192 32100512 23056656
17:41:58 13777 8192000000 10950111408 11379630080 1968791456 19.376 99 61 122 1 2023336288 36372928 18171904
17:42:19 4757 8192000000 10951251840 11380133888 1986272096 19.514 100 59 118 1 2037314032 32815552 18226384
17:42:30 6742 8192000000 10952074928 11382124544 1983784112 19.495 100 61 123 1 2035530640 33065472 18681056
17:42:44 4598 8192000000 10956992736 11381436416 1969193520 19.379 99 68 133 0 2021002736 31459360 20349856
17:42:58 5669 8192000000 10957503392 11388829696 1985762224 19.510 100 57 114 0 2037840144 34502752 17575168
17:43:12 7915 8192000000 10918542288 11372511232 1974342112 19.420 100 38 76 1 2018517968 32277584 11898272
17:43:37 8656 8192000000 10916161920 11357691904 1947018608 19.203 99 31 62 1 1990120864 32746112 10356144
17:44:03 9767 8192000000 10922429440 11356340224 1960002592 19.306 100 49 97 2 2010257760 35151680 15103488
17:44:22 4726 8192000000 10927498288 11357253632 1952083840 19.243 100 44 85 1 2005027744 39238960 13704944
17:44:33 2748 8192000000 10950780896 11366825984 1964310400 19.340 100 77 155 2 2029533920 40955088 24268432
17:44:43 2122 8192000000 10966466736 11390332928 1979008768 19.457 100 74 149 2 2049713696 47632880 23072048
17:44:56 12559 8192000000 10954609040 11391819776 1980281280 19.467 100 50 98 0 2040549680 44563168 15705232
17:45:23 4836 8192000000 10939430480 11380219904 1963730192 19.336 100 43 84 1 2023585632 45880416 13975024
17:45:35 4168 8192000000 10929657344 11363069952 1947177824 19.204 99 44 88 0 1995781008 34867184 13736000
17:45:46 4922 8192000000 10921473312 11346497536 1944142992 19.180 99 62 125 2 1999955776 36654912 19157872
17:45:59 16408 8192000000 10909701520 11366699008 1947335664 19.205 99 41 80 2 1995837472 36081328 12420480
17:46:31 10864 8192000000 10905015040 11342606336 1918070944 18.971 98 41 82 1 1961465312 30490736 12903632
17:46:48 14653 8192000000 10891360768 11325227008 1918237056 18.973 98 34 68 0 1961443136 32148944 11057136
17:47:13 11383 8192000000 10929986240 11356131328 1940134208 19.148 99 49 96 3 1990964880 35265200 15565472
17:47:32 8622 8192000000 10915937264 11353370624 1939527136 19.143 99 40 80 2 1988332976 35545952 13259888
17:47:57 15584 8192000000 10928284640 11362791424 1959426000 19.301 100 29 56 1 2005137328 36082272 9629056
17:48:20 8285 8192000000 10917289808 11352985600 1935367744 19.110 99 48 96 0 1990257968 39617008 15273216
17:48:40 9170 8192000000 10932105312 11371778048 1957398352 19.285 100 34 69 2 2009054816 40370560 11285904
17:48:56 17216 8192000000 10932434224 11368628224 1942555872 19.167 99 29 58 2 1990273984 37651568 10066544
17:49:20 17925 8192000000 10923409008 11374964736 1958533616 19.294 100 32 63 3 2012376592 43376832 10466144
17:49:44 13451 8192000000 10912522240 11355901952 1921499984 18.999 98 26 52 0 1976557248 46021776 9035488
17:50:06 2127 8192000000 10939221264 11358224384 1916287520 18.957 98 60 120 2 1984424448 48224080 19912848
17:50:15 12679 8192000000 10930966336 11370295296 1930469824 19.071 99 42 84 2 1999305280 54527280 14308176
17:50:38 17929 8192000000 10928532992 11374669824 1931043664 19.075 99 36 69 1 2000563008 57559456 11959888
17:51:04 23422 8192000000 10918318736 11373236224 1952559696 19.247 100 22 44 1 2007506256 47603136 7343424
17:51:41 20925 8192000000 10904453792 11360305152 1947444512 19.206 100 19 38 0 1992526816 38238496 6843808
17:52:34 9336 8192000000 10918874272 11368054784 1956925856 19.282 100 41 80 4 2007284736 36822160 13536720
17:52:54 17966 8192000000 10915199472 11374645248 1951574320 19.239 100 15 30 0 1992813888 35704528 5535040
17:53:39 28494 8192000000 10912302784 11373015040 1952727552 19.248 100 22 44 2 1999323888 39361248 7235088
17:54:15 53181 8192000000 10892817616 11354705920 1912255200 18.925 98 22 44 2 1965762416 45793072 7714144
17:55:14 35976 8192000000 10882287456 11351547904 1893675168 18.775 98 17 34 1 1938185568 38472928 6037472
17:55:56 20906 8192000000 10874948992 11357597696 1921553296 18.999 100 11 22 0 1966078384 40752112 3772976
17:56:23 14871 8192000000 10854692912 11339071488 1903406704 18.854 99 5 9 1 1924969760 20133456 1429600
17:56:45 18083 8192000000 10893623264 11324846080 1939661632 19.144 100 50 98 2 1963242208 7181600 16398976
17:57:13 41772 8192000000 10908766752 11337834496 1934949808 19.106 99 49 99 0 1960498832 12069152 13479872
17:58:03 137321 8192000000 10906678752 11367784448 1903283216 18.853 97 13 26 1 1922744464 16760576 2700672
18:00:56 144196 8192000000 10911826896 11360505856 1923046016 19.011 98 9 19 1 1946374944 21145056 2183872
18:03:27 93560 8192000000 10908419280 11358814208 1949852768 19.225 99 21 42 0 1967319216 11670800 5795648
18:05:09 90879 8192000000 10908381008 11369005056 1972976912 19.409 100 31 60 1 1992071424 10342464 8752048
18:06:47 8961 8192000000 10912529120 11363303424 1963860432 19.337 99 49 98 1 1985772976 7283008 14629536
18:07:04 72225 8192000000 10901361808 11369992192 1942111728 19.164 98 17 34 0 1957974720 11209216 4653776
18:08:24 60832 8192000000 10916795856 11369267200 1961112544 19.315 99 44 88 3 1983894192 10201600 12580048
18:09:35 90739 8192000000 10918033360 11380924416 1964434576 19.341 99 26 51 0 1981593616 9857056 7301984
18:11:12 51424 8192000000 10873347648 11339210752 1934515648 19.103 97 35 69 2 1956412752 10873280 11023824
18:12:11 67633 8192000000 10947798128 11397931008 1982931808 19.488 100 30 59 0 2003740032 11857312 8950912
18:13:31 40691 8192000000 10924886304 11382583296 1955722528 19.272 98 49 97 1 1984095264 14553072 13819664
18:14:18 61198 8192000000 10897236368 11384520704 1974749488 19.423 100 6 13 1 1992955472 16312400 1893584
18:15:30 25048 8192000000 10905021408 11394363392 1978906752 19.456 100 6 12 1 1995005520 14472352 1626416
18:16:03 3669 8192000000 10907854608 11397726208 1981009616 19.473 100 6 12 0 2000239728 17407120 1822992
18:16:45 8871 8192000000 10917797024 11385966592 1983518624 19.493 100 11 22 1 1995422432 9369520 2534288
18:17:01 51391 8192000000 10889377888 11365662720 1926218208 19.037 97 11 22 0 1938361408 9253152 2890048
18:17:58 19771 8192000000 10892948592 11370012672 1971351920 19.396 100 7 15 0 1984692768 10179232 3161616
18:18:24 52045 8192000000 10903380752 11373289472 1957118608 19.283 99 15 30 0 1974487392 12896960 4471824
18:19:22 31205 8192000000 10897296272 11371716608 1957388768 19.285 99 24 48 2 1972833232 9244336 6200128
18:20:00 32191 8192000000 10917411744 11388702720 1982762512 19.487 100 25 48 2 1996595328 7301632 6531184
18:20:42 55216 8192000000 10907593024 11394912256 1988645360 19.533 100 13 26 1 2002377312 10331728 3400224
18:22:12 20143 8192000000 10908493584 11400024064 1988131328 19.529 100 10 21 0 2003295984 12195392 2969264
18:22:44 38307 8192000000 10899798832 11394101248 1968541312 19.374 99 5 10 0 1980097408 10420496 1135600
18:23:32 57495 8192000000 10895975776 11381383168 1945958304 19.194 98 10 20 0 1956587664 8119008 2510352
18:24:36 36707 8192000000 10894537600 11370475520 1926339824 19.038 97 16 32 1 1937553728 6647152 4566752
18:25:27 53086 8192000000 10882157712 11359682560 1896123776 18.795 96 20 40 0 1911233232 9803680 5305776
18:26:26 22736 8192000000 10879214288 11349565440 1901147600 18.836 97 16 32 1 1915978320 10369008 4461712
18:26:55 63781 8192000000 10861386912 11326730240 1832566944 18.280 94 19 38 1 1849683312 11847056 5269312
18:28:05 41588 8192000000 10879232928 11348406272 1931735232 19.081 99 14 28 2 1947177536 11629456 3812848
18:28:57 66568 8192000000 10855327728 11334246400 1813112304 18.121 93 22 44 2 1834523600 15370352 6040944
18:30:26 76003 8192000000 10897231136 11348619264 1898068992 18.811 98 10 20 0 1912677040 11406688 3201360
18:31:48 41298 8192000000 10846663184 11321024512 1889951600 18.745 98 18 36 2 1911986896 16569472 5465824
18:32:37 63653 8192000000 10853989136 11302449152 1805934848 18.063 93 22 44 1 1820256192 8324480 5996864
18:33:54 60847 8192000000 10868794080 11336945664 1930100736 19.068 100 25 50 1 1949087920 11844544 7142640
18:35:01 85323 8192000000 10880709056 11339939840 1877460272 18.645 96 16 32 2 1894365680 12672096 4233312
18:36:37 82588 8192000000 10865632240 11336658944 1881953904 18.681 97 8 16 1 1899259728 14977440 2328384
18:38:09 79861 8192000000 10850860192 11322048512 1880007712 18.665 97 24 48 0 1896822400 9745216 7069472
18:40:03 98669 8192000000 10841759296 11332214784 1890531792 18.750 98 18 36 0 1921727296 26073824 5121680
18:41:57 46118 8192000000 10839507008 11309096960 1886582992 18.718 98 18 36 0 1906881840 15424048 4874800
18:42:52 46948 8192000000 10790431968 11262521344 1852935680 18.446 97 7 14 0 1861125616 6106000 2083936
18:43:45 28324 8192000000 10811810432 11287433216 1888637888 18.735 99 9 18 1 1897762512 6846032 2278592
18:44:19 50184 8192000000 10834798192 11304718336 1883602736 18.694 98 16 32 2 1895934768 7137440 5194592
18:45:17 48493 8192000000 10831142608 11296120832 1892549808 18.766 98 16 32 1 1905193600 7746352 4897440
18:46:22 71891 8192000000 10844360112 11316461568 1911158896 18.916 99 19 38 1 1925685920 8880736 5646288
18:47:40 70355 8192000000 10848536368 11326992384 1910245040 18.909 99 16 32 2 1925963648 10709504 5009104
18:48:57 49137 8192000000 10843086416 11317334016 1903865520 18.857 99 15 30 1 1920130368 11899632 4365216
18:49:52 40224 8192000000 10867101984 11327782912 1913088880 18.931 99 19 38 0 1927910864 9371152 5450832
18:50:47 54406 8192000000 10889095824 11360133120 1954082096 19.259 100 26 52 1 1975622352 13226832 8313424
18:51:52 45743 8192000000 10890144688 11367219200 1955152464 19.267 100 15 30 1 1974876512 14688128 5035920
18:52:50 60657 8192000000 10850904000 11319062528 1910712448 18.912 98 11 22 0 1927463296 13580464 3170384
18:54:06 48474 8192000000 10894324272 11345821696 1915470224 18.951 98 31 62 2 1935239488 11007296 8761968
18:55:01 30443 8192000000 10891453296 11360288768 1952252448 19.244 100 28 56 3 1972175088 12266256 7656384
18:55:40 69423 8192000000 10899371552 11371229184 1960587504 19.311 100 31 60 0 1981702704 12840736 8274464
18:56:56 67217 8192000000 10911742000 11375075328 1947529488 19.207 99 14 28 1 1964195760 12904080 3762192
18:58:09 50310 8192000000 10902695648 11370004480 1938857392 19.138 98 14 28 0 1955029680 12064608 4107680
18:59:06 38048 8192000000 10909437600 11381698560 1941584848 19.159 98 28 56 0 1963889792 14736416 7568528
18:59:58 60125 8192000000 10889745680 11356368896 1878155200 18.650 95 20 40 0 1893099520 9725312 5219008
19:01:06 134132 8192000000 10904859088 11380940800 1949187984 19.220 99 21 42 1 1968344352 12893712 6262656
19:03:34 30549 8192000000 10888799600 11382763520 1965181280 19.347 100 10 20 0 1986694864 18943344 2570240
19:04:17 36996 8192000000 10880052112 11353874432 1933966800 19.099 98 13 26 0 1948599200 11594608 3037792
19:05:02 50965 8192000000 10877123040 11353477120 1952347408 19.245 99 16 32 0 1969162880 12332944 4482528
19:05:59 47937 8192000000 10888354704 11370909696 1968111744 19.370 100 7 14 0 1981681456 11740624 1829088
19:06:53 83121 8192000000 10895193376 11378782208 1941164656 19.156 98 13 26 0 1952783856 7703056 3916144
19:08:32 95057 8192000000 10904658464 11385217024 1971529264 19.398 99 23 46 0 1990411920 12404784 6477872
19:10:27 76086 8192000000 10897854240 11385012224 1938577200 19.135 98 7 14 0 1954046416 13428384 2040832
19:12:19 55761 8192000000 10897084736 11376586752 1911525088 18.919 96 15 30 0 1928365840 12489584 4351168
19:13:21 80986 8192000000 10886351856 11377127424 1933977584 19.099 98 19 38 2 1954246320 14535744 5732992
19:14:56 33706 8192000000 10898739312 11369025536 1937462592 19.127 98 24 48 1 1955610224 11609696 6537936
19:15:58 42741 8192000000 10907133184 11367067648 1920406528 18.990 97 30 60 0 1945729136 16680192 8642416
19:16:50 43607 8192000000 10886655536 11351961600 1900352896 18.829 97 37 74 1 1925631120 14896560 10381664
19:17:45 44625 8192000000 10881162384 11344773120 1923896224 19.018 98 29 58 1 1944838080 13151104 7790752
19:18:36 54374 8192000000 10874061744 11344183296 1876830848 18.640 96 25 50 0 1896893136 13077616 6984672
19:19:36 35775 8192000000 10862874736 11333365760 1864097040 18.536 96 28 56 3 1887821648 15593152 8131456
19:20:23 89573 8192000000 10873237392 11370921984 1903544560 18.855 98 8 16 0 1935464720 29455360 2464800
19:21:58 95332 8192000000 10856378272 11325939712 1826345824 18.230 94 14 28 0 1841217728 11019760 3852144
19:23:40 47050 8192000000 10888155888 11346427904 1950314432 19.229 100 51 102 1 1973931328 9348128 14268768
19:24:38 104373 8192000000 10864328112 11331121152 1890095712 18.747 97 25 51 0 1905779136 7919664 7763760
19:26:29 41811 8192000000 9940772672 10322153472 1043357632 11.297 54 7 13 0 1052092176 6618544 2116000

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 25-11-2020 19:29:50 to 25-11-2020 19:30:22.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 134 v_add_invoice_to_stock 335544517
except 16 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 25-11-2020 19:30:23 to 25-11-2020 19:30:25.

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          243988
MON$OLDEST_ACTIVE               244269
MON$OLDEST_SNAPSHOT             244269
MON$NEXT_TRANSACTION            244269
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                       2044256
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.33393 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33393 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33393 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33393 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 ---
:227: 
:228: mscs-test-161.budzdorov.ru    Wed Nov 25 19:27:26 2020
:229:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:230: 
:231: 
:232: mscs-test-161.budzdorov.ru    Wed Nov 25 19:27:32 2020
:233:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:234: 
--- end of diff output ---

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

25.11.20 19:30:26. 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-25 19:30:28 No severe PSQL-related problems occured
25.11.20 19:30:29. End of report.