Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 22.11.2020 22: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 17418092 kB
MemAvailable 31530080 kB
Buffers 0 kB
Cached 14309704 kB
SwapCached 3188 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-11-22 22:27:01
DTS_END                         2020-11-22 22:27:01.1020
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_RECALC_IDX_STAT(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/38936
TRN_ID                          234555
ATT_ID                          671
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: 9402.41 21288 1128289
customer order: creation 165.74 371 19889
customer order: refuse 14.83 350 1780
order to supplier: creation 45.13 1311 5416
order to supplier: removal 3.47 106469 416
invoice (draft): creation 44.89 3453 5387
invoice (draft): removal 54.97 782 6596
invoice accept: apply 41.18 18680 4941
invoice accept: cancel 49.87 801 5984
customer reserve: creation 3821.03 182 458523
customer reserve: removal 4861.48 59 583378
realization accept: apply 81.63 205 9795
realization accept: cancel 92.13 98 11056
payment from customer: creation 58.08 114 6969
payment from customer: removal 5.74 88 689
payment to supplier: creation 47.12 132 5654
payment to supplier: removal 3.44 86 413
service: total inventory turnovers 4.61 1102 553
service: total monetary turnovers 6.36 23 763
service: aggregate perf. data 0.69 24534 83
service: refresh index statistics 0.03 266928 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 22-11-2020 22:29:10 to 22-11-2020 22:29:12.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6869
TEST_TIME 2 7978
TEST_TIME 3 6943
TEST_TIME 4 6139
TEST_TIME 5 5984
TEST_TIME 6 5735
TEST_TIME 7 5971
TEST_TIME 8 6545
TEST_TIME 9 6860
TEST_TIME 10 6859
TEST_TIME 11 6875
TEST_TIME 12 6963
TEST_TIME 13 6985
TEST_TIME 14 6931
TEST_TIME 15 7000
TEST_TIME 16 7793
TEST_TIME 17 7897
TEST_TIME 18 7851
TEST_TIME 19 7965
TEST_TIME 20 8605
TEST_TIME 21 8505
TEST_TIME 22 8603
TEST_TIME 23 8829
TEST_TIME 24 9306
TEST_TIME 25 9712
TEST_TIME 26 10591
TEST_TIME 27 11375
TEST_TIME 28 11252
TEST_TIME 29 11143
TEST_TIME 30 11034
TEST_TIME 31 10937
TEST_TIME 32 10995
TEST_TIME 33 10803
TEST_TIME 34 10710
TEST_TIME 35 10460
TEST_TIME 36 10523
TEST_TIME 37 10586
TEST_TIME 38 10383
TEST_TIME 39 10325
TEST_TIME 40 10248
TEST_TIME 41 10182
TEST_TIME 42 10201
TEST_TIME 43 10132
TEST_TIME 44 10049
TEST_TIME 45 9971
TEST_TIME 46 10136
TEST_TIME 47 9946
TEST_TIME 48 9896
TEST_TIME 49 9860
TEST_TIME 50 9801
TEST_TIME 51 9807
TEST_TIME 52 9758
TEST_TIME 53 9777
TEST_TIME 54 9768
TEST_TIME 55 9799
TEST_TIME 56 9823
TEST_TIME 57 9830
TEST_TIME 58 9928
TEST_TIME 59 9951
TEST_TIME 60 10038
TEST_TIME 61 10109
TEST_TIME 62 10149
TEST_TIME 63 10131
TEST_TIME 64 10067
TEST_TIME 65 10015
TEST_TIME 66 9926
TEST_TIME 67 9919
TEST_TIME 68 9825
TEST_TIME 69 9824
TEST_TIME 70 9735
TEST_TIME 71 9621
TEST_TIME 72 9666
TEST_TIME 73 9595
TEST_TIME 74 9541
TEST_TIME 75 9694
TEST_TIME 76 9644
TEST_TIME 77 9694
TEST_TIME 78 9757
TEST_TIME 79 9750
TEST_TIME 80 9770
TEST_TIME 81 9743
TEST_TIME 82 9751
TEST_TIME 83 9859
TEST_TIME 84 9853
TEST_TIME 85 9871
TEST_TIME 86 9774
TEST_TIME 87 9724
TEST_TIME 88 9716
TEST_TIME 89 9661
TEST_TIME 90 9629
TEST_TIME 91 9612
TEST_TIME 92 9589
TEST_TIME 93 9599
TEST_TIME 94 9573
TEST_TIME 95 9577
TEST_TIME 96 9656
TEST_TIME 97 9640
TEST_TIME 98 9632
TEST_TIME 99 9714
TEST_TIME 100 9725
TEST_TIME 101 9724
TEST_TIME 102 9701
TEST_TIME 103 9730
TEST_TIME 104 9756
TEST_TIME 105 9763
TEST_TIME 106 9824
TEST_TIME 107 9807
TEST_TIME 108 9720
TEST_TIME 109 9666
TEST_TIME 110 9616
TEST_TIME 111 9595
TEST_TIME 112 9563
TEST_TIME 113 9642
TEST_TIME 114 9600
TEST_TIME 115 9612
TEST_TIME 116 9571
TEST_TIME 117 9510
TEST_TIME 118 9502
TEST_TIME 119 9489
TEST_TIME 120 9410

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 22-11-2020 22:29:14 to 22-11-2020 22:29:17.

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 1552136 1552136 0 0.00 0 19768 7 0 0
doc_list_biud 1552136 1552136 0 0.00 0 34760 28 0 0
sp_add_invoice_to_stock 5037 4941 96 1.90 30 165197 18680 0 96
sp_cancel_adding_invoice 5984 5984 0 0.00 4 56024 802 0 0
sp_cancel_client_order 1780 1780 0 0.00 4 11129 351 0 0
sp_cancel_customer_reserve 583378 583378 0 0.00 1 34765 60 0 0
sp_cancel_pay_from_customer 689 689 0 0.00 2 5042 89 0 0
sp_cancel_pay_to_supplier 413 413 0 0.00 2 2917 86 0 0
sp_cancel_supplier_invoice 6598 6596 2 0.03 1 18262 782 0 2
sp_cancel_supplier_order 416 416 0 0.00 6 981958 106470 0 0
sp_cancel_write_off 11056 11056 0 0.00 1 8645 98 0 0
sp_client_order 19889 19889 0 0.00 3 23805 372 0 0
sp_customer_reserve 458523 458523 0 0.00 0 63410 183 0 0
sp_fill_shopping_cart 30688 30688 0 0.00 1 11871 39 0 0
sp_fill_shopping_cart_clo_res 458490 458490 0 0.00 0 19662 14 0 0
sp_get_clo_for_invoice 4906 4906 0 0.00 0 23944 345 0 0
sp_kill_cost_storno 18142 18142 0 0.00 0 8642 59 0 0
sp_kill_qstorno_ret_qs2qd 1184824 1184824 0 0.00 0 26177 32 0 0
sp_kill_qty_storno 623911 623911 0 0.00 0 34759 69 0 0
sp_lock_selected_doc 20462 20462 0 0.00 0 8038 7 0 0
sp_make_cost_storno 27324 27324 0 0.00 0 13485 63 0 0
sp_multiply_rows_for_pdistr 27324 27324 0 0.00 0 7252 29 0 0
sp_multiply_rows_for_qdistr 19889 19889 0 0.00 0 18939 163 0 0
sp_pay_from_customer 6969 6969 0 0.00 4 11868 114 0 0
sp_pay_to_supplier 5654 5654 0 0.00 5 23580 133 0 0
sp_payment_common 12623 12623 0 0.00 1 23511 35 0 0
sp_qd_handle_on_cancel_clo 1780 1780 0 0.00 0 11122 318 0 0
sp_qd_handle_on_invoice_upd_sts 10890 10890 0 0.00 0 31450 326 0 0
sp_qd_handle_on_reserve_upd_sts 9795 9795 0 0.00 0 23287 68 0 0
sp_reserve_write_off 9795 9795 0 0.00 6 23433 206 0 0
sp_supplier_invoice 5387 5387 0 0.00 5 76847 3454 0 0
sp_supplier_order 5416 5416 0 0.00 5 35455 1311 0 0
srv_aggregate_perf_data 84 83 1 1.19 2255 240497 24535 0 1
srv_fill_mon_cache_memory 168 168 0 0.00 1267 138469 30198 0 0
srv_find_qd_qs_mism 1081169 1081169 0 0.00 0 19767 6 0 0
srv_make_invnt_saldo 553 553 0 0.00 22 70119 1103 0 0
srv_make_money_saldo 763 763 0 0.00 1 529 24 0 0
srv_recalc_idx_stat 4 4 0 0.00 215858 348222 266928 0 0
t$perf-abend:sp_add_invoice_to_stock 96 96 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 2 2 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4941 4941 0 0.00 0 14387 196 0 0
t$perf-norm:sp_cancel_adding_invoice 417 417 0 0.00 0 10517 179 0 0
t$perf-norm:sp_cancel_client_order 1780 1780 0 0.00 0 3893 15 0 0
t$perf-norm:sp_cancel_customer_reserve 669 669 0 0.00 0 7411 32 0 0
t$perf-norm:sp_cancel_pay_from_customer 689 689 0 0.00 0 11503 26 0 0
t$perf-norm:sp_cancel_pay_to_supplier 413 413 0 0.00 0 2273 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 400 400 0 0.00 0 6684 36 0 0
t$perf-norm:sp_cancel_supplier_order 416 416 0 0.00 0 22294 1683 0 0
t$perf-norm:sp_cancel_write_off 977 977 0 0.00 0 3251 10 0 0
t$perf-norm:sp_client_order 19889 19889 0 0.00 0 7286 16 0 0
t$perf-norm:sp_customer_reserve 997 997 0 0.00 0 1622 5 0 0
t$perf-norm:sp_pay_from_customer 6969 6969 0 0.00 0 4866 10 0 0
t$perf-norm:sp_pay_to_supplier 5654 5654 0 0.00 0 5165 11 0 0
t$perf-norm:sp_reserve_write_off 9795 9795 0 0.00 0 8062 13 0 0
t$perf-norm:sp_supplier_invoice 5387 5387 0 0.00 0 5382 17 0 0
t$perf-norm:sp_supplier_order 5416 5416 0 0.00 0 11765 19 0 0
t$perf-norm:srv_aggregate_perf_data 83 83 0 0.00 0 254 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 168 168 0 0.00 0 2201 40 0 0
t$perf-norm:srv_make_invnt_saldo 553 553 0 0.00 0 511 17 0 0
t$perf-norm:srv_make_money_saldo 763 763 0 0.00 0 1616 22 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 10 4 0 0
v_add_invoice_to_stock 10004 9812 192 1.91 0 5611 17 0 192
v_all_customers 36510 36510 0 0.00 0 24 1 0 0
v_all_suppliers 29724 29724 0 0.00 0 17 1 0 0
v_all_wares 39778 39778 0 0.00 0 15 1 0 0
v_cancel_adding_invoice 834 834 0 0.00 0 1826 9 0 0
v_cancel_client_order 3560 3560 0 0.00 0 2347 4 0 0
v_cancel_customer_prepayment 1378 1378 0 0.00 0 1099 5 0 0
v_cancel_customer_reserve 1338 1338 0 0.00 0 2608 5 0 0
v_cancel_payment_to_supplier 826 826 0 0.00 0 185 3 0 0
v_cancel_supplier_invoice 804 800 4 0.49 0 4919 25 0 4
v_cancel_supplier_order 832 832 0 0.00 0 1590 7 0 0
v_cancel_write_off 1954 1954 0 0.00 0 5746 15 0 0
v_max_id_clo_ord 5415 5415 0 0.00 0 339 1 0 0
v_max_id_clo_res 997 997 0 0.00 0 2755 15 0 0
v_max_id_ord_sup 5384 5384 0 0.00 0 1780 3 0 0
v_max_non_paid_invoice 1591 1591 0 0.00 0 6424 6 0 0
v_max_non_paid_realizn 3715 3715 0 0.00 0 11134 7 0 0
v_min_id_clo_ord 5415 5415 0 0.00 0 5585 8 0 0
v_min_id_clo_res 997 997 0 0.00 0 5088 15 0 0
v_min_id_ord_sup 5384 5384 0 0.00 0 4290 8 0 0
v_min_non_paid_invoice 5654 5654 0 0.00 0 23507 26 0 0
v_min_non_paid_realizn 6969 6969 0 0.00 0 11284 23 0 0
v_our_firm 9776 9776 0 0.00 0 23 1 0 0
v_reserve_write_off 19590 19590 0 0.00 0 5599 6 0 0
x_lock_depdocs_on_canc_invoice 12180 12180 0 0.00 0 28983 118 0 0
x_lock_depdocs_on_canc_sup_ord 416 416 0 0.00 0 9901 362 0 0
x_make_qstorno_1000_1200 5416 5416 0 0.00 2 35441 1227 0 0
x_make_qstorno_1200_2000 5387 5387 0 0.00 2 71242 3314 0 0
x_make_qstorno_2100_3300 458523 458523 0 0.00 0 63410 167 0 0

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

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:04 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:10 8347 8192000000 10166526096 10462253056 888038576 9.780 72 53 109 1 907701136 2367504 17295056
19:57:28 23867 8192000000 10316876880 10630864896 1355461984 14.197 100 80 158 1 1385054416 4061232 25531200
19:58:02 33850 8192000000 10373751536 10694840320 1418572768 14.760 100 86 172 0 1452893056 6203216 28117072
19:58:58 14355 8192000000 10405398656 10735689728 1464117920 15.162 100 87 174 0 1499303632 7454416 27731296
19:59:27 20314 8192000000 10419425616 10752851968 1476017696 15.267 100 82 164 1 1510543088 8071968 26453424
20:00:07 18546 8192000000 10463009120 10797727744 1502846144 15.501 100 89 179 0 1539969056 8538960 28583952
20:00:40 15657 8192000000 10467555744 10808094720 1525504048 15.698 100 88 176 0 1562677040 9296176 27876816
20:01:06 18640 8192000000 10494128736 10835468288 1541800000 15.839 100 82 164 0 1577658624 9809632 26048992
20:01:33 15623 8192000000 10507878992 10856710144 1559378320 15.991 100 80 160 0 1595116944 10530496 25208128
20:01:59 21881 8192000000 10536034976 10891808768 1579947088 16.168 100 78 156 1 1614935616 11345792 23642736
20:02:36 10984 8192000000 10569443440 10923880448 1621565408 16.523 100 86 172 2 1659433280 12049296 25818576
20:02:59 10705 8192000000 10575013488 10939949056 1641879152 16.696 100 81 162 2 1678838720 12665760 24293808
20:03:17 10593 8192000000 10608526272 10970947584 1663539360 16.879 100 85 170 2 1701511744 12799120 25173264
20:03:36 9146 8192000000 10624593648 10991157248 1679035600 17.009 100 81 160 0 1715592592 13203184 23353808
20:03:59 7998 8192000000 10643440000 11014475776 1700216096 17.187 100 76 152 0 1735102432 13025856 21860480
20:04:15 7622 8192000000 10657429376 11027320832 1715045600 17.311 100 82 163 1 1752661104 14191440 23424064
20:04:30 6168 8192000000 10670432816 11045556224 1724724256 17.392 100 78 156 0 1760096752 12990544 22381952
20:04:43 10142 8192000000 10660666720 11042746368 1736707360 17.491 100 73 146 1 1770500432 13262576 20530496
20:05:01 3325 8192000000 10689103456 11064180736 1748965344 17.593 100 78 156 1 1784506992 13498496 22043152
20:05:11 3210 8192000000 10693385488 11072823296 1759518224 17.680 100 82 163 0 1795679808 13161232 23000352
20:05:25 4292 8192000000 10714854528 11093811200 1776024736 17.817 100 83 166 3 1812292544 12704592 23563216
20:05:36 2682 8192000000 10721592064 11100352512 1780996784 17.858 100 93 185 1 1821605088 14440832 26167472
20:05:46 7481 8192000000 10723265296 11109924864 1787243072 17.909 100 84 165 1 1823927856 13266064 23418720
20:05:59 6094 8192000000 10717722400 11107033088 1788368880 17.918 100 71 142 2 1820713328 12768368 19576080
20:06:13 3443 8192000000 10739767456 11125780480 1803774912 18.045 100 79 158 0 1838219680 12094864 22349904
20:06:23 3338 8192000000 10757047232 11142971392 1813562784 18.125 100 80 158 2 1848829344 12589024 22677536
20:06:34 2903 8192000000 10758146896 11143442432 1822840992 18.201 100 89 178 2 1861438240 14184912 24412336
20:06:43 1973 8192000000 10777447680 11161788416 1832150368 18.277 100 89 177 1 1871974208 14960048 24863792
20:06:51 2376 8192000000 10773125440 11158679552 1836657664 18.314 100 91 182 1 1876003280 13941248 25404368
20:07:00 1748 8192000000 10772023936 11161612288 1835391024 18.303 100 88 175 0 1872400544 13226400 23783120
20:07:08 1245 8192000000 10780467424 11167612928 1841798576 18.355 100 90 179 1 1879380896 12780896 24801424
20:07:16 2780 8192000000 10784255440 11171590144 1842405328 18.360 100 91 181 1 1881390912 13776128 25209456
20:07:25 1396 8192000000 10787792048 11178057728 1847607968 18.403 100 93 185 2 1888035504 13548800 26878736
20:07:33 2063 8192000000 10790508992 11178754048 1848751840 18.412 100 91 179 0 1886638544 13001648 24885056
20:07:41 2251 8192000000 10802537168 11185491968 1856861792 18.478 100 87 174 1 1892772320 11930096 23980432
20:07:50 1767 8192000000 10802678816 11188035584 1856638448 18.476 100 94 187 1 1894934720 12296048 26000224
20:07:58 1855 8192000000 10808409680 11193032704 1861364544 18.514 100 96 191 4 1903078320 14887392 26826384
20:08:06 1235 8192000000 10802315872 11190607872 1865456224 18.547 100 92 184 1 1905101888 13369584 26276080
20:08:13 25500 8192000000 10774973936 11193544704 1860344160 18.506 100 43 83 1 1880429520 7512944 12572416
20:08:57 3175 8192000000 10806863520 11207057408 1871205632 18.594 100 67 133 2 1899171664 8608416 19357616
20:09:07 14657 8192000000 10806006240 11208720384 1873210496 18.610 100 58 116 2 1897789536 8676672 15902368
20:09:28 5640 8192000000 10789731568 11206356992 1870027792 18.584 100 41 82 0 1891015776 9728128 11259856
20:09:41 5283 8192000000 10793140320 11213246464 1877025680 18.641 100 50 98 0 1900344064 9962160 13356224
20:09:53 4667 8192000000 10793005264 11212955648 1878742784 18.655 100 43 83 2 1898206448 7558992 11904672
20:10:04 6201 8192000000 10797440032 11219398656 1879334528 18.660 100 29 58 0 1895361712 7990512 8036672
20:10:17 5403 8192000000 10793545776 11217883136 1880488656 18.669 100 27 54 2 1894244688 5950704 7805328
20:10:30 5988 8192000000 10794121776 11219210240 1885013456 18.706 100 35 71 1 1901045936 5776320 10256160
20:10:47 12168 8192000000 10788379040 11219984384 1882607920 18.686 100 19 38 0 1893879984 5647440 5624624
20:11:05 6286 8192000000 10786095552 11222757376 1883444608 18.693 100 18 36 2 1894276688 5660432 5171648
20:11:20 5078 8192000000 10795936944 11224739840 1888698704 18.735 100 25 50 0 1901982784 6542352 6741728
20:11:32 9511 8192000000 10792475072 11229573120 1888130464 18.731 100 19 38 1 1899582624 6055824 5396336
20:11:47 5555 8192000000 10815149888 11233185792 1892724176 18.768 100 36 72 1 1909538992 6439872 10374944
20:12:04 7530 8192000000 10793466688 11228708864 1889529472 18.742 100 19 36 2 1900974320 6099904 5344944
20:12:18 8591 8192000000 10797602928 11233587200 1892110960 18.763 100 13 26 1 1901498240 5856320 3530960
20:12:33 6342 8192000000 10814354064 11244630016 1896264960 18.796 100 17 34 0 1911475920 10719872 4491088
20:12:47 66723 8192000000 10856468240 11258572800 1906721040 18.880 100 63 125 2 1931416640 6134368 18561232
20:14:00 4812 8192000000 10822313616 11254374400 1906342976 18.877 100 43 86 3 1927944304 9443200 12158128
20:14:11 6491 8192000000 10814537520 11248111616 1902206176 18.844 100 22 44 2 1914099520 5595504 6297840
20:14:28 8763 8192000000 10827974400 11256856576 1905940320 18.874 100 27 54 0 1920875984 7546480 7389184
20:14:44 7322 8192000000 10815834800 11255959552 1907835296 18.889 100 23 46 0 1920952656 6755984 6361376
20:14:59 4593 8192000000 10814019344 11257413632 1907924576 18.890 100 16 32 0 1918794464 6530704 4339184
20:15:10 6231 8192000000 10821485840 11260395520 1912119808 18.924 100 32 62 1 1927738432 6656176 8962448
20:15:24 8198 8192000000 10811581312 11247017984 1872009744 18.601 98 20 38 0 1883566256 5541968 6014544
20:15:40 8866 8192000000 10818717024 11255427072 1908112752 18.891 100 28 56 2 1922837584 6877584 7847248
20:15:56 11643 8192000000 10817673680 11258998784 1908701728 18.896 100 22 43 2 1920880528 6305952 5872848
20:16:15 45021 8192000000 10835675968 11264872448 1915252576 18.949 100 54 106 1 1937024688 5796432 15975680
20:17:07 5023 8192000000 10821262880 11246788608 1888713856 18.735 99 30 60 0 1904754352 7172992 8867504
20:17:22 8431 8192000000 10795777328 11217670144 1818740704 18.167 96 24 48 3 1830649120 5472832 6435584
20:17:37 7604 8192000000 10788066160 11210760192 1825203008 18.220 97 18 33 6 1835281824 5306016 4772800
20:17:53 5134 8192000000 10784722368 11208577024 1838013088 18.325 98 34 68 0 1854763216 7132528 9617600
20:18:06 5033 8192000000 10756597808 11178082304 1798002816 17.998 97 34 68 1 1814141856 6263312 9875728
20:18:18 8580 8192000000 10737734624 11150839808 1744756816 17.558 95 20 41 1 1756365600 5706672 5902112
20:18:33 8949 8192000000 10746826832 11168542720 1814484544 18.133 99 35 70 0 1831098368 6705312 9908512
20:18:52 3385 8192000000 10750997008 11160178688 1808015600 18.080 99 45 86 1 1826515792 5784976 12715216
20:19:03 10249 8192000000 10729378272 11154980864 1767189872 17.744 96 15 30 0 1776913248 5135056 4588320
20:19:19 5389 8192000000 10718724208 11138289664 1766613744 17.739 97 20 40 0 1778357504 5843552 5900208
20:19:34 7438 8192000000 10735975760 11149307904 1786620336 17.904 98 31 62 2 1801788544 6238912 8929296
20:19:49 5009 8192000000 10725539856 11147845632 1799425536 18.009 99 25 52 0 1812203360 5736848 7040976
20:20:00 16924 8192000000 10747033344 11166576640 1809678000 18.093 99 24 48 1 1823595712 6434784 7482928
20:20:23 59883 8192000000 10691127952 11103784960 1664798064 16.889 92 38 76 3 1680771440 4994240 10979136
20:21:36 11730 8192000000 10682013024 11083935744 1712584944 17.290 96 15 30 0 1722996432 5428432 4983056
20:21:57 10118 8192000000 10700999120 11116888064 1775745872 17.814 99 33 66 0 1791949504 6647648 9555984
20:22:14 8854 8192000000 10730868224 11146309632 1791613264 17.945 99 24 49 2 1804696656 6097712 6985680
20:22:31 7058 8192000000 10740299216 11160694784 1821663680 18.191 100 25 49 0 1834394896 6162880 6568336
20:22:46 6589 8192000000 10740162000 11166609408 1833344064 18.287 100 26 51 3 1846635872 5628752 7663056
20:22:59 6814 8192000000 10751511744 11174060032 1835939872 18.308 100 33 66 2 1851796048 6066672 9789504
20:23:12 10316 8192000000 10745671808 11176861696 1838947616 18.332 100 20 39 2 1850507728 6069584 5490528
20:23:29 9998 8192000000 10759324704 11177918464 1838313200 18.327 100 18 36 2 1849323696 5222784 5787712
20:23:48 8832 8192000000 10756701648 11178172416 1840845424 18.348 100 14 28 0 1850111200 5259568 4006208
20:24:04 12698 8192000000 10773699136 11194257408 1849032528 18.414 100 16 31 2 1859043792 5184400 4826864
20:24:23 9419 8192000000 10776857888 11194146816 1855572912 18.467 100 21 42 1 1867331472 5618432 6140128
20:24:39 6947 8192000000 10779363280 11198779392 1858845600 18.494 100 26 51 2 1871683936 4772528 8065808
20:24:54 13114 8192000000 10769825392 11201839104 1859751664 18.501 100 9 18 2 1868668480 5582896 3333920
20:25:17 71704 8192000000 10773047920 11205455872 1866784672 18.558 100 38 76 1 1884292096 6065680 11441744
20:26:36 9012 8192000000 10779888528 11210833920 1869839440 18.583 100 30 60 1 1884298416 5433456 9025520
20:26:51 22105 8192000000 10811045984 11223982080 1875820160 18.631 100 45 90 2 1895901264 7838784 12242320
20:27:22 8947 8192000000 10838329040 11246714880 1894195888 18.780 100 65 130 1 1922173840 10195344 17782608
20:27:51 9327 8192000000 10842290640 11251572736 1905918256 18.874 100 69 136 0 1936079136 11833072 18327808
20:28:07 19135 8192000000 10859361888 11265466368 1911900656 18.922 100 74 146 3 1945190560 12576816 20713088
20:28:41 16700 8192000000 10850788016 11266994176 1912797776 18.929 100 51 102 0 1938861120 11943616 14119728
20:29:07 26883 8192000000 10851077424 11281281024 1924902336 19.026 100 37 74 1 1946985904 10408384 11675184
20:29:41 22382 8192000000 10865115280 11293995008 1935704064 19.112 100 37 72 3 1956379888 9936544 10739280
20:30:14 35160 8192000000 10880733424 11306885120 1948433792 19.214 100 30 60 1 1969004096 12164928 8405376
20:31:00 8421 8192000000 10894613984 11320385536 1955265344 19.268 100 50 96 0 1983774224 13307776 15201104
20:31:18 6725 8192000000 10898903568 11327066112 1960970464 19.314 100 53 104 1 1992196992 15977472 15249056
20:31:40 29496 8192000000 10901803328 11330072576 1967874304 19.369 100 62 124 0 2005370480 17846832 19649344
20:32:17 35976 8192000000 10895317056 11335315456 1967563808 19.366 100 42 84 1 1997144080 17331280 12248992
20:33:02 21365 8192000000 10895519088 11334963200 1966957360 19.361 100 27 54 1 1990301568 15495616 7848592
20:33:32 10389 8192000000 10910560032 11343929344 1975087440 19.426 100 47 92 0 2005672848 15851264 14734144
20:33:51 6393 8192000000 10924458992 11353325568 1978975392 19.457 100 54 106 0 2012231808 17695472 15560944
20:34:06 5211 8192000000 10928635536 11354005504 1980248848 19.467 100 59 117 0 2016420896 19482368 16689680
20:34:25 16368 8192000000 10927283376 11364073472 1985635968 19.509 100 51 103 0 2021566336 20693728 15236640
20:34:48 11507 8192000000 10941704176 11374964736 1991862800 19.559 100 56 112 0 2030164176 22066800 16234576
20:35:07 6861 8192000000 10938774448 11364786176 1975612512 19.430 99 67 129 1 2017011520 22037216 19361792
20:35:26 15361 8192000000 10945342512 11372339200 1989016400 19.536 100 66 130 1 2031537760 24009760 18511600
20:35:52 3290 8192000000 10953815936 11372064768 1990692368 19.549 100 71 143 1 2036110016 24171344 21246304
20:36:04 1990 8192000000 10961127648 11378745344 1995783680 19.589 100 78 154 0 2044336672 25659440 22893552
20:36:23 19796 8192000000 10945769408 11385004032 1999505952 19.619 100 56 110 2 2039429408 24072048 15851408
20:37:00 17167 8192000000 10951583952 11396853760 2008770352 19.692 100 42 84 2 2047767584 26859856 12137376
20:37:24 11508 8192000000 10967728960 11411709952 2018252480 19.766 100 39 78 1 2057658848 27500720 11905648
20:37:45 12741 8192000000 10984655728 11422228480 2026215664 19.829 100 50 100 1 2071987616 30397584 15374368
20:38:14 6425 8192000000 10987635152 11424841728 2012686192 19.723 99 53 106 2 2061970000 33050064 16233744
20:38:29 15245 8192000000 11010238800 11437768704 2039288304 19.931 100 76 151 2 2100347232 38463392 22595536
20:38:52 3602 8192000000 11008696800 11437977600 2038293392 19.924 100 78 156 0 2098217680 35862464 24061824
20:39:05 7752 8192000000 11011268160 11442024448 2044402944 19.971 100 81 159 2 2102148160 34652160 23093056
20:39:24 3665 8192000000 11005284848 11439128576 2044119696 19.969 100 65 128 1 2095696832 32182960 19394176
20:39:35 5339 8192000000 11015961152 11446059008 2046951520 19.991 100 68 134 0 2101640480 32784544 21904416
20:39:50 6072 8192000000 11027382736 11451805696 2050545328 20.019 100 63 126 1 2102355616 33084192 18726096
20:40:05 2528 8192000000 11026431648 11455410176 2056191376 20.063 100 75 150 2 2113432128 34416368 22824384
20:40:14 4342 8192000000 11020946352 11450621952 2047677936 19.997 100 66 132 1 2103105504 35205376 20222192
20:40:31 2701 8192000000 11028464800 11453218816 2050099248 20.016 100 75 147 2 2108510480 35826912 22584320
20:40:43 3097 8192000000 11017486144 11445198848 2045304672 19.978 100 73 146 1 2104279152 36768464 22206016
20:40:52 8516 8192000000 11027535072 11455094784 2050337200 20.018 100 79 157 2 2112296384 37783760 24175424
20:41:12 13066 8192000000 10999969728 11433390080 1990483392 19.548 97 60 118 1 2047760880 38070944 19206544
20:41:33 3803 8192000000 11019412992 11448958976 2038198160 19.923 100 70 139 4 2099723840 40093120 21432560
20:41:51 3402 8192000000 11016198064 11447611392 2035752016 19.904 100 64 127 0 2099109936 43326208 20031712
20:42:01 6057 8192000000 11003169440 11433304064 2001654560 19.636 98 69 136 2 2067379952 43420864 22304528
20:42:15 1823 8192000000 11014889280 11434143744 2026084784 19.828 100 80 160 1 2096431888 44777648 25569456
20:42:24 3956 8192000000 11030455888 11451621376 2037318272 19.916 100 78 156 0 2109455536 47121248 25016016
20:42:35 2554 8192000000 11014997824 11442855936 2030871584 19.865 100 75 145 2 2101433200 47680784 22880832
20:42:45 2182 8192000000 11034499152 11453100032 2035887552 19.905 100 88 177 0 2114121392 50598624 27635216
20:42:54 1265 8192000000 11049522400 11469537280 2043703200 19.966 100 90 182 0 2121702176 49568288 28430688
20:43:03 2716 8192000000 11017635680 11436912640 2008388496 19.689 99 89 174 2 2085617408 49728128 27500784
20:43:13 3659 8192000000 11005170912 11428691968 2015436784 19.744 100 80 158 1 2085894336 45480416 24977136
20:43:24 1334 8192000000 10983870256 11404607488 1985914064 19.511 98 82 163 0 2053773648 41095808 26763776
20:43:32 3865 8192000000 10991099776 11409203200 2000338560 19.625 100 71 141 1 2068379408 45974016 22066832
20:43:56 8502 8192000000 10968194480 11400667136 1986298592 19.515 99 56 109 1 2046563072 43120352 17144128
20:44:16 8569 8192000000 10974208000 11411206144 1995948128 19.591 100 57 112 1 2059920304 46239424 17732752
20:44:33 2714 8192000000 11000043888 11421626368 2008164288 19.687 100 81 161 1 2081157280 47804800 25188192
20:44:44 3412 8192000000 10979892832 11395743744 1975815408 19.432 99 83 165 2 2051231168 48775584 26640176
20:44:56 6488 8192000000 10959285488 11383488512 1979375936 19.460 100 67 133 2 2048268832 47512320 21380576
20:45:10 5265 8192000000 10965003936 11386621952 1953365024 19.253 98 75 148 0 2022168112 44839728 23963360
20:45:21 3055 8192000000 10956574400 11364130816 1960923968 19.313 100 73 145 0 2032548768 48076400 23548400
20:45:31 3817 8192000000 10975764816 11392061440 1984939296 19.504 100 81 162 0 2060062976 49643968 25479712
20:45:41 3077 8192000000 10978649584 11393728512 1972067248 19.402 99 80 159 2 2046090720 49299008 24724464
20:45:53 2888 8192000000 10995173984 11407282176 1973556240 19.414 99 80 160 0 2052224464 53536064 25132160
20:46:04 4610 8192000000 10986859504 11401486336 1984725584 19.502 100 84 168 1 2066869840 55060528 27083728
20:46:18 2080 8192000000 10991504176 11401019392 1987604224 19.525 100 91 184 0 2071616544 55273584 28738736
20:46:27 3695 8192000000 10991164672 11406028800 1987871552 19.527 100 89 178 0 2074526208 58609296 28045360
20:46:38 3137 8192000000 10999847568 11413213184 1992584672 19.564 100 86 171 1 2079376640 58727936 28064032
20:46:48 2992 8192000000 10992598880 11402878976 1984307792 19.499 100 90 178 0 2071792800 59299312 28185696
20:47:00 3687 8192000000 10987987696 11399938048 1969048464 19.378 99 84 168 0 2054194272 58091120 27054688
20:47:11 3247 8192000000 10963257888 11388051456 1971221328 19.395 100 67 134 0 2052871872 59458720 22191824
20:47:28 4601 8192000000 10936962336 11357020160 1942017072 19.163 99 69 137 0 2022743712 59163088 21563552
20:47:39 9035 8192000000 10936367376 11373039616 1956582608 19.279 100 41 82 2 2021705616 51125472 13997536
20:48:00 4074 8192000000 10933856512 11347304448 1919902176 18.986 98 66 131 0 1991628624 50842832 20883616
20:48:11 2303 8192000000 10949113360 11354173440 1923525344 19.015 98 91 179 2 2007159072 55375424 28258304
20:48:21 2189 8192000000 10958663936 11367571456 1938076352 19.131 99 86 172 1 2023403696 58382496 26944848
20:48:29 3724 8192000000 10918232592 11338600448 1918696704 18.976 99 63 126 1 1997992592 59227760 20068128
20:48:40 8512 8192000000 10923605872 11351834624 1934691792 19.104 100 57 114 1 2013700128 59428752 19579584
20:48:58 12822 8192000000 10907958048 11333967872 1909190304 18.900 99 42 84 1 1985052832 61185824 14676704
20:49:18 8305 8192000000 10912047200 11337412608 1903907904 18.858 99 50 101 1 1982906000 61462656 17535440
20:49:41 8904 8192000000 10919269216 11348676608 1928624944 19.056 100 54 108 2 2011203440 64292000 18286496
20:49:56 4125 8192000000 10926177888 11357380608 1927474288 19.047 100 45 88 1 2009614400 66342688 15797424
20:50:26 16542 8192000000 10918285392 11359293440 1925519472 19.031 100 38 74 3 2006022512 66752928 13750112
20:50:59 14236 8192000000 10938791936 11371909120 1934661600 19.104 100 48 96 1 2024877040 73235264 16980176
20:51:29 4918 8192000000 10924921536 11370102784 1913356784 18.934 99 35 70 3 2000548912 74716752 12475376
20:51:48 23995 8192000000 10922492896 11371778048 1922392624 19.006 100 27 54 2 1997761008 65402320 9966064
20:52:23 30162 8192000000 10903222464 11367116800 1902316176 18.845 99 27 54 1 1980269088 67606848 10346064
20:53:08 20135 8192000000 10893688560 11371843584 1910351424 18.909 100 26 52 0 1987575088 68003648 9220016
20:53:43 51978 8192000000 10838011072 11312160768 1892161488 18.763 100 9 18 0 1934573120 39140784 3270848
20:54:41 59171 8192000000 10846851696 11308331008 1895690816 18.792 99 13 26 0 1913365808 13700432 3974560
20:55:46 32922 8192000000 10854264688 11317886976 1908401376 18.894 99 9 17 0 1920423888 9179344 2843168
20:56:39 83203 8192000000 10845460832 11300409344 1826698816 18.232 94 27 52 3 1841147120 7809904 6638400
20:58:11 61110 8192000000 10878625088 11325128704 1920033856 18.987 99 18 36 0 1933844704 8790832 5020016
20:59:22 62537 8192000000 10896650048 11336032256 1936201760 19.116 99 27 51 1 1957792976 13900960 7690256
21:00:35 97416 8192000000 10905628336 11353288704 1954927984 19.266 100 20 40 1 1970748368 9888640 5931744
21:03:02 102611 8192000000 10885483200 11353862144 1911588960 18.919 97 20 40 2 1933236064 16013920 5633184
21:05:08 31461 8192000000 10882057824 11358101504 1951335664 19.237 100 10 20 0 1968302784 13980432 2986688
21:05:46 4975 8192000000 10885151424 11360120832 1953600240 19.255 100 10 20 1 1970714272 14476752 2637280
21:06:00 5232 8192000000 10887957936 11338481664 1934578864 19.103 99 35 70 0 1955460752 11104352 9777536
21:06:11 21806 8192000000 10895794016 11348381696 1957761760 19.288 100 34 68 2 1975081584 7356752 9963072
21:06:41 20981 8192000000 10909276192 11347783680 1958460800 19.294 100 45 90 2 1978188816 6719040 13008976
21:07:10 19923 8192000000 10910674048 11354832896 1964576160 19.342 100 40 80 0 1984933728 9100128 11257440
21:07:37 10474 8192000000 10929007568 11368742912 1977067312 19.441 100 61 122 0 2004349168 10532640 16749216
21:08:00 14192 8192000000 10915571840 11363397632 1972645840 19.406 100 29 58 0 1989336464 8641520 8049104
21:08:20 8920 8192000000 10921685056 11371442176 1980794432 19.471 100 59 119 2 2007345744 9751360 16799952
21:08:39 18416 8192000000 10911559568 11376312320 1980347744 19.467 100 40 80 2 2002623872 11298624 10977504
21:09:04 47868 8192000000 10897001776 11374411776 1958089200 19.291 99 16 30 0 1976545696 13087360 5369136
21:09:59 60880 8192000000 10907974016 11382829056 1976048064 19.433 100 19 38 0 1995274864 13172016 6054784
21:11:35 43286 8192000000 10913358560 11391614976 1992496048 19.564 100 14 29 1 2011359696 14626016 4237632
21:12:28 138468 8192000000 10904249968 11368620032 1927292112 19.045 97 21 42 0 1939639264 6472288 5874864
21:15:06 35901 8192000000 10913655408 11372933120 1963588848 19.335 99 39 78 1 1984964880 10326464 11049568
21:15:55 31484 8192000000 10890773392 11372011520 1975148480 19.426 100 15 31 2 1988413184 9353264 3911440
21:18:09 44148 8192000000 10921056544 11398451200 1988486096 19.532 100 12 24 1 2001017456 8323312 4208048
21:19:07 61026 8192000000 10914019600 11382140928 1975543040 19.429 99 31 61 1 1993766928 9694752 8529136
21:20:16 39088 8192000000 10917950112 11388628992 1984773040 19.502 100 19 38 1 1999006416 8445936 5787440
21:21:01 49984 8192000000 10922197920 11389702144 1974111056 19.418 99 22 45 3 1991560448 10959392 6490000
21:22:01 79177 8192000000 10908527424 11380432896 1911999568 18.923 96 15 30 0 1928588336 12592912 3995856
21:23:26 52611 8192000000 10937825376 11399139328 1970180208 19.387 99 27 53 0 1992750160 15094032 7475920
21:24:59 58496 8192000000 10930553648 11410542592 1950052176 19.227 98 14 28 0 1979712400 24729136 4931088
21:26:15 37416 8192000000 10915422016 11388649472 1953639120 19.255 98 21 42 0 1981288736 20894496 6755120
21:27:00 28457 8192000000 10940527792 11394379776 1971363424 19.396 99 24 48 3 1995273312 17344496 6565392
21:27:40 54988 8192000000 10923678320 11403231232 1948103808 19.211 98 7 14 0 1969017088 18611536 2301744
21:28:43 48456 8192000000 10916164256 11382632448 1934042128 19.099 97 6 12 1 1950171216 13947312 2181776
21:29:38 98318 8192000000 10896773680 11374686208 1834895680 18.299 93 16 32 1 1851811776 11752208 5163888
21:31:25 90957 8192000000 10876104976 11338317824 1880564656 18.670 95 25 50 0 1896595664 9265696 6765312
21:33:02 27907 8192000000 10893408912 11341729792 1938577440 19.135 99 50 100 0 1962066832 9236832 14252560
21:33:44 54600 8192000000 10875618048 11352764416 1953072656 19.251 100 29 58 1 1974923328 12354128 9496544
21:34:55 53258 8192000000 10842586768 11316326400 1897959408 18.810 98 11 22 1 1911967392 11007680 3000304
21:36:04 50541 8192000000 10846363824 11328061440 1878498352 18.653 97 6 12 0 1893276448 12178912 2599184
21:37:01 13311 8192000000 10857844304 11338698752 1933967968 19.099 100 4 8 0 1944147408 9155360 1024080
21:37:26 47695 8192000000 10870359904 11341799424 1933164832 19.092 99 18 36 1 1947416032 9025472 5225728
21:38:20 80614 8192000000 10871994560 11349979136 1893422224 18.773 97 25 49 0 1913726320 13448432 6855664
21:39:48 30969 8192000000 10848838960 11326926848 1846482096 18.394 95 11 22 0 1866337904 16703632 3152176
21:40:39 58031 8192000000 10837253616 11304628224 1837788128 18.323 95 15 30 2 1862493728 20186880 4518720
21:41:43 83874 8192000000 10851507184 11334250496 1915485728 18.951 100 13 25 2 1934142896 15010064 3647104
21:43:13 28551 8192000000 10883198400 11331006464 1931594992 19.080 100 35 70 0 1951465120 8953856 10916272
21:43:54 32960 8192000000 10868114544 11334877184 1907659520 18.888 98 34 68 1 1926793088 9929344 9204224
21:44:41 64627 8192000000 10821604000 11308208128 1822423376 18.197 94 16 33 1 1843532816 15928176 5181264
21:46:03 66204 8192000000 10852675616 11319328768 1874937344 18.624 98 12 24 1 1891238880 13042400 3259136
21:47:38 17456 8192000000 10876232560 11327811584 1929297616 19.061 100 38 76 3 1952726304 12871184 10557504
21:48:02 10764 8192000000 10876715488 11322019840 1917508272 18.967 99 47 92 2 1940525392 10305360 12711760
21:48:19 7386 8192000000 10870582496 11312603136 1906700144 18.880 99 54 108 2 1932940176 11277904 14962128
21:48:32 10331 8192000000 10872876688 11311939584 1889346384 18.741 98 55 110 4 1916558640 12021312 15190944
21:48:50 35078 8192000000 10879823648 11325177856 1907475344 18.886 99 57 113 3 1936285072 13771152 15038576
21:49:32 29066 8192000000 10873303520 11328524288 1889364848 18.741 98 34 68 1 1912372864 13434304 9573712
21:50:14 71679 8192000000 10846592880 11320303616 1883049216 18.690 98 17 34 0 1907926704 19863632 5013856
21:52:11 114770 8192000000 10881884592 11326554112 1911018800 18.915 98 22 45 0 1926000800 9353392 5628608
21:54:12 69773 8192000000 10879044208 11349794816 1935776320 19.113 99 29 59 1 1954591840 10588016 8227504
21:55:40 12630 8192000000 10876281280 11352752128 1950298848 19.229 100 19 38 1 1965978256 10257440 5421968
21:55:59 38652 8192000000 10894292672 11359817728 1957332080 19.285 100 27 54 0 1974434544 9269152 7833312
21:56:46 48626 8192000000 10869130320 11348336640 1944463952 19.182 99 23 46 0 1960932656 9948592 6520112
21:58:42 61570 8192000000 10874650256 11353313280 1938053280 19.131 99 5 10 0 1946297152 7317520 926352
21:59:50 39647 8192000000 10875379152 11335409664 1940019152 19.147 99 11 22 1 1951560768 7995664 3545952
22:00:36 41858 8192000000 10902809344 11379044352 1969697888 19.383 100 21 42 1 1989594544 13550416 6346240
22:01:33 40197 8192000000 10916658512 11389161472 1982707696 19.486 100 17 34 1 2001673040 14212480 4752864
22:02:34 56146 8192000000 10892680128 11367182336 1918262960 18.973 97 13 26 0 1938909152 17006016 3640176
22:03:36 81577 8192000000 10901085696 11368759296 1931933344 19.082 98 12 24 1 1945901504 10907840 3060320
22:05:06 71553 8192000000 10910149712 11393568768 1978345200 19.452 100 30 60 2 1999425200 12445312 8634688
22:06:36 117864 8192000000 10927450608 11382890496 1960713632 19.312 99 20 40 1 1979171952 13022784 5435536
22:08:40 64503 8192000000 10922783840 11400314880 1986727440 19.518 100 20 40 0 2006370624 14029760 5613424
22:09:57 65493 8192000000 10927323664 11405365248 1973083456 19.410 99 11 23 0 1994931472 18659440 3188576
22:11:09 99181 8192000000 10932229200 11404439552 1909522960 18.903 96 20 40 2 1928375920 13690176 5162784
22:13:42 83068 8192000000 10894991696 11366645760 1881582032 18.678 95 9 18 0 1896462512 12385360 2495120
22:15:11 69368 8192000000 10895756656 11352035328 1923022448 19.011 98 22 42 1 1935136208 6466176 5647584
22:16:33 47821 8192000000 10912810928 11387609088 1968812704 19.376 100 20 40 1 1984401328 10051824 5536800
22:17:27 44702 8192000000 10911900512 11387932672 1966560352 19.358 99 19 38 2 1989933792 17671456 5701984
22:18:58 94276 8192000000 10896135488 11378446336 1889363552 18.741 95 18 36 0 1912915296 18357120 5194624
22:21:37 60874 8192000000 10891360656 11369345024 1951220240 19.236 99 17 34 0 1965043040 9400368 4422432
22:23:14 70805 8192000000 10891937152 11353698304 1917998624 18.971 98 20 40 0 1932073088 8180672 5893792
22:24:50 72222 8192000000 10884140320 11369234432 1955617488 19.271 100 12 24 0 1973916912 14897376 3402048
22:26:24 52579 8192000000 10021250128 10410496000 1122962240 12.055 57 7 14 0 1135389072 9716464 2710368

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 22-11-2020 22:29:24 to 22-11-2020 22:29:56.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 96 v_add_invoice_to_stock 335544517
except 2 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 22-11-2020 22:29:57 to 22-11-2020 22:29:59.

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          233877
MON$OLDEST_ACTIVE               234753
MON$OLDEST_SNAPSHOT             234753
MON$NEXT_TRANSACTION            234753
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                       2030560
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33393 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33393 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33393 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33393 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
:100: 
:101: mscs-test-161.budzdorov.ru    Sun Nov 22 22:27:22 2020
:102:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:103: 
:104: 
:105: mscs-test-161.budzdorov.ru    Sun Nov 22 22:27:27 2020
:106:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:107: 
--- end of diff output ---

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

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