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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-09 16:27:08
DTS_END                         2020-12-09 16:27:08.1410
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/53526
TRN_ID                          253045
ATT_ID                          729
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: 9992.57 21317 1199108
customer order: creation 179.58 350 21549
customer order: refuse 14.93 261 1792
order to supplier: creation 48.51 1186 5821
order to supplier: removal 3.50 80301 420
invoice (draft): creation 47.28 2892 5673
invoice (draft): removal 59.33 599 7119
invoice accept: apply 43.36 17842 5203
invoice accept: cancel 53.80 615 6456
customer reserve: creation 4041.34 176 484961
customer reserve: removal 5187.02 41 622442
realization accept: apply 85.93 182 10312
realization accept: cancel 95.35 91 11442
payment from customer: creation 61.03 131 7324
payment from customer: removal 6.00 64 720
payment to supplier: creation 49.92 156 5990
payment to supplier: removal 3.87 94 464
service: total inventory turnovers 4.81 1007 577
service: total monetary turnovers 6.27 28 752
service: aggregate perf. data 0.73 24232 87
service: refresh index statistics 0.03 296092 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 09-12-2020 16:27:55 to 09-12-2020 16:27:58.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6710
TEST_TIME 2 5239
TEST_TIME 3 7654
TEST_TIME 4 7293
TEST_TIME 5 7688
TEST_TIME 6 7222
TEST_TIME 7 7159
TEST_TIME 8 7351
TEST_TIME 9 7670
TEST_TIME 10 7744
TEST_TIME 11 7785
TEST_TIME 12 7913
TEST_TIME 13 8559
TEST_TIME 14 8979
TEST_TIME 15 9596
TEST_TIME 16 10059
TEST_TIME 17 9772
TEST_TIME 18 10219
TEST_TIME 19 10366
TEST_TIME 20 11214
TEST_TIME 21 11547
TEST_TIME 22 11578
TEST_TIME 23 12318
TEST_TIME 24 12204
TEST_TIME 25 12054
TEST_TIME 26 12019
TEST_TIME 27 12129
TEST_TIME 28 11750
TEST_TIME 29 11442
TEST_TIME 30 11476
TEST_TIME 31 11261
TEST_TIME 32 11333
TEST_TIME 33 11151
TEST_TIME 34 10991
TEST_TIME 35 10860
TEST_TIME 36 10655
TEST_TIME 37 10493
TEST_TIME 38 10506
TEST_TIME 39 10551
TEST_TIME 40 10551
TEST_TIME 41 10467
TEST_TIME 42 10493
TEST_TIME 43 10391
TEST_TIME 44 10503
TEST_TIME 45 10468
TEST_TIME 46 10451
TEST_TIME 47 10621
TEST_TIME 48 10749
TEST_TIME 49 10688
TEST_TIME 50 10718
TEST_TIME 51 10750
TEST_TIME 52 10862
TEST_TIME 53 10750
TEST_TIME 54 10624
TEST_TIME 55 10488
TEST_TIME 56 10484
TEST_TIME 57 10565
TEST_TIME 58 10482
TEST_TIME 59 10495
TEST_TIME 60 10396
TEST_TIME 61 10304
TEST_TIME 62 10347
TEST_TIME 63 10331
TEST_TIME 64 10371
TEST_TIME 65 10341
TEST_TIME 66 10425
TEST_TIME 67 10413
TEST_TIME 68 10357
TEST_TIME 69 10418
TEST_TIME 70 10435
TEST_TIME 71 10635
TEST_TIME 72 10649
TEST_TIME 73 10570
TEST_TIME 74 10601
TEST_TIME 75 10616
TEST_TIME 76 10514
TEST_TIME 77 10447
TEST_TIME 78 10360
TEST_TIME 79 10359
TEST_TIME 80 10358
TEST_TIME 81 10286
TEST_TIME 82 10319
TEST_TIME 83 10269
TEST_TIME 84 10199
TEST_TIME 85 10140
TEST_TIME 86 10103
TEST_TIME 87 10158
TEST_TIME 88 10124
TEST_TIME 89 10135
TEST_TIME 90 10118
TEST_TIME 91 10185
TEST_TIME 92 10187
TEST_TIME 93 10176
TEST_TIME 94 10216
TEST_TIME 95 10194
TEST_TIME 96 10218
TEST_TIME 97 10279
TEST_TIME 98 10263
TEST_TIME 99 10302
TEST_TIME 100 10315
TEST_TIME 101 10241
TEST_TIME 102 10158
TEST_TIME 103 10176
TEST_TIME 104 10153
TEST_TIME 105 10087
TEST_TIME 106 10084
TEST_TIME 107 10028
TEST_TIME 108 10076
TEST_TIME 109 10050
TEST_TIME 110 10005
TEST_TIME 111 9943
TEST_TIME 112 9969
TEST_TIME 113 10008
TEST_TIME 114 9970
TEST_TIME 115 10013
TEST_TIME 116 10022
TEST_TIME 117 10031
TEST_TIME 118 10016
TEST_TIME 119 10018
TEST_TIME 120 9998

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 09-12-2020 16:27:59 to 09-12-2020 16:28:02.

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 1649343 1649343 0 0.00 0 28699 6 0 0
doc_list_biud 1649343 1649343 0 0.00 0 26209 21 0 0
sp_add_invoice_to_stock 5312 5203 109 2.05 23 161436 17843 0 109
sp_cancel_adding_invoice 6456 6456 0 0.00 5 44561 615 0 0
sp_cancel_client_order 1792 1792 0 0.00 4 8937 261 0 0
sp_cancel_customer_reserve 622442 622442 0 0.00 1 26214 42 0 0
sp_cancel_pay_from_customer 720 720 0 0.00 3 6603 64 0 0
sp_cancel_pay_to_supplier 464 464 0 0.00 3 9822 94 0 0
sp_cancel_supplier_invoice 7129 7119 10 0.14 2 13683 600 0 10
sp_cancel_supplier_order 420 420 0 0.00 8 884122 80302 0 0
sp_cancel_write_off 11442 11442 0 0.00 1 23164 91 0 0
sp_client_order 21549 21549 0 0.00 3 21829 350 0 0
sp_customer_reserve 484961 484961 0 0.00 0 70255 177 0 0
sp_fill_shopping_cart 33036 33036 0 0.00 1 14144 36 0 0
sp_fill_shopping_cart_clo_res 484959 484959 0 0.00 0 15249 13 0 0
sp_get_clo_for_invoice 5196 5196 0 0.00 0 23764 259 0 0
sp_kill_cost_storno 19082 19082 0 0.00 0 12320 42 0 0
sp_kill_qstorno_ret_qs2qd 1263865 1263865 0 0.00 0 26206 23 0 0
sp_kill_qty_storno 665179 665179 0 0.00 0 26208 50 0 0
sp_lock_selected_doc 21553 21553 0 0.00 0 9317 8 0 0
sp_make_cost_storno 28822 28822 0 0.00 0 26911 64 0 0
sp_multiply_rows_for_pdistr 28822 28822 0 0.00 0 18903 31 0 0
sp_multiply_rows_for_qdistr 21549 21549 0 0.00 0 13014 139 0 0
sp_pay_from_customer 7324 7324 0 0.00 4 32156 132 0 0
sp_pay_to_supplier 5990 5990 0 0.00 4 12199 157 0 0
sp_payment_common 13314 13314 0 0.00 1 17168 44 0 0
sp_qd_handle_on_cancel_clo 1792 1792 0 0.00 0 8927 234 0 0
sp_qd_handle_on_invoice_upd_sts 11652 11652 0 0.00 0 14942 278 0 0
sp_qd_handle_on_reserve_upd_sts 10312 10312 0 0.00 0 8929 55 0 0
sp_reserve_write_off 10312 10312 0 0.00 6 26950 183 0 0
sp_supplier_invoice 5673 5673 0 0.00 7 75196 2893 0 0
sp_supplier_order 5821 5821 0 0.00 6 27326 1186 0 0
srv_aggregate_perf_data 87 87 0 0.00 3213 307202 24233 0 0
srv_fill_mon_cache_memory 153 153 0 0.00 1519 138350 35714 0 0
srv_find_qd_qs_mism 1150016 1150016 0 0.00 0 28699 5 0 0
srv_make_invnt_saldo 577 577 0 0.00 36 38345 1007 0 0
srv_make_money_saldo 752 752 0 0.00 0 6437 29 0 0
srv_recalc_idx_stat 4 4 0 0.00 228273 407574 296093 0 0
t$perf-abend:sp_add_invoice_to_stock 109 109 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5204 5204 0 0.00 0 13652 161 0 0
t$perf-norm:sp_cancel_adding_invoice 419 419 0 0.00 1 1843 69 0 0
t$perf-norm:sp_cancel_client_order 1792 1792 0 0.00 0 7258 19 0 0
t$perf-norm:sp_cancel_customer_reserve 776 776 0 0.00 0 6403 15 0 0
t$perf-norm:sp_cancel_pay_from_customer 720 720 0 0.00 0 3976 12 0 0
t$perf-norm:sp_cancel_pay_to_supplier 464 464 0 0.00 0 469 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 421 421 0 0.00 0 936 10 0 0
t$perf-norm:sp_cancel_supplier_order 420 420 0 0.00 0 18245 1404 0 0
t$perf-norm:sp_cancel_write_off 1033 1033 0 0.00 0 8106 11 0 0
t$perf-norm:sp_client_order 21549 21549 0 0.00 0 16104 16 0 0
t$perf-norm:sp_customer_reserve 1141 1141 0 0.00 0 16108 22 0 0
t$perf-norm:sp_pay_from_customer 7324 7324 0 0.00 0 4415 12 0 0
t$perf-norm:sp_pay_to_supplier 5990 5990 0 0.00 0 2224 6 0 0
t$perf-norm:sp_reserve_write_off 10312 10312 0 0.00 0 10698 13 0 0
t$perf-norm:sp_supplier_invoice 5673 5673 0 0.00 0 6902 16 0 0
t$perf-norm:sp_supplier_order 5821 5821 0 0.00 0 7458 12 0 0
t$perf-norm:srv_aggregate_perf_data 87 87 0 0.00 0 157 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 153 153 0 0.00 0 8666 66 0 0
t$perf-norm:srv_make_invnt_saldo 577 577 0 0.00 0 1017 14 0 0
t$perf-norm:srv_make_money_saldo 752 752 0 0.00 0 3518 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 69 19 0 0
v_add_invoice_to_stock 10610 10392 218 2.05 0 7214 17 0 218
v_all_customers 38900 38900 0 0.00 0 74 1 0 0
v_all_suppliers 31304 31304 0 0.00 0 18 1 0 0
v_all_wares 43098 43098 0 0.00 0 20 1 0 0
v_cancel_adding_invoice 838 838 0 0.00 0 3930 12 0 0
v_cancel_client_order 3584 3584 0 0.00 0 1815 4 0 0
v_cancel_customer_prepayment 1440 1440 0 0.00 0 814 3 0 0
v_cancel_customer_reserve 1552 1552 0 0.00 0 715 4 0 0
v_cancel_payment_to_supplier 928 928 0 0.00 0 5194 12 0 0
v_cancel_supplier_invoice 862 842 20 2.32 0 3957 25 0 20
v_cancel_supplier_order 840 840 0 0.00 0 2257 7 0 0
v_cancel_write_off 2066 2066 0 0.00 0 6968 21 0 0
v_max_id_clo_ord 5821 5821 0 0.00 0 1038 1 0 0
v_max_id_clo_res 1141 1141 0 0.00 0 1077 11 0 0
v_max_id_ord_sup 5666 5666 0 0.00 0 6619 6 0 0
v_max_non_paid_invoice 1825 1825 0 0.00 0 3636 7 0 0
v_max_non_paid_realizn 3973 3973 0 0.00 0 3323 4 0 0
v_min_id_clo_ord 5821 5821 0 0.00 0 4937 8 0 0
v_min_id_clo_res 1141 1141 0 0.00 0 5902 16 0 0
v_min_id_ord_sup 5666 5666 0 0.00 0 6242 6 0 0
v_min_non_paid_invoice 5990 5990 0 0.00 0 9887 29 0 0
v_min_non_paid_realizn 7324 7324 0 0.00 0 17157 33 0 0
v_our_firm 10900 10900 0 0.00 0 19 1 0 0
v_reserve_write_off 20624 20624 0 0.00 0 7429 5 0 0
x_lock_depdocs_on_canc_invoice 13154 13154 0 0.00 0 10280 95 0 0
x_lock_depdocs_on_canc_sup_ord 420 420 0 0.00 0 20727 373 0 0
x_make_qstorno_1000_1200 5821 5821 0 0.00 2 27319 1109 0 0
x_make_qstorno_1200_2000 5673 5673 0 0.00 2 75182 2772 0 0
x_make_qstorno_2100_3300 484961 484961 0 0.00 0 70252 162 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 09-12-2020 16:28:03 to 09-12-2020 16:28:07.

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:11 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:18 4353 8192000000 9958885456 10221330432 853577040 9.436 70 55 117 0 875251696 2478336 19196320
13:57:31 28222 8192000000 10337968416 10653147136 1360825312 14.245 100 87 174 0 1393787776 4294832 28667632
13:58:08 24957 8192000000 10372491360 10694754304 1416816352 14.744 100 89 178 3 1452723136 6546640 29360144
13:58:41 19893 8192000000 10393932800 10721697792 1452266736 15.058 100 86 172 0 1487801248 7265600 28268912
13:59:10 5881 8192000000 10404375904 10732883968 1465167664 15.171 100 87 174 0 1501368416 7819600 28381152
13:59:26 15869 8192000000 10425128336 10754887680 1479855520 15.300 100 89 178 0 1517012320 8047600 29109200
13:59:54 20382 8192000000 10441953232 10773082112 1491310384 15.400 100 88 176 0 1528234784 8802416 28121984
14:00:25 21400 8192000000 10459234848 10794741760 1512212224 15.583 100 85 170 2 1548816432 9318304 27285904
14:00:58 14809 8192000000 10488175840 10828210176 1536320080 15.792 100 83 166 0 1572408704 9944864 26143760
14:01:27 16503 8192000000 10503904624 10854051840 1562612512 16.019 100 78 156 1 1597045536 10133104 24299920
14:01:53 11984 8192000000 10541987008 10894651392 1597657552 16.319 100 80 158 3 1631758464 10128272 23972640
14:02:12 10324 8192000000 10547258576 10903977984 1614240640 16.461 100 83 166 1 1650327936 11122176 24965120
14:02:31 11138 8192000000 10571175152 10928787456 1632055120 16.612 100 81 162 0 1667439296 11272912 24111264
14:02:50 9234 8192000000 10582182256 10946596864 1644445424 16.717 100 74 148 2 1678354848 11723840 22185584
14:03:08 8408 8192000000 10618863792 10986086400 1674670880 16.973 100 82 161 2 1710466880 11935648 23860352
14:03:23 6945 8192000000 10631428128 11003158528 1694131920 17.136 100 79 157 2 1729572208 12228912 23211376
14:03:37 7125 8192000000 10649125248 11020587008 1711643856 17.282 100 83 165 0 1748770304 13401568 23724880
14:03:52 7076 8192000000 10659182096 11030315008 1721871328 17.368 100 90 178 0 1760820912 13558528 25391056
14:04:06 4146 8192000000 10670851680 11045511168 1731809280 17.451 100 78 156 0 1767087488 12964944 22313264
14:04:17 6564 8192000000 10685908272 11060486144 1747717264 17.583 100 80 161 0 1784090032 13661056 22711712
14:04:31 4526 8192000000 10714841840 11085385728 1767787488 17.749 100 91 180 0 1807606368 14071408 25747472
14:04:42 3133 8192000000 10711028464 11093860352 1772950400 17.791 100 85 167 1 1810048656 12998288 24099968
14:04:52 3699 8192000000 10725640432 11105337344 1782817568 17.873 100 84 168 0 1819216048 12512048 23886432
14:05:03 3783 8192000000 10720486352 11104927744 1790200992 17.933 100 84 168 0 1827792768 13665504 23926272
14:05:13 2631 8192000000 10741776272 11122069504 1801899648 18.029 100 87 174 1 1840199440 13762192 24537600
14:05:22 2653 8192000000 10747977600 11129393152 1805023280 18.055 100 80 160 0 1840574960 12187952 23363728
14:05:31 6939 8192000000 10744241424 11130937344 1806783728 18.070 100 74 148 1 1838511296 11802256 19925312
14:05:45 4660 8192000000 10753680912 11138195456 1809537264 18.092 100 78 157 2 1844299456 13255312 21506880
14:05:57 1419 8192000000 10771359456 11153997824 1829980816 18.259 100 90 180 0 1868490768 13437632 25072320
14:06:05 2186 8192000000 10785710800 11169857536 1835624304 18.305 100 95 189 1 1875662160 14122320 25915536
14:06:13 1978 8192000000 10787048048 11170349056 1844223056 18.375 100 87 175 1 1882148064 13555072 24369936
14:06:22 2280 8192000000 10793248032 11179966464 1854648704 18.460 100 86 172 0 1893824192 14923392 24252096
14:06:30 1529 8192000000 10799798528 11187146752 1856594592 18.476 100 93 182 1 1896570896 13603568 26372736
14:06:38 1285 8192000000 10805678000 11191312384 1864286432 18.538 100 94 187 3 1902444672 12386800 25771440
14:06:46 1463 8192000000 10811724992 11197825024 1863588544 18.532 100 86 173 2 1901981120 13255152 25137424
14:06:54 1317 8192000000 10816798272 11200147456 1866277440 18.554 100 96 196 2 1906064960 12377104 27410416
14:07:01 1532 8192000000 10813600192 11203809280 1871586624 18.597 100 94 188 1 1911780544 12679456 27514464
14:07:09 2710 8192000000 10795462480 11203641344 1866539440 18.556 100 66 133 0 1898252880 12837248 18876192
14:07:19 3364 8192000000 10802701072 11203309568 1866843968 18.559 100 64 128 2 1896425696 12155888 17425840
14:07:28 3698 8192000000 10791236368 11204513792 1870498080 18.588 100 55 110 1 1894626720 9089376 15039264
14:07:38 4492 8192000000 10795716944 11205074944 1869810960 18.583 100 47 95 1 1891732240 8232176 13689104
14:07:50 10692 8192000000 10790750208 11209338880 1880491536 18.669 100 41 84 1 1898005568 5889072 11624960
14:08:07 43434 8192000000 10798001104 11216850944 1876588432 18.638 100 32 64 3 1892411472 6877040 8946000
14:08:57 20713 8192000000 10791492448 11221401600 1878145552 18.650 100 23 46 2 1890295744 5490912 6659280
14:09:23 5011 8192000000 10798728576 11225604096 1885573904 18.710 100 37 74 0 1903775296 7136592 11064800
14:09:35 7221 8192000000 10795153200 11223764992 1884162368 18.699 100 33 66 2 1900354960 6818944 9373648
14:09:48 4178 8192000000 10792791888 11226779648 1883775200 18.696 100 27 54 1 1898236880 6613792 7847888
14:09:59 6099 8192000000 10800674384 11231805440 1886475168 18.717 100 25 49 1 1900555360 6790352 7289840
14:10:13 7790 8192000000 10808574928 11235098624 1889027840 18.738 100 26 52 3 1902201536 6358528 6815168
14:10:32 5392 8192000000 10803010592 11234533376 1892539488 18.766 100 27 54 1 1906626176 5244752 8841936
14:10:44 7582 8192000000 10812273408 11242323968 1894212512 18.780 100 32 64 1 1910404224 7155376 9036336
14:11:01 6945 8192000000 10804648720 11238510592 1892921664 18.769 100 16 32 3 1903459648 6135152 4402832
14:11:14 8550 8192000000 10807592880 11243905024 1900335904 18.829 100 20 39 1 1911090608 5408432 5346272
14:11:29 8119 8192000000 10809656784 11245297664 1898347056 18.813 100 24 48 0 1911085744 5794208 6944480
14:11:44 6284 8192000000 10819683936 11246698496 1899521088 18.822 100 30 60 2 1915106944 7402352 8183504
14:11:57 13283 8192000000 10811662880 11242029056 1896289104 18.796 100 13 26 2 1905428128 5753456 3385568
14:12:17 10962 8192000000 10803053104 11242418176 1897178016 18.804 100 17 34 2 1907457184 5434080 4845088
14:12:34 27632 8192000000 10818645920 11253170176 1899454800 18.822 100 22 44 2 1915357568 9740768 6162000
14:13:15 45035 8192000000 10803712480 11248103424 1903123632 18.851 100 42 81 2 1921368240 5107248 13137360
14:14:07 13856 8192000000 10827076624 11257921536 1907259824 18.885 100 34 70 1 1922483328 6060848 9162656
14:14:27 10113 8192000000 10822049168 11254886400 1890971312 18.754 99 30 60 1 1905036832 5532080 8533440
14:14:44 6726 8192000000 10823134976 11252899840 1905700240 18.872 100 32 64 0 1921836576 7273040 8863296
14:14:59 7901 8192000000 10797508544 11228782592 1869298096 18.579 98 24 48 1 1882141888 6189200 6654592
14:15:20 11150 8192000000 10801189408 11231985664 1827262912 18.237 96 27 53 3 1841241088 6044432 7933744
14:15:41 7132 8192000000 10779235248 11210149888 1867368096 18.563 100 20 40 5 1879444368 6111552 5964720
14:15:54 10869 8192000000 10799624864 11219210240 1829401632 18.254 97 25 50 2 1842103824 5534736 7167456
14:16:16 9349 8192000000 10783155216 11210588160 1838398240 18.328 98 16 32 1 1848184320 4805648 4980432
14:16:34 8087 8192000000 10764789376 11188654080 1779536736 17.846 95 21 42 1 1791009632 5728624 5744272
14:16:48 12964 8192000000 10720189792 11142418432 1756063040 17.652 95 10 20 0 1764032816 5045264 2924512
14:17:09 9270 8192000000 10745160992 11160612864 1738674128 17.508 94 21 41 1 1749941808 5475792 5791888
14:17:27 8336 8192000000 10713790880 11133054976 1729191968 17.429 95 17 33 2 1739540560 6089728 4258864
14:17:45 56424 8192000000 10672471488 11097866240 1713057216 17.294 95 41 81 4 1731057216 5240384 12759616
14:18:50 10963 8192000000 10702883152 11117101056 1772762720 17.790 99 19 38 0 1783632752 5845936 5024096
14:19:10 6011 8192000000 10724516688 11137744896 1788954464 17.923 99 35 70 1 1805934064 7110304 9869296
14:19:23 6570 8192000000 10700309776 11117854720 1758511216 17.672 97 28 56 1 1772394080 6047808 7835056
14:19:36 9635 8192000000 10722756176 11155992576 1805788992 18.061 99 24 48 1 1819541616 6636624 7116000
14:19:54 4591 8192000000 10699975520 11111043072 1743122896 17.545 97 27 53 1 1756500160 5610352 7766912
14:20:05 10166 8192000000 10695141664 11113435136 1757998464 17.668 98 28 56 1 1771827232 5502160 8326608
14:20:24 13726 8192000000 10717191776 11136782336 1778398352 17.836 98 23 46 1 1790829264 5520592 6910320
14:20:50 8966 8192000000 10720774784 11145793536 1812039472 18.113 100 22 44 1 1825388480 6827088 6521920
14:21:05 5218 8192000000 10732792384 11151138816 1812498160 18.116 100 27 54 0 1825513920 5763600 7252160
14:21:20 9624 8192000000 10748811072 11163262976 1813131824 18.122 99 25 49 2 1825687568 5096816 7458928
14:21:36 7787 8192000000 10749900304 11173269504 1835261168 18.302 100 17 34 1 1845389904 5514128 4614608
14:21:50 6426 8192000000 10765330432 11177295872 1836083248 18.309 100 13 27 2 1845331504 5259616 3988640
14:22:03 7232 8192000000 10767189552 11190927360 1849011424 18.414 100 22 42 1 1860147248 5962656 5173168
14:22:20 13816 8192000000 10753476016 11180134400 1848129824 18.407 100 22 44 1 1858626096 4784480 5711792
14:22:42 74212 8192000000 10760222416 11196723200 1859035536 18.495 100 19 38 2 1870075536 5238144 5801856
14:24:04 10325 8192000000 10778324288 11206197248 1865236368 18.546 100 24 49 3 1878298432 5657472 7404592
14:24:20 6220 8192000000 10794334048 11217526784 1873903840 18.616 100 42 84 0 1892287808 6259344 12124624
14:24:37 5519 8192000000 10804898672 11217752064 1875603376 18.630 100 34 66 4 1890776400 5886016 9287008
14:24:51 6188 8192000000 10817014032 11231170560 1881456496 18.677 100 40 80 0 1898580672 5057792 12066384
14:25:06 4395 8192000000 10798478192 11226492928 1881675760 18.679 100 35 70 2 1899137392 8015216 9446416
14:25:19 11942 8192000000 10798040736 11224784896 1879304512 18.659 100 16 32 0 1889398528 5665488 4428528
14:25:37 8969 8192000000 10794102512 11227852800 1880901168 18.672 100 18 34 1 1891112768 5322576 4889024
14:25:53 9560 8192000000 10787535008 11225628672 1882793840 18.688 100 27 54 1 1896101936 5302384 8005712
14:26:08 9564 8192000000 10792123680 11227062272 1883792624 18.696 100 17 33 3 1893970176 5031776 5145776
14:26:26 11174 8192000000 10809055936 11238359040 1888612992 18.735 100 19 39 1 1899688272 5258688 5816592
14:26:44 12468 8192000000 10809071632 11239432192 1890235104 18.748 100 13 26 2 1899090752 5057824 3797824
14:27:07 18141 8192000000 10833191024 11253968896 1902591488 18.847 100 17 34 2 1912676800 5139568 4945744
14:27:35 6623 8192000000 10847528768 11264700416 1920117568 18.988 100 44 89 1 1939268672 5840960 13310144
14:27:48 34800 8192000000 10862611248 11285897216 1930448928 19.070 100 46 92 1 1951684576 6949408 14286240
14:28:35 17404 8192000000 10864936480 11292581888 1939265552 19.141 100 47 92 2 1961422224 8540608 13616064
14:29:30 44777 8192000000 10866322000 11299409920 1941913568 19.162 100 30 60 1 1960901424 9999712 8988144
14:30:21 7837 8192000000 10888472752 11309969408 1949808272 19.225 100 53 103 3 1975374800 10253216 15313312
14:30:38 17367 8192000000 10875785040 11310923776 1935912336 19.114 99 46 91 1 1958994176 9894368 13187472
14:31:03 2656 8192000000 10895073264 11322798080 1961853568 19.321 100 60 120 1 1989627008 10375408 17398032
14:31:13 6364 8192000000 10911877424 11330535424 1961552144 19.318 100 62 124 0 1994355792 15630352 17173296
14:31:27 13164 8192000000 10917231680 11334930432 1968743344 19.375 100 71 137 1 2006211504 18434064 19034096
14:31:55 8493 8192000000 10917142320 11335729152 1957055184 19.283 99 64 129 2 1991217536 16202640 17959712
14:32:10 13304 8192000000 10906997680 11335061504 1962465728 19.326 100 61 121 3 1995998288 16072656 17459904
14:32:30 3455 8192000000 10932268400 11341135872 1974532432 19.421 100 66 132 1 2011401936 17864096 19005408
14:32:42 5753 8192000000 10901840560 11332034560 1952439040 19.246 99 61 120 1 1986823296 17439104 16945152
14:32:54 8242 8192000000 10902676592 11326418944 1959113440 19.299 100 56 110 1 1991856800 17460048 15283312
14:33:10 7137 8192000000 10908177424 11334107136 1952400432 19.246 99 59 117 1 1987706688 18662896 16643360
14:33:25 11883 8192000000 10910183248 11329097728 1948200032 19.212 99 64 127 0 1987080976 19731904 19149040
14:33:45 4006 8192000000 10897955744 11306663936 1940516656 19.151 99 72 142 3 1983601184 22343600 20740928
14:33:58 5886 8192000000 10923648352 11339079680 1970468176 19.389 100 75 150 1 2015715904 23580192 21667536
14:34:12 7873 8192000000 10903101088 11315441664 1929804432 19.065 98 65 127 1 1973465696 25127264 18534000
14:34:29 17638 8192000000 10920555616 11341111296 1958960640 19.298 100 56 112 0 2002055296 25506944 17587712
14:34:54 5511 8192000000 10929045584 11354054656 1975444416 19.429 100 60 115 1 2021959872 29478608 17036848
14:35:06 7077 8192000000 10922201648 11350188032 1971523936 19.398 100 52 104 0 2018319168 29680960 17114272
14:35:21 5197 8192000000 10937144336 11347046400 1967913632 19.369 100 81 160 2 2022651392 31050128 23687632
14:35:37 3033 8192000000 10941359344 11355303936 1975163776 19.426 100 72 142 1 2027316768 31247376 20905616
14:35:47 3931 8192000000 10953447712 11370536960 1984891840 19.503 100 70 139 1 2038412704 32605776 20915088
14:35:57 4702 8192000000 10960173728 11375702016 1989972208 19.544 100 62 123 1 2040659952 32696464 17991280
14:36:22 2767 8192000000 10951201744 11385774080 1996442640 19.595 100 53 106 2 2044821952 32065632 16313680
14:36:31 1989 8192000000 10919844848 11337678848 1953369152 19.253 100 59 118 1 2003616384 31979664 18267568
14:36:40 6540 8192000000 10921515424 11349196800 1948680496 19.216 99 62 121 1 1999908672 32843856 18384320
14:36:53 1848 8192000000 10928743472 11350614016 1967729520 19.367 100 78 152 1 2025303728 34803824 22770384
14:37:06 4880 8192000000 10936597696 11358248960 1972748848 19.407 100 78 156 2 2032311872 35781408 23781616
14:37:26 14906 8192000000 10896086144 11330355200 1933353120 19.094 99 44 88 3 1984181424 36803008 14025296
14:38:00 3911 8192000000 10899059136 11326881792 1941337424 19.157 100 42 84 0 1987902528 33673568 12891536
14:38:11 6678 8192000000 10913393552 11334201344 1934230128 19.101 99 49 99 0 1981929616 33029120 14670368
14:38:26 2748 8192000000 10931854752 11343220736 1961363840 19.317 100 76 152 0 2018804048 34148896 23291312
14:38:37 9398 8192000000 10915638480 11329273856 1940958864 19.154 99 63 126 0 1995097280 35501728 18636688
14:38:54 2501 8192000000 10913307616 11325386752 1938113168 19.132 99 67 132 0 1994204864 35914688 20177008
14:39:04 6940 8192000000 10926092896 11337977856 1949189968 19.220 100 73 146 2 2012236640 41576320 21470352
14:39:18 3374 8192000000 10929018176 11332931584 1947561536 19.207 100 81 163 0 2011101936 39135728 24404672
14:39:28 3275 8192000000 10920591760 11336863744 1946195008 19.196 100 63 125 0 2004440976 38967728 19278240
14:39:38 3481 8192000000 10896048784 11308171264 1909738208 18.905 99 74 148 0 1971299776 38490160 23071408
14:39:48 1612 8192000000 10896523200 11295879168 1912215184 18.924 99 88 176 1 1979475936 40638096 26622656
14:39:58 2779 8192000000 10882546928 11284877312 1903534272 18.855 99 77 155 1 1969491792 42116480 23841040
14:40:10 3415 8192000000 10896512832 11309670400 1909907696 18.906 99 69 138 0 1973722384 43078864 20735824
14:40:24 2234 8192000000 10905069472 11309281280 1920857888 18.994 100 81 162 1 1989777824 43568512 25351424
14:40:33 3608 8192000000 10905995616 11318669312 1929149536 19.060 100 65 131 1 1991266512 42283104 19833872
14:40:44 2493 8192000000 10904799024 11318198272 1916466128 18.959 99 72 143 3 1980608336 42575360 21566848
14:40:57 1807 8192000000 10896439328 11310530560 1920257040 18.989 100 73 144 3 1988050960 44563968 23229952
14:41:06 3229 8192000000 10900714976 11310219264 1919884160 18.986 100 74 148 1 1985844864 43086320 22874384
14:41:16 2598 8192000000 10891742880 11305369600 1914445328 18.942 100 68 135 3 1979087792 43230096 21412368
14:41:27 6265 8192000000 10889721920 11300884480 1912670560 18.928 100 74 148 1 1977305600 41962672 22672368
14:41:39 3686 8192000000 10879741152 11296587776 1908470768 18.894 100 64 128 0 1971256992 43092848 19693376
14:41:52 1519 8192000000 10888919984 11291021312 1902387216 18.845 100 85 171 2 1971439920 43213264 25839440
14:42:02 6862 8192000000 10858036000 11280838656 1885540112 18.710 100 54 108 1 1950679600 48384688 16754800
14:42:18 11215 8192000000 10855058928 11294167040 1899093488 18.819 100 39 78 1 1954659776 42818144 12748144
14:42:46 10183 8192000000 10864156352 11292332032 1883593760 18.694 99 34 68 0 1934183520 39721920 10867840
14:43:12 9219 8192000000 10870924448 11299995648 1905780656 18.873 100 29 58 1 1953453136 37902544 9769936
14:43:28 6646 8192000000 10867501232 11309871104 1912596272 18.927 100 29 58 1 1960987664 38574112 9817280
14:43:51 15977 8192000000 10867799808 11307663360 1916676720 18.960 100 21 42 1 1957013872 33358144 6979008
14:44:24 8455 8192000000 10879350368 11307520000 1915917904 18.954 100 41 78 2 1965565456 36828384 12819168
14:44:53 6514 8192000000 10886450752 11314581504 1920085856 18.988 100 54 106 0 1980046128 42545056 17415216
14:45:07 16684 8192000000 10883321280 11325726720 1905193120 18.868 99 35 70 1 1958281424 40425056 12663248
14:45:30 9621 8192000000 10889208208 11311869952 1902683088 18.848 99 38 74 2 1959546672 43068336 13795248
14:45:49 8238 8192000000 10895009008 11325063168 1910910272 18.914 99 37 74 0 1965676032 42172368 12593392
14:46:04 11880 8192000000 10899263200 11335409664 1927689072 19.048 100 28 56 2 1979701984 41808448 10204464
14:46:24 16006 8192000000 10910388608 11345854464 1927605856 19.048 100 38 75 2 1987143504 47066624 12471024
14:46:50 28855 8192000000 10882375168 11325939712 1924114224 19.020 100 25 50 1 1985318272 51526688 9677360
14:47:28 19066 8192000000 10880871504 11325112320 1923591440 19.016 100 35 70 0 1977549888 42033712 11924736
14:48:08 13023 8192000000 10888694352 11330760704 1931287360 19.077 100 31 62 3 1970743056 28582000 10873696
14:49:13 38985 8192000000 10871074224 11327012864 1914087088 18.939 99 17 33 2 1950791376 31198672 5505616
14:49:59 47372 8192000000 10860766080 11326500864 1923992368 19.019 100 12 24 1 1963656720 35512624 4151728
14:50:52 71459 8192000000 10859057664 11297247232 1811995264 18.112 94 19 40 1 1835443296 18101056 5346976
14:52:14 17897 8192000000 10877586096 11306983424 1927876208 19.050 100 59 118 0 1955390128 10072368 17441552
14:52:41 8355 8192000000 10872174064 11314302976 1934628016 19.104 100 51 100 1 1960316240 11448960 14239264
14:53:04 61656 8192000000 10869827920 11330850816 1938210192 19.132 100 29 58 3 1959904512 13593456 8100864
14:54:35 138350 8192000000 10892310064 11347640320 1945700576 19.192 100 36 70 0 1968954464 13360656 9893232
14:57:12 73170 8192000000 10889822016 11364380672 1959223648 19.300 100 10 20 0 1973821328 12000352 2597328
14:58:32 5189 8192000000 10888850672 11364708352 1966796992 19.360 100 6 13 0 1981224768 13004928 1422848
14:58:44 10657 8192000000 10908677728 11360772096 1952287696 19.245 99 20 40 1 1971293456 13186624 5819136
14:59:02 20715 8192000000 10917293952 11364827136 1980577696 19.469 100 48 95 1 2003110416 9604576 12928144
14:59:34 64906 8192000000 10890510080 11367661568 1956934080 19.282 99 10 18 1 1970266016 11067248 2264688
15:00:45 12948 8192000000 10887303024 11364917248 1957316784 19.285 99 5 10 0 1969305520 10913232 1075504
15:01:04 14991 8192000000 10898228400 11364487168 1977256400 19.443 100 13 26 0 1992879376 12150464 3472512
15:01:47 86529 8192000000 10890315184 11362484224 1947674592 19.208 98 18 36 0 1958563472 6279392 4609488
15:03:32 41089 8192000000 10913388864 11380555776 1988001040 19.528 100 17 32 2 2001443888 8560928 4881920
15:04:27 14397 8192000000 10915505680 11382616064 1998511392 19.611 100 37 77 2 2019235184 9921648 10802144
15:04:49 41368 8192000000 10930876512 11393589248 1999191680 19.616 100 22 44 2 2014368192 9013104 6163408
15:05:39 64896 8192000000 10923292320 11399536640 1994405040 19.579 100 23 46 0 2012117984 10304928 7408016
15:07:01 54683 8192000000 10914194928 11392565248 1975963440 19.433 99 8 16 2 1990027968 11849888 2214640
15:08:04 52201 8192000000 10926672880 11401453568 1985155760 19.505 99 24 48 0 2003313408 11086672 7070976
15:09:03 45013 8192000000 10925098160 11390160896 1960585216 19.311 98 30 59 2 1984858416 15598176 8675024
15:10:01 56394 8192000000 10906299184 11372462080 1903246272 18.852 96 12 24 1 1929166128 21939264 3980592
15:11:05 35480 8192000000 10898028480 11360620544 1924607520 19.024 97 20 40 0 1938432704 8236304 5588880
15:11:50 22154 8192000000 10906543744 11358003200 1935142848 19.108 98 27 54 0 1953942704 10948256 7851600
15:12:20 20421 8192000000 10899743552 11364253696 1956240000 19.276 100 36 70 2 1979620800 13438496 9942304
15:12:46 48801 8192000000 10882504752 11359002624 1913366176 18.934 97 15 30 1 1933071840 15395632 4310032
15:13:41 99772 8192000000 10861459056 11322626048 1843611312 18.370 94 11 22 2 1864937088 18046384 3279392
15:15:29 110595 8192000000 10871590512 11346169856 1850904976 18.429 95 15 30 2 1870099056 15081904 4112176
15:17:25 97999 8192000000 10899158464 11360641024 1872026560 18.601 96 23 46 0 1892013536 13892736 6094240
15:19:10 77406 8192000000 10852486128 11336105984 1869293440 18.579 96 14 28 1 1892444304 19163296 3987568
15:20:34 87605 8192000000 10867295328 11323346944 1899585328 18.823 98 26 53 0 1913880560 7010448 7284784
15:22:07 39434 8192000000 10896743072 11341524992 1938056752 19.131 99 50 99 1 1964988720 12478368 14453600
15:23:51 58607 8192000000 10879587824 11359318016 1931175552 19.076 99 21 42 2 1963627920 26605168 5847200
15:25:55 41929 8192000000 10850558784 11328319488 1884419632 18.701 97 5 10 0 1905305568 19491216 1394720
15:26:49 55637 8192000000 10830100464 11297218560 1845642112 18.387 95 9 19 0 1857420656 9131376 2647168
15:27:59 137630 8192000000 10858024112 11342118912 1868608128 18.573 97 11 22 1 1885840368 14360832 2871408
15:30:23 63959 8192000000 10834672768 11310440448 1845950048 18.389 95 16 32 0 1862483136 11976832 4556256
15:31:36 71175 8192000000 10839543120 11296608256 1799585200 18.011 93 27 54 2 1818655376 11431568 7638608
15:32:57 85286 8192000000 10846854912 11316514816 1821801856 18.192 95 12 24 1 1835788880 10368000 3619024
15:34:54 65681 8192000000 10878973952 11335524352 1905118144 18.867 99 19 38 1 1926204608 15831568 5254896
15:36:17 24743 8192000000 10912412160 11369140224 1948486496 19.214 100 39 78 0 1978719696 18524288 11708912
15:37:03 103753 8192000000 10874037904 11352268800 1872610784 18.605 96 9 18 1 1900192496 24966848 2614864
15:38:57 102201 8192000000 10894670240 11333943296 1871714160 18.598 96 25 50 1 1892693648 13498752 7480736
15:40:47 51397 8192000000 10884791360 11329556480 1868643200 18.573 96 36 72 0 1894056080 15301024 10111856
15:41:47 57462 8192000000 10867877424 11347611648 1910385776 18.910 99 15 30 0 1930111920 15722944 4003200
15:42:51 93065 8192000000 10889502160 11350360064 1952911936 19.250 100 30 60 0 1971383408 9616736 8854736
15:44:33 59862 8192000000 10901958320 11351040000 1933146096 19.092 98 48 97 4 1953754656 7597808 13010752
15:45:39 39142 8192000000 10907739104 11359936512 1963090800 19.331 100 49 96 1 1989874672 12529664 14254208
15:46:25 8603 8192000000 10902196608 11360047104 1963895600 19.337 100 37 74 3 1985007584 10999936 10112048
15:46:41 46775 8192000000 10876214816 11361972224 1968357296 19.372 100 35 70 1 1988196512 9385888 10453328
15:47:48 77459 8192000000 10888505760 11364470784 1949280960 19.221 99 16 32 0 1965547440 11496352 4770128
15:49:19 32310 8192000000 10889920352 11369598976 1966610704 19.359 100 8 16 0 1978619952 9713152 2296096
15:50:00 24643 8192000000 10883512448 11359440896 1954513328 19.262 99 24 48 0 1968483808 7257680 6712800
15:50:31 64008 8192000000 10898073328 11374346240 1954081712 19.259 99 11 22 0 1965353744 7580016 3692016
15:51:41 93570 8192000000 10889164416 11362549760 1958855488 19.297 99 18 36 1 1979559072 15436768 5266816
15:53:29 60584 8192000000 10883286016 11379818496 1956833936 19.281 99 14 28 1 1976478800 15662272 3982592
15:54:42 46465 8192000000 10892735728 11363045376 1953769344 19.256 99 10 20 0 1964785312 8254896 2761072
15:55:43 44080 8192000000 10896114928 11363438592 1950248160 19.228 99 15 30 2 1964210544 9284480 4677904
15:56:34 31315 8192000000 10895170672 11363098624 1939913568 19.146 98 37 72 2 1960415856 10552192 9950096
15:57:11 89718 8192000000 10886842880 11365859328 1910829296 18.913 97 19 38 1 1927734240 11760112 5144832
15:58:47 52809 8192000000 10883222048 11349188608 1912377648 18.926 97 21 41 1 1927091296 9525952 5187696
15:59:46 53879 8192000000 10874806976 11341844480 1894663104 18.783 97 18 36 4 1910153680 10702192 4788384
16:01:06 65848 8192000000 10899623840 11361525760 1939754848 19.145 99 18 36 0 1955694416 10237152 5702416
16:02:18 49261 8192000000 10912234512 11371704320 1957100528 19.283 99 41 81 1 1978299424 9978032 11220864
16:03:24 32082 8192000000 10917842176 11380936704 1956283504 19.276 99 33 66 0 1980314048 14957792 9072752
16:04:08 106844 8192000000 10852812224 11310051328 1835910560 18.308 93 18 36 0 1857763312 16462368 5390384
16:06:04 68189 8192000000 10879388976 11343200256 1920069424 18.987 99 16 32 3 1942450320 17914192 4466704
16:07:23 58674 8192000000 10889545984 11361587200 1917403424 18.966 98 16 32 0 1935368176 13561072 4403680
16:08:29 130859 8192000000 10877301216 11341422592 1898816304 18.817 97 24 49 0 1913711008 8139440 6755264
16:10:46 79903 8192000000 10853326320 11335245824 1852729232 18.444 95 13 26 0 1870279744 13901152 3649360
16:12:17 48711 8192000000 10856411568 11321790464 1878778208 18.655 97 21 42 0 1897606848 12667216 6161424
16:13:23 82619 8192000000 10872659360 11333410816 1872446672 18.604 97 23 46 2 1896304272 16852048 7005552
16:14:54 39979 8192000000 10859682912 11333586944 1917559024 18.967 99 19 38 1 1939303328 15648848 6095456
16:15:40 72437 8192000000 10846827792 11317788672 1855836752 18.470 96 18 36 1 1873981456 12606512 5538192
16:17:08 91444 8192000000 10862163088 11331407872 1881387024 18.676 97 14 28 2 1898473808 13082512 4004272
16:19:35 53868 8192000000 10833985744 11302211584 1859322368 18.498 97 12 23 1 1876953264 14334800 3296096
16:20:35 62179 8192000000 10856301776 11322523648 1866747216 18.558 97 20 40 0 1890897920 18525504 5625200
16:21:44 59457 8192000000 10880062448 11330543616 1903860784 18.857 99 28 56 1 1930567088 18580624 8125680
16:22:53 61059 8192000000 10843745088 11305934848 1867720176 18.566 97 26 52 0 1886460800 11896160 6844464
16:24:03 41448 8192000000 10868367392 11321843712 1908828528 18.897 99 32 64 1 1928676176 11055040 8792608
16:24:51 70481 8192000000 10853269952 11326234624 1890564480 18.750 98 28 54 1 1917040016 18647872 7827664
16:26:08 66989 8192000000 9409353664 9699094528 540561616 6.190 29 5 10 0 547154544 5247888 1345040

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 09-12-2020 16:28:09 to 09-12-2020 16:28:40.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 109 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 09-12-2020 16:28:41 to 09-12-2020 16:28:43.

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          253583
MON$OLDEST_ACTIVE               253584
MON$OLDEST_SNAPSHOT             253584
MON$NEXT_TRANSACTION            253584
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                       2034848
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.33398 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33398 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33398 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33398 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 ---
:226: 
:227: mscs-test-161.budzdorov.ru    Wed Dec  9 16:27:17 2020
:228:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:229: 
:230: 
:231: mscs-test-161.budzdorov.ru    Wed Dec  9 16:27:17 2020
:232:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:233: 
--- end of diff output ---

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

09.12.20 16:28:44. 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-12-09 16:28:46 No severe PSQL-related problems occured
09.12.20 16:28:47. End of report.