Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 26.12.2020 22: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 16991436 kB
MemAvailable 31434940 kB
Buffers 0 kB
Cached 14666300 kB
SwapCached 4820 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-26 22:27:09
DTS_END                         2020-12-26 22:27:09.6880
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/43850
TRN_ID                          244728
ATT_ID                          671
EXC_UNIT                        2


Test workload details

SETTING_NAME SETTING_VALUE
WORKING_MODE SMALL_03
C_WARES_MAX_ID 400
C_CUSTOMER_DOC_MAX_ROWS 10
C_SUPPLIER_DOC_MAX_ROWS 50
C_CUSTOMER_DOC_MAX_QTY 15
C_SUPPLIER_DOC_MAX_QTY 50
C_NUMBER_OF_AGENTS 50

Indexes for heavy-loaded tables

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_ASC WORKER_ID,DOC_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_DEC WORKER_ID,DOC_ID
XQD_1200_2000 XQD_1200_2000_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID

Performance in TOTAL

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE
*** OVERALL *** for 120 minutes: 9666.30 20483 1159956
customer order: creation 176.91 340 21229
customer order: refuse 15.32 341 1838
order to supplier: creation 48.59 1257 5831
order to supplier: removal 3.90 88502 468
invoice (draft): creation 47.69 3290 5723
invoice (draft): removal 56.38 756 6765
invoice accept: apply 42.20 16716 5064
invoice accept: cancel 51.08 642 6130
customer reserve: creation 3933.88 162 472065
customer reserve: removal 4986.33 53 598359
realization accept: apply 84.97 197 10196
realization accept: cancel 84.89 97 10187
payment from customer: creation 60.60 132 7272
payment from customer: removal 5.90 79 708
payment to supplier: creation 51.50 142 6180
payment to supplier: removal 3.44 63 413
service: total inventory turnovers 4.95 1334 594
service: total monetary turnovers 6.86 24 823
service: aggregate perf. data 0.89 17480 107
service: refresh index statistics 0.03 278060 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 26-12-2020 22:28:17 to 26-12-2020 22:28:19.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4854
TEST_TIME 2 5639
TEST_TIME 3 4612
TEST_TIME 4 3780
TEST_TIME 5 4680
TEST_TIME 6 4632
TEST_TIME 7 4468
TEST_TIME 8 4654
TEST_TIME 9 4753
TEST_TIME 10 4837
TEST_TIME 11 5123
TEST_TIME 12 5648
TEST_TIME 13 5671
TEST_TIME 14 6279
TEST_TIME 15 6397
TEST_TIME 16 6763
TEST_TIME 17 7464
TEST_TIME 18 7472
TEST_TIME 19 7692
TEST_TIME 20 8542
TEST_TIME 21 9017
TEST_TIME 22 9349
TEST_TIME 23 9672
TEST_TIME 24 9802
TEST_TIME 25 10358
TEST_TIME 26 10641
TEST_TIME 27 10613
TEST_TIME 28 11124
TEST_TIME 29 10957
TEST_TIME 30 10775
TEST_TIME 31 10731
TEST_TIME 32 10817
TEST_TIME 33 10846
TEST_TIME 34 10907
TEST_TIME 35 10916
TEST_TIME 36 10863
TEST_TIME 37 10743
TEST_TIME 38 10707
TEST_TIME 39 10763
TEST_TIME 40 10735
TEST_TIME 41 10728
TEST_TIME 42 10513
TEST_TIME 43 10471
TEST_TIME 44 10499
TEST_TIME 45 10426
TEST_TIME 46 10269
TEST_TIME 47 10218
TEST_TIME 48 10245
TEST_TIME 49 10340
TEST_TIME 50 10339
TEST_TIME 51 10332
TEST_TIME 52 10230
TEST_TIME 53 10233
TEST_TIME 54 10120
TEST_TIME 55 9972
TEST_TIME 56 9928
TEST_TIME 57 9994
TEST_TIME 58 9944
TEST_TIME 59 9841
TEST_TIME 60 9926
TEST_TIME 61 9944
TEST_TIME 62 9910
TEST_TIME 63 10012
TEST_TIME 64 10009
TEST_TIME 65 10054
TEST_TIME 66 10073
TEST_TIME 67 10104
TEST_TIME 68 10125
TEST_TIME 69 10131
TEST_TIME 70 10110
TEST_TIME 71 10127
TEST_TIME 72 10175
TEST_TIME 73 10202
TEST_TIME 74 10232
TEST_TIME 75 10185
TEST_TIME 76 10082
TEST_TIME 77 10108
TEST_TIME 78 10064
TEST_TIME 79 10056
TEST_TIME 80 9994
TEST_TIME 81 9951
TEST_TIME 82 9988
TEST_TIME 83 9928
TEST_TIME 84 9874
TEST_TIME 85 9871
TEST_TIME 86 9922
TEST_TIME 87 9872
TEST_TIME 88 9876
TEST_TIME 89 9945
TEST_TIME 90 9903
TEST_TIME 91 9901
TEST_TIME 92 9960
TEST_TIME 93 10045
TEST_TIME 94 10074
TEST_TIME 95 10037
TEST_TIME 96 10113
TEST_TIME 97 10159
TEST_TIME 98 10166
TEST_TIME 99 10176
TEST_TIME 100 10139
TEST_TIME 101 10078
TEST_TIME 102 10046
TEST_TIME 103 10006
TEST_TIME 104 9975
TEST_TIME 105 10007
TEST_TIME 106 9991
TEST_TIME 107 9966
TEST_TIME 108 9948
TEST_TIME 109 9922
TEST_TIME 110 9898
TEST_TIME 111 9858
TEST_TIME 112 9819
TEST_TIME 113 9790
TEST_TIME 114 9796
TEST_TIME 115 9746
TEST_TIME 116 9749
TEST_TIME 117 9724
TEST_TIME 118 9719
TEST_TIME 119 9743
TEST_TIME 120 9675

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 26-12-2020 22:28:20 to 26-12-2020 22:28:24.

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 1597645 1597645 0 0.00 0 24779 6 0 0
doc_list_biud 1597644 1597644 0 0.00 0 31545 26 0 0
sp_add_invoice_to_stock 5183 5064 119 2.29 45 215350 16717 0 119
sp_cancel_adding_invoice 6130 6130 0 0.00 4 51750 643 0 0
sp_cancel_client_order 1838 1838 0 0.00 4 12715 342 0 0
sp_cancel_customer_reserve 598359 598359 0 0.00 1 22098 54 0 0
sp_cancel_pay_from_customer 708 708 0 0.00 2 7668 80 0 0
sp_cancel_pay_to_supplier 413 413 0 0.00 3 2128 64 0 0
sp_cancel_supplier_invoice 6771 6765 6 0.08 1 25488 757 0 6
sp_cancel_supplier_order 468 468 0 0.00 6 1150996 88502 0 0
sp_cancel_write_off 10187 10187 0 0.00 1 23755 97 0 0
sp_client_order 21229 21229 0 0.00 3 23590 341 0 0
sp_customer_reserve 472065 472065 0 0.00 0 38813 163 0 0
sp_fill_shopping_cart 32778 32778 0 0.00 1 15463 40 0 0
sp_fill_shopping_cart_clo_res 472057 472057 0 0.00 0 13263 12 0 0
sp_get_clo_for_invoice 5052 5052 0 0.00 0 16709 266 0 0
sp_kill_cost_storno 17438 17438 0 0.00 0 9339 50 0 0
sp_kill_qstorno_ret_qs2qd 1214138 1214138 0 0.00 0 25477 29 0 0
sp_kill_qty_storno 638995 638995 0 0.00 0 31545 63 0 0
sp_lock_selected_doc 21208 21208 0 0.00 0 10543 9 0 0
sp_make_cost_storno 28700 28700 0 0.00 0 15880 60 0 0
sp_multiply_rows_for_pdistr 28700 28700 0 0.00 0 24761 35 0 0
sp_multiply_rows_for_qdistr 21229 21229 0 0.00 0 19961 146 0 0
sp_pay_from_customer 7272 7272 0 0.00 4 12658 132 0 0
sp_pay_to_supplier 6180 6180 0 0.00 5 24783 143 0 0
sp_payment_common 13452 13452 0 0.00 2 10394 40 0 0
sp_qd_handle_on_cancel_clo 1838 1838 0 0.00 0 12698 306 0 0
sp_qd_handle_on_invoice_upd_sts 11182 11182 0 0.00 0 31544 330 0 0
sp_qd_handle_on_reserve_upd_sts 10196 10196 0 0.00 0 13676 64 0 0
sp_reserve_write_off 10196 10196 0 0.00 6 15895 198 0 0
sp_supplier_invoice 5723 5723 0 0.00 5 85601 3290 0 0
sp_supplier_order 5831 5831 0 0.00 6 30790 1257 0 0
srv_aggregate_perf_data 107 107 0 0.00 2360 136409 17481 0 0
srv_fill_mon_cache_memory 163 163 0 0.00 1321 131189 32329 0 0
srv_find_qd_qs_mism 1111038 1111038 0 0.00 0 21000 4 0 0
srv_make_invnt_saldo 594 594 0 0.00 32 40749 1334 0 0
srv_make_money_saldo 823 823 0 0.00 1 3504 25 0 0
srv_recalc_idx_stat 4 4 0 0.00 156048 379438 278060 0 0
t$perf-abend:sp_add_invoice_to_stock 119 119 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5064 5064 0 0.00 0 29042 206 0 0
t$perf-norm:sp_cancel_adding_invoice 398 398 0 0.00 0 8968 73 0 0
t$perf-norm:sp_cancel_client_order 1838 1838 0 0.00 0 1037 8 0 0
t$perf-norm:sp_cancel_customer_reserve 710 710 0 0.00 0 1355 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 708 708 0 0.00 0 2281 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 413 413 0 0.00 0 197 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 408 408 0 0.00 0 655 15 0 0
t$perf-norm:sp_cancel_supplier_order 468 468 0 0.00 0 25923 1671 0 0
t$perf-norm:sp_cancel_write_off 1017 1017 0 0.00 0 4087 18 0 0
t$perf-norm:sp_client_order 21229 21229 0 0.00 0 12127 18 0 0
t$perf-norm:sp_customer_reserve 1103 1103 0 0.00 0 2281 10 0 0
t$perf-norm:sp_pay_from_customer 7272 7272 0 0.00 0 4791 11 0 0
t$perf-norm:sp_pay_to_supplier 6180 6180 0 0.00 0 3828 9 0 0
t$perf-norm:sp_reserve_write_off 10196 10196 0 0.00 0 9718 16 0 0
t$perf-norm:sp_supplier_invoice 5723 5723 0 0.00 0 7230 18 0 0
t$perf-norm:sp_supplier_order 5831 5831 0 0.00 0 16771 22 0 0
t$perf-norm:srv_aggregate_perf_data 107 107 0 0.00 0 7294 80 0 0
t$perf-norm:srv_fill_mon_cache_memory 163 163 0 0.00 0 415 5 0 0
t$perf-norm:srv_make_invnt_saldo 594 594 0 0.00 0 2132 23 0 0
t$perf-norm:srv_make_money_saldo 823 823 0 0.00 0 14624 42 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 3 3 0 0
v_add_invoice_to_stock 10342 10104 238 2.30 0 9908 20 0 238
v_all_customers 38630 38630 0 0.00 0 17 1 0 0
v_all_suppliers 32400 32400 0 0.00 0 19 1 0 0
v_all_wares 42458 42458 0 0.00 0 68 1 0 0
v_cancel_adding_invoice 796 796 0 0.00 0 1630 9 0 0
v_cancel_client_order 3676 3676 0 0.00 0 5854 10 0 0
v_cancel_customer_prepayment 1416 1416 0 0.00 0 2611 10 0 0
v_cancel_customer_reserve 1420 1420 0 0.00 0 254 3 0 0
v_cancel_payment_to_supplier 826 826 0 0.00 0 1806 8 0 0
v_cancel_supplier_invoice 828 816 12 1.44 0 9984 35 0 12
v_cancel_supplier_order 936 936 0 0.00 0 385 3 0 0
v_cancel_write_off 2034 2034 0 0.00 0 1814 15 0 0
v_max_id_clo_ord 5831 5831 0 0.00 0 869 1 0 0
v_max_id_clo_res 1103 1103 0 0.00 0 5149 21 0 0
v_max_id_ord_sup 5718 5718 0 0.00 0 2584 2 0 0
v_max_non_paid_invoice 1529 1529 0 0.00 0 6154 7 0 0
v_max_non_paid_realizn 3811 3811 0 0.00 0 6362 8 0 0
v_min_id_clo_ord 5831 5831 0 0.00 0 15451 14 0 0
v_min_id_clo_res 1103 1103 0 0.00 0 11083 27 0 0
v_min_id_ord_sup 5718 5718 0 0.00 0 9756 8 0 0
v_min_non_paid_invoice 6180 6180 0 0.00 0 9260 25 0 0
v_min_non_paid_realizn 7272 7272 0 0.00 0 10388 28 0 0
v_our_firm 10750 10750 0 0.00 0 16 1 0 0
v_reserve_write_off 20392 20392 0 0.00 0 3219 5 0 0
x_lock_depdocs_on_canc_invoice 12487 12487 0 0.00 0 12191 98 0 0
x_lock_depdocs_on_canc_sup_ord 468 468 0 0.00 0 11778 342 0 0
x_make_qstorno_1000_1200 5831 5831 0 0.00 2 28217 1168 0 0
x_make_qstorno_1200_2000 5723 5723 0 0.00 2 85591 3151 0 0
x_make_qstorno_2100_3300 472065 472065 0 0.00 0 38812 148 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 26-12-2020 22:28:25 to 26-12-2020 22:28:29.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:13 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:20 13714 8192000000 10220159648 10524966912 892513376 9.824 71 54 112 2 911991088 2382480 17095232
19:57:40 25848 8192000000 10330041968 10649280512 1376388416 14.384 100 82 164 0 1407607840 4184832 27034592
19:58:16 37813 8192000000 10379973760 10703912960 1433865920 14.895 100 94 188 0 1470510560 6097552 30547088
19:59:13 21554 8192000000 10405905424 10734981120 1463410144 15.156 100 89 178 0 1499629408 7262448 28956816
19:59:51 17310 8192000000 10430675264 10762006528 1484273280 15.339 100 85 170 1 1519826896 8027104 27526512
20:00:23 18975 8192000000 10449511200 10785591296 1506721296 15.535 100 88 174 1 1543307472 8530896 28055280
20:00:51 18515 8192000000 10457193712 10798276608 1516646976 15.621 100 81 162 0 1551547696 8858816 26041904
20:01:24 20346 8192000000 10485519376 10835030016 1541524880 15.837 100 79 158 0 1576153776 9299376 25329520
20:01:51 11947 8192000000 10526702336 10876067840 1586090880 16.220 100 82 164 0 1621265056 9994480 25179696
20:02:11 12106 8192000000 10532145184 10888024064 1601408816 16.351 100 82 164 0 1637213856 10613232 25191808
20:02:32 12480 8192000000 10557567120 10915938304 1615177744 16.469 100 74 148 1 1648458000 11117152 22163104
20:02:52 12773 8192000000 10576331696 10935988224 1630823648 16.602 100 82 164 1 1667065232 11804464 24437120
20:03:13 14422 8192000000 10579584224 10942693376 1647263120 16.741 100 73 146 2 1680455664 11983792 21208752
20:03:35 11970 8192000000 10603940144 10969739264 1660963360 16.857 100 78 156 1 1696442064 12293744 23184960
20:03:55 11721 8192000000 10626103552 10994040832 1688007120 17.085 100 81 160 1 1723821344 12742016 23072208
20:04:15 11160 8192000000 10649913440 11019919360 1704228128 17.220 100 73 146 3 1738129728 12318336 21583264
20:04:34 7223 8192000000 10657608432 11033190400 1718430560 17.339 100 75 150 2 1752533808 12910352 21192896
20:04:48 6040 8192000000 10680219936 11054219264 1735430112 17.481 100 85 170 1 1771677136 12747744 23499280
20:05:04 7033 8192000000 10678933728 11059429376 1742904864 17.543 100 71 141 0 1774974544 11774080 20295600
20:05:18 4951 8192000000 10685556032 11068272640 1756913312 17.659 100 73 146 3 1789401520 11666544 20821664
20:05:30 5779 8192000000 10700615664 11082731520 1765951120 17.734 100 69 138 1 1796377744 11280400 19146224
20:05:42 7498 8192000000 10710560384 11093913600 1778291520 17.835 100 83 167 1 1814171392 12310224 23569648
20:05:56 3757 8192000000 10726978240 11105447936 1787566352 17.912 100 86 170 2 1823650272 12277776 23806144
20:06:08 4261 8192000000 10732104704 11115180032 1791378416 17.943 100 83 166 0 1828227184 13939888 22908880
20:06:19 9519 8192000000 10741399552 11125002240 1797579584 17.994 100 76 152 0 1832436944 13907072 20950288
20:06:36 4219 8192000000 10756270528 11136954368 1803408464 18.042 100 76 154 2 1837610192 13280496 20921232
20:06:47 3804 8192000000 10757574000 11143983104 1815650864 18.142 100 82 162 1 1852127504 13400752 23075888
20:06:58 4619 8192000000 10764447792 11146768384 1821806592 18.192 100 81 163 2 1858362272 13835152 22720528
20:07:10 2784 8192000000 10759221472 11152986112 1828187056 18.245 100 89 178 0 1867495200 14046224 25261920
20:07:19 1932 8192000000 10772488720 11164151808 1836126656 18.309 100 88 175 1 1873174096 12943456 24103984
20:07:28 1408 8192000000 10783763872 11165446144 1841198192 18.351 100 95 190 2 1882562672 14452416 26912064
20:07:36 2150 8192000000 10789841680 11178176512 1841871216 18.356 100 90 180 2 1881098672 13054864 26172592
20:07:45 1310 8192000000 10791787536 11179737088 1852149520 18.440 100 85 171 3 1887874704 11173520 24551664
20:07:52 2453 8192000000 10802922640 11193606144 1856330144 18.474 100 88 175 0 1893382832 11441200 25611488
20:08:01 1965 8192000000 10803288928 11194556416 1864175168 18.537 100 93 186 1 1902823136 12494752 26153216
20:08:10 1376 8192000000 10814877296 11203276800 1866595392 18.557 100 93 187 1 1906782144 13676416 26510336
20:08:18 1488 8192000000 10812735888 11202850816 1869262880 18.578 100 91 183 0 1909410016 14215936 25931200
20:08:26 1429 8192000000 10815124176 11204345856 1871022240 18.593 100 86 173 0 1907563616 12507296 24034080
20:08:34 15845 8192000000 10813013360 11210129408 1870374608 18.587 100 68 136 0 1900705344 10904112 19426624
20:08:57 14326 8192000000 10814313712 11210100736 1874303200 18.619 100 68 137 4 1904017104 11877264 17836640
20:09:17 24026 8192000000 10788326448 11208708096 1874906656 18.624 100 46 90 0 1896953280 9824432 12222192
20:09:49 9462 8192000000 10789999040 11208273920 1872506240 18.605 100 31 62 1 1888343344 6669744 9167360
20:10:05 5707 8192000000 10786678160 11213832192 1873856320 18.615 100 30 60 2 1891274496 8513904 8904272
20:10:18 5376 8192000000 10791088032 11215351808 1875193008 18.626 100 33 66 0 1893185040 8720688 9271344
20:10:31 8423 8192000000 10798079072 11220967424 1878081280 18.650 100 34 69 1 1899948832 12222736 9644816
20:10:47 6222 8192000000 10799016624 11221180416 1883175440 18.691 100 40 80 0 1904167936 8294048 12698448
20:10:59 8075 8192000000 10808428752 11221970944 1879411632 18.660 100 21 42 0 1891523824 6352864 5759328
20:11:14 6148 8192000000 10801853872 11227316224 1885056352 18.706 100 33 66 1 1901550448 7223056 9271040
20:11:29 6682 8192000000 10791755152 11224129536 1885960560 18.713 100 29 58 1 1900713264 6594848 8157856
20:11:47 11883 8192000000 10794845200 11227164672 1886546688 18.718 100 16 32 0 1897342416 6161552 4634176
20:12:07 18303 8192000000 10804666736 11236732928 1892346080 18.765 100 11 22 1 1901864736 5851552 3667104
20:12:31 15701 8192000000 10802033184 11237400576 1896259936 18.796 100 26 51 0 1909748288 6178464 7309888
20:12:53 9634 8192000000 10798586080 11236564992 1895708208 18.792 100 14 28 1 1904869328 5176720 3984400
20:13:10 17847 8192000000 10814620112 11248881664 1901836816 18.841 100 29 59 0 1916258576 5168448 9253312
20:14:17 20454 8192000000 10826387264 11261890560 1909757872 18.905 100 45 90 0 1930188032 7938944 12491216
20:14:43 6093 8192000000 10826156224 11258675200 1907724224 18.888 100 31 59 1 1924073440 6845616 9503600
20:14:57 6138 8192000000 10835795072 11265155072 1911705392 18.920 100 41 80 2 1929899360 6789904 11404064
20:15:11 8589 8192000000 10832785552 11264524288 1911473552 18.918 100 16 32 0 1921978832 5298496 5206784
20:15:26 5624 8192000000 10830373072 11268476928 1915050448 18.947 100 21 42 1 1927294432 6290288 5953696
20:15:37 4385 8192000000 10845793888 11277414400 1919378720 18.982 100 23 46 1 1931520768 5831712 6310336
20:15:50 5320 8192000000 10847554528 11277737984 1922730864 19.009 100 27 54 0 1935472352 5396736 7344752
20:16:02 4425 8192000000 10839995056 11273101312 1917998128 18.971 100 28 56 0 1933243072 7128400 8116544
20:16:13 8339 8192000000 10821331200 11258454016 1894149216 18.779 99 20 40 2 1906797328 6150928 6497184
20:16:30 7627 8192000000 10814124128 11248054272 1882869392 18.688 99 15 30 1 1892107264 4869952 4367920
20:16:45 6409 8192000000 10823183632 11259985920 1908123600 18.892 100 24 47 2 1922069008 6778896 7166512
20:16:59 12412 8192000000 10808297040 11247353856 1884080576 18.698 99 18 35 1 1894844192 5038464 5725152
20:17:19 8238 8192000000 10822248800 11256705024 1903640096 18.856 100 18 36 1 1914725808 6136016 4949696
20:17:36 16320 8192000000 10804697040 11242110976 1863506400 18.532 98 19 38 1 1875030704 6431600 5092704
20:18:00 67060 8192000000 10755424832 11183247360 1750303904 17.604 93 25 50 0 1762807232 5085728 7417600
20:19:14 10855 8192000000 10764824320 11198935040 1825634960 18.224 98 14 29 1 1834753760 5441936 3676864
20:19:31 6719 8192000000 10770375744 11178164224 1780353904 17.852 96 35 67 0 1796471120 7255856 8861360
20:19:46 3336 8192000000 10698121632 11118116864 1744593024 17.557 96 31 62 1 1760287152 6048592 9645536
20:19:55 7403 8192000000 10700579120 11110977536 1755949184 17.651 97 25 50 0 1769023264 5998304 7075776
20:20:10 5129 8192000000 10725077600 11140395008 1760607392 17.689 97 22 45 2 1772424224 5556096 6260736
20:20:23 5790 8192000000 10684773392 11101339648 1753651472 17.632 97 29 57 3 1768565168 6177008 8736688
20:20:35 5602 8192000000 10737435376 11144253440 1790877456 17.939 99 30 60 2 1809372672 9971904 8523312
20:20:48 6914 8192000000 10700083920 11111567360 1717763280 17.334 95 27 54 0 1731199456 5185840 8250336
20:21:01 8125 8192000000 10686174848 11106656256 1717756288 17.333 96 17 34 0 1727622208 4855824 5010096
20:21:15 7015 8192000000 10709247200 11115851776 1756865520 17.658 98 25 50 2 1774209648 10230160 7113968
20:21:28 4043 8192000000 10688903600 11103121408 1756701056 17.657 99 33 66 3 1776411392 9975696 9734640
20:21:38 5281 8192000000 10697983488 11106603008 1772819616 17.790 100 21 42 0 1784939312 5414880 6704816
20:21:53 9631 8192000000 10708235344 11118735360 1769949312 17.767 99 25 50 1 1783647856 5377472 8321072
20:22:09 7177 8192000000 10720668848 11139567616 1787247504 17.909 99 28 55 0 1801341120 5994752 8098864
20:22:24 10567 8192000000 10727782752 11142537216 1763204560 17.711 97 26 52 1 1776052368 5622816 7224992
20:22:43 14532 8192000000 10741872560 11160379392 1822051376 18.194 100 36 72 3 1837886048 5648528 10186144
20:23:05 64126 8192000000 10743382096 11173482496 1831866208 18.275 100 23 46 2 1844145216 5545184 6733824
20:24:17 11983 8192000000 10756286592 11188441088 1844728832 18.379 100 28 56 0 1859183648 6946560 7508256
20:24:35 3649 8192000000 10786568512 11201806336 1858248448 18.489 100 55 111 4 1881309408 7577632 15483328
20:24:46 5778 8192000000 10772518944 11196923904 1854169632 18.456 100 16 32 1 1864859968 6443040 4247296
20:25:00 7706 8192000000 10776303984 11201200128 1861335536 18.514 100 29 58 0 1875507776 5751904 8420336
20:25:14 4134 8192000000 10787771312 11208314880 1865788192 18.550 100 42 83 0 1885226320 6934800 12503328
20:25:28 5048 8192000000 10781177328 11206279168 1866583648 18.557 100 34 68 0 1883711360 7349360 9778352
20:25:41 5530 8192000000 10790229088 11209019392 1867365376 18.563 100 32 64 1 1882484848 5269344 9850128
20:25:52 5962 8192000000 10777500560 11208065024 1865097568 18.545 100 18 33 2 1875630128 4598416 5934144
20:26:07 13742 8192000000 10781806240 11214188544 1869355040 18.579 100 24 48 2 1886659648 10035424 7269184
20:26:26 13774 8192000000 10790823168 11222192128 1872179680 18.602 100 23 45 2 1884441792 5487488 6774624
20:26:46 8621 8192000000 10792602128 11221188608 1879345728 18.660 100 33 64 2 1894386592 5515904 9524960
20:27:05 8065 8192000000 10809000464 11235368960 1888541680 18.734 100 29 58 3 1902583952 5563408 8478864
20:27:25 33836 8192000000 10837044608 11256078336 1902207168 18.844 100 41 82 3 1924317440 10831584 11278688
20:28:06 24584 8192000000 10852625728 11270111232 1917198016 18.964 100 53 107 1 1941913232 9202928 15512288
20:28:39 33907 8192000000 10860916128 11281801216 1925451872 19.030 100 61 120 1 1953186240 10638224 17096144
20:29:21 25476 8192000000 10867874880 11293933568 1932603808 19.088 100 49 98 4 1960078768 13348976 14125984
20:29:54 83116 8192000000 10874797552 11303661568 1938309840 19.133 100 46 91 3 1964507744 12168720 14029184
20:31:42 57079 8192000000 10858075632 11310419968 1942481536 19.167 100 26 51 1 1963275888 13094688 7699664
20:33:02 16298 8192000000 10883285744 11321950208 1948699808 19.216 100 23 45 1 1970119568 14885872 6533888
20:33:29 15515 8192000000 10896559200 11331215360 1961702544 19.320 100 40 80 2 1991167904 17165568 12299792
20:33:55 28567 8192000000 10907008624 11347656704 1968545312 19.374 100 39 78 2 1998887520 18344800 11997408
20:34:40 15765 8192000000 10927637376 11356913664 1983436144 19.492 100 48 94 4 2017411296 19820032 14155120
20:35:03 10927 8192000000 10937348672 11369099264 1990117056 19.545 100 64 128 1 2030496512 21177632 19201824
20:35:22 5491 8192000000 10953887824 11378376704 1994407360 19.579 100 60 119 0 2036528208 24638816 17482032
20:35:45 9625 8192000000 10954932256 11384688640 1997669696 19.604 100 55 108 0 2041404672 27459136 16275840
20:36:03 5571 8192000000 10954533120 11375509504 1979422496 19.460 99 61 121 2 2026124752 27966432 18735824
20:36:18 10460 8192000000 10961155312 11389579264 2000578928 19.627 100 62 124 0 2048468144 28614944 19274272
20:36:37 15164 8192000000 10957159744 11391856640 2003321968 19.649 100 54 105 4 2048778544 29375440 16081136
20:36:59 2156 8192000000 10975288560 11391594496 2003074384 19.647 100 65 130 0 2052895248 30318272 19502592
20:37:08 10946 8192000000 10967754096 11398258688 2009839312 19.700 100 63 125 1 2061122720 31636000 19647408
20:37:27 12955 8192000000 10974113584 11408846848 2011528896 19.714 100 54 108 1 2060629712 32265280 16835536
20:37:48 16335 8192000000 10977247584 11413487616 2015646208 19.746 100 53 106 1 2067257536 34576160 17035168
20:38:14 5579 8192000000 10995840144 11425755136 2020678848 19.785 100 62 124 2 2076989600 36430304 19880448
20:38:29 9080 8192000000 10987119312 11421659136 2008304688 19.688 99 67 135 0 2064022592 35820256 19897648
20:38:51 10581 8192000000 11004934704 11428728832 2024569632 19.816 100 66 129 1 2079220688 34870608 19780448
20:39:09 2569 8192000000 10988440496 11409367040 2011088112 19.710 99 79 160 0 2065688928 30645920 23954896
20:39:18 6064 8192000000 10992998960 11419201536 2026578464 19.832 100 78 156 2 2081148304 31508192 23061648
20:39:32 1793 8192000000 11000999232 11428880384 2027573072 19.840 100 71 142 0 2082842256 33115936 22153248
20:39:41 4773 8192000000 11001327152 11432730624 2032144416 19.875 100 75 149 2 2088965792 34264752 22556624
20:39:54 3312 8192000000 11000458192 11430690816 2030302672 19.861 100 69 138 0 2085547424 33994544 21250208
20:40:06 2057 8192000000 10991033904 11420991488 2022323792 19.798 100 79 154 3 2078096048 33196496 22575760
20:40:16 2759 8192000000 11001950224 11425816576 2026616960 19.832 100 77 153 1 2085520736 35325392 23578384
20:40:27 3472 8192000000 11009844432 11435859968 2030308528 19.861 100 74 148 0 2090053072 36145824 23598720
20:40:39 3413 8192000000 11000820880 11422478336 2004702400 19.660 99 75 147 1 2064338352 36963184 22672768
20:40:50 4150 8192000000 10999641584 11420794880 2016618432 19.754 100 80 156 1 2079849792 39227664 24003696
20:41:02 4311 8192000000 11006300368 11430957056 2022349872 19.799 100 78 156 2 2087305312 40616816 24338624
20:41:13 3185 8192000000 11003203184 11425521664 2018217008 19.766 100 85 170 1 2085630160 41329776 26083376
20:41:24 1804 8192000000 11008266864 11426492416 2019702512 19.778 100 91 182 2 2091146080 41510176 29933392
20:41:35 4206 8192000000 11002889216 11421663232 2019260752 19.774 100 84 166 2 2080430272 35161984 26007536
20:41:46 1634 8192000000 10991977168 11407724544 2007583072 19.682 100 85 168 0 2069128064 35317760 26227232
20:41:56 3788 8192000000 10992250336 11416858624 2019879248 19.779 100 89 179 1 2084828112 37136176 27812688
20:42:10 2730 8192000000 10987872944 11412647936 2010986832 19.709 100 78 154 1 2071820448 37085936 23747680
20:42:21 8610 8192000000 10984948656 11409498112 2005071616 19.663 100 72 143 0 2067094288 39384016 22638656
20:42:38 1862 8192000000 10998892688 11421151232 2016451008 19.752 100 88 174 0 2083080112 39350384 27278720
20:42:47 2395 8192000000 10983905376 11402301440 1996444176 19.595 100 91 180 2 2066398608 41365136 28589296
20:42:56 3210 8192000000 10955648624 11366105088 1953839376 19.257 98 88 173 1 2021667392 40995088 26832928
20:43:08 1727 8192000000 10965665488 11382398976 1978657408 19.454 100 82 162 1 2043576128 39963104 24955616
20:43:17 4336 8192000000 10971444192 11388993536 1982883344 19.488 100 73 145 0 2045337808 39196400 23258064
20:43:33 5537 8192000000 10959819168 11379134464 1969344400 19.380 99 76 152 3 2034501088 41262512 23894176
20:43:47 3043 8192000000 10989506736 11410931712 2000434592 19.626 100 84 168 0 2069868176 43768720 25664864
20:43:59 4484 8192000000 10982758096 11393150976 1971475328 19.397 99 87 175 2 2046436016 47099408 27861280
20:44:12 4200 8192000000 10980128896 11396943872 1989857088 19.543 100 87 171 1 2061354656 44803792 26693776
20:44:24 2514 8192000000 10995535296 11409702912 1994252208 19.577 100 83 166 1 2067455952 47416272 25787472
20:44:34 1470 8192000000 10981010592 11392139264 1982612304 19.485 100 88 175 0 2058640416 48551456 27476656
20:44:45 1817 8192000000 10987491728 11398045696 1991556112 19.556 100 88 174 3 2066829824 47846944 27426768
20:44:53 2686 8192000000 10969151312 11379449856 1963094224 19.331 99 89 178 2 2037428640 45305744 29028672
20:45:02 4376 8192000000 10930462944 11361959936 1929509984 19.063 98 53 105 0 1991065872 43856112 17699776
20:45:16 4541 8192000000 10952172864 11371282432 1970834880 19.392 100 72 142 3 2035747008 42505696 22406432
20:45:29 2368 8192000000 10982610960 11394506752 1987007952 19.520 100 86 169 0 2058028176 44206576 26813648
20:45:38 4437 8192000000 10962199584 11377360896 1968528064 19.374 100 78 157 0 2041464944 48282944 24653936
20:45:49 3431 8192000000 10968959280 11384680448 1959933856 19.306 99 86 168 0 2035829296 49314976 26580464
20:45:59 1320 8192000000 10985060848 11390451712 1977421904 19.444 100 94 190 2 2058353488 51412896 29518688
20:46:07 2670 8192000000 10983790256 11398799360 1985140992 19.505 100 90 179 2 2066383024 53454096 27787936
20:46:17 6864 8192000000 10980084272 11395997696 1980305040 19.467 100 76 153 3 2062700752 58274608 24121104
20:46:33 7439 8192000000 10974981216 11409965056 1983107680 19.489 100 59 118 0 2062524096 59980864 19435552
20:46:51 11153 8192000000 10978928352 11416137728 1986962384 19.520 100 50 100 2 2062455664 58166624 17326656
20:47:34 8850 8192000000 10958613440 11409203200 1981628752 19.478 100 39 78 4 2042967472 47511392 13827328
20:47:53 19614 8192000000 10933052928 11387535360 1951629104 19.239 99 29 58 2 2007289264 45660704 9999456
20:48:20 10895 8192000000 10934186032 11389808640 1964420576 19.341 100 28 56 2 2020585760 46317152 9848032
20:48:44 10670 8192000000 10945314688 11389423616 1974830528 19.424 100 45 89 3 2029188576 40349024 14009024
20:49:08 22401 8192000000 10930894416 11389820928 1970529248 19.390 100 25 50 1 2014415296 35657264 8228784
20:49:37 14526 8192000000 10903765552 11356626944 1920940544 18.994 98 21 40 1 1966559232 38277952 7340736
20:50:00 45825 8192000000 10898876960 11364982784 1921206224 18.997 98 22 44 2 1971285968 42483232 7596512
20:50:52 20466 8192000000 10913762832 11362689024 1935387104 19.110 99 25 50 2 1986711184 42829424 8494656
20:51:21 10477 8192000000 10923175696 11372609536 1917279616 18.965 98 26 51 2 1975927520 49555072 9092832
20:51:43 38084 8192000000 10884113440 11345887232 1910422864 18.910 98 16 32 2 1955786576 40103824 5259888
20:53:04 17580 8192000000 10888839936 11351183360 1921456816 18.999 99 13 26 0 1961235648 35635904 4142928
20:53:30 11710 8192000000 10891325888 11348242432 1916114640 18.956 99 23 46 0 1960029024 36389152 7525232
20:53:53 9776 8192000000 10848285216 11294408704 1875149680 18.626 98 19 38 0 1905178928 23707632 6321616
20:54:13 13852 8192000000 10870220816 11313618944 1906860048 18.881 100 22 44 1 1937271504 23991488 6419968
20:54:37 63317 8192000000 10834073664 11311181824 1816795744 18.151 95 14 28 0 1849495696 28448032 4251920
20:55:47 79874 8192000000 10860249856 11314573312 1896514048 18.798 99 8 16 1 1916922416 18433520 1974848
20:57:26 53971 8192000000 10891256416 11331313664 1899722880 18.824 98 15 31 0 1916462720 13157664 3582176
20:58:35 39456 8192000000 10865038480 11316609024 1904873952 18.865 98 29 60 1 1923398720 10167552 8357216
20:59:21 69765 8192000000 10868500576 11320565760 1897703056 18.808 98 12 24 1 1916534352 15582512 3248784
21:00:44 131189 8192000000 10895236928 11363049472 1951393440 19.238 100 7 14 0 1966334272 13172592 1768240
21:03:03 78862 8192000000 10891823680 11351003136 1949635840 19.224 99 8 16 1 1963250096 11412736 2201520
21:04:45 70250 8192000000 10905824144 11356020736 1931623728 19.080 98 23 44 0 1949438480 11638080 6176672
21:06:08 42695 8192000000 10902540864 11369758720 1953386768 19.253 99 5 10 1 1964448400 9569968 1491664
21:07:19 120407 8192000000 10874432496 11338506240 1813440384 18.124 92 8 16 0 1833883120 18431008 2011728
21:09:25 72500 8192000000 10891966640 11347156992 1953433888 19.254 100 38 76 1 1978676144 14445552 10796704
21:10:55 67189 8192000000 10920672816 11381452800 1977353200 19.444 100 30 60 2 1995402080 8445696 9603184
21:12:16 70998 8192000000 10916435824 11392368640 1981168496 19.474 100 20 40 2 2006345104 19547552 5629056
21:13:36 6536 8192000000 10918807040 11393429504 1984176528 19.498 100 14 28 2 2006543440 18464896 3902016
21:13:48 10188 8192000000 10922195296 11384406016 1986032496 19.512 100 20 40 1 2010459296 19029328 5397472
21:14:11 1607 8192000000 10943071856 11396460544 2000386496 19.626 100 46 92 1 2027158224 13222928 13548800
21:14:23 15594 8192000000 10939711744 11398029312 1999315744 19.617 100 38 76 0 2024867664 14158560 11393360
21:14:46 19203 8192000000 10930512080 11397885952 1977516192 19.445 99 28 56 1 2007582784 21897424 8169168
21:15:12 54613 8192000000 10922578576 11400413184 1988534368 19.532 100 19 37 1 2009999120 15792672 5672080
21:16:29 23193 8192000000 10929648016 11380088832 1974310784 19.420 99 41 82 3 2004640240 17407680 12921776
21:17:01 28441 8192000000 10924937024 11382812672 1975076784 19.426 99 42 82 2 1995520688 8500656 11943248
21:17:37 23711 8192000000 10909989232 11383164928 1972648672 19.406 99 30 60 1 1993925920 13059056 8218192
21:18:07 56195 8192000000 10892366512 11374002176 1940271360 19.149 98 19 38 2 1959905248 14070432 5563456
21:19:12 17081 8192000000 10889349888 11368681472 1965585488 19.350 100 10 19 1 1980729072 12546256 2597328
21:19:36 22667 8192000000 10901036800 11375554560 1963571920 19.334 100 10 18 2 1978840288 12876496 2391872
21:20:11 22455 8192000000 10889678944 11373236224 1967872800 19.369 100 7 14 0 1978311104 8388624 2049680
21:20:51 70183 8192000000 10902359472 11371855872 1952973488 19.250 99 11 22 0 1964032784 7818640 3240656
21:22:16 94337 8192000000 10901094416 11381403648 1976792288 19.439 100 18 36 1 1996301344 13675376 5833680
21:23:56 48899 8192000000 10905740736 11387154432 1962848720 19.329 99 18 36 0 1980549008 12177536 5522752
21:25:00 11898 8192000000 10911619280 11375112192 1964655232 19.343 99 36 72 4 1987369024 12304880 10408912
21:25:18 30554 8192000000 10901566528 11371614208 1960762080 19.312 99 23 46 1 1980792736 13652768 6377888
21:26:11 84736 8192000000 10895712816 11377311744 1937917488 19.130 98 13 26 0 1960319360 18135632 4266240
21:28:29 46082 8192000000 10907982848 11377942528 1939912976 19.146 98 16 32 0 1952754464 8474448 4367040
21:29:26 57609 8192000000 10899863232 11377975296 1937855216 19.130 98 15 30 1 1956874832 14946048 4073568
21:30:30 33005 8192000000 10892904256 11365322752 1938505232 19.135 98 14 28 0 1958135872 15256128 4374512
21:31:09 35066 8192000000 10874164496 11336642560 1894702256 18.784 96 25 49 4 1911281232 9413024 7165952
21:32:03 23018 8192000000 10882339440 11348152320 1936749840 19.121 99 29 59 0 1957754320 11950400 9054080
21:32:37 37874 8192000000 10870028448 11336798208 1889575328 18.742 97 21 42 0 1903741008 8505584 5660096
21:33:22 61747 8192000000 10882788832 11338760192 1897851248 18.809 97 27 55 1 1915898320 9632656 8414416
21:34:32 42199 8192000000 10872239344 11331825664 1869297792 18.579 96 32 64 0 1888215424 10130240 8787392
21:35:29 61358 8192000000 10888035344 11350605824 1891866624 18.761 97 32 62 0 1912040832 11877072 8297136
21:36:39 34181 8192000000 10850388496 11305480192 1841030208 18.349 95 37 74 3 1861978624 10329376 10619040
21:37:30 14020 8192000000 10879037424 11324207104 1902707824 18.848 99 44 88 1 1925728416 10970688 12049904
21:37:50 41983 8192000000 10856736128 11321896960 1860964768 18.511 96 28 56 3 1880231824 11660656 7606400
21:38:39 54891 8192000000 10850060784 11324354560 1863215920 18.529 97 16 32 2 1886543232 18694496 4632816
21:39:40 32104 8192000000 10839026800 11290341376 1881733104 18.679 98 20 40 2 1895614112 8486720 5394288
21:41:17 34702 8192000000 10875385888 11339112448 1910174928 18.908 98 37 73 2 1934631456 14464096 9992432
21:42:05 115822 8192000000 10869419504 11337129984 1910038896 18.907 98 30 60 0 1928567616 10054160 8474560
21:44:21 101634 8192000000 10877972448 11362684928 1921542272 18.999 99 17 34 0 1943705488 17555328 4607888
21:46:10 21252 8192000000 10892348048 11341864960 1935963520 19.115 99 35 70 0 1957743568 11486352 10293696
21:46:40 66258 8192000000 10855807184 11335561216 1905200960 18.868 98 11 22 0 1919023456 10594032 3228464
21:48:24 76162 8192000000 10843895696 11330150400 1868111392 18.569 97 9 19 0 1884186240 13638592 2436256
21:49:49 59813 8192000000 10853832144 11332767744 1932262832 19.085 100 7 14 1 1941990944 7921648 1806464
21:50:56 68342 8192000000 10872397600 11349860352 1929018240 19.059 99 19 38 2 1945855392 11412736 5424416
21:52:10 55291 8192000000 10867742560 11358736384 1940605280 19.152 100 12 24 0 1962415488 18305280 3504928
21:53:12 37059 8192000000 10864030448 11350839296 1924479072 19.023 99 15 30 2 1945998496 16210272 5309152
21:53:58 28414 8192000000 10879149360 11342540800 1928664640 19.056 99 32 63 1 1947394384 9715776 9013968
21:54:33 40064 8192000000 10892905744 11358388224 1951401344 19.238 100 24 48 1 1970230880 12055808 6773728
21:55:25 50202 8192000000 10864066960 11343937536 1919015936 18.979 98 25 50 4 1937903488 12315888 6571664
21:56:22 55393 8192000000 10906322240 11372638208 1962071440 19.323 100 19 38 1 1978410064 11098240 5240384
21:57:29 69831 8192000000 10936072512 11405119488 1985676976 19.510 100 23 46 2 2005352208 13191296 6483936
21:58:45 106303 8192000000 10910731424 11405606912 1965701888 19.351 99 9 18 0 1989563136 21118032 2743216
22:01:45 45685 8192000000 10921515616 11386515456 1968916368 19.377 99 24 48 1 1984865616 8392928 7556320
22:02:40 9916 8192000000 10939642320 11395268608 1991931504 19.559 100 52 102 3 2012440032 6626992 13881536
22:03:01 29800 8192000000 10912131936 11380391936 1960275632 19.308 99 39 79 4 1984278432 12405552 11597248
22:04:17 107563 8192000000 10907646256 11392860160 1935098048 19.108 98 5 10 0 1954723696 18577248 1048400
22:06:10 84918 8192000000 10912348528 11378499584 1936237664 19.117 98 14 28 0 1956076992 15544480 4294848
22:07:44 84818 8192000000 10885775008 11341811712 1913945584 18.938 97 22 43 1 1933677440 13030432 6701424
22:09:19 88999 8192000000 10887719200 11340767232 1913441024 18.934 97 25 50 0 1928453712 7852848 7159840
22:11:04 6846 8192000000 10906253904 11363921920 1960611616 19.311 100 44 88 0 1982289152 9330704 12346832
22:11:17 39053 8192000000 10881458736 11341291520 1892565280 18.766 96 25 50 3 1909587824 9545136 7477408
22:12:33 55695 8192000000 10834741264 11308589056 1865397856 18.547 96 13 26 0 1877361120 8451056 3512208
22:13:46 51469 8192000000 10837270096 11320745984 1860921456 18.511 97 10 20 1 1873853808 10099040 2833312
22:14:46 54968 8192000000 10834968928 11292139520 1807780992 18.078 94 25 45 1 1818775360 5409248 5585120
22:15:47 48688 8192000000 10846694848 11315138560 1896150416 18.795 99 9 18 0 1904095712 5852160 2093136
22:16:42 83919 8192000000 10862587456 11338498048 1900665712 18.832 98 8 16 0 1908333072 6014976 1652384
22:18:15 66303 8192000000 10856925168 11335319552 1893404752 18.773 97 18 35 0 1909393904 10139600 5849552
22:20:09 70415 8192000000 10846964320 11326119936 1899053168 18.819 98 24 48 1 1917708240 11558560 7096512
22:21:26 77414 8192000000 10857676720 11331375104 1886167808 18.715 97 18 36 0 1901856896 10498640 5190448
22:22:57 53623 8192000000 10848704992 11332435968 1898404320 18.813 98 7 14 1 1912011600 11775824 1831456
22:23:59 43332 8192000000 10822195504 11287990272 1815683792 18.142 94 12 25 2 1827862048 8973008 3205248
22:24:48 59730 8192000000 10849768736 11322048512 1898907264 18.818 99 15 30 0 1911555680 8445776 4202640
22:25:54 42730 8192000000 10841967904 11310424064 1878387136 18.652 97 34 66 1 1896540736 8710576 9443024
22:26:50 25019 8192000000 9302607392 9575256064 445837520 5.161 24 6 12 0 449041488 1947280 1256688

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 26-12-2020 22:28:31 to 26-12-2020 22:29:02.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 119 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 26-12-2020 22:29:03 to 26-12-2020 22:29:05.

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          245090
MON$OLDEST_ACTIVE               245091
MON$OLDEST_SNAPSHOT             245091
MON$NEXT_TRANSACTION            245091
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                       2066016
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.33401 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33401 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33401 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33401 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 ---
--- end of diff output ---

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

26.12.20 22:29:06. 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-26 22:29:08 No severe PSQL-related problems occured
26.12.20 22:29:10. End of report.