Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 17.01.2021 19: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 17295388 kB
MemAvailable 31308500 kB
Buffers 0 kB
Cached 14370624 kB
SwapCached 4864 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-01-17 19:27:11
DTS_END                         2021-01-17 19:27:11.1120
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_RECALC_IDX_STAT(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/41652
TRN_ID                          243444
ATT_ID                          711
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: 9477.35 18243 1137282
customer order: creation 179.61 362 21553
customer order: refuse 14.60 318 1752
order to supplier: creation 47.62 1261 5714
order to supplier: removal 3.43 106245 411
invoice (draft): creation 47.28 3011 5674
invoice (draft): removal 53.90 812 6468
invoice accept: apply 42.83 17600 5139
invoice accept: cancel 48.79 783 5855
customer reserve: creation 3958.53 173 475024
customer reserve: removal 4771.72 60 572606
realization accept: apply 86.75 179 10410
realization accept: cancel 89.88 114 10786
payment from customer: creation 61.09 111 7331
payment from customer: removal 5.90 101 708
payment to supplier: creation 50.12 126 6014
payment to supplier: removal 3.45 49 414
service: total inventory turnovers 4.73 1287 568
service: total monetary turnovers 6.23 23 747
service: aggregate perf. data 0.87 20908 104
service: refresh index statistics 0.03 211338 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 17-01-2021 19:28:03 to 17-01-2021 19:28:05.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4996
TEST_TIME 2 4335
TEST_TIME 3 4776
TEST_TIME 4 4799
TEST_TIME 5 4401
TEST_TIME 6 4948
TEST_TIME 7 5172
TEST_TIME 8 5565
TEST_TIME 9 5477
TEST_TIME 10 5572
TEST_TIME 11 5764
TEST_TIME 12 5847
TEST_TIME 13 6058
TEST_TIME 14 6399
TEST_TIME 15 7010
TEST_TIME 16 7115
TEST_TIME 17 8024
TEST_TIME 18 8239
TEST_TIME 19 8781
TEST_TIME 20 8705
TEST_TIME 21 8995
TEST_TIME 22 9684
TEST_TIME 23 9772
TEST_TIME 24 9904
TEST_TIME 25 10188
TEST_TIME 26 11307
TEST_TIME 27 11408
TEST_TIME 28 11053
TEST_TIME 29 10860
TEST_TIME 30 10771
TEST_TIME 31 10680
TEST_TIME 32 10548
TEST_TIME 33 10427
TEST_TIME 34 10369
TEST_TIME 35 10205
TEST_TIME 36 10119
TEST_TIME 37 9958
TEST_TIME 38 9925
TEST_TIME 39 9805
TEST_TIME 40 9761
TEST_TIME 41 9672
TEST_TIME 42 9625
TEST_TIME 43 9768
TEST_TIME 44 9810
TEST_TIME 45 9907
TEST_TIME 46 10041
TEST_TIME 47 9964
TEST_TIME 48 9896
TEST_TIME 49 9854
TEST_TIME 50 10055
TEST_TIME 51 10010
TEST_TIME 52 10050
TEST_TIME 53 10015
TEST_TIME 54 10071
TEST_TIME 55 10021
TEST_TIME 56 9908
TEST_TIME 57 9848
TEST_TIME 58 9825
TEST_TIME 59 9764
TEST_TIME 60 9722
TEST_TIME 61 9679
TEST_TIME 62 9570
TEST_TIME 63 9571
TEST_TIME 64 9553
TEST_TIME 65 9556
TEST_TIME 66 9619
TEST_TIME 67 9638
TEST_TIME 68 9611
TEST_TIME 69 9581
TEST_TIME 70 9587
TEST_TIME 71 9588
TEST_TIME 72 9690
TEST_TIME 73 9660
TEST_TIME 74 9786
TEST_TIME 75 9782
TEST_TIME 76 9888
TEST_TIME 77 9861
TEST_TIME 78 9882
TEST_TIME 79 9770
TEST_TIME 80 9744
TEST_TIME 81 9690
TEST_TIME 82 9666
TEST_TIME 83 9649
TEST_TIME 84 9602
TEST_TIME 85 9557
TEST_TIME 86 9580
TEST_TIME 87 9562
TEST_TIME 88 9518
TEST_TIME 89 9515
TEST_TIME 90 9509
TEST_TIME 91 9477
TEST_TIME 92 9490
TEST_TIME 93 9498
TEST_TIME 94 9553
TEST_TIME 95 9577
TEST_TIME 96 9543
TEST_TIME 97 9655
TEST_TIME 98 9655
TEST_TIME 99 9616
TEST_TIME 100 9651
TEST_TIME 101 9699
TEST_TIME 102 9747
TEST_TIME 103 9697
TEST_TIME 104 9652
TEST_TIME 105 9643
TEST_TIME 106 9616
TEST_TIME 107 9601
TEST_TIME 108 9575
TEST_TIME 109 9553
TEST_TIME 110 9496
TEST_TIME 111 9467
TEST_TIME 112 9463
TEST_TIME 113 9536
TEST_TIME 114 9509
TEST_TIME 115 9529
TEST_TIME 116 9539
TEST_TIME 117 9544
TEST_TIME 118 9554
TEST_TIME 119 9550
TEST_TIME 120 9479

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 17-01-2021 19:28:07 to 17-01-2021 19:28:10.

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 1577052 1577052 0 0.00 0 20134 6 0 0
doc_list_biud 1577052 1577052 0 0.00 0 34287 28 0 0
sp_add_invoice_to_stock 5260 5139 121 2.30 27 189670 17601 0 121
sp_cancel_adding_invoice 5855 5855 0 0.00 5 71501 783 0 0
sp_cancel_client_order 1752 1752 0 0.00 4 6654 319 0 0
sp_cancel_customer_reserve 572606 572606 0 0.00 1 34289 60 0 0
sp_cancel_pay_from_customer 708 708 0 0.00 3 5172 102 0 0
sp_cancel_pay_to_supplier 414 414 0 0.00 2 2229 50 0 0
sp_cancel_supplier_invoice 6479 6468 11 0.16 2 17717 813 0 11
sp_cancel_supplier_order 411 411 0 0.00 6 1215319 106246 0 0
sp_cancel_write_off 10786 10786 0 0.00 1 10251 115 0 0
sp_client_order 21553 21553 0 0.00 4 18576 363 0 0
sp_customer_reserve 475024 475024 0 0.00 0 112629 173 0 0
sp_fill_shopping_cart 32920 32920 0 0.00 1 10783 39 0 0
sp_fill_shopping_cart_clo_res 475019 475019 0 0.00 0 15694 14 0 0
sp_get_clo_for_invoice 5131 5131 0 0.00 0 20149 360 0 0
sp_kill_cost_storno 17763 17763 0 0.00 0 12645 58 0 0
sp_kill_qstorno_ret_qs2qd 1162877 1162877 0 0.00 0 34245 33 0 0
sp_kill_qty_storno 613414 613414 0 0.00 0 34287 70 0 0
sp_lock_selected_doc 21398 21398 0 0.00 0 10314 6 0 0
sp_make_cost_storno 28881 28881 0 0.00 0 20102 51 0 0
sp_multiply_rows_for_pdistr 28881 28881 0 0.00 0 10885 29 0 0
sp_multiply_rows_for_qdistr 21553 21553 0 0.00 0 11083 168 0 0
sp_pay_from_customer 7331 7331 0 0.00 4 16848 111 0 0
sp_pay_to_supplier 6014 6014 0 0.00 5 15282 126 0 0
sp_payment_common 13345 13345 0 0.00 1 15270 31 0 0
sp_qd_handle_on_cancel_clo 1752 1752 0 0.00 0 6647 293 0 0
sp_qd_handle_on_invoice_upd_sts 10981 10981 0 0.00 0 26744 310 0 0
sp_qd_handle_on_reserve_upd_sts 10410 10410 0 0.00 0 26160 64 0 0
sp_reserve_write_off 10410 10410 0 0.00 6 26245 179 0 0
sp_supplier_invoice 5674 5674 0 0.00 6 68656 3011 0 0
sp_supplier_order 5714 5714 0 0.00 5 39202 1261 0 0
srv_aggregate_perf_data 105 104 1 0.95 2722 368515 20908 0 1
srv_fill_mon_cache_memory 159 159 0 0.00 961 186408 33503 0 0
srv_find_qd_qs_mism 1088011 1088011 0 0.00 0 13157 5 0 0
srv_make_invnt_saldo 568 568 0 0.00 13 100367 1288 0 0
srv_make_money_saldo 747 747 0 0.00 0 1039 24 0 0
srv_recalc_idx_stat 4 4 0 0.00 173272 280326 211339 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 11 11 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5139 5139 0 0.00 0 13422 174 0 0
t$perf-norm:sp_cancel_adding_invoice 422 422 0 0.00 0 4635 91 0 0
t$perf-norm:sp_cancel_client_order 1752 1752 0 0.00 0 5731 16 0 0
t$perf-norm:sp_cancel_customer_reserve 676 676 0 0.00 0 2743 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 708 708 0 0.00 0 1803 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 414 414 0 0.00 0 1505 9 0 0
t$perf-norm:sp_cancel_supplier_invoice 453 453 0 0.00 0 735 8 0 0
t$perf-norm:sp_cancel_supplier_order 411 411 0 0.00 0 24533 1593 0 0
t$perf-norm:sp_cancel_write_off 1027 1027 0 0.00 0 4980 14 0 0
t$perf-norm:sp_client_order 21553 21553 0 0.00 0 17336 19 0 0
t$perf-norm:sp_customer_reserve 1015 1015 0 0.00 0 2282 12 0 0
t$perf-norm:sp_pay_from_customer 7331 7331 0 0.00 0 13897 9 0 0
t$perf-norm:sp_pay_to_supplier 6014 6014 0 0.00 0 12404 15 0 0
t$perf-norm:sp_reserve_write_off 10410 10410 0 0.00 0 7787 13 0 0
t$perf-norm:sp_supplier_invoice 5674 5674 0 0.00 0 8036 21 0 0
t$perf-norm:sp_supplier_order 5714 5714 0 0.00 0 4170 12 0 0
t$perf-norm:srv_aggregate_perf_data 104 104 0 0.00 0 477 10 0 0
t$perf-norm:srv_fill_mon_cache_memory 159 159 0 0.00 0 2951 22 0 0
t$perf-norm:srv_make_invnt_saldo 568 568 0 0.00 0 927 16 0 0
t$perf-norm:srv_make_money_saldo 747 747 0 0.00 0 3217 18 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 10492 10250 242 2.30 0 7719 24 0 242
v_all_customers 39078 39078 0 0.00 0 18 1 0 0
v_all_suppliers 31572 31572 0 0.00 0 24 1 0 0
v_all_wares 43106 43106 0 0.00 0 15 1 0 0
v_cancel_adding_invoice 844 844 0 0.00 0 369 7 0 0
v_cancel_client_order 3504 3504 0 0.00 0 3022 6 0 0
v_cancel_customer_prepayment 1416 1416 0 0.00 0 4993 10 0 0
v_cancel_customer_reserve 1352 1352 0 0.00 0 12700 13 0 0
v_cancel_payment_to_supplier 828 828 0 0.00 0 2205 6 0 0
v_cancel_supplier_invoice 928 906 22 2.37 0 3437 25 0 22
v_cancel_supplier_order 822 822 0 0.00 0 2407 10 0 0
v_cancel_write_off 2054 2054 0 0.00 0 1562 11 0 0
v_max_id_clo_ord 5714 5714 0 0.00 0 1130 1 0 0
v_max_id_clo_res 1015 1015 0 0.00 0 3715 18 0 0
v_max_id_ord_sup 5653 5653 0 0.00 0 4161 4 0 0
v_max_non_paid_invoice 1595 1595 0 0.00 0 493 2 0 0
v_max_non_paid_realizn 3909 3909 0 0.00 0 5681 5 0 0
v_min_id_clo_ord 5714 5714 0 0.00 0 2665 5 0 0
v_min_id_clo_res 1015 1015 0 0.00 0 4540 14 0 0
v_min_id_ord_sup 5653 5653 0 0.00 0 8189 6 0 0
v_min_non_paid_invoice 6014 6014 0 0.00 0 15258 20 0 0
v_min_non_paid_realizn 7331 7331 0 0.00 0 6664 19 0 0
v_our_firm 10872 10872 0 0.00 0 24 1 0 0
v_reserve_write_off 20820 20820 0 0.00 0 16764 9 0 0
x_lock_depdocs_on_canc_invoice 11870 11870 0 0.00 0 24510 127 0 0
x_lock_depdocs_on_canc_sup_ord 411 411 0 0.00 0 8935 306 0 0
x_make_qstorno_1000_1200 5714 5714 0 0.00 2 39195 1188 0 0
x_make_qstorno_1200_2000 5674 5674 0 0.00 3 65071 2860 0 0
x_make_qstorno_2100_3300 475024 475024 0 0.00 0 112627 157 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 17-01-2021 19:28:11 to 17-01-2021 19:28:15.

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:14 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:20 20572 8192000000 10252728944 10557661184 848123808 9.381 67 59 119 0 870859600 2519696 20216096
16:57:49 24235 8192000000 10338686288 10657619968 1388663872 14.494 100 87 174 0 1421281536 4738992 27878672
16:58:24 19914 8192000000 10372198400 10691653632 1433289504 14.890 100 90 180 1 1468734192 6164432 29280256
16:58:59 17360 8192000000 10400667968 10726903808 1451725408 15.053 100 87 173 0 1487099232 6959648 28414176
16:59:26 20645 8192000000 10418563664 10748776448 1473858096 15.248 100 87 174 0 1509407952 7752688 27797168
16:59:57 15119 8192000000 10439164800 10769608704 1496621440 15.447 100 89 178 0 1533053296 8101232 28330624
17:00:20 6365 8192000000 10443674368 10776981504 1500311136 15.479 100 87 174 0 1536812752 8581376 27920240
17:00:35 18862 8192000000 10453390976 10786619392 1506606384 15.534 100 88 176 0 1543981840 9060368 28315088
17:01:04 22234 8192000000 10472603072 10812293120 1523942672 15.684 100 88 176 0 1561070816 9281072 27847072
17:01:34 11609 8192000000 10483831520 10828062720 1545310736 15.869 100 86 172 0 1582197104 9737616 27148752
17:01:56 9485 8192000000 10504932160 10849153024 1558808848 15.986 100 78 156 0 1592062336 9416128 23837360
17:02:14 14905 8192000000 10539524112 10890801152 1586976752 16.228 100 77 154 1 1620096576 9464576 23655248
17:02:37 14741 8192000000 10575124448 10936725504 1629343024 16.589 100 76 152 0 1661608176 9996880 22268272
17:03:01 11166 8192000000 10596127808 10962051072 1660888736 16.856 100 78 157 0 1695444176 11819616 22735824
17:03:20 12671 8192000000 10620631136 10985803776 1678423536 17.004 100 87 173 0 1715277024 11913920 24939568
17:03:43 11631 8192000000 10639243680 11009118208 1700495504 17.189 100 84 168 1 1737456784 12618032 24343248
17:04:03 5781 8192000000 10654769072 11024621568 1710073008 17.269 100 76 152 5 1743994496 12534816 21386672
17:04:17 8488 8192000000 10661237968 11035566080 1724880928 17.393 100 81 163 4 1760854576 12684368 23289280
17:04:32 6554 8192000000 10674971312 11049992192 1742139152 17.536 100 86 172 1 1780152864 13408512 24605200
17:04:46 8464 8192000000 10696113952 11071528960 1753731552 17.633 100 86 171 2 1791020464 13624400 23664512
17:05:02 5041 8192000000 10695765584 11074285568 1757570880 17.664 100 80 160 2 1793340256 13852320 21917056
17:05:15 5577 8192000000 10708703296 11087056896 1765550320 17.730 100 82 164 0 1801567872 13523168 22494384
17:05:29 4965 8192000000 10712805952 11093176320 1776526304 17.821 100 80 159 1 1812590368 13921232 22142832
17:05:41 3901 8192000000 10728859248 11105312768 1786556672 17.903 100 85 170 0 1824167104 13472896 24137536
17:05:51 3303 8192000000 10731610656 11111424000 1789941040 17.931 100 89 176 3 1828885264 14484080 24460144
17:06:03 6578 8192000000 10728344896 11110305792 1787308320 17.910 100 83 164 1 1824047728 14654864 22084544
17:06:16 4044 8192000000 10741140128 11123486720 1792243680 17.950 100 89 177 2 1831482464 14628528 24610256
17:06:27 2495 8192000000 10751106288 11132317696 1808353200 18.082 100 83 165 2 1846085520 14865328 22866992
17:06:36 1966 8192000000 10752636192 11131760640 1811608864 18.109 100 93 186 4 1852479696 14849264 26021568
17:06:44 1614 8192000000 10758928032 11139362816 1815047568 18.137 100 88 176 1 1854964448 14816496 25100384
17:06:53 2081 8192000000 10762648624 11146969088 1824041840 18.211 100 89 178 0 1861440992 13128688 24270464
17:07:01 2892 8192000000 10766863376 11150413824 1829379744 18.254 100 89 178 1 1867707552 13223984 25103824
17:07:11 2175 8192000000 10776442832 11163983872 1837324080 18.319 100 92 181 3 1876591664 13975200 25292384
17:07:20 2257 8192000000 10783209872 11164643328 1838075952 18.325 100 97 195 0 1879439664 13686592 27677120
17:07:28 2155 8192000000 10780417264 11169443840 1841260784 18.351 100 91 182 2 1881131856 13745664 26125408
17:07:37 1986 8192000000 10787303712 11171786752 1845804336 18.388 100 91 184 0 1884439280 12688688 25946256
17:07:45 1576 8192000000 10796765216 11181219840 1850319040 18.425 100 86 173 0 1887427616 12755152 24353424
17:07:53 6001 8192000000 10793395744 11185635328 1854859856 18.462 100 86 173 0 1892537360 13608816 24068688
17:08:06 1212 8192000000 10791855776 11188445184 1856516848 18.475 100 78 154 1 1896160160 18504192 21139120
17:08:13 3893 8192000000 10785588656 11185602560 1853878816 18.454 100 58 116 0 1882079568 12316304 15884448
17:08:23 16606 8192000000 10789894288 11186511872 1857266432 18.481 100 67 133 0 1886642944 10799296 18577216
17:08:46 12140 8192000000 10747293680 11184836608 1852802240 18.445 100 30 60 0 1870219728 9108448 8309040
17:09:09 12924 8192000000 10781148640 11195576320 1860113536 18.504 100 30 61 2 1875474960 6490832 8870592
17:09:28 5198 8192000000 10779709760 11199766528 1866695280 18.558 100 30 58 2 1881456960 6593728 8167952
17:09:40 3957 8192000000 10786709968 11204444160 1873788704 18.615 100 39 80 1 1891863472 5932720 12142048
17:09:50 7004 8192000000 10782065152 11208126464 1872835824 18.607 100 22 44 1 1886235232 6925488 6473920
17:10:04 12083 8192000000 10778807584 11209166848 1877097712 18.642 100 20 40 1 1888599952 6197968 5304272
17:10:22 5508 8192000000 10781622880 11214827520 1879481488 18.661 100 25 50 0 1893150720 6891840 6777392
17:10:34 7052 8192000000 10789763584 11216674816 1879367392 18.660 100 25 51 1 1892806816 6576272 6863152
17:10:50 8260 8192000000 10787938560 11216052224 1882050544 18.682 100 21 42 1 1893305440 5927440 5327456
17:11:06 13679 8192000000 10791022224 11220787200 1882231136 18.683 100 15 30 0 1892471168 5928496 4311536
17:11:26 4459 8192000000 10786499200 11219312640 1881747216 18.679 100 12 23 0 1891153584 5829376 3576992
17:11:37 4049 8192000000 10787019936 11222589440 1884579664 18.702 100 19 38 0 1895902000 5979520 5342816
17:11:49 15198 8192000000 10804242640 11223937024 1891322960 18.756 100 28 55 1 1910006976 9395792 9288224
17:12:12 64306 8192000000 10806784432 11241598976 1891619696 18.759 100 35 68 1 1907726816 6471648 9635472
17:13:25 9270 8192000000 10810332656 11241123840 1892560384 18.766 100 25 50 1 1905557600 6137440 6859776
17:13:45 3349 8192000000 10803268064 11238080512 1893762272 18.776 100 30 60 0 1909144128 6260256 9121600
17:13:55 7195 8192000000 10818233056 11246538752 1892771488 18.768 100 19 38 0 1907950192 9694608 5484096
17:14:11 4177 8192000000 10810417712 11244294144 1896034448 18.794 100 20 40 0 1908090464 6325664 5730352
17:14:22 4651 8192000000 10823902144 11248844800 1903377104 18.853 100 30 60 0 1918539616 6550384 8612128
17:14:35 6895 8192000000 10818316112 11253886976 1902873152 18.849 100 24 48 1 1920990336 11331792 6785392
17:14:49 5204 8192000000 10815030864 11250241536 1902090288 18.843 100 24 49 0 1914926528 5849312 6986928
17:15:03 5006 8192000000 10818858432 11248877568 1903780592 18.857 100 33 67 3 1919937904 5198304 10959008
17:15:15 9707 8192000000 10810741120 11243823104 1898990608 18.818 100 18 36 1 1909790352 5601968 5197776
17:15:32 5776 8192000000 10809612400 11246227456 1901627344 18.839 100 28 54 5 1915739168 5547712 8564112
17:15:44 6716 8192000000 10816302304 11247816704 1886300224 18.716 99 25 48 1 1899701088 5854528 7546336
17:16:03 6392 8192000000 10828147200 11255750656 1906472624 18.878 100 27 54 0 1921493904 7400336 7620944
17:16:18 8619 8192000000 10799691328 11234476032 1851092192 18.431 97 16 32 2 1861203488 5640592 4470704
17:16:35 63911 8192000000 10807930816 11231789056 1856213104 18.473 98 30 60 3 1870246016 5392960 8639952
17:17:46 17977 8192000000 10790817040 11224580096 1856468016 18.475 98 16 31 1 1866907568 5415344 5024208
17:18:10 6689 8192000000 10767924432 11190435840 1808207376 18.081 97 27 54 0 1822122576 6613056 7302144
17:18:23 6692 8192000000 10743937040 11167150080 1815238832 18.139 99 15 30 2 1824980576 5590688 4151056
17:18:36 8151 8192000000 10732516384 11140587520 1731741632 17.450 94 19 38 1 1742334896 5248912 5344352
17:18:52 4729 8192000000 10691511584 11094388736 1693629664 17.132 94 28 57 1 1707523104 5982816 7910624
17:19:05 11782 8192000000 10699585312 11113525248 1756834432 17.658 98 33 66 0 1772980144 6627184 9518528
17:19:25 4733 8192000000 10720215600 11120865280 1760082816 17.685 98 34 68 4 1776045136 6089008 9873312
17:19:37 6197 8192000000 10717268864 11134124032 1784811856 17.889 99 22 44 1 1796979616 6027232 6140528
17:19:51 9098 8192000000 10699923824 11114704896 1700517424 17.189 94 21 42 1 1711699024 4522656 6658944
17:20:08 7232 8192000000 10710588032 11124224000 1761963664 17.701 98 32 64 3 1776477696 5153840 9360192
17:20:21 6891 8192000000 10707269072 11109728256 1723970592 17.385 96 41 82 1 1742859760 7348928 11540240
17:20:37 9034 8192000000 10713754048 11129069568 1786335440 17.902 99 22 43 3 1798992752 5602032 7055280
17:20:52 10350 8192000000 10728067744 11146858496 1810868544 18.103 100 20 40 1 1822241840 6149216 5224080
17:21:10 20317 8192000000 10729050240 11136966656 1747130656 17.578 96 16 32 2 1756848352 5616896 4100800
17:21:37 59088 8192000000 10732142864 11153608704 1790871776 17.939 98 27 54 1 1804306192 5614736 7819680
17:22:46 11619 8192000000 10730304432 11147145216 1752496208 17.622 96 11 22 4 1760817728 5064400 3257120
17:23:04 8181 8192000000 10743248688 11160260608 1826562640 18.231 100 44 88 0 1846980192 7951760 12465792
17:23:20 4573 8192000000 10758412384 11171463168 1832733328 18.282 100 44 89 0 1852305968 6799024 12773616
17:23:34 4937 8192000000 10743562992 11173183488 1834674976 18.297 100 18 36 1 1845448192 5647408 5125808
17:23:45 5911 8192000000 10763972016 11184037888 1842559328 18.362 100 26 52 1 1856570928 6715792 7295808
17:23:57 8999 8192000000 10755249264 11182989312 1844353200 18.376 100 19 38 1 1855568192 6147008 5067984
17:24:12 7457 8192000000 10773911008 11194183680 1849884160 18.421 100 22 44 2 1861299168 4973520 6441488
17:24:27 8319 8192000000 10772251536 11193315328 1854756992 18.461 100 24 47 0 1867315776 5719200 6839584
17:24:42 7265 8192000000 10770557664 11197001728 1856892192 18.478 100 31 62 4 1875953200 9915264 9145744
17:24:56 9723 8192000000 10771548416 11202383872 1863392240 18.531 100 30 60 2 1878275520 5844736 9038544
17:25:11 8354 8192000000 10773597152 11205156864 1863851376 18.534 100 21 39 3 1874681408 4627264 6202768
17:25:28 7494 8192000000 10785474128 11210366976 1868299872 18.571 100 19 38 0 1879927232 5413120 6214240
17:25:43 12195 8192000000 10770839344 11210317824 1869548640 18.581 100 21 42 0 1881613456 6195632 5869184
17:26:01 12764 8192000000 10806684384 11221999616 1870681376 18.590 100 14 28 2 1879952560 4914976 4356208
17:26:21 100206 8192000000 10846709616 11263533056 1899217760 18.820 100 44 88 2 1919214512 5668624 14328128
17:28:08 3379 8192000000 10852556336 11267776512 1920054848 18.987 100 56 112 3 1945318064 10479584 14783632
17:28:18 2003 8192000000 10854635920 11274166272 1923832368 19.018 100 49 96 0 1947651392 11161888 12657136
17:28:27 16842 8192000000 10881302528 11295576064 1934954560 19.106 100 66 134 2 1970870576 17201904 18714112
17:29:06 12048 8192000000 10871651792 11293614080 1940499872 19.151 100 56 112 0 1969007760 12707376 15800512
17:29:24 39044 8192000000 10878567136 11311210496 1945600528 19.191 100 48 94 2 1973892384 14839296 13452560
17:30:11 15329 8192000000 10888218528 11314536448 1949609968 19.223 100 41 82 1 1978137680 16515744 12011968
17:30:34 21918 8192000000 10894932000 11327418368 1954654976 19.264 100 42 84 2 1983625264 16040512 12929776
17:31:02 10065 8192000000 10908873936 11333775360 1962045712 19.322 100 35 70 2 1989315296 16674880 10594704
17:31:21 17566 8192000000 10909131040 11337338880 1972791024 19.408 100 48 93 1 2002556256 16395328 13369904
17:31:57 8845 8192000000 10923028272 11348250624 1978835536 19.455 100 59 116 0 2015447200 19034832 17576832
17:32:15 13181 8192000000 10927390032 11354972160 1983045856 19.489 100 56 110 1 2020345280 20618720 16680704
17:32:35 17707 8192000000 10926005904 11354828800 1983789824 19.495 100 49 98 2 2018611536 20713728 14107984
17:33:03 7109 8192000000 10933352736 11370016768 1990430768 19.547 100 47 94 0 2028395920 23442352 14522800
17:33:27 10903 8192000000 10943688688 11374317568 1997275968 19.601 100 48 96 3 2032346480 21108016 13962496
17:33:45 3660 8192000000 10943704496 11373039616 1997998048 19.607 100 55 111 2 2036942016 22813088 16130880
17:33:59 10892 8192000000 10956731184 11382534144 2001675552 19.636 100 59 117 1 2043124160 23933024 17515584
17:34:20 9174 8192000000 10953744960 11387904000 2008197712 19.687 100 55 110 0 2051227344 25891344 17138288
17:34:45 15251 8192000000 10959338816 11395862528 2009736768 19.699 100 50 100 2 2051817152 26724336 15356048
17:35:08 15294 8192000000 10963527488 11402084352 2015062880 19.741 100 47 94 0 2056198416 26658096 14477440
17:35:31 12115 8192000000 10957955168 11398250496 2009825840 19.700 100 43 86 0 2049323328 25857232 13640256
17:35:52 6299 8192000000 10964393984 11399077888 2010363136 19.704 100 49 98 0 2053214256 28106304 14744816
17:36:11 6447 8192000000 10974655008 11407364096 2017907152 19.764 100 59 118 0 2066417136 31046016 17463968
17:36:26 12808 8192000000 10966120288 11400085504 2001868608 19.637 99 60 118 2 2052516352 32311664 18336080
17:36:50 9321 8192000000 10985069840 11414224896 2019364992 19.775 100 54 108 4 2067714912 32099360 16250560
17:37:08 12908 8192000000 10994379936 11422015488 2025209728 19.821 100 71 142 2 2081219200 34972992 21036480
17:37:33 4875 8192000000 10999079152 11428667392 2027597200 19.840 100 71 143 2 2086340080 37334416 21408464
17:37:52 2768 8192000000 11011070464 11437486080 2040033328 19.937 100 76 152 2 2100752080 38080112 22638640
17:38:02 6428 8192000000 11011710352 11442610176 2040376608 19.940 100 66 130 1 2097457568 37379712 19701248
17:38:20 3587 8192000000 11012908864 11443863552 2042579632 19.957 100 71 139 2 2100809408 37595200 20634576
17:38:36 4571 8192000000 11028208592 11447590912 2043310688 19.963 100 74 149 1 2104785776 39728608 21746480
17:38:49 3938 8192000000 11013336304 11445985280 2026655440 19.832 99 66 132 0 2088887632 41967760 20264432
17:39:00 1665 8192000000 10999206880 11424403456 2022006640 19.796 99 83 163 0 2087927456 41204560 24716256
17:39:09 5997 8192000000 10998050656 11427975168 2020897904 19.787 100 64 129 0 2083543168 42878448 19766816
17:39:22 11847 8192000000 10973924112 11403358208 1982729920 19.486 98 65 129 1 2045957680 42784912 20442848
17:39:42 9797 8192000000 10972911664 11404869632 2001724400 19.636 100 57 114 2 2064310640 43614640 18971600
17:40:03 10326 8192000000 10992205456 11427598336 2018253088 19.766 100 65 127 0 2084280688 46414896 19612704
17:40:21 3224 8192000000 10997863920 11418030080 1991822736 19.558 99 75 150 1 2062838576 47634176 23381664
17:40:31 2150 8192000000 10984081456 11405017088 1992670992 19.565 99 80 155 1 2064371872 48053072 23647808
17:40:41 1542 8192000000 11005988336 11418955776 2008212352 19.687 100 86 171 1 2080490256 45659792 26618112
17:40:50 2829 8192000000 11009639360 11426385920 2016880384 19.756 100 86 172 1 2093021424 48370784 27770256
17:40:59 2945 8192000000 11001815536 11424763904 1997219440 19.601 99 83 166 2 2073784592 51596192 24968960
17:41:13 2531 8192000000 10985662400 11410821120 1998348752 19.610 100 77 152 2 2074578944 52042944 24187248
17:41:25 3280 8192000000 10973103536 11394408448 1968695008 19.375 99 77 153 0 2045813248 53408016 23710224
17:41:35 6212 8192000000 10973889248 11403423744 1990636352 19.549 100 72 144 1 2064502496 50290640 23575504
17:41:55 1436 8192000000 11000429792 11420545024 2005646480 19.667 100 82 161 0 2081959792 50928928 25384384
17:42:03 1958 8192000000 11008363664 11423395840 2008162848 19.687 100 87 170 2 2086000272 51220368 26617056
17:42:13 957 8192000000 10996946864 11411628032 1991891648 19.559 99 90 180 0 2071898688 51972480 28034560
17:42:20 3024 8192000000 11004059536 11422392320 2006902448 19.677 100 86 172 2 2087625392 53714224 27008720
17:42:31 2537 8192000000 10969273776 11381497856 1977840912 19.448 99 75 146 0 2045132624 44958848 22332864
17:42:41 4603 8192000000 10976362976 11393875968 1973458192 19.413 99 82 161 0 2044322928 45719552 25145184
17:42:54 5851 8192000000 10989115280 11405414400 1994246096 19.577 100 77 154 3 2065758416 47431040 24081280
17:43:11 5847 8192000000 10996716272 11415326720 2005204896 19.664 100 76 155 1 2076671904 47886384 23580624
17:43:25 3771 8192000000 10989629168 11409498112 2001854240 19.637 100 88 176 2 2077482608 48121488 27506880
17:43:36 6828 8192000000 10989084336 11409178624 1997687840 19.604 100 75 150 0 2070697472 49955696 23053936
17:43:50 3559 8192000000 10998377728 11416764416 2002279872 19.641 100 85 169 0 2081604656 52614656 26710128
17:44:02 5639 8192000000 10975046960 11396390912 1971313440 19.396 99 73 146 0 2048679584 54059680 23306464
17:44:14 2610 8192000000 10989071680 11403005952 1989014912 19.536 100 71 140 0 2064750640 53653280 22082448
17:44:23 6381 8192000000 10983356256 11416055808 1997840112 19.606 100 67 134 1 2071155216 52033616 21281488
17:44:45 21784 8192000000 10964032864 11413659648 1986351552 19.515 100 33 66 0 2048692544 51170224 11170768
17:45:31 3595 8192000000 10961697728 11400515584 1982418224 19.484 100 47 94 0 2048960464 51303872 15238368
17:45:54 9425 8192000000 10950956128 11393265664 1974918144 19.424 100 44 86 2 2040598592 51829008 13851440
17:46:10 7539 8192000000 10950366080 11375656960 1947798784 19.209 99 52 101 4 2015323584 51380688 16144112
17:46:25 9885 8192000000 10950043056 11396603904 1973063504 19.410 100 44 88 2 2040960272 53675392 14221376
17:46:41 14413 8192000000 10939611552 11386679296 1956833840 19.281 99 35 70 1 2018048624 49405648 11809136
17:47:04 21130 8192000000 10940669648 11388047360 1954356192 19.261 99 28 56 3 2008778880 44715456 9707232
17:47:35 13098 8192000000 10926206592 11367333888 1925972400 19.035 98 40 81 0 1987009744 47692416 13344928
17:47:57 1650 8192000000 10927618304 11341869056 1918898272 18.978 99 66 129 1 1989688896 50203280 20587344
17:48:09 11618 8192000000 10940258608 11374071808 1948427872 19.214 100 50 100 0 2023645696 58506848 16710976
17:48:28 10806 8192000000 10938324352 11385495552 1959104032 19.299 100 33 66 1 2026447648 56260864 11082752
17:48:56 20739 8192000000 10926707760 11369447424 1920154400 18.988 98 33 66 1 1989633344 57848672 11630272
17:49:31 13705 8192000000 10923164800 11370045440 1925853744 19.034 99 31 62 0 1990979840 54433616 10692480
17:50:06 15538 8192000000 10922007536 11367170048 1951755104 19.240 100 31 61 1 2004799088 42535632 10508352
17:50:35 14069 8192000000 10915862208 11361886208 1935360272 19.110 99 26 53 1 1986242144 42065920 8815952
17:50:56 22056 8192000000 10902642784 11354214400 1910697232 18.912 98 26 52 1 1967370896 47380672 9292992
17:51:24 40951 8192000000 10907731600 11360198656 1917263648 18.965 99 21 42 1 1973062432 47921584 7877200
17:52:13 36127 8192000000 10910913728 11374399488 1935228352 19.109 100 14 28 1 1995628688 55044160 5356176
17:52:56 31249 8192000000 10920975392 11364114432 1906662544 18.880 98 18 36 0 1960349376 47061504 6625328
17:53:34 21224 8192000000 10890621072 11367563264 1924306336 19.021 99 17 34 1 1970453216 40083536 6063344
17:54:01 56817 8192000000 10826693056 11282010112 1799819520 18.012 93 8 16 1 1810858880 8641664 2397696
17:55:04 58465 8192000000 10864143968 11293290496 1883218320 18.691 98 37 77 1 1899395808 6462368 9715120
17:56:09 40422 8192000000 10871718384 11304955904 1908447616 18.894 99 33 67 4 1925536208 8405184 8683408
17:57:00 33920 8192000000 10895920704 11329011712 1948516704 19.215 100 49 97 2 1974672432 13533552 12622176
17:58:10 186408 8192000000 10876004384 11335151616 1859991808 18.503 95 18 36 1 1873692336 9183904 4516624
18:01:23 23596 8192000000 10870174704 11337142272 1954503936 19.262 100 17 34 1 1967638528 8274272 4860320
18:01:53 13285 8192000000 10849595584 11314712576 1913020032 18.931 98 6 13 0 1923034096 8329712 1684352
18:02:13 53028 8192000000 10884520048 11348643840 1958255232 19.292 100 32 61 1 1979579904 12102176 9222496
18:03:12 56801 8192000000 10879566944 11354173440 1957596288 19.287 100 12 24 0 1971722720 10439872 3686560
18:05:01 92300 8192000000 10910489392 11375779840 1930105936 19.068 98 22 44 0 1944361904 8141808 6114160
18:07:16 43538 8192000000 10903021600 11378032640 1975776848 19.431 100 34 66 0 2004832736 19151888 9904000
18:08:22 54837 8192000000 10912048960 11389009920 1981267376 19.475 100 14 28 0 2003560864 18034352 4259136
18:09:24 61213 8192000000 10915094304 11395420160 1982933728 19.488 100 20 39 1 2013643616 24397136 6312752
18:11:08 63690 8192000000 10928610736 11397926912 1963273936 19.332 99 14 28 0 1983257776 15995824 3988016
18:12:18 77527 8192000000 10911425136 11387392000 1966237888 19.356 99 15 30 0 1982158272 11566736 4353648
18:14:08 32465 8192000000 10910000432 11371749376 1944629824 19.184 98 18 36 3 1963738240 14414448 4693968
18:14:47 52828 8192000000 10911413072 11366690816 1938319824 19.133 98 23 45 1 1956463488 12149392 5994272
18:15:49 38667 8192000000 10917910752 11361792000 1937571264 19.127 98 41 83 0 1962716912 13631632 11514016
18:16:40 41933 8192000000 10922086720 11373408256 1979857648 19.464 100 33 66 0 2011769472 21941552 9970272
18:17:34 61356 8192000000 10926587232 11386650624 1958369344 19.293 99 27 54 1 1977661552 11437584 7854624
18:18:42 40985 8192000000 10918074304 11376111616 1968887664 19.377 99 27 54 2 1988465136 11875904 7701568
18:19:33 49903 8192000000 10923697536 11378540544 1929345792 19.062 97 19 38 2 1950774720 15538016 5890912
18:20:35 44477 8192000000 10911542912 11365056512 1947670000 19.208 99 27 54 0 1967692992 12826784 7196208
18:21:26 22349 8192000000 10919850080 11367534592 1954380144 19.261 99 33 66 0 1973446048 10013120 9052784
18:22:19 98485 8192000000 10905492928 11368165376 1967276800 19.364 99 42 81 1 1987180016 8174656 11728560
18:24:06 66882 8192000000 10922545744 11377815552 1948289424 19.213 98 46 92 2 1971787472 10321984 13176064
18:25:21 19353 8192000000 10913254224 11380465664 1984667328 19.502 100 30 60 0 2005287024 12268816 8350880
18:25:50 23653 8192000000 10896683472 11364708352 1956954912 19.282 99 30 58 2 1974353696 8792384 8606400
18:26:24 30663 8192000000 10881678736 11351695360 1957375904 19.285 99 21 42 1 1972096288 8255552 6464832
18:27:11 55939 8192000000 10882243680 11350368256 1933808256 19.097 98 7 14 0 1942628976 7028960 1791760
18:28:13 39397 8192000000 10883646480 11359961088 1968058352 19.370 100 12 24 0 1978570896 7140064 3372480
18:29:05 33178 8192000000 10851479648 11317534720 1890676880 18.751 97 16 30 3 1901545264 7296224 3572160
18:30:06 60439 8192000000 10852144496 11333808128 1912775376 18.929 99 9 17 1 1924922944 9478112 2669456
18:31:12 42916 8192000000 10849497136 11312517120 1863272320 18.530 96 11 21 1 1872489968 6820304 2397344
18:32:03 48920 8192000000 10867422368 11337166848 1916255760 18.957 98 33 66 2 1936903632 11675632 8972240
18:33:14 93337 8192000000 10879447024 11356532736 1925909312 19.034 98 17 34 0 1945145360 14878800 4357248
18:35:02 41772 8192000000 10881346176 11339939840 1903635680 18.856 97 23 45 2 1917339392 6982608 6721104
18:35:55 81020 8192000000 10891405968 11359158272 1885187136 18.707 96 22 44 0 1902446432 11245504 6013792
18:37:52 75457 8192000000 10885038464 11346673664 1904281792 18.861 98 10 20 1 1928761920 21431504 3048624
18:39:16 71356 8192000000 10894248288 11351924736 1936700464 19.120 99 18 36 0 1954755056 13233504 4821088
18:40:34 33595 8192000000 10892671136 11351044096 1938814736 19.137 99 22 44 1 1958894336 13305648 6773952
18:41:18 102945 8192000000 10871430400 11339702272 1890270960 18.748 97 19 38 2 1914101568 18727360 5103248
18:43:08 118158 8192000000 10867919536 11340111872 1795937200 17.981 92 15 30 0 1819649680 19487744 4224736
18:46:25 114156 8192000000 10860328960 11327430656 1874363152 18.620 97 28 56 0 1890760416 8662896 7734368
18:48:28 34899 8192000000 10848796640 11318751232 1908471728 18.894 99 14 28 0 1928120800 16153536 3495536
18:49:12 38986 8192000000 10855801632 11328229376 1921021472 18.995 99 25 50 1 1940640416 12431408 7187536
18:50:05 83825 8192000000 10874192640 11350835200 1941722480 19.160 100 11 21 2 1955650576 10301024 3627072
18:51:39 39447 8192000000 10854067536 11324895232 1912231872 18.925 98 18 35 1 1928529424 11326848 4970704
18:52:47 72080 8192000000 10859142096 11342110720 1921366512 18.998 99 12 24 1 1935274944 9793824 4114608
18:54:05 49834 8192000000 10862526416 11339575296 1923945584 19.018 99 15 26 0 1936303968 8002544 4355840
18:55:05 71208 8192000000 10844017552 11324940288 1882320192 18.684 97 9 18 1 1895832672 11309856 2202624
18:56:23 47918 8192000000 10869214352 11337711616 1917054208 18.963 99 19 35 1 1929980864 8562272 4364384
18:57:23 65690 8192000000 10890183888 11344023552 1933252736 19.093 99 15 30 1 1944258160 7065120 3940304
18:58:37 10941 8192000000 10899721536 11354972160 1965488624 19.350 100 45 90 2 1987140368 8468784 13182960
18:58:54 25083 8192000000 10903105072 11369107456 1969761456 19.384 100 30 59 1 1989630912 11968992 7900464
18:59:41 49532 8192000000 10898390320 11353112576 1916035168 18.955 97 25 50 0 1935562224 12780880 6746176
19:00:38 69939 8192000000 10897704368 11366985728 1950984800 19.234 99 24 48 2 1977182944 18504640 7693504
19:01:54 62112 8192000000 10875353408 11345985536 1908676320 18.896 97 12 24 0 1923842544 11907696 3258528
19:03:03 34629 8192000000 10891511280 11348262912 1905848000 18.873 97 29 58 0 1924613760 10633616 8132144
19:03:51 64689 8192000000 10876390336 11364274176 1943590544 19.175 99 14 28 1 1964085472 16694560 3800368
19:05:17 61890 8192000000 10890092672 11354812416 1910048416 18.907 97 11 22 0 1928045792 14895344 3102032
19:06:25 42229 8192000000 10916095152 11370254336 1973337712 19.412 100 39 76 2 1996328896 11579840 11411344
19:07:18 31283 8192000000 10921393408 11384680448 1982589056 19.485 100 35 70 0 2004305408 12096688 9619664
19:09:05 94942 8192000000 10895581312 11364376576 1896679600 18.800 96 8 16 1 1912262464 13397376 2185488
19:10:47 108591 8192000000 10893052928 11361632256 1959004784 19.298 100 19 38 1 1983018240 18203008 5810448
19:12:43 81262 8192000000 10887165712 11354243072 1915938048 18.954 97 25 51 2 1933094416 9652992 7503376
19:14:11 25645 8192000000 10878608304 11348877312 1936492448 19.119 98 37 74 2 1955106912 8527728 10086736
19:15:13 49854 8192000000 10868680448 11346624512 1909647568 18.904 97 8 15 0 1918629344 6987104 1994672
19:16:09 43489 8192000000 10877913872 11352985600 1929699504 19.064 98 9 18 0 1940709456 7992864 3017088
19:16:59 46368 8192000000 10873456720 11340312576 1927978432 19.051 98 14 28 2 1941772560 9280336 4513792
19:17:56 70018 8192000000 10864894688 11336192000 1905499120 18.871 97 12 24 0 1922188384 12720784 3968480
19:19:15 79063 8192000000 10854039312 11336179712 1902522464 18.847 98 15 30 0 1918064560 10649920 4892176
19:20:44 31578 8192000000 10843511952 11317137408 1865342720 18.547 96 10 20 1 1878120752 9646736 3131296
19:21:36 43272 8192000000 10858683072 11334053888 1901302528 18.837 98 15 30 0 1917088608 11671936 4114144
19:22:26 59377 8192000000 10845492976 11317407744 1859362496 18.498 96 25 50 3 1879975856 13548704 7064656
19:23:34 53010 8192000000 10842835680 11305316352 1894874720 18.785 99 35 70 1 1919152320 14630144 9647456
19:24:34 33540 8192000000 10852043440 11320258560 1909572048 18.903 99 30 60 1 1926341664 8578320 8191296
19:25:14 34505 8192000000 10852035984 11314872320 1883132832 18.690 97 36 72 1 1902851552 9899264 9819456
19:25:55 38187 8192000000 10865133440 11325014016 1912380640 18.926 99 26 52 1 1930008720 10360736 7267344
19:26:45 28883 8192000000 9358295712 9629822976 508402704 5.843 27 14 26 1 514813808 3100976 3310128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 17-01-2021 19:28:17 to 17-01-2021 19:28:48.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 121 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 17-01-2021 19:28:49 to 17-01-2021 19:28:51.

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          243090
MON$OLDEST_ACTIVE               243721
MON$OLDEST_SNAPSHOT             243721
MON$NEXT_TRANSACTION            243721
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                       2019328
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.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 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 ---
:1011: 
:1012: mscs-test-161.budzdorov.ru    Sun Jan 17 19:27:15 2021
:1013:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1014: 
--- end of diff output ---

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

17.01.21 19:28:52. 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-01-17 19:28:55 No severe PSQL-related problems occured
17.01.21 19:28:56. End of report.