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

Server and database settinfs

SERVER_MODE                     SuperServer 3.0.8
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=120
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-11 19:27:20
DTS_END                         2021-03-11 19:27:20.9260
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/57422
TRN_ID                          238658
ATT_ID                          694
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: 9421.87 21516 1130624
customer order: creation 174.49 349 20939
customer order: refuse 14.56 327 1747
order to supplier: creation 45.70 1247 5484
order to supplier: removal 3.37 104418 404
invoice (draft): creation 45.60 3262 5472
invoice (draft): removal 54.13 719 6496
invoice accept: apply 41.56 18232 4987
invoice accept: cancel 48.43 739 5812
customer reserve: creation 3890.21 178 466825
customer reserve: removal 4806.93 57 576832
realization accept: apply 83.52 178 10022
realization accept: cancel 86.44 110 10373
payment from customer: creation 57.48 120 6898
payment from customer: removal 5.66 91 679
payment to supplier: creation 48.15 124 5778
payment to supplier: removal 3.20 87 384
service: total inventory turnovers 4.75 1071 570
service: total monetary turnovers 6.82 31 818
service: aggregate perf. data 0.83 20285 100
service: refresh index statistics 0.03 278691 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 11-03-2021 19:28:41 to 11-03-2021 19:28:43.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5330
TEST_TIME 2 6287
TEST_TIME 3 5990
TEST_TIME 4 5790
TEST_TIME 5 6431
TEST_TIME 6 5983
TEST_TIME 7 5990
TEST_TIME 8 5917
TEST_TIME 9 5980
TEST_TIME 10 5933
TEST_TIME 11 5950
TEST_TIME 12 6368
TEST_TIME 13 6507
TEST_TIME 14 6584
TEST_TIME 15 6934
TEST_TIME 16 7735
TEST_TIME 17 8081
TEST_TIME 18 8191
TEST_TIME 19 8482
TEST_TIME 20 8501
TEST_TIME 21 8559
TEST_TIME 22 9249
TEST_TIME 23 8998
TEST_TIME 24 8980
TEST_TIME 25 9545
TEST_TIME 26 9626
TEST_TIME 27 9971
TEST_TIME 28 10858
TEST_TIME 29 11237
TEST_TIME 30 11035
TEST_TIME 31 10916
TEST_TIME 32 10846
TEST_TIME 33 10819
TEST_TIME 34 10676
TEST_TIME 35 10600
TEST_TIME 36 10511
TEST_TIME 37 10354
TEST_TIME 38 10299
TEST_TIME 39 10201
TEST_TIME 40 10301
TEST_TIME 41 10205
TEST_TIME 42 10285
TEST_TIME 43 10268
TEST_TIME 44 10122
TEST_TIME 45 10021
TEST_TIME 46 10089
TEST_TIME 47 9921
TEST_TIME 48 9955
TEST_TIME 49 9959
TEST_TIME 50 9877
TEST_TIME 51 9965
TEST_TIME 52 10018
TEST_TIME 53 10041
TEST_TIME 54 9993
TEST_TIME 55 10026
TEST_TIME 56 10004
TEST_TIME 57 10066
TEST_TIME 58 10160
TEST_TIME 59 10228
TEST_TIME 60 10273
TEST_TIME 61 10299
TEST_TIME 62 10158
TEST_TIME 63 10145
TEST_TIME 64 10073
TEST_TIME 65 10040
TEST_TIME 66 10017
TEST_TIME 67 9923
TEST_TIME 68 9898
TEST_TIME 69 9822
TEST_TIME 70 9754
TEST_TIME 71 9810
TEST_TIME 72 9723
TEST_TIME 73 9758
TEST_TIME 74 9740
TEST_TIME 75 9760
TEST_TIME 76 9735
TEST_TIME 77 9769
TEST_TIME 78 9752
TEST_TIME 79 9763
TEST_TIME 80 9733
TEST_TIME 81 9742
TEST_TIME 82 9900
TEST_TIME 83 9903
TEST_TIME 84 9879
TEST_TIME 85 9905
TEST_TIME 86 9916
TEST_TIME 87 9811
TEST_TIME 88 9757
TEST_TIME 89 9731
TEST_TIME 90 9756
TEST_TIME 91 9691
TEST_TIME 92 9650
TEST_TIME 93 9635
TEST_TIME 94 9594
TEST_TIME 95 9609
TEST_TIME 96 9642
TEST_TIME 97 9690
TEST_TIME 98 9694
TEST_TIME 99 9652
TEST_TIME 100 9688
TEST_TIME 101 9739
TEST_TIME 102 9719
TEST_TIME 103 9798
TEST_TIME 104 9803
TEST_TIME 105 9792
TEST_TIME 106 9798
TEST_TIME 107 9787
TEST_TIME 108 9724
TEST_TIME 109 9696
TEST_TIME 110 9668
TEST_TIME 111 9674
TEST_TIME 112 9637
TEST_TIME 113 9617
TEST_TIME 114 9594
TEST_TIME 115 9535
TEST_TIME 116 9500
TEST_TIME 117 9485
TEST_TIME 118 9474
TEST_TIME 119 9478
TEST_TIME 120 9427

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 11-03-2021 19:28:45 to 11-03-2021 19:28:48.

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 1561545 1561545 0 0.00 0 23645 6 0 0
doc_list_biud 1561545 1561545 0 0.00 0 36170 27 0 0
sp_add_invoice_to_stock 5108 4987 121 2.36 38 144533 18232 0 121
sp_cancel_adding_invoice 5812 5812 0 0.00 4 70436 739 0 0
sp_cancel_client_order 1747 1747 0 0.00 4 11817 328 0 0
sp_cancel_customer_reserve 576832 576832 0 0.00 1 34499 58 0 0
sp_cancel_pay_from_customer 679 679 0 0.00 3 7254 91 0 0
sp_cancel_pay_to_supplier 384 384 0 0.00 3 4318 88 0 0
sp_cancel_supplier_invoice 6501 6496 5 0.07 1 18309 719 0 5
sp_cancel_supplier_order 404 404 0 0.00 5 1057618 104418 0 0
sp_cancel_write_off 10373 10373 0 0.00 1 13408 110 0 0
sp_client_order 20939 20939 0 0.00 4 30490 350 0 0
sp_customer_reserve 466825 466825 0 0.00 0 96174 178 0 0
sp_fill_shopping_cart 31892 31892 0 0.00 1 12114 35 0 0
sp_fill_shopping_cart_clo_res 466819 466819 0 0.00 0 14730 13 0 0
sp_get_clo_for_invoice 4979 4979 0 0.00 0 15095 271 0 0
sp_kill_cost_storno 17248 17248 0 0.00 0 23637 57 0 0
sp_kill_qstorno_ret_qs2qd 1170937 1170937 0 0.00 0 34495 31 0 0
sp_kill_qty_storno 616663 616663 0 0.00 0 36168 67 0 0
sp_lock_selected_doc 20659 20659 0 0.00 0 8449 5 0 0
sp_make_cost_storno 27675 27675 0 0.00 0 16509 54 0 0
sp_multiply_rows_for_pdistr 27675 27675 0 0.00 0 9144 29 0 0
sp_multiply_rows_for_qdistr 20939 20939 0 0.00 0 17374 158 0 0
sp_pay_from_customer 6898 6898 0 0.00 4 14500 121 0 0
sp_pay_to_supplier 5778 5778 0 0.00 5 14088 124 0 0
sp_payment_common 12676 12676 0 0.00 1 14461 33 0 0
sp_qd_handle_on_cancel_clo 1747 1747 0 0.00 0 11806 292 0 0
sp_qd_handle_on_invoice_upd_sts 10789 10789 0 0.00 0 36163 318 0 0
sp_qd_handle_on_reserve_upd_sts 10022 10022 0 0.00 0 12577 58 0 0
sp_reserve_write_off 10022 10022 0 0.00 6 16522 179 0 0
sp_supplier_invoice 5472 5472 0 0.00 5 97335 3262 0 0
sp_supplier_order 5484 5484 0 0.00 5 36927 1248 0 0
srv_aggregate_perf_data 100 100 0 0.00 2799 125681 20286 0 0
srv_fill_mon_cache_memory 166 166 0 0.00 952 159943 30660 0 0
srv_find_qd_qs_mism 1082237 1082237 0 0.00 0 6933 5 0 0
srv_make_invnt_saldo 570 570 0 0.00 40 116702 1071 0 0
srv_make_money_saldo 818 818 0 0.00 1 4136 32 0 0
srv_recalc_idx_stat 4 4 0 0.00 189797 342907 278691 0 0
t$perf-abend:sp_add_invoice_to_stock 121 121 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 4987 4987 0 0.00 0 10410 201 0 0
t$perf-norm:sp_cancel_adding_invoice 399 399 0 0.00 1 14058 143 0 0
t$perf-norm:sp_cancel_client_order 1747 1747 0 0.00 0 6454 22 0 0
t$perf-norm:sp_cancel_customer_reserve 646 646 0 0.00 0 3170 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 679 679 0 0.00 0 1935 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 384 384 0 0.00 0 3002 14 0 0
t$perf-norm:sp_cancel_supplier_invoice 391 391 0 0.00 0 1039 9 0 0
t$perf-norm:sp_cancel_supplier_order 404 404 0 0.00 0 18392 1701 0 0
t$perf-norm:sp_cancel_write_off 1011 1011 0 0.00 0 7449 15 0 0
t$perf-norm:sp_client_order 20939 20939 0 0.00 0 12836 23 0 0
t$perf-norm:sp_customer_reserve 1069 1069 0 0.00 0 1496 6 0 0
t$perf-norm:sp_pay_from_customer 6898 6898 0 0.00 0 9334 18 0 0
t$perf-norm:sp_pay_to_supplier 5778 5778 0 0.00 0 8360 20 0 0
t$perf-norm:sp_reserve_write_off 10022 10022 0 0.00 0 6683 11 0 0
t$perf-norm:sp_supplier_invoice 5472 5472 0 0.00 0 6740 22 0 0
t$perf-norm:sp_supplier_order 5484 5484 0 0.00 0 7533 20 0 0
t$perf-norm:srv_aggregate_perf_data 100 100 0 0.00 0 792 14 0 0
t$perf-norm:srv_fill_mon_cache_memory 166 166 0 0.00 0 248 2 0 0
t$perf-norm:srv_make_invnt_saldo 570 570 0 0.00 0 1559 26 0 0
t$perf-norm:srv_make_money_saldo 818 818 0 0.00 0 5644 24 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 10194 9952 242 2.37 0 6937 23 0 242
v_all_customers 38178 38178 0 0.00 0 15 1 0 0
v_all_suppliers 30268 30268 0 0.00 0 25 1 0 0
v_all_wares 41878 41878 0 0.00 0 14 1 0 0
v_cancel_adding_invoice 798 798 0 0.00 0 3676 12 0 0
v_cancel_client_order 3494 3494 0 0.00 0 5713 7 0 0
v_cancel_customer_prepayment 1358 1358 0 0.00 0 6372 11 0 0
v_cancel_customer_reserve 1292 1292 0 0.00 0 4545 9 0 0
v_cancel_payment_to_supplier 768 768 0 0.00 0 4196 12 0 0
v_cancel_supplier_invoice 792 782 10 1.26 0 7566 38 0 10
v_cancel_supplier_order 808 808 0 0.00 0 2989 8 0 0
v_cancel_write_off 2022 2022 0 0.00 0 10759 31 0 0
v_max_id_clo_ord 5484 5484 0 0.00 0 7692 3 0 0
v_max_id_clo_res 1069 1069 0 0.00 0 2765 14 0 0
v_max_id_ord_sup 5469 5469 0 0.00 0 2225 2 0 0
v_max_non_paid_invoice 1597 1597 0 0.00 0 1590 4 0 0
v_max_non_paid_realizn 3562 3562 0 0.00 0 7771 7 0 0
v_min_id_clo_ord 5484 5484 0 0.00 0 6113 11 0 0
v_min_id_clo_res 1069 1069 0 0.00 0 4581 12 0 0
v_min_id_ord_sup 5469 5469 0 0.00 0 6440 7 0 0
v_min_non_paid_invoice 5778 5778 0 0.00 0 7225 18 0 0
v_min_non_paid_realizn 6898 6898 0 0.00 0 8491 24 0 0
v_our_firm 10372 10372 0 0.00 0 19 1 0 0
v_reserve_write_off 20044 20044 0 0.00 0 8022 8 0 0
x_lock_depdocs_on_canc_invoice 11917 11917 0 0.00 0 22283 111 0 0
x_lock_depdocs_on_canc_sup_ord 404 404 0 0.00 0 15409 386 0 0
x_make_qstorno_1000_1200 5484 5484 0 0.00 1 36904 1164 0 0
x_make_qstorno_1200_2000 5472 5472 0 0.00 2 97291 3145 0 0
x_make_qstorno_2100_3300 466825 466825 0 0.00 0 96173 162 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 11-03-2021 19:28:49 to 11-03-2021 19:28:53.

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:24 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:30 13559 8192000000 10202440176 10503430144 878379376 9.684 70 59 118 0 900938160 2620480 19938304
16:57:55 31173 8192000000 10323808656 10637692928 1367823808 14.308 100 89 178 0 1402911792 5015344 30072640
16:58:41 19473 8192000000 10352817008 10671525888 1403789024 14.629 100 87 174 0 1438563424 6541664 28232736
16:59:11 18825 8192000000 10394450784 10714968064 1438473888 14.936 100 88 175 1 1474332160 7155248 28703024
16:59:39 32366 8192000000 10422846208 10749054976 1464905712 15.169 100 88 177 0 1501342320 7923232 28513376
17:00:22 12873 8192000000 10431904160 10760302592 1487087104 15.363 100 89 178 1 1524716400 8626272 29003024
17:00:51 10430 8192000000 10448276336 10781593600 1508531904 15.551 100 88 176 0 1545424528 9072016 27820608
17:01:12 16866 8192000000 10469171696 10806730752 1520018304 15.650 100 87 175 0 1557316976 9565488 27733184
17:01:38 7775 8192000000 10472221280 10812153856 1536108048 15.790 100 85 170 0 1573038176 10397568 26532560
17:02:03 21354 8192000000 10520389328 10871492608 1573056624 16.109 100 79 158 2 1607926544 10898880 23971040
17:02:38 9178 8192000000 10546724352 10902286336 1606172624 16.392 100 81 162 0 1641495712 11271440 24051648
17:02:54 11713 8192000000 10578687392 10936930304 1633133552 16.621 100 77 154 1 1667576272 11251456 23191264
17:03:16 12076 8192000000 10589810240 10955419648 1652277056 16.784 100 78 155 1 1686367744 11599760 22490928
17:03:35 10882 8192000000 10614047232 10977701888 1670450720 16.937 100 78 156 0 1705555360 12250528 22854112
17:03:54 8966 8192000000 10631015472 10999250944 1687404672 17.080 100 82 165 0 1725218944 13085728 24728544
17:04:10 9857 8192000000 10637856448 11009277952 1700674400 17.191 100 80 160 1 1737153120 13364032 23114688
17:04:27 7367 8192000000 10667830752 11037872128 1721421344 17.364 100 79 154 1 1756045776 12732576 21891856
17:04:43 8130 8192000000 10668842096 11045740544 1734545216 17.473 100 78 154 2 1769758960 13163808 22049936
17:04:59 5778 8192000000 10683960656 11061264384 1745960368 17.568 100 79 158 2 1781554960 12248704 23345888
17:05:13 4661 8192000000 10698096688 11074596864 1759113104 17.677 100 84 167 1 1795820864 13385728 23322032
17:05:25 5720 8192000000 10710682144 11086131200 1769259056 17.761 100 86 173 1 1806456896 13561056 23636784
17:05:37 3974 8192000000 10715543296 11093200896 1773354864 17.795 100 83 164 2 1810866368 14519376 22992128
17:05:48 4001 8192000000 10712125488 11096137728 1782229776 17.868 100 79 156 0 1818113008 12925504 22957728
17:06:00 2857 8192000000 10730711968 11110141952 1793276944 17.959 100 91 179 0 1831392256 13062544 25052768
17:06:09 3666 8192000000 10737786912 11119751168 1794521744 17.969 100 81 157 1 1830007760 12731200 22754816
17:06:19 2475 8192000000 10738112288 11117395968 1802028368 18.031 100 80 155 1 1835410640 12753424 20628848
17:06:28 10579 8192000000 10731558880 11123625984 1805889328 18.062 100 74 149 3 1839455936 13709120 19857488
17:06:45 3348 8192000000 10762071232 11148468224 1811896640 18.111 100 87 174 1 1850313440 13854016 24562784
17:06:55 2141 8192000000 10774390304 11159371776 1829724576 18.257 100 90 180 2 1868582560 12906416 25951568
17:07:04 4099 8192000000 10782831680 11167105024 1837752272 18.323 100 84 169 1 1873240528 12351520 23136736
17:07:14 2022 8192000000 10787848736 11169927168 1845326512 18.384 100 89 178 1 1881579744 11407184 24846048
17:07:22 1745 8192000000 10787473424 11179343872 1849357984 18.417 100 89 174 2 1887282896 12521712 25403200
17:07:31 1894 8192000000 10805543120 11188871168 1852899968 18.446 100 91 182 0 1891592240 12762688 25929584
17:07:39 1372 8192000000 10799384112 11188690944 1858427152 18.491 100 93 185 2 1896384880 13050720 24907008
17:07:47 2063 8192000000 10803322656 11192127488 1862205248 18.521 100 84 168 1 1899467712 14214272 23048192
17:07:55 1597 8192000000 10796720768 11189248000 1860254048 18.505 100 91 182 1 1900551120 14367264 25929808
17:08:03 22834 8192000000 10809608512 11198152704 1859418032 18.499 100 76 151 1 1893741360 13060080 21263248
17:08:32 3819 8192000000 10788936064 11191177216 1858572064 18.492 100 49 99 0 1883822160 11170784 14079312
17:08:42 4078 8192000000 10779185120 11196514304 1861559008 18.516 100 41 82 1 1883130848 10378160 11193680
17:08:56 5391 8192000000 10780102736 11197706240 1867437088 18.564 100 44 88 0 1886571168 6393520 12740560
17:09:09 8136 8192000000 10775296144 11198025728 1867612704 18.565 100 22 43 2 1883936432 10233856 6089872
17:09:26 10173 8192000000 10774318944 11202420736 1871575488 18.597 100 32 64 1 1888321056 8140736 8604832
17:09:44 7913 8192000000 10783696960 11207999488 1876363088 18.636 100 27 54 3 1889452784 5630416 7459280
17:09:58 7544 8192000000 10776977520 11206193152 1876046256 18.633 100 31 62 0 1891777360 6913776 8817328
17:10:15 6406 8192000000 10777173152 11207335936 1873762560 18.615 100 17 34 1 1884382112 5740896 4878656
17:10:31 10516 8192000000 10788302464 11214327808 1879101264 18.658 100 22 44 2 1892577184 7385200 6090720
17:10:48 9516 8192000000 10781178240 11215110144 1883277632 18.692 100 26 52 3 1896843648 5889936 7676080
17:11:05 10343 8192000000 10783785392 11215519744 1882345264 18.684 100 21 43 1 1894576784 5634176 6597344
17:11:23 83468 8192000000 10799823296 11230429184 1888060512 18.730 100 41 82 1 1906292080 5444960 12786608
17:12:55 8885 8192000000 10803512752 11239747584 1891876128 18.761 100 19 39 0 1902980400 5920224 5184048
17:13:12 7494 8192000000 10818026832 11246841856 1900857264 18.833 100 38 76 0 1923083536 11389136 10837136
17:13:27 4596 8192000000 10830490336 11251634176 1901030016 18.835 100 39 78 1 1923089744 11112112 10947616
17:13:39 5876 8192000000 10813734640 11247566848 1899148688 18.819 100 21 42 2 1911231568 6426880 5656000
17:13:51 15991 8192000000 10816419456 11249811456 1902480624 18.846 100 23 46 1 1915197104 5309856 7406624
17:14:13 5634 8192000000 10816174112 11254353920 1903209040 18.852 100 21 42 0 1914768416 5583536 5975840
17:14:25 12478 8192000000 10821183184 11258183680 1907920208 18.890 100 23 46 1 1921180992 6612672 6648112
17:14:44 10298 8192000000 10816539568 11256053760 1907030160 18.883 100 19 38 0 1918387840 6186688 5170992
17:15:03 12833 8192000000 10818410320 11258990592 1909820432 18.905 100 15 30 1 1919794288 6177520 3796336
17:15:24 11190 8192000000 10823168624 11257368576 1908595872 18.895 100 20 40 0 1920163232 6158464 5408896
17:15:45 12072 8192000000 10806222864 11245072384 1869553168 18.581 98 14 28 0 1879054256 5486112 4014976
17:16:05 6319 8192000000 10814504224 11241017344 1864734640 18.542 98 12 24 3 1873476784 4898576 3843568
17:16:18 69003 8192000000 10800780032 11223601152 1822636720 18.199 96 25 48 2 1835772480 5347744 7788016
17:17:35 10798 8192000000 10781981824 11217846272 1861168800 18.513 99 12 24 1 1870023632 5312640 3542192
17:17:51 6348 8192000000 10786458128 11214032896 1863316464 18.530 99 19 38 1 1874645392 6281072 5047856
17:18:06 6388 8192000000 10757452080 11181027328 1792534160 17.953 96 18 36 2 1803064320 5359552 5170608
17:18:22 8776 8192000000 10774368304 11195502592 1834409376 18.295 99 33 66 2 1851176640 7511792 9255472
17:18:39 3821 8192000000 10726681968 11143499776 1803569984 18.043 98 33 66 0 1819535376 6470416 9494976
17:18:52 12020 8192000000 10724829088 11146596352 1750071616 17.602 95 24 48 1 1763353248 5712992 7568640
17:19:10 15066 8192000000 10680068400 11097550848 1655655744 16.812 91 18 35 0 1666263504 5177728 5430032
17:19:34 7837 8192000000 10721877520 11134214144 1769125424 17.760 98 21 40 5 1780318672 5583392 5609856
17:19:49 9877 8192000000 10723503920 11147706368 1793727152 17.962 99 20 40 2 1805319600 6004224 5588224
17:20:08 18120 8192000000 10686269024 11094249472 1618942416 16.501 89 26 52 1 1631626416 4827488 7856512
17:20:35 15379 8192000000 10683263552 11105222656 1749555792 17.598 98 16 32 1 1759689264 5704992 4428480
17:20:56 8771 8192000000 10697039520 11113541632 1766141360 17.735 98 19 38 5 1777766336 5743200 5881776
17:21:11 14282 8192000000 10716000224 11133177856 1766014784 17.734 98 22 45 1 1778201648 4892960 7293904
17:21:32 70433 8192000000 10714023904 11142033408 1757924368 17.667 97 17 33 2 1767731680 4675696 5131616
17:22:49 10262 8192000000 10734530320 11152027648 1782742272 17.872 98 14 29 2 1792230336 5308048 4180016
17:23:05 6781 8192000000 10707932960 11124514816 1780046416 17.850 98 23 46 4 1791046592 4331440 6668736
17:23:19 8204 8192000000 10720307504 11150766080 1814843840 18.136 100 19 38 0 1825468144 5534080 5090224
17:23:33 5794 8192000000 10752676624 11169443840 1829845728 18.258 100 37 74 1 1846709424 6337344 10526352
17:23:46 5677 8192000000 10739361696 11167105024 1829653456 18.257 100 22 44 2 1842054864 6379552 6021856
17:23:58 6290 8192000000 10760135520 11178778624 1834748432 18.298 100 31 62 2 1850775184 7361312 8665440
17:24:10 5337 8192000000 10751541824 11179233280 1842278304 18.359 100 32 64 0 1857711744 6291984 9141456
17:24:24 9851 8192000000 10761075440 11185983488 1843712480 18.371 100 21 42 3 1855144336 5508704 5923152
17:24:44 6570 8192000000 10777028224 11195072512 1850576816 18.427 100 29 59 2 1864015648 4573136 8865696
17:24:58 12486 8192000000 10779196528 11199881216 1855313360 18.465 100 30 60 1 1869156848 4814944 9028544
17:25:16 11856 8192000000 10783497904 11208425472 1858508224 18.491 100 23 46 1 1875212944 9925072 6779648
17:25:34 20363 8192000000 10774103696 11202699264 1861465456 18.515 100 20 40 2 1873397152 6350096 5581600
17:26:04 54498 8192000000 10797881824 11217944576 1867455808 18.564 100 28 56 0 1880500176 4755744 8288624
17:27:06 17511 8192000000 10794906544 11226615808 1876781920 18.639 100 30 60 2 1890858656 5772480 8304256
17:27:34 4529 8192000000 10812206272 11237142528 1893774832 18.776 100 34 66 2 1912953376 9345136 9833408
17:27:47 38514 8192000000 10833745024 11257372672 1907384688 18.886 100 53 104 1 1928889136 6836368 14668080
17:28:35 36967 8192000000 10844248496 11271643136 1917882576 18.970 100 40 80 1 1937784800 8799712 11102512
17:29:22 15536 8192000000 10853191824 11280728064 1923841648 19.018 100 46 92 0 1947331344 10598112 12891584
17:29:46 14575 8192000000 10853329712 11281162240 1927101408 19.044 100 45 90 1 1948933632 8502112 13330112
17:30:08 3987 8192000000 10863543216 11287805952 1931822864 19.081 100 49 97 3 1954649520 8604912 14221744
17:30:21 12498 8192000000 10879936336 11300552704 1936552176 19.119 100 55 109 0 1962665216 10353008 15760032
17:30:41 30666 8192000000 10865067984 11302248448 1940415792 19.150 100 44 88 1 1965208224 11266720 13525712
17:31:23 4356 8192000000 10877470384 11307286528 1944743776 19.185 100 51 103 0 1971220208 11112832 15363600
17:31:35 26710 8192000000 10897284032 11326738432 1954095952 19.259 100 49 98 1 1984826960 16338176 14392832
17:32:10 7523 8192000000 10901928048 11326193664 1960124896 19.307 100 53 106 1 1992420016 16545904 15749216
17:32:28 14057 8192000000 10907799888 11338854400 1965780944 19.352 100 49 97 0 1996024496 16503248 13740304
17:32:50 7804 8192000000 10917781824 11345276928 1972355184 19.404 100 54 105 3 2004776608 16904112 15517312
17:33:07 9699 8192000000 10914141408 11346403328 1973920704 19.417 100 49 98 1 2006572592 17746288 14905600
17:33:25 25800 8192000000 10928943552 11354779648 1979763312 19.463 100 52 102 1 2015021392 18746464 16511616
17:34:05 13304 8192000000 10941969728 11368120320 1983548944 19.493 100 50 100 2 2022040928 24041104 14450880
17:34:24 10093 8192000000 10942720016 11369525248 1995653600 19.588 100 61 122 2 2034537520 20473648 18410272
17:34:48 1867 8192000000 10958919872 11378593792 2006659216 19.675 100 86 169 2 2053398736 21795312 24944208
17:34:57 5179 8192000000 10966403696 11383779328 2004357712 19.657 100 63 126 0 2045734560 22741504 18635344
17:35:12 5800 8192000000 10958516112 11380015104 1999477456 19.619 100 69 138 1 2044039520 23533488 21028576
17:35:31 3687 8192000000 10945414432 11374641152 1996146496 19.592 100 60 120 0 2037961168 23637520 18177152
17:35:46 11187 8192000000 10946047520 11373490176 1989973904 19.544 100 59 118 1 2031188288 23684224 17530160
17:36:10 10958 8192000000 10949723344 11374006272 1989634432 19.541 100 66 131 1 2034637536 25256992 19746112
17:36:32 8007 8192000000 10942850656 11371827200 1991232304 19.554 100 60 119 4 2031838976 23418192 17188480
17:37:08 15172 8192000000 10938255280 11375460352 1992416624 19.563 100 49 98 0 2030964000 24034576 14512800
17:37:36 11404 8192000000 10938697744 11375136768 1991130256 19.553 100 48 94 2 2029048960 23360704 14558000
17:37:57 6717 8192000000 10934280080 11373940736 1985672112 19.510 100 39 78 2 2021377888 23663504 12042272
17:38:11 9089 8192000000 10940943104 11375824896 1991594320 19.556 100 43 86 1 2028614544 23911488 13108736
17:38:33 9696 8192000000 10940952128 11375046656 1985791584 19.511 100 51 102 0 2027909072 26182128 15935360
17:38:50 3931 8192000000 10966790368 11389104128 1999934032 19.622 100 76 152 0 2050028576 27090624 23003920
17:39:05 3047 8192000000 10967584336 11396018176 1999743424 19.621 100 61 117 1 2045568064 27871904 17952736
17:39:16 4797 8192000000 10955978672 11379195904 1984686112 19.502 99 60 117 0 2031786544 28937120 18163312
17:39:30 7604 8192000000 10956259904 11384406016 1995707440 19.589 100 65 130 1 2045571040 29848272 20015328
17:39:45 2897 8192000000 10971778496 11389538304 2001793296 19.637 100 91 178 1 2055411920 26354768 27263856
17:39:56 2210 8192000000 10962474144 11381714944 1997501376 19.603 100 82 164 0 2048961392 26796192 24663824
17:40:06 3377 8192000000 10950310800 11363430400 1981225200 19.474 99 80 158 1 2032000336 27004640 23770496
17:40:17 4209 8192000000 10957443024 11377012736 1975302976 19.427 99 77 152 2 2026270480 27653360 23314144
17:40:30 5885 8192000000 10956582480 11380191232 1987646176 19.525 100 72 138 2 2039587504 30478784 21462544
17:40:43 1100 8192000000 10983926720 11396014080 2003324512 19.649 100 90 185 2 2061073616 30625680 27123424
17:40:51 2647 8192000000 10975293408 11398230016 2003184928 19.648 100 77 154 0 2059195904 32408240 23602736
17:41:01 2655 8192000000 10988320256 11402403840 2006239872 19.672 100 94 184 0 2067661360 33351088 28070400
17:41:14 10649 8192000000 10968286352 11395436544 1996275376 19.593 100 78 156 1 2056214576 35107152 24832048
17:41:37 1850 8192000000 10963839616 11382222848 1976785504 19.439 99 69 138 1 2035608384 37730560 21092320
17:41:48 4061 8192000000 10962456240 11388059648 1985422960 19.508 100 66 130 1 2045451024 39276624 20751440
17:41:59 3786 8192000000 10958733520 11372851200 1961263232 19.316 99 78 155 2 2026039280 40677552 24098496
17:42:09 13699 8192000000 10954222320 11379204096 1977728784 19.447 100 72 144 2 2040322160 40093744 22499632
17:42:30 2367 8192000000 10955416048 11378622464 1976489440 19.437 100 71 142 1 2040625248 40708832 23426976
17:42:41 3273 8192000000 10949364304 11374362624 1972485888 19.405 100 72 144 2 2035259936 40385808 22388240
17:42:52 2126 8192000000 10922236736 11330727936 1932733072 19.089 98 88 174 2 2001251680 41453472 27065136
17:43:01 1311 8192000000 10938880640 11349876736 1951711568 19.240 99 88 177 2 2019120000 40874208 26534224
17:43:09 951 8192000000 10920914640 11325591552 1928535984 19.055 98 88 178 2 1997748256 42118704 27093568
17:43:17 2742 8192000000 10958238032 11369664512 1963049616 19.330 100 92 184 3 2036080416 44203760 28827040
17:43:27 1603 8192000000 10947244928 11360735232 1943040096 19.171 99 90 180 1 2015454608 44094912 28319600
17:43:38 4442 8192000000 10927324560 11339304960 1939996016 19.147 99 84 169 2 2011527312 44400096 27131200
17:44:01 2660 8192000000 10903281104 11316215808 1894036688 18.778 98 69 138 0 1959106496 43438032 21631776
17:44:10 6003 8192000000 10917487136 11335835648 1938268480 19.133 100 73 146 1 2001819440 41190192 22360768
17:44:26 2556 8192000000 10907706432 11317116928 1919275536 18.981 100 87 174 0 1986646944 40828224 26543184
17:44:36 5522 8192000000 10912996480 11325898752 1928886032 19.058 100 82 164 0 1999424832 44620144 25918656
17:44:55 4144 8192000000 10903599840 11325026304 1911154992 18.916 99 65 129 1 1974567744 43246480 20166272
17:45:17 6576 8192000000 10907983712 11337379840 1931846080 19.082 100 64 126 0 1991501168 40921824 18733264
17:45:32 7573 8192000000 10909857168 11337383936 1926840992 19.042 99 62 121 0 1987014000 41131024 19041984
17:45:46 2649 8192000000 10928115504 11354460160 1927444656 19.046 99 52 103 1 1987444976 43729328 16270992
17:45:58 2691 8192000000 10928458736 11348369408 1932728480 19.089 99 65 128 1 2000937568 46750416 21458672
17:46:08 2612 8192000000 10940826512 11352727552 1952220976 19.244 100 84 164 2 2025955968 48480336 25254656
17:46:17 2061 8192000000 10960207744 11369676800 1964151296 19.339 100 84 162 1 2037739600 47941776 25646528
17:46:27 6032 8192000000 10948279840 11364577280 1955746208 19.272 100 70 139 3 2028368320 50400528 22221584
17:46:41 3514 8192000000 10967013360 11382214656 1966980352 19.361 100 82 163 3 2049575072 57600128 24994592
17:46:51 2029 8192000000 10971489760 11378319360 1969063344 19.378 100 96 192 2 2047717776 48553600 30100832
17:47:00 11196 8192000000 10915293200 11350896640 1943785568 19.177 100 56 111 2 2010171248 48380976 18004704
17:47:29 9198 8192000000 10923608800 11351388160 1941563680 19.159 100 38 76 2 2001755616 46804752 13387184
17:47:45 3765 8192000000 10915081520 11334303744 1919215504 18.981 99 44 86 2 1982195280 47959440 15020336
17:47:56 4086 8192000000 10934577136 11358941184 1944753728 19.185 100 59 118 0 2015553936 51888768 18911440
17:48:08 5586 8192000000 10930530496 11361710080 1944955696 19.186 100 69 136 2 2019122720 53071872 21095152
17:48:24 12294 8192000000 10941037664 11368493056 1950062672 19.227 100 53 105 1 2024788976 57219744 17506560
17:48:44 6630 8192000000 10947014048 11376844800 1952710640 19.248 100 50 99 0 2028808384 59560016 16537728
17:48:57 5365 8192000000 10955963440 11388948480 1964244720 19.340 100 64 128 0 2045541920 59786576 21510624
17:49:11 1589 8192000000 10970492624 11392745472 1970145728 19.387 100 67 135 1 2049714192 57862272 21706192
17:49:22 17063 8192000000 10940305888 11378761728 1965633056 19.351 100 37 74 1 2026477104 48534448 12309600
17:49:47 24661 8192000000 10938540464 11382923264 1960884928 19.313 100 33 66 4 2017827632 46011680 10931024
17:50:18 17201 8192000000 10929211568 11373580288 1947587968 19.207 99 31 62 3 2001478176 43266176 10624032
17:50:45 10690 8192000000 10935666688 11376287744 1962827744 19.329 100 40 80 0 2021879648 45736656 13315248
17:51:06 15501 8192000000 10936875488 11377745920 1958554256 19.295 100 36 73 2 2020524496 49653488 12316752
17:51:28 10925 8192000000 10941189328 11391815680 1964164640 19.339 100 30 60 3 2030613808 55512720 10936448
17:51:45 10413 8192000000 10945701600 11392331776 1961184880 19.315 100 30 60 1 2028791696 56767440 10839376
17:52:33 26113 8192000000 10913517584 11374030848 1923401216 19.014 98 21 42 0 1974715936 44457840 6856880
17:53:18 23711 8192000000 10920724592 11366543360 1935166320 19.108 100 20 40 1 1996521984 53849440 7506224
17:53:48 38717 8192000000 10914896528 11361341440 1914361136 18.942 99 19 38 1 1978148592 56728176 7059280
17:54:45 17276 8192000000 10908772256 11372130304 1928683328 19.056 100 17 34 3 1994213952 58926576 6604048
17:55:50 37926 8192000000 10865682608 11340075008 1897834800 18.809 98 10 20 2 1923222896 22113488 3274608
17:56:34 42666 8192000000 10868848352 11327676416 1924282656 19.021 99 22 41 1 1937123616 7201472 5639488
17:57:23 30150 8192000000 10880018352 11325218816 1919820432 18.985 98 52 103 1 1942085440 6314448 15950560
17:58:07 59459 8192000000 10908286848 11351773184 1962945680 19.329 100 41 82 0 1984875568 10786960 11142928
17:59:21 70786 8192000000 10893901312 11353313280 1942828288 19.169 99 17 34 1 1958699232 11151952 4718992
18:01:12 142140 8192000000 10864348992 11326935040 1854417200 18.458 94 21 39 1 1872750864 13189536 5144128
18:03:46 59507 8192000000 10892030000 11347660800 1960172720 19.307 100 31 61 2 1979684336 10435024 9076592
18:04:52 19283 8192000000 10902839232 11356983296 1973848192 19.416 100 38 76 2 1996997136 11828048 11320896
18:05:18 45872 8192000000 10889041712 11345764352 1929746288 19.065 98 19 37 1 1946415216 11009840 5659088
18:06:13 34653 8192000000 10899539392 11346485248 1949910784 19.226 99 16 32 1 1970553584 15889040 4753760
18:07:12 48424 8192000000 10903969072 11385880576 1978701216 19.454 100 23 46 1 2006643456 21096272 6845968
18:09:09 106923 8192000000 10900135040 11369762816 1973285376 19.412 100 11 22 0 1987836432 11118880 3432176
18:11:04 39077 8192000000 10913408208 11381121024 1987941520 19.528 100 12 24 1 2005266912 13616816 3708576
18:11:50 64773 8192000000 10921175360 11387727872 1991278048 19.554 100 13 26 0 2007590272 12200608 4111616
18:13:01 70454 8192000000 10898243056 11381710848 1981537472 19.477 100 16 30 1 2001945248 16317216 4090560
18:16:05 54542 8192000000 10899048400 11377147904 1961585280 19.319 99 9 18 0 1971488960 7913280 1990400
18:17:06 32245 8192000000 10943761584 11394166784 1992544752 19.564 100 41 80 0 2012545328 8608032 11392544
18:17:47 53438 8192000000 10896939184 11383173120 1968604544 19.374 99 28 56 2 1991350608 14878752 7867312
18:18:47 74112 8192000000 10917903248 11391987712 1987587072 19.525 100 17 33 1 2002521920 9995200 4939648
18:20:08 44859 8192000000 10905054944 11373559808 1933326704 19.093 97 21 42 1 1947946368 8810480 5809184
18:21:02 21071 8192000000 10907055376 11361509376 1946879872 19.202 98 37 74 2 1965145168 8247872 10017424
18:21:35 12589 8192000000 10918580544 11372318720 1979645248 19.462 100 35 70 1 2000424336 11276592 9502496
18:21:56 18362 8192000000 10913517632 11375505408 1981116672 19.474 100 34 68 1 2002699504 12234992 9347840
18:22:26 86453 8192000000 10910020800 11389693952 1947249328 19.205 98 13 26 1 1968102240 17183744 3669168
18:24:57 61548 8192000000 10904161264 11381915648 1958518816 19.294 99 20 40 1 1983867840 19202336 6146688
18:26:09 45375 8192000000 10899300672 11366547456 1926496640 19.039 97 13 26 1 1941795552 11524768 3774144
18:27:05 47582 8192000000 10906736304 11380637696 1974426576 19.421 100 25 50 1 1991299040 10465168 6407296
18:27:59 81034 8192000000 10914726832 11376136192 1932191056 19.084 97 22 44 1 1952958608 14760288 6007264
18:30:02 77426 8192000000 10881290992 11345133568 1898966848 18.818 96 24 46 2 1916292400 10506672 6818880
18:32:35 42034 8192000000 10844558784 11303432192 1870986656 18.592 96 16 32 0 1883502304 8141488 4374160
18:33:29 62321 8192000000 10841573680 11320225792 1912667296 18.928 99 5 10 0 1924555552 10351488 1536768
18:34:38 6102 8192000000 10846482448 11324616704 1929367936 19.062 100 3 6 0 1939935488 9816000 751552
18:34:50 9097 8192000000 10849559408 11313205248 1912931568 18.930 99 6 12 0 1923966656 9654096 1380992
18:35:13 64748 8192000000 10861621072 11329974272 1909940512 18.906 98 14 28 0 1920661776 7161760 3559504
18:36:24 48155 8192000000 10838148560 11289419776 1858485216 18.491 96 23 46 1 1873405072 8479952 6439904
18:37:18 100245 8192000000 10835700064 11310956544 1867703872 18.566 97 32 65 1 1889650064 11731840 10214352
18:39:15 20151 8192000000 10847320736 11314204672 1922036224 19.003 100 18 36 1 1940783104 13813968 4932912
18:39:42 27583 8192000000 10840546944 11307356160 1889808944 18.744 98 20 40 2 1907046560 11438976 5798640
18:40:17 54077 8192000000 10827001568 11302375424 1838752608 18.331 96 12 24 1 1855767440 13579152 3435680
18:41:17 63355 8192000000 10812857680 11272683520 1833586240 18.289 96 10 20 0 1847450816 11553120 2311456
18:42:27 59245 8192000000 10858680304 11313577984 1901217120 18.836 99 26 52 0 1917445200 9153952 7074128
18:43:32 51647 8192000000 10860463904 11318763520 1891519216 18.758 98 35 70 1 1912806864 11185248 10102400
18:44:30 48074 8192000000 10830792848 11298025472 1864347632 18.539 97 24 48 1 1880711712 9664272 6699808
18:45:32 28604 8192000000 10871227824 11328253952 1930728592 19.073 100 36 71 4 1950357152 9642704 9985856
18:46:07 52955 8192000000 10867797376 11310694400 1839564016 18.337 95 37 74 1 1861067584 11210832 10292736
18:47:07 15349 8192000000 10886310768 11328004096 1935579504 19.111 100 55 110 1 1962177264 11460576 15137184
18:47:35 54339 8192000000 10878795440 11340062720 1921657712 19.000 99 29 58 2 1943948832 13776352 8514768
18:48:36 79674 8192000000 10874273600 11356614656 1919525440 18.983 99 19 37 3 1947280832 21861552 5893840
18:50:14 71254 8192000000 10880001664 11331223552 1896397936 18.797 98 19 38 1 1913445184 12113744 4933504
18:51:34 33067 8192000000 10859966608 11321925632 1899655120 18.824 98 28 56 3 1917815360 10333392 7826848
18:52:28 159943 8192000000 10866798688 11307515904 1890914752 18.753 97 15 30 1 1908065088 12927424 4222912
18:55:14 33053 8192000000 10881979424 11331940352 1924459136 19.023 99 30 59 0 1940017872 6795120 8763616
18:55:55 40244 8192000000 10905361040 11359526912 1960898752 19.313 100 46 92 1 1986652816 12558080 13195984
18:56:48 37874 8192000000 10877323216 11359666176 1958330240 19.293 100 25 50 2 1977651536 12480784 6840512
18:57:41 42468 8192000000 10879492640 11367907328 1959549392 19.302 100 14 28 0 1970981856 7963936 3468528
18:58:30 50465 8192000000 10885104368 11368796160 1970266016 19.388 100 5 10 0 1977542464 6224320 1052128
19:00:28 44589 8192000000 10904209472 11371782144 1957456080 19.286 99 9 18 0 1968452720 8888304 2108336
19:01:19 38225 8192000000 10920915728 11391045632 1972107056 19.402 99 20 38 0 1985943888 8921472 4915360
19:02:05 68339 8192000000 10912873024 11384242176 1971911200 19.401 99 17 34 1 1989097488 12608288 4578000
19:03:19 53056 8192000000 10909941504 11393220608 1967094320 19.362 99 20 38 0 1988449952 15687280 5668352
19:04:19 85950 8192000000 10907862224 11390791680 1966796720 19.360 99 17 34 0 1985473136 14139024 4537392
19:05:51 41463 8192000000 10915264832 11369734144 1926866240 19.042 97 29 58 0 1951693632 16695328 8132064
19:06:45 48744 8192000000 10898434240 11372773376 1941929360 19.162 98 38 77 2 1967644928 15279328 10436240
19:07:42 96647 8192000000 10906160976 11370577920 1949010768 19.219 99 14 28 1 1969820192 16738000 4071424
19:09:25 25986 8192000000 10903925024 11367063552 1926298432 19.037 97 58 116 1 1956285312 12143216 17843664
19:10:01 112523 8192000000 10887462688 11385446400 1907308896 18.885 97 10 20 1 1929515280 19727632 2478752
19:11:59 100119 8192000000 10889594320 11357519872 1891837776 18.761 96 13 26 1 1910015040 14783536 3393728
19:13:57 54413 8192000000 10909372224 11376926720 1954474400 19.262 99 31 62 0 1976388592 12757440 9156752
19:14:58 82810 8192000000 10908753872 11376525312 1973777728 19.415 100 22 44 0 1994307584 14388208 6141648
19:16:47 44718 8192000000 10887452704 11355168768 1939101280 19.140 98 29 58 0 1953064160 6030496 7932384
19:17:46 47545 8192000000 10877656400 11360120832 1950024128 19.227 99 12 24 0 1961169984 7565760 3580096
19:18:44 67254 8192000000 10853070512 11339845632 1902927504 18.850 97 3 6 0 1912867104 9201920 737680
19:20:01 16462 8192000000 10838280192 11327172608 1909766672 18.905 99 3 6 0 1921118864 10630064 722128
19:20:34 106501 8192000000 10846628384 11327053824 1840230816 18.343 94 15 30 0 1851979680 7595104 4153760
19:22:50 26206 8192000000 10839112256 11300438016 1860493648 18.507 96 35 68 1 1877137008 6551248 10092112
19:24:27 91648 8192000000 10836405792 11327365120 1863434688 18.531 97 5 10 0 1874844384 10094544 1315152
19:26:05 78680 8192000000 9779060528 10136403968 865231856 9.552 45 8 16 2 871151040 3692656 2226528

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 11-03-2021 19:28:55 to 11-03-2021 19:29:26.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 121 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 11-03-2021 19:29:27 to 11-03-2021 19:29:29.

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          238489
MON$OLDEST_ACTIVE               238954
MON$OLDEST_SNAPSHOT             238954
MON$NEXT_TRANSACTION            238954
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                       2032288
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.33424 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33424 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33424 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33424 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'

11.03.21 19:29:30. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2021-03-11 19:29:32 No severe PSQL-related problems occured
11.03.21 19:29:33. End of report.