Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 13.01.2021 01: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 17251540 kB
MemAvailable 31331176 kB
Buffers 0 kB
Cached 14412248 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-13 01:27:12
DTS_END                         2021-01-13 01:27:12.7350
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/57624
TRN_ID                          238497
ATT_ID                          697
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: 9000.41 22748 1080049
customer order: creation 173.01 368 20761
customer order: refuse 14.84 374 1781
order to supplier: creation 45.93 1248 5511
order to supplier: removal 3.43 100393 412
invoice (draft): creation 46.12 3690 5534
invoice (draft): removal 51.83 797 6220
invoice accept: apply 40.98 17914 4918
invoice accept: cancel 46.71 753 5605
customer reserve: creation 3735.16 178 448219
customer reserve: removal 4545.09 60 545411
realization accept: apply 84.70 178 10164
realization accept: cancel 84.22 109 10106
payment from customer: creation 58.67 120 7040
payment from customer: removal 5.83 99 700
payment to supplier: creation 48.80 123 5856
payment to supplier: removal 3.52 117 422
service: total inventory turnovers 4.21 1347 505
service: total monetary turnovers 6.49 36 779
service: aggregate perf. data 0.84 19684 101
service: refresh index statistics 0.03 307368 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 13-01-2021 01:28:23 to 13-01-2021 01:28:25.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2871
TEST_TIME 2 3256
TEST_TIME 3 4418
TEST_TIME 4 4430
TEST_TIME 5 4748
TEST_TIME 6 4907
TEST_TIME 7 5657
TEST_TIME 8 5864
TEST_TIME 9 6321
TEST_TIME 10 6390
TEST_TIME 11 6849
TEST_TIME 12 7259
TEST_TIME 13 7854
TEST_TIME 14 7758
TEST_TIME 15 7631
TEST_TIME 16 7592
TEST_TIME 17 8007
TEST_TIME 18 8274
TEST_TIME 19 8845
TEST_TIME 20 8973
TEST_TIME 21 9062
TEST_TIME 22 9122
TEST_TIME 23 9288
TEST_TIME 24 9156
TEST_TIME 25 9599
TEST_TIME 26 9873
TEST_TIME 27 10411
TEST_TIME 28 11261
TEST_TIME 29 10904
TEST_TIME 30 10663
TEST_TIME 31 11011
TEST_TIME 32 10700
TEST_TIME 33 10599
TEST_TIME 34 10491
TEST_TIME 35 10309
TEST_TIME 36 10182
TEST_TIME 37 10158
TEST_TIME 38 10129
TEST_TIME 39 10037
TEST_TIME 40 9889
TEST_TIME 41 9790
TEST_TIME 42 9702
TEST_TIME 43 9704
TEST_TIME 44 9737
TEST_TIME 45 9656
TEST_TIME 46 9635
TEST_TIME 47 9605
TEST_TIME 48 9615
TEST_TIME 49 9470
TEST_TIME 50 9367
TEST_TIME 51 9237
TEST_TIME 52 9280
TEST_TIME 53 9240
TEST_TIME 54 9163
TEST_TIME 55 9095
TEST_TIME 56 9034
TEST_TIME 57 9107
TEST_TIME 58 9051
TEST_TIME 59 9091
TEST_TIME 60 9132
TEST_TIME 61 9179
TEST_TIME 62 9190
TEST_TIME 63 9256
TEST_TIME 64 9236
TEST_TIME 65 9369
TEST_TIME 66 9386
TEST_TIME 67 9320
TEST_TIME 68 9468
TEST_TIME 69 9477
TEST_TIME 70 9510
TEST_TIME 71 9517
TEST_TIME 72 9518
TEST_TIME 73 9391
TEST_TIME 74 9417
TEST_TIME 75 9372
TEST_TIME 76 9292
TEST_TIME 77 9274
TEST_TIME 78 9221
TEST_TIME 79 9253
TEST_TIME 80 9209
TEST_TIME 81 9184
TEST_TIME 82 9182
TEST_TIME 83 9141
TEST_TIME 84 9085
TEST_TIME 85 9159
TEST_TIME 86 9135
TEST_TIME 87 9110
TEST_TIME 88 9093
TEST_TIME 89 9110
TEST_TIME 90 9120
TEST_TIME 91 9195
TEST_TIME 92 9198
TEST_TIME 93 9190
TEST_TIME 94 9256
TEST_TIME 95 9242
TEST_TIME 96 9199
TEST_TIME 97 9297
TEST_TIME 98 9279
TEST_TIME 99 9245
TEST_TIME 100 9339
TEST_TIME 101 9336
TEST_TIME 102 9259
TEST_TIME 103 9224
TEST_TIME 104 9170
TEST_TIME 105 9183
TEST_TIME 106 9171
TEST_TIME 107 9131
TEST_TIME 108 9103
TEST_TIME 109 9147
TEST_TIME 110 9094
TEST_TIME 111 9058
TEST_TIME 112 9068
TEST_TIME 113 9058
TEST_TIME 114 9017
TEST_TIME 115 9001
TEST_TIME 116 8977
TEST_TIME 117 9053
TEST_TIME 118 9045
TEST_TIME 119 9030
TEST_TIME 120 9006

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 13-01-2021 01:28:27 to 13-01-2021 01:28:30.

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 1496582 1496582 0 0.00 0 18822 6 0 0
doc_list_biud 1496582 1496582 0 0.00 0 84037 28 0 0
sp_add_invoice_to_stock 5030 4918 112 2.22 30 191821 17915 0 112
sp_cancel_adding_invoice 5605 5605 0 0.00 5 101781 753 0 0
sp_cancel_client_order 1781 1781 0 0.00 4 17111 374 0 0
sp_cancel_customer_reserve 545411 545411 0 0.00 1 26662 60 0 0
sp_cancel_pay_from_customer 700 700 0 0.00 2 6565 100 0 0
sp_cancel_pay_to_supplier 422 422 0 0.00 3 13659 118 0 0
sp_cancel_supplier_invoice 6232 6220 12 0.19 2 84039 797 0 12
sp_cancel_supplier_order 412 412 0 0.00 9 997095 100394 0 0
sp_cancel_write_off 10106 10106 0 0.00 1 12008 109 0 0
sp_client_order 20761 20761 0 0.00 3 32387 369 0 0
sp_customer_reserve 448219 448219 0 0.00 0 59154 178 0 0
sp_fill_shopping_cart 31786 31786 0 0.00 1 41432 45 0 0
sp_fill_shopping_cart_clo_res 448214 448214 0 0.00 0 18550 14 0 0
sp_get_clo_for_invoice 4907 4907 0 0.00 0 28945 375 0 0
sp_kill_cost_storno 16833 16833 0 0.00 0 18814 57 0 0
sp_kill_qstorno_ret_qs2qd 1107560 1107560 0 0.00 0 84036 33 0 0
sp_kill_qty_storno 584604 584604 0 0.00 0 84036 71 0 0
sp_lock_selected_doc 20860 20860 0 0.00 0 7960 5 0 0
sp_make_cost_storno 27965 27965 0 0.00 0 11565 52 0 0
sp_multiply_rows_for_pdistr 27965 27965 0 0.00 0 11676 29 0 0
sp_multiply_rows_for_qdistr 20761 20761 0 0.00 0 24766 169 0 0
sp_pay_from_customer 7040 7040 0 0.00 4 12592 120 0 0
sp_pay_to_supplier 5856 5856 0 0.00 5 17173 124 0 0
sp_payment_common 12896 12896 0 0.00 1 17150 36 0 0
sp_qd_handle_on_cancel_clo 1781 1781 0 0.00 0 17104 345 0 0
sp_qd_handle_on_invoice_upd_sts 10510 10510 0 0.00 0 74345 338 0 0
sp_qd_handle_on_reserve_upd_sts 10164 10164 0 0.00 0 22448 71 0 0
sp_reserve_write_off 10164 10164 0 0.00 6 22468 179 0 0
sp_supplier_invoice 5534 5534 0 0.00 6 95844 3691 0 0
sp_supplier_order 5511 5511 0 0.00 5 33746 1248 0 0
srv_aggregate_perf_data 101 101 0 0.00 2538 335700 19684 0 0
srv_fill_mon_cache_memory 152 152 0 0.00 1570 169498 35057 0 0
srv_find_qd_qs_mism 1033594 1033594 0 0.00 0 17451 5 0 0
srv_make_invnt_saldo 505 505 0 0.00 58 131770 1348 0 0
srv_make_money_saldo 779 779 0 0.00 0 10058 37 0 0
srv_recalc_idx_stat 4 4 0 0.00 196582 490194 307368 0 0
t$perf-abend:sp_add_invoice_to_stock 112 112 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4918 4918 0 0.00 0 9869 153 0 0
t$perf-norm:sp_cancel_adding_invoice 400 400 0 0.00 0 6576 111 0 0
t$perf-norm:sp_cancel_client_order 1781 1781 0 0.00 0 5420 14 0 0
t$perf-norm:sp_cancel_customer_reserve 678 678 0 0.00 0 3169 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 700 700 0 0.00 0 5936 17 0 0
t$perf-norm:sp_cancel_pay_to_supplier 422 422 0 0.00 0 760 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 398 398 0 0.00 0 4363 29 0 0
t$perf-norm:sp_cancel_supplier_order 412 412 0 0.00 0 19293 1541 0 0
t$perf-norm:sp_cancel_write_off 1002 1002 0 0.00 0 2038 8 0 0
t$perf-norm:sp_client_order 20761 20761 0 0.00 0 14807 16 0 0
t$perf-norm:sp_customer_reserve 1026 1026 0 0.00 0 688 3 0 0
t$perf-norm:sp_pay_from_customer 7040 7040 0 0.00 0 11027 10 0 0
t$perf-norm:sp_pay_to_supplier 5856 5856 0 0.00 0 4760 8 0 0
t$perf-norm:sp_reserve_write_off 10164 10164 0 0.00 0 12230 12 0 0
t$perf-norm:sp_supplier_invoice 5534 5534 0 0.00 0 6906 24 0 0
t$perf-norm:sp_supplier_order 5511 5511 0 0.00 0 5539 15 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 309 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 152 152 0 0.00 0 602 18 0 0
t$perf-norm:srv_make_invnt_saldo 505 505 0 0.00 0 2233 28 0 0
t$perf-norm:srv_make_money_saldo 779 779 0 0.00 0 513 9 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 13 5 0 0
v_add_invoice_to_stock 10030 9806 224 2.23 0 10375 18 0 224
v_all_customers 37824 37824 0 0.00 0 18 1 0 0
v_all_suppliers 30138 30138 0 0.00 0 20 1 0 0
v_all_wares 41522 41522 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 800 800 0 0.00 0 444 7 0 0
v_cancel_client_order 3562 3562 0 0.00 0 3255 7 0 0
v_cancel_customer_prepayment 1400 1400 0 0.00 0 2643 9 0 0
v_cancel_customer_reserve 1356 1356 0 0.00 0 1651 4 0 0
v_cancel_payment_to_supplier 844 844 0 0.00 0 1516 5 0 0
v_cancel_supplier_invoice 820 796 24 2.92 0 1651 18 0 24
v_cancel_supplier_order 824 824 0 0.00 0 1703 5 0 0
v_cancel_write_off 2004 2004 0 0.00 0 859 11 0 0
v_max_id_clo_ord 5511 5511 0 0.00 0 2488 1 0 0
v_max_id_clo_res 1026 1026 0 0.00 0 2582 25 0 0
v_max_id_ord_sup 5514 5514 0 0.00 0 3678 3 0 0
v_max_non_paid_invoice 1812 1812 0 0.00 0 8061 7 0 0
v_max_non_paid_realizn 3732 3732 0 0.00 0 3282 6 0 0
v_min_id_clo_ord 5511 5511 0 0.00 0 6392 9 0 0
v_min_id_clo_res 1026 1026 0 0.00 0 1432 5 0 0
v_min_id_ord_sup 5514 5514 0 0.00 0 8446 10 0 0
v_min_non_paid_invoice 5856 5856 0 0.00 0 17146 24 0 0
v_min_non_paid_realizn 7040 7040 0 0.00 0 9169 22 0 0
v_our_firm 10314 10314 0 0.00 0 14 1 0 0
v_reserve_write_off 20328 20328 0 0.00 0 3243 4 0 0
x_lock_depdocs_on_canc_invoice 11427 11427 0 0.00 0 18516 111 0 0
x_lock_depdocs_on_canc_sup_ord 412 412 0 0.00 0 6183 357 0 0
x_make_qstorno_1000_1200 5511 5511 0 0.00 2 33728 1166 0 0
x_make_qstorno_1200_2000 5534 5534 0 0.00 2 95831 3521 0 0
x_make_qstorno_2100_3300 448219 448219 0 0.00 0 59152 161 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 13-01-2021 01:28:31 to 13-01-2021 01:28:35.

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:16 4 8192000000 8799864528 8810889216 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:23 14966 8192000000 10210171280 10511814656 973752576 10.623 78 57 111 1 995206160 2627664 18825920
22:57:44 27795 8192000000 10325876528 10644213760 1381313328 14.428 100 86 172 0 1413492416 4403744 27775344
22:58:19 23309 8192000000 10375980592 10701029376 1424690928 14.814 100 79 158 0 1454904464 5639440 24574096
22:58:58 24446 8192000000 10417147440 10746097664 1464729712 15.167 100 83 166 0 1497367808 6684208 25953888
22:59:35 30418 8192000000 10433773280 10768760832 1492973168 15.415 100 91 180 1 1529411152 7889504 28548480
23:00:13 20757 8192000000 10459391664 10795024384 1507080736 15.538 100 90 180 1 1544556800 8864768 28611296
23:00:45 23348 8192000000 10485004352 10825469952 1537515152 15.802 100 88 176 0 1574705248 9534896 27655200
23:01:20 16242 8192000000 10503505680 10850570240 1558588048 15.984 100 84 170 1 1594488080 9866160 26033872
23:01:45 17729 8192000000 10514543648 10865033216 1575720096 16.131 100 84 168 0 1611328256 10188560 25419600
23:02:10 6511 8192000000 10523433376 10879102976 1590792656 16.261 100 78 156 0 1624171296 10238096 23140544
23:02:34 13056 8192000000 10558055776 10914590720 1616493024 16.480 100 84 168 1 1651832912 10773456 24566432
23:02:57 14691 8192000000 10584251328 10946732032 1640302336 16.682 100 75 150 0 1672786224 10660320 21823568
23:03:24 7062 8192000000 10597456368 10962255872 1665055552 16.892 100 79 157 1 1698590832 11340480 22194800
23:03:41 12061 8192000000 10629534560 10999816192 1685372656 17.062 100 75 148 2 1718233936 11483200 21378080
23:04:03 6767 8192000000 10630930112 11000463360 1694691360 17.141 100 69 138 0 1726795808 12285456 19818992
23:04:18 7817 8192000000 10645859200 11017977856 1710706416 17.275 100 76 152 2 1745150256 12931424 21512416
23:04:34 9894 8192000000 10657038080 11037003776 1720986464 17.360 100 67 134 0 1752861856 12685232 19190160
23:04:52 7629 8192000000 10682848240 11061309440 1741188336 17.528 100 73 146 1 1774568944 12138400 21242208
23:05:08 6490 8192000000 10687131888 11069587456 1752154560 17.619 100 74 146 0 1785081120 12726944 20199616
23:05:22 4272 8192000000 10702831360 11079413760 1766795440 17.741 100 90 178 0 1804298304 12317632 25185232
23:05:32 5748 8192000000 10707756720 11086413824 1775027296 17.808 100 83 166 2 1810713104 13133328 22552480
23:05:46 5716 8192000000 10710260944 11094024192 1773937488 17.800 100 65 130 0 1804927200 13178192 17811520
23:06:01 4937 8192000000 10739877024 11121029120 1795773120 17.979 100 86 173 1 1833696448 13808448 24114880
23:06:13 2810 8192000000 10735199504 11120750592 1800332720 18.017 100 74 148 0 1834954528 14345920 20275888
23:06:22 2993 8192000000 10748493008 11133247488 1812877200 18.119 100 91 182 2 1853410416 14934560 25598656
23:06:32 3817 8192000000 10758147392 11141804032 1815978880 18.145 100 90 178 5 1855999648 15257792 24762976
23:06:42 2123 8192000000 10766696352 11151249408 1820157504 18.179 100 92 184 1 1858945504 13920640 24867360
23:06:50 2085 8192000000 10770230288 11155460096 1826617504 18.232 100 95 188 3 1868520080 15151216 26751360
23:06:58 2936 8192000000 10780860368 11164844032 1826601904 18.232 100 89 177 0 1866223568 15358128 24263536
23:07:08 2491 8192000000 10781745504 11166466048 1833688592 18.289 100 90 179 1 1874515424 14992880 25833952
23:07:17 1832 8192000000 10783842240 11167506432 1842969664 18.365 100 91 182 2 1883115024 14572496 25572864
23:07:25 1277 8192000000 10793958976 11178708992 1846196240 18.391 100 94 187 1 1887336720 14628176 26512304
23:07:33 1749 8192000000 10788694208 11177488384 1847865472 18.405 100 83 167 0 1884161952 13068336 23228144
23:07:41 1657 8192000000 10796738912 11181928448 1854110304 18.456 100 88 175 0 1891776800 12952992 24713504
23:07:49 1781 8192000000 10803933312 11191779328 1861223520 18.513 100 90 179 1 1898641184 12078224 25339440
23:07:57 2256 8192000000 10808193264 11195293696 1861673616 18.517 100 87 174 0 1898399824 12225280 24500928
23:08:05 1241 8192000000 10812774000 11199819776 1866694768 18.558 100 94 188 1 1906937552 13017472 27225312
23:08:13 2194 8192000000 10813984512 11201777664 1868727216 18.574 100 95 189 2 1908146592 13610800 25808576
23:08:22 1276 8192000000 10823607168 11211481088 1874485792 18.621 100 94 186 1 1915602640 13961264 27155584
23:08:29 41124 8192000000 10814099840 11209474048 1869161600 18.577 100 66 131 1 1895999504 6828816 20009088
23:09:17 1297 8192000000 10819009008 11221880832 1888605504 18.735 100 93 186 1 1926524592 10737520 27181568
23:09:26 5614 8192000000 10800064480 11217985536 1877724288 18.647 100 46 92 0 1900876560 10570640 12581632
23:09:38 5843 8192000000 10800956464 11221729280 1881875936 18.680 100 51 100 2 1904760960 9374208 13510816
23:09:52 3385 8192000000 10803780784 11221561344 1883933008 18.697 100 41 82 1 1903904016 7280928 12690080
23:10:03 5296 8192000000 10816721632 11227365376 1890854208 18.753 100 47 94 2 1909863088 5947936 13060944
23:10:15 5166 8192000000 10812654416 11232108544 1889772864 18.744 100 40 79 0 1908961760 8142320 11046576
23:10:28 11938 8192000000 10801489536 11232202752 1887235920 18.723 100 16 32 1 1897639200 6107504 4295776
23:10:47 10816 8192000000 10796710048 11231637504 1894824352 18.785 100 22 44 0 1907118432 6086688 6207392
23:11:06 13275 8192000000 10810570032 11239268352 1896968528 18.802 100 16 33 1 1907503472 5694736 4840208
23:11:31 10210 8192000000 10798201536 11238600704 1901129648 18.835 100 29 56 0 1916654032 6803376 8721008
23:11:50 13590 8192000000 10807231472 11243814912 1897696112 18.808 100 11 23 1 1909890064 9350576 2843376
23:12:13 15049 8192000000 10828134528 11251417088 1909551536 18.903 100 31 63 0 1923617744 5462576 8603632
23:12:35 62025 8192000000 10834079184 11257298944 1908647792 18.896 100 42 84 1 1925532448 4009648 12875008
23:13:44 3693 8192000000 10840751264 11265024000 1913697744 18.936 100 55 110 2 1939805280 10758208 15349328
23:13:55 10459 8192000000 10837784512 11260182528 1913066464 18.931 100 34 67 3 1928652528 6208800 9377264
23:14:12 4483 8192000000 10833100512 11257253888 1907351344 18.885 100 24 48 3 1920245504 5753104 7141056
23:14:28 5272 8192000000 10827309936 11256635392 1908869920 18.898 100 31 62 1 1924578608 7112064 8596624
23:14:39 8808 8192000000 10821580576 11259977728 1911779872 18.921 100 25 48 4 1926489328 6662480 8046976
23:14:55 7838 8192000000 10835066528 11264233472 1911933424 18.922 100 26 50 2 1925537952 5336896 8267632
23:15:11 9170 8192000000 10832605216 11266289664 1912972032 18.930 100 22 44 0 1925856256 6334480 6549744
23:15:29 9049 8192000000 10826998752 11266224128 1917005488 18.963 100 22 44 3 1929662592 5645312 7011792
23:15:44 10221 8192000000 10825274384 11266117632 1917282400 18.965 100 24 49 3 1929928960 6027408 6619152
23:16:02 9931 8192000000 10805631648 11242827776 1853104512 18.447 97 16 30 2 1864114896 5727152 5283232
23:16:21 9111 8192000000 10799293376 11233755136 1861591056 18.516 98 20 40 0 1873097600 5287840 6218704
23:16:38 53117 8192000000 10826403312 11224059904 1866972240 18.560 98 63 130 4 1891896304 5767104 19156960
23:17:37 19318 8192000000 10793314096 11226198016 1836949760 18.316 97 21 42 1 1849806736 6010944 6846032
23:18:05 4403 8192000000 10783757296 11202711552 1830686832 18.265 98 36 72 3 1847879616 7571264 9621520
23:18:19 6028 8192000000 10777563584 11201085440 1846394192 18.393 99 36 72 1 1862943952 6286032 10263728
23:18:33 8147 8192000000 10765921744 11186302976 1792917824 17.956 96 26 52 1 1806224880 5042800 8264256
23:18:48 1943 8192000000 10789929264 11206725632 1851224208 18.432 99 45 90 0 1872416576 8443712 12748656
23:18:56 8807 8192000000 10749116624 11174596608 1782012272 17.866 96 22 44 1 1793671632 5379232 6280128
23:19:11 6431 8192000000 10724976096 11139727360 1757045568 17.660 96 29 58 0 1771888160 6566688 8275904
23:19:24 8526 8192000000 10692030240 11113091072 1717184640 17.329 94 21 42 0 1729252080 5626624 6440816
23:19:41 8214 8192000000 10709895008 11122544640 1774748240 17.806 99 24 48 0 1788088976 5893728 7447008
23:19:56 8599 8192000000 10705322432 11119001600 1776016784 17.817 99 21 42 1 1787234416 5488800 5728832
23:20:11 7713 8192000000 10683275040 11087572992 1719721312 17.350 96 31 62 3 1733570512 4831120 9018080
23:20:26 9572 8192000000 10675475920 11090358272 1730179424 17.437 97 26 52 3 1742871232 5109440 7582368
23:20:42 9745 8192000000 10698049616 11117568000 1769341552 17.762 99 18 36 1 1780718960 6306704 5070704
23:20:59 7416 8192000000 10685498464 11101347840 1760129760 17.685 99 14 28 1 1769327696 5333312 3864624
23:21:13 59801 8192000000 10697249232 11109109760 1721683312 17.366 96 29 56 5 1735932608 5369968 8879328
23:22:19 25947 8192000000 10696407040 11107131392 1740841344 17.526 97 23 47 1 1752854976 5429344 6584288
23:22:53 6140 8192000000 10725826304 11136323584 1790524000 17.936 99 36 73 2 1807668352 7173744 9970608
23:23:06 6099 8192000000 10743966784 11147935744 1796062416 17.982 99 35 70 0 1812665584 6719728 9883440
23:23:20 6832 8192000000 10721997232 11145265152 1810576144 18.101 100 22 44 1 1823455664 6777648 6101872
23:23:33 6707 8192000000 10742959568 11154456576 1822234128 18.196 100 33 67 0 1842488880 9218864 11035888
23:23:46 5918 8192000000 10740252032 11164708864 1826102464 18.228 100 22 44 1 1837848480 5528768 6217248
23:23:58 13953 8192000000 10745208112 11174723584 1832874688 18.283 100 14 27 1 1841865312 4716976 4273648
23:24:19 14097 8192000000 10753584320 11179712512 1840632800 18.346 100 25 50 0 1854094544 6059360 7402384
23:24:39 12065 8192000000 10771441824 11185274880 1846717776 18.395 100 23 46 1 1858293328 5374256 6201296
23:24:58 7922 8192000000 10764332768 11187208192 1846441776 18.393 100 16 32 1 1856381776 5401584 4538416
23:25:13 11296 8192000000 10753342368 11189059584 1849879952 18.421 100 22 41 3 1862532816 6774016 5878848
23:25:32 7957 8192000000 10759041712 11192475648 1855385744 18.466 100 19 38 0 1865602816 5430656 4786416
23:25:48 17109 8192000000 10766316224 11194707968 1855491968 18.467 100 15 29 0 1864855312 5174160 4189184
23:26:12 28302 8192000000 10780117008 11210661888 1863502464 18.532 100 18 37 0 1874179216 5252752 5424000
23:27:17 136521 8192000000 10841823968 11265998848 1904706128 18.864 100 34 67 2 1919794736 5930944 9157664
23:29:46 32888 8192000000 10844168016 11280572416 1926769072 19.041 100 38 76 0 1948775952 10732992 11273888
23:30:43 15131 8192000000 10884851584 11305017344 1937576736 19.127 100 46 90 3 1958117680 8730016 11810928
23:31:15 8937 8192000000 10881440432 11302395904 1945047264 19.187 100 54 108 1 1972230880 11662464 15521152
23:31:31 6227 8192000000 10882219552 11305046016 1946834624 19.201 100 61 120 2 1976853056 12579584 17438848
23:31:51 28486 8192000000 10897480704 11321651200 1954211184 19.260 100 59 118 0 1986128032 14720560 17196288
23:32:32 18136 8192000000 10893921856 11329064960 1960238624 19.308 100 46 90 1 1988758848 15288496 13231728
23:33:00 11775 8192000000 10908533200 11334610944 1971410480 19.397 100 62 121 1 2003913360 14749456 17753424
23:33:19 5882 8192000000 10923456176 11339415552 1971271968 19.396 100 67 134 2 2009078688 17756096 20050624
23:33:36 19186 8192000000 10921022720 11343323136 1973539248 19.414 100 66 131 3 2009937744 17323648 19074848
23:34:07 5442 8192000000 10926781328 11351060480 1977261136 19.443 100 61 119 3 2014848448 19509040 18078272
23:34:21 3646 8192000000 10941879536 11352965120 1979418032 19.460 100 66 131 2 2018759600 19695328 19646240
23:34:42 6532 8192000000 10923101136 11354296320 1980915008 19.472 100 52 104 1 2017435184 19973024 16547152
23:34:57 14017 8192000000 10930168752 11363143680 1984934864 19.504 100 59 118 1 2022885136 20245792 17704480
23:35:20 7790 8192000000 10939715792 11365847040 1989901920 19.543 100 72 144 1 2031846720 20569280 21375520
23:35:41 8539 8192000000 10948555888 11371999232 1991404688 19.555 100 67 132 0 2032303280 21679200 19219392
23:35:57 3052 8192000000 10955452704 11375124480 1996901040 19.598 100 68 136 3 2040088128 21595696 21591392
23:36:07 2599 8192000000 10945191568 11373350912 1995917568 19.591 100 71 142 1 2040621824 23577664 21126592
23:36:16 1769 8192000000 10940839280 11370110976 1979357904 19.460 99 69 138 3 2023890720 24123664 20409152
23:36:25 4415 8192000000 10949325504 11380469760 1998119456 19.608 100 67 134 1 2042118848 23300288 20699104
23:36:38 1775 8192000000 10960458576 11376951296 2001000528 19.631 100 78 152 1 2044285520 20739744 22545248
23:36:48 17636 8192000000 10954199280 11383160832 2000575104 19.627 100 60 120 3 2042675344 23891104 18209136
23:37:16 9823 8192000000 10958555616 11391574016 2001941344 19.638 100 57 114 0 2045570432 26180640 17448448
23:37:36 6410 8192000000 10939865616 11374637056 1982568160 19.485 99 49 98 0 2023513456 25117040 15828256
23:37:53 4261 8192000000 10965099216 11389841408 1999893536 19.622 100 64 127 1 2048822880 29240352 19688992
23:38:05 5624 8192000000 10955897984 11391733760 1999209936 19.617 100 53 104 3 2040170800 23880416 17080448
23:38:17 13125 8192000000 10950559552 11386699776 2000083008 19.623 100 65 130 0 2043476240 23826000 19567232
23:38:41 18836 8192000000 10948635440 11389378560 1984411072 19.500 99 49 98 0 2023578592 24446352 14721168
23:39:16 5219 8192000000 10962400000 11404349440 2007330752 19.681 100 53 106 1 2054230176 30463344 16436080
23:39:28 7599 8192000000 10969433840 11406049280 1992197488 19.561 99 52 104 1 2037922320 29529024 16195808
23:39:43 1804 8192000000 10993853664 11415293952 2017974864 19.764 100 89 176 0 2075764064 31678800 26110400
23:39:52 3812 8192000000 10978807248 11400388608 2003691264 19.652 100 74 148 1 2058413056 32430016 22291776
23:40:03 3833 8192000000 10978878096 11407007744 2009759472 19.700 100 76 152 0 2065891984 33791472 22341040
23:40:15 2277 8192000000 10991786752 11408822272 1997714080 19.605 99 84 168 1 2057250016 34609456 24926480
23:40:23 1569 8192000000 10985150400 11398459392 2003066864 19.647 100 92 181 0 2064984256 34319568 27597824
23:40:32 3434 8192000000 10963628176 11380903936 1986537072 19.516 100 85 170 2 2045537456 33488112 25512272
23:40:42 1818 8192000000 10955245104 11372503040 1972717264 19.407 99 88 174 1 2028759520 29028288 27013968
23:40:51 7640 8192000000 10940355952 11368136704 1978616112 19.454 100 75 145 0 2029964480 29869072 21479296
23:41:06 2488 8192000000 10951802304 11382095872 1985665968 19.510 100 67 133 0 2035712496 29938512 20108016
23:41:16 4995 8192000000 10946032544 11365855232 1961259328 19.316 99 78 151 1 2017232800 33338976 22634496
23:41:29 14181 8192000000 10946421888 11379392512 1983523760 19.493 100 55 108 0 2032921360 33198464 16199136
23:42:03 4865 8192000000 10964136784 11388837888 1991211664 19.553 100 65 127 1 2044587648 33915248 19460736
23:42:16 3729 8192000000 10958477040 11379494912 1982457840 19.484 100 72 144 2 2041047280 36562320 22027120
23:42:36 6851 8192000000 10951965424 11381555200 1980923488 19.472 100 66 127 1 2039599008 38857280 19818240
23:42:52 3621 8192000000 10939447568 11367911424 1954435088 19.262 99 63 125 0 2013164656 38968464 19761104
23:43:06 7723 8192000000 10958700144 11375919104 1971619280 19.398 100 84 166 0 2037361664 40412112 25330272
23:43:21 4644 8192000000 10942720848 11365355520 1953039216 19.251 99 74 149 3 2018241808 41801360 23401232
23:43:35 4902 8192000000 10960513760 11376861184 1968486112 19.373 100 75 149 1 2035617584 43761648 23369824
23:43:47 6067 8192000000 10948587184 11374465024 1965500688 19.350 100 66 128 0 2030715776 44705248 20509840
23:44:02 4094 8192000000 10947911536 11368648704 1964620624 19.343 100 70 137 1 2031139088 45450208 21068256
23:44:15 8052 8192000000 10905463536 11344207872 1910828960 18.913 98 57 113 0 1972440320 43671056 17940304
23:44:41 7466 8192000000 10932432656 11360059392 1956515200 19.278 100 56 110 0 2014421104 40165696 17740208
23:44:56 4840 8192000000 10951588880 11369013248 1967025520 19.362 100 75 149 2 2030546112 40879632 22640960
23:45:08 9072 8192000000 10954564096 11379027968 1973197216 19.411 100 62 124 1 2035653728 42626064 19830448
23:45:26 2050 8192000000 10943523936 11368288256 1955718944 19.272 99 66 133 1 2019177392 43142816 20315632
23:45:36 5193 8192000000 10969959456 11385155584 1979617248 19.462 100 75 147 0 2045156336 43002672 22536416
23:45:49 1636 8192000000 10968719984 11376726016 1971463488 19.397 100 85 167 1 2039454096 43911792 24078816
23:45:58 3784 8192000000 10964744288 11374460928 1968961088 19.377 100 87 171 4 2038466576 43730736 25774752
23:46:08 4433 8192000000 10876670400 11301527552 1896369728 18.797 97 61 122 0 1950841840 35996672 18475440
23:46:19 13216 8192000000 10889019312 11326697472 1932884752 19.090 100 24 48 3 1967090096 26435168 7770176
23:46:42 4272 8192000000 10903548368 11320762368 1919130464 18.980 99 68 138 2 1969108176 29501488 20476224
23:46:55 1964 8192000000 10941114384 11347513344 1953544560 19.255 100 94 189 4 2016500912 34117952 28838400
23:47:07 2760 8192000000 10931256384 11338084352 1934158432 19.100 99 90 182 0 1998680208 36845712 27676064
23:47:16 1974 8192000000 10920418608 11341680640 1944876448 19.186 100 60 120 1 2001104160 38107840 18119872
23:47:36 9286 8192000000 10893252512 11326353408 1917731184 18.969 99 35 70 0 1966280512 36831424 11717904
23:47:52 7546 8192000000 10900319088 11331776512 1915636544 18.952 99 44 88 0 1968046128 38673792 13735792
23:48:08 5777 8192000000 10908505936 11334701056 1928963712 19.059 100 47 94 0 1983471440 39916048 14591680
23:48:22 10509 8192000000 10898070176 11339444224 1933108688 19.092 100 29 58 1 1981125152 38336688 9679776
23:48:40 7203 8192000000 10901207248 11331796992 1918409408 18.974 99 49 95 2 1971638352 37353280 15875664
23:48:54 5204 8192000000 10923829760 11348918272 1945366576 19.190 100 45 91 0 1999722752 39602080 14754096
23:49:06 9851 8192000000 10918795280 11351109632 1944394944 19.182 100 46 91 1 1999313552 40188928 14729680
23:49:26 15616 8192000000 10919533872 11355160576 1953833840 19.257 100 36 72 0 2007094608 40516256 12744512
23:49:50 14479 8192000000 10927276832 11364503552 1940562736 19.151 99 37 74 1 1993228576 40360000 12305840
23:50:12 12993 8192000000 10931424432 11369586688 1962073616 19.323 100 43 86 0 2016032352 39914016 14044720
23:50:36 13301 8192000000 10945378304 11385929728 1968702096 19.375 100 43 86 2 2027207312 44130928 14374288
23:51:03 11277 8192000000 10935598912 11379298304 1955294400 19.269 99 32 64 2 2007675168 41332464 11048304
23:51:25 16591 8192000000 10951418800 11391057920 1972831552 19.408 100 36 72 0 2031160032 45833296 12495184
23:52:05 9086 8192000000 10951731296 11399540736 1969993984 19.385 100 32 64 0 2035379648 53115920 12269744
23:52:35 25328 8192000000 10920502848 11367710720 1904726000 18.864 97 31 61 1 1958821552 43796736 10298816
23:53:06 27983 8192000000 10908984832 11361894400 1906568624 18.879 98 29 56 1 1968442384 51726640 10147120
23:53:56 27514 8192000000 10893709200 11362549760 1935093200 19.108 100 22 44 0 1989056096 45405744 8557152
23:54:31 34353 8192000000 10871868096 11332161536 1861097952 18.512 96 23 44 0 1910750512 42006624 7645936
23:55:17 78611 8192000000 10879940016 11330818048 1931866224 19.082 100 24 47 4 1961948352 22838976 7243152
23:57:01 25348 8192000000 10901708704 11341934592 1955436592 19.270 100 50 99 0 1984844416 15534544 13873280
23:57:33 14787 8192000000 10921318112 11345309696 1961855840 19.321 100 69 135 3 1997076768 15162896 20058032
23:57:55 27389 8192000000 10892149344 11354996736 1960567760 19.311 100 23 46 0 1984345072 17364800 6412512
23:58:46 79653 8192000000 10874040800 11323715584 1927391680 19.046 98 11 22 1 1940765904 10531488 2842736
00:00:54 124682 8192000000 10902833504 11357822976 1949359536 19.221 99 27 52 3 1963531040 7560736 6610768
00:03:12 92144 8192000000 10905026672 11371261952 1959467440 19.302 99 23 46 1 1980491088 14863568 6160080
00:05:15 108269 8192000000 10912444064 11363315712 1922627984 19.008 97 26 51 1 1939856384 10793936 6434464
00:07:10 51659 8192000000 10927523184 11374149632 1967850096 19.368 99 32 64 0 1988783584 10827040 10106448
00:08:10 57356 8192000000 10930255088 11381854208 1971747280 19.399 99 27 54 1 1991457760 12188144 7522336
00:09:14 81497 8192000000 10922268000 11389992960 1989142528 19.537 100 15 30 0 2008570752 14985392 4442832
00:11:05 27856 8192000000 10912786032 11381219328 1993834832 19.574 100 26 52 2 2012780800 10714752 8231216
00:11:47 38104 8192000000 10907858160 11376685056 1953406656 19.254 98 19 38 1 1970421568 11444432 5570480
00:12:37 39473 8192000000 10926626976 11383517184 1996850720 19.598 100 39 78 1 2019779888 12245056 10684112
00:13:33 45548 8192000000 10918979168 11388342272 1996878800 19.598 100 22 44 2 2012672496 9764848 6028848
00:14:55 55694 8192000000 10898028272 11381522432 1976191216 19.435 99 10 21 0 1991126448 11952720 2982512
00:16:12 112383 8192000000 10908601520 11384532992 1970224640 19.387 99 11 22 0 1980378000 6993344 3160016
00:18:23 87027 8192000000 10909581760 11396632576 1976741152 19.439 99 15 29 2 1993316960 11886672 4689136
00:20:01 50116 8192000000 10894179808 11391352832 1936670208 19.120 97 10 20 2 1952465072 13022480 2772384
00:21:00 49361 8192000000 10886761984 11362205696 1945691984 19.192 98 11 22 0 1956716640 8179648 2845008
00:22:20 56877 8192000000 10876979760 11359371264 1913470432 18.934 97 3 6 0 1920404816 6173328 761056
00:23:28 67474 8192000000 10892271072 11360919552 1934252688 19.101 98 27 52 3 1951958144 10271376 7434080
00:24:49 47994 8192000000 10866137296 11331121152 1881206016 18.675 96 22 42 2 1900588400 12650752 6731632
00:25:44 19283 8192000000 10881760048 11341508608 1929881264 19.066 99 30 60 0 1950148000 11856944 8409792
00:26:11 88610 8192000000 10889324512 11370303488 1961280352 19.316 100 28 56 1 1985264064 16185760 7797952
00:28:01 90255 8192000000 10860040832 11334090752 1836020048 18.308 93 15 30 1 1855407328 15123280 4264000
00:29:37 114361 8192000000 10862136368 11332419584 1796480624 17.985 92 8 16 1 1810640624 11920768 2239232
00:31:39 124805 8192000000 10879355680 11364556800 1837495856 18.320 94 10 20 1 1858416336 18125888 2794592
00:34:06 53597 8192000000 10918875344 11368955904 1943899744 19.178 99 30 58 2 1965321104 13612112 7809248
00:35:06 35715 8192000000 10890614528 11349385216 1908778192 18.897 97 34 68 1 1936432784 17650928 10003664
00:35:55 101449 8192000000 10878620736 11363270656 1897068496 18.803 97 8 16 0 1916648032 17335120 2244416
00:37:43 80839 8192000000 10886172928 11353083904 1876259408 18.635 96 24 47 0 1898554880 15304864 6990608
00:39:10 169497 8192000000 10840509200 11295297536 1831801456 18.274 94 29 58 2 1848860496 9069936 7989104
00:42:06 67161 8192000000 10853167984 11298181120 1879671952 18.662 97 43 86 0 1900744720 8556112 12516656
00:43:37 7397 8192000000 10860743472 11292934144 1907471616 18.886 99 51 100 4 1929078240 7832800 13773824
00:43:51 23134 8192000000 10882885648 11313229824 1923901680 19.018 100 45 88 1 1946113408 10165440 12046288
00:44:22 59195 8192000000 10854970544 11323871232 1936809040 19.121 100 25 50 2 1955026752 10761984 7455728
00:45:28 83152 8192000000 10867762800 11332657152 1894759152 18.784 97 17 34 1 1912059680 12639616 4660912
00:46:57 70636 8192000000 10876943760 11347222528 1932183424 19.084 99 17 34 1 1952145952 14334896 5627632
00:48:16 34829 8192000000 10859391408 11327426560 1908367136 18.894 98 7 14 0 1920949664 10316688 2265840
00:49:01 42187 8192000000 10859787568 11335942144 1927582672 19.048 99 15 29 0 1946898016 15094976 4220368
00:49:52 32297 8192000000 10874813840 11348680704 1943871776 19.178 100 11 22 0 1958478512 11135008 3471728
00:52:02 46444 8192000000 10865669024 11347001344 1916492416 18.959 98 20 40 1 1934088832 11517552 6078864
00:53:01 55448 8192000000 10865578816 11333996544 1913874528 18.938 98 7 12 1 1923611680 8706816 1030336
00:54:05 23518 8192000000 10875990192 11339849728 1947312784 19.205 100 30 61 2 1963333424 7488480 8532160
00:54:34 39827 8192000000 10884698176 11344785408 1932800080 19.089 99 31 60 0 1951518288 10210960 8507248
00:55:22 90689 8192000000 10882677584 11357708288 1926300032 19.037 98 16 32 0 1947680960 16766688 4614240
00:56:59 74352 8192000000 10896805072 11357614080 1905356320 18.869 97 17 34 0 1930419424 20505536 4557568
00:58:39 70301 8192000000 10890776880 11349643264 1924813664 19.025 98 11 22 0 1935885792 8585488 2486640
00:59:59 22750 8192000000 10894485424 11344818176 1929776048 19.065 98 26 51 1 1946000608 8939776 7284784
01:00:29 81803 8192000000 10911182368 11385880576 1973542736 19.414 100 25 50 1 1994926336 14462560 6921040
01:02:02 87035 8192000000 10911858544 11368345600 1899627968 18.823 96 12 24 1 1914627520 12176448 2823104
01:03:35 23647 8192000000 10926770464 11374841856 1976691104 19.438 100 43 85 1 2000155152 11855488 11608560
01:04:16 96724 8192000000 10913660416 11376222208 1954241056 19.260 99 17 34 0 1978606912 19869888 4495968
01:06:00 42190 8192000000 10927448352 11379359744 1949832480 19.225 98 29 58 0 1968032720 10209744 7990496
01:06:52 95459 8192000000 10906320256 11380371456 1971423152 19.397 100 19 38 1 1989501600 12499760 5578688
01:08:39 89456 8192000000 10939150576 11391434752 1986843840 19.519 100 22 44 0 2002907632 9698576 6365216
01:10:29 88838 8192000000 10890138752 11367518208 1892333760 18.765 95 11 22 0 1905246176 9848496 3063920
01:12:04 52166 8192000000 10865327072 11346366464 1893984096 18.778 96 10 20 0 1907669008 10628528 3056384
01:13:30 41552 8192000000 10860204496 11336396800 1931273008 19.077 100 6 12 0 1945032976 12151312 1608656
01:14:20 43048 8192000000 10881834128 11353776128 1939217456 19.141 99 23 46 2 1956274768 10086144 6971168
01:15:30 68864 8192000000 10887496272 11376578560 1964120640 19.339 100 18 36 1 1983014976 13614816 5279520
01:16:54 74437 8192000000 10886348288 11345833984 1895064144 18.787 96 17 33 0 1908008176 8814896 4129136
01:18:15 65832 8192000000 10855821344 11347570688 1920735968 18.993 98 19 38 1 1939652720 13341280 5575472
01:19:50 74006 8192000000 10860070944 11345002496 1912651152 18.928 98 19 37 1 1925453328 7273072 5529104
01:21:19 59995 8192000000 10848298720 11314683904 1882096864 18.682 97 9 18 0 1892874912 8313664 2464384
01:22:26 66370 8192000000 10835918592 11297120256 1866853744 18.559 96 19 38 1 1881985504 9958368 5173392
01:23:55 53568 8192000000 10827496928 11300442112 1844041648 18.374 95 18 36 1 1862706656 13530944 5134064
01:24:58 48262 8192000000 10836031936 11299328000 1871041520 18.593 97 17 34 1 1885690288 10158656 4490112
01:25:52 74042 8192000000 10857868080 11320258560 1851718848 18.436 96 18 34 2 1867219360 10929344 4571168

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 13-01-2021 01:28:37 to 13-01-2021 01:29:07.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 112 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 13-01-2021 01:29:08 to 13-01-2021 01:29:10.

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          238940
MON$OLDEST_ACTIVE               238941
MON$OLDEST_SNAPSHOT             238941
MON$NEXT_TRANSACTION            238941
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                       2027424
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 ---
:849: 
:850: mscs-test-161.budzdorov.ru    Wed Jan 13 01:27:29 2021
:851:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:852: 
:853: 
:854: mscs-test-161.budzdorov.ru    Wed Jan 13 01:27:30 2021
:855:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:856: 
--- end of diff output ---

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

13.01.21 01:29:11. 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-13 01:29:13 No severe PSQL-related problems occured
13.01.21 01:29:15. End of report.