Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 10.11.2020 16: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 17214268 kB
MemAvailable 31419692 kB
Buffers 0 kB
Cached 14446308 kB
SwapCached 2916 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.7
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-10 16:27:03
DTS_END                         2020-11-10 16:27:03.6950
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/43052
TRN_ID                          249082
ATT_ID                          735
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: 9648.28 19900 1157793
customer order: creation 181.93 312 21831
customer order: refuse 15.18 377 1822
order to supplier: creation 49.51 1279 5941
order to supplier: removal 3.79 90982 455
invoice (draft): creation 48.74 3156 5849
invoice (draft): removal 54.45 778 6534
invoice accept: apply 43.43 17110 5212
invoice accept: cancel 49.20 837 5904
customer reserve: creation 4041.89 168 485027
customer reserve: removal 4842.84 56 581141
realization accept: apply 90.53 177 10864
realization accept: cancel 89.70 98 10764
payment from customer: creation 63.12 110 7574
payment from customer: removal 5.89 77 707
payment to supplier: creation 51.68 119 6202
payment to supplier: removal 3.78 64 454
service: total inventory turnovers 4.63 1375 555
service: total monetary turnovers 6.98 41 837
service: aggregate perf. data 0.97 15604 116
service: refresh index statistics 0.03 265277 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 10-11-2020 16:27:46 to 10-11-2020 16:27:48.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5975
TEST_TIME 2 5487
TEST_TIME 3 4732
TEST_TIME 4 4576
TEST_TIME 5 5644
TEST_TIME 6 5976
TEST_TIME 7 6338
TEST_TIME 8 6673
TEST_TIME 9 6716
TEST_TIME 10 6798
TEST_TIME 11 6749
TEST_TIME 12 6816
TEST_TIME 13 7138
TEST_TIME 14 7517
TEST_TIME 15 7627
TEST_TIME 16 7740
TEST_TIME 17 8603
TEST_TIME 18 8514
TEST_TIME 19 9082
TEST_TIME 20 9218
TEST_TIME 21 9203
TEST_TIME 22 9326
TEST_TIME 23 9624
TEST_TIME 24 9626
TEST_TIME 25 10006
TEST_TIME 26 9683
TEST_TIME 27 10295
TEST_TIME 28 11372
TEST_TIME 29 11301
TEST_TIME 30 11054
TEST_TIME 31 11147
TEST_TIME 32 11053
TEST_TIME 33 10992
TEST_TIME 34 10917
TEST_TIME 35 10865
TEST_TIME 36 11077
TEST_TIME 37 10978
TEST_TIME 38 10818
TEST_TIME 39 10591
TEST_TIME 40 10537
TEST_TIME 41 10448
TEST_TIME 42 10433
TEST_TIME 43 10363
TEST_TIME 44 10304
TEST_TIME 45 10323
TEST_TIME 46 10247
TEST_TIME 47 10178
TEST_TIME 48 10405
TEST_TIME 49 10355
TEST_TIME 50 10251
TEST_TIME 51 10226
TEST_TIME 52 10189
TEST_TIME 53 10244
TEST_TIME 54 10203
TEST_TIME 55 10196
TEST_TIME 56 10210
TEST_TIME 57 10233
TEST_TIME 58 10373
TEST_TIME 59 10343
TEST_TIME 60 10331
TEST_TIME 61 10377
TEST_TIME 62 10317
TEST_TIME 63 10384
TEST_TIME 64 10333
TEST_TIME 65 10428
TEST_TIME 66 10309
TEST_TIME 67 10429
TEST_TIME 68 10353
TEST_TIME 69 10221
TEST_TIME 70 10237
TEST_TIME 71 10164
TEST_TIME 72 10089
TEST_TIME 73 10117
TEST_TIME 74 10084
TEST_TIME 75 10010
TEST_TIME 76 10010
TEST_TIME 77 9924
TEST_TIME 78 9909
TEST_TIME 79 9888
TEST_TIME 80 9899
TEST_TIME 81 9874
TEST_TIME 82 9849
TEST_TIME 83 9811
TEST_TIME 84 9816
TEST_TIME 85 9804
TEST_TIME 86 9827
TEST_TIME 87 9810
TEST_TIME 88 9796
TEST_TIME 89 9915
TEST_TIME 90 9936
TEST_TIME 91 9945
TEST_TIME 92 9933
TEST_TIME 93 9951
TEST_TIME 94 9951
TEST_TIME 95 9972
TEST_TIME 96 9933
TEST_TIME 97 9850
TEST_TIME 98 9898
TEST_TIME 99 9828
TEST_TIME 100 9826
TEST_TIME 101 9768
TEST_TIME 102 9801
TEST_TIME 103 9776
TEST_TIME 104 9743
TEST_TIME 105 9742
TEST_TIME 106 9682
TEST_TIME 107 9680
TEST_TIME 108 9641
TEST_TIME 109 9609
TEST_TIME 110 9610
TEST_TIME 111 9626
TEST_TIME 112 9637
TEST_TIME 113 9673
TEST_TIME 114 9626
TEST_TIME 115 9652
TEST_TIME 116 9681
TEST_TIME 117 9763
TEST_TIME 118 9748
TEST_TIME 119 9734
TEST_TIME 120 9654

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 10-11-2020 16:27:50 to 10-11-2020 16:27:53.

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 1607016 1607016 0 0.00 0 39097 6 0 0
doc_list_biud 1607016 1607016 0 0.00 0 33600 26 0 0
sp_add_invoice_to_stock 5324 5212 112 2.10 37 144834 17111 0 112
sp_cancel_adding_invoice 5904 5904 0 0.00 5 65674 838 0 0
sp_cancel_client_order 1822 1822 0 0.00 4 26929 378 0 0
sp_cancel_customer_reserve 581141 581141 0 0.00 1 28582 56 0 0
sp_cancel_pay_from_customer 707 707 0 0.00 3 4726 77 0 0
sp_cancel_pay_to_supplier 454 454 0 0.00 3 2352 65 0 0
sp_cancel_supplier_invoice 6541 6534 7 0.10 2 18759 778 0 7
sp_cancel_supplier_order 455 455 0 0.00 6 997417 90983 0 0
sp_cancel_write_off 10764 10764 0 0.00 1 15711 98 0 0
sp_client_order 21831 21831 0 0.00 3 28106 312 0 0
sp_customer_reserve 485027 485027 0 0.00 0 95312 169 0 0
sp_fill_shopping_cart 33606 33606 0 0.00 1 17930 38 0 0
sp_fill_shopping_cart_clo_res 485016 485016 0 0.00 0 22416 12 0 0
sp_get_clo_for_invoice 5201 5201 0 0.00 0 24300 233 0 0
sp_kill_cost_storno 17829 17829 0 0.00 0 16149 52 0 0
sp_kill_qstorno_ret_qs2qd 1180035 1180035 0 0.00 0 28574 31 0 0
sp_kill_qty_storno 622684 622684 0 0.00 0 33599 66 0 0
sp_lock_selected_doc 22213 22213 0 0.00 0 7146 6 0 0
sp_make_cost_storno 29840 29840 0 0.00 0 39094 55 0 0
sp_multiply_rows_for_pdistr 29840 29840 0 0.00 0 7752 24 0 0
sp_multiply_rows_for_qdistr 21831 21831 0 0.00 0 28098 139 0 0
sp_pay_from_customer 7574 7574 0 0.00 4 11642 110 0 0
sp_pay_to_supplier 6202 6202 0 0.00 4 12780 120 0 0
sp_payment_common 13776 13776 0 0.00 2 11613 36 0 0
sp_qd_handle_on_cancel_clo 1822 1822 0 0.00 0 26899 335 0 0
sp_qd_handle_on_invoice_upd_sts 11104 11104 0 0.00 0 33598 315 0 0
sp_qd_handle_on_reserve_upd_sts 10864 10864 0 0.00 0 24750 70 0 0
sp_reserve_write_off 10864 10864 0 0.00 6 24768 177 0 0
sp_supplier_invoice 5849 5849 0 0.00 7 82192 3156 0 0
sp_supplier_order 5941 5941 0 0.00 5 35673 1280 0 0
srv_aggregate_perf_data 116 116 0 0.00 2525 123798 15605 0 0
srv_fill_mon_cache_memory 165 165 0 0.00 1364 134107 31704 0 0
srv_find_qd_qs_mism 1107394 1107394 0 0.00 0 9809 5 0 0
srv_make_invnt_saldo 555 555 0 0.00 48 142771 1375 0 0
srv_make_money_saldo 837 837 0 0.00 0 11459 41 0 0
srv_recalc_idx_stat 4 4 0 0.00 116287 368360 265277 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 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5213 5213 0 0.00 0 16062 166 0 0
t$perf-norm:sp_cancel_adding_invoice 478 478 0 0.00 0 3739 70 0 0
t$perf-norm:sp_cancel_client_order 1822 1822 0 0.00 0 4039 12 0 0
t$perf-norm:sp_cancel_customer_reserve 729 729 0 0.00 0 4313 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 707 707 0 0.00 0 1450 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 454 454 0 0.00 0 11480 34 0 0
t$perf-norm:sp_cancel_supplier_invoice 431 431 0 0.00 0 1270 20 0 0
t$perf-norm:sp_cancel_supplier_order 455 455 0 0.00 0 23602 1261 0 0
t$perf-norm:sp_cancel_write_off 1073 1073 0 0.00 0 3148 13 0 0
t$perf-norm:sp_client_order 21831 21831 0 0.00 0 10393 16 0 0
t$perf-norm:sp_customer_reserve 1043 1043 0 0.00 0 901 5 0 0
t$perf-norm:sp_pay_from_customer 7574 7574 0 0.00 0 11477 11 0 0
t$perf-norm:sp_pay_to_supplier 6202 6202 0 0.00 0 5674 10 0 0
t$perf-norm:sp_reserve_write_off 10864 10864 0 0.00 0 4346 8 0 0
t$perf-norm:sp_supplier_invoice 5849 5849 0 0.00 0 8569 19 0 0
t$perf-norm:sp_supplier_order 5941 5941 0 0.00 0 4299 15 0 0
t$perf-norm:srv_aggregate_perf_data 116 116 0 0.00 0 894 20 0 0
t$perf-norm:srv_fill_mon_cache_memory 165 165 0 0.00 0 707 11 0 0
t$perf-norm:srv_make_invnt_saldo 555 555 0 0.00 0 3655 26 0 0
t$perf-norm:srv_make_money_saldo 837 837 0 0.00 0 3699 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 3 40 15 0 0
v_add_invoice_to_stock 10622 10398 224 2.10 0 12937 20 0 224
v_all_customers 39644 39644 0 0.00 0 19 1 0 0
v_all_suppliers 32900 32900 0 0.00 0 19 1 0 0
v_all_wares 43662 43662 0 0.00 0 65 1 0 0
v_cancel_adding_invoice 956 956 0 0.00 0 2536 12 0 0
v_cancel_client_order 3644 3644 0 0.00 0 3946 8 0 0
v_cancel_customer_prepayment 1414 1414 0 0.00 0 3952 6 0 0
v_cancel_customer_reserve 1458 1458 0 0.00 0 1433 5 0 0
v_cancel_payment_to_supplier 908 908 0 0.00 0 2179 7 0 0
v_cancel_supplier_invoice 876 862 14 1.59 0 2619 17 0 14
v_cancel_supplier_order 910 910 0 0.00 0 334 3 0 0
v_cancel_write_off 2146 2146 0 0.00 0 3192 13 0 0
v_max_id_clo_ord 5936 5936 0 0.00 0 902 1 0 0
v_max_id_clo_res 1043 1043 0 0.00 0 2616 14 0 0
v_max_id_ord_sup 5838 5838 0 0.00 0 17922 8 0 0
v_max_non_paid_invoice 1526 1526 0 0.00 0 322 2 0 0
v_max_non_paid_realizn 4103 4103 0 0.00 0 4274 6 0 0
v_min_id_clo_ord 5936 5936 0 0.00 0 17523 21 0 0
v_min_id_clo_res 1043 1043 0 0.00 0 1509 6 0 0
v_min_id_ord_sup 5838 5838 0 0.00 0 4873 8 0 0
v_min_non_paid_invoice 6202 6202 0 0.00 0 10822 23 0 0
v_min_non_paid_realizn 7574 7574 0 0.00 0 11609 26 0 0
v_our_firm 10960 10960 0 0.00 0 154 1 0 0
v_reserve_write_off 21728 21728 0 0.00 0 3851 5 0 0
x_lock_depdocs_on_canc_invoice 12007 12007 0 0.00 0 24511 111 0 0
x_lock_depdocs_on_canc_sup_ord 455 455 0 0.00 0 11947 366 0 0
x_make_qstorno_1000_1200 5941 5941 0 0.00 1 35640 1187 0 0
x_make_qstorno_1200_2000 5849 5849 0 0.00 3 80466 3036 0 0
x_make_qstorno_2100_3300 485027 485027 0 0.00 0 95311 154 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 10-11-2020 16:27:54 to 10-11-2020 16:27:58.

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
13:57:07 19 8192000000 8806172880 8818950144 8751472 0.106 3 1 2 0 8872176 58144 62560
13:57:14 18122 8192000000 10246794496 10548191232 971550832 10.602 77 65 127 1 996308432 2847696 21909904
13:57:42 31683 8192000000 10340335216 10660724736 1387177904 14.481 100 90 180 0 1421822512 4857056 29787552
13:58:25 16257 8192000000 10371878288 10697236480 1432005152 14.879 100 86 172 0 1466448624 5953136 28490336
13:58:50 31909 8192000000 10414551232 10741293056 1458650992 15.114 100 86 172 0 1493167920 6414000 28102928
13:59:35 20018 8192000000 10425158304 10757595136 1481721952 15.316 100 87 174 0 1517674528 7786816 28165760
14:00:05 20046 8192000000 10446149552 10778861568 1501123856 15.486 100 88 176 1 1537654320 7994384 28536080
14:00:34 16025 8192000000 10455748080 10794606592 1516503888 15.620 100 83 166 0 1550761568 7875840 26381840
14:01:01 23708 8192000000 10496180432 10842157056 1551247840 15.921 100 78 154 0 1583224208 8576144 23400224
14:01:40 17521 8192000000 10530628336 10886070272 1589895152 16.253 100 80 160 2 1623850176 9370768 24584256
14:02:09 15049 8192000000 10564919008 10921693184 1626968128 16.569 100 78 156 1 1660096400 9994336 23133936
14:02:35 16872 8192000000 10588691968 10951405568 1641540656 16.693 100 77 152 1 1674722736 10541248 22640832
14:03:02 11856 8192000000 10620432064 10988285952 1676581440 16.989 100 80 157 2 1710936032 11436624 22917968
14:03:23 14482 8192000000 10640393936 11011993600 1702142512 17.203 100 79 158 0 1736781312 11786400 22852400
14:03:47 6970 8192000000 10653667728 11022196736 1713913168 17.301 100 82 165 0 1749565072 11754640 23897264
14:04:13 7666 8192000000 10670163552 11045703680 1730374800 17.439 100 71 142 0 1762254368 12101872 19777696
14:04:28 9881 8192000000 10682223040 11059113984 1739919728 17.518 100 74 148 0 1773128320 12375808 20832784
14:04:45 5034 8192000000 10684672656 11063631872 1750537168 17.606 100 77 152 3 1785247456 13314192 21396096
14:04:59 6378 8192000000 10704307328 11083857920 1765838528 17.733 100 84 168 2 1804149968 14233680 24077760
14:05:12 4874 8192000000 10704891712 11086585856 1772986528 17.792 100 78 155 0 1807911392 13783968 21140896
14:05:24 3756 8192000000 10718894304 11096334336 1776659296 17.822 100 79 158 4 1812645472 13472944 22513232
14:05:34 4554 8192000000 10728279136 11109019648 1783196608 17.876 100 83 165 3 1819782784 13876080 22710096
14:05:46 6908 8192000000 10717496672 11106930688 1784140368 17.884 100 71 141 1 1817622320 14015152 19466800
14:06:02 3607 8192000000 10748415328 11130990592 1805050640 18.055 100 86 170 0 1842716768 14009760 23656368
14:06:13 3804 8192000000 10760583056 11144474624 1816169456 18.146 100 86 172 0 1854323232 14161840 23991936
14:06:24 3498 8192000000 10763947824 11153428480 1823648560 18.207 100 84 168 2 1861074432 13677104 23748768
14:06:34 3634 8192000000 10760051632 11150143488 1828780304 18.249 100 80 160 0 1863244400 12497808 21966288
14:06:45 3373 8192000000 10773179024 11160707072 1834398192 18.295 100 81 161 0 1869596208 13176928 22021088
14:06:55 2849 8192000000 10782867264 11170598912 1837327872 18.319 100 89 177 2 1875218688 13071984 24818832
14:07:05 2355 8192000000 10790849632 11177328640 1844010288 18.373 100 93 184 0 1884556064 14870720 25675056
14:07:14 2917 8192000000 10794210912 11182141440 1847010016 18.398 100 84 168 0 1884477856 14155712 23312128
14:07:25 2710 8192000000 10791982032 11182698496 1851053616 18.431 100 91 184 1 1891442880 14950976 25438288
14:07:34 2231 8192000000 10792221632 11183165440 1859082624 18.496 100 92 185 1 1898291856 13710432 25498800
14:07:43 2411 8192000000 10806973968 11193614336 1862578944 18.524 100 91 183 1 1901242992 12381616 26282432
14:07:52 1168 8192000000 10807647776 11196317696 1869520016 18.580 100 92 184 0 1908479664 12623312 26336336
14:08:00 2908 8192000000 10807899056 11202293760 1867954048 18.568 100 84 167 0 1905725696 14177104 23594544
14:08:09 1535 8192000000 10817862144 11205525504 1871310736 18.595 100 92 183 1 1909425280 12192672 25921872
14:08:17 4366 8192000000 10813818256 11206639616 1871179344 18.594 100 87 172 2 1908887904 12710624 24997936
14:08:30 4961 8192000000 10809033888 11203026944 1871937744 18.600 100 81 163 0 1905596800 10102496 23556560
14:08:42 1428 8192000000 10816071376 11209248768 1876017872 18.633 100 80 161 0 1911215744 12321456 22876416
14:09:00 1701 8192000000 10820775312 11209678848 1874648528 18.622 100 83 166 1 1910528560 12681760 23198272
14:09:08 1502 8192000000 10819114784 11214364672 1877571600 18.645 100 87 174 2 1915703696 12450080 25682016
14:09:16 11673 8192000000 10811956064 11207950336 1876779552 18.639 100 70 140 2 1907419328 11179680 19460096
14:09:34 7378 8192000000 10804713488 11215851520 1875738080 18.631 100 51 100 0 1899528192 10000288 13789824
14:09:49 5309 8192000000 10782476064 11208810496 1878718720 18.655 100 46 92 0 1899845776 7993264 13133792
14:10:01 5306 8192000000 10797732512 11214774272 1879239664 18.659 100 42 84 1 1899016368 8198016 11578688
14:10:12 6545 8192000000 10788605536 11213332480 1878838912 18.656 100 32 62 1 1895559712 7727600 8993200
14:10:29 2367 8192000000 10806233872 11222446080 1888684384 18.735 100 54 108 1 1911750080 8191168 14874528
14:10:41 8653 8192000000 10796051104 11224317952 1886462912 18.717 100 24 48 1 1900830160 7538656 6828592
14:10:57 6513 8192000000 10792917088 11225481216 1889283488 18.740 100 25 50 1 1903430432 7159920 6987024
14:11:11 6463 8192000000 10807445536 11231121408 1892766752 18.768 100 37 74 4 1910638240 8291744 9579744
14:11:25 4947 8192000000 10806581600 11233296384 1897185968 18.804 100 35 71 1 1918510480 11600000 9724512
14:11:36 3979 8192000000 10808815600 11235246080 1893177680 18.771 100 24 49 0 1907163984 7365232 6621072
14:11:47 9930 8192000000 10814039152 11236024320 1899659152 18.824 100 21 43 1 1912065920 6821600 5585168
14:12:03 6300 8192000000 10812799952 11243008000 1903942080 18.858 100 26 52 2 1918542112 7507136 7092896
14:12:16 7094 8192000000 10815169024 11244335104 1906667312 18.880 100 29 58 0 1922287696 7750496 7869888
14:12:29 5428 8192000000 10817076480 11242332160 1904705104 18.864 100 29 58 1 1919626544 5659648 9261792
14:12:41 10371 8192000000 10811746848 11242524672 1906870864 18.882 100 17 33 0 1917138608 5776192 4491552
14:13:01 40167 8192000000 10826793920 11255459840 1906372704 18.878 100 24 48 3 1918276160 5413312 6490144
14:13:50 28216 8192000000 10850048400 11258871808 1912196480 18.924 100 47 94 0 1931201424 6136096 12868848
14:14:24 3432 8192000000 10846274528 11267080192 1918234176 18.973 100 69 139 2 1948738160 10998064 19505920
14:14:38 3809 8192000000 10844800576 11264004096 1912355344 18.926 100 39 79 4 1930884800 6875120 11654336
14:14:50 5594 8192000000 10839513472 11267035136 1912738816 18.929 100 42 84 2 1936370688 12197136 11434736
14:15:02 8830 8192000000 10831908272 11261054976 1912162336 18.924 100 24 48 1 1923886192 5176176 6547680
14:15:18 5850 8192000000 10841152208 11257905152 1913265104 18.933 100 31 62 0 1929162160 7301136 8595920
14:15:31 5100 8192000000 10829189600 11263254528 1911723264 18.920 100 34 68 0 1927792144 6409920 9658960
14:15:42 37766 8192000000 10837653136 11260518400 1879776592 18.663 98 36 72 0 1896436928 6404880 10255456
14:16:30 5585 8192000000 10806852784 11237261312 1880036928 18.665 99 30 60 1 1895045024 5998336 9009760
14:16:43 10067 8192000000 10825311088 11251867648 1901025808 18.835 100 37 73 0 1918453904 6899472 10528624
14:16:59 6992 8192000000 10815059952 11248103424 1884274288 18.700 99 30 60 0 1898726528 6614496 7837744
14:17:13 6217 8192000000 10784861904 11219443712 1850608944 18.427 98 24 48 2 1862923440 5714944 6599552
14:17:25 6671 8192000000 10802218208 11234512896 1885905568 18.713 100 22 44 0 1898477232 6170544 6401120
14:17:38 7401 8192000000 10790772288 11222298624 1862711264 18.525 99 21 42 2 1874729760 5068144 6950352
14:17:54 3470 8192000000 10739831504 11155451904 1795209520 17.975 96 41 79 0 1811297696 4892560 11195616
14:18:03 5247 8192000000 10748843728 11170992128 1824743664 18.216 99 22 45 1 1836735360 5569072 6422624
14:18:15 6499 8192000000 10754056192 11181125632 1829657344 18.257 99 28 56 3 1844788672 6620016 8511312
14:18:31 6803 8192000000 10745755936 11170312192 1816864160 18.152 99 31 61 0 1831914224 6137488 8912576
14:18:44 10051 8192000000 10766326656 11193040896 1849308112 18.417 100 27 55 1 1864459328 7428832 7722384
14:19:00 5009 8192000000 10736677808 11158065152 1799740752 18.012 98 29 58 2 1814714928 6708000 8266176
14:19:16 61071 8192000000 10667059760 11090092032 1673949984 16.966 92 32 64 1 1688053680 5037392 9066304
14:20:26 11744 8192000000 10701778000 11112935424 1698315968 17.171 95 25 48 2 1714559456 9140736 7102752
14:20:47 6152 8192000000 10699599872 11118583808 1764887744 17.725 98 34 68 3 1781015856 6443056 9685056
14:21:02 6849 8192000000 10728696944 11121573888 1768247536 17.753 98 42 83 3 1790143536 10337472 11558528
14:21:16 4639 8192000000 10708446496 11123572736 1770041728 17.767 98 39 78 2 1791876736 11035216 10799792
14:21:28 5973 8192000000 10710179696 11131797504 1773161424 17.793 98 17 34 1 1783109376 5372400 4575552
14:21:41 10160 8192000000 10715851616 11127914496 1769196544 17.760 98 17 34 1 1779424448 5153312 5074592
14:21:57 10926 8192000000 10695075856 11114692608 1750782048 17.608 97 22 45 1 1762670432 5495648 6392736
14:22:14 11312 8192000000 10744156560 11150893056 1807674864 18.077 100 24 48 1 1825500640 10869248 6956528
14:22:32 14064 8192000000 10723205504 11142864896 1790033552 17.932 99 29 57 1 1805117360 5487424 9596384
14:22:53 6844 8192000000 10726500224 11157823488 1823210848 18.204 100 34 69 1 1838655472 5848864 9595760
14:23:06 9512 8192000000 10751999104 11167510528 1813627456 18.126 99 29 56 4 1827688528 5416976 8644096
14:23:28 7768 8192000000 10743802592 11167547392 1830187456 18.261 100 22 45 2 1841928016 5312480 6428080
14:23:44 69961 8192000000 10750980656 11176919040 1818231616 18.163 99 27 54 1 1830997280 5146080 7619584
14:25:00 8620 8192000000 10759571680 11181453312 1838440720 18.328 100 19 38 3 1849404048 5297552 5665776
14:25:15 8361 8192000000 10768766960 11190763520 1849837488 18.421 100 30 58 0 1864441568 6418304 8185776
14:25:30 7959 8192000000 10781270928 11196751872 1854485168 18.459 100 30 60 3 1869159792 6014112 8660512
14:25:46 7727 8192000000 10775226096 11203604480 1862171040 18.521 100 39 78 2 1881407840 7315600 11921200
14:26:00 8287 8192000000 10780144576 11205500928 1864974288 18.544 100 34 68 3 1882686000 8050016 9661696
14:26:14 9659 8192000000 10772311072 11203682304 1866002752 18.552 100 37 74 2 1882427712 4792864 11632096
14:26:30 5864 8192000000 10776759824 11210244096 1866929552 18.559 100 26 51 1 1880659152 5638176 8091424
14:26:43 9714 8192000000 10779722880 11213549568 1868440512 18.572 100 19 38 1 1879187568 5182688 5564368
14:26:59 5230 8192000000 10797344240 11219202048 1876735088 18.639 100 31 62 1 1891140448 5357456 9047904
14:27:15 54832 8192000000 10831951456 11250999296 1902924400 18.850 100 48 95 2 1923552976 7088848 13539728
14:28:17 13481 8192000000 10844480352 11263021056 1912992800 18.931 100 46 90 1 1936314320 10479056 12842464
14:28:38 12566 8192000000 10857463264 11274461184 1922320128 19.005 100 61 122 1 1952423088 12702928 17400032
14:28:59 34717 8192000000 10858359616 11280871424 1925443408 19.030 100 41 82 0 1949680016 12610096 11626512
14:29:44 60123 8192000000 10865225280 11302051840 1939642016 19.144 100 38 74 1 1965299152 13847968 11809168
14:31:37 39505 8192000000 10876278592 11324653568 1947504944 19.207 100 32 64 2 1973372208 16519120 9348144
14:32:27 17116 8192000000 10879463056 11319402496 1951100000 19.235 100 30 60 1 1975636432 15529072 9007360
14:32:55 10083 8192000000 10893307104 11325022208 1956482784 19.278 100 42 84 0 1983995248 15546032 11966432
14:33:13 5084 8192000000 10911430384 11337805824 1964104096 19.339 100 58 116 0 1999476160 18798928 16573136
14:33:29 4795 8192000000 10921033152 11343523840 1971889344 19.400 100 70 140 0 2010617776 19636624 19091808
14:33:43 4389 8192000000 10936197776 11347623936 1973301248 19.412 100 76 149 1 2015679856 20663616 21714992
14:33:55 5327 8192000000 10925400160 11347595264 1957150944 19.283 99 71 139 1 1998069920 21501664 19417312
14:34:07 3718 8192000000 10917213920 11337424896 1964687248 19.343 100 74 146 0 2007071520 21295376 21088896
14:34:17 4836 8192000000 10924328576 11348131840 1974130608 19.418 100 83 166 1 2019032688 21265568 23636512
14:34:29 6392 8192000000 10919424976 11343765504 1972722272 19.407 100 69 139 0 2012941088 20771568 19447248
14:34:46 9374 8192000000 10923937072 11349979136 1972854992 19.408 100 71 139 1 2014012416 21021888 20135536
14:35:04 9855 8192000000 10928650272 11357966336 1978482416 19.453 100 66 131 2 2018292016 21009296 18800304
14:35:22 4160 8192000000 10924314048 11349307392 1974124352 19.418 100 65 130 1 2015067408 21399808 19543248
14:35:34 3907 8192000000 10935986704 11359895552 1982910240 19.488 100 74 149 1 2025591632 20734352 21947040
14:35:51 6004 8192000000 10918791776 11343876096 1957061136 19.283 99 66 131 0 1996628512 20830160 18737216
14:36:21 7527 8192000000 10930627952 11364384768 1982208304 19.482 100 51 102 0 2023598064 25812480 15577280
14:36:41 4485 8192000000 10934265552 11368075264 1986180528 19.514 100 61 119 0 2029396880 25702304 17514048
14:36:54 6530 8192000000 10930757904 11361419264 1968148000 19.371 99 65 130 0 2013322384 25556320 19618064
14:37:09 5973 8192000000 10938164848 11366539264 1969474944 19.381 99 60 120 0 2014144464 26861008 17808512
14:37:23 2829 8192000000 10948505360 11367501824 1984559520 19.501 100 76 150 0 2034634288 27571632 22503136
14:37:32 3248 8192000000 10956786464 11373273088 1989129072 19.537 100 74 147 0 2039421568 27788144 22504352
14:37:44 6999 8192000000 10959078240 11379511296 1997741888 19.605 100 73 145 0 2047544528 28277312 21525328
14:37:57 1646 8192000000 10976760288 11388940288 1998864592 19.614 100 86 173 2 2056389536 31546608 25978336
14:38:06 5338 8192000000 10968560096 11389128704 1996782320 19.597 100 72 144 1 2050463392 32117344 21563728
14:38:18 4156 8192000000 10967178208 11390660608 1998498496 19.611 100 73 146 2 2052670192 31901072 22270624
14:38:34 9324 8192000000 10958279648 11391164416 1996844912 19.598 100 58 117 2 2045918656 31501744 17572000
14:39:04 2432 8192000000 10964025984 11385831424 1995045760 19.584 100 75 150 2 2049778000 31744832 22987408
14:39:15 8064 8192000000 10955121760 11387621376 1996900224 19.598 100 62 124 2 2047995296 32226688 18868384
14:39:33 10633 8192000000 10957528000 11388055552 1994841232 19.582 100 65 128 0 2048841680 33953488 20046960
14:39:55 4533 8192000000 10962524208 11387957248 1990625360 19.549 100 61 122 0 2043996368 33861008 19510000
14:40:07 1937 8192000000 10950346880 11373834240 1978987408 19.457 99 65 130 1 2033733680 34198384 20547888
14:40:18 6663 8192000000 10962462416 11390521344 1995991120 19.591 100 63 125 2 2051068144 35072784 20004240
14:40:36 4138 8192000000 10950471520 11378503680 1977362272 19.444 99 61 121 2 2031674816 35915104 18397440
14:40:47 3472 8192000000 10989148592 11405209600 1994556512 19.580 100 83 166 0 2061410400 41012432 25841456
14:40:58 5515 8192000000 10965698352 11387510784 1976372560 19.436 99 70 140 4 2035108384 36097632 22638192
14:41:12 2684 8192000000 10950218624 11379036160 1984702544 19.502 100 57 112 1 2038883392 35855872 18324976
14:41:27 7289 8192000000 10963071536 11384115200 1986117440 19.513 100 57 113 0 2040309104 35508304 18683360
14:41:44 5508 8192000000 10946480992 11381252096 1983133984 19.490 100 52 104 0 2033176752 33345936 16696832
14:41:58 9756 8192000000 10955708688 11384025088 1969684416 19.383 99 50 100 1 2021448016 36267392 15496208
14:42:16 4468 8192000000 10963786096 11390423040 1991746272 19.558 100 65 129 2 2047873104 35322336 20804496
14:42:29 2741 8192000000 10959797728 11377324032 1957931136 19.290 98 79 155 2 2016087024 34848336 23307552
14:42:39 1621 8192000000 10948403328 11366735872 1969451568 19.381 99 77 155 0 2028798592 35759168 23587856
14:42:48 3107 8192000000 10939875264 11352965120 1957000128 19.282 99 74 144 2 2014642352 35756768 21885456
14:42:58 3316 8192000000 10926894000 11343863808 1933640416 19.096 98 85 169 3 1995929296 36836416 25452464
14:43:08 3557 8192000000 10950838640 11358515200 1961698416 19.320 100 86 172 0 2026419472 38024672 26696384
14:43:19 4096 8192000000 10922991424 11335000064 1940206720 19.148 100 85 170 0 2006524624 39666128 26651776
14:43:31 2866 8192000000 10931559616 11343704064 1944880816 19.186 100 87 172 3 2015757632 44088256 26788560
14:43:43 3854 8192000000 10944533728 11358621696 1952600704 19.247 100 76 151 2 2019877104 43505504 23770896
14:43:56 4196 8192000000 10964749472 11381207040 1969714896 19.383 100 81 158 0 2042352288 47347712 25289680
14:44:07 5789 8192000000 10947426400 11378544640 1974465792 19.421 100 60 120 1 2033749152 40454848 18828512
14:44:22 4176 8192000000 10929933824 11346206720 1937586672 19.127 99 57 114 0 1997146832 41659136 17901024
14:44:36 5860 8192000000 10916385264 11342639104 1944157280 19.180 100 63 126 1 2001447648 36512032 20778336
14:44:53 6558 8192000000 10891741568 11322949632 1931599680 19.080 100 49 99 2 1983606560 36072512 15934368
14:45:13 11095 8192000000 10905730960 11321438208 1916093552 18.956 99 61 119 1 1970598448 35680432 18824464
14:45:31 1908 8192000000 10908639728 11319861248 1929256192 19.061 100 80 161 0 1990712624 36184032 25272400
14:45:42 2529 8192000000 10909343712 11322687488 1928077376 19.052 100 72 144 0 1989399040 38118544 23203120
14:45:51 6345 8192000000 10908941376 11331067904 1935811056 19.113 100 61 122 1 1993585472 39150336 18624080
14:46:05 1361 8192000000 10919849280 11332562944 1931951936 19.082 99 76 151 1 1998753968 44206512 22595520
14:46:22 6145 8192000000 10914312032 11344633856 1932246256 19.085 99 57 114 0 1991380512 40755504 18378752
14:46:37 8882 8192000000 10912902112 11351810048 1951105936 19.235 100 39 78 1 2001722016 36740336 13875744
14:46:53 15517 8192000000 10922203872 11357380608 1945045328 19.187 99 40 79 1 1992883936 35147712 12690896
14:47:24 13061 8192000000 10910149728 11349233664 1944296592 19.181 99 35 70 1 1988616832 32842448 11477792
14:47:52 13641 8192000000 10920652000 11357810688 1959613120 19.303 100 35 70 3 2006084432 34853536 11617776
14:48:14 4443 8192000000 10944566272 11379298304 1971520544 19.398 100 42 81 0 2021490864 36224112 13746208
14:48:33 14497 8192000000 10919414576 11358359552 1958624080 19.295 100 33 66 2 2005524000 35440368 11459552
14:48:58 4396 8192000000 10949214480 11375271936 1975260160 19.427 100 48 95 1 2028984912 37951376 15773376
14:49:09 2218 8192000000 10980691616 11394629632 1987445328 19.524 100 76 152 3 2052229360 38811424 25972608
14:49:20 20100 8192000000 10959782560 11401752576 1980501440 19.469 100 40 80 2 2041024128 46704016 13818672
14:49:47 5260 8192000000 10949532288 11395018752 1981900992 19.480 100 41 82 3 2036135824 40372544 13862288
14:49:59 6902 8192000000 10947612256 11390017536 1966339504 19.356 99 39 78 0 2020904640 41156640 13408496
14:50:18 27781 8192000000 10905115440 11354742784 1927520048 19.047 98 36 72 2 1984125744 44473072 12132624
14:51:24 15318 8192000000 10921980208 11358822400 1950769760 19.233 100 22 44 6 1994436384 35916736 7749888
14:51:51 20745 8192000000 10906807296 11352313856 1918866688 18.978 98 33 66 1 1969131488 39537792 10727008
14:52:39 19105 8192000000 10915011696 11371438080 1955986096 19.274 100 21 42 3 1999824704 36738432 7100176
14:53:10 25855 8192000000 10912622976 11365945344 1949684992 19.224 100 20 40 0 1998386880 41025952 7675936
14:53:43 8459 8192000000 10920559776 11367362560 1948645760 19.216 100 27 54 0 2003664304 44384496 10634048
14:53:58 11343 8192000000 10924824928 11372896256 1934688592 19.104 99 32 64 1 1994913664 48310640 11914432
14:54:47 32268 8192000000 10899576672 11363741696 1944432352 19.182 100 16 32 0 1970824640 20722304 5669984
14:55:34 103382 8192000000 10906386304 11356184576 1934286976 19.101 99 6 10 0 1959880752 24061376 1532400
14:57:25 26165 8192000000 10907551408 11354939392 1955296688 19.269 99 40 82 2 1976360144 9489104 11574352
14:58:02 121535 8192000000 10908403744 11368931328 1934657104 19.104 98 14 28 1 1951012352 13071968 3283280
15:00:10 69612 8192000000 10899996240 11362467840 1939087616 19.139 98 17 32 2 1951335888 7992208 4256064
15:01:36 128176 8192000000 10918195424 11387793408 1893782128 18.776 95 10 20 0 1907370064 10936032 2651904
15:04:06 102742 8192000000 10888361568 11345326080 1902129264 18.843 96 28 56 4 1921777344 12231008 7417072
15:05:55 43557 8192000000 10882903536 11347738624 1946911600 19.202 99 18 36 1 1960672176 8709408 5051168
15:07:06 59248 8192000000 10907080000 11364597760 1957587424 19.287 99 38 76 1 1975040896 7313680 10139792
15:08:25 36835 8192000000 10954439056 11393183744 1982204304 19.482 99 45 90 1 2006688752 11115952 13368496
15:09:10 13254 8192000000 10955736848 11402625024 2003915536 19.654 100 53 106 1 2030550496 10698304 15936656
15:09:44 86289 8192000000 10938853488 11395510272 1970648464 19.391 98 45 86 6 2000592832 17350816 12593552
15:11:39 25283 8192000000 10950405456 11418431488 2010132288 19.703 100 24 48 1 2035610016 17634752 7842976
15:12:13 52391 8192000000 10937737360 11407769600 1972420224 19.405 98 19 38 0 1996065824 17686064 5959536
15:13:19 27313 8192000000 10971004640 11423195136 2014522848 19.737 100 43 87 3 2044279424 16324096 13432480
15:13:53 12733 8192000000 10985894688 11431239680 2023746480 19.810 100 66 127 2 2061715088 19686416 18282192
15:14:12 17348 8192000000 10985690016 11429490688 2011464096 19.713 99 69 138 0 2053692464 21555024 20673344
15:14:38 48415 8192000000 10939790432 11425452032 1991227136 19.553 99 39 78 2 2033577744 30600048 11750560
15:15:33 28399 8192000000 10939030976 11434291200 2000548784 19.627 100 10 21 1 2023863680 20525936 2788960
15:16:07 14779 8192000000 10924907168 11408781312 1982248640 19.482 99 7 14 0 2003853552 19873456 1731456
15:16:32 4113 8192000000 10944749136 11406360576 2003761760 19.652 100 24 48 1 2028494496 17448128 7284608
15:16:43 25625 8192000000 10926484160 11398938624 1984246976 19.498 99 12 24 0 1998231360 10526944 3457440
15:17:14 74180 8192000000 10928055248 11403010048 1983095808 19.489 99 15 30 0 2007481376 20248176 4137392
15:19:00 59761 8192000000 10911266112 11376267264 1935494240 19.111 97 9 19 0 1949556144 11402352 2659552
15:20:06 54963 8192000000 10903455488 11398246400 1924834960 19.026 97 7 14 0 1940664976 14230672 1599344
15:21:07 66135 8192000000 10896265312 11374141440 1911533888 18.919 96 23 46 0 1930258368 11586144 7138336
15:22:36 78040 8192000000 10910676288 11386478592 1944935936 19.186 98 14 28 1 1966569968 17424608 4209424
15:24:18 66014 8192000000 10898688560 11363667968 1872099056 18.601 95 19 38 0 1902114352 24501440 5513856
15:25:34 40528 8192000000 10868773120 11330797568 1870218032 18.586 96 22 42 0 1886322480 10649488 5454960
15:26:26 56395 8192000000 10887923376 11346145280 1917705456 18.968 98 24 47 0 1933560064 8385008 7469600
15:27:35 80404 8192000000 10896358144 11364716544 1926807584 19.041 98 18 36 1 1940931872 9482624 4641664
15:29:08 74816 8192000000 10890997200 11358748672 1878018368 18.649 95 28 56 0 1900617952 15050448 7549136
15:31:33 85763 8192000000 10871684976 11352752128 1866166176 18.553 95 25 50 2 1885461280 12046976 7248128
15:33:05 96998 8192000000 10874031856 11349204992 1855232432 18.465 95 28 57 1 1878240992 14936880 8071680
15:34:55 62934 8192000000 10860575488 11322986496 1867385808 18.563 96 22 44 0 1885743168 12482912 5874448
15:36:43 79053 8192000000 10854910624 11327770624 1861013200 18.511 96 18 36 1 1880290256 14052768 5224288
15:38:14 61674 8192000000 10860066048 11312869376 1882808464 18.688 97 33 66 1 1902901984 10415536 9677984
15:39:24 3214 8192000000 10896750768 11338625024 1948067968 19.211 100 59 117 0 1977040832 11867712 17105152
15:39:35 30392 8192000000 10896954176 11349426176 1948743808 19.216 100 41 82 0 1973048096 12932576 11371712
15:40:13 6364 8192000000 10898204896 11350433792 1955424400 19.270 100 54 106 1 1984978256 13975072 15578784
15:40:39 52853 8192000000 10871968864 11347505152 1943456688 19.174 100 9 18 1 1959360000 12831856 3071456
15:41:38 53885 8192000000 10857876784 11332317184 1901499328 18.838 98 16 33 1 1916986832 11352336 4135168
15:42:39 41872 8192000000 10842938288 11291406336 1867093664 18.561 96 30 60 3 1886448880 10276672 9078544
15:43:27 73291 8192000000 10850009904 11316711424 1879887920 18.664 97 11 22 0 1893084000 9888656 3307424
15:44:47 59216 8192000000 10849482672 11316576256 1906401648 18.878 99 12 24 0 1919911808 9658304 3851856
15:45:56 93571 8192000000 10863483232 11351949312 1942380608 19.166 100 16 32 0 1959553696 12356896 4816192
15:47:42 52285 8192000000 10866461984 11365310464 1944552496 19.183 100 4 8 0 1958780416 13096720 1131200
15:48:41 38019 8192000000 10854622000 11333394432 1904706768 18.864 98 8 16 0 1918203680 11333008 2163904
15:49:26 43421 8192000000 10877683520 11350126592 1946697376 19.200 100 12 24 0 1956875392 7180304 2997712
15:50:15 34469 8192000000 10890350832 11360600064 1961343168 19.317 100 22 45 0 1978486528 10784208 6359152
15:50:56 48240 8192000000 10883418992 11343839232 1928759392 19.057 98 33 66 2 1950439728 12228848 9451488
15:51:56 37163 8192000000 10881409168 11344076800 1920012016 18.987 98 27 54 2 1936997232 9411376 7573840
15:52:39 44030 8192000000 10889411472 11356315648 1937883552 19.130 99 26 52 2 1958609504 13368976 7356976
15:53:30 46991 8192000000 10900272656 11367776256 1966043296 19.354 100 34 68 1 1989724096 14224512 9456288
15:54:24 48861 8192000000 10908148736 11374895104 1951211776 19.236 99 20 40 2 1970649152 13778656 5658720
15:55:19 55582 8192000000 10903650576 11381665792 1959725904 19.304 99 27 54 0 1984843904 17287872 7830128
15:56:21 57231 8192000000 10902157120 11385286656 1966547872 19.358 100 11 22 1 1987580112 18034224 2998016
15:57:24 117579 8192000000 10914251744 11374546944 1921648176 19.000 97 12 24 0 1937224432 12444560 3131696
15:59:29 103999 8192000000 10913350016 11361300480 1887308640 18.724 95 14 28 0 1902937232 11862928 3765664
16:01:20 51478 8192000000 10897187888 11369091072 1930472880 19.071 98 23 46 1 1946722416 9916176 6333360
16:02:28 82004 8192000000 10903221904 11367661568 1934878384 19.106 98 22 44 2 1953594672 12576896 6139392
16:03:57 134107 8192000000 10871698880 11340726272 1868701712 18.574 95 23 46 0 1888883456 13161120 7020624
16:06:18 34559 8192000000 10886175840 11346259968 1953595808 19.255 100 24 46 1 1968478256 8004272 6878176
16:07:01 44165 8192000000 10887392512 11348959232 1935534640 19.111 99 27 54 1 1953711728 10488832 7688256
16:08:01 77282 8192000000 10882638432 11367518208 1955249312 19.268 100 7 14 0 1968239824 11041904 1948608
16:09:25 35790 8192000000 10878902624 11367546880 1959086080 19.299 100 8 16 0 1977000080 15464544 2449456
16:10:14 32995 8192000000 10871530432 11343650816 1939207504 19.140 99 23 46 1 1953959232 8477776 6273952
16:11:14 59329 8192000000 10855116464 11326730240 1894778656 18.784 97 15 30 0 1910097632 11008672 4310304
16:12:25 43729 8192000000 10856217328 11325550592 1902627680 18.847 98 16 32 1 1920464576 12995824 4841072
16:14:12 82782 8192000000 10841987728 11325804544 1917824432 18.969 99 6 12 0 1927259600 7981728 1453440
16:16:03 31722 8192000000 10875459744 11333685248 1918910464 18.978 99 27 54 1 1933289312 6413472 7965376
16:16:42 26979 8192000000 10878892080 11342757888 1948176288 19.212 100 35 69 1 1966871968 9438128 9257552
16:17:20 34873 8192000000 10872382528 11338620928 1924618352 19.024 99 19 38 0 1937980688 7613264 5749072
16:18:05 26634 8192000000 10852909200 11330359296 1903475184 18.854 98 24 45 0 1923236112 12850560 6910368
16:19:09 33915 8192000000 10856074688 11333124096 1896090112 18.795 98 17 34 0 1911945328 11151504 4703712
16:19:49 32053 8192000000 10861212336 11320045568 1881168752 18.675 97 19 38 0 1898088240 11520912 5398576
16:20:33 79881 8192000000 10880903488 11327782912 1835856320 18.307 95 25 50 1 1857768608 14007056 7905232
16:22:20 55389 8192000000 10832883728 11297181696 1871673856 18.598 97 28 56 1 1894593536 15015792 7903888
16:23:28 113672 8192000000 10856461536 11316408320 1891257472 18.756 98 12 24 1 1912575792 18147888 3170432
16:25:30 44757 8192000000 10859873024 11322748928 1873534912 18.613 97 30 60 1 1892152912 9262576 9355424
16:26:28 14004 8192000000 10870884576 11324456960 1916923408 18.962 99 31 60 4 1932677536 7434400 8319728
16:26:48 29686 8192000000 9139416704 9375637504 299913824 3.531 16 3 6 0 303801024 3119344 767856

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 10-11-2020 16:28:00 to 10-11-2020 16:28:32.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 10-11-2020 16:28:33 to 10-11-2020 16:28:35.

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          249809
MON$OLDEST_ACTIVE               249810
MON$OLDEST_SNAPSHOT             249810
MON$NEXT_TRANSACTION            249810
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                       2044704
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.7.33388 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33388 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33388 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33388 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 ---
:202: 
:203: mscs-test-161.budzdorov.ru    Tue Nov 10 16:27:22 2020
:204:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:205: 
:206: 
:207: mscs-test-161.budzdorov.ru    Tue Nov 10 16:27:22 2020
:208:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:209: 
--- end of diff output ---

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

10.11.20 16:28:36. 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-10 16:28:38 No severe PSQL-related problems occured
10.11.20 16:28:39. End of report.