Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 21.11.2020 22:27
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 17441388 kB
MemAvailable 31477032 kB
Buffers 0 kB
Cached 14223796 kB
SwapCached 3228 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-21 22:27:05
DTS_END                         2020-11-21 22:27:05.7320
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/51866
TRN_ID                          245334
ATT_ID                          722
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: 9318.24 22159 1118189
customer order: creation 175.21 357 21025
customer order: refuse 14.77 374 1772
order to supplier: creation 47.58 1288 5709
order to supplier: removal 3.33 108352 400
invoice (draft): creation 45.94 3272 5513
invoice (draft): removal 51.91 836 6229
invoice accept: apply 43.88 19507 5265
invoice accept: cancel 46.93 794 5632
customer reserve: creation 4022.02 196 482642
customer reserve: removal 4562.99 62 547559
realization accept: apply 85.53 168 10264
realization accept: cancel 83.80 111 10056
payment from customer: creation 60.89 113 7307
payment from customer: removal 5.90 73 708
payment to supplier: creation 50.88 115 6106
payment to supplier: removal 3.88 63 466
service: total inventory turnovers 5.17 1178 620
service: total monetary turnovers 6.95 31 834
service: aggregate perf. data 0.65 32210 78
service: refresh index statistics 0.03 274082 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 21-11-2020 22:28:06 to 21-11-2020 22:28:09.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 10229
TEST_TIME 2 8852
TEST_TIME 3 7623
TEST_TIME 4 7429
TEST_TIME 5 7346
TEST_TIME 6 7536
TEST_TIME 7 7493
TEST_TIME 8 7344
TEST_TIME 9 7235
TEST_TIME 10 6948
TEST_TIME 11 6966
TEST_TIME 12 6801
TEST_TIME 13 6701
TEST_TIME 14 6635
TEST_TIME 15 6498
TEST_TIME 16 6893
TEST_TIME 17 6949
TEST_TIME 18 7224
TEST_TIME 19 7550
TEST_TIME 20 7943
TEST_TIME 21 7812
TEST_TIME 22 7882
TEST_TIME 23 8150
TEST_TIME 24 9103
TEST_TIME 25 8990
TEST_TIME 26 9032
TEST_TIME 27 9842
TEST_TIME 28 10776
TEST_TIME 29 10911
TEST_TIME 30 10612
TEST_TIME 31 10472
TEST_TIME 32 10442
TEST_TIME 33 10388
TEST_TIME 34 10176
TEST_TIME 35 10104
TEST_TIME 36 10022
TEST_TIME 37 9934
TEST_TIME 38 9995
TEST_TIME 39 9946
TEST_TIME 40 9821
TEST_TIME 41 9723
TEST_TIME 42 9718
TEST_TIME 43 9580
TEST_TIME 44 9679
TEST_TIME 45 9578
TEST_TIME 46 9625
TEST_TIME 47 9596
TEST_TIME 48 9557
TEST_TIME 49 9553
TEST_TIME 50 9682
TEST_TIME 51 9655
TEST_TIME 52 9659
TEST_TIME 53 9607
TEST_TIME 54 9605
TEST_TIME 55 9614
TEST_TIME 56 9750
TEST_TIME 57 9802
TEST_TIME 58 9673
TEST_TIME 59 9588
TEST_TIME 60 9705
TEST_TIME 61 9644
TEST_TIME 62 9589
TEST_TIME 63 9613
TEST_TIME 64 9517
TEST_TIME 65 9423
TEST_TIME 66 9496
TEST_TIME 67 9600
TEST_TIME 68 9546
TEST_TIME 69 9525
TEST_TIME 70 9551
TEST_TIME 71 9696
TEST_TIME 72 9790
TEST_TIME 73 9780
TEST_TIME 74 9789
TEST_TIME 75 9814
TEST_TIME 76 9747
TEST_TIME 77 9827
TEST_TIME 78 9827
TEST_TIME 79 9733
TEST_TIME 80 9694
TEST_TIME 81 9651
TEST_TIME 82 9635
TEST_TIME 83 9627
TEST_TIME 84 9580
TEST_TIME 85 9543
TEST_TIME 86 9499
TEST_TIME 87 9436
TEST_TIME 88 9388
TEST_TIME 89 9437
TEST_TIME 90 9447
TEST_TIME 91 9439
TEST_TIME 92 9414
TEST_TIME 93 9403
TEST_TIME 94 9535
TEST_TIME 95 9484
TEST_TIME 96 9485
TEST_TIME 97 9627
TEST_TIME 98 9618
TEST_TIME 99 9581
TEST_TIME 100 9562
TEST_TIME 101 9541
TEST_TIME 102 9596
TEST_TIME 103 9620
TEST_TIME 104 9539
TEST_TIME 105 9487
TEST_TIME 106 9458
TEST_TIME 107 9432
TEST_TIME 108 9405
TEST_TIME 109 9371
TEST_TIME 110 9339
TEST_TIME 111 9406
TEST_TIME 112 9391
TEST_TIME 113 9389
TEST_TIME 114 9367
TEST_TIME 115 9341
TEST_TIME 116 9354
TEST_TIME 117 9391
TEST_TIME 118 9385
TEST_TIME 119 9395
TEST_TIME 120 9322

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 21-11-2020 22:28:10 to 21-11-2020 22:28:13.

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 1563224 1563224 0 0.00 0 21762 7 0 0
doc_list_biud 1563221 1563221 0 0.00 0 29154 28 0 0
sp_add_invoice_to_stock 5406 5265 141 2.60 18 247824 19508 0 141
sp_cancel_adding_invoice 5632 5632 0 0.00 6 82025 794 0 0
sp_cancel_client_order 1772 1772 0 0.00 5 10388 374 0 0
sp_cancel_customer_reserve 547559 547559 0 0.00 1 29159 63 0 0
sp_cancel_pay_from_customer 708 708 0 0.00 3 3655 73 0 0
sp_cancel_pay_to_supplier 466 466 0 0.00 3 3344 63 0 0
sp_cancel_supplier_invoice 6245 6229 16 0.25 1 14477 836 0 16
sp_cancel_supplier_order 400 400 0 0.00 11 1109480 108353 0 0
sp_cancel_write_off 10056 10056 0 0.00 1 8656 112 0 0
sp_client_order 21025 21025 0 0.00 4 44936 358 0 0
sp_customer_reserve 482642 482642 0 0.00 0 40746 197 0 0
sp_fill_shopping_cart 32236 32236 0 0.00 1 10009 40 0 0
sp_fill_shopping_cart_clo_res 482636 482636 0 0.00 0 21419 14 0 0
sp_get_clo_for_invoice 5258 5258 0 0.00 0 21188 276 0 0
sp_kill_cost_storno 16862 16862 0 0.00 0 7511 52 0 0
sp_kill_qstorno_ret_qs2qd 1111803 1111803 0 0.00 0 29124 34 0 0
sp_kill_qty_storno 587167 587167 0 0.00 0 29154 73 0 0
sp_lock_selected_doc 21422 21422 0 0.00 0 8632 6 0 0
sp_make_cost_storno 28933 28933 0 0.00 0 21427 49 0 0
sp_multiply_rows_for_pdistr 28932 28932 0 0.00 0 6712 27 0 0
sp_multiply_rows_for_qdistr 21024 21024 0 0.00 0 39573 172 0 0
sp_pay_from_customer 7307 7307 0 0.00 4 26130 113 0 0
sp_pay_to_supplier 6106 6106 0 0.00 4 13175 115 0 0
sp_payment_common 13413 13413 0 0.00 1 26099 31 0 0
sp_qd_handle_on_cancel_clo 1772 1772 0 0.00 0 10380 342 0 0
sp_qd_handle_on_invoice_upd_sts 10887 10887 0 0.00 0 27061 318 0 0
sp_qd_handle_on_reserve_upd_sts 10264 10264 0 0.00 0 21577 57 0 0
sp_reserve_write_off 10264 10264 0 0.00 6 21612 168 0 0
sp_supplier_invoice 5513 5513 0 0.00 7 66496 3272 0 0
sp_supplier_order 5709 5709 0 0.00 5 37807 1288 0 0
srv_aggregate_perf_data 78 78 0 0.00 2654 1052996 32211 0 0
srv_fill_mon_cache_memory 174 174 0 0.00 1354 136218 29929 0 0
srv_find_qd_qs_mism 1067907 1067907 0 0.00 0 21761 7 0 0
srv_make_invnt_saldo 620 620 0 0.00 43 99260 1178 0 0
srv_make_money_saldo 834 834 0 0.00 1 3312 32 0 0
srv_recalc_idx_stat 4 4 0 0.00 125927 555604 274083 0 0
t$perf-abend:sp_add_invoice_to_stock 141 141 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 5265 5265 0 0.00 0 16575 175 0 0
t$perf-norm:sp_cancel_adding_invoice 424 424 0 0.00 0 6834 126 0 0
t$perf-norm:sp_cancel_client_order 1772 1772 0 0.00 0 4958 15 0 0
t$perf-norm:sp_cancel_customer_reserve 674 674 0 0.00 0 2235 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 708 708 0 0.00 0 6641 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 466 466 0 0.00 0 1736 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 390 390 0 0.00 0 1647 18 0 0
t$perf-norm:sp_cancel_supplier_order 400 400 0 0.00 0 25777 1741 0 0
t$perf-norm:sp_cancel_write_off 1069 1069 0 0.00 0 5592 8 0 0
t$perf-norm:sp_client_order 21025 21025 0 0.00 0 10725 19 0 0
t$perf-norm:sp_customer_reserve 1034 1034 0 0.00 0 487 4 0 0
t$perf-norm:sp_pay_from_customer 7307 7307 0 0.00 0 4771 8 0 0
t$perf-norm:sp_pay_to_supplier 6106 6106 0 0.00 0 7942 15 0 0
t$perf-norm:sp_reserve_write_off 10264 10264 0 0.00 0 6490 11 0 0
t$perf-norm:sp_supplier_invoice 5513 5513 0 0.00 0 14313 23 0 0
t$perf-norm:sp_supplier_order 5709 5709 0 0.00 0 8044 18 0 0
t$perf-norm:srv_aggregate_perf_data 78 78 0 0.00 0 481 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 174 174 0 0.00 0 333 6 0 0
t$perf-norm:srv_make_invnt_saldo 620 620 0 0.00 0 3351 36 0 0
t$perf-norm:srv_make_money_saldo 834 834 0 0.00 0 8003 30 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 3 3 0 0
v_add_invoice_to_stock 10792 10510 282 2.61 0 5219 17 0 282
v_all_customers 38207 38207 0 0.00 0 49 1 0 0
v_all_suppliers 31054 31054 0 0.00 0 97 1 0 0
v_all_wares 42046 42046 0 0.00 0 105 1 0 0
v_cancel_adding_invoice 848 848 0 0.00 0 2985 10 0 0
v_cancel_client_order 3544 3544 0 0.00 0 4690 5 0 0
v_cancel_customer_prepayment 1416 1416 0 0.00 0 2600 7 0 0
v_cancel_customer_reserve 1348 1348 0 0.00 0 1752 5 0 0
v_cancel_payment_to_supplier 932 932 0 0.00 0 1482 7 0 0
v_cancel_supplier_invoice 812 780 32 3.94 0 5616 33 0 32
v_cancel_supplier_order 800 800 0 0.00 0 16475 30 0 0
v_cancel_write_off 2138 2138 0 0.00 0 3065 15 0 0
v_max_id_clo_ord 5709 5709 0 0.00 0 592 1 0 0
v_max_id_clo_res 1034 1034 0 0.00 0 1137 8 0 0
v_max_id_ord_sup 5503 5503 0 0.00 0 6344 5 0 0
v_max_non_paid_invoice 1791 1791 0 0.00 0 333 2 0 0
v_max_non_paid_realizn 3895 3895 0 0.00 0 4566 4 0 0
v_min_id_clo_ord 5709 5709 0 0.00 0 4597 8 0 0
v_min_id_clo_res 1034 1034 0 0.00 0 6232 18 0 0
v_min_id_ord_sup 5503 5503 0 0.00 0 7763 8 0 0
v_min_non_paid_invoice 6106 6106 0 0.00 0 12990 23 0 0
v_min_non_paid_realizn 7307 7307 0 0.00 0 26093 24 0 0
v_our_firm 10662 10662 0 0.00 0 11 1 0 0
v_reserve_write_off 20528 20528 0 0.00 0 17448 8 0 0
x_lock_depdocs_on_canc_invoice 11471 11471 0 0.00 0 24404 113 0 0
x_lock_depdocs_on_canc_sup_ord 400 400 0 0.00 0 7483 306 0 0
x_make_qstorno_1000_1200 5709 5709 0 0.00 1 37801 1200 0 0
x_make_qstorno_1200_2000 5513 5513 0 0.00 3 66236 3134 0 0
x_make_qstorno_2100_3300 482642 482642 0 0.00 0 38562 180 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 21-11-2020 22:28:14 to 21-11-2020 22:28:18.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:09 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:15 18050 8192000000 10233167120 10539081728 984259648 10.726 77 68 138 0 1011363888 2797888 24306352
19:57:42 28340 8192000000 10322093328 10634428416 1353355200 14.178 100 83 167 0 1385986160 4816768 27814192
19:58:18 23971 8192000000 10351969872 10670592000 1403376816 14.625 100 88 176 1 1438090944 5656416 29057712
19:58:54 23471 8192000000 10384822688 10709114880 1431904352 14.878 100 84 168 0 1466396320 6900512 27591456
19:59:27 13589 8192000000 10394611664 10723590144 1456716400 15.097 100 86 172 0 1492096464 7448000 27932064
19:59:57 3393 8192000000 10423171248 10752294912 1481844016 15.318 100 88 176 0 1519194560 8233440 29117104
20:00:12 22929 8192000000 10452255296 10784989184 1501216688 15.487 100 89 178 2 1538761072 8807184 28737200
20:00:46 16972 8192000000 10472378672 10811002880 1524984512 15.694 100 87 174 1 1561917232 9308832 27623888
20:01:11 11765 8192000000 10491295120 10832334848 1543987472 15.858 100 83 166 1 1579042656 9443744 25611440
20:01:32 15818 8192000000 10509340208 10855796736 1563465216 16.026 100 81 162 1 1597987968 9697680 24825072
20:01:58 10298 8192000000 10526723424 10877394944 1586309728 16.222 100 81 163 2 1621385296 10332064 24743504
20:02:18 15331 8192000000 10546379440 10904907776 1604342144 16.376 100 74 148 0 1636573936 10531360 21700432
20:02:42 12507 8192000000 10573115184 10931929088 1629231920 16.588 100 79 159 2 1664210880 11244368 23734592
20:03:02 11209 8192000000 10594023408 10952269824 1648463904 16.751 100 76 152 1 1682306144 11764880 22077360
20:03:20 11893 8192000000 10615833040 10979418112 1660116064 16.850 100 75 149 2 1693878688 12006976 21755648
20:03:39 6869 8192000000 10637613408 11005472768 1690714240 17.107 100 86 171 1 1727742448 12515104 24513104
20:04:00 8450 8192000000 10655537936 11027390464 1716189232 17.320 100 81 161 0 1753509840 13927872 23392736
20:04:16 6388 8192000000 10670021136 11043500032 1730671712 17.441 100 90 181 1 1770805616 14167408 25966496
20:04:30 7359 8192000000 10690462080 11064541184 1751332448 17.613 100 74 145 2 1783043216 11544912 20165856
20:04:45 6090 8192000000 10699714816 11078201344 1757255744 17.662 100 73 146 0 1790484128 11757232 21471152
20:04:59 4344 8192000000 10713487552 11090165760 1770155792 17.768 100 79 158 1 1804644592 11277008 23211792
20:05:11 4651 8192000000 10719292304 11102814208 1780447440 17.853 100 75 149 1 1812729088 11821424 20460224
20:05:25 4792 8192000000 10730888624 11109416960 1789011168 17.924 100 85 170 0 1826844336 14055728 23777440
20:05:37 3500 8192000000 10728960672 11112370176 1796910400 17.989 100 87 173 2 1836012352 14085744 25016208
20:05:47 3389 8192000000 10746596128 11125809152 1805031184 18.055 100 91 182 1 1844140384 14046224 25062976
20:05:57 3659 8192000000 10751357696 11135868928 1810692704 18.102 100 89 178 1 1849682720 13932320 25057696
20:06:07 2744 8192000000 10759520944 11144470528 1820387296 18.181 100 91 174 1 1859250384 14398912 24464176
20:06:17 3016 8192000000 10765796096 11152060416 1827404368 18.238 100 87 169 2 1864924528 14476032 23044128
20:06:26 7020 8192000000 10760223248 11151773696 1829465776 18.255 100 82 164 1 1867201520 15166208 22569536
20:06:40 5333 8192000000 10780544464 11168587776 1833703616 18.290 100 78 154 1 1868808288 14340240 20764432
20:06:52 1973 8192000000 10800205760 11185000448 1854681760 18.460 100 94 185 2 1894642192 13543904 26416528
20:07:01 2924 8192000000 10795341152 11182780416 1860613536 18.508 100 89 176 0 1897671712 12802528 24255648
20:07:10 2207 8192000000 10806665776 11193692160 1863505088 18.532 100 91 182 0 1902658416 13940096 25213232
20:07:19 1832 8192000000 10802161600 11192356864 1866126208 18.553 100 90 182 1 1904511952 12795600 25590144
20:07:27 2585 8192000000 10815141888 11205582848 1872652656 18.606 100 92 187 1 1912349024 13112272 26584096
20:07:36 1867 8192000000 10820699040 11210244096 1875834896 18.631 100 97 194 2 1916316864 12875968 27606000
20:07:45 1641 8192000000 10813250080 11205451776 1873662016 18.614 100 90 178 1 1913104784 13883840 25558928
20:07:52 2014 8192000000 10808682560 11199238144 1874735008 18.623 100 89 177 3 1912784832 12529280 25520544
20:08:02 1827 8192000000 10820821008 11210280960 1875961072 18.632 100 94 188 5 1915216624 12963024 26292528
20:08:10 1701 8192000000 10819980080 11209146368 1876582528 18.638 100 94 190 0 1915348224 12336704 26428992
20:08:18 1374 8192000000 10825860512 11215888384 1881279360 18.675 100 90 179 2 1919329648 12738880 25311408
20:08:25 1293 8192000000 10824146016 11215474688 1882370576 18.684 100 85 169 0 1919297456 12382368 24544512
20:08:33 23354 8192000000 10803436048 11206246400 1874385472 18.620 100 50 100 1 1897386720 9354640 13646608
20:09:02 22050 8192000000 10804818176 11212595200 1876335568 18.636 100 45 90 2 1896485776 8050224 12099984
20:09:31 3735 8192000000 10824022496 11229036544 1887862528 18.729 100 83 166 0 1923570096 11804704 23902864
20:09:51 13210 8192000000 10792647744 11217727488 1881066000 18.674 100 34 66 1 1895993232 4514256 10412976
20:10:11 7563 8192000000 10790837648 11218604032 1882138672 18.682 100 29 58 1 1898209856 7845664 8225520
20:10:26 4482 8192000000 10807197968 11230957568 1889789184 18.744 100 40 80 2 1913110496 12285840 11035472
20:10:39 2788 8192000000 10803579584 11232378880 1893112624 18.771 100 38 77 2 1912344768 8379824 10852320
20:10:48 8899 8192000000 10806758368 11232296960 1890345936 18.749 100 20 40 2 1902160704 6430512 5384256
20:11:05 3281 8192000000 10807357664 11235729408 1896230832 18.796 100 24 48 0 1909476768 6146336 7099600
20:11:15 9990 8192000000 10800215216 11234918400 1896078480 18.795 100 15 30 0 1906254464 5699360 4476624
20:11:33 5938 8192000000 10805819648 11239538688 1900416048 18.830 100 31 62 0 1916992576 7868912 8707616
20:11:49 18794 8192000000 10802155264 11242565632 1899517424 18.822 100 11 20 2 1907562656 5414992 2630240
20:12:14 10764 8192000000 10808318512 11243511808 1901077984 18.835 100 16 32 0 1911617152 6306944 4232224
20:12:38 6162 8192000000 10801372272 11244523520 1904207120 18.860 100 25 50 3 1917638864 6076896 7354848
20:12:51 8037 8192000000 10815823184 11249557504 1903964832 18.858 100 23 46 1 1917069936 6489664 6615440
20:13:06 8430 8192000000 10807866800 11245879296 1903500400 18.854 100 14 27 1 1913424320 6206272 3717648
20:13:22 17812 8192000000 10821000768 11254538240 1911143456 18.916 100 23 47 0 1923002080 4865952 6992672
20:13:47 65389 8192000000 10824717584 11262545920 1912784304 18.929 100 23 44 3 1925469008 5807952 6876752
20:15:03 3956 8192000000 10828152864 11266723840 1914737792 18.945 100 24 48 2 1927157840 5506480 6913568
20:15:13 5733 8192000000 10836755856 11271675904 1916370064 18.958 100 24 48 2 1929624240 6361920 6892256
20:15:29 6393 8192000000 10816819136 11249958912 1873283072 18.611 98 32 64 1 1889331648 5857856 10190720
20:15:42 3827 8192000000 10808140608 11235192832 1881814672 18.680 99 32 64 1 1897352976 6661872 8876432
20:15:52 3382 8192000000 10832239856 11254484992 1900135952 18.827 100 39 79 2 1918899760 6658096 12105712
20:16:02 5969 8192000000 10818307952 11246395392 1895529360 18.790 100 23 44 3 1907403312 5732192 6141760
20:16:16 6664 8192000000 10819671136 11257942016 1906301232 18.877 100 26 52 1 1919856496 6430960 7124304
20:16:29 4919 8192000000 10817180176 11249623040 1886801824 18.720 99 23 46 0 1899282576 5890224 6590528
20:16:43 9716 8192000000 10774289600 11210526720 1853131504 18.448 98 19 39 1 1868174000 9710464 5332032
20:16:59 7294 8192000000 10811007536 11232509952 1882838128 18.688 100 19 38 1 1894404016 6090880 5475008
20:17:13 13264 8192000000 10783612016 11214618624 1815585184 18.142 96 20 40 0 1826423680 5480288 5358208
20:17:35 7770 8192000000 10778546544 11202269184 1769197120 17.760 94 23 45 0 1784569024 9033952 6337952
20:17:52 12900 8192000000 10716143504 11137843200 1706385088 17.239 92 13 25 1 1715318448 5180352 3753008
20:18:13 20185 8192000000 10717709088 11142840320 1719783520 17.350 94 22 44 1 1730717216 5183888 5749808
20:19:09 33049 8192000000 10728798848 11162501120 1767600224 17.747 96 29 56 4 1780851520 5316272 7935024
20:19:48 9481 8192000000 10728616704 11153354752 1788826304 17.922 98 21 42 1 1800652912 6132560 5694048
20:20:05 5925 8192000000 10695583424 11099799552 1700675984 17.191 94 29 57 1 1714015600 5337584 8002032
20:20:19 6962 8192000000 10685238528 11096293376 1718348896 17.338 96 26 52 2 1730299712 4275136 7675680
20:20:32 6359 8192000000 10692635376 11099066368 1713634000 17.299 96 31 60 2 1727831968 5575712 8622256
20:20:47 13241 8192000000 10690771744 11107414016 1718070992 17.336 96 19 38 2 1729269776 6254560 4944224
20:21:06 8456 8192000000 10707687920 11133796352 1783273264 17.876 99 22 45 1 1796317616 5760848 7283504
20:21:24 7195 8192000000 10738016352 11145805824 1775704160 17.814 98 25 50 0 1792780528 9702624 7373744
20:21:38 5414 8192000000 10728421584 11149238272 1809014432 18.088 100 16 32 2 1819444544 5665216 4764896
20:21:52 11369 8192000000 10727654272 11146526720 1789987328 17.932 99 22 44 1 1802519280 5684400 6847552
20:22:15 8447 8192000000 10743868704 11161214976 1828000176 18.243 100 30 60 1 1842872784 5622048 9250560
20:22:33 10246 8192000000 10741102304 11160035328 1815228016 18.139 99 21 42 2 1827314784 5201520 6885248
20:22:51 5835 8192000000 10754049040 11172376576 1830704240 18.265 100 27 54 3 1843590304 5225872 7660192
20:23:04 7031 8192000000 10748555696 11177558016 1839050432 18.333 100 22 44 0 1851035968 5640608 6344928
20:23:20 83932 8192000000 10758767152 11185725440 1846853376 18.397 100 30 60 2 1861550448 5336928 9360144
20:24:51 11711 8192000000 10772735872 11190779904 1851158272 18.432 100 27 54 2 1865123968 5887520 8078176
20:25:09 7523 8192000000 10774353344 11197476864 1856296976 18.473 100 34 64 1 1871467680 6287040 8883664
20:25:22 6199 8192000000 10772708720 11196727296 1853276224 18.449 100 25 51 2 1866182352 5865152 7040976
20:25:38 11827 8192000000 10777354832 11202580480 1858592992 18.492 100 29 58 0 1873127920 5815968 8718960
20:25:56 6129 8192000000 10772824752 11202879488 1860666976 18.509 100 31 60 0 1876925104 7637632 8620496
20:26:09 9165 8192000000 10778793488 11209461760 1859506064 18.499 100 26 48 3 1876496992 9462576 7528352
20:26:27 9954 8192000000 10776957072 11203612672 1862582112 18.524 100 33 65 5 1879127600 6175232 10370256
20:26:46 7218 8192000000 10782640592 11209674752 1865716240 18.550 100 39 79 2 1885245472 6345616 13183616
20:26:59 9293 8192000000 10804578208 11222523904 1873957952 18.616 100 28 53 2 1886699952 4918784 7823216
20:27:17 8611 8192000000 10836480688 11244638208 1896531008 18.798 100 52 101 0 1922882464 10949344 15402112
20:27:32 12916 8192000000 10842721248 11250049024 1904341248 18.861 100 58 116 0 1928543840 7713888 16488704
20:27:55 8908 8192000000 10847396832 11259817984 1908982912 18.898 100 60 118 1 1934832368 8591888 17257568
20:28:11 2459 8192000000 10854377488 11259785216 1915105504 18.948 100 65 129 2 1943213344 9702864 18404976
20:28:23 70449 8192000000 10842878912 11265417216 1898955952 18.818 99 53 108 1 1923216656 9164480 15096224
20:29:45 16481 8192000000 10844602688 11269271552 1898745936 18.816 99 38 76 1 1917853840 8194928 10912976
20:30:08 18673 8192000000 10864092624 11286421504 1927951440 19.050 100 46 88 3 1947926160 7797152 12177568
20:30:34 4689 8192000000 10869720016 11289493504 1931354912 19.078 100 47 92 0 1953076096 8916384 12804800
20:30:45 9840 8192000000 10855066416 11281276928 1915358912 18.950 99 60 118 1 1941637584 9867168 16411504
20:31:08 13313 8192000000 10879714752 11299086336 1938851856 19.138 100 55 110 3 1963719296 10101792 14765648
20:31:29 3292 8192000000 10879686320 11295137792 1938182624 19.132 100 66 133 0 1967333232 10772080 18378528
20:31:38 4733 8192000000 10860492208 11279921152 1906018752 18.875 99 62 124 1 1934737936 11284048 17435136
20:31:50 7242 8192000000 10881190112 11295100928 1933825392 19.097 100 70 139 0 1966524240 13294624 19404224
20:32:16 24352 8192000000 10880354464 11301244928 1937263376 19.125 100 57 114 0 1967315840 14034352 16018112
20:32:49 10326 8192000000 10877531920 11304202240 1942815040 19.169 100 57 114 0 1972197264 12888064 16494160
20:33:07 4015 8192000000 10887732848 11304378368 1944554656 19.183 100 70 140 0 1977203840 13059408 19589776
20:33:21 3508 8192000000 10900461616 11312328704 1949539216 19.223 100 66 130 0 1982984688 14388384 19057088
20:33:33 17700 8192000000 10887787520 11315027968 1952353328 19.245 100 58 117 0 1983488336 14789408 16345600
20:34:01 19896 8192000000 10887744720 11321286656 1956763520 19.280 100 55 110 1 1987473280 14686896 16022864
20:34:28 2799 8192000000 10897136288 11325804544 1922217200 19.005 98 52 101 3 1952639056 15641120 14780736
20:34:39 27589 8192000000 10875165888 11304058880 1909642816 18.904 98 52 104 0 1938810736 13417248 15750672
20:35:16 10119 8192000000 10876019344 11310587904 1924715312 19.025 99 43 82 2 1954578032 17260480 12602240
20:35:35 19695 8192000000 10894360208 11326390272 1951952992 19.242 100 38 76 0 1981416096 18008352 11454752
20:36:03 6929 8192000000 10900589712 11328036864 1943836752 19.177 99 61 121 3 1979950992 18380992 17733248
20:36:19 13339 8192000000 10908172304 11336769536 1963300848 19.332 100 42 84 0 1993284272 17530960 12452464
20:36:52 6905 8192000000 10901954272 11333894144 1951601744 19.239 99 38 76 0 1982241920 19633152 11007024
20:37:07 1351 8192000000 10921397888 11343929344 1961884496 19.321 99 83 164 1 2007120240 20848576 24387168
20:37:17 11711 8192000000 10928049840 11349086208 1970088192 19.386 100 66 127 1 2010950512 22817504 18044816
20:37:46 5404 8192000000 10929705824 11358003200 1981327680 19.475 100 65 129 1 2025258880 25554160 18377040
20:38:01 10703 8192000000 10927351792 11351445504 1960429616 19.309 99 64 128 2 2007339216 26709792 20199808
20:38:23 8229 8192000000 10941690320 11366293504 1979760240 19.463 100 56 112 0 2027532800 30566320 17206240
20:38:39 3004 8192000000 10945337440 11370696704 1983487088 19.492 100 58 117 2 2032135760 30470816 18177856
20:38:57 7588 8192000000 10932585824 11364794368 1966365984 19.357 99 49 95 0 2009480048 28472944 14641120
20:39:12 3046 8192000000 10923651776 11344248832 1948400448 19.214 98 59 117 1 1993416432 27142096 17873888
20:39:22 10314 8192000000 10944986848 11368361984 1983193392 19.490 100 71 142 0 2034458736 29353504 21911840
20:39:43 10058 8192000000 10932047120 11364433920 1976516656 19.437 100 55 110 0 2025315104 32403792 16394656
20:40:04 4501 8192000000 10941102672 11366191104 1964876896 19.345 99 63 125 3 2017242528 32301232 20064400
20:40:18 7166 8192000000 10956476112 11380027392 1989703424 19.541 100 70 136 2 2043921808 33957664 20260720
20:40:35 5946 8192000000 10936112624 11362017280 1964545056 19.342 99 71 142 1 2020191152 34303792 21342304
20:40:49 3714 8192000000 10943946224 11371896832 1982664464 19.486 100 57 114 2 2034353712 34513232 17176016
20:41:00 4858 8192000000 10953627040 11373953024 1979900368 19.464 100 63 125 1 2033865312 34488752 19476192
20:41:13 6201 8192000000 10951699760 11376574464 1989686144 19.541 100 71 141 0 2046733008 34737552 22309312
20:41:26 3572 8192000000 10956026320 11372011520 1980247888 19.467 100 68 135 2 2036035872 35482768 20305216
20:41:37 3804 8192000000 10941000416 11350990848 1963079424 19.331 99 81 159 2 2024267232 36129904 25057904
20:41:51 2541 8192000000 10959546528 11363991552 1974049200 19.418 100 82 160 0 2036662768 37369968 25243600
20:42:00 1967 8192000000 10961217840 11368861696 1975907920 19.432 100 82 164 2 2039983808 38555792 25520096
20:42:09 8644 8192000000 10948576000 11370266624 1977004464 19.441 100 65 127 0 2035735344 39297536 19433344
20:42:25 6917 8192000000 10951075696 11372683264 1977016832 19.441 100 70 140 1 2038463424 39508480 21938112
20:42:40 6880 8192000000 10968104944 11389272064 1988498080 19.532 100 65 130 0 2050025392 40857136 20670176
20:42:57 1361 8192000000 10964384048 11380572160 1983744416 19.494 100 77 155 2 2050816736 42386336 24685984
20:43:07 3247 8192000000 10953554960 11367985152 1973088544 19.410 100 72 144 2 2039896112 43542432 23265136
20:43:19 3494 8192000000 10974029824 11384066048 1982135104 19.482 100 76 153 1 2051377136 45347024 23895008
20:43:30 2975 8192000000 10969417792 11374587904 1974974976 19.425 100 84 168 1 2047426656 46853040 25598640
20:43:47 2390 8192000000 10950691248 11367972864 1966296800 19.356 100 70 140 2 2037579728 48692464 22590464
20:43:57 16641 8192000000 10942154368 11366678528 1964875712 19.345 100 60 120 2 2031177952 46386816 19915424
20:44:29 14633 8192000000 10925254848 11355029504 1933514928 19.095 99 53 105 1 1997568176 46363328 17689920
20:44:51 2038 8192000000 10952805072 11369320448 1959180112 19.300 100 73 141 2 2034035152 51381152 23473888
20:45:03 2412 8192000000 10952592048 11364581376 1957046528 19.283 100 72 143 2 2029175184 48488576 23640080
20:45:13 4311 8192000000 10940696288 11361861632 1953608816 19.255 100 65 131 1 2026731856 51067360 22055680
20:45:26 3844 8192000000 10926313584 11335319552 1906779040 18.881 97 67 134 1 1979428704 51308784 21340880
20:45:39 3131 8192000000 10943216000 11353161728 1945201632 19.188 100 84 168 1 2026300032 54116624 26981776
20:45:49 4904 8192000000 10944968576 11359154176 1937773728 19.129 99 87 173 0 2020818320 55245600 27798992
20:46:02 2228 8192000000 10947246048 11352100864 1946409264 19.198 100 87 175 3 2028031888 53371264 28251360
20:46:11 2542 8192000000 10936425808 11341889536 1932526432 19.087 99 81 159 1 2012285712 54470576 25288704
20:46:21 3646 8192000000 10951438688 11361148928 1949590560 19.223 100 88 174 1 2032940256 55351280 27998416
20:46:32 5307 8192000000 10949548592 11364311040 1947262160 19.205 100 73 146 1 2027835088 56819392 23753536
20:46:47 2225 8192000000 10972058720 11373608960 1964820192 19.344 100 92 184 1 2047292448 53600096 28872160
20:46:56 2257 8192000000 10949427888 11360976896 1942818944 19.169 99 84 168 1 2022946720 54182192 25945584
20:47:06 2494 8192000000 10946602432 11361005568 1950436288 19.230 100 68 137 2 2025198176 53173312 21588576
20:47:16 1896 8192000000 10951665104 11359719424 1952987536 19.250 100 78 154 1 2031874288 53754304 25132448
20:47:25 3164 8192000000 10972886496 11384532992 1970482304 19.389 100 83 165 0 2051820512 55781888 25556320
20:47:36 2122 8192000000 10981858608 11396030464 1979704448 19.462 100 80 158 2 2062147088 57898432 24544208
20:47:45 1788 8192000000 10974060160 11394437120 1978999952 19.457 100 70 136 0 2053691552 53005520 21686080
20:47:54 7988 8192000000 10961827520 11399819264 1980539248 19.469 100 55 110 0 2051311632 53273504 17498880
20:48:19 21173 8192000000 10964433616 11403759616 1976239968 19.435 100 45 90 1 2046879408 56157296 14482144
20:48:50 3887 8192000000 10976069280 11402092544 1977143520 19.442 100 54 108 1 2055551232 59910736 18496976
20:49:01 9634 8192000000 10974001120 11404500992 1965849936 19.353 99 51 101 3 2039076976 56573536 16653504
20:49:20 5538 8192000000 10975007536 11400212480 1977216240 19.443 100 60 118 2 2056430064 60257840 18955984
20:49:36 6394 8192000000 10956746160 11384573952 1953328352 19.253 99 54 108 0 2033498960 62478672 17691936
20:49:54 9039 8192000000 10964575456 11397894144 1965346432 19.349 100 51 102 1 2047678608 64964048 17368128
20:50:24 10351 8192000000 10970141664 11412856832 1969606144 19.382 100 40 79 1 2052826992 69664528 13556320
20:51:02 14040 8192000000 10966438336 11412029440 1970574816 19.390 100 31 61 0 2049446896 67904736 10967344
20:51:28 23404 8192000000 10946771712 11421831168 1967422848 19.365 100 25 50 2 2037901776 61736032 8742896
20:51:58 25796 8192000000 10925454896 11386073088 1941784384 19.161 99 25 49 2 2006413488 56068352 8560752
20:52:37 18801 8192000000 10931866592 11387961344 1943837136 19.177 100 24 48 1 2014525632 60936304 9752192
20:53:12 17467 8192000000 10913476640 11365478400 1910220432 18.908 99 19 38 0 1979394080 61638480 7535168
20:53:38 26433 8192000000 10929519984 11383107584 1931147296 19.076 100 24 48 1 2012302416 72331808 8823312
20:54:46 34628 8192000000 10865243456 11325575168 1891496240 18.758 98 13 26 0 1949276880 52420464 5360176
20:55:30 50885 8192000000 10864343776 11337977856 1933863616 19.098 100 12 24 1 1959009280 21018704 4126960
20:56:27 102469 8192000000 10866543696 11320422400 1906280176 18.877 98 19 38 1 1925404800 13549888 5574736
20:58:23 54369 8192000000 10869715776 11299561472 1869622656 18.581 96 40 81 1 1888334960 7771184 10941120
20:59:25 47009 8192000000 10866502672 11302154240 1887922160 18.729 98 28 56 1 1904748896 8022336 8804400
21:00:25 19913 8192000000 10859570336 11309383680 1893424496 18.773 98 37 75 1 1910923472 6978496 10520480
21:00:55 88161 8192000000 10868914128 11319189504 1889257200 18.740 97 20 39 1 1902676912 7630416 5789296
21:02:30 21586 8192000000 10870017120 11327000576 1943091472 19.171 100 23 46 1 1959111936 9513664 6506800
21:03:09 54800 8192000000 10877074848 11320926208 1914991904 18.947 98 33 65 2 1940299824 15784496 9523424
21:04:16 26701 8192000000 10910149712 11333201920 1936419264 19.118 99 42 82 1 1961236624 10914448 13902912
21:04:57 18203 8192000000 10889302768 11344130048 1954844368 19.265 100 27 54 1 1979545360 16509616 8191376
21:05:23 45370 8192000000 10875717712 11342245888 1936414016 19.118 99 16 32 0 1954719120 13398144 4906960
21:06:20 39741 8192000000 10880719024 11352432640 1956975264 19.282 100 19 38 0 1976912400 14379824 5557312
21:07:43 23193 8192000000 10876189184 11338358784 1936614896 19.120 99 12 24 0 1953400528 13033456 3752176
21:08:12 18780 8192000000 10886063280 11349364736 1956334816 19.277 100 17 35 0 1980878960 19647104 4897040
21:09:02 44969 8192000000 10890182960 11345674240 1939544656 19.143 99 13 26 0 1956654992 13387136 3723200
21:09:54 53647 8192000000 10883152224 11345108992 1938077968 19.131 99 11 22 0 1953792864 12300064 3414832
21:11:11 66913 8192000000 10882852512 11354759168 1939513248 19.143 99 14 28 0 1958220512 14466288 4240976
21:12:27 33236 8192000000 10907826960 11346866176 1918719856 18.977 97 48 96 0 1941356208 9247856 13388496
21:13:07 29450 8192000000 10908841040 11364614144 1972988928 19.409 100 50 102 2 1998825728 12107024 13729776
21:13:52 46807 8192000000 10875915680 11345231872 1923532128 19.015 98 8 15 1 1935016240 8949024 2535088
21:14:51 25744 8192000000 10884993024 11346300928 1945578368 19.191 99 18 35 1 1958237408 7477568 5181472
21:15:25 28302 8192000000 10888117456 11346010112 1945410304 19.190 99 32 62 2 1965936752 12002368 8524080
21:16:12 47925 8192000000 10909186720 11367579648 1971947776 19.401 100 24 48 1 1990173904 11520032 6706096
21:17:41 63627 8192000000 10879836544 11349942272 1924662160 19.024 98 13 26 0 1941750352 14039840 3048352
21:18:53 56136 8192000000 10905589664 11363397632 1965987504 19.354 100 18 36 1 1981858720 10911184 4960032
21:19:55 49199 8192000000 10902874592 11348795392 1895152288 18.787 96 35 71 0 1913375744 9267392 8956064
21:21:15 19487 8192000000 10911274416 11362672640 1953192336 19.252 99 39 78 2 1979628240 15143680 11292224
21:21:51 81552 8192000000 10910149840 11372892160 1920232480 18.989 97 22 44 1 1944230304 17562992 6434832
21:23:19 63245 8192000000 10869187360 11347144704 1911977232 18.923 98 14 28 0 1938308960 22201424 4130304
21:24:30 51811 8192000000 10883009504 11336126464 1896166976 18.795 97 37 74 1 1924500192 16208032 12125184
21:25:37 96290 8192000000 10870694560 11343183872 1916790592 18.961 98 34 68 0 1944067696 16393360 10883744
21:29:15 39911 8192000000 10856522528 11311804416 1891739616 18.760 97 22 44 1 1908339968 10757808 5842544
21:30:06 63204 8192000000 10860590288 11342745600 1907679712 18.888 98 6 12 0 1924613344 15760112 1173520
21:31:16 5412 8192000000 10874738256 11349950464 1946071456 19.195 100 13 25 1 1966712656 17450048 3191152
21:31:27 29500 8192000000 10856567360 11323273216 1914846720 18.946 98 10 19 0 1927505296 10324128 2334448
21:32:03 59275 8192000000 10864365808 11323924480 1877716496 18.647 96 11 22 0 1891805024 10727296 3361232
21:33:10 60586 8192000000 10868331344 11357208576 1932288816 19.085 99 17 34 0 1952251376 15333344 4629216
21:34:17 44508 8192000000 10886053040 11360833536 1924450112 19.022 99 9 18 1 1943524096 16957360 2116624
21:35:08 51063 8192000000 10914703920 11372969984 1952690944 19.248 99 22 43 1 1974329904 15774336 5864624
21:36:07 45064 8192000000 10916236320 11360161792 1929618240 19.064 98 32 64 0 1958929664 20380992 8930432
21:37:04 61019 8192000000 10879348144 11334344704 1901241088 18.836 97 12 24 2 1927621888 23073360 3307440
21:38:13 66725 8192000000 10879163968 11352698880 1932642272 19.088 99 9 18 0 1953677136 18571248 2463616
21:39:26 78150 8192000000 10883205248 11342360576 1872564224 18.605 96 18 36 0 1892142800 14503872 5074704
21:41:04 60110 8192000000 10870446320 11337449472 1914635808 18.944 98 17 34 1 1933168832 13715360 4817664
21:42:12 76376 8192000000 10905384784 11341160448 1901229856 18.836 97 36 72 3 1925928496 14197408 10501232
21:43:37 80456 8192000000 10874423024 11339120640 1888219248 18.731 97 29 58 1 1911876192 15709056 7947888
21:45:04 13702 8192000000 10883139072 11326525440 1924770064 19.025 99 56 113 2 1949785968 8572576 16443328
21:45:28 19830 8192000000 10880195664 11336081408 1940682736 19.152 100 32 64 0 1961100432 11456032 8961664
21:45:54 103052 8192000000 10881131392 11335933952 1928540416 19.055 99 25 50 0 1944420784 9174720 6705648
21:47:44 91097 8192000000 10870968496 11334451200 1893660880 18.775 97 22 44 4 1913788352 13901456 6226016
21:49:24 19675 8192000000 10879885504 11342209024 1939673856 19.144 100 17 32 1 1955498512 11484480 4340176
21:49:54 66634 8192000000 10852542256 11330392064 1908545872 18.895 98 13 26 0 1920844288 8015648 4282768
21:51:57 48518 8192000000 10853458224 11321524224 1915812592 18.953 98 12 24 1 1926768448 7481584 3474272
21:52:56 27829 8192000000 10872807616 11337637888 1930532096 19.071 99 14 28 0 1943685328 9177952 3975280
21:53:35 86987 8192000000 10864326752 11342069760 1929955872 19.067 99 19 38 2 1947786848 11938624 5892352
21:55:36 44704 8192000000 10848058176 11319488512 1872372624 18.603 96 13 26 0 1887578832 11535440 3670768
21:56:32 60796 8192000000 10862459472 11339571200 1913505232 18.935 99 10 19 0 1928235456 12304560 2425664
21:57:42 54001 8192000000 10884927024 11347988480 1934547216 19.103 99 18 36 1 1950174176 10470656 5156304
21:58:46 33537 8192000000 10887375888 11352895488 1938900448 19.138 99 21 42 0 1956764960 11458960 6405552
21:59:42 51886 8192000000 10917417488 11377631232 1972685792 19.407 100 21 42 2 1996370432 18015904 5668736
22:00:41 103113 8192000000 10883457776 11353772032 1877774736 18.647 95 22 44 0 1905428464 20739744 6913984
22:02:32 39993 8192000000 10905821776 11358994432 1932038544 19.083 98 34 66 2 1953577328 12317248 9221536
22:03:20 38904 8192000000 10908716192 11354185728 1930254128 19.069 98 37 74 0 1952470096 12000560 10215408
22:04:08 80593 8192000000 10881460000 11363753984 1938052800 19.131 99 27 54 0 1961142496 15847680 7242016
22:05:36 85546 8192000000 10906026608 11357753344 1928491520 19.055 98 28 54 3 1947306880 11487824 7327536
22:07:08 14293 8192000000 10920117792 11359748096 1968411680 19.373 100 42 84 0 1991580368 11451472 11717216
22:07:30 9032 8192000000 10907309808 11347701760 1945871456 19.194 99 53 106 0 1973243984 12332592 15039936
22:07:49 15655 8192000000 10931344480 11366236160 1969627536 19.382 100 54 108 0 1998040624 13215856 15197232
22:08:14 12044 8192000000 10916287216 11356110848 1950383680 19.230 99 57 114 0 1979343408 13668128 15291600
22:08:33 19291 8192000000 10919372720 11357442048 1930759232 19.073 98 44 88 1 1958622912 15834496 12029184
22:09:03 19112 8192000000 10924450768 11375706112 1969624944 19.382 100 45 90 1 2005455440 23741472 12089024
22:09:30 136218 8192000000 10889019296 11364163584 1892721136 18.768 96 24 48 0 1915443344 16139248 6582960
22:11:58 70048 8192000000 10849903840 11310731264 1835725968 18.306 94 29 58 1 1852159904 8473824 7960112
22:13:15 45358 8192000000 10864297280 11324362752 1935283312 19.109 100 21 42 1 1949081536 7496608 6301616
22:14:07 62723 8192000000 10880829920 11348750336 1946756928 19.201 100 23 46 1 1970675152 17334992 6583232
22:15:20 84484 8192000000 10883522848 11359371264 1954844528 19.265 100 11 20 1 1972892880 14701040 3347312
22:16:58 97439 8192000000 10873632800 11344191488 1901545584 18.839 97 25 50 1 1929661312 20411408 7704320
22:18:42 71145 8192000000 10855401520 11339972608 1889297840 18.740 97 9 17 0 1901975024 10146176 2531008
22:20:11 49532 8192000000 10857966112 11329118208 1890627360 18.751 97 12 24 0 1905093456 10740464 3725632
22:21:12 62992 8192000000 10898516416 11338469376 1929442096 19.062 99 30 59 1 1947783856 10205824 8135936
22:22:22 34424 8192000000 10876342112 11335962624 1914379408 18.942 98 29 58 2 1936591360 13692816 8519136
22:23:09 46428 8192000000 10871304624 11331317760 1909525216 18.903 98 39 78 0 1936586128 15153408 11907504
22:24:11 79353 8192000000 10863668944 11338551296 1904624672 18.863 99 25 50 0 1932121264 20485056 7011536
22:25:46 47300 8192000000 10868075968 11306921984 1824264144 18.213 94 33 66 2 1842958640 9492592 9201904
22:26:43 43454 8192000000 9431298560 9728495616 561950304 6.419 30 1 2 0 567409040 5396608 62128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 21-11-2020 22:28:20 to 21-11-2020 22:28:53.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 141 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 21-11-2020 22:28:54 to 21-11-2020 22:28:56.

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          246441
MON$OLDEST_ACTIVE               246442
MON$OLDEST_SNAPSHOT             246442
MON$NEXT_TRANSACTION            246442
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                       2025760
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 ---
:36: 
:37: mscs-test-161.budzdorov.ru    Sat Nov 21 22:27:28 2020
:38:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:39: 
:40: 
:41: mscs-test-161.budzdorov.ru    Sat Nov 21 22:27:28 2020
:42:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:43: 
:44: 
:45: mscs-test-161.budzdorov.ru    Sat Nov 21 22:27:28 2020
:46:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:47: 
:48: 
:49: mscs-test-161.budzdorov.ru    Sat Nov 21 22:27:28 2020
:50:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:51: 
:52: 
:53: mscs-test-161.budzdorov.ru    Sat Nov 21 22:27:28 2020
:54:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:55: 
--- end of diff output ---

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

21.11.20 22:28:57. 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-21 22:28:59 No severe PSQL-related problems occured
21.11.20 22:29:00. End of report.