Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 03.01.2021 01:28
Common Performance Final Results
  1. Hardware and OS info
  2. Test configuration
  3. Test Finish details
  4. Test workload details
  5. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score:    as table     as chart
  2. Performance per MINUTE, during test_time phase:    as table     as chart
  3. Performance, DETAILS per units
  4. Memory consumption, metadata cache, attachments activity    as table    as chart
  5. Monitoring data: STATEMENTS activity, as chart
  6. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database statistics was not gathered. Change config parameter 'run_db_statistics' to 1.
  3. Database validation was not performed. Change config parameter 'run_db_validation' to 1.
  4. New in firebird.log while test was run
  5. Final processing of ISQL logs

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17318576 kB
MemAvailable 31423252 kB
Buffers 0 kB
Cached 14379280 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-03 01:27:08
DTS_END                         2021-01-03 01:27:08.2600
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/42374
TRN_ID                          240101
ATT_ID                          690
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: 9210.17 19294 1105221
customer order: creation 174.89 356 20987
customer order: refuse 14.93 352 1791
order to supplier: creation 46.17 1300 5540
order to supplier: removal 3.29 108601 395
invoice (draft): creation 47.27 3457 5672
invoice (draft): removal 53.42 833 6410
invoice accept: apply 42.57 16975 5108
invoice accept: cancel 47.50 794 5700
customer reserve: creation 3857.32 170 462878
customer reserve: removal 4634.65 60 556158
realization accept: apply 83.12 182 9974
realization accept: cancel 76.19 115 9143
payment from customer: creation 58.29 134 6995
payment from customer: removal 5.38 69 645
payment to supplier: creation 49.87 146 5984
payment to supplier: removal 3.18 71 382
service: total inventory turnovers 4.68 998 561
service: total monetary turnovers 6.65 40 798
service: aggregate perf. data 0.80 21919 96
service: refresh index statistics 0.03 229298 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 03-01-2021 01:28:30 to 03-01-2021 01:28:32.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7491
TEST_TIME 2 7423
TEST_TIME 3 5971
TEST_TIME 4 5506
TEST_TIME 5 5313
TEST_TIME 6 5958
TEST_TIME 7 5547
TEST_TIME 8 5771
TEST_TIME 9 5616
TEST_TIME 10 5320
TEST_TIME 11 5319
TEST_TIME 12 5511
TEST_TIME 13 5505
TEST_TIME 14 5892
TEST_TIME 15 6015
TEST_TIME 16 6154
TEST_TIME 17 6404
TEST_TIME 18 6697
TEST_TIME 19 6703
TEST_TIME 20 7313
TEST_TIME 21 7667
TEST_TIME 22 8208
TEST_TIME 23 8513
TEST_TIME 24 9288
TEST_TIME 25 10354
TEST_TIME 26 10634
TEST_TIME 27 10771
TEST_TIME 28 10702
TEST_TIME 29 10515
TEST_TIME 30 10381
TEST_TIME 31 10434
TEST_TIME 32 10305
TEST_TIME 33 10144
TEST_TIME 34 10000
TEST_TIME 35 9861
TEST_TIME 36 9777
TEST_TIME 37 9811
TEST_TIME 38 9845
TEST_TIME 39 9778
TEST_TIME 40 9649
TEST_TIME 41 9520
TEST_TIME 42 9494
TEST_TIME 43 9530
TEST_TIME 44 9412
TEST_TIME 45 9636
TEST_TIME 46 9630
TEST_TIME 47 9569
TEST_TIME 48 9633
TEST_TIME 49 9573
TEST_TIME 50 9716
TEST_TIME 51 9814
TEST_TIME 52 9791
TEST_TIME 53 9724
TEST_TIME 54 9893
TEST_TIME 55 9950
TEST_TIME 56 9888
TEST_TIME 57 9842
TEST_TIME 58 9963
TEST_TIME 59 9836
TEST_TIME 60 9734
TEST_TIME 61 9762
TEST_TIME 62 9693
TEST_TIME 63 9659
TEST_TIME 64 9586
TEST_TIME 65 9483
TEST_TIME 66 9472
TEST_TIME 67 9420
TEST_TIME 68 9423
TEST_TIME 69 9471
TEST_TIME 70 9480
TEST_TIME 71 9532
TEST_TIME 72 9511
TEST_TIME 73 9482
TEST_TIME 74 9550
TEST_TIME 75 9646
TEST_TIME 76 9589
TEST_TIME 77 9613
TEST_TIME 78 9636
TEST_TIME 79 9643
TEST_TIME 80 9705
TEST_TIME 81 9719
TEST_TIME 82 9644
TEST_TIME 83 9553
TEST_TIME 84 9525
TEST_TIME 85 9513
TEST_TIME 86 9465
TEST_TIME 87 9461
TEST_TIME 88 9404
TEST_TIME 89 9460
TEST_TIME 90 9386
TEST_TIME 91 9411
TEST_TIME 92 9368
TEST_TIME 93 9351
TEST_TIME 94 9396
TEST_TIME 95 9423
TEST_TIME 96 9403
TEST_TIME 97 9423
TEST_TIME 98 9522
TEST_TIME 99 9480
TEST_TIME 100 9537
TEST_TIME 101 9516
TEST_TIME 102 9549
TEST_TIME 103 9560
TEST_TIME 104 9566
TEST_TIME 105 9573
TEST_TIME 106 9500
TEST_TIME 107 9454
TEST_TIME 108 9408
TEST_TIME 109 9401
TEST_TIME 110 9404
TEST_TIME 111 9385
TEST_TIME 112 9358
TEST_TIME 113 9338
TEST_TIME 114 9285
TEST_TIME 115 9254
TEST_TIME 116 9290
TEST_TIME 117 9290
TEST_TIME 118 9292
TEST_TIME 119 9280
TEST_TIME 120 9211

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 03-01-2021 01:28:33 to 03-01-2021 01:28:37.

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 1535651 1535651 0 0.00 0 19359 6 0 0
doc_list_biud 1535651 1535651 0 0.00 0 49823 28 0 0
sp_add_invoice_to_stock 5183 5108 75 1.44 38 182124 16975 0 75
sp_cancel_adding_invoice 5700 5700 0 0.00 4 77551 794 0 0
sp_cancel_client_order 1791 1791 0 0.00 4 13547 352 0 0
sp_cancel_customer_reserve 556158 556158 0 0.00 1 49832 60 0 0
sp_cancel_pay_from_customer 645 645 0 0.00 2 2736 69 0 0
sp_cancel_pay_to_supplier 382 382 0 0.00 2 4371 72 0 0
sp_cancel_supplier_invoice 6421 6410 11 0.17 1 19872 833 0 11
sp_cancel_supplier_order 395 395 0 0.00 5 1207626 108601 0 0
sp_cancel_write_off 9143 9143 0 0.00 1 19143 116 0 0
sp_client_order 20987 20987 0 0.00 3 15624 356 0 0
sp_customer_reserve 462878 462878 0 0.00 0 51732 171 0 0
sp_fill_shopping_cart 32198 32198 0 0.00 1 10124 40 0 0
sp_fill_shopping_cart_clo_res 462871 462871 0 0.00 0 16137 13 0 0
sp_get_clo_for_invoice 5101 5101 0 0.00 0 45580 339 0 0
sp_kill_cost_storno 15870 15870 0 0.00 0 9967 54 0 0
sp_kill_qstorno_ret_qs2qd 1128264 1128264 0 0.00 0 49809 33 0 0
sp_kill_qty_storno 594672 594672 0 0.00 0 49822 71 0 0
sp_lock_selected_doc 20896 20896 0 0.00 0 9142 6 0 0
sp_make_cost_storno 28054 28054 0 0.00 0 16154 55 0 0
sp_multiply_rows_for_pdistr 28054 28054 0 0.00 0 8820 29 0 0
sp_multiply_rows_for_qdistr 20987 20987 0 0.00 0 15611 161 0 0
sp_pay_from_customer 6995 6995 0 0.00 4 22643 135 0 0
sp_pay_to_supplier 5984 5984 0 0.00 5 20616 146 0 0
sp_payment_common 12979 12979 0 0.00 1 16143 42 0 0
sp_qd_handle_on_cancel_clo 1791 1791 0 0.00 0 13541 316 0 0
sp_qd_handle_on_invoice_upd_sts 10801 10801 0 0.00 0 26418 319 0 0
sp_qd_handle_on_reserve_upd_sts 9974 9974 0 0.00 0 19628 66 0 0
sp_reserve_write_off 9974 9974 0 0.00 6 19755 182 0 0
sp_supplier_invoice 5672 5672 0 0.00 7 92936 3458 0 0
sp_supplier_order 5540 5540 0 0.00 5 58440 1300 0 0
srv_aggregate_perf_data 96 96 0 0.00 2488 320617 21920 0 0
srv_fill_mon_cache_memory 161 161 0 0.00 1462 101135 32894 0 0
srv_find_qd_qs_mism 1058162 1058162 0 0.00 0 19358 5 0 0
srv_make_invnt_saldo 561 561 0 0.00 41 35291 999 0 0
srv_make_money_saldo 798 798 0 0.00 1 13650 41 0 0
srv_recalc_idx_stat 4 4 0 0.00 124192 298223 229298 0 0
t$perf-abend:sp_add_invoice_to_stock 75 75 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-norm:sp_add_invoice_to_stock 5108 5108 0 0.00 0 15298 167 0 0
t$perf-norm:sp_cancel_adding_invoice 428 428 0 0.00 0 7856 110 0 0
t$perf-norm:sp_cancel_client_order 1791 1791 0 0.00 0 9681 17 0 0
t$perf-norm:sp_cancel_customer_reserve 731 731 0 0.00 0 2283 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 645 645 0 0.00 0 9197 30 0 0
t$perf-norm:sp_cancel_pay_to_supplier 382 382 0 0.00 0 1336 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 457 457 0 0.00 0 1432 21 0 0
t$perf-norm:sp_cancel_supplier_order 395 395 0 0.00 0 23683 1697 0 0
t$perf-norm:sp_cancel_write_off 992 992 0 0.00 0 833 6 0 0
t$perf-norm:sp_client_order 20987 20987 0 0.00 0 14440 19 0 0
t$perf-norm:sp_customer_reserve 1044 1044 0 0.00 0 3397 8 0 0
t$perf-norm:sp_pay_from_customer 6995 6995 0 0.00 0 14553 14 0 0
t$perf-norm:sp_pay_to_supplier 5984 5984 0 0.00 0 14550 16 0 0
t$perf-norm:sp_reserve_write_off 9974 9974 0 0.00 0 9858 16 0 0
t$perf-norm:sp_supplier_invoice 5673 5673 0 0.00 0 10749 23 0 0
t$perf-norm:sp_supplier_order 5540 5540 0 0.00 0 7589 19 0 0
t$perf-norm:srv_aggregate_perf_data 96 96 0 0.00 0 442 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 161 161 0 0.00 0 5066 49 0 0
t$perf-norm:srv_make_invnt_saldo 561 561 0 0.00 0 5125 28 0 0
t$perf-norm:srv_make_money_saldo 798 798 0 0.00 0 2109 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 10350 10200 150 1.44 0 12512 21 0 150
v_all_customers 38090 38090 0 0.00 0 19 1 0 0
v_all_suppliers 30890 30890 0 0.00 0 16 1 0 0
v_all_wares 41972 41972 0 0.00 0 65 1 0 0
v_cancel_adding_invoice 856 856 0 0.00 0 7963 15 0 0
v_cancel_client_order 3582 3582 0 0.00 0 3204 8 0 0
v_cancel_customer_prepayment 1290 1290 0 0.00 0 2702 6 0 0
v_cancel_customer_reserve 1462 1462 0 0.00 0 7597 12 0 0
v_cancel_payment_to_supplier 764 764 0 0.00 0 3599 9 0 0
v_cancel_supplier_invoice 936 914 22 2.35 0 4205 23 0 22
v_cancel_supplier_order 790 790 0 0.00 0 966 5 0 0
v_cancel_write_off 1984 1984 0 0.00 0 3220 16 0 0
v_max_id_clo_ord 5540 5540 0 0.00 0 262 1 0 0
v_max_id_clo_res 1044 1044 0 0.00 0 1833 9 0 0
v_max_id_ord_sup 5672 5672 0 0.00 0 4961 7 0 0
v_max_non_paid_invoice 1751 1751 0 0.00 0 5557 6 0 0
v_max_non_paid_realizn 3756 3756 0 0.00 0 7720 8 0 0
v_min_id_clo_ord 5540 5540 0 0.00 0 2816 6 0 0
v_min_id_clo_res 1044 1044 0 0.00 0 15510 32 0 0
v_min_id_ord_sup 5672 5672 0 0.00 0 2299 5 0 0
v_min_non_paid_invoice 5984 5984 0 0.00 0 10262 25 0 0
v_min_non_paid_realizn 6995 6995 0 0.00 0 11088 28 0 0
v_our_firm 10360 10360 0 0.00 0 35 1 0 0
v_reserve_write_off 19948 19948 0 0.00 0 8574 7 0 0
x_lock_depdocs_on_canc_invoice 11653 11653 0 0.00 0 25099 128 0 0
x_lock_depdocs_on_canc_sup_ord 395 395 0 0.00 0 15759 379 0 0
x_make_qstorno_1000_1200 5540 5540 0 0.00 2 58433 1220 0 0
x_make_qstorno_1200_2000 5672 5672 0 0.00 3 92910 3313 0 0
x_make_qstorno_2100_3300 462878 462878 0 0.00 0 51730 155 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 03-01-2021 01:28:38 to 03-01-2021 01:28:42.

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
22:57:12 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:18 14727 8192000000 10228901056 10541342720 995251536 10.832 78 60 118 2 1016673216 2646048 18775632
22:57:40 25403 8192000000 10324911360 10638290944 1368066368 14.310 100 81 162 0 1399145472 4489088 26590016
22:58:14 30314 8192000000 10375128640 10698133504 1418794688 14.762 100 90 180 1 1454848720 5941072 30112960
22:58:54 21954 8192000000 10402241904 10726998016 1451831760 15.054 100 90 178 1 1487680640 7039024 28809856
22:59:26 29279 8192000000 10423060624 10751139840 1474713536 15.255 100 87 174 2 1510465280 7987504 27764240
23:00:08 35084 8192000000 10453597888 10786615296 1498462576 15.463 100 85 170 1 1534589216 8940736 27185904
23:00:49 15886 8192000000 10470180992 10808422400 1525219616 15.696 100 87 172 1 1561477024 9395920 26861488
23:01:15 15200 8192000000 10492522000 10838573056 1550211232 15.912 100 84 168 1 1585438688 9454512 25772944
23:01:40 22597 8192000000 10531883552 10884096000 1571901616 16.099 100 69 138 0 1602491520 9759872 20830032
23:02:13 6040 8192000000 10549215232 10904051712 1610219232 16.427 100 81 161 0 1645210256 10436272 24554752
23:02:27 11067 8192000000 10572320336 10931945472 1629984320 16.595 100 82 164 1 1665113248 10991120 24137808
23:02:51 13130 8192000000 10598837776 10956951552 1650398736 16.768 100 78 156 1 1684811856 11577296 22835824
23:03:14 12048 8192000000 10616349872 10979487744 1672742048 16.956 100 88 176 1 1711046288 12744640 25559600
23:03:35 8349 8192000000 10631385184 10997202944 1687939808 17.084 100 86 172 2 1726072496 13113616 25019072
23:03:50 7862 8192000000 10638377840 11007291392 1696475344 17.156 100 84 169 0 1734552784 13445776 24631664
23:04:05 6180 8192000000 10656465840 11024486400 1710704928 17.275 100 82 164 0 1748042608 13737104 23600576
23:04:21 6326 8192000000 10668471360 11039256576 1723735568 17.383 100 80 160 0 1760285712 13859040 22691104
23:04:35 4982 8192000000 10681413328 11057782784 1743107296 17.544 100 76 150 3 1776993360 11868128 22017936
23:04:46 5712 8192000000 10681056688 11064586240 1751089312 17.611 100 76 151 2 1785078992 12343136 21646544
23:05:01 4583 8192000000 10705039360 11081322496 1766789488 17.741 100 86 170 2 1803812208 12469760 24552960
23:05:12 4630 8192000000 10717692016 11099570176 1776438640 17.820 100 79 157 0 1810438784 12403696 21596448
23:05:24 5994 8192000000 10728270224 11110084608 1789240688 17.926 100 85 170 3 1826420592 13638816 23541088
23:05:38 4558 8192000000 10732860304 11117428736 1793499840 17.961 100 80 160 1 1829217712 13532336 22185536
23:05:49 3824 8192000000 10742848848 11124527104 1800618640 18.019 100 83 165 1 1837394192 13677920 23097632
23:06:00 5168 8192000000 10740892496 11129761792 1803973552 18.047 100 82 161 1 1839436000 12992160 22470288
23:06:12 2769 8192000000 10755860032 11137019904 1815105984 18.138 100 87 172 2 1852124752 13322144 23696624
23:06:21 2524 8192000000 10769014096 11153743872 1823771232 18.208 100 89 178 1 1862475536 14216112 24488192
23:06:31 4816 8192000000 10767075712 11151597568 1829549104 18.256 100 86 171 0 1866985424 14194800 23241520
23:06:42 3667 8192000000 10779348480 11166859264 1833273904 18.286 100 86 170 0 1871095504 14361152 23460448
23:06:53 2722 8192000000 10778408240 11168772096 1842941888 18.365 100 76 147 0 1876276752 12930912 20403952
23:07:02 2182 8192000000 10792586288 11177414656 1851813168 18.437 100 93 186 1 1890549120 12674672 26061280
23:07:10 1137 8192000000 10796631632 11184177152 1855198368 18.464 100 94 181 2 1894205264 13389648 25617248
23:07:18 1544 8192000000 10804637008 11192578048 1858466496 18.491 100 93 187 1 1897938992 13380224 26092272
23:07:27 1778 8192000000 10800990672 11194290176 1859983680 18.503 100 89 179 3 1899618896 14834800 24800416
23:07:35 1736 8192000000 10807426352 11197095936 1862856032 18.526 100 94 186 0 1902481616 13280320 26345264
23:07:43 1617 8192000000 10813938496 11201949696 1864827792 18.542 100 94 189 0 1905715088 14070480 26816816
23:07:51 1785 8192000000 10819118704 11205857280 1868588656 18.573 100 92 186 0 1907087600 12592400 25906544
23:07:59 13400 8192000000 10804859360 11199549440 1868456848 18.572 100 79 158 2 1902557856 11939328 22161680
23:08:19 1634 8192000000 10800285200 11205750784 1870317568 18.587 100 67 132 2 1900739248 11061520 19360160
23:08:27 1924 8192000000 10797627392 11201757184 1870511904 18.588 100 53 104 1 1895134304 10082496 14539904
23:08:37 6274 8192000000 10787238032 11202162688 1870349024 18.587 100 37 74 0 1888976720 7940048 10687648
23:08:52 5009 8192000000 10789194208 11211935744 1879662880 18.662 100 44 88 2 1899958656 8399424 11896352
23:09:05 6164 8192000000 10786370752 11212754944 1880495616 18.669 100 35 68 1 1897476560 7668800 9312144
23:09:19 8479 8192000000 10786465856 11218259968 1879777648 18.663 100 28 56 2 1895257376 7833472 7646256
23:09:35 8801 8192000000 10781184656 11215425536 1881736400 18.679 100 29 58 3 1897296800 7408928 8151472
23:09:50 33901 8192000000 10787166032 11225550848 1884318304 18.700 100 26 52 2 1897745264 5584512 7842448
23:10:43 21410 8192000000 10831746720 11235864576 1894097008 18.779 100 59 122 0 1916944064 5476656 17370400
23:11:11 6841 8192000000 10815417248 11244716032 1893603376 18.775 100 44 88 1 1919184224 13828688 11752160
23:11:24 5148 8192000000 10811344576 11238690816 1892430304 18.765 100 30 60 1 1907692304 6096384 9165616
23:11:37 9575 8192000000 10802663920 11238756352 1893458160 18.774 100 20 40 2 1904801424 5738608 5604656
23:11:55 5251 8192000000 10807084784 11241889792 1894115264 18.779 100 25 50 1 1906681216 5494352 7071600
23:12:07 5006 8192000000 10814106576 11244576768 1896381632 18.797 100 28 56 2 1910676752 6149808 8145312
23:12:20 6200 8192000000 10816483616 11246923776 1901415424 18.838 100 25 50 1 1914926544 5827984 7683136
23:12:34 15446 8192000000 10803739072 11246321664 1905486800 18.870 100 24 48 1 1918460720 5927984 7045936
23:12:57 6370 8192000000 10824295600 11252875264 1904386784 18.862 100 38 77 1 1923087840 7552416 11148640
23:13:11 7679 8192000000 10816169760 11249434624 1904711984 18.864 100 21 42 0 1916756000 5800032 6243984
23:13:25 8196 8192000000 10822357248 11255967744 1908316800 18.893 100 31 62 0 1925007232 8378560 8311872
23:13:40 12436 8192000000 10825985680 11257344000 1907494272 18.887 100 22 44 1 1919823424 5888240 6440912
23:13:58 7338 8192000000 10818746384 11250626560 1890502960 18.750 99 21 42 3 1902352400 5821952 6027488
23:14:15 34225 8192000000 10813582672 11261980672 1912951824 18.930 100 29 58 0 1926730096 5128816 8649456
23:15:28 32016 8192000000 10828535776 11261861888 1895519104 18.790 99 16 30 3 1905174320 5373280 4281936
23:16:08 6327 8192000000 10804381360 11228246016 1843816240 18.372 96 38 76 3 1861657008 7142624 10698144
23:16:21 5579 8192000000 10826464048 11255263232 1904622832 18.863 100 40 80 1 1924439184 8720016 11096336
23:16:33 6838 8192000000 10831868912 11263557632 1912862032 18.930 100 39 78 3 1931700960 8189184 10649744
23:16:49 4407 8192000000 10829276848 11255648256 1890242656 18.748 99 42 85 2 1908597792 6054080 12301056
23:17:02 5176 8192000000 10809759728 11234258944 1876050768 18.633 99 21 45 1 1887020768 4581408 6388592
23:17:18 6397 8192000000 10813053232 11234271232 1869465200 18.580 99 24 47 2 1882050064 5767744 6817120
23:17:31 3720 8192000000 10787000576 11203063808 1835729968 18.306 98 47 94 1 1854852512 4762000 14360544
23:17:41 8043 8192000000 10751923616 11181252608 1788652288 17.921 96 18 36 0 1799236544 5264112 5320144
23:17:55 10417 8192000000 10785817760 11217182720 1857204096 18.481 99 29 57 3 1871666896 5641664 8821136
23:18:12 9515 8192000000 10783876512 11207688192 1810364656 18.099 96 20 40 2 1821675968 5308784 6002528
23:18:29 14766 8192000000 10766612528 11195195392 1788669968 17.921 96 11 22 1 1797989520 5705056 3614496
23:18:54 5967 8192000000 10732571088 11152801792 1773484784 17.796 96 13 26 0 1782760672 5780608 3495280
23:19:08 6262 8192000000 10727275520 11151233024 1751746960 17.616 95 18 35 2 1762506096 5797488 4961648
23:19:24 57426 8192000000 10722319344 11125223424 1733320816 17.463 95 60 118 2 1757065600 6371456 17373328
23:20:28 18805 8192000000 10718020288 11142049792 1742920880 17.543 96 28 55 2 1756816208 5731200 8164128
23:20:56 5384 8192000000 10731614448 11147837440 1796256832 17.983 99 35 69 5 1813461616 5698608 11506176
23:21:08 6334 8192000000 10682864112 11090927616 1695094176 17.144 95 33 66 1 1710808384 6608400 9105808
23:21:21 6002 8192000000 10718818144 11121725440 1787515552 17.911 100 38 74 2 1805666000 6890976 11259472
23:21:35 4925 8192000000 10717772400 11132223488 1795517104 17.977 100 27 54 0 1808797136 5902480 7377552
23:21:48 7536 8192000000 10743574016 11158855680 1806429248 18.067 99 29 58 0 1821877792 6723488 8725056
23:22:04 8672 8192000000 10745966128 11155283968 1802985024 18.038 99 30 60 2 1817716448 5114944 9616480
23:22:20 5885 8192000000 10740203280 11154137088 1808447520 18.083 99 19 38 2 1819845088 5003040 6394528
23:22:32 4686 8192000000 10737982624 11150221312 1792486288 17.952 98 33 66 0 1809356992 6770848 10099856
23:22:43 4780 8192000000 10761316544 11174313984 1832327520 18.278 100 50 97 3 1858711664 11960160 14423984
23:22:54 9946 8192000000 10753530096 11168018432 1816100944 18.146 99 26 50 1 1828798016 5107040 7590032
23:23:13 9602 8192000000 10764240480 11183603712 1841544992 18.353 100 38 77 2 1858713040 5458288 11709760
23:23:28 10349 8192000000 10761033536 11185086464 1843261344 18.367 100 12 24 0 1852296128 5719856 3314928
23:23:46 7157 8192000000 10780050464 11198205952 1855803456 18.469 100 30 60 0 1870275360 5530672 8941232
23:24:02 69419 8192000000 10769486688 11200098304 1857448224 18.483 100 26 51 2 1870210368 4972176 7789968
23:25:18 5592 8192000000 10779087136 11208863744 1867065472 18.561 100 30 60 2 1882260688 7258928 7936288
23:25:30 4398 8192000000 10777766624 11210571776 1868964880 18.576 100 26 50 3 1882561696 6567968 7028848
23:25:46 6510 8192000000 10801150544 11223298048 1874607408 18.622 100 39 78 1 1897877264 12071104 11198752
23:26:00 5546 8192000000 10784362624 11214376960 1874962672 18.624 100 29 58 1 1889221312 6179184 8079456
23:26:12 7806 8192000000 10792886912 11219894272 1874036480 18.617 100 31 62 0 1891059824 7887024 9136320
23:26:28 7447 8192000000 10796134992 11219660800 1881478016 18.677 100 41 82 2 1899994112 7096560 11419536
23:26:44 10924 8192000000 10784425632 11218673664 1875853760 18.632 100 19 38 0 1886979328 5151312 5974256
23:27:01 12992 8192000000 10815937216 11240050688 1890866912 18.753 100 15 29 0 1899668512 4583824 4217776
23:27:27 3916 8192000000 10842262128 11256061952 1912851888 18.930 100 45 87 3 1931796864 5693552 13251424
23:27:39 9632 8192000000 10857046480 11266887680 1926678192 19.040 100 61 124 2 1952531072 8611152 17241728
23:27:56 23151 8192000000 10864068864 11282624512 1927698544 19.048 100 55 110 1 1953121344 10037408 15385392
23:28:27 6344 8192000000 10864129152 11285827584 1931676400 19.080 100 53 103 1 1955419584 9824960 13918224
23:28:41 6897 8192000000 10864155584 11287650304 1934849920 19.106 100 57 113 1 1960685824 10008848 15827056
23:28:58 56633 8192000000 10858861120 11297345536 1933185952 19.092 100 43 86 2 1954778112 8922960 12669200
23:30:01 3594 8192000000 10868911904 11296243712 1938214048 19.133 100 48 96 0 1960708640 8243920 14250672
23:30:12 32434 8192000000 10863818976 11291459584 1921940656 19.002 99 41 80 1 1941559136 8271824 11346656
23:30:51 26242 8192000000 10883550448 11306303488 1948343008 19.213 100 51 102 0 1974869360 12354464 14171888
23:31:36 18111 8192000000 10885358352 11315806208 1939256448 19.141 99 42 83 0 1966587264 15715328 11615488
23:32:02 14243 8192000000 10901611760 11326328832 1958462688 19.294 100 53 106 2 1990840800 17322688 15055424
23:32:25 18493 8192000000 10900153296 11326201856 1957607424 19.287 100 62 123 0 1993811376 18890336 17313616
23:33:13 5237 8192000000 10914565584 11330895872 1961913488 19.321 100 61 121 2 2001493872 22151536 17428848
23:33:29 19259 8192000000 10895800864 11330088960 1951479296 19.238 99 47 93 2 1984193648 18118112 14596240
23:33:55 15141 8192000000 10895178352 11334479872 1966458352 19.357 100 49 98 0 2000080496 18849152 14772992
23:34:19 6929 8192000000 10916719760 11342286848 1970062656 19.386 100 49 97 2 2005228480 19756432 15409392
23:34:39 19480 8192000000 10927730000 11358420992 1977021680 19.441 100 55 110 2 2015212976 21097248 17094048
23:35:08 12122 8192000000 10929641584 11364888576 1981409760 19.476 100 46 92 1 2020083792 24605408 14068624
23:35:29 12150 8192000000 10928217120 11364315136 1983357152 19.491 100 35 69 1 2017751520 22661936 11732432
23:35:49 15234 8192000000 10940221776 11375890432 1990655600 19.549 100 45 88 0 2028770304 24490448 13624256
23:36:14 36758 8192000000 10915033120 11362246656 1950724336 19.232 98 31 62 1 1986815296 25725216 10365744
23:37:09 19278 8192000000 10918594736 11364294656 1978269696 19.451 100 32 64 1 2014338384 25652704 10415984
23:37:37 13826 8192000000 10931055616 11361931264 1969174992 19.379 99 45 90 0 2012621760 29492000 13954768
23:38:01 23141 8192000000 10951877616 11389038592 1991218224 19.553 100 46 92 1 2039716944 34106512 14392208
23:38:32 4369 8192000000 10956836400 11391049728 1980117008 19.466 99 52 104 1 2031256352 34940704 16198640
23:38:47 5928 8192000000 10956935200 11381911552 1974041152 19.417 99 61 122 0 2029192176 36176416 18974608
23:39:03 9084 8192000000 10958941472 11386298368 1973907360 19.416 99 56 108 3 2026151632 35930256 16314016
23:39:20 2662 8192000000 10935094736 11353804800 1966669456 19.359 99 63 125 0 2020629504 34837040 19123008
23:39:30 3301 8192000000 10963630960 11381071872 1988285584 19.530 100 64 127 0 2041413792 34272592 18855616
23:39:41 5648 8192000000 10969547264 11389665280 1994192560 19.577 100 68 137 0 2052201648 37635360 20373728
23:39:55 2459 8192000000 10975928384 11393196032 1997408944 19.602 100 75 151 1 2057863872 37356912 23098016
23:40:05 2370 8192000000 10972175392 11389968384 1992703808 19.565 100 71 143 0 2052286000 38169376 21412816
23:40:14 6269 8192000000 10955684032 11370860544 1973846240 19.416 99 83 166 0 2039560528 40221568 25492720
23:40:33 4676 8192000000 10971460720 11383128064 1988324192 19.531 100 79 158 3 2054149408 41463584 24361632
23:40:44 3768 8192000000 10986979744 11393961984 1996370096 19.594 100 80 160 1 2063577360 42953808 24253456
23:40:55 5424 8192000000 10979419280 11395829760 1997352416 19.602 100 77 154 0 2066083936 45005424 23726096
23:41:07 3468 8192000000 10989437888 11404529664 2001444080 19.634 100 79 159 1 2070629216 44597920 24587216
23:41:18 5690 8192000000 10982061792 11407986688 2002602640 19.643 100 63 126 2 2066532192 44470624 19458928
23:41:32 13494 8192000000 10982718256 11404701696 1999747312 19.621 100 72 145 1 2067496224 45355264 22393648
23:41:56 3648 8192000000 10975282976 11402752000 1998067184 19.607 100 64 127 0 2061557184 43363968 20126032
23:42:09 3557 8192000000 10979772208 11400798208 2000178048 19.624 100 80 161 0 2074165648 49090128 24897472
23:42:22 2334 8192000000 10989028864 11411226624 1999875072 19.622 100 72 144 3 2067861712 45026144 22960496
23:42:31 4173 8192000000 10978205152 11403513856 1999087456 19.616 100 70 140 3 2066418336 45685984 21644896
23:42:42 4068 8192000000 10974099536 11387297792 1984024240 19.497 99 78 154 0 2054923040 47311840 23586960
23:42:53 8061 8192000000 10981352528 11405848576 1997812624 19.605 100 71 142 0 2067636672 48140896 21683152
23:43:09 1832 8192000000 10987999312 11414622208 2006718256 19.676 100 74 145 0 2077697472 48640912 22338304
23:43:18 2786 8192000000 10995680912 11411943424 2004444336 19.658 100 81 161 1 2075762560 46632720 24685504
23:43:28 3652 8192000000 10979083088 11387953152 1987483248 19.524 99 90 179 3 2061117920 46201088 27433584
23:43:39 4078 8192000000 10989332144 11402301440 1997414672 19.602 100 83 166 3 2070528448 46952064 26161712
23:43:52 7300 8192000000 10985897296 11404914688 1997174432 19.600 100 75 151 0 2069996912 49535520 23286960
23:44:07 3602 8192000000 10986916320 11401084928 1984037680 19.497 99 81 159 1 2057339824 49270992 24031152
23:44:18 1861 8192000000 10996783024 11406921728 2001730144 19.636 100 83 164 2 2077065168 49652688 25682336
23:44:27 3348 8192000000 10986278768 11393470464 1985903760 19.511 100 84 166 2 2063130320 51284240 25942320
23:44:38 3088 8192000000 10973291872 11384991744 1969810272 19.384 99 75 150 1 2048073104 54868960 23393872
23:44:50 2886 8192000000 10989060880 11400699904 1989129296 19.537 100 81 161 0 2069872656 55588816 25154544
23:45:00 2919 8192000000 10964097136 11368886272 1945521408 19.191 98 92 180 0 2028044832 55571296 26952128
23:45:11 2921 8192000000 10961836496 11373568000 1956880736 19.281 99 78 156 0 2037377680 55977200 24519744
23:45:21 1486 8192000000 10972601328 11386228736 1974098224 19.418 100 80 161 0 2055239200 55896320 25244656
23:45:31 1702 8192000000 10973334240 11380588544 1967842320 19.368 100 87 171 1 2049922336 56331248 25748768
23:45:46 2678 8192000000 10971934352 11384733696 1970809456 19.392 100 89 179 2 2056760976 58057568 27893952
23:45:56 2936 8192000000 10954798928 11377250304 1961776528 19.320 100 61 122 0 2040528896 58961936 19790432
23:46:09 7101 8192000000 10943213536 11358277632 1941399248 19.158 99 60 119 0 2021368960 59880752 20088960
23:46:23 2221 8192000000 10972703440 11384926208 1965890688 19.353 100 85 170 1 2053111024 59428704 27791632
23:46:36 1667 8192000000 10972753408 11385401344 1966678304 19.359 100 86 171 1 2056280784 62952240 26650240
23:46:46 1772 8192000000 10971978592 11387031552 1972339248 19.404 100 81 159 0 2061306256 63346304 25620704
23:46:57 4577 8192000000 10985507312 11393667072 1969833664 19.384 100 78 156 1 2060278640 65225200 25219776
23:47:08 3709 8192000000 10985769776 11388928000 1964753984 19.344 100 87 173 1 2059227616 67029776 27443856
23:47:22 1461 8192000000 10960281056 11369644032 1940944208 19.154 99 82 164 2 2038454192 70679056 26830928
23:47:32 2729 8192000000 10974257104 11386437632 1958598064 19.295 100 85 170 1 2056517088 70007312 27911712
23:47:42 4137 8192000000 10946391872 11379519488 1953448080 19.254 100 53 106 1 2036338032 65193472 17696480
23:48:04 10684 8192000000 10935568048 11362885632 1929174464 19.060 99 41 82 2 2006227920 62542960 14510496
23:48:27 6132 8192000000 10945588752 11373367296 1940633088 19.152 100 57 115 1 2027509536 67565456 19310992
23:48:40 12614 8192000000 10918758368 11350343680 1925889856 19.034 99 55 110 1 2007948192 62572992 19485344
23:48:59 15268 8192000000 10909423664 11345268736 1899900448 18.825 98 33 66 1 1972671952 60713584 12057920
23:49:21 24636 8192000000 10883701744 11331940352 1874289568 18.619 98 27 54 1 1944946368 60632528 10024272
23:50:01 13844 8192000000 10888802752 11332292608 1891858368 18.761 99 30 60 0 1965441328 62609440 10973520
23:50:24 16765 8192000000 10885222608 11332452352 1886980128 18.721 99 24 46 3 1954251232 58717680 8553424
23:50:48 18185 8192000000 10902917152 11338534912 1913682512 18.936 100 31 62 1 1986325408 61933264 10709632
23:51:13 21972 8192000000 10888745792 11348664320 1915639536 18.952 100 27 54 0 1993319408 67970896 9708976
23:52:08 46380 8192000000 10886264240 11332231168 1920507888 18.991 100 29 58 1 1966636352 37226400 8902064
23:53:02 24991 8192000000 10875574752 11332173824 1931720160 19.081 100 24 45 1 1957162112 18404256 7037696
23:53:44 43488 8192000000 10847352640 11306774528 1878201136 18.651 97 16 32 0 1894422416 11164976 5056304
23:55:34 66981 8192000000 10876231664 11324268544 1927853824 19.050 99 26 50 0 1943618464 8004944 7759696
23:56:47 32071 8192000000 10885240272 11332644864 1936944704 19.122 99 37 77 2 1955181872 6954560 11282608
23:57:37 56651 8192000000 10880388736 11339636736 1912867568 18.930 97 31 64 0 1930214192 8472352 8874272
23:58:41 79782 8192000000 10900431520 11345657856 1923908912 19.018 98 17 34 3 1938857568 10024720 4923936
00:00:08 98863 8192000000 10900799040 11337895936 1952274544 19.245 99 32 61 0 1966968880 5945392 8748944
00:01:55 49662 8192000000 10861158912 11318030336 1905089840 18.867 97 27 54 0 1924183344 11494912 7598592
00:02:54 32170 8192000000 10881862880 11339554816 1952123280 19.243 100 18 36 1 1967336016 9565264 5647472
00:03:36 11348 8192000000 10892951968 11348500480 1961984736 19.322 100 30 60 0 1979779616 9320528 8474352
00:03:59 30850 8192000000 10923703664 11362250752 1969773264 19.384 100 24 46 1 1986022576 9148000 7101312
00:04:37 60158 8192000000 10892813872 11371421696 1975120768 19.426 100 15 30 1 1987050208 7776064 4153376
00:05:44 19717 8192000000 10876985744 11344920576 1913202512 18.932 97 7 14 1 1921617520 6996432 1418576
00:06:10 21743 8192000000 10886186368 11352231936 1962356768 19.325 100 20 39 0 1976065424 9097392 4611264
00:06:45 64361 8192000000 10904554048 11364737024 1962171488 19.323 99 28 56 0 1981999600 11016592 8811520
00:07:56 55780 8192000000 10890100000 11347472384 1907804944 18.889 96 19 38 1 1926045696 12524880 5715872
00:09:11 34925 8192000000 10898726848 11369562112 1970805056 19.392 100 17 34 0 1993846400 17502176 5539168
00:10:02 101134 8192000000 10907454480 11379113984 1969577168 19.382 100 13 26 1 1994510384 20230560 4702656
00:11:54 83660 8192000000 10883653168 11385438208 1939089552 19.139 98 11 22 0 1957409904 14862592 3457760
00:13:31 39376 8192000000 10924080960 11379077120 1971467648 19.397 100 13 27 0 1981775312 7072384 3235280
00:14:26 68255 8192000000 10912231856 11389358080 1930771680 19.073 97 30 60 0 1955342176 16242096 8328400
00:15:42 91491 8192000000 10924209600 11383898112 1947751072 19.209 98 13 24 2 1965338800 14084288 3503440
00:17:19 32738 8192000000 10942282240 11389304832 1993219088 19.569 100 19 36 3 2008195760 9918896 5057776
00:18:13 100026 8192000000 10930143456 11405688832 1956669888 19.280 98 11 22 0 1970838496 10960000 3208608
00:20:00 67350 8192000000 10944194960 11388612608 1947327744 19.205 97 31 62 0 1971697888 15448064 8922080
00:21:16 57136 8192000000 10890499536 11359985664 1894970912 18.786 95 23 46 2 1921670112 20418160 6281040
00:22:29 78936 8192000000 10878638176 11336593408 1876997888 18.641 95 24 48 1 1896848656 13190912 6659856
00:23:58 67570 8192000000 10930213952 11396562944 1978819664 19.455 100 28 56 0 2002608080 15831856 7956560
00:25:14 75029 8192000000 10906636992 11396833280 1927140016 19.044 97 18 36 0 1955116160 23103440 4872704
00:26:45 51106 8192000000 10894856160 11355525120 1943629568 19.176 98 44 86 2 1965575440 10333712 11612160
00:27:48 58252 8192000000 10900870256 11362877440 1904174352 18.860 97 17 34 0 1923093072 14651872 4266848
00:28:56 39641 8192000000 10907299824 11377729536 1968473536 19.373 100 33 66 3 1994415216 16184000 9757680
00:29:44 29489 8192000000 10892816848 11341451264 1950843104 19.233 100 38 76 1 1973614224 12054224 10716896
00:30:39 32811 8192000000 10881265664 11349663744 1956443072 19.278 100 13 26 1 1972420128 12462176 3514880
00:31:41 52639 8192000000 10868855808 11334758400 1916794240 18.961 98 8 16 0 1932797712 13602656 2400816
00:32:39 69271 8192000000 10857439680 11338199040 1884192592 18.699 97 8 16 0 1900934672 14347296 2394784
00:34:13 55738 8192000000 10858305744 11336314880 1905933264 18.874 98 17 34 1 1929032112 18009936 5088912
00:35:22 52013 8192000000 10863408464 11332521984 1913005488 18.931 98 24 48 1 1933394288 13502048 6886752
00:36:31 50775 8192000000 10873471936 11340988416 1926274144 19.037 99 32 64 0 1950042080 14213808 9554128
00:37:31 69664 8192000000 10854985152 11329372160 1867508192 18.564 96 14 28 1 1890114288 18753152 3852944
00:38:50 45965 8192000000 10881134848 11342462976 1932318272 19.085 99 14 28 1 1945003472 8713616 3971584
00:39:43 63626 8192000000 10893887232 11354685440 1905966000 18.874 97 21 42 3 1924579440 12006544 6606896
00:40:53 54312 8192000000 10893769648 11363123200 1942265392 19.165 99 17 35 1 1965286016 17797072 5223552
00:41:54 49726 8192000000 10882741072 11369078784 1955689888 19.272 100 13 26 1 1974260080 14573904 3996288
00:42:50 35938 8192000000 10882291408 11336101888 1905148656 18.868 97 33 66 1 1922557376 7767712 9641008
00:43:34 36708 8192000000 10889233616 11349573632 1936461824 19.119 99 32 64 1 1955268960 9599504 9207632
00:44:28 92411 8192000000 10876117472 11353526272 1898001248 18.810 97 11 22 0 1912810240 11939024 2869968
00:46:07 79468 8192000000 10916598416 11368382464 1961707152 19.320 100 19 38 0 1984663344 17427024 5529168
00:48:01 71498 8192000000 10895256208 11362115584 1929052784 19.059 98 23 46 1 1944363248 9128336 6182128
00:49:18 82832 8192000000 10905472464 11353772032 1931109232 19.076 98 45 91 2 1954177296 10288592 12779472
00:50:59 72205 8192000000 10874774816 11330576384 1906737808 18.880 97 33 66 1 1926814368 10446272 9630288
00:52:18 13936 8192000000 10878137472 11336192000 1941500944 19.159 100 38 76 1 1963286864 11523200 10262720
00:52:40 35045 8192000000 10866702448 11335135232 1910852240 18.913 98 30 60 1 1931506784 12316400 8338144
00:54:17 52692 8192000000 10860838496 11338547200 1922123440 19.004 99 10 20 2 1935817792 10806128 2888224
00:55:21 81456 8192000000 10875059568 11356856320 1956671072 19.280 100 13 26 1 1972566704 12173584 3722048
00:56:56 55563 8192000000 10870990240 11347529728 1922608832 19.008 98 9 18 1 1937116000 11932032 2575136
00:59:14 36782 8192000000 10885581520 11352440832 1873469376 18.612 95 12 25 1 1887175808 10806096 2900336
00:59:57 50686 8192000000 10875523376 11343269888 1899161568 18.820 97 21 42 1 1918114416 12642944 6309904
01:01:04 80450 8192000000 10868068832 11355627520 1914999696 18.947 98 16 32 0 1939315120 19593840 4721584
01:02:38 43783 8192000000 10920827072 11376144384 1973477696 19.413 100 26 52 2 1994813632 13396000 7939936
01:03:30 32155 8192000000 10924494544 11391881216 1984234032 19.498 100 35 70 0 2008886592 13951920 10700640
01:04:20 78049 8192000000 10916981936 11405701120 1958619232 19.295 99 7 14 0 1984198256 22672384 2906640
01:05:44 34183 8192000000 10936310864 11388067840 1987941488 19.528 100 30 60 0 2005935824 9242320 8752016
01:06:26 70633 8192000000 10886031904 11367247872 1916234624 18.957 97 15 30 1 1932649568 11878384 4536560
01:07:55 58321 8192000000 10913528768 11381092352 1961808336 19.320 99 28 56 1 1980459952 11506464 7145152
01:09:00 77858 8192000000 10895074752 11381628928 1897274080 18.804 96 11 22 0 1915937056 15616320 3046656
01:10:24 75984 8192000000 10904373552 11375079424 1933395616 19.094 98 23 46 1 1954670480 14856192 6418672
01:11:47 88917 8192000000 10891618976 11370700800 1926933968 19.042 97 23 46 1 1948331248 15010112 6387168
01:14:01 75251 8192000000 10908126640 11369410560 1948537872 19.215 98 33 65 1 1964701632 6446992 9716768
01:15:23 69889 8192000000 10884679408 11361976320 1941662352 19.160 98 27 54 1 1959104896 9667344 7775200
01:16:39 28689 8192000000 10894513888 11363065856 1952000624 19.242 99 25 50 1 1968310048 8997456 7311968
01:17:24 59748 8192000000 10871807648 11350487040 1939428304 19.142 99 16 32 1 1952926304 8710800 4787200
01:18:30 23477 8192000000 10861336944 11343130624 1935522032 19.111 99 5 10 0 1945698960 8964992 1211936
01:19:00 21880 8192000000 10871269232 11349299200 1935240304 19.109 99 6 12 0 1944978880 8364096 1374480
01:19:33 80221 8192000000 10872808224 11341553664 1895676832 18.792 97 7 14 0 1904815152 6884192 2254128
01:20:59 58410 8192000000 10881382560 11351625728 1958874992 19.297 100 14 28 0 1974486192 11340240 4270960
01:22:22 75209 8192000000 10869581200 11353694208 1924384784 19.022 98 12 24 1 1939738592 11627152 3726656
01:23:58 66746 8192000000 10877603920 11342434304 1856138864 18.472 95 17 34 0 1876398960 15421264 4838832
01:25:45 33338 8192000000 10863378640 11321262080 1879270400 18.659 97 15 30 0 1894294640 10574064 4450176
01:26:29 43327 8192000000 10239698832 10641285120 1325051264 13.922 68 15 30 0 1338930640 9539488 4339888

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 03-01-2021 01:28:44 to 03-01-2021 01:29:15.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 75 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 03-01-2021 01:29:16 to 03-01-2021 01:29:18.

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          237021
MON$OLDEST_ACTIVE               240632
MON$OLDEST_SNAPSHOT             240632
MON$NEXT_TRANSACTION            240632
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                       2031840
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 ---
:257: 
:258: mscs-test-161.budzdorov.ru    Sun Jan  3 01:27:16 2021
:259:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:260: 
:261: 
:262: mscs-test-161.budzdorov.ru    Sun Jan  3 01:27:16 2021
:263:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:264: 
:265: 
:266: mscs-test-161.budzdorov.ru    Sun Jan  3 01:27:21 2021
:267:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:268: 
:269: 
:270: mscs-test-161.budzdorov.ru    Sun Jan  3 01:27:23 2021
:271:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:272: 
--- end of diff output ---

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

03.01.21 01:29:19. 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-03 01:29:21 No severe PSQL-related problems occured
03.01.21 01:29:23. End of report.