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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-11 16:27:14
DTS_END                         2021-01-11 16:27:14.5110
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/35564
TRN_ID                          242079
ATT_ID                          654
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: 9467.58 20226 1136109
customer order: creation 173.51 374 20821
customer order: refuse 15.07 367 1808
order to supplier: creation 46.76 1266 5611
order to supplier: removal 3.31 110107 397
invoice (draft): creation 46.98 3234 5638
invoice (draft): removal 53.92 858 6470
invoice accept: apply 42.83 17499 5139
invoice accept: cancel 48.56 714 5827
customer reserve: creation 3930.81 174 471697
customer reserve: removal 4804.09 58 576491
realization accept: apply 83.94 187 10073
realization accept: cancel 85.22 105 10226
payment from customer: creation 61.07 119 7328
payment from customer: removal 5.76 61 691
payment to supplier: creation 50.33 137 6040
payment to supplier: removal 3.43 79 411
service: total inventory turnovers 4.37 1138 524
service: total monetary turnovers 6.67 32 800
service: aggregate perf. data 0.94 17690 113
service: refresh index statistics 0.03 250311 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 11-01-2021 16:28:41 to 11-01-2021 16:28:43.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3639
TEST_TIME 2 3400
TEST_TIME 3 4230
TEST_TIME 4 4651
TEST_TIME 5 4368
TEST_TIME 6 4433
TEST_TIME 7 4547
TEST_TIME 8 4672
TEST_TIME 9 5560
TEST_TIME 10 5732
TEST_TIME 11 5999
TEST_TIME 12 6066
TEST_TIME 13 5967
TEST_TIME 14 6263
TEST_TIME 15 6474
TEST_TIME 16 6767
TEST_TIME 17 7078
TEST_TIME 18 7352
TEST_TIME 19 7719
TEST_TIME 20 7578
TEST_TIME 21 8227
TEST_TIME 22 8099
TEST_TIME 23 8269
TEST_TIME 24 8381
TEST_TIME 25 8926
TEST_TIME 26 9661
TEST_TIME 27 10182
TEST_TIME 28 10816
TEST_TIME 29 10925
TEST_TIME 30 10649
TEST_TIME 31 10647
TEST_TIME 32 10697
TEST_TIME 33 10727
TEST_TIME 34 10654
TEST_TIME 35 10753
TEST_TIME 36 10675
TEST_TIME 37 10419
TEST_TIME 38 10341
TEST_TIME 39 10414
TEST_TIME 40 10244
TEST_TIME 41 10184
TEST_TIME 42 10147
TEST_TIME 43 9983
TEST_TIME 44 9940
TEST_TIME 45 10114
TEST_TIME 46 10235
TEST_TIME 47 10129
TEST_TIME 48 10061
TEST_TIME 49 9952
TEST_TIME 50 9911
TEST_TIME 51 10166
TEST_TIME 52 10099
TEST_TIME 53 10035
TEST_TIME 54 10074
TEST_TIME 55 10099
TEST_TIME 56 10109
TEST_TIME 57 10128
TEST_TIME 58 10048
TEST_TIME 59 10206
TEST_TIME 60 10218
TEST_TIME 61 10262
TEST_TIME 62 10289
TEST_TIME 63 10413
TEST_TIME 64 10264
TEST_TIME 65 10190
TEST_TIME 66 10143
TEST_TIME 67 10084
TEST_TIME 68 10079
TEST_TIME 69 10042
TEST_TIME 70 10020
TEST_TIME 71 9983
TEST_TIME 72 9965
TEST_TIME 73 9901
TEST_TIME 74 9846
TEST_TIME 75 9772
TEST_TIME 76 9754
TEST_TIME 77 9759
TEST_TIME 78 9705
TEST_TIME 79 9709
TEST_TIME 80 9708
TEST_TIME 81 9726
TEST_TIME 82 9726
TEST_TIME 83 9714
TEST_TIME 84 9755
TEST_TIME 85 9758
TEST_TIME 86 9776
TEST_TIME 87 9799
TEST_TIME 88 9823
TEST_TIME 89 9837
TEST_TIME 90 9910
TEST_TIME 91 9841
TEST_TIME 92 9806
TEST_TIME 93 9782
TEST_TIME 94 9776
TEST_TIME 95 9720
TEST_TIME 96 9738
TEST_TIME 97 9702
TEST_TIME 98 9676
TEST_TIME 99 9743
TEST_TIME 100 9746
TEST_TIME 101 9714
TEST_TIME 102 9754
TEST_TIME 103 9786
TEST_TIME 104 9800
TEST_TIME 105 9761
TEST_TIME 106 9804
TEST_TIME 107 9827
TEST_TIME 108 9817
TEST_TIME 109 9788
TEST_TIME 110 9713
TEST_TIME 111 9696
TEST_TIME 112 9669
TEST_TIME 113 9654
TEST_TIME 114 9624
TEST_TIME 115 9576
TEST_TIME 116 9574
TEST_TIME 117 9561
TEST_TIME 118 9551
TEST_TIME 119 9534
TEST_TIME 120 9468

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 11-01-2021 16:28:44 to 11-01-2021 16:28:48.

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 1572197 1572197 0 0.00 0 21437 6 0 0
doc_list_biud 1572197 1572197 0 0.00 0 67692 27 0 0
sp_add_invoice_to_stock 5282 5139 143 2.70 25 169451 17499 0 143
sp_cancel_adding_invoice 5827 5827 0 0.00 6 61143 714 0 0
sp_cancel_client_order 1808 1808 0 0.00 4 19500 367 0 0
sp_cancel_customer_reserve 576491 576491 0 0.00 1 60438 59 0 0
sp_cancel_pay_from_customer 691 691 0 0.00 3 3812 61 0 0
sp_cancel_pay_to_supplier 411 411 0 0.00 3 3983 80 0 0
sp_cancel_supplier_invoice 6484 6470 14 0.21 2 67702 858 0 14
sp_cancel_supplier_order 397 397 0 0.00 8 1380480 110107 0 0
sp_cancel_write_off 10226 10226 0 0.00 1 13022 105 0 0
sp_client_order 20821 20821 0 0.00 3 53038 374 0 0
sp_customer_reserve 471697 471697 0 0.00 0 120646 175 0 0
sp_fill_shopping_cart 32061 32061 0 0.00 1 9001 35 0 0
sp_fill_shopping_cart_clo_res 471697 471697 0 0.00 0 11331 12 0 0
sp_get_clo_for_invoice 5139 5139 0 0.00 0 19977 286 0 0
sp_kill_cost_storno 17155 17155 0 0.00 0 8970 57 0 0
sp_kill_qstorno_ret_qs2qd 1170075 1170075 0 0.00 0 67685 32 0 0
sp_kill_qty_storno 616431 616431 0 0.00 0 67689 69 0 0
sp_lock_selected_doc 20919 20919 0 0.00 0 9745 6 0 0
sp_make_cost_storno 28580 28580 0 0.00 0 19252 50 0 0
sp_multiply_rows_for_pdistr 28580 28580 0 0.00 0 7242 28 0 0
sp_multiply_rows_for_qdistr 20821 20821 0 0.00 0 52931 169 0 0
sp_pay_from_customer 7328 7328 0 0.00 4 18306 120 0 0
sp_pay_to_supplier 6040 6040 0 0.00 5 13182 137 0 0
sp_payment_common 13368 13368 0 0.00 1 18247 27 0 0
sp_qd_handle_on_cancel_clo 1808 1808 0 0.00 0 19472 316 0 0
sp_qd_handle_on_invoice_upd_sts 10966 10966 0 0.00 0 12896 318 0 0
sp_qd_handle_on_reserve_upd_sts 10073 10073 0 0.00 0 12945 63 0 0
sp_reserve_write_off 10073 10073 0 0.00 6 12964 188 0 0
sp_supplier_invoice 5638 5638 0 0.00 5 82830 3234 0 0
sp_supplier_order 5611 5611 0 0.00 5 38071 1267 0 0
srv_aggregate_perf_data 113 113 0 0.00 2985 196508 17690 0 0
srv_fill_mon_cache_memory 159 159 0 0.00 1492 145078 31548 0 0
srv_find_qd_qs_mism 1087083 1087083 0 0.00 0 21437 5 0 0
srv_make_invnt_saldo 524 524 0 0.00 18 62759 1138 0 0
srv_make_money_saldo 800 800 0 0.00 1 5659 33 0 0
srv_recalc_idx_stat 4 4 0 0.00 159368 403963 250312 0 0
t$perf-abend:sp_add_invoice_to_stock 143 143 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 14 14 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5139 5139 0 0.00 0 22255 185 0 0
t$perf-norm:sp_cancel_adding_invoice 356 356 0 0.00 0 13892 125 0 0
t$perf-norm:sp_cancel_client_order 1808 1808 0 0.00 0 2410 15 0 0
t$perf-norm:sp_cancel_customer_reserve 659 659 0 0.00 0 1522 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 691 691 0 0.00 0 2705 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 411 411 0 0.00 0 3133 11 0 0
t$perf-norm:sp_cancel_supplier_invoice 385 385 0 0.00 0 987 9 0 0
t$perf-norm:sp_cancel_supplier_order 397 397 0 0.00 0 19267 1670 0 0
t$perf-norm:sp_cancel_write_off 1000 1000 0 0.00 0 5899 11 0 0
t$perf-norm:sp_client_order 20821 20821 0 0.00 0 14925 19 0 0
t$perf-norm:sp_customer_reserve 1014 1014 0 0.00 0 1734 8 0 0
t$perf-norm:sp_pay_from_customer 7328 7328 0 0.00 0 9020 13 0 0
t$perf-norm:sp_pay_to_supplier 6040 6040 0 0.00 0 7062 14 0 0
t$perf-norm:sp_reserve_write_off 10073 10073 0 0.00 0 6973 13 0 0
t$perf-norm:sp_supplier_invoice 5638 5638 0 0.00 0 13860 22 0 0
t$perf-norm:sp_supplier_order 5611 5611 0 0.00 0 4613 16 0 0
t$perf-norm:srv_aggregate_perf_data 113 113 0 0.00 0 3723 40 0 0
t$perf-norm:srv_fill_mon_cache_memory 159 159 0 0.00 0 997 11 0 0
t$perf-norm:srv_make_invnt_saldo 524 524 0 0.00 0 3382 31 0 0
t$perf-norm:srv_make_money_saldo 800 800 0 0.00 0 1523 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 10564 10278 286 2.70 0 10204 23 0 286
v_all_customers 38276 38276 0 0.00 0 11 1 0 0
v_all_suppliers 30954 30954 0 0.00 0 47 1 0 0
v_all_wares 41642 41642 0 0.00 0 14 1 0 0
v_cancel_adding_invoice 712 712 0 0.00 0 6944 15 0 0
v_cancel_client_order 3616 3616 0 0.00 0 8615 11 0 0
v_cancel_customer_prepayment 1382 1382 0 0.00 0 1387 4 0 0
v_cancel_customer_reserve 1318 1318 0 0.00 0 6533 13 0 0
v_cancel_payment_to_supplier 822 822 0 0.00 0 3493 8 0 0
v_cancel_supplier_invoice 798 770 28 3.50 0 8284 42 0 28
v_cancel_supplier_order 794 794 0 0.00 0 3029 9 0 0
v_cancel_write_off 2000 2000 0 0.00 0 5869 16 0 0
v_max_id_clo_ord 5611 5611 0 0.00 0 1523 2 0 0
v_max_id_clo_res 1014 1014 0 0.00 0 2296 17 0 0
v_max_id_ord_sup 5627 5627 0 0.00 0 2776 3 0 0
v_max_non_paid_invoice 1800 1800 0 0.00 0 5628 7 0 0
v_max_non_paid_realizn 3679 3679 0 0.00 0 5485 4 0 0
v_min_id_clo_ord 5611 5611 0 0.00 0 4084 8 0 0
v_min_id_clo_res 1014 1014 0 0.00 0 3143 10 0 0
v_min_id_ord_sup 5627 5627 0 0.00 0 5528 11 0 0
v_min_non_paid_invoice 6040 6040 0 0.00 0 7801 16 0 0
v_min_non_paid_realizn 7328 7328 0 0.00 0 18236 22 0 0
v_our_firm 10664 10664 0 0.00 0 22 1 0 0
v_reserve_write_off 20146 20146 0 0.00 0 10887 10 0 0
x_lock_depdocs_on_canc_invoice 11912 11912 0 0.00 0 12707 107 0 0
x_lock_depdocs_on_canc_sup_ord 397 397 0 0.00 0 20103 372 0 0
x_make_qstorno_1000_1200 5611 5611 0 0.00 2 38051 1194 0 0
x_make_qstorno_1200_2000 5638 5638 0 0.00 3 82799 3110 0 0
x_make_qstorno_2100_3300 471697 471697 0 0.00 0 120642 160 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 11-01-2021 16:28:49 to 11-01-2021 16:28:53.

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:18 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:24 22417 8192000000 10294071936 10606305280 1132845840 12.148 87 66 134 0 1157044128 3111232 21087056
13:57:55 28374 8192000000 10366488240 10686361600 1411980304 14.702 100 86 173 0 1444279664 5078528 27220832
13:58:32 29221 8192000000 10400209232 10723979264 1449038400 15.029 100 89 178 0 1484401280 7105424 28257456
13:59:21 24913 8192000000 10433522176 10764070912 1483724896 15.334 100 93 186 0 1521274560 8114976 29434688
14:00:00 12663 8192000000 10446988096 10778116096 1496945312 15.450 100 91 180 1 1534464768 8663408 28856048
14:00:24 23347 8192000000 10457875072 10793291776 1509824720 15.562 100 92 184 3 1548067232 9247344 28995168
14:01:03 23967 8192000000 10472367264 10813276160 1528574000 15.725 100 87 174 0 1565755664 10255952 26925712
14:01:37 17488 8192000000 10508717408 10855075840 1559462928 15.992 100 82 164 0 1594692224 10391600 24837696
14:02:09 8352 8192000000 10539759680 10891468800 1596340304 16.308 100 86 172 0 1633175664 11077824 25757536
14:02:26 14873 8192000000 10550969904 10906218496 1609109008 16.417 100 71 143 0 1640751488 11051504 20590976
14:02:48 13440 8192000000 10564362800 10921771008 1620375024 16.513 100 77 154 1 1654603760 11520368 22708368
14:03:11 9141 8192000000 10580036864 10943053824 1643992368 16.714 100 83 166 0 1680521184 12527184 24001632
14:03:28 9315 8192000000 10592821584 10956410880 1651743456 16.779 100 75 150 2 1686057328 12515408 21798464
14:03:45 6961 8192000000 10625236496 10991894528 1683269056 17.045 100 81 162 0 1719303664 12867520 23167088
14:04:01 7072 8192000000 10637024304 11008241664 1701221856 17.195 100 82 164 2 1738117296 13317872 23577568
14:04:16 10958 8192000000 10660017664 11030708224 1714044192 17.303 100 85 170 0 1752218864 14048048 24126624
14:04:35 9975 8192000000 10667349856 11048738816 1731814960 17.451 100 72 145 0 1764479216 12310176 20354080
14:04:52 4608 8192000000 10682620528 11062009856 1742689808 17.541 100 74 148 1 1776438592 12389104 21359680
14:05:04 7805 8192000000 10697559264 11078230016 1758069040 17.668 100 71 142 1 1790200912 12021808 20110064
14:05:19 5897 8192000000 10707674320 11089592320 1768702400 17.756 100 76 152 1 1803369456 12966512 21700544
14:05:33 2840 8192000000 10721162672 11098832896 1784946240 17.890 100 84 166 1 1822136160 13363184 23826736
14:05:43 8421 8192000000 10726000560 11111997440 1784655040 17.888 100 80 161 2 1820673264 12210928 23807296
14:05:59 5720 8192000000 10726389168 11118804992 1791764144 17.946 100 69 139 0 1823603168 12205472 19633552
14:06:13 3024 8192000000 10750528512 11134840832 1812793008 18.119 100 83 166 1 1852937632 16603792 23540832
14:06:23 2838 8192000000 10746900416 11139391488 1819802752 18.176 100 77 154 0 1854121456 12502288 21816416
14:06:33 3471 8192000000 10767323744 11154542592 1828400384 18.246 100 83 166 1 1864741536 13012416 23328736
14:06:44 2241 8192000000 10770633360 11159924736 1835507088 18.304 100 85 168 0 1872145584 13024368 23614128
14:06:52 3436 8192000000 10781535664 11168256000 1842190400 18.359 100 90 182 3 1881042480 13138928 25713152
14:07:04 3038 8192000000 10791360208 11175997440 1848936752 18.413 100 93 184 3 1888808768 14002864 25869152
14:07:14 2376 8192000000 10794185840 11179991040 1847197376 18.399 100 87 175 1 1885342048 14319856 23824816
14:07:23 2687 8192000000 10794683936 11185799168 1851728496 18.436 100 91 182 1 1890677904 13252240 25697168
14:07:32 1878 8192000000 10800797904 11191541760 1853827696 18.453 100 86 170 3 1890270000 12795248 23647056
14:07:41 2021 8192000000 10807047136 11195801600 1862197584 18.521 100 92 184 1 1901078672 12846704 26034384
14:07:49 2701 8192000000 10804494992 11193614336 1861821296 18.518 100 83 165 1 1898112672 12666624 23624752
14:07:59 2099 8192000000 10799928592 11198685184 1867749872 18.566 100 86 169 1 1903256208 11520240 23986096
14:08:07 2034 8192000000 10813238336 11206615040 1873463312 18.612 100 82 164 2 1908944896 12494064 22987520
14:08:16 4049 8192000000 10814366480 11209777152 1873337072 18.611 100 76 153 1 1907665600 12760176 21568352
14:08:26 2972 8192000000 10824584224 11217096704 1879280320 18.659 100 84 166 1 1915990960 13705360 23005280
14:08:35 1395 8192000000 10824097232 11214753792 1879990896 18.665 100 93 187 3 1919941440 12954480 26996064
14:08:43 4281 8192000000 10825988896 11222577152 1882589936 18.686 100 74 149 2 1919994640 17034752 20369952
14:08:54 1682 8192000000 10829630096 11226091520 1887781664 18.728 100 87 173 0 1925988144 13346096 24860384
14:09:08 4065 8192000000 10802501888 11216973824 1884048656 18.698 100 49 98 1 1907639504 10367376 13223472
14:09:19 3525 8192000000 10798195536 11220684800 1888214864 18.731 100 51 102 3 1911859040 9512992 14131184
14:09:29 2229 8192000000 10813526752 11227287552 1891916496 18.761 100 56 112 0 1917304352 9631712 15756144
14:09:38 1400 8192000000 10813507520 11228299264 1896144624 18.795 100 59 118 1 1922750736 10253200 16352912
14:09:47 2290 8192000000 10811604912 11228545024 1894930032 18.785 100 52 104 2 1918402304 8903088 14569184
14:09:58 2207 8192000000 10814336880 11232423936 1896392960 18.797 100 63 126 2 1924388624 9692400 18303264
14:10:06 6766 8192000000 10800639424 11228405760 1892125648 18.763 100 30 58 2 1908635264 8696112 7813504
14:10:21 5611 8192000000 10804979984 11236016128 1892885280 18.769 100 27 53 4 1907522000 6907648 7729072
14:10:32 3837 8192000000 10806713552 11235139584 1896596176 18.799 100 31 61 0 1910955680 5942128 8417376
14:10:47 7129 8192000000 10819813408 11240263680 1900048208 18.827 100 38 77 0 1919653008 8898048 10706752
14:11:03 8588 8192000000 10805172176 11242299392 1900088256 18.827 100 16 32 0 1914975808 10332208 4555344
14:11:18 8155 8192000000 10812245184 11245072384 1900890912 18.833 100 19 38 1 1912202720 5879360 5432448
14:11:36 13072 8192000000 10814062768 11243634688 1907178416 18.884 100 46 92 1 1927361984 5572032 14611536
14:11:58 72442 8192000000 10827591776 11259596800 1909006368 18.899 100 31 62 0 1923660208 5836576 8817264
14:13:17 7506 8192000000 10815092656 11258830848 1907845424 18.889 100 16 33 2 1918289376 6286064 4157888
14:13:34 6361 8192000000 10829549776 11262849024 1912847280 18.929 100 33 66 0 1929254016 6740432 9666304
14:13:46 5770 8192000000 10830005616 11266482176 1912759680 18.929 100 33 64 2 1928757280 6326000 9671600
14:14:00 4316 8192000000 10836594192 11269599232 1911763456 18.921 100 26 52 2 1926122352 7421280 6937616
14:14:10 7681 8192000000 10828627840 11264831488 1910498336 18.911 100 21 42 2 1922004352 5549008 5957008
14:14:27 12698 8192000000 10826766896 11265748992 1911209600 18.916 100 17 32 1 1921520288 5653184 4657504
14:14:47 9661 8192000000 10830637488 11268333568 1916280896 18.957 100 30 60 1 1931401088 6317056 8803136
14:15:03 10597 8192000000 10819452816 11258396672 1894270128 18.780 99 17 34 3 1904455296 5592000 4593168
14:15:24 11007 8192000000 10822533728 11263799296 1912640640 18.928 100 19 38 1 1924961392 6493056 5827696
14:15:41 8111 8192000000 10811499072 11252498432 1894802128 18.784 99 25 50 0 1907518624 5908944 6807552
14:15:56 9878 8192000000 10809093616 11249225728 1889103376 18.739 99 22 43 4 1899769232 5104064 5561792
14:16:12 10326 8192000000 10803441040 11235061760 1878579632 18.654 99 18 36 1 1889322784 5631408 5111744
14:16:31 64316 8192000000 10833300496 11250462720 1884723168 18.703 99 42 83 1 1902398464 5745040 11930256
14:17:42 10997 8192000000 10793769584 11231838208 1843624912 18.370 97 15 30 2 1853554208 5232752 4696544
14:17:59 6283 8192000000 10810234976 11249926144 1893662144 18.775 100 29 58 1 1912295456 10888240 7745072
14:18:12 9190 8192000000 10763250032 11188436992 1758878272 17.675 93 25 50 1 1771334736 5750912 6705552
14:18:29 3592 8192000000 10756026016 11183771648 1840448544 18.344 100 25 49 4 1853707456 6708512 6550400
14:18:44 4272 8192000000 10756595104 11181056000 1839109232 18.334 100 27 54 2 1857385600 10424864 7851504
14:18:55 4267 8192000000 10718466048 11138371584 1776266048 17.819 97 30 59 0 1791038368 6963392 7808928
14:19:06 5958 8192000000 10702336896 11114733568 1769723200 17.765 98 27 54 1 1783217584 5517520 7976864
14:19:18 7506 8192000000 10727569328 11141312512 1783129504 17.875 98 25 48 0 1796366128 6438784 6797840
14:19:33 8999 8192000000 10742079648 11160727552 1804357872 18.050 99 28 54 1 1818114800 5780208 7976720
14:19:51 4447 8192000000 10711844992 11122376704 1716595264 17.324 95 38 76 1 1737991456 10254656 11141536
14:20:02 12340 8192000000 10712908080 11124146176 1756683904 17.657 98 21 42 2 1772605328 9938320 5983104
14:20:22 10726 8192000000 10730790400 11147173888 1796943456 17.989 99 33 66 2 1812601664 5707360 9950848
14:20:39 11519 8192000000 10731262832 11144933376 1743468544 17.547 96 25 50 6 1760702304 9112752 8121008
14:20:57 10474 8192000000 10695386416 11116163072 1741081600 17.528 97 17 34 2 1750419408 4635568 4702240
14:21:14 14053 8192000000 10715810432 11120222208 1767213648 17.744 98 41 81 4 1786864704 5579552 14071504
14:21:35 74275 8192000000 10710783200 11129643008 1722208928 17.371 95 36 72 2 1738579520 5346432 11024160
14:22:58 11172 8192000000 10744503760 11149484032 1802842016 18.037 100 30 60 2 1816538816 5570832 8125968
14:23:16 5180 8192000000 10743132512 11155808256 1799788848 18.012 99 42 84 1 1824327600 12759296 11779456
14:23:27 3609 8192000000 10730055984 11142856704 1809032736 18.088 100 25 50 2 1823284416 6962464 7289216
14:23:38 7263 8192000000 10739392608 11164094464 1823570736 18.207 100 26 52 0 1841596240 10486544 7538960
14:23:55 3962 8192000000 10749203952 11170824192 1833968992 18.292 100 33 66 2 1849572512 6254016 9349504
14:24:06 11187 8192000000 10751642368 11180122112 1838412416 18.328 100 19 37 1 1849725760 5792496 5520848
14:24:24 10204 8192000000 10774043152 11201892352 1854831312 18.461 100 27 54 1 1868512144 5728464 7952368
14:24:47 8224 8192000000 10778042848 11205652480 1862837616 18.526 100 23 46 2 1875446064 5608784 6999664
14:25:01 8901 8192000000 10789220512 11208466432 1865508384 18.548 100 18 36 0 1875980000 4998160 5473456
14:25:17 11640 8192000000 10782437552 11212931072 1869779632 18.582 100 26 52 0 1883578416 5680656 8118128
14:25:38 14538 8192000000 10796070640 11222630400 1875638432 18.630 100 21 43 1 1887365824 5964832 5762560
14:26:01 17195 8192000000 10792574576 11227447296 1881195440 18.675 100 24 47 3 1894600624 5863280 7541904
14:26:27 21130 8192000000 10799480800 11230507008 1882086160 18.682 100 14 26 1 1890469856 4770928 3612768
14:26:55 10268 8192000000 10819124208 11238043648 1892916608 18.769 100 33 64 1 1908091920 5900384 9274928
14:27:55 30252 8192000000 10843044320 11263770624 1913616192 18.936 100 35 68 4 1928197872 5489936 9091744
14:28:33 20985 8192000000 10859380496 11276578816 1925718480 19.033 100 48 95 0 1946081728 7166128 13197120
14:29:00 18726 8192000000 10870273152 11289243648 1934332416 19.102 100 56 112 0 1959641712 10101344 15207952
14:29:29 9796 8192000000 10883022576 11300278272 1942705776 19.168 100 58 114 1 1969162096 10319040 16137280
14:29:47 31287 8192000000 10888484576 11311476736 1949164768 19.220 100 64 128 0 1979230624 12526320 17539536
14:30:33 4862 8192000000 10900252848 11324014592 1961895136 19.321 100 67 134 2 1995602448 14219072 19488240
14:30:51 23823 8192000000 10905619888 11332796416 1967462416 19.365 100 60 120 0 1998333216 13683664 17187136
14:31:25 14671 8192000000 10915242640 11336028160 1963417360 19.333 100 47 94 2 1993040144 15646240 13976544
14:31:56 12483 8192000000 10915028640 11341066240 1973236544 19.411 100 44 89 1 2000994928 14198352 13560032
14:32:18 5021 8192000000 10911230272 11343745024 1978543632 19.453 100 50 101 1 2008923424 15822928 14556864
14:32:30 15923 8192000000 10923212736 11350740992 1983610064 19.493 100 63 122 0 2018506240 16915792 17980384
14:33:12 19089 8192000000 10923199376 11356233728 1985213872 19.506 100 44 86 0 2015684208 17316848 13153488
14:33:44 22208 8192000000 10925866976 11360661504 1989659248 19.541 100 42 84 2 2019801728 18034080 12108400
14:34:17 10316 8192000000 10930408192 11367710720 1995433168 19.587 100 45 90 1 2026698208 17575440 13689600
14:34:40 5320 8192000000 10948902464 11373199360 1999772496 19.621 100 55 110 1 2034924912 19099088 16053328
14:34:53 5013 8192000000 10943492448 11376201728 2002991600 19.646 100 50 100 2 2036807488 19005632 14810256
14:35:07 13998 8192000000 10944208720 11376754688 1999046096 19.615 100 46 86 1 2030449136 18241264 13161776
14:35:29 7511 8192000000 10941255792 11372793856 1979896720 19.464 99 41 80 1 2012267360 19528048 12842592
14:35:44 5176 8192000000 10960026304 11380056064 2000873984 19.630 100 69 136 2 2042114960 21626432 19614544
14:36:04 6613 8192000000 10956745728 11380097024 1986733120 19.518 99 59 118 1 2027078960 22091744 18254096
14:36:18 1914 8192000000 10960371440 11377786880 2000233136 19.625 100 80 158 1 2044860576 20471136 24156304
14:36:29 2950 8192000000 10965439136 11384643584 2005492784 19.666 100 77 153 1 2050896864 22440256 22963824
14:36:40 2878 8192000000 10972148192 11390849024 2011808832 19.716 100 81 161 0 2058398000 22785648 23803520
14:36:49 4646 8192000000 10961593616 11384983552 2006429024 19.673 100 73 145 0 2051727008 23420528 21877456
14:37:04 17023 8192000000 10949018704 11380998144 1983425184 19.492 99 61 120 2 2024681824 23436176 17820464
14:37:30 21306 8192000000 10957261744 11394768896 2003683840 19.652 100 47 94 2 2044546352 26576160 14286352
14:38:05 17979 8192000000 10946634528 11394736128 2004413776 19.658 100 40 78 2 2043528928 26139856 12975296
14:38:42 8916 8192000000 10949894464 11390410752 1996524112 19.595 100 41 81 3 2038025680 28294656 13206912
14:38:57 10829 8192000000 10963854896 11407507456 2010558976 19.706 100 47 94 2 2053574048 28571552 14443520
14:39:16 6917 8192000000 10958343072 11393445888 1999389648 19.618 99 51 102 0 2045267600 30102880 15775072
14:39:34 13440 8192000000 10956458016 11393208320 2001620096 19.636 100 49 97 0 2044169008 27997872 14551040
14:39:56 2874 8192000000 10946823840 11376795648 1987553840 19.524 99 64 128 2 2036251856 28629008 20069008
14:40:09 7713 8192000000 10969599424 11400605696 2007157808 19.679 100 66 132 0 2057745280 30296784 20290688
14:40:25 7733 8192000000 10957723216 11383435264 1947285632 19.205 97 61 120 1 1997288112 31331456 18671024
14:40:43 3387 8192000000 10968738672 11390152704 1999138864 19.616 100 79 159 0 2057371392 33650752 24581776
14:40:55 6960 8192000000 10955318928 11383918592 1963438288 19.333 98 62 124 0 2016587120 33935216 19213616
14:41:12 2212 8192000000 10973307536 11387203584 1982554800 19.485 99 77 152 2 2042256384 34115840 25585744
14:41:21 4676 8192000000 10966782560 11390369792 1996755792 19.597 100 74 147 1 2054930480 34953792 23220896
14:41:33 2920 8192000000 10973169552 11387035648 1990983936 19.552 100 82 163 3 2052882032 36469824 25428272
14:41:42 3967 8192000000 10963678320 11383320576 1960552784 19.310 98 77 149 0 2021465264 37333760 23578720
14:41:52 4669 8192000000 10969019456 11390308352 1994702800 19.581 100 73 145 1 2055549888 38381296 22465792
14:42:05 1775 8192000000 10971472240 11387023360 1991627984 19.557 100 79 159 2 2052273216 36283296 24361936
14:42:16 11287 8192000000 10958012624 11386023936 1987011872 19.520 100 61 122 2 2042864864 36232112 19620880
14:42:37 6290 8192000000 10963969952 11389046784 1989776400 19.542 100 68 136 4 2050387584 38466240 22144944
14:42:51 4055 8192000000 10970751664 11392540672 1993405328 19.571 100 74 148 3 2055569520 38452944 23711248
14:43:03 3069 8192000000 10971225008 11381297152 1981017328 19.473 99 81 161 0 2045469344 39306176 25145840
14:43:15 3201 8192000000 10961777232 11380559872 1982879504 19.487 99 81 161 1 2047524976 37625248 27020224
14:43:26 2271 8192000000 10978813664 11394621440 1990186224 19.545 100 84 168 2 2056946000 40533808 26225968
14:43:41 2699 8192000000 10970489552 11383943168 1966049888 19.354 99 77 153 0 2032159504 41739472 24370144
14:43:54 2143 8192000000 10965976256 11390976000 1987624224 19.525 100 71 139 0 2051909488 42383664 21901600
14:44:03 1746 8192000000 10959467760 11373465600 1955420464 19.270 99 88 177 1 2021895632 39695808 26779360
14:44:12 3951 8192000000 10954632576 11372355584 1971741440 19.399 100 72 144 0 2033771840 40212672 21817728
14:44:23 1671 8192000000 10975820048 11385847808 1982880032 19.487 100 86 168 1 2048897904 40846160 25171712
14:44:32 2759 8192000000 10927058496 11335778304 1940205216 19.148 98 82 163 0 2006823808 41835280 24783312
14:44:42 3882 8192000000 10953334832 11366363136 1964101296 19.339 100 83 166 1 2033248144 43840912 25305936
14:44:57 2282 8192000000 10950165424 11359846400 1944846784 19.185 99 87 172 1 2016474464 44559312 27068368
14:45:06 3663 8192000000 10934314864 11344134144 1946057760 19.195 99 73 146 1 2013567552 44249216 23260576
14:45:20 2009 8192000000 10960169280 11365945344 1962964928 19.330 100 88 176 1 2035865776 44675136 28225712
14:45:29 5544 8192000000 10958087616 11368402944 1970543888 19.390 100 80 153 2 2035432016 41151072 23737056
14:45:43 3465 8192000000 10957787488 11370565632 1971244144 19.395 100 81 162 0 2036910592 41013312 24653136
14:45:55 3138 8192000000 10948372512 11367849984 1968890048 19.377 100 70 140 0 2031002048 40040832 22071168
14:46:05 1491 8192000000 10943299792 11357462528 1934891488 19.106 98 72 138 2 1998426032 40545856 22988688
14:46:13 4833 8192000000 10933824928 11344359424 1934865696 19.106 99 64 127 3 1995604336 41266624 19472016
14:46:25 5292 8192000000 10893106688 11335536640 1929600864 19.064 99 45 90 1 1988347968 44015168 14731936
14:46:47 16382 8192000000 10912035424 11346329600 1944435232 19.182 100 40 80 3 1997334544 39182016 13717296
14:47:14 3816 8192000000 10924472096 11348451328 1946990976 19.203 100 61 119 1 2004154560 38479808 18683776
14:47:31 4305 8192000000 10961613216 11374919680 1965035264 19.346 100 75 150 2 2033441536 44858736 23547536
14:47:43 3012 8192000000 10959193280 11379265536 1969995760 19.385 100 81 162 0 2039850272 43675264 26179248
14:47:59 4986 8192000000 10960546288 11373944832 1959858592 19.305 100 73 147 0 2036109280 52775424 23475264
14:48:14 4269 8192000000 10953738640 11381223424 1965357456 19.349 100 69 139 0 2037862416 49469744 23035216
14:48:31 16916 8192000000 10898130976 11332198400 1922043424 19.003 98 33 66 1 1969692080 36743280 10905376
14:49:03 6414 8192000000 10931258832 11364036608 1960329968 19.309 100 57 114 1 2015625440 37899760 17395712
14:49:19 4099 8192000000 10918114688 11356733440 1939581344 19.143 99 47 94 1 1993845392 39052912 15211136
14:49:31 17142 8192000000 10932875920 11364990976 1956343456 19.277 100 32 64 1 2007966816 40448224 11175136
14:49:57 10364 8192000000 10954272896 11383345152 1968906496 19.377 100 46 89 2 2029848160 45760592 15181072
14:50:16 11119 8192000000 10945510496 11387572224 1971136160 19.394 100 47 92 1 2034917568 47181328 16600080
14:50:49 10013 8192000000 10957199776 11401306112 1977239936 19.443 100 39 78 0 2038736736 48130160 13366640
14:51:11 11088 8192000000 10951361472 11397005312 1956875312 19.281 99 27 54 1 2017903024 51065232 9962480
14:51:43 18948 8192000000 10953740352 11399282688 1953473504 19.254 99 40 81 1 2026584240 58359744 14750992
14:52:21 21197 8192000000 10916745680 11372343296 1917686976 18.968 98 29 59 0 1986778608 58160240 10931392
14:53:10 21541 8192000000 10908536896 11357351936 1920268656 18.989 99 25 50 0 1988574976 58402944 9903376
14:53:44 20498 8192000000 10893542464 11350310912 1935416192 19.110 100 21 42 1 1991882000 48807056 7658752
14:54:18 35273 8192000000 10880689472 11342516224 1911066608 18.915 99 18 36 0 1952850624 35117056 6666960
14:55:04 35399 8192000000 10863843248 11348140032 1901319888 18.837 99 9 18 1 1932760912 28625232 2815792
14:55:45 70191 8192000000 10845774640 11303006208 1890872016 18.753 98 3 6 0 1907537408 15939440 725952
14:57:03 42864 8192000000 10906054768 11340488704 1934146720 19.100 99 34 67 2 1953309616 9917488 9245408
14:57:57 38598 8192000000 10897685024 11348819968 1948119936 19.212 99 44 85 0 1972847072 12132960 12594176
14:58:50 95410 8192000000 10895803888 11347501056 1884955008 18.705 96 9 17 1 1896069184 8989520 2124656
15:01:48 55861 8192000000 10898220880 11359830016 1943192656 19.172 99 18 36 1 1967204480 18741344 5270480
15:02:54 114886 8192000000 10903129536 11358355456 1945878976 19.194 99 22 44 3 1962948240 10655456 6413808
15:05:03 70710 8192000000 10923238176 11370704896 1968779152 19.376 100 35 67 3 1987609248 9630176 9199920
15:06:22 15773 8192000000 10914751840 11376848896 1974740960 19.423 100 55 110 0 2007182656 16543312 15898384
15:06:44 32466 8192000000 10902797680 11373002752 1978378736 19.452 100 20 40 0 1991154560 7327632 5448192
15:07:27 20952 8192000000 10896612224 11364814848 1959207488 19.300 99 10 20 1 1969254112 7050240 2996384
15:07:55 25036 8192000000 10891427728 11346956288 1934452272 19.102 98 21 43 0 1946758912 6191200 6115440
15:08:27 2538 8192000000 10898114352 11348484096 1953543072 19.255 99 39 77 0 1974299264 9453040 11303152
15:08:37 10172 8192000000 10938835504 11376672768 1978904000 19.456 100 47 94 1 2005579488 13902288 12773200
15:08:54 13698 8192000000 10923799376 11385720832 1984911776 19.504 100 34 68 0 2009581632 15044672 9625184
15:09:18 47256 8192000000 10937998256 11390377984 1959902368 19.305 99 18 36 1 1978663008 13602848 5157792
15:10:33 49486 8192000000 10939631936 11396046848 1981468624 19.476 99 50 96 2 2014122848 17732800 14921424
15:11:34 46814 8192000000 10940913920 11408412672 1992559104 19.564 100 39 77 1 2026905488 22939280 11407104
15:12:50 30335 8192000000 10931232336 11410710528 1964381264 19.341 99 27 53 3 1992824080 20165680 8277136
15:13:39 137233 8192000000 10909105472 11390050304 1947645216 19.208 98 14 29 1 1965238720 13830480 3763024
15:17:34 44114 8192000000 10905884960 11390582784 1940088288 19.147 98 7 14 0 1962359536 20177040 2094208
15:18:26 54303 8192000000 10912663920 11377356800 1931789360 19.081 98 15 31 1 1946990896 11096752 4104784
15:19:28 21971 8192000000 10913634000 11373498368 1948851904 19.217 99 25 50 1 1961942080 6718592 6371584
15:20:04 33096 8192000000 10918992672 11386306560 1980221232 19.466 100 30 60 1 1997637248 8794864 8621152
15:20:43 19434 8192000000 10929620432 11389165568 1988131824 19.529 100 50 100 2 2011960336 9476752 14351760
15:21:10 67212 8192000000 10888699504 11374325760 1928694400 19.056 97 36 73 0 1953530144 14387808 10447936
15:22:23 74436 8192000000 10904461104 11385253888 1922227264 19.005 97 14 28 1 1938658272 12635296 3795712
15:23:44 107759 8192000000 10926052688 11388149760 1909268384 18.901 96 10 20 2 1925226000 12667792 3289824
15:25:41 81515 8192000000 10892009504 11370872832 1889997504 18.746 96 13 26 0 1914038656 19743504 4297648
15:27:09 64756 8192000000 10894942624 11360305152 1890012000 18.746 96 19 36 1 1907613712 13210256 4391456
15:28:21 59991 8192000000 10912476784 11389231104 1905737392 18.872 97 17 34 1 1928498304 17382752 5378160
15:30:15 69806 8192000000 10892804592 11382513664 1904686688 18.864 97 8 16 0 1934130624 26560688 2883248
15:32:12 52138 8192000000 10882205840 11348176896 1911534320 18.919 97 23 46 1 1927154400 9242224 6377856
15:33:11 56398 8192000000 10909800992 11368599552 1941939648 19.162 99 33 65 1 1959992912 9037568 9015696
15:34:16 31776 8192000000 10909555152 11371184128 1962142128 19.323 100 33 66 0 1982696656 11648960 8905568
15:34:58 12198 8192000000 10874865440 11331997696 1921420480 18.998 98 38 76 0 1944681424 12241104 11019840
15:36:08 75967 8192000000 10828986464 11310481408 1813178272 18.122 93 12 24 0 1826098560 9655280 3265008
15:37:31 53298 8192000000 10876112240 11334582272 1918419440 18.974 99 22 44 0 1937019152 12410240 6189472
15:38:31 63939 8192000000 10859442752 11340742656 1922367856 19.006 99 8 17 0 1933881968 8849888 2664224
15:39:41 50575 8192000000 10870997552 11341770752 1921277376 18.997 99 22 44 0 1934403760 6555104 6571280
15:41:05 78954 8192000000 10879059168 11356438528 1937566160 19.127 99 8 16 1 1949656432 9785808 2304464
15:43:04 82717 8192000000 10870848160 11359043584 1920978432 18.995 98 14 28 0 1939018704 14405216 3635056
15:44:33 33315 8192000000 10863197744 11349757952 1942538224 19.167 100 5 11 1 1956646800 12791408 1317168
15:45:19 45288 8192000000 10906316160 11365797888 1943591568 19.175 99 19 38 2 1955686080 6958416 5136096
15:46:13 54627 8192000000 10881945408 11360919552 1910057056 18.907 97 22 44 1 1926448416 10310336 6081024
15:47:13 48620 8192000000 10874859696 11356020736 1922554176 19.007 98 25 50 1 1938714560 9154736 7005648
15:48:10 48891 8192000000 10867590880 11344723968 1900036896 18.827 97 22 44 1 1916276160 9957600 6281664
15:49:13 39109 8192000000 10889582048 11342876672 1897242944 18.804 97 33 66 2 1915409840 8760352 9406544
15:50:07 44491 8192000000 10864159152 11333865472 1919371056 18.982 99 20 40 0 1935633024 10882176 5379792
15:50:58 68077 8192000000 10895736656 11358498816 1928330192 19.054 99 27 54 2 1947540112 11705232 7504688
15:52:56 81171 8192000000 10873500640 11346612224 1859240768 18.497 95 12 24 1 1880302992 17787824 3274400
15:54:23 63732 8192000000 10890645712 11349299200 1898733712 18.816 97 34 66 1 1923732640 15457408 9541520
15:55:33 56289 8192000000 10891145328 11366993920 1938169152 19.132 99 15 30 1 1958166832 15356864 4640816
15:57:22 36284 8192000000 10914574800 11379822592 1960525200 19.310 99 21 42 0 1976168224 9931920 5711104
15:58:11 145077 8192000000 10916955936 11384963072 1958969904 19.298 99 21 40 1 1975424720 10661536 5793280
16:00:44 31994 8192000000 10915945296 11395125248 1983806592 19.495 100 22 44 0 2006388784 16823936 5758256
16:01:35 34423 8192000000 10911056368 11376750592 1954695168 19.264 99 15 30 0 1967907696 9180304 4032224
16:02:22 64888 8192000000 10893800576 11372888064 1963325296 19.332 99 16 32 1 1979794944 11925568 4544080
16:03:43 55754 8192000000 10911975904 11391217664 1957297456 19.285 99 15 30 1 1973070624 11088368 4684800
16:04:52 45176 8192000000 10913939760 11381358592 1948158912 19.212 98 20 40 1 1962357888 8419952 5779024
16:06:10 96412 8192000000 10898527344 11368824832 1929509968 19.063 98 14 28 1 1947115040 13931264 3673808
16:07:52 59132 8192000000 10881824400 11349123072 1916641408 18.960 97 18 36 0 1935489040 13420576 5427056
16:08:58 59372 8192000000 10873560672 11349807104 1883689760 18.695 96 12 24 1 1898531488 11512112 3329616
16:10:14 100689 8192000000 10889197664 11368505344 1957937920 19.290 100 7 14 0 1974631840 14757472 1936448
16:12:16 33792 8192000000 10919860608 11379650560 1979547216 19.461 100 36 72 1 2001228832 10697040 10984576
16:13:13 63764 8192000000 10881011808 11367804928 1924016000 19.019 98 22 44 2 1941151840 11298096 5837744
16:14:29 86127 8192000000 10876518096 11341799424 1894087744 18.779 97 10 19 1 1905729376 8771728 2869904
16:16:01 21151 8192000000 10902815776 11352870912 1955211808 19.268 100 41 83 0 1974642368 7067424 12363136
16:16:30 85620 8192000000 10894465456 11358748672 1958145424 19.291 100 43 87 2 1980942720 10430448 12366848
16:18:30 85022 8192000000 10856579760 11326341120 1859085056 18.496 95 18 36 0 1872152048 7893552 5173440
16:20:05 48963 8192000000 10870849712 11354902528 1948415728 19.214 100 13 26 0 1961213664 8376528 4421408
16:21:36 51328 8192000000 10858313184 11322920960 1883575776 18.694 97 14 28 3 1896641120 8918160 4147184
16:22:36 73969 8192000000 10817913328 11295703040 1807958352 18.079 94 15 30 0 1823359248 10861936 4538960
16:24:05 62447 8192000000 10816036976 11297193984 1865200384 18.545 98 16 32 0 1882843248 12583328 5059536
16:25:23 74727 8192000000 10808674272 11287289856 1823887232 18.209 96 20 40 1 1849642736 20103744 5651760
16:26:44 41353 8192000000 9237902784 9498742784 400755088 4.663 21 4 8 0 409912016 8087392 1069536

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 11-01-2021 16:28:55 to 11-01-2021 16:29:26.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 143 v_add_invoice_to_stock 335544517
except 14 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 11-01-2021 16:29:27 to 11-01-2021 16:29:29.

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          243026
MON$OLDEST_ACTIVE               243027
MON$OLDEST_SNAPSHOT             243027
MON$NEXT_TRANSACTION            243027
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                       2048032
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics

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

Database validation

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

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

--- start of diff output ---
:686: 
:687: mscs-test-161.budzdorov.ru    Mon Jan 11 16:27:34 2021
:688:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:689: 
--- end of diff output ---

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

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